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

Difference between revisions of "ZLog SQL"

From ZNC
Jump to: navigation, search
m
Line 26: Line 26:
 
<li>Save changes. SQL table schema is going to be created automatically.</li></ol>
 
<li>Save changes. SQL table schema is going to be created automatically.</li></ol>
  
[[Category:External_Modules]]
+
{{External Module}}

Revision as of 02:49, 12 September 2017

MySQL/SQLite logging plugin for ZNC IRC bouncer written in Python 3.

GitHub repository and latest version can be found here: https://github.com/stil/zlog-sql

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 MySQL, set module argument matching 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 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.