HUGE mySQL connection problems!

azhar

Can someone please help me, my website is expierencing major downtime.

I use a mySQL database to power power my website (http://www.dailydosemedia.net), but as you can see it's totally dead.

I don't know what's wrong but I do know that mySQL is up and running but I think the problem is in PHP. What I did was do an upgrade of PHP which went fine with the website running great but only restarted my server a little while ago, when since then it's been dead!

Does anybody know what's up?

My phpinfo() file can be found at http://www.dailydosemedia.net/locate.pl?phpinfo.phtml if someone needs to take a look at it.

Please help!

brandonschnell

what error does mysql_connect() return?

according to phpinfo(), php has mysql support so this might not just be an issue with php.

azhar

mysql_connect() returns absolutely nothing!

brandonschnell

then call "echo mysql_error();" to get the error that mysql_connect() returns.

plean

Hi,

I found another possible connection problem, under SuSE Linux:

PHP wants to use /tmp/mysql.sock, but MySQL usally uses /var/lib/nysql/mysql.sock

So just making a symlink with \"ls -s\" solved the problem.

Anon

when going to the site, this is the error that eventually showed up..
could php be breaking on that .dll?
just thought i'd throw that in.
-Si
error: -----
X-Powered-By: PHP/4.0.4pl1 Content-type: text/html Set-Cookie: PHPSESSID=9f012b8da86f4c3f59fbe46c14fa2c55; path=/ Expires: Thu, 19 Nov 1981 08:52:00 GMT Cache-Control: no-store,
no-cache, must-revalidate, post-check=0, pre-check=0 Pragma: no-cache Couldn't make connection.PHP Warning: Unable to load dynamic library

'C:\INETPUB\SCRIPTS\PHP\EXTENSIONS/php_gd.dll' - The specified module could not be found. in Unknown on line 0

aroderick

It seems like a syntax or installation problem. What OS and what webserver software are you using? Is this server local or remote? Does the error occur when the mysql_connect() is called? This is something hard to troubleshoot without more info. Have you tested php on another mysql host. If you need one to use email me directly and I can give you a hostname user and pass to use to test your php. Also, what syntax are you using to connect.

Adam

azhar

The operating system is Windows 2000 Advanced Server running ISS and is located locally. The syntax which I am using to connect is:

<pre>
$connection = mysql_connect("localhost","username","password") or die("Couldn't make connection.");
$db = mysql_select_db('db', $connection) or die("Couldn't select database");
$sql = "SELECT * FROM news ORDER BY ID desc";
$result = mysql_query($sql,$connection) or die("Couldn't execute query");
</pre>

But it seems to fail on connecting also I did try phpMyAdmin which gave me a simple 'Error, MySQL said:' and that's it. It looks like to that there is a PHP problem here.

Thanks for all your help.

Azhar.

melvyn

You can test if php can connect, by using the fsockopen call. Just to determin, if your mysql server, accepts these connections.

What does:
`mysqladmin processlist'

tell you?
Are there many connections open?

azhar

mysqladmin processlist gives me:

+----+------+-----------+----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+-----------+----+---------+------+-------+------------------+
| 1 | root | localhost | | Sleep | 5 | | |
| 7 | ODBC | localhost | | Query | 0 | | show processlist |
+----+------+-----------+----+---------+------+-------+------------------+

Can anyone see anythring wrong?

melvyn

Azhar wrote:

Can anyone see anythring wrong?

Could you try this testing script:

<body>
<UL>
<?
ini_set("display_errors", "Off");
$sp=fsockopen("localhost",3306,&$errno,&$errstr, 15);
if($sp)
{
$i=0;
$line=fgets($sp, 4096); // get the first line
// the second line returns the version number, but no new line. Fgets will lock your script!
$line=fread($sp, 12);
if(ereg("^{[0-9].[0-9]+.[0-9]+",} $line))
{
$version=ereg_replace("^{([0-9].[0-9]+.[0-9]+).*$",} "\1", $line);
}
fclose($sp);
echo "";
echo "<LI>Socket connection returned version: $version</LI>";
$cs=mysql_connect("localhost", "dummy");
if(!$cs)
{
echo "<LI>mysql connection returned error: <CODE>".$php_errormsg."</CODE></LI>";
}
else
{
echo "<LI>Connection on localhost succesful</LI>";
mysql_close($cs);
}
}
else
{
die("Are you sure mysql is running on port 3306?");
}
?>

</UL>
</body>

azhar

Thanks for all your help.

The error which I received after running this script was "Are you sure mysql is running on port 3306?", what can or have I to do now?

Thanks again for all your help!

melvyn

Azhar wrote:

The error which I received after running this script was "Are you sure mysql is running on port 3306?", what can or have I to do now?

Hmm, that either means, you can't create sockets (didn't enable socket support in php.ini) or you have mysql running on a different port or bound to an ip other than 127.0.0.1.

What does:
netstat -na

tell you? Anything listening on port 3306?
And especially '127.0.0.1:3306'.

There's no Unix-socket communication on windows, so it can't be looking for /var/tmp/mysql.sock or something obscure like that.

To rule that out, specify the mysql_default_* variables in your php.ini file, stop (not restart) iis and start it again after a few secs.

Since php is loaded as an ISAPI into IIS, you need to bring the server down, in order for the DLL (and subsequently the cached ini file) to be unloaded and re-read.

azhar

I have been looking around and MySQL is set and LISTENING on 127.0.0.1:3306. I have reinstalled PHP with no result, the problem has to be somewhere within PHP and not MySQL. How would I enable socket support in php.ini, I looked into it but couldn't work it out!

Thanks again for all your help!

melvyn

Well, we might just have stumbled upon something here.

For windows there's no need to set sockets - you can set the socket_method, down below, just before the end of the file.

But apparently, there's something missing on your system, that makes php unable to setup a TCP socket.

Can you do an fopen on an url? Like this:

$fp=fopen("http://www.php.net/", "r");
while(!feof($fp))
{
print fgets($fp, 4096);
}
fclose($fp);

You might consider reverting back to the older php version and file a bug-report.