Author: Dan LaSota

  • print.css

    When the WERC site went live a week or so ago it did not have a proper print.css file. With a reworked print stylesheet people can print pages without seeing mainly the menu and header divs. The content will fill up more of the paper and look better.

  • 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…