Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Error after updating DB_SERVER


yalan1220

Recommended Posts

I recently upgraded my database from mySQL 4.1 to 5.0. I kept the database name, username and password all the same. Only change is the server name. I updated this information in the includes/configure.php file

/*

OLD DB INFO

define('DB_SERVER', 'p41mysql127.secureserver.net');

define('DB_SERVER_USERNAME', 'ucsadmin');

define('DB_SERVER_PASSWORD', *****');

define('DB_DATABASE', 'ucsadmin');

define('USE_PCONNECT', 'false');

define('STORE_SESSIONS', 'mysql');

*/

define('DB_SERVER', 'p50mysql117.secureserver.net');

define('DB_SERVER_USERNAME', 'ucsadmin');

define('DB_SERVER_PASSWORD', '*****');

define('DB_DATABASE', 'ucsadmin');

define('USE_PCONNECT', 'false');

define('STORE_SESSIONS', 'mysql');

 

Now I am getting this error when accessing my admin page (http://segllc.net/UCSTest/catalog/admin/'>http://segllc.net/UCSTest/catalog/admin/):

 

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/s/e/g/segweb/html/UCSTest/catalog/admin/includes/functions/database.php on line 19

Unable to connect to database server!

 

And this error when accessing my online store (http://segllc.net/UCSTest/catalog/):

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ucsadmin'@'208.109.181.225' (using password: YES) in /home/content/s/e/g/segweb/html/UCSTest/catalog/includes/functions/database.php on line 19

Unable to connect to database server!

 

Please help!

Link to comment
Share on other sites

incorrect password to database

Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here!

8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself.

Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues.

Any issues with oscommerce, I am here to help you.

Link to comment
Share on other sites

incorrect password to database

Did you change both configure.php files (or all 4 if you also have them in includes/local directory).

 

Does the new db on the new server have ucsadmin as a user with all priveliges?

Link to comment
Share on other sites

Did you change both configure.php files (or all 4 if you also have them in includes/local directory).

A: Sorry, I did not realize that there were two configure.php file. Are these the two files?

#1 admin/includes/configure.php (just found)

#2 includes/configure.php (already updated)

 

I noticed that the several of the fields in file #1 are different from file #2. I could use some guidance on how to populate the fields because what I currently have in there is incorrect.

 

I was also informed that the ip address (208.109.181.225) in the error message correlates to the web server address, not the database address of (p50mysql117.secureserver.net), so it is most likely a configuration setting that I have missed.

 

Does the new db on the new server have ucsadmin as a user with all privileges?

A: I spoke to my hosting technical support and they informed me that all database users have read/write permission.

 

Thank you so much for your help.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...