If this is your first visit, check our documentation. To post, register or login.
Forums / General Questions / Problem Connecting To Database

Problem Connecting To Database

Locked

Started by jeffnord on 4 Feb 2009, 9:17 PM · Views: 2,591

Results 1 to 9 of 9
This thread is locked. New replies are disabled.
4 Feb 2009, 9:17 PM
#1
jeffnord avatar

jeffnord

New Zenner

Join Date:
Apr 2005
Posts:
16
Plugin Contributions:
0

Problem Connecting To Database

We had trouble with our web hoster the other day and now our store won't work. I know our hoster lost emails and now I'm wondering if they messed up the store.

All I get when I try to go to the store is a page (nddbc.html) that says:
Sorry!
There seems to be a problem connecting to our database. Please give us a few minutes to remedy the problem. Thank you.

I can't seem to figure out why this is coming up and what the problem could be. I know I'm not an expert but I just can't find the problem and can't get the store back up.

Any ideas? Please, pretty please.

Thanks,

Jeff

4 Feb 2009, 9:21 PM
#2
haredo avatar

haredo

Totally Zenned

Join Date:
Apr 2006
Location:
Texas
Posts:
6,189
Plugin Contributions:
0

Re: Problem Connecting To Database

Jeff,
Did you check the two configure.php files

  1. includes/ configure.php
  2. admin/ includes/ configure.php

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.

Zen Cart Certified hosting at myZenCartHost.com.

4 Feb 2009, 9:56 PM
#3
jeffnord avatar

jeffnord

New Zenner

Join Date:
Apr 2005
Posts:
16
Plugin Contributions:
0

Re: Problem Connecting To Database

I did. And I didn't notice anything out of the ordinary. All the information seemed to be correct. I can go into cpanel and look at the database, so I know it's not corrupt. I just won't connect for some reason.

hardo, thanks for responding.

Jeff

4 Feb 2009, 10:08 PM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Problem Connecting To Database

jeffnord:

All I get when I try to go to the store is a page (nddbc.html) that says:
Sorry!
There seems to be a problem connecting to our database. Please give us a few minutes to remedy the problem. Thank you.
That appears when one or more of the following situations occurs:
a) database details in the /includes/configure.php file point to wrong database, or username, or password
b) attempts to connect to the database fail with an error
c) database is corrupt and needs repair

Perhaps someone changed your database password and/or username recently?
Maybe creating a new username+password and granting appropriate privileges to it, and setting that new username+password in your configure.php files might help?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

4 Feb 2009, 11:03 PM
#5
jeffnord avatar

jeffnord

New Zenner

Join Date:
Apr 2005
Posts:
16
Plugin Contributions:
0

Re: Problem Connecting To Database

DrByte:

Maybe creating a new username+password and granting appropriate privileges to it, and setting that new username+password in your configure.php files might help?I think that is a good idea. But I noticed in the configure.php file that the password seems to be encrypted. How would I enter a new password into the config file?

Thanks,
Jeff

4 Feb 2009, 11:05 PM
#6
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Problem Connecting To Database

The password in the configure.php file is not encrypted. It's plain-text, and must match exactly whatever password you've set for the database user you enter there.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

4 Feb 2009, 11:49 PM
#7
jeffnord avatar

jeffnord

New Zenner

Join Date:
Apr 2005
Posts:
16
Plugin Contributions:
0

Re: Problem Connecting To Database

Then that may be the problem! Because the pw looks like a bunch of junk.

I'll try it out and let you know.

Thanks,
Jeff

5 Feb 2009, 12:23 AM
#8
jeffnord avatar

jeffnord

New Zenner

Join Date:
Apr 2005
Posts:
16
Plugin Contributions:
0

Re: Problem Connecting To Database

DrByte, that seems to have done the trick. Thanks a bunch!

Jeff

28 Oct 2009, 9:48 PM
#9
newbie76 avatar

newbie76

Zen Follower

Join Date:
Aug 2009
Posts:
100
Plugin Contributions:
0

Re: Problem Connecting To Database

Thanks Dr Byte, had posted about this same thing a while ago (didn't find this post then) but changing pass and editing configure files seemed to do the trick