SQLite logging plugin
Current version: 0.5
Logs user info on login and logout into sqlite database.
Configuration
Open plugins.conf in your favourite text editor and add this line:
plugin /usr/lib/uhub/mod_logging_sqlite.so "file=/etc/uhub/userlog.db"
Parameters:
| Parameter | Description |
|---|---|
| file | Path/filename for log database. |
Hub commands
| Command | Description |
|---|---|
| !userlog [<lines> [<column> <search pattern>]] | Search in user log for a value. If lines given, displays specified number of last user log entries, else displays 20 by default. If column and search pattern are given, displays specified number of lines matching the pattern in given column. Searching for pattern (especially in all columns) may result in large result sets and hub freeze for several seconds, therefore max lines displayed is hard limited to 200 lines and is recommended to always specify a reasonable limit and column. |
| !userlogcleanup <days> | Delete log entries older than specified number of days. |