Jump to content
  • 0

Server sql problem


Phalanx Des

Question

6 answers to this question

Recommended Posts


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

thnx netsrot.. oh by the way im a bayern munchin fan hehehheh

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  143
  • Reputation:   15
  • Joined:  12/25/13
  • Last Seen:  

Hello,

 

did u import/upload

 

main.sql files on your ragnarok database and grant privileges on it?

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  104
  • Reputation:   6
  • Joined:  01/23/14
  • Last Seen:  

So? the console already show you what the problem and from where the problem is.. what u w8ing for? go fix it~  /heh

 

Tips..

change the..

  • userid: s1 to username
  • passwd: p1 to password
 
File location "trunkk\conf"
  • char_athena.conf
  • map_athena.conf
 
MSQL "your server" Schemas\table\login
  1. right click it.. select row-limit 1000
  2. then change the s1 and p1 to username and password
  3. then apply the changes
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  6
  • Topics Per Day:  0.00
  • Content Count:  77
  • Reputation:   5
  • Joined:  12/05/12
  • Last Seen:  

LOL StainSky ^^

 

That problem is a bit earlier than the error you are thinking of. ^^

 

@Phalanx:

 

The problem is in your inter_athena.conf and your table `users` in database `mysql`. MySQL and / or Password do not match.

 

Here an example for inter_athena.conf:

// 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: yourservername
sql.db_password: yourpassword
sql.db_database: yourdatabase

// MySQL Character SQL server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: yourservername
char_server_pw: yourpassword
char_server_db: yourdatabase

// MySQL Map SQL Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: yourservername
map_server_pw: yourpassword
map_server_db: yourdatabase

// MySQL Log SQL Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: yourservername
log_db_pw: yourpassword
log_db_db: yourdatabase

// MySQL Mail SQL Server
mail_server_ip: 127.0.0.1
mail_server_port: 3306
mail_server_id: yourservername
mail_server_pw: yourpassword
mail_server_db: yourdatabase

and here an example for the sql-database:

 

mysqlsettings_zps27bdab1e.jpg

 

OR ^^ the MySQL-Server is not active ^^

Edited by Netsrot
Link to comment
Share on other sites


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

thnx guys ive solved it... woo.. its my first RO server online.. 

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  6
  • Topics Per Day:  0.00
  • Content Count:  77
  • Reputation:   5
  • Joined:  12/05/12
  • Last Seen:  

thnx guys ive solved it... woo.. its my first RO server online.. 

 

Good Luck with it :)

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