Jump to content
  • 0

login-server_sql [SQL] and [DEBUG] messages


xtiand

Question


  • Group:  Members
  • Topic Count:  5
  • Topics Per Day:  0.00
  • Content Count:  24
  • Reputation:   0
  • Joined:  02/06/13
  • Last Seen:  

Hi,

 

I always get these messages in my login-server_sql window. How do I fix them?

 

Thanks! :)

 

ps. My server runs fine. I just want those messages not to appear.. 

post-14898-0-85716300-1361036334_thumb.jpg

Edited by xtiand
Link to comment
Share on other sites

4 answers to this question

Recommended Posts


  • Group:  Forum Moderator
  • Topic Count:  93
  • Topics Per Day:  0.02
  • Content Count:  10015
  • Reputation:   2348
  • Joined:  10/28/11
  • Last Seen:  

trunk/sql-files/logs.sql

load these into the SQL machine~

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  5
  • Topics Per Day:  0.00
  • Content Count:  24
  • Reputation:   0
  • Joined:  02/06/13
  • Last Seen:  

Thanks for the reply. :)

 

I already have my "log" schema and the tables in it, so I tried to delete it and and executed the script you gave, but I still get the messages..

 

EDIT:

 

I found this solution for anyone else who need it: http://rathena.org/board/topic/78618-sql-error-loginlog-and-picklog/?p=179199

Edited by xtiand
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  75
  • Topics Per Day:  0.02
  • Content Count:  2223
  • Reputation:   593
  • Joined:  10/26/11
  • Last Seen:  

trunk/conf/inter_athena.conf

// MySQL Log SQL Database

log_db_ip: 127.0.0.1

log_db_port: 3306

log_db_id: ragnarok

log_db_pw: ragnarok

log_db_db: ragnarok

log_codepage:

log_login_db: loginlog

Make sure you set log_db_db to the name of your "log" database.
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  5
  • Topics Per Day:  0.00
  • Content Count:  24
  • Reputation:   0
  • Joined:  02/06/13
  • Last Seen:  

I deleted the log tables in my ragnarok schema, and tried to do this, and it works!

 

Thanks, Brian and Emistry for the replies! :)

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...