Jump to content
  • 0

error in login-server_sql (Database error)


Winz

Question


  • Group:  Members
  • Topic Count:  22
  • Topics Per Day:  0.00
  • Content Count:  1479
  • Reputation:   172
  • Joined:  12/14/11
  • Last Seen:  

Hi there, may someone tell me, why do I get this problem and how to fix it?

Untitled-3.png

I've set:

- char_athena.conf

- login_athena.conf

- inter_athena.conf

- map_athena.conf

their SQL information correctly and I can login, using the same credential, even from my house..

Thanks in advance. :)

Link to comment
Share on other sites

13 answers to this question

Recommended Posts


  • Group:  Members
  • Topic Count:  22
  • Topics Per Day:  0.00
  • Content Count:  1479
  • Reputation:   172
  • Joined:  12/14/11
  • Last Seen:  

I've did that.. and I'm triply sure that the data is correct..

Duarrr!!!

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  707
  • Reputation:   168
  • Joined:  01/26/12
  • Last Seen:  

Hi Winz,

Do you have your MySQL Database properly set up? Are you using the correct user/pass combination for your MySQL authentication?

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  22
  • Topics Per Day:  0.00
  • Content Count:  1479
  • Reputation:   172
  • Joined:  12/14/11
  • Last Seen:  

Hi, Asura

Yes, I have set it properly and I am using the correct user and pass on the configs..

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  707
  • Reputation:   168
  • Joined:  01/26/12
  • Last Seen:  

Hi Winz,

"their SQL information correctly and I can login, using the same credential, even from my house"

Are you running the MySQL server on the SAME EXACT computer that you are running the rAthena server?

Edited by Asura
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  22
  • Topics Per Day:  0.00
  • Content Count:  1479
  • Reputation:   172
  • Joined:  12/14/11
  • Last Seen:  

Hi Asura,

Yes, both of them are running on the same computer

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  47
  • Topics Per Day:  0.01
  • Content Count:  633
  • Reputation:   78
  • Joined:  11/14/11
  • Last Seen:  

can you try your root account in mysql? if does work i think the problem is the ragnarok account.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  22
  • Topics Per Day:  0.00
  • Content Count:  1479
  • Reputation:   172
  • Joined:  12/14/11
  • Last Seen:  

Using ID: root, result: not working..

I guess the login-server is not reading the inter_athena.conf..

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  707
  • Reputation:   168
  • Joined:  01/26/12
  • Last Seen:  

Hi Winz,

Did you compile rAthena correctly by including the mysql packages?

Source: http://rathena.org/w...g_Visual_Studio

Edited by Asura
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  22
  • Topics Per Day:  0.00
  • Content Count:  1479
  • Reputation:   172
  • Joined:  12/14/11
  • Last Seen:  

it's

./configure
make clean
make sql plugins

right?

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  707
  • Reputation:   168
  • Joined:  01/26/12
  • Last Seen:  

Hi Winz,

That's correct. Make sure when you perform './configure' it outputs the value 'yes' for mySQL.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  22
  • Topics Per Day:  0.00
  • Content Count:  1479
  • Reputation:   172
  • Joined:  12/14/11
  • Last Seen:  

Here is what I found on the console window:

checking for mysql_config... /usr/bin/mysql_config
checking for mysql_init in -lmysqlclient... yes
checking mysql.h usability... yes
checking mysql.h presence... yes
checking for mysql.h... yes
checking MySQL library (optional)... yes (5.1.41)

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  707
  • Reputation:   168
  • Joined:  01/26/12
  • Last Seen:  

Hi Winz,

Go to the file, '/etc/my.ini'; do you see anywhere mentioning 'bind-address'? Is it active or is it commented out? (commented out: '#bind-address:')

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  22
  • Topics Per Day:  0.00
  • Content Count:  1479
  • Reputation:   172
  • Joined:  12/14/11
  • Last Seen:  

Hi Asura,

ho oh, done that. (BTW, if I have not done that, how can I connect from my house?)

*Solved, I reinstalled the MySQL Database, PHPMyAdmin (Optional), and apache2 (optional). Then, I ran:

./configure
make clean
make txt
make sql plugins

Then, when I typed

./athena-start start

the login-server itself said

using account engine: 'sql'

Done! :)

Thanks for the willing to help, guys!

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