MySQL Database Problems

My friends have a little forum running here. The problem is that quite often we get the following message when we try to open the page: QUOTE Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/vhosts/rohit.bizhat.com/forums/db/mysql4.php on line 48 Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/vhosts/rohit.bizhat.com/forums/db/mysql4.php on line 330 Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/vhosts/rohit.bizhat.com/forums/db/mysql4.php on line 331 phpBB : Critical Error Could not connect to the database Why does this happen and what can we do to avoid it??

Comment/Reply (w/o sign-up)

Hey..

I've often had that problem.. most often than not .. its because of incomplete transfers of files due to lost packets while you FTP. As a solution to this, I do the following:

1. re-upload the concerned file causing the problem as dictated by the error message (preferably re-upload the entire folder)
2. Check all files for consistancy with the files on your local system. I do this using the Compare Directories function in LeechFTP although I do all my file transfers using WSFTP.
3. Check and recheck your config files to make sure you've got all the settings correct. Especially the settings that connect you to the DB.

Usually, these steps should get you up and running. if it doesn't, then you may have a problem with your DB.. To cure any problems with that.. I'd suggest you Backup the tables with user data, as well as post data and dump your entire DB, drop all tables in your DB, run the SQL file that came with your installation of bb. .. and then re-populate the tables as required with all the user and post data... (DO all this only if you feel you've exhausted all other solutions, and feel compitent to do it)

Hope this helped..

Rashid

 

 

 

Comment/Reply (w/o sign-up)

^Never heard that one.

As far as I was taught that means MySQL overloaded and is now broken, give it some time for the admin to reset it.

Comment/Reply (w/o sign-up)

when it has the error on a line like that it can be the script or permissions als. Did you get any other error messages?

Nils

Comment/Reply (w/o sign-up)

Maybe this will help
http://www.tech-recipes.com/mysql_tips762.html

From the looks of it, you need the help of a website admin to fix it

Comment/Reply (w/o sign-up)

This is a server side error which only the webserver admin can correct.

mySQL servers have limited connections capability as of version 3.x, the max user can be atmost 100 connections.. at mySQL version 4.x, the connection goes up to 500 - 1000 connections as far as the last release I have on my pc.

Connection limit is base on the maximum current connections the server can handle.

Most of the time, mySQL server can process each query at a microsecond speed but there arise the question why some webservers encounter the error above.

1. First is that when mySQL server is accessed on the internet, there are countless of visitor that can access the website at any given time giving way to hammering and filling up all the connection slots to the servers.

2. Shared webserver hostings with shared connection poll will also trigger this event since assuming that there are 100 hosted sites sharing the same mySQL server with the same connection limit. If all 100 websites have 1 visitor at the exact time and 1 new visitor visits the same site at the same exact time, one of them will get that socket error if the max connection limit is 100.

3. There are times that we make scripts that connect to the database that are malformed. Malformed since they lack the full cycle of connection to the server. The full cycle is

a) locate server
connect and open connection
c) process query
d) disconnect and close connections

sometimes, we forget the closing part or we have a database connection command that are unreachable to the scripts.

Unclose connections stayed up in the server. For us the connection is finished but for the server, it will dutifully waits for the the client softwares or programs to send their disconnect commands.

For every unclose connection, a connection slot is taken and on default installation, the autotimeout of the database sometimes is set to 45mins.


--------------

Hope i solve the problem, the best solution is to contact the server admin for some assistance since mostly the settings are beyond your control.

geez, this seems so long, maybe I should put this one as a tutorial

Comment/Reply (w/o sign-up)

It looks a problem in your code. You sould take a look there to fix it up.

The fist line is telling you that there is problem in your code avoiding that it appers in another words could not connect to the server.
2nd = second there is a wrong argument.
3rd = A political security from your forum phpBB

Comment/Reply (w/o sign-up)

im sorry but I do believe that you have a misconception about the problem. The real error is the socket can no longer accept the connection.

the next errors are the results of the 1st error.

since the socket cannot process the request made and the webserver cannot create a connection, then mysql4.php also cannot finish its connection routine thus it output the errors that it have invalid arguments.

in short, mysql4.php expects that it eithers get granted to access or be denied to the database.. since it cannot verify either of the two, it just output a generic error that there are some invalid arguments.. actually the one that output that are the webservers.

Comment/Reply (w/o sign-up)

what is it?
MySQL Database Problems

Warning: mysql_connect() [function.Mysql-connect]: Access denied for user (using password: YES) in z:\home\localhost\www\forum\db\mysql4.Php on line 48 Access denied for user '' (using password: YES) 

Comment/Reply (w/o sign-up)