Problem with connection

[Dazel]

[Error]: Can not connect to login-server.

[Error]: The server communication passwords (default s1/p1) are probably invalid. 

[Error]: Also, please make sure your login db has the correct communication username/passwords and the gender of the account is S.

[Error]: The communication passwords are set in map_athena.conf and char_athena.conf

 

i have sql, dedicated server, using WinSCP for db, and using PuTTy for system maneagmnet, the problem is that my server was running perfectly 1 hour ago, and now, im not sure of what i did, the Char, and Map athena have their default userid and pswd s1 p1 and i've already checked in my loging db, there is 

"s1 p1" and gender "S", dont know what's happending, thanks for your help.

[rans]

try to change it? 
and check also your inter_athena, Char-athena, Map-athena

[Dazel]

do i have to edit this in "inter_athena"

 

// Log Inter Connections, etc.?

log_inter: 1

 

could it be if i add an "s" to that "1" it will get solved? or isnt.

[DeadlySilence]

Have you set the option

use_MD5_passwords: yes

 

in conf/login_athena.conf?

If yes you have to make a hash of the user's password inside your database.

[Dazel]

a hash? excuse me, didnt understand your mean.

here's my hashtag..

Edited June 20, 2013 by kyyyyhh

[DeadlySilence]

By hash I mean the hash function (http://en.wikipedia.org/wiki/Hash_function)

 

Have a look at your login-table inside your database. If the password for your user is still plain text (e.g. p1 or whatever password you chose), execute this query:

UPDATE `login` SET `user_pass` = MD5(`user_pass`);

[Dazel]

thank you for your time, where can i execute that query?, i dont really know where commands are injected. can you explain me that please. im newbie in this.

[DeadlySilence]

Connect to your server with Putty and write

mysql -u your_user_name -p

 

and enter your password when prompted. (The same data you use in your config files)

You should now be connected to your database.

 

USE rathena_database_name 

 

(again, same database as specified in your config files)

 

Then use

SELECT `userid`, `user_pass` FROM `login`;

 

if the passwords do not look like someone smashed their head on the keyboard, write

UPDATE `login` SET `user_pass` = MD5(`user_pass`);

 

And write 

SELECT `userid`, `user_pass` FROM `login`;

 

to verify the passwords have been updated correctly.

[Dazel]

when i try to write "mysql -u your_user_name -p" this happens...

[DeadlySilence]

It seems you don't have access to the mysql binary.

How did you import the sql files (from trunk/sql-files) to create the database in the first place?

[Dazel]

im actually using 3 programs, PuTTy for SSH, WinSCP for editing tables and txts, and a web sql FTP to administrate accounts and stuff.

Edited June 20, 2013 by kyyyyhh

[DeadlySilence]

What kind of web SQL panel do you use? PHPMyAdmin?

If you log in to your web panel, you should be able to select the ragnarok database. Do so and search for some option that is called "SQL" or "Query". Execute this command there:

UPDATE `login` SET `user_pass` = MD5(`user_pass`);

[Dazel]

i contacted to my hosting support, they solved the problem thanks a lot!