Website down problems

[Andros]

One of my indexu websites seems to be down since yesterday and I am unable to figure out the problem. Note that the server is hosting other websites of mine and all seem to be fine except this one. Please see partial log file below: Any help would be appreciated!

Mon Sep 07 18:54:35 2009] [error] [client 66.249.71.146] PHP Fatal error: Call to a member function Fields() on a non-object in /home/euredco/public_html/lib/db.class.php on line 120
[Mon Sep 07 18:54:35 2009] [error] [client 66.249.71.146] PHP Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/euredco/public_html/lib/db.class.php on line 22
[Mon Sep 07 18:54:35 2009] [error] [client 66.249.71.146] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'euredco'@'localhost' (using password: YES) in /home/euredco/public_html/lib/db.class.php on line 20
It seems that this client's traces 66.249.71.146 are all over the error log file

[FSGDAG]

It would appear that your MySQL is having an issue.

[Mon Sep 07 18:54:35 2009] [error] [client 66.249.71.146] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'euredco'@'localhost' (using password: YES)

If your unable to connect to the MySQL DB, then thats probably the issue for the other errors too

[Andros]

Mysql seems to work fine. The problem is that the website is not always down, only at irregular intervals. I am not sure why mysql is down only at some times.

[dody]

If you are in shared hosting, perhaps other users have busy website. From my experience, busy website usually take mysql resource bigger than httpd. It may cause mysql down.

[FSGDAG]

Dody is right! If other sites being hosted on that server are eating up all of the MySQL connections allowed / processes... Your going to run into that problem.

Fortunately, this is never a problem with IndexU Hosting

[Andros]

Ok I do have my own dedicated server that hosts not more than 20 websites and some of the other websites are more demanding on mysql resources, so why only this website is down and only at irregular intervals?

[dody]

You should be more often to check how much resource eaten by mysqld. Perhaps you can use ps command in linux shell.

One of my friend running busy drupal site, around 20k unique visit per day. His server is quad xeon and 8gb ram. But he still have problem with mysqld.

I think FSGDAG (Frank) has better explaination since he is running webhost

[Andros]

Somehow database user got mispelled or changed not sure how. Now site is working fine. Thanks for support and suggestions.

[Andros]

No the problem is back.

[I]" Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'euredco'@'localhost' (using password: YES) in /home/euredco/public_html/lib/db.class.php on line 20

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/euredco/public_html/lib/db.class.php on line 22

Fatal error: Call to a member function Fields() on a non-object in /home/euredco/public_html/lib/db.class.php on line 120"[/I]

Every day I issue the query
grant all privileges on euredco_estate.* to 'euredco'@'localhost' identified by 'password_of_database_user';

Problem is fixed temporarily and next day, again same problem, website is not accessible giving me the error above

[FSGDAG]

Well, this pretty much confirms that its a server issue, rather than being an IndexU or script issue.

You should NEVER have to run the 'grant all privileges' query. Especially having to do it once a day.

Did you clone a site that was already created on your server?

[FSGDAG]

grant all privileges on euredco_estate.* to 'euredco'@'localhost' identified by 'password_of_database_user';

I just thought about something... Are you also running 'flush privileges' directly after that command? So it should look like this:

mysql> grant all privileges on euredco_estate.* to 'euredco'@'localhost' identified by '<password>';
mysql> flush privileges;
mysql> \q

[Andros]

Yes the site was cloned or changed using an existing site on the server.

[FSGDAG]

If your not doing the 'flush privileges' after the 'grant all' statement, then thats why your having to rerun the command every day. Let me know if that fixes it.

[Andros]

Hi FSGDAG, have tried it and did not work. Again the strangest thing is as soon as I access the database through mysql site is working again

[FSGDAG]

Not sure how much help I can be at this point without being able to see the server. My suggestion at this point:

- Export all the data to an SQL file
- Create a new database
- Import the SQL file into the new DB
- Edit /application.php to reflect new database information

That should clear up the issue - I hope!