BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Age of Conan Archive => AoC 0.6 support => Topic started by: GBH on December 04, 2010, 01:29:26 pm

Title: MySql Issue
Post by: GBH on December 04, 2010, 01:29:26 pm
Hi,

I've had a working bot without any problems for ages. I've just completely re-installed everything including PHP and MySql only I'm getting the following error

Code: [Select]
Curl extension loaded

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

Warning: mysql_connect(): 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.
in H:\Bebot\Sources\MySQL.php on line 129
MySQL ERROR(# 1) on query: Cannot connect to the database server at localhost as user botuser!
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.

I can log into the database using EMS SQL Manager Lite using the "botuser" account and I have access for everything. I've rechecked and re-done my grant privileges to make sure I have full access to the DB. I can browse the DB without any limitation. The service is clearly running or I wouldn't be able to access it at all.

I've re-installed the DB twice and it's had no effect.

Anyone got any ideas why this is happening?

G
Title: Re: MySql Issue
Post by: GBH on December 04, 2010, 06:02:33 pm
OK figured it out (well technically someone in the guild did but I'm sure I'd have got there eventually ;))

In Windows 7 Hone Premium edition, 127.0.0.1 is not mapped to localhost in the /Windows/System32/Drivers/Etc hosts file. It's commented out and makes a note that it will be picked up by DNS. Uncommented it and bam, bot connected straight away.

What a crock of shit. Thats all I have to say on it.

Anyway all sorted and the bots back up.

G
SimplePortal 2.3.7 © 2008-2025, SimplePortal