Project

General

Profile

Quassel Logging » History » Version 25

TC01, 08/09/2017 09:15 PM

1 1 Gentle
h1. Quassel Logging
2 1 Gentle
3 7 seezer
{{toc}}
4 7 seezer
5 22 TC01
Quassel saves all logs into the database, it never forgets backlogs unless you delete a buffer. You can either scroll back in chat windows as far as you like, or you can use a tool to dump or view the logs in plaintext format. You can of course perform database queries against your database manually, but this is annoying and possibly impractical (if you are using a shared core and don't have access to the database). This page lists a handful of tools that can allow you to view your logs. It is current as of 2017.
6 1 Gentle
7 24 TC01
These tools were written by members of the community; they are not maintained by the quassel project maintainers. The authors' IRC usernames (for #quassel in chat.freenode.net) are listed in each section. For bugs, feature requests, etc. either contact the authors on IRC or use the linked github pages.
8 1 Gentle
9 22 TC01
h2. quasselgrep
10 1 Gentle
11 22 TC01
quasselgrep is a command line for searching quassel logs. It supports both SQLite and PostgreSQL and can be run on a local database or in client-server mode. quasselgrep can run as a server on the same machine running your quassel core, sitting on top of your database. Then users can use quasselgrep in client mode to connect to this server and access their logs remotely.
12 1 Gentle
13 22 TC01
quasselgrep is written in Python and is available on github here, along with documentation: https://github.com/fish-face/quasselgrep. It is written by Fish-Face.
14 22 TC01
15 22 TC01
h2. quassel-rest-search
16 22 TC01
17 22 TC01
quassel-rest-search is a web application for searching quassel logs. It provides both a HTTP API and a web application. 
18 22 TC01
19 22 TC01
quassel-rest-search is a PHP and JavaScript application available on github here: https://github.com/justjanne/quassel-rest-search. It is written by justJanne.
20 22 TC01
21 22 TC01
h2. dumplog
22 22 TC01
23 23 TC01
dumplog is an older tool for dumping logs to the command line. (Unlike quasselgrep, it cannot be used to search directly-- it simply dumps logs). The original version only supported SQLite databases, but a newer version now supports PostgreSQL. The new version may *not* support SQLite without some tinkering, so both are provided here.
24 22 TC01
25 22 TC01
The original version is available as an attachment here, and was written by Gentle.
26 22 TC01
27 15 Anonymous
> attachment:dumplog-0.0.1.tar.gz
28 1 Gentle
29 25 TC01
The newer version is available on github here: https://github.com/rikai/Quassel-DumpLog-Mirror. It was written by TecknoJock.
30 1 Gentle
31 22 TC01
Some documentation for the original version follows:
32 22 TC01
33 22 TC01
Default database path (ok for most unixes):
34 1 Gentle
<pre>python dumplog.py -u username -n network -c "#channel" -o channel.log</pre>
35 1 Gentle
36 22 TC01
Custom database path (Windows etc.):
37 1 Gentle
<pre>python dumplog.py -d "C:\Quassel\quassel-storage.sqlite"</pre>
38 1 Gentle
39 22 TC01
Examples:
40 22 TC01
41 1 Gentle
>*show users in quasseldb*
42 1 Gentle
><pre>python dumplog.py</pre>
43 1 Gentle
>
44 1 Gentle
>*show networks for quassel user john*
45 1 Gentle
><pre>python dumplog.py -u john</pre>
46 1 Gentle
>
47 1 Gentle
>*show channels for network Freenode for user john*
48 1 Gentle
><pre>python dumplog.py -u john -n Freenode</pre>
49 1 Gentle
>
50 4 Gentle
>*dump channel #quassel on network Freenode for user john to file quassel.log*
51 4 Gentle
><pre>python dumplog.py -u john -n Freenode -c "#quassel" -o quassel.log</pre>
52 1 Gentle
53 22 TC01
There are apparently some nasty charset conversion issues, and topics are only parsed properly with English logs.
54 1 Gentle
55 25 TC01
h2. Quasselsearch
56 25 TC01
57 25 TC01
*quasselsearch only supports sqlite databases; tools that support command line searches both are available above, like quasselgrep.* (Since the tool uses sql to extract stuff, it could possibly work on postgresql cores too, if you do give it a try please contact the author at karan 90 at g mail.c om (no spaces)).
58 25 TC01
59 25 TC01
With this bash script you can search your quassel database from the command line and get the output as a csv file/right in your terminal. You can get the script at Github here: https://github.com/karan42/quasselsearch. To contact the author, use the github page.
60 25 TC01
61 25 TC01
Requirements: Gnu awk, sqlite3 backend
62 25 TC01
How to use: Add yourself to the group "quasselcore" and then just run the script normally by doing "./quasselsearch <options>"
63 25 TC01
64 25 TC01
The available options are : 
65 25 TC01
Usage : quasselsearch.sh (n|c|t|e|s|o|q|d|f)
66 25 TC01
-n nick 
67 25 TC01
-c channel
68 25 TC01
-t start date in the format "YYYY-MM-DD HH:MM:SS" 
69 25 TC01
-e end date in the same format as above
70 25 TC01
-s search term 
71 25 TC01
-o output file 
72 25 TC01
-q quassel user defaults to $USER 
73 25 TC01
-d quassel database location , defaults to /var/lib/quassel/quassel-storage.sqlite
74 25 TC01
-f Change the time format, all formats that are accepted by the "date" command are allowed.
75 25 TC01
76 25 TC01
All the arguments are optional. Although if you run it without any arguments you would print out your whole backlog from all buffers. 
77 25 TC01
78 25 TC01
Example:
79 25 TC01
80 25 TC01
><pre>./quasselsearch.sh -n karan -c #quassel -t 2015-04-20 -e 2015-04-30 -o logs.txt -s quasseldroid </pre>
81 25 TC01
82 22 TC01
h1. Legacy Tools
83 5 brot
84 22 TC01
We recommend you _don't_ use these and instead use one of the above.
85 18 karan
86 16 karan
h2. quasselsuche
87 17 karan
88 16 karan
*WARNING: there are security vulnerabilities in quasselsuche, we strongly recommend not using it. If you want a web interface instead, please look at quassel-rest-search above.* 
89 1 Gentle
90 17 karan
A webbased Quassel-Search-Engine for Quassel IRC
91 17 karan
92 17 karan
!quassel_backlog_search.png!
93 16 karan
94 17 karan
*Download*
95 16 karan
Snapshots and git version tracker can be found here: http://m4yer.minad.de/quassel/
96 16 karan
97 16 karan
*Note*
98 1 Gentle
this tool is not maintained by quassel staff, contact m4yer on Freenode for bugs or feature requests
99 17 karan
100 1 Gentle
h3. Windows - Portable quasselsuche
101 16 karan
102 16 karan
This is the same quasselsuche as above, pre-packaged for Windows with a web server ("mongoose":https://github.com/valenok/mongoose) and php. Just "extract":http://7-zip.org and *run start-search-server.bat*. No install required and no traces are left outside the extracted directory. Further info and instructions are available at readme.txt in that package.
103 17 karan
104 16 karan
* Note - If you don't know your username/password, run show-password.bat
105 17 karan
106 16 karan
*Download*
107 16 karan
Current version is 1.1 (updated 2012-08-19): "portable-quassel-backlog-search-v1.1.7z":http://share.minad.de/mtUC.1.7z
108 16 karan
109 16 karan
* Note - The above package is 9 MB since it includes php. If you already have a local copy of php (zipped package for windows), you can download a smaller package (180 KB) to which you would need to extract php yourself: "portable-quassel-backlog-search-v1.1-NO-PHP.7z":http://share.minad.de/1phm.1-no-php.7z
110 16 karan
111 16 karan
*Note*
112 1 Gentle
this tool is not maintained by quassel staff, contact Avi Halachmi (avih on Freenode) for bugs or feature requests