Jump to content

Can't connect Mysql...


Recommended Posts

I have " [40250] Reference Serverfile + Client + Src [15 Available Languages]" and can't connect to server.

Every attempt to connect to the server results in mysql shutdown. I attach syssers. I don't have the strength anymore, so please help me.

About a minute after turning on the server, my entire mysql shut down... It only works normally when the server is turned off.

AUTH:

Spoiler

SYSERR: May 12 17:29:33 :: socket_bind: bind: Address already in use
SYSERR: May 12 17:31:17 :: ChildLoop: AsyncSQL: query failed: Can't connect to MySQL server on '127.0.0.1' (61) (query: SELECT PASSWORD('123456789'),password,securitycode,social_id,id,status,availDt - NOW() > 0,UNIX_TIMESTAMP(silver_expire),UNIX_TIMESTAMP(gold_expire),UNIX_TIMESTAMP(safebox_expire),UNIX_TIMESTAMP(autoloot_expire),UNIX_TIMESTAMP(fish_mind_expire),UNIX_TIMESTAMP(marriage_fast_expire),UNIX_TIMESTAMP(money_drop_rate_expire),UNIX_TIMESTAMP(create_time) FROM account WHERE login='admin' errno: 2003)
SYSERR: May 12 17:31:17 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 12 17:31:17 :: ChildLoop: AsyncSQL: query failed: Can't connect to MySQL server on '127.0.0.1' (61) (query: SELECT PASSWORD('123456789'),password,securitycode,social_id,id,status,availDt - NOW() > 0,UNIX_TIMESTAMP(silver_expire),UNIX_TIMESTAMP(gold_expire),UNIX_TIMESTAMP(safebox_expire),UNIX_TIMESTAMP(autoloot_expire),UNIX_TIMESTAMP(fish_mind_expire),UNIX_TIMESTAMP(marriage_fast_expire),UNIX_TIMESTAMP(money_drop_rate_expire),UNIX_TIMESTAMP(create_time) FROM account WHERE login='admin' errno: 2003)
SYSERR: May 12 17:31:17 :: ChildLoop: AsyncSQL: retrying
 

DB:
 

Spoiler

SYSERR: May 12 18:08:06 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 12 18:08:06 :: ChildLoop: AsyncSQL: query failed: Can't connect to MySQL server on '127.0.0.1' (61) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2003)
SYSERR: May 12 18:08:06 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 12 18:08:06 :: ChildLoop: AsyncSQL: query failed: Can't connect to MySQL server on '127.0.0.1' (61) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2003)
SYSERR: May 12 18:08:06 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 12 18:08:06 :: ChildLoop: AsyncSQL: query failed: Can't connect to MySQL server on '127.0.0.1' (61) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2003)
SYSERR: May 12 18:08:06 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 12 18:08:06 :: ChildLoop: AsyncSQL: query failed: Can't connect to MySQL server on '127.0.0.1' (61) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2003)
SYSERR: May 12 18:08:06 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 12 18:08:06 :: ChildLoop: AsyncSQL: query failed: Can't connect to MySQL server on '127.0.0.1' (61) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2003)

Game 99:
 

Spoiler

SYSERR: May 12 17:50:20 :: socket_bind: bind: Address already in use
SYSERR: May 12 17:56:14 :: ChildLoop: MySQL connection was reconnected. querying locale set
SYSERR: May 12 17:56:14 :: QueryLocaleSet: cannot set locale latin1 by 'mysql_set_character_set', errno 2003 Can't connect to MySQL server on '127.0.0.1' (61)
SYSERR: May 12 17:56:14 :: ChildLoop: AsyncSQL: query failed: Can't connect to MySQL server on '127.0.0.1' (61) (query: SELECT word, score FROM spam_db WHERE type='SPAM' errno: 2003)
SYSERR: May 12 17:56:14 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 12 18:06:14 :: ChildLoop: AsyncSQL: query failed: Can't connect to MySQL server on '127.0.0.1' (61) (query: SELECT word, score FROM spam_db WHERE type='SPAM' errno: 2003)
SYSERR: May 12 18:06:14 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 12 18:06:14 :: ChildLoop: AsyncSQL: query failed: Can't connect to MySQL server on '127.0.0.1' (61) (query: SELECT word, score FROM spam_db WHERE type='SPAM' errno: 2003)
SYSERR: May 12 18:06:14 :: ChildLoop: AsyncSQL: retrying

 

Edited by bvjad
Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

Announcements



×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.