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
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
{{External Module}} | |||
MySQL/SQLite logging plugin for ZNC IRC bouncer written in Python 3. | MySQL/SQLite logging plugin for ZNC IRC bouncer written in Python 3. | ||
| Line 25: | Line 27: | ||
<ol start="5" style="list-style-type: decimal;"> | <ol start="5" style="list-style-type: decimal;"> | ||
<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> | ||
Revision as of 02:49, 12 September 2017
 |
This is an external module. Please note that it may or may not work with the current release (1.9.1). This module is not included in the default ZNC installation, and you will need to manually compile it before you can load this module. Contact the author if you have any questions, but feel free to ask in #znc on Libera.Chat. Someone might be able to help you there. |
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.pyto~/.znc/modules/zlog_sql.py. - In Webadmin, open the list of Global Modules.
- Make sure
modpythonis enabled. - Enable module
zlog_sqland 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.