Author: Dan LaSota
-
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…
-
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, or things that would actually affect the…