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

I’ve installed Movable Type including several upgrades, WordPress and several other CMS. I’m not great at MySQL but I usually manage to get through it.

Not MODx. MODx says, "Checking database:Could not connect to the mysql server." Hum? No idea why. I’ve searched through what documentation I could find.

MySQL - 4.1.22

Smittie

OK. I’ve spent a day trying to figure this out. A database exists on my MySQL setup. I do not have access to the logs insofar as I know nor can I find any useful feedback in discovering what the problem is.

→ Test database server connection and view collations.
Connecting to mysql server: Success!

Then

→ Create or test selection of your database.
Checking database:Could not connect to the mysql server.

Anyone want to sell me clue?

Smittie

1. Did you make sure the database name is correct? By default the installer places modx as the name of the database, but you might have named your database something different. In addition, some hosts add a prefix to the database name when you create it e.g. abc_modx, so make sure you’re putting the correct name there.

2. Make sure the user you specified in the first step has full privileges on your database.

From: http://modxcms.com/forums/index.php/topic,40188.0.html

3. If you’re posting about a bug, please state all of your Environment information in your post: Server OS, Server Version, PHP Version, MySQL Version (client and server), is pdo_mysql installed, your Browser type and version, and any other environment data we should know.

It will be difficult to pinpoint the problem without this information.

Quote from: Smittie at Feb 14, 2010, 04:59 PM

MySQL - 4.1.22

That’s an ancient MySQL version, and if MySQL is that old, I doubt your environment will support MODx Revolution, but feel free to provide more details and we can confirm or not.

Installed MovableType 5 without a hitch in less than 5 minutes. That’s too bad. I was interested in checking out MODx.

Smittie

Quote from: einsteinsboi at Feb 14, 2010, 09:13 PM

1. Did you make sure the database name is correct? By default the installer places modx as the name of the database, but you might have named your database something different. In addition, some hosts add a prefix to the database name when you create it e.g. abc_modx, so make sure you’re putting the correct name there.

2. Make sure the user you specified in the first step has full privileges on your database.

I assumed this was the error. So, I revisited the database several times to make sure the name and character sets matched. I’m very certain that they did at this point. Several times. The error message says that the problem is in connecting with the database server which would indicate that MODx never got far enough to trip over the database name.

Smittie

Quote from: splittingred at Feb 14, 2010, 10:39 PM

From: http://modxcms.com/forums/index.php/topic,40188.0.html

3. If you’re posting about a bug, please state all of your Environment information in your post: Server OS, Server Version, PHP Version, MySQL Version (client and server), is pdo_mysql installed, your Browser type and version, and any other environment data we should know.

It will be difficult to pinpoint the problem without this information.

I’m on a shared host. I’d love to provide all that information but I do not have easy access to it. Other CMS such as Movable Type provide a script that checks that information and reports on what you have running as well as anything that is missing or behind in version. When I installed MovableType 5, I got a complete report of everything that was installed. Would you like me to provide the information that MovableType gave me?

Smittie

Quote from: OpenGeek at Feb 15, 2010, 09:14 AM

Quote from: Smittie at Feb 14, 2010, 04:59 PM

MySQL - 4.1.22

That’s an ancient MySQL version, and if MySQL is that old, I doubt your environment will support MODx Revolution, but feel free to provide more details and we can confirm or not.

The environment requirements stated on the MODx web say 4.1.20 is what is required. Does that not include 4.1.22?

Smittie

Quote from: Smittie at Feb 15, 2010, 10:30 AM

I’m on a shared host. I’d love to provide all that information but I do not have easy access to it. Other CMS such as Movable Type provide a script that checks that information and reports on what you have running as well as anything that is missing or behind in version. When I installed MovableType 5, I got a complete report of everything that was installed. Would you like me to provide the information that MovableType gave me?

We at the very least need your PHP/MySQL versions, as well as if you have the pdo_mysql extension installed.

And if you’re on a shared host that’s running MySQL 4.1.22, you need to tell them to upgrade MySQL. That’s absurd to be running that ancient a MySQL version on a shared server on their part.