Author Topic: MySQL issues after update to PHP 5.3.1 (Read 3646 times)

plugz · « **on:** November 27, 2009, 04:01:03 pm »

Following Khalem's suggestions on PHP update and using lastest main.php update, I now see a new set of errors

Quote

An Anarchy Online Chat Automaton

And

An Age of Conan Chat Automaton

v.0.6.5 - PHP 5.3.1

OS: Windows_NT

Your operating system is detected as 32bit

===================================================

Curl extension loaded

Warning: mysql_connect(): [2002] A connection attempt failed because the connect
ed party did not (trying to connect via tcp://localhost:3306) in Bot\Sources\MySQL.php on line 129

Warning: mysql_connect(): A connection attempt failed because the connected part
y did not properly respond after a period of time, or established connection fai
led because connected host has failed to respond.
in Bot\Sources\MySQL.php on line 129
MySQL ERROR(# 1) on query: Cannot connect to the database server at localhost as
user *!
A connection attempt failed because the connected party did not properly respond
after a period of time, or established connection failed because connected host
has failed to respond.

Yet, I have 3 other bots running on php 5.2 with no issues using cURL as well on the same machine

clashbot · « **Reply #1 on:** November 27, 2009, 04:38:05 pm »

did you move over the sql libraries to php_extensions folder?

Khalem · « **Reply #2 on:** November 28, 2009, 01:17:18 am »

Split this one out into its own topic.

How is your PHP installed? Is your bot using the correct php.ini and is the php.ini pointing to the 5.3.1 versions of the libraries? Does your MySQL server accept piped connections (iirc localhost => piped connection on Windows, but i could be mistaken)

Racheloblade · « **Reply #3 on:** April 21, 2010, 04:07:46 pm »

I get exactly the same msg (yes its exactly the same).
Im running bebot 0.6.7
php v5.3.2
mySQL v5.1.45 win 64
OS: win7 pro 64

I have tried so many things its turning my face blue.
I hope there is an awnser for this issue besides downgrading to php 5.2

Khalem · « **Reply #4 on:** April 21, 2010, 08:29:38 pm »

There is no reason the PHP upgrade should affect this unless it also altered your php.ini settings for MySQL.

I am personally running PHP 5.3.1/2/3 for testing locally with MySQL 5.1.x on Win 7 64bit without any issues.

The error indicates that traffic is being blocked/dropped or not routed.

Try changing the server address to 127.0.0.1 instead of localhost.