All Log Aren't Save In Log_db And Mysql Setting
Warning! This is the old Hercules bugtracker archive, and may not reflect the current state of Hercules. The current bugtracker is on GitHub Issues.
Issue information
Issue ID
#1195
Status
Working as Intended
Severity
None
Started
Hercules Elf Bot
Mar 15, 2008 23:39
Last Post
Hercules Elf Bot
Apr 5, 2012 8:32
Confirmation
Hercules Elf Bot - Mar 15, 2008 23:39
Originally posted by [b]Barron-Monster[/b]
http://www.eathena.ws/board/index.php?autocom=bugtracker&showbug=1195
charlog, interlog, loginlog aren't still save in the MySQL Log SQL Database. Other thing you can specify different db name for login or char or map but i don't think you can segment it because there is only a main.sql and not a login char map sql file then you don't know what table put in different db.
This post has been edited by Barron-Monster: Mar 16 2008, 07:49 AM
http://www.eathena.ws/board/index.php?autocom=bugtracker&showbug=1195
charlog, interlog, loginlog aren't still save in the MySQL Log SQL Database. Other thing you can specify different db name for login or char or map but i don't think you can segment it because there is only a main.sql and not a login char map sql file then you don't know what table put in different db.
This post has been edited by Barron-Monster: Mar 16 2008, 07:49 AM
Hercules Elf Bot - Dec 17, 2011 5:35
Originally posted by [b]Ind[/b]
indeed they should be merged to log db
indeed they should be merged to log db
Hercules Elf Bot - Dec 18, 2011 4:02
Originally posted by [b]Xtremist[/b]
Yea... Even I was thinking ... why they are saved in main.Every time i backup I have to delete such bug charlog from main
Yea... Even I was thinking ... why they are saved in main.Every time i backup I have to delete such bug charlog from main
Hercules Elf Bot - Dec 18, 2011 6:45
Originally posted by [b]Brian[/b]
To update the original post, now the only log tables left in main.sql are:
- charlog
- interlog
(loginlog was moved to the logs database in [rev=13000])
The previous reason charlog and interlog are in main.sql is so the char-server doesn't need a 2nd SQL connection (to the log database).
[quote name='theultramage' date='Mar 17 2008, 10:41 PM']I think that one problem is that the `log` db is a separate database, and would require an extra database connection (and the related startup code) on the login- and char-server. That's because they don't use the log database.[/quote]
To update the original post, now the only log tables left in main.sql are:
- charlog
- interlog
(loginlog was moved to the logs database in [rev=13000])
The previous reason charlog and interlog are in main.sql is so the char-server doesn't need a 2nd SQL connection (to the log database).
[quote name='theultramage' date='Mar 17 2008, 10:41 PM']I think that one problem is that the `log` db is a separate database, and would require an extra database connection (and the related startup code) on the login- and char-server. That's because they don't use the log database.[/quote]
Hercules Elf Bot - Dec 19, 2011 12:01
Originally posted by [b]Ind[/b]
thanks for the info. this isn't a bug then.
thanks for the info. this isn't a bug then.