Lost database connection

[SMIFFAD]

Really annoying problem and ive come to the end of my whitts with it

I installed ZEN for a customer of mine ages ago, and his host has insisted he change his SQL database password as they were hacked recently

Should have been simple enough, passwords changed, i can log into the database using MYSQL with no problem, and an old install of OSCOMMERCE works fine. For some reason the ZEN cart simply will not connect to the database! Even installed a new instance of zen and that will work!!! but not the old one.

Ive updated the info in the

includes/config.php &
admin/includes/configer.php

Both are correct, and the only thing thats changed is the password, but no joy.

Is there something else odd about Zen that i have missed?

Any help greatly appreciated at this point!

Just incase ive missed something:

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'zen_');
define('DB_SERVER', '************);
define('DB_SERVER_USERNAME', '**********');
define('DB_SERVER_PASSWORD', '*************);
define('DB_DATABASE', '**************');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // use 'db' for best support, or '' for file-based storage

[dbltoe]

Does the database actually have a prefix of zen_?

[SMIFFAD]

Does the database actually have a prefix of zen_?

It does indeed... Its always been that, the only thing thats changed is the password for the database.

[dbltoe]

assuming that you meant includes/configure.php and admin/includes/configure.php there is little else that is common to both the admin and catalog as far as database is the password, username, database prefix, and database name. Other than that, I can't think of anything that would make both the cart and the admin inaccessible. They are both not working, correct?

[SMIFFAD]

assuming that you meant includes/configure.php and admin/includes/configure.php there is little else that is common to both the admin and catalog as far as database is the password, username, database prefix, and database name. Other than that, I can't think of anything that would make both the cart and the admin inaccessible. They are both not working, correct?

Interesting question.... the admin side IS working....

Least thats a start some more investigation required.....

[SMIFFAD]

I just cannot see any reason for it not working....

Admin sections working and picking up data,

Ive installed another zen cart - that picks up its tables (how ever it wont read the original zen data)

Ive Restored a recent backup of the sql database, just incase it had corrupted, still nothing.

[dbltoe]

different versions of mySql have different internal coding. Might want to google or search here for either Merlinpa or DrByte talking about compatibility. Could be that something in the database is locking up the cart and not the admin.

Still, it's a stab in the dark.

[SMIFFAD]

different versions of mySql have different internal coding. Might want to google or search here for either Merlinpa or DrByte talking about compatibility. Could be that something in the database is locking up the cart and not the admin.

Still, it's a stab in the dark.

Thanks for your help and suggestions dbltoe, its much appreciated

It seems to defy logic! Im going to blame the hosting company!

Ive come to a head with it now... it wants to die so ill let it! Good oppertunity to ditch the current host and start completly a-fresh! Just have to see what i can salvage from the sql backups i have

[paws4pets]

Had the same problem. I could log into admin but not my site. Once i changed my phpMYadmin passwords in the 'config.inc.php' file and logged on it worked. It may work for you.

[january]

Could be that the new PW is hashed under the new hashing algorithm used by the latest versions of MySQL, but that the webserver has an older version of MySQL Client API that can't handle the new hashing algorithm. I'm fighting with my employer's webhost over the same issue right now. The solution is to reset the DB PW to use the old-style hashing algorithm.

More info:
http://dev.mysql.com/doc/refman/5.0/en/old-client.html

Good luck!