To create new wiki account, please join us on #znc at Libera.Chat and ask admins to create a wiki account for you. You can say thanks to spambots for this inconvenience.

ZLog SQL: Difference between revisions

From ZNC
Jump to navigation Jump to search
Lipvig (talk | contribs)
No edit summary
HaptiK (talk | contribs)
No edit summary
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{External Module}}
{{External Module}}


MySQL/SQLite logging plugin for ZNC IRC bouncer written in Python 3.
This is a global Python module for PostgreSQL/MySQL/SQLite logging.


GitHub repository and latest version can be found here: https://github.com/stil/zlog-sql
GitHub repository: https://github.com/stil/zlog-sql
 
== Features ==
* Supports PostgreSQL, MySQL, and SQLite databases.
* Asynchronous database writes on a separate thread. Guarantees that ZNC won't hang during SQL connection timeout.
* Automatic table creation (CREATE TABLE IF NOT EXIST)
* Retry after failed inserts. When the database server is offline, logs are buffered to memory. They are saved when the database is back online so you won't lose logs during MySQL outages.


== Quick start ==
== Quick start ==
Line 12: Line 18:
# Enable module <code>zlog_sql</code> and set its argument.
# Enable module <code>zlog_sql</code> and set its argument.


For MySQL, set module argument matching following format:
For PostgreSQL, set module argument matching the following format:
 
<pre>postgres://username:password@localhost/database_name</pre>
 
'''Important:''' you need <code>psycopg2</code> pip package for MySQL logging. Install it with <code>pip3 install psycopg2</code> command.
 
For MySQL, set module argument matching the following format:


<pre>mysql://username:password@localhost/database_name</pre>
<pre>mysql://username:password@localhost/database_name</pre>
'''Important:''' you need <code>PyMySQL</code> pip package for MySQL logging. Install it with <code>pip3 install PyMySQL</code> command.
'''Important:''' you need <code>PyMySQL</code> pip package for MySQL logging. Install it with <code>pip3 install PyMySQL</code> command.


For SQLite use following string format:
For SQLite use the following string format:


<pre>sqlite://home/user/logs.sqlite</pre>
<pre>sqlite:///home/user/logs.sqlite</pre>
or simply leave out the path
or simply leave out the path



Latest revision as of 07:47, 21 May 2019

This is a global Python module for PostgreSQL/MySQL/SQLite logging.

GitHub repository: https://github.com/stil/zlog-sql

Features

  • Supports PostgreSQL, MySQL, and SQLite databases.
  • Asynchronous database writes on a separate thread. Guarantees that ZNC won't hang during SQL connection timeout.
  • Automatic table creation (CREATE TABLE IF NOT EXIST)
  • Retry after failed inserts. When the database server is offline, logs are buffered to memory. They are saved when the database is back online so you won't lose logs during MySQL outages.

Quick start

  1. Copy zlog_sql.py to ~/.znc/modules/zlog_sql.py.
  2. In Webadmin, open the list of Global Modules.
  3. Make sure modpython is enabled.
  4. Enable module zlog_sql and set its argument.

For PostgreSQL, set module argument matching the following format:

postgres://username:password@localhost/database_name

Important: you need psycopg2 pip package for MySQL logging. Install it with pip3 install psycopg2 command.

For MySQL, set module argument matching the following format:

mysql://username:password@localhost/database_name

Important: you need PyMySQL pip package for MySQL logging. Install it with pip3 install PyMySQL command.

For SQLite use the following string format:

sqlite:///home/user/logs.sqlite

or simply leave out the path

sqlite

in this case, logs are going to be written to the default path ~/.znc/moddata/zlog_sql/logs.sqlite.

  1. Save changes. SQL table schema is going to be created automatically.