OS X Lion Server to Mavericks OS X Server and mySQL
OK, I made the plunge last night and upgraded from OS X Lion Server on a mid-2011 Mac Mini to Mavericks and OS X Server 3.0.
It was a bit of a struggle getting my DNS zones properly re-configured after the upgrade. The "websites" service also sees and serves up my dozen or so virtual hosts. However the Apache configuration changed between Lion and Mountain Lion (and hence Mavericks) so don't bother looking in /etc/apache2/ for config files. They're now in /Library/Server/Web/Config/apache2/
This server is also running mySQL (5.5.17 MySQL Community Server (GPL)) which isn't the latest, but it's working. However, any web sites that use mySQL probably are throwing "cannot connect to the mySQL database". I installed phpMyAdmin to help debug my server, and I post this here hoping it will maybe save someone's bacon (or at least hours of debugging).
To get the proper connection for the WordPress (and Joomla 2.6) sites I host, I had to make one SIMPLE change from "localhost" to "127.0.0.1" in the wp-config.php (WordPress) and configuration.php (Joomla)
To get up and running again, in WordPress change your wp-config.php file from:
define('DB_HOST', 'localhost');
to:
define('DB_HOST', '127.0.0.1');
In Joomla, the line "public $host = 'localhost';" should change to: "public $host = '127.0.0.1';"
Hope this helps! —michael