BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Anarchy Online Archive => AO 0.6 support => Topic started by: plugz on November 27, 2009, 04:01:03 pm

Title: MySQL issues after update to PHP 5.3.1
Post by: 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

Title: Re: MySQL issues after update to PHP 5.3.1
Post by: clashbot on November 27, 2009, 04:38:05 pm

did you move over the sql libraries to php_extensions folder?

Title: Re: MySQL issues after update to PHP 5.3.1
Post by: Khalem 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)

Title: Re: MySQL issues after update to PHP 5.3.1
Post by: Racheloblade 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

Title: Re: MySQL issues after update to PHP 5.3.1
Post by: Khalem 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.