GRRR!!!!!Cant connect to MySQL server on 127.0.0.1

Experienced Elementalist
Joined
Feb 2, 2007
Messages
214
Reaction score
6
Location
Area 51
please help my char-server and map-server always has an error involving on the MySQL server cant connect...

how to configure it??

please give me a guide..
 
do into your inter_athena.conf and add the database user and pw of you mysqlserver
 
look so

/ MySQL Login SQL Server
login_server_ip: 127.0.0.1
login_server_port: 3306
login_server_id: ragnarok
login_server_pw: ragnarok
login_server_db: ragnarok

// MySQL Character SQL server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: ragnarok
char_server_pw: ragnarok
char_server_db: ragnarok

// MySQL Map SQL Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: ragnarok
map_server_pw: ragnarok
map_server_db: ragnarok

// MySQL Log SQL Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: ragnarok
log_db_pw: ragnarok
log_db: log
 
ow ok i get it.. umm there still an error in the char-server in the connection..

connection failed 127.0.0.1

buddy 1986 please reply
 
Last edited by a moderator:
1. Make sure you have the server running =D
2. Make sure you created the database and imported the SQL files into that database
3. Make sure you have a user on the mySQL which is allowed to modify the above database
4. Make sure you input the correct information into the inter_athena.conf
 
yo buddy sorry for the late reply.. i got only yahoo i got no msn... T_T

i got a new error

char-server

[error]can not connect to log in server
[error]this server communication password <default s1, p1> are probably invalid

[error]also, please make sure your log in db has the correct coounication username/password and the gender of the account is s

[error]the communication password are set in map_anthena.conf and char_athena.conf

please some one read this
 
Last edited by a moderator:
where can i find the s1 and p1 account??it in is the mysql?? i got the ragnarok database on the myqsl
and also the log db...

um my log db it only has:

atcommandlog

branchlog

chatlog

mvplog

npclog

piclog

zenylog
 
the logs don't matter.

the s1/p1 account is in the login table in the ragnarok database.

If you don't have it, run the following mySQL query in your ragnarok database:

Code:
INSERT INTO `login` (`account_id`, `userid`, `user_pass`, `sex`, `email`) VALUES ('1', 's1', 'p1', 'S','[email protected]');

just make sure you don't have another account with account_id 1. if you do, delete that account.
 
OHHHHHH YEEEEEAAAAHHHH IIIITTTTTSSSS WORKING!!!!!!!!!!


YEAH!!!! 2weeks of mind bugling from 10pm to 8am in the morning w/out sleeping.... I GOT THE SQL SERVER NOW RUNNING WOOOOOOOOOOO
 
Back