Source Logging and Reporting Services
8 Attachment(s)
Updates
Latest SLRD version 1.2.0.0, released 6/6/2009. Latest SLRP version 1.0.2.0, released 4/16/2009. Note: special characters in DB passwords If you use certain special characters in your DB password, they must be escaped in the exe.config file. Here are the characters and their escaped versions: quote (") - " apostrophe (') - ' ampersand (&) - & less than (<) - < greater than (>) - > Source for the above escape sequences. Background Before SLRS, I wrote several other logging systems/readers, and though they worked to a certain degree, they weren't powerful enough. SLRS came about when I noticed some new functions in the API about GameLogHooks. Though I didn't end up using them, the discussion lead to a comment by Tsunami, in which he suggested creating a daemon that can receive a logaddress stream, which is how SLRS works. Concept SLRS has three major pieces:
SLRP logs all SourceMod LogAction messages to the database. With this system in place, your SM admin and server logs are stored in an easily searchable DB table. Screenshots DB Schema Attachment 40608 tblLogMessages Attachment 40609 Requirements
Installing SLRS This system is somewhat complex, and requires some technical skills to install it. Setting up the database
Installing the daemon (SLRD)
At this point, the logging daemon is online and ready to receive log messages. Attaching servers and installing SLRP (repeat these steps for each server you want to attach)
How to use All log messages are in tblLogMessages. Use SQL to search the table. Changelogs SRLD
Troubleshooting If SLRD closes shortly after you start it, or if log messages aren't making it into the database, you can check the SRLD logs. The logs are created by default at ./logs. Licensing & Source Code SLRS is licensed under the GNU GPL 3.0 license. You can download the source code (if you don't know what source code means, you are trying to download the wrong thing) from GitHub. Thanks to
|
Re: Source Logging and Reporting Services
This looks fantastic. Great job. :)
|
Re: Source Logging and Reporting Services
Quote:
I finished coding a new feature in the plugin that sets timestamps correctly for sources that aren't in the DB server's time zone. EDIT: SLRP 1.0.1.0 released. |
Re: Source Logging and Reporting Services
Im confused by what this does?
Sorry :( |
Re: Source Logging and Reporting Services
Quote:
Quote:
|
Re: Source Logging and Reporting Services
SLRD 1.1.0.1 and SLRP 1.0.2.0 released!
See the updates section for details. |
Re: Source Logging and Reporting Services
Any plans for a linux based daemon :)?
|
Re: Source Logging and Reporting Services
Quote:
Update SLRD now supports multiple game servers streaming logs from the same IP address. |
Re: Source Logging and Reporting Services
Recon, you own :D
|
Re: Source Logging and Reporting Services
Database Schema Update (12/15/09 4:46 PM PST)
I have added an index for the messageDT column in tbllogmessages. Queries based on that column will return up to 300 times faster (as was the case with a 37 million row table). This is basically a change from O(N) searching to O(log base 2 of N). To apply this update, run add_messagedt_index.sql (attached to the first post). The update will require MySQL to index all the rows in tbllogmessages, which could take quite awhile. If you don't want the speed increase, you do not have to apply this update. |
All times are GMT -4. The time now is 02:25. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.