Jump to content
  • 0
Sign in to follow this  
xlaws27

new hercules error on loginlog

Question

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 by xlaws27

Share this post


Link to post
Share on other sites

5 answers to this question

Recommended Posts

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

 

sql%20error_zpsqlsphkxx.png

Edited by Hafflex

Share this post


Link to post
Share on other sites
  • 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:

 

sql%20error_zpsqlsphkxx.png

 

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

Share this post


Link to post
Share on other sites
  • 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 by Hafflex

Share this post


Link to post
Share on other sites
  • 0

Thank you Ridley, 

 

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

Edited by Hafflex

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.