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

Modules/sqllog

From the makers of InspIRCd.

Jump to: navigation, search

sqllog module (InspIRCd-sqllog version)

1.0 Documentation 1.1 Documentation 1.2 Documentation
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
This module does not implement any extra user or channel modes.
Additional Commands
This module adds no extra commands.
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
Personal tools
head
Navigation
head
head
head
head
 
head
head
Toolbox
head
head