Jump to content
  • 0

Solved`how to setup separate sql database and rathena server? (HOST)


darkPirates

Question


  • Group:  Members
  • Topic Count:  4
  • Topics Per Day:  0.00
  • Content Count:  9
  • Reputation:   0
  • Joined:  06/20/12
  • Last Seen:  

how to setup separate sql database and rathena server?

is this the correct files that i need to re-cofig? or am missing something?

trunk/conf/char_athena.conf

nano trunk/conf/map_athena.conf

nano trunk/conf/inter_athena.conf

nano trunk/conf/subnet_athena.conf

inter.c

loginlogsql.c

map.c

..............................................

i cant connect to database :(

Edited by darkPirates
Link to comment
Share on other sites

7 answers to this question

Recommended Posts


  • Group:  Members
  • Topic Count:  28
  • Topics Per Day:  0.01
  • Content Count:  218
  • Reputation:   16
  • Joined:  01/24/12
  • Last Seen:  

I usually just make changes into the import folder. Why can't you connect to the SQL Database? Does it allow incoming connections? Is there a user set in the privileges of MySQL? Make sure that you have your IP under the MySQL user.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  4
  • Topics Per Day:  0.00
  • Content Count:  9
  • Reputation:   0
  • Joined:  06/20/12
  • Last Seen:  

you mean i don't need to touch the conf files?

trunk/conf/import

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  9
  • Topics Per Day:  0.00
  • Content Count:  44
  • Reputation:   5
  • Joined:  02/07/12
  • Last Seen:  

Are you trying to connect the rAthena from "A Computer" to "B Computer" which has the MySQL DB? I have a server set up like this. All I had to do is change the Local Host IP (127.0.0.1) to the WAN IP of "B Computer" at inter_athena.conf. That's all.

  • Upvote 1
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  4
  • Topics Per Day:  0.00
  • Content Count:  9
  • Reputation:   0
  • Joined:  06/20/12
  • Last Seen:  

vps hosting & website hosting..idol

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  6
  • Topics Per Day:  0.00
  • Content Count:  439
  • Reputation:   29
  • Joined:  12/08/11
  • Last Seen:  

Are you trying to connect the rAthena from "A Computer" to "B Computer" which has the MySQL DB? I have a server set up like this. All I had to do is change the Local Host IP (127.0.0.1) to the WAN IP of "B Computer" at inter_athena.conf. That's all.

This is it. This is what you need.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  4
  • Topics Per Day:  0.00
  • Content Count:  9
  • Reputation:   0
  • Joined:  06/20/12
  • Last Seen:  

i send a ticket to pen the port.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  9
  • Topics Per Day:  0.00
  • Content Count:  44
  • Reputation:   5
  • Joined:  02/07/12
  • Last Seen:  

Are your VPS and Webhosting from the same company? If yes; I think that you are allowed to connect.

Edited by Decimal
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...