Strav's blog

Well, I'm tired of investing a lot of time working on resolving some sort of sysadmin issue then either not documenting it or not being able to remember quite where it is documented. So, I finally got around to setting up blogging software so I can have someplace to store this sort of information.



Of course, even that was a challenge. When I installed b2evolution, it was erroring out with a mysql error - "Client does not support authentication protocol requested by server". I finally got around this by changing the password to the old password style and starting mysql with the --old-password option.



Prior to finding the solution stated above, I first tried to upgrade to mysql version 5.0. This was a total disaster! Initially, apt-get removed the 4.1 mysql files, installed the mysql 5.0 client files then aborted the update to mysql 5.0 server because the 5.0 server can't be installed if there are any ISAM tables. Of course, the program needed to update had been removed and now apt was completely confused. dpkg to the rescue - uninstall 5.0, reinstall 4.1, update the few ISAM tables to MyISAM using the mysql_upgrade command, then finally upgrade to 5.0. Unfortunately, Squirrelmail is not yet compatible with 5.0 so I had to downgrade. I ran into yet more issues here. apt let me downgrade with no issues, however Apache stopped interpreting the PHP pages. I had to manuall remove a number of php files as well as re-register php4_module with apache-modconf. Finally everything seems to be working again!