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 |
mNo edit summary |
||
| Line 1: | Line 1: | ||
{{External Module}} | {{External Module}} | ||
MySQL/SQLite logging | This is a global Python module for MySQL/SQLite logging. | ||
GitHub repository | GitHub repository: https://github.com/stil/zlog-sql | ||
== Quick start == | == Quick start == | ||
Revision as of 02:52, 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. |
This is a global Python module for MySQL/SQLite logging.
GitHub repository: 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.