I'm setting up a fresh install of rathena, moving over from eathena. I'm having some connection issues between my servers, which I'm wondering is part of my DB setup. I couldn't find anywhere in the wiki which specifies exactly how your DB should be structured.
I found a really old how-to somewhere which had me set up 2 DB's: ragnarok and login
1. Should I instead have everything in ragnarok?
2. What do I need to source from a fresh install from svn trunk? (ie, the files in sql-files)
Here's what triggered my question:
my start logs: (./athena-start start > start-logs.txt)
[info]: Connection request of the char-server 'rAthena -- myRO' @ 192.168.1.116:6121 (account: 'test', pass: 'test', ip: '127.0.0.1')
[Debug]: at loginlog_sql.c:75 - INSERT INTO `loginlog`(`time`,`ip`,`user`,`rcode`,`log`) VALUES (NOW(), '127.0.0.1', 'test', '100', 'charserver - rAthena -- [email protected]:6121')
[Debug]: at account_sql.c:528 - SELECT `account_id`,`userid`,`user_pass`,`sex`,`email`,`group_id`,`state`,`unban_time`,`expiration_time`,`logincount`,`lastlogin`,`last_ip`,`birthdate` FROM `login` WHERE `account_id` = 1
[Notice]: Unknown account (account: test, received pass: test, ip: 127.0.0.1)
[Notice]: Connection of the char-server 'rAthena -- myRO' REFUSED.
[info]: Closed connection from '127.0.0.1'.
[Warning]: Connection to Login Server lost.
I don't have a loginlog table in my database anywhere (there was one in the login table from eathena...). But I started fresh dropped my db's when I switched to rathena, and sourced the following into it:
Question
inkjetcanvas
Hi!
I'm setting up a fresh install of rathena, moving over from eathena. I'm having some connection issues between my servers, which I'm wondering is part of my DB setup. I couldn't find anywhere in the wiki which specifies exactly how your DB should be structured.
I found a really old how-to somewhere which had me set up 2 DB's: ragnarok and login
1. Should I instead have everything in ragnarok?
2. What do I need to source from a fresh install from svn trunk? (ie, the files in sql-files)
Here's what triggered my question:
my start logs: (./athena-start start > start-logs.txt)
I don't have a loginlog table in my database anywhere (there was one in the login table from eathena...). But I started fresh dropped my db's when I switched to rathena, and sourced the following into it:
If it helps: I am only setting up LAN right now for dev. I'm using Debian headless VM.
I couldn't find a wiki page specific to this part, and I'll be happy to make one once I get my own configs working.
Thanks!
Turned out I didn't update the first username/pass to test/test. I still can't connect to the server, but that's a different issue.
Edited by inkjetcanvasLink to comment
Share on other sites
0 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.