Hmm.. This Seems Weird

[dpilon]

Hey, my SQLyog seems to be acting weird. When i first installed it, it ran great, connected, and ran as it should. Later on that day, i got error: 2003 it couldnt connect to localhost. I waited a bit, then tried turning off my firewall, then it worked again.. Turned my firewall back on and it still worked.. so figured whatever the error was had corrected itself. A day later (now) when i go to connect i get error code 2003 cannot connect to localhost.. again. Turning off the firewall doesnt help. Im using XP Home.. Any ideas?

Don

[peterlaursen]

1) You are sure that the server is running?

2) Which one is the firewall?

3) SQLyog, MySQL and Windows version please!! (though probably not very much relevant here!)

[dpilon]

Im running Mango's server emulator. Using SQLyog community edition 5.30, on microsoft windows xp home edition, using only windows firewall (which i tried turning off, as well as forwarding port 3306). I opened up the .err file in my sqlyog folder and this is what it said:

Code:

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2007-05-12 15:05:14
Line no.:12
Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2007-05-12 15:05:18
Line no.:12
Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2007-05-12 15:07:29
Line no.:12
Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2007-05-12 15:07:30
Line no.:12
Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2007-05-12 15:07:36
Line no.:12
Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2007-05-12 13:10:17
Line no.:12
Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2007-05-12 13:10:23
Line no.:12
Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist

Hope that helps.

[peterlaursen]

No, I am afraid it does not really help much!

We need a reproducable test case.  This error message is without valuefor us  if you do not explain how to reproduce it!  And I am not sure that this error mesage at all is related to the (connection) issue that you are reporting!  This error log was created when you were connected.  

Whend id you execute the statement “40103 SET TIME_ZONE='+00:00” with SQLyog.  did you import some script?  We do not know the mango server in detail.  And what is the MySQL version?  I think you may need to import the time zone descriptions, if they are not distributed with Mango.  But may depend on the server version.  And still I do not think this is related to the conection problem.

the timestamps in the log also is confusing.  they are not in logical/cronological order-  Still you may be able to tell from the timestamps what happend at taht particular time+

You can clear the error log in Notepad (select all and delete).  Or just rename the existing file and a new one will be created. Then the file will only have 'fresh' error messages in it.

[dpilon]

I cleared the error and tried to start SQLyog again, checked the .err file and it was blank.. so that must have been from before. Basically all my SQLyog program does is:

When i click on the shortcut on my desktop, brings up the GUI, i click connect.. and then I get this error ..

'Error no. 2003

Can't connect to MySQL server on localhost '

I don't know how else to explain my problem, I should be able to open and access/edit my sql database which i created and made in SQLyog before it started giving me this error. Im not tryin to connect to a server, im tryin to connect localy. Everything is being done on one computer.

Sorry if this isn't helping.

Don

[peterlaursen]

that sorted out one issue at least.  the error messages were not related to this connection issue.  probably you imported some script when you set up this game server?

Can't conenct to localhost.  That is pretty strange.

Please try some other client program, for instance

*mysql command lien client if it ships with this system (check the bin folder under the mysql server folder for the file 'mysql.exe'.  Start it from comman line like “mysql -uuser -p”.  Substitute user for the name of an existing user (= 'mango' ??)

* MySQL adminsistrator from http://dev.mysql.com –   Connection screen is much similar to SQLyog.

But this is a connection problem – not an authentication problem.  It is not user and password details that are wrong.  But the  system does not seem to realise that there is a server listening on port 3306!

Does the game script(s) connect OK?

Do you know if MySQL runs as a service when installed with mango?  And do you know the service name (check control panel .. administrative tools .. services)?  If it is running as a service try command line commands “net start mysql” and “net stop mysql” (substitute the service name with 'mysql' if it is different) You may also stop and start the service from Windows service manager itself.

the most weird thing is that you told that once you were able to connect!

[dpilon]

Yeh, it really does seem strange to me that it was able to connect fine, then all of a sudden it has this connection issue. My ports are all forwarded for 3306, so i can't see why that is a problem. One more thing, not sure if this is relevant to my connection issue, but it started happening after my power turned off and on due to a thunderstorm. My internet was working fine after, my system was completely fine. No corrupt files, I thought maybe sqlyog was messed up due to the power problem, but I get the same error (2003 cant connect to localhost) when i try to use navicat, or any other sql programs.

I am thinking about upgradeing to Vista. Vista has much better network settings so I am thinking this will solve my problem. Could my problem just be because I am using XP SP2?

To answer you question, before the connection issu, Mangos was able to access the database and run perfectly. Now it just cannot connect to my sql database.

[peterlaursen]

Ok the error messages in the error log were not related!

does the game script(s) connect OK?

can you connect with other clients (command line, mySQL administrator)?

do you know if MySQL as shipped with Mango runs as a service?

can you stop and start the service from Windows service manager or command line (net start servicename/net stop servicename) ?

It looks like the system does not realize that a server is listening on port 3306!

But weird that you reported that you connected once!

[dpilon]

-The game scripts don't connect now

-I can't connect using other clients

-Not sure about “do you know if MySQL as shipped with Mango runs as a service?”

-I can't start or stop the service in the command line.

EDIT: here are some pictures of the errors and mangos

[peterlaursen]

To me it looks like this Mango system and MySQL did not get installed correctly.

I would remove it and start from scratch.

I do not know the system but I know that other users are using SQLyog with it.

[dpilon]

ok, thanks for all your help. I've decided to reformat and install Vista. Vista has a more advanced networking setup than xp. I was never fond of xp anyways.

Thanks again. 🙂

Don

[Author]

Posts