UNABLE TO CONNECT TO DATABASE

[big_mac2007]

Help!

Ok, i have only noticed this problem since installing the "extra customer fields" contribution. not sure if it is related or weather i installed it wrong but the problem is this

 

1. On 2 seperate occassions, whilst accessing my main page the following message appears "unable to connect to database"

 

if i then try to log directly on to phpmyadmin, it says error #2003 Unable to connect to database server

 

If i keep trying to log on, eventually it will let me and then i am again able to access my main page.

 

I am not sure what may be causing this instability. Can anyone please help me with this.....

[FIMBLE]

Hiya,

What was the message exactly?

Nic

[big_mac2007]

Hiya,

What was the message exactly?

Nic

 

Hi Nic, thanks for the reply.Appreciate it. On the main page, was a single line that said "Unable to connect to database server" or "unable to connect to database'. I am sorry I cannot remember the exact words. However, from phpmyadmin, there was an error "#2003 - The server is not responding" or something similar. Its happened twice over this week and when it happens again i will post the exact words.

 

Regards

 

Angus

[FIMBLE]

Hi angus,

On your configure files, what have you for Database define?

If its not as below try setting it to localhost

define('DB_SERVER', 'localhost');

NIc

[big_mac2007]

Hi angus,

On your configure files, what have you for Database define?

If its not as below try setting it to localhost

define('DB_SERVER', 'localhost');

NIc

 

Hi nic,

 

Sorry for asking but can you please tell me which configuration file. I am still a newbie. I have checked catalog/admin/includes/configure.php and catalog/inculdes/configure.php but i cannot find "define('DB_SERVER', 'localhost');" anywhere there.

 

thanks

 

angus

[FIMBLE]

Hi

Thats the correct files

 

Near the bottom you should see define('DB_SERVER', ' ');

Instead of localhost you probably have an IP number then, try to change it to localhost.

 

Make sure you have a back up for quick re install in necessary though!

[big_mac2007]

Hi Nic, this is what i had below, possibly set it up wrong initially then, are the other settings correct?

 

 

define('DB_SERVER', 'mysql');

define('DB_SERVER_USERNAME', 'blah blah ');

define('DB_SERVER_PASSWORD', 'abra cadabra ');

define('DB_DATABASE', '_general');

define('USE_PCONNECT', 'false');

define('STORE_SESSIONS', 'mysql');

 

also, how do i know if i have set up my cookies configuration/settings correctly ?/