Connection problems

[rovinrambo]

Hi guys, I was 100% sure that i made all the userid and passwd the same but i've been getting these errors. I couldn't find where it comes from. Need ya help! 

Thanks!

[sikiro]

Check for typo or spaces as well as your ip if you are running a server locally sometimes using 127.0.0.1 may not work and might need to use your actual local ip on the machine.

[Cyro]

Error says cannot connect with server with given id password on port 3306

That means it is unable to Connect mysql server 

1.You either given wrong id password in confi

2. Or the given mysql user do not have privileges to connect the database 

[Felten]

make sure your mysql is active.

[Freya]

Hello, the username and password you've placed in your MySQL must be the id and password in your inter_athena.conf. Please try again.

[rovinrambo]

7 hours ago, Felten said:

make sure your mysql is active.

Hi how would i know if the mysql is active or nah?

 

7 hours ago, Freya said:

Hello, the username and password you've placed in your MySQL must be the id and password in your inter_athena.conf. Please try again.

I did but still giving me save problems

 

That's what i have in my inter_athena.conf right

[Felten]

Just now, rovinrambo said:

Hi how would i know if the mysql is active or nah?

What's your OS? Debian, Centos, Ubuntu...?

[rovinrambo]

I'm running it with centOS

[Freya]

Just now, rovinrambo said:

I did but still giving me save problems

Hello, okay, now check your userid and your passwd in two of the conf and make sure they are the same with your ragnarok login tables. Also, check if you MySQL username is not ragnarok instead it is root. 

[rovinrambo]

2 minutes ago, Freya said:

Hello, okay, now check your userid and your passwd in two of the conf and make sure they are the same with your ragnarok login tables. Also, check if you MySQL username is not ragnarok instead it is root. 

isn't the userid is the one the i've created on the command line? cause i remembered i've created a username along the mysql installation

[Freya]

4 minutes ago, rovinrambo said:

isn't the userid is the one the i've created on the command line? cause i remembered i've created a username along the mysql installation

Hello, okay, here. In your inter_athena that is where your MySQL username and password lies. You place them in there, however in char_athena and map_athena( or login_athena, I forgot) userid and passwd, that is your server's userid and passwd, your MySQL username and password is not the same with the userid and passwd of your server.
Place your MySQL username and password in your inter_athena.conf.
Place your userid and passwd in your ragnarok->login table if you do not remember something like this it should be
account_id = 1
userid = userid of char_athena and login_athena (again, I forgot)
passwd = passwd of char_athena and login_athena

Your username in your MySQL Installation that would be your inter_athena ID.

Edited May 1, 2017 by Freya

[rovinrambo]

7 hours ago, Freya said:

Hello, okay, here. In your login_athena that is where your MySQL username and password lies. You place them in there, however in char_athena and map_athena( or login_athena, I forgot) userid and passwd, that is your server's userid and passwd, your MySQL username and password is not the same with the userid and passwd of your server.
Place your MySQL username and password in your inter_athena.conf.
Place your userid and passwd in your ragnarok->login table if you do not remember something like this it should be
account_id = 1
userid = userid of char_athena and login_athena (again, I forgot)
passwd = passwd of char_athena and login_athena

I did this and it gave me error. The one the i was editing is from conf/import . Should i also change the conf outside of this folder?

 

7 hours ago, rovinrambo said:

I did this and it gave me error. The one the i was editing is from conf/import . Should i also change the conf outside of this folder?

hey bro , nevermind. it is up and running . what u said was right, i just forgot to save my works . Thanks!

[ragexe]

Hello i got same problem, how to fix it?