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
Jump to navigation
Jump to search
First edit, not sure about how MediaWiki is going to handle this |
mNo edit summary |
||
Line 1: | Line 1: | ||
MySQL/SQLite logging plugin for ZNC IRC bouncer written in Python 3. | MySQL/SQLite logging plugin for ZNC IRC bouncer written in Python 3. | ||
Revision as of 02:48, 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
- Copy
zlog_sql.py
to~/.znc/modules/zlog_sql.py
. - In Webadmin, open the list of Global Modules.
- Make sure
modpython
is enabled. - 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
.
- Save changes. SQL table schema is going to be created automatically.