Database Setup: Please confirm what gets sourced where? (mySQL)

[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)

[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:

main.sql
logs.sql
item_db.sql
item_db2.sql
mob_skill_db2.sql
mob_skill_db.sql
mob_db.sql
mob_db2.sql
item_db2.sql
item_db.sql
item_db_re.sql
convert_passwords.sql

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 April 19, 2012 by inkjetcanvas