Thread: Random database error !

Hi, I am using Dolphin 5.3 and my site works fine, well at least sometimes..

The problem is that I'm randomly getting a Database Activation Failed error throughout my site. One minute my site works just fine and another minute there is a red box on the screen that says Database Activation Error, not Database Access Error.
I did put a trap for mysql_error() to see what is causing the problem and it says "Access denied for nobody@localhost, using password = no.

I thought that maybe the script is not reading the username and password from header file so I have also trapped the db user and password variables to see if they are correct at the time of the error and they all seem fine too.

I did read about the maximum connected users and about changing pconnect to connect. I am not sure if this is causing the problem, since I am currently developing the site, so there are no other users than me. The max concurrent users allowed on my server is 30 and maximum connections is 650. During the error when I check the Active Persistent Links and Active Link on mysql server it shows only 2.

I have tried using connect instead of pconnect to be sure but the problem stays the same. One minute its working fine and then Error, and after some time its alright again.

Any help will be appriciated...
Thanks

Is your mysql server overloaded?

Smoge

Well the mysql server traffic as of today shows :

Traffic......................ø per hour
Received 3,631 MiB.....157 MiB
Sent 3,940 MiB...........171 MiB
Total 7,571 MiB..........328 MiB

Connections....................................... .ø per hour...........%
max. concurrent connections....370.........---....................---
Failed attempts......................9,157......396.98... ............4.07%
Aborted................................78......... .3.38...................0.03%
Total....................................225 k......9,754.76.............100.00%

There is only one db on the server and it is dolphin.

I had the same problem, i disabled IM and then it was ok.

and is the mysql server local - that is - on the same server as apache?

Smoge

It is hosted on hostforweb.

I understand - but on the same physical server?

The apache server does not connect to ANOTHER server running mysql?

Your HOST variable in header.inc.php is "localhost"?

Smoge

Originally Posted by Smoge

I understand - but on the same physical server?

The apache server does not connect to ANOTHER server running mysql?

Your HOST variable in header.inc.php is "localhost"?

Smoge

Oh, yes they are on the same server. Host variable is localhost.

Well - then something strange is going on... I don't have any other ideas to ask/tell you - I would need to look at the server/installation to fix it.

If this is something you are interested in - send me a PM.

Smoge

thanks for the help, I still don't know what was causing the error. I didn't change anything but somehow it seems to be working fine now.

I have asked the hostforweb support about the errors I have been getting and they have told me that they have been doing some changes on the dns of my server. Maybe that was the problem