Jump to content
  • 0

My SQL


vindi

Question


  • Group:  Members
  • Topic Count:  21
  • Topics Per Day:  0.00
  • Content Count:  57
  • Reputation:   0
  • Joined:  12/22/11
  • Last Seen:  

eathena.jpg

how to remove this errors?

Link to comment
Share on other sites

10 answers to this question

Recommended Posts


  • Group:  Members
  • Topic Count:  50
  • Topics Per Day:  0.01
  • Content Count:  1702
  • Reputation:   238
  • Joined:  09/05/12
  • Last Seen:  

What error? /swt/hmm

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  182
  • Reputation:   36
  • Joined:  01/26/12
  • Last Seen:  

Check your jomar@localhost password (reset it if needed) and make sure that's the same user you'll be using for MySQL access in your conf/inter_athena.conf files.

 

These lines on that file:

// Global SQL settings
// overriden by local settings when the hostname is defined there
// (currently only the login-server reads/obeys these settings)
sql.db_hostname: 127.0.0.1
sql.db_port: 3306
sql.db_username: ragnarok
sql.db_password: ragnarok
sql.db_database: ragnarok
sql.codepage:

// MySQL Character SQL server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: ragnarok
char_server_pw: ragnarok
char_server_db: ragnarok

// MySQL Map SQL Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: ragnarok
map_server_pw: ragnarok
map_server_db: ragnarok

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

Edit them to your username and password of the MySQL user jomar@localhost, then try again.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  21
  • Topics Per Day:  0.00
  • Content Count:  57
  • Reputation:   0
  • Joined:  12/22/11
  • Last Seen:  

// Global SQL settings
// overriden by local settings when the hostname is defined there
// (currently only the login-server reads/obeys these settings)
sql.db_hostname: 127.0.0.1
sql.db_port: 3306
sql.db_username: jomar
sql.db_password: jomar
sql.db_database: ragnarok
sql.codepage:

// MySQL Character SQL server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: jomar
char_server_pw: jomar
char_server_db: ragnarok

// MySQL Map SQL Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: jomar
map_server_pw: jomar
map_server_db: ragnarok

// MySQL Log SQL Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: jomar
log_db_pw: jomar
log_db_db: log
log_codepage:

Ive edited it before and dont know why there are errors im using that password to my MYSQL admin and query, but when I log in im using the root username

 

 

eathena.jpg

how to remove this errors?

What error? /swt/hmm

the one with SQL and Debug thing how to fix it?

I dont have any errors or conflict when Im using rathena and a client 2012 04 10, but I dont like the new creating a character screen so I switch to another old client and SVN and thats what happening right now

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  81
  • Topics Per Day:  0.02
  • Content Count:  1654
  • Reputation:   583
  • Joined:  08/09/12
  • Last Seen:  

The new character creation screen isn't that bad, your char will be created with 1 for all stats, so actually it gives you more freedom.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  21
  • Topics Per Day:  0.00
  • Content Count:  57
  • Reputation:   0
  • Joined:  12/22/11
  • Last Seen:  

The new character creation screen isn't that bad, your char will be created with 1 for all stats, so actually it gives you more freedom.

I just like that old school character creation screen :)

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  81
  • Topics Per Day:  0.02
  • Content Count:  1654
  • Reputation:   583
  • Joined:  08/09/12
  • Last Seen:  

Ahh to bad..

Because I prefer functionality over design :P

 

Then, good luck :)

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  27
  • Topics Per Day:  0.01
  • Content Count:  120
  • Reputation:   3
  • Joined:  07/04/13
  • Last Seen:  

kailangan ng mysql administrator>>>useradministrator>>>i click mo ragnarok tapos i "<< ragnarok at logs ganun din sa logs!!

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  6
  • Topics Per Day:  0.00
  • Content Count:  116
  • Reputation:   4
  • Joined:  01/11/12
  • Last Seen:  

kailangan ng mysql administrator>>>useradministrator>>>i click mo ragnarok tapos i "<< ragnarok at logs ganun din sa logs!!

 

This is an English thread

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  27
  • Topics Per Day:  0.01
  • Content Count:  120
  • Reputation:   3
  • Joined:  07/04/13
  • Last Seen:  

hehe sorry!..

@drops all you need to do is click the mysql administrator>>usradministrator>>Click Shema privilages || click ragnarok then << click this do the same w/ log!!.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  6
  • Topics Per Day:  0.00
  • Content Count:  116
  • Reputation:   4
  • Joined:  01/11/12
  • Last Seen:  

try to log in to mysql using the username and password in your inter_athena.conf, if you successfully logged in, then user and pass is correct, then you can check this:

 

hehe sorry!..

@drops all you need to do is click the mysql administrator>>usradministrator>>Click Shema privilages || click ragnarok then << click this do the same w/ log!!.

 

Make sure the user jomar has privileges on your ragnarok database.

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