Unfortunately after whiping my rAthena server folder entirely, and re-installing via SVN (r17185)
I configure, compile and run after changing all listening servers to my LAN ip (debian OS, so they have to listen on that device or the router won't forward properly, here nor there)...
I now have this issue:
[SQL]: DB error - Unknown column 'pincode' in 'field list'
[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`,`character_slots`,`pincode`, `pincode_change` FROM `login` WHERE `account_id` = 1
[Notice]: Unknown account (account: ***, received pass: ***, ip: 192.168.1.20)
[Notice]: Connection of the char-server 'Moonlight_RO' REFUSED.
[Error]: Can not connect to login-server.
which makes perfect sense considering that all cridentials are being queried from sql in 1 string... and when 'pincode' as a column is not found... it throws out the entire statement, thus comparing user *** and pass *** to NULL and NULL (or w/e default value those variables hold)
Question is, why is it looking for this pincode column at all? If I go in and fix login.c to not ask for the pincode column, will there be other side effects? Is that even the proper solution?
***EDIT:
I resolved my own issue....
Running debian 6.0.6 (might be relevent)
I had been using the shell command:
cat main.sql | mysql -u root -p ragnarok
to populate my database, for whatever reason... it doesn't work well... when instead i used:
mysql -u root -p ragnarok < main.sql
it seemed to apply that rule... i don't know if there's much of a difference honestly... could have caught the svn update at a bad time... =\ it's working now though...
anyone with a similar issue, check your main.sql and search for 'pincode' ... if it's there, then it should work.