The InspIRCd Project
Home | Developers | Wiki | Forums | Bug Tracker | SVN | Download | Blog | Stats
Personal tools

Modules/sqllog

From the makers of InspIRCd.

(Redirected from SQL Logging Module)
Jump to: navigation, search


Description
This module allows you to globally log all of your useful network traffic (e.g. oper ups, connects, disconnects) using a backend database. The special notes for this module are important. Please read them before you load this module on your server.
Configuration Tags
To use this module you must define a tag as shown below:
<sqllog dbid="1">

The variables in the tag have the following meanings:

  • dbid - The database id which this module is to use. Please see the documentation of the m_sql module for more details.
Additional Modes
None
Additional Commands
None
Special Notes
Before you use this module, you must import the schema for it into your mysql database! To do so, import the SQL file m_sqllog.schema.sql from the extras/ directory of your inspircd install. The recommended ways to do this are mysqlimport and webmin (the SQL file is compatible with both).

Remember that you only need to load m_sqllog.so on one server on your network for it to work, as it logs messages globally.

To do anything useful with the data, you must use (or write) a tool to search and present the data in your SQL database. There is an example of such a system administrator's tool in the inspircd-extras package which you can download from our SVN. You may view an example of this utility in action here. Please use the username inspircd, the database name brain and no password to access the data.

Extra ModuleThis module is an 'extra' module. This means that by default it is not compiled when you type make to build your IRCd. To enable this module follow these steps.


Dependencies