Checking database:Could not connect to the mysql server. What now?

Quote from: Jayster at Mar 11, 2010, 03:28 PM

After adding pdo_mysql.default_socket=/tmp/mysql.sock to your php.ini, make sure to restart Apache, and also clear your browser cache and cookies.

Modx seems to be storing some error messages in the session, and these seem to persist, even after the source of the error has been fixed.

Revo doesn’t store anything in session during setup, so not sure what you mean by this. You definitely have to restart Apache to get the PHP changes to take affect.

Not getting any love from my Beta 5 install

Env: Centos 5.4 with Zend Server CE (PHP 5.3.1), Apache 2.2.3, MySQL 5.0.77

• Checked all mysql socket settings in php.ini are correct
• Restarted Apache
• Checked DB creds and privs via command line
• Still getting rather useless "Checking database:Could not connect to the mysql server." error

Is there anywhere else I can check for error messages?

No other web apps have any issue whatsoever using mysql, mysqli and pdo_mysql.
Edit: Strike that, since upgrading to PHP 5.3.1, no PDO_MYSQL apps work.

I edited setup/processors/database/collation.php and added some debugging and found that the connection is failing whilst trying to connect to the information_schema database.

This is still confusing as I can connect and query this database via the command line using the supplied credentials.

Ok, finally getting somewhere...

You guys should seriously think about passing back some better error messages and never, and I mean never discarding exceptions.



I can’t find any config setting with the value of /tmp/mysql.sock so am going to start digging around the Centos and / or Zend Server forums.

Don’t spend too much time on it; that code has been rewritten since beta5.

I am getting this same error on my install. I am installing Revolution on Host Gator

Triple checked all my connection settings.

php version 5.2.10
apache version 2.2.13
mysql version 5.1.3

I’m excited to try this CMS.

I’ll try installing evolution and see if I have better luck.

I’ve identified my issue as a bug in PHP 5.3.1 - http://bugs.php.net/50829

Basically, unless your mysql socket file (mysql.sock) resides in or is symlinked (temporary solution) to /tmp, MODx Revo will not work with PHP 5.3.0 - 5.3.1.

If it’s an option, you should upgrade to PHP 5.3.2 ASAP.

FYI, a temporary fix is to specify "127.0.0.1" instead of "localhost" for the DB host name. This will force PDO to use a TCP connection instead of the local socket.

Revolution would not install on my hosting but Evolution installed on my server with no problems.

Quote from: ross259 at Mar 17, 2010, 12:30 AM

Revolution would not install on my hosting but Evolution installed on my server with no problems.

That pretty much confirms your PDO configuration is broken.

Quote from: OpenGeek at Mar 17, 2010, 08:48 AM

That pretty much confirms your PDO configuration is broken.

Or that you dont have access to the information_schema table, depending on what happened during install. Try SVN, or wait for RC1.