BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Age of Conan Archive => AoC 0.6 support => Topic started by: davidfury on October 21, 2009, 04:04:54 pm

Title: FIXED: Mysql connection failed
Post by: davidfury on October 21, 2009, 04:04:54 pm

i cant seem to connect the bebot, this is the messege i get:

Curl extension loaded

Warning: mysql_connect(): [2002] A connection attempt failed because the connect
ed party did not  (trying to connect via tcp://127.0.0.1:3306) in C:\Bebot\Sourc
es\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 C:\Bebot\Sources\MySQL.php on line 129

Fatal error: Call to a member function log() on a non-object in C:\Bebot\Sources
\MySQL.php on line 164
i really apreciate any help i can get.

please

Title: Re: Mysql connection failed
Post by: Getrix on October 21, 2009, 04:31:06 pm

And you are having a MySQL server installed on that machine with database and user?

Title: Re: Mysql connection failed
Post by: davidfury on October 21, 2009, 05:37:37 pm

yes, i have it installed, Mysql, 5.1.
i did it all according to the Bebot Wiki guide.

Title: Re: Mysql connection failed
Post by: clashbot on October 21, 2009, 05:42:40 pm

check you mysql conf file to make sure it is correct with the values that you used to create the DB

Title: Re: Mysql connection failed
Post by: Khalem on October 21, 2009, 09:15:33 pm

Check firewall settings as it could be blocking incoming traffic to your MySQL server.

Second, you could try using localhost instead of 127.0.0.1 for your MySQL server.

Title: Re: Mysql connection failed
Post by: davidfury on October 21, 2009, 10:09:57 pm

i tried, i used localhost instead, and yea i checked the file so many times, its all correct, and i have no firewall, i even port forwarded ports 3306 and 3307

Title: Re: Mysql connection failed
Post by: Getrix on October 22, 2009, 07:58:37 am

See if you could find "mysql-cli.exe" or "mysql.exe" (Not sure whats the name of that client file on Windows) in your MySQL bin folder.
execute that using "cmd" with:

Quote

mysql --user=user_name --password=your_password db_name

EDIT:
Found a installation on one of my computers.
The client name is "mysql.exe".
You could also try the files "mysqlcheck.exe" "mysqltest.exe" and see if anyone of them gives you a result that you can connect to your DB..

Title: Re: Mysql connection failed
Post by: davidfury on October 22, 2009, 05:50:28 pm

i get error access is denied for user Davidfury@localhost, using password=yes.
although I'm using the correct user and password.  :-[
I'm very very sorry to bother you guys, but I'm really trying hard to get this bebot working.
we really need it.
anymore help is really appreciated.

i even tried opening CMD as admin.

Title: Re: Mysql connection failed
Post by: snyder on October 23, 2009, 10:22:52 am

did you try with root username and password you put at instalation?

Title: Re: Mysql connection failed
Post by: davidfury on October 24, 2009, 06:51:42 pm

ok i fixed it, apearantly i had 2 Mysql running, the old one and the new, even though i removed the old one. but it was still in my registery files, so i removed them all from the registery, and installed the latest one again, and now its working.
=)
now i dont know if i should remove this post or keep it, i will leave this to an admin to decide, i was gonna remove it but i thought someone with the same problem might need it.
thanks alot for your help guys, i really apreciate it.
=)