Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

DB not connecting


Guest

Recommended Posts

Ok, I just changed my password for my db and the admin won't let me connect to it saying there is a problem on line 19 in database.php. But I don't see where the password is actually displayed for me to change it to the new one.

 

Anyone know how to do this? OPlease help :o

Link to comment
Share on other sites

the problem is actually in the configure.php files the catalog/includes/configure.php and admin/includes/configure.php this is the line where you change the password

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

in both files

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

Thank you 241. I tried that...didn't work. All I did from my host was change the password for mysql db and this is what it says when I try to connect to the osc admin panel:

 

Warning: Access denied for user: '[email protected]' (Using password: YES) in /*****/*/****/****/catalog/admin/includes/functions/database.php on line 19

 

Warning: MySQL Connection Failed: Access denied for user: '[email protected]' (Using password: YES) in /*****/*/****/****/catalog/admin/includes/functions/database.php on line 19

Unable to connect to database server!

Link to comment
Share on other sites

Ok, I dug alittle deeper now there is a new error msg:

 

1046 - No Database Selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

Link to comment
Share on other sites

CRAP ON A FROG!!!!!!!!!!!!!!!!!!!!!!! Now when I try to look at my catalog/index.php it gives me the same first error msg I had :( The admin works, but not the site :(

Link to comment
Share on other sites

this is more and more a database information in the two configure.php files issue the 1046 shows that the wrong database information is present along with the earlier message for the database password

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

Thanx 241....I just noticed that when i upload the catalog/includes/configure.php to the server it is changing my password to the old one. The admin/.../.../configure.php password is still the new one though. So very odd.

Link to comment
Share on other sites

Thanx 241 - You actually helped me to think for a second :P I had to change the chmod to be able to write to it, change the password, then switch the chmod back again :P I am a flippin goof ball :blink: :wacko:

Link to comment
Share on other sites

a good lesson for your frog to look in all directions before jumping the lilly pad :lol: :unsure:

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...