MySQL FILE Priv
This was a sticking point in for the WERC seminar reservation system. The database web bot / mysql user needs the FILE priv.
GRANT FILE on *.* to ‘werc_seminar_bot’@’localhost’;
A little LDAP research
I had opened a ticket a while back with OIT and eventually got a response from Daniel LaRoe. He suggested one way to get a listing of INE people via edir.alaska.edu and LDAP was to do an advanced search with this query:
(&(|(uid=*Northern Engineering*)(unitDirectoryHeadings=*Northern Engineering*)(unitAlias=*Northern Engineering*)(unitDisplayName=*Northern Engineering*))(|(ou=routing)(ou=resource)(ou=departments)))
This only produces two records, each which point to […]
MySQL 5.1.44
This new version is out. I looked at the release notes https://dev.mysql.com/doc/refman/5.1/en/news-5-1-44.html and determined that none of these issues immediately affect this work or the new WERC website. I am not going to bother with this upgrade until the final rollover to production server.
mysql 5.1.43 Done
Upgraded to 5.1.43.
mysql> select version();
+———————+
| version() |
+———————+
| 5.1.43-standard-log |
+———————+
1 row in set (0.00 sec)
./configure -prefix=/usr/local/mysql -with-server-suffix=-standard -enable-thread-safe-client -enable-local-infile -enable-shared -with-zlib-dir=bundled -with-big-tables -with-readline -with-plugins=all -without-docs –libexecdir=/usr/local/mysql/libexec/
Methane Videos
Videos located at https://www.alaska.edu/uaf/cem/ine/walter/videopage.xml
https://www.alaska.edu/uaf/cem/ine/walter/videopage2.xml were having a hard time loading on some computers. Videos were uploaded to YouTube and we do not have this problem anymore.
The text was also cleaned up on these pages and some emails were updated.
Accessing EDIR Data
Spoke with David Bantz and John Mitchell about getting a data feed for accessing Banner info to update pages like https://www.alaska.edu/uaf/cem/ine/directory/directory_alpha.xml
Will open another ticket requesting rpts ops$sxldap resources. The plan is to have shell access on some SQL machine, produce a data dump of INE people (for example), and then send a data file […]
MySQL 5.1.42
Configure Commands
CFLAGS=”-arch x86_64″
CXXFLAGS=”-arch x86_64″
./configure -prefix=/usr/local/mysql
-with-server-suffix=-standard
-enable-thread-safe-client
-enable-local-infile
-enable-shared
-with-zlib-dir=bundled
-with-big-tables
-with-readline
-with-plugins=all
-with-unix-socket-path=/tmp/mysql.sock
-without-docs
This prompted a more robust set of steps to test out MySQL updates:
Read Patch Notes, make sure it does not break anything, see if the update fixes unrelated bugs, […]
Style Sheet for Printing
I worked up a quick style sheet for print media (fancy way of saying printing), for this blog. Browser support for published standards of print style sheets is lacking at the moment, but most browsers support the “display:none” property. With this control, I can make certain elements of the page disappear.
When these pages […]