Map and Char Server Errors

[hatedigi]

Basically server isn't working. I have an error in map and char servers which isn't letting me connect to my server, (on this pc and my when my friend trys to connect). I have port forwarded. I have MySQL server and workbench. I have given myself schema privelages. I have added all those files to the query part of MySQL workbench. I have also attached a screenshot of the errors.

[v00m3r]

on the db error find this one..

go to your conf/inter_athena.conf

 // 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_db: ragnarok   <- change this to "log"
log_codepage:
log_login_db: loginlog

[Asura]

Hi hatedigi,

Please check if you have ran the 'logs.sql' for the database specified in your 'inter_athena.conf'

https://rathena.svn.sourceforge.net/svnroot/rathena/trunk/sql-files/logs.sql

[hatedigi]

I have executed the logs.sql file in MySQL Workbench. Attached are screenhots of my inter.conf and showing my log.sql executed in Workbench.

Edited May 1, 2012 by hatedigi

[Matrixfox]

I noticed in your inter_athena.conf you have the wrong log database, log_db_db: ragnarok needs to look like this log_db_db: log

Then please change sql.db_database: log back to sql.db_database: ragnarok

Edited May 1, 2012 by Matrixfox

[hatedigi]

Thanks that has fixed the log server issue. Still can't play though as the map and char servers still dont seem to connect and i have the same error on them as before.

EDIT: Have attached 3 screenshots. The first is of my MySQL Adminitrator status thing. The second is the Start Up/Shutdown section. When I click on it is says stopped, so when I press start it doesnt do anything but when I return to the first page thing it says what is shown on the last screenshot (Requires an active MySQL connection) or something like that. I highly suspect this is the cause of my problem but have no clue about what to do to fix it.

Edited May 1, 2012 by hatedigi

[Matrixfox]

What does your "char_athena.conf" and "map_athena.conf" look like?

Edited May 1, 2012 by Matrixfox

[hatedigi]

Here they are.

[Magnetix]

both IP setup on map_athena and char_athena should be like this:

char_athena

login_ip: LAN IP

char_ip: WAN IP or NO-IP DNS Service

map_athena

char_ip: LAN IP

map_ip: WAN IP or NO-IP DNS Service

[hatedigi]

Thanks Magnetix, seems to be working fine my end, will ask my friend to test soon and will get results back to you.

[Matrixfox]

Congrats!!! Feel free to keep posting if you run into anymore errors.