new hercules error on loginlog

[xlaws27]

hi i wanted to use the new hercules and tried to setup it by myself (cause theres no guide yet)

: DB error - Table 'hercules.loginlog' doesn't exist

i know the problem is the loginlog should be on the hercules database.

but i'm not sure if i should import the logs.sql + main.sql on 1 hercules database

i looked at conf/global/sqlconnection.conf

but there's no additional lines to put loginlog

my question is

1. should i put logs.sql and main sql in 1 database?

2. or is there a way to seperate them?

sql_connection: {
    // [INTER] You can specify the codepage to use in your mySQL tables here.
    // (Note that this feature requires MySQL 4.1+)
    //default_codepage: ""


    // [LOGIN] Is `userid` in account_db case sensitive?
    //case_sensitive: false


    // For IPs, ideally under linux, you want to use localhost instead of 127.0.0.1.
    // Under windows, you want to use 127.0.0.1.  If you see a message like
    // "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"
    // and you have localhost, switch it to 127.0.0.1
    db_hostname: "127.0.0.1"
    db_port: 3306
    db_username: "root"
    db_password: "ragnarok"
    db_database: "hercules"
    //codepage:""
}
 

 

[Hafflex]

Bump, I've been experiencing this issue as well.

I've tried changing to:

    db_username: "root"
    db_password: "ragnarok"
    db_database: "log" <----- from ragnarok

Still no luck, I've got those guide from rathena however, that trick isn't working for me.

Here:

 

[Legend]

Bump, I've been experiencing this issue as well.

I've tried changing to:

    db_username: "root"

    db_password: "ragnarok"

    db_database: "log" <----- from ragnarok

Still no luck, I've got those guide from rathena however, that trick isn't working for me.

Here:

Did you load your logs.sql to your database? This contains loginlog table

 

[Hafflex]

@Legend yes, I did import the logs.sql to my "log" database.

or should I import it to my main database which is "ragnarok" where the main.sql is loaded.

 

[Ridley]

Yes, either import to your main database or read this

https://github.com/HerculesWS/Hercules/blob/master/doc/global_configuration.txt

 

[Hafflex]

Thank you Ridley, 

The answer is: import logs.sql to your main ro database not to other database like before.