Jump to content
  • 0

Sql problem


AllHailToTheKing

Question


  • Group:  Members
  • Topic Count:  54
  • Topics Per Day:  0.01
  • Content Count:  235
  • Reputation:   0
  • Joined:  11/22/11
  • Last Seen:  

how to check if your SQL is working fine and it is recording everything? my SQL seems have a problem. not recording everything. like login and login logs.

Link to comment
Share on other sites

5 answers to this question

Recommended Posts


  • Group:  Members
  • Topic Count:  4
  • Topics Per Day:  0.00
  • Content Count:  68
  • Reputation:   13
  • Joined:  11/14/11
  • Last Seen:  

Are you using anything like eAmod, or harmony?

Since that might cause some problems on the SQL tables.
If yes, you should check the server console registers for any error (usually when you login).

 

Or when loading server, it might show some errors.

Just don't turn off the Warnings nor error messages on the conf files.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  54
  • Topics Per Day:  0.01
  • Content Count:  235
  • Reputation:   0
  • Joined:  11/22/11
  • Last Seen:  

Are you using anything like eAmod, or harmony?

Since that might cause some problems on the SQL tables.

If yes, you should check the server console registers for any error (usually when you login).

 

Or when loading server, it might show some errors.

Just don't turn off the Warnings nor error messages on the conf files.

 

 

hi the problem just show up now. cant run my server.

 

m[sql]
m: 
m[sql]
m: Can't connect to MySQL server on '211.*.*.*'' (113)
 
m[Debug]
m: at loginlog_sql.c:110
Can't connect to MySQL server on '211.*.*.*'' (113)
 
m[sql]
m: Can't connect to MySQL server on '211.*.*.*' (113)

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  4
  • Topics Per Day:  0.00
  • Content Count:  68
  • Reputation:   13
  • Joined:  11/14/11
  • Last Seen:  

Well, it's clear that your server can't connect to MySQL Server.

Do you host your SQL on different server?

Try using something like Navicat to try the connection, if you can login via navicat, then sure it's a configuration problem.

  • Upvote 2
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  54
  • Topics Per Day:  0.01
  • Content Count:  235
  • Reputation:   0
  • Joined:  11/22/11
  • Last Seen:  

Well, it's clear that your server can't connect to MySQL Server.

Do you host your SQL on different server?

Try using something like Navicat to try the connection, if you can login via navicat, then sure it's a configuration problem.

thank you miles its already fix. the data center had a power outage.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  4
  • Topics Per Day:  0.00
  • Content Count:  68
  • Reputation:   13
  • Joined:  11/14/11
  • Last Seen:  

Sure, no problem

i'm glad your problem was fixed.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...