[Guide] How to setup hercules

hi there ^^, can you heLp me with this?? i don`t know what i need to DL here 1st >.< i can`t see svn files to be DL!

 
QUESTION : What MySQL Workbench version did you use.. i install 6.1 and i'm lost.. please help.. thanks in advance

 
lost in patskie's tutorial.. because i'm using 6.1 version.. and i don't know what version did he use in this tutorial
default_smile.png


 
I used MySQL 5.6 + workbench 6.1 prior changed it to MariaDB.

The graphical interface is different but that shouldn't be a problem.

After you installed Workbench you should have a connection named "root", it can be seen in first interface.

You can open it by double clicking it, then you can make "hercules" & "log" schema, and follow the rest of the guide.

 
sound like your server failed to connect to mysql database.

Check these :

1. Patskie's step 2-4 :

  in confchar-server.conf :

// Server Communication username and password.
userid: patskie
passwd: patskie

in confmap-server.conf :

// Interserver communication passwords, set in account.txt (or equiv.)
userid: patskie
passwd: patskie

Those userid & password must be match with the one in login database

(Patskie's step 31, you should change s1 & p1 to whatever in your char-server.conf & map-server.conf)

2.  from Patskie's step 11 :

// Global SQL settings
// overriden by local settings when the hostname is defined there
// (currently only the login-server reads/obeys these settings)
sql.db_hostname: 127.0.0.1
sql.db_port: 3306
sql.db_username: root
sql.db_password: ragnarok
sql.db_database: hercules
sql.codepage:


// MySQL Character SQL server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: root
char_server_pw: ragnarok
char_server_db: hercules


// MySQL Map SQL Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: root
map_server_pw: ragnarok
map_server_db: hercules


// MySQL Log SQL Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: root
log_db_pw: ragnarok
log_db_db: log
log_codepage:
log_login_db: loginlog

make sure in MySQL Workbench you have user with same name and password with those part from your confinter-server.conf (which written in bold)

 
can somebody help me?i followed everything this tutorial tells..but im using workbench 6.1 and i used the hercules 10 with the microsoft visual 2010..
help.jpg


 
31. Execute the following code 

SELECT * FROM login;

32. Change userid, user_pass to the credentials you have put on both char-server and map-server.conf

33. Click apply.

i think i dont get this..

 
You are doing some mistake when creating database, your database are not created.

This is copied from patskie guide above (I add some hint for workbench 6.1 in bold note):

9. Open mysql workbench

20. Add user and password into it. Follow this guide. Make sure you set username as root and password as ragnarok because this is the credentials located on your conf/inter-server.conf

21. Create a server instance and connection. Just click New Connection for creating connection and click New Server Instance for creating a new server instance everything there are self explanatory
Note : This is in the first interface (interface with mostly black color), usually you have root connection by default, you can use it.

22. More likely you must have the following : (different interface)

23. At the left portion of the application.
Note : at left bottom of the application, usually with mysql, information_schema, performance_schema, test (if you install sample and example will have Sakila and World as addition).
You can see schemas.
Right click on one of them (test schema) and click on create schema

24. Set the name of the schema to hercules because that is the credential we put in our inter-server

25. Create also a schema log

26. Double click hercules schema
Note : make sure hercules schema in bold

27. Under file located at the bottom of the home button ( upper left to be exact ) click Open SQL Script and locate sql script on sql-files/main.sql,
open it and execute ( you can find execute button at the upper portion
of the text editor of mysql workbench it looks like a thunder xD )
Note : button position can be different, but they have same name.
NB : At this point you should have all table needed in hercules schema, check it in mysql data directory (hercules folder). It should have some file with frm, MYD, MYI extension

28. Double click log schema
Note : make sure log schema in bold

29. Under file located at the bottom of the home button ( upper left to be exact ) click Open SQL Script and locate sql script on sql-files/logs.sql,
open it and execute ( you can find execute button at the upper portion
of the text editor of mysql workbench it looks like a thunder xD )
Note : Same way with step 27
NB : At this point you should have all table needed in log schema, check it in mysql data directory (log folder).

30. Once everything is set double click again hercules schema

31. Execute the following code

SELECT * FROM login;

32. Change userid, user_pass to the credentials you have put on both char-server and map-server.conf

33. Click apply.

I hope this can help.

 
Last edited by a moderator:
I followed all the steps carefully, but still no luck..

Problems:

1. under MVS2010 got 2 failed,2 succeded. (attached below)

failed.png

2 Starting the server. (see attached photos)

server failed.png

Note: Im using Worckbench 5.2

 
Last edited by a moderator:
I could use some assistance.

Upon attempting step 31 of the tutorial, this happened: Error Code: 1146. Table "hercules.login" doesn't exist
   


H6EJDRc.jpg
I'm guessing that I did something wrong either when editing the .conf files, or perhaps I don't have the user set to the right name... I tried messing around with it for a while, only to be met with failure. So... Any assistance in fixing this? Please?


Edit: Managed to fix the issue with some help from the IRC.

 
Last edited by a moderator:
would it be possible to use MsSQL instead of MySQL?

 
The guide at number 20 is "page not found"

20. Add user and password into it. Follow this guide. Make sure you set username as root and password as ragnarok because this is the credentials located on your conf/inter-server.conf
Click to expand...
 
Thank you I finished working with my server side.

4WcTKVl.png


and now how can I make the client side. ?

can I use this client ? http://www.nickyzai.com/?p=kro

P.s I try to make client many time but can't connect server to client
default_sad.png


 
Last edited by a moderator:
You must log in or register to reply here.
Back
Top