new hercules error on loginlog

[xlaws27 3]

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:""
}
 

 

Edited September 25, 2016 by xlaws27

[Hafflex 0]

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:

 

Edited October 12, 2016 by Hafflex

[Legend 43]

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 0]

@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.

Edited October 13, 2016 by Hafflex

[Ridley 295]

Yes, either import to your main database or read this

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

[Hafflex 0]

Thank you Ridley, 

 

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

Edited October 13, 2016 by Hafflex