Log sql config

Tio Akima

New member
Messages
349
Points
0
Age
36
Discord
TioAkima#0636
Github
Tio Akima
Emulator
Hello, my database is separate
 
Main.sql
Log.sql
 
But ... Where do I configure in the emulator for it to access the Log tables?
 
Before it was in the file Inter-server.conf ... But now the structure has changed if I'm not mistaken.
 
thanks
 
Read it in my

2017 hercules setup guide

in my signature

after

By default Hercules is configured to write LOGs...

Rigth now, I need to go, I don't have time to write a full answer here.

after

 
Last edited by a moderator:
Read it in my

2017 hercules setup guide

in my signature

after

By default Hercules is configured to write LOGs...

Rigth now, I need to go, I don't have time to write a full answer here.

after
Sorry, but your guide is late and does not match the new emulator settings.

@EDIT

 Does anyone know where I can set to the LOG setting (set the infos to connect to the database) ???

 
Last edited by a moderator:
2017... matches i'm pretty sure when I gethome from school, I will be able to configure a latest from GIT Herc server...

Solution is in the guide...

 
Last edited by a moderator:
2017... matches i'm pretty sure when I gethome from school, I will be able to configure a latest from GIT Herc server...

Solution is in the guide...
Sorry again, but the solution is not in the guide.
 
The inter-server in your guide is different (old) according to the new inter-server.
 
Again, does anyone know how to configure the log? = /
 
To moderators : I don't mean to be rude or disrespectful, I just wasted 1 hour and 30 minutes to install latest Hercules from GIT, I think it should bring me some satisfaction ...

OK....So I'm back from school!

So as of writing this post, latest commit in GIT is 

32 minutes ago 

hash is

1b02f9269f15582c7d211f1d1a3a0c1c7ce68a88

1 parent 19883c5 commit 1b02f9269f15582c7d211f1d1a3a0c1c7ce68a88HerculesWSAPI committed with HerculesWSAPI 32 minutes ago 

Verified
I installed latest Hercules emulator on my Raspberry Pi server Using my guide

SlSE31t.jpg


Here is the output of the commands

hercuser@mtldevserverrpi:~/HerculesLatest $ git rev-parse HEAD
1b02f9269f15582c7d211f1d1a3a0c1c7ce68a88
hercuser@mtldevserverrpi:~/HerculesLatest $ cat .git/refs/heads/master
1b02f9269f15582c7d211f1d1a3a0c1c7ce68a88
hercuser@mtldevserverrpi:~/HerculesLatest $

As you can see the  hash of My cloned emulator is also 

1b02f9269f15582c7d211f1d1a3a0c1c7ce68a88

Here is the output of commands on my Log Database

TXPRlcq.jpg


mysql> use hercrolatestlog
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+---------------------------+
| Tables_in_hercrolatestlog |
+---------------------------+
| atcommandlog |
| branchlog |
| chatlog |
| loginlog |
| mvplog |
| npclog |
| picklog |
| zenylog |
+---------------------------+
8 rows in set (0.00 sec)


See there are Only log tables...

My guide works...

PS: My character wants to tell you something

ZvKDznW.jpg


So, please do yourself and every one else a favor, and do as my character tells you to do  
default_tongue.png


And stop wasting everyone else's time...

To moderators : I don't mean to be rude or disrespectful, I just wasted 1 hour and 30 minutes  to install latest Hercules from GIT, I think it should bring me some satisfaction ...

 
Last edited by a moderator:
To moderators : I don't mean to be rude or disrespectful, I just wasted 1 hour and 30 minutes to install latest Hercules from GIT, I think it should bring me some satisfaction ...

OK....So I'm back from school!

So as of writing this post, latest commit in GIT is 

32 minutes ago 

hash is

1b02f9269f15582c7d211f1d1a3a0c1c7ce68a88

1 parent 19883c5 commit 1b02f9269f15582c7d211f1d1a3a0c1c7ce68a88HerculesWSAPI committed with HerculesWSAPI 32 minutes ago 

Verified
I installed latest Hercules emulator on my Raspberry Pi server Using my guide

SlSE31t.jpg


Here is the output of the commands

hercuser@mtldevserverrpi:~/HerculesLatest $ git rev-parse HEAD
1b02f9269f15582c7d211f1d1a3a0c1c7ce68a88
hercuser@mtldevserverrpi:~/HerculesLatest $ cat .git/refs/heads/master
1b02f9269f15582c7d211f1d1a3a0c1c7ce68a88
hercuser@mtldevserverrpi:~/HerculesLatest $

As you can see the  hash of My cloned emulator is also 

1b02f9269f15582c7d211f1d1a3a0c1c7ce68a88

Here is the output of commands on my Log Database

TXPRlcq.jpg


mysql> use hercrolatestlog
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+---------------------------+
| Tables_in_hercrolatestlog |
+---------------------------+
| atcommandlog |
| branchlog |
| chatlog |
| loginlog |
| mvplog |
| npclog |
| picklog |
| zenylog |
+---------------------------+
8 rows in set (0.00 sec)


See there are Only log tables...

My guide works...

PS: My character wants to tell you something

ZvKDznW.jpg


So, please do yourself and every one else a favor, and do as my character tells you to do  
default_tongue.png


And stop wasting everyone else's time...

To moderators : I don't mean to be rude or disrespectful, I just wasted 1 hour and 30 minutes  to install latest Hercules from GIT, I think it should bring me some satisfaction ...

Oh god .. you again!
 
I'm going to draw so you can understand.
 
Your tutorial says to go in: Hercules/conf/import/inter-server.conf
As in the image below.
 
print2.jpg

 
 
But in Herc.this Hercules/conf/import/inter-server.conf

Current file, this file is as follows:
 
print1.jpg

 
 
Tutorial ill-explained! rude.

 
Last edited by a moderator:
To moderators : I don't mean to be rude or disrespectful, I just wasted 1 hour and 30 minutes to install latest Hercules from GIT, I think it should bring me some satisfaction ...

OK....So I'm back from school!

So as of writing this post, latest commit in GIT is 

32 minutes ago 

hash is

1b02f9269f15582c7d211f1d1a3a0c1c7ce68a88

1 parent 19883c5 commit 1b02f9269f15582c7d211f1d1a3a0c1c7ce68a88HerculesWSAPI committed with HerculesWSAPI 32 minutes ago 

Verified
I installed latest Hercules emulator on my Raspberry Pi server Using my guide

SlSE31t.jpg


Here is the output of the commands

hercuser@mtldevserverrpi:~/HerculesLatest $ git rev-parse HEAD
1b02f9269f15582c7d211f1d1a3a0c1c7ce68a88
hercuser@mtldevserverrpi:~/HerculesLatest $ cat .git/refs/heads/master
1b02f9269f15582c7d211f1d1a3a0c1c7ce68a88
hercuser@mtldevserverrpi:~/HerculesLatest $

As you can see the  hash of My cloned emulator is also 

1b02f9269f15582c7d211f1d1a3a0c1c7ce68a88

Here is the output of commands on my Log Database

TXPRlcq.jpg


mysql> use hercrolatestlog
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+---------------------------+
| Tables_in_hercrolatestlog |
+---------------------------+
| atcommandlog |
| branchlog |
| chatlog |
| loginlog |
| mvplog |
| npclog |
| picklog |
| zenylog |
+---------------------------+
8 rows in set (0.00 sec)


See there are Only log tables...

My guide works...

PS: My character wants to tell you something

ZvKDznW.jpg


So, please do yourself and every one else a favor, and do as my character tells you to do  
default_tongue.png


And stop wasting everyone else's time...

To moderators : I don't mean to be rude or disrespectful, I just wasted 1 hour and 30 minutes  to install latest Hercules from GIT, I think it should bring me some satisfaction ...

Oh god .. you again!
 
I'm going to draw so you can understand.
 
Your tutorial says to go in: Hercules/conf/import/inter-server.conf
As in the image below.
 
print2.jpg

 
 
But in Herc.this Hercules/conf/import/inter-server.conf

Current file, this file is as follows:
 
print1.jpg

 
 
Tutorial ill-explained! rude.
aTFTtNJ.jpg
aTFTtNJ.jpg
aTFTtNJ.jpg
aTFTtNJ.jpg
aTFTtNJ.jpg
aTFTtNJ.jpg
aTFTtNJ.jpg


aTFTtNJ.jpg
aTFTtNJ.jpg
aTFTtNJ.jpg
aTFTtNJ.jpg
aTFTtNJ.jpg
aTFTtNJ.jpg
aTFTtNJ.jpg


aTFTtNJ.jpg
aTFTtNJ.jpg
aTFTtNJ.jpg
aTFTtNJ.jpg
aTFTtNJ.jpg
aTFTtNJ.jpg
aTFTtNJ.jpg


Wow I didn't laugh that much since lunch break at school!!

It's an IMPORT folder config file of course it is empty!!!

How inside import folder config files work :

you put your settings inside of file (just those you need to change)

and the settings inside files of IMPORT folder  override setting in the default conf

Draw as much as you like 
aTFTtNJ.jpg
 But learn how your emulator works first 
B38cFIv.jpg


BTW :

- I'm never going to be rude to someone because he is right.

- I'm never going to be rude to someone who doesn't know something.

- I'm rude to you because you didn't know how import folder works, and was saying I'm wrong (even after I made a proof of concept).

hope this clears things up 
default_wink.png


Ps: read more attentively this part:

Hercules as most modern emulators support configuration import. This means that there is a directory import containing exact names of configuration files found throughout config folder.

Files inside import directory, override configuration files. This is a good industry practice to add your changes to .config in the import directory, for the following reasons:

  1. Maintenance, you can easily update this part of the emulator. (otherwise, you would have to compare your current configuration with updated one and manually integrate new features)
  2. Portability, when you recovering the server from backup, just plug and play your import folder. Boom, your server is configured.
  3. Conciliation, all relevant to your server option are neatly stored in one place, for easy review.
  4. Reversibility, you can revert your setting to a default value by simply removing the entry from .config in import folder.
The way I work with Import folder:

I open the original config folder in Hercules GIT repository.

https://github.com/HerculesWS/Hercules/tree/master/conf

Then, I open each .config file, I review and I copy/paste values I want to configure to the same .config in my import folder.

I open same .config file in my import folder:

nano ~/Hercules/conf/import/char-server.conf

//================= Hercules Configuration ================================

[...]

//=========================================================================

//= Character Server local configuration file.

//=========================================================================

char_configuration: {

}

I paste parts, just the way they appear in the original .config, but without // comments.

So, I paste this:

server_name: "Hercules"

wisp_server_name: "Server"

And I edit those parts:

//================= Hercules Configuration ================================

[...]

//=========================================================================

//= Character Server local configuration file.

//=========================================================================

char_configuration: {

server_name: "HabilisRagnarok"

wisp_server_name: "HabilisRO"

}

Save and exit CTL+X, y.

see first time I open config file inside import folder it is empty:

//================= Hercules Configuration ================================

[...]

//=========================================================================

//= Character Server local configuration file.

//=========================================================================

char_configuration: {

}

 
Last edited by a moderator:
Sorry for bringing this topic back..

But it seems that the main and log sql should be in one database as of now??

 
@Samuel if use default configs yes, but you can use different sql db for logs, need only change configs a bit.

Default sql information in each config added by this line:

@include "conf/import/sql_connection.conf"


If files where you need, you should include in same way your custom sql connection information.

 
@4144

But using that method will alter main files instead of using the import section

Unlike before where we put all the custom config in the import folder..

or i'm missing sumthng in using this new conf files

 
Import directory now supported too.

But sadly you cant split sql_connection.conf without changing other configuration files.

 
Back
Top