error in login-server_sql (Database error)

[Winz]

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

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.

[Winz]

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

Duarrr!!!

[Asura]

Hi Winz,

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

[Winz]

Hi, Asura

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

[Asura]

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 March 9, 2012 by Asura

[Winz]

Hi Asura,

Yes, both of them are running on the same computer

[JayPee]

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

[Winz]

Using ID: root, result: not working..

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

[Asura]

Hi Winz,

Did you compile rAthena correctly by including the mysql packages?

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

Edited March 9, 2012 by Asura

[Winz]

it's

./configure
make clean
make sql plugins

right?

[Asura]

Hi Winz,

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

[Winz]

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)

[Asura]

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:')

[Winz]

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!