[Guide] How to setup hercules

[cielthephantom]

@classy5 : you dont need to modifi inter -server.conf anymore in the lastest herc server.

btw , my hex-client don't show anything but it still running in task manager , any fix ?

 

[classy5]

@classy5 : you dont need to modifi inter -server.conf anymore in the lastest herc server.

btw , my hex-client don't show anything but it still running in task manager , any fix ?

i used the guide to sql_connections.conf that supposed to be for inter-server.conf (still testing)

 

[defsam]

EDIT:

skipped step 11 and done almost everything,

I am getting this though when I run the .bat file. Makes me think that I screwed up something in the files but I cant find where.

another edit: Hercules\conf\global\sql_connection.conf is screwing my stuff.

 

[coldmaster]

Also, having issues with step 11 Things are different now so I don't know how to do it

I'm getting this error

[SQL]: DB error - Table 'ragnarok.loginlog' doesn't exist
[Debug]: at ..\src\login\loginlog_sql.c:95 - INSERT INTO `loginlog`(`time`,`ip`,`user`,`rcode`,`log`) VALUES (NOW(), '0.0.0.0', 'login server', '100', 'login server started')

it points to the loginlog_sql.c, and tell me to edit the line, but I don't understand if I should do this or if there is a better way with a file in the conf/ also if I edit the c file I'm not really sure how it should look like.

Reading the forums people say to change this line on inter-server.conf

log_db_db: ragnarok


to 

log_db_db: log


But there is no such line on the inter-server.conf


I would really appreciate some help.

 

[caspe]

Also, having issues with step 11 Things are different now so I don't know how to do it

I'm getting this error

[SQL]: DB error - Table 'ragnarok.loginlog' doesn't exist
[Debug]: at ..\src\login\loginlog_sql.c:95 - INSERT INTO `loginlog`(`time`,`ip`,`user`,`rcode`,`log`) VALUES (NOW(), '0.0.0.0', 'login server', '100', 'login server started')

it points to the loginlog_sql.c, and tell me to edit the line, but I don't understand if I should do this or if there is a better way with a file in the conf/ also if I edit the c file I'm not really sure how it should look like.

Reading the forums people say to change this line on inter-server.conf

log_db_db: ragnarok


to 

log_db_db: log


But there is no such line on the inter-server.conf

I would really appreciate some help.

Well config file format has been changed, in folder global/sql_connection.conf u can set database name and specific id pass. and try with extracting log tables in same database as main database.

 

[coldmaster]

Hey @caspe Thanks!!

It's working after I extracted the log into the "ragnarok" database, is this because I did some setup wrong or it's now by default?they should be in the same database?

I tried setting up "log" into the sql_connection.conf  but couldn't make it work so I left it as "ragnarok"
 

db_hostname: "localhost"
db_port: 3306
db_username: "ragnarok"
db_password: "Pass"
db_database: "ragnarok"



Well, it's working just not sure if I missed something.

 

[caspe]

I think there is no way to create separate database for log now.

 

[coldmaster]

Ok thanks for making that clear

After some testing, I learned a better way to do this.
open Hercules\conf\import\inter-server.conf

and edit the following into it:

inter_configuration: {
// See conf/common/inter-server.conf
log: {
sql_connection: {
db_hostname: "127.0.0.1"
db_port: 3306
db_username: "ragnarok"
db_password: "MyPassword"
db_database: "log"
}
}
}


now, you can create a "log" database and keep things more organized.
better than having everything inside "ragnarok"!!

 

[skenywitdafer]

I have lots of issues in sql...its sql updates just like that

 

[DreamingGal]

Hi I have MySQL Workbench 6.3.10 and because it's different I am stuck on 21.

I found a + button that creates a new connection but there isn't much that resembles a New Server Instance button

Do I press the Configure Server Management button? If so I get stuck with the Path to Configuration File location. The path in the image gives me an error: couldn't find section [mysqld] in the config file.

Any help would be greatly appreciated.