Project

General

Profile

Quassel Logging » History » Version 23

TC01, 08/07/2017 02:59 AM

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 22 TC01
None of these tools are maintained by the quassel maintainers, but are maintained by active community members. 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 22 TC01
The newer version is available on github here: https://github.com/rikai/Quassel-DumpLog-Mirror. It was written by rikai.
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 4 Gentle
55 22 TC01
h1. Legacy Tools
56 5 brot
57 22 TC01
We recommend you _don't_ use these and instead use one of the above.
58 5 brot
59 22 TC01
h2. quasselsuche
60 21 TC01
61 22 TC01
*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.* 
62 22 TC01
63 5 brot
A webbased Quassel-Search-Engine for Quassel IRC
64 5 brot
65 5 brot
!quassel_backlog_search.png!
66 6 m4yer
67 5 brot
*Download*
68 5 brot
Snapshots and git version tracker can be found here: http://m4yer.minad.de/quassel/
69 1 Gentle
70 1 Gentle
*Note*
71 1 Gentle
this tool is not maintained by quassel staff, contact m4yer on Freenode for bugs or feature requests
72 5 brot
73 8 avih
h3. Windows - Portable quasselsuche
74 8 avih
75 8 avih
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.
76 14 avih
77 8 avih
* Note - If you don't know your username/password, run show-password.bat
78 12 avih
79 12 avih
*Download*
80 8 avih
Current version is 1.1 (updated 2012-08-19): "portable-quassel-backlog-search-v1.1.7z":http://share.minad.de/mtUC.1.7z
81 8 avih
82 1 Gentle
* 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
83 12 avih
84 8 avih
*Note*
85 8 avih
this tool is not maintained by quassel staff, contact Avi Halachmi (avih on Freenode) for bugs or feature requests
86 11 avih
87 22 TC01
h2. Quasselsearch
88 22 TC01
89 22 TC01
*quasselsearch only supports sqlite databases; tools that support command line searches both are available above, like quasselgrep.*
90 18 karan
91 18 karan
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":https://github.com/karan42/quasselsearch
92 16 karan
93 17 karan
Requirements: Gnu awk, sqlite3 backend
94 16 karan
How to use: Add yourself to the group "quasselcore" and then just run the script normally by doing "./quasselsearch <options>"
95 1 Gentle
96 17 karan
The available options are : 
97 17 karan
Usage : quasselsearch.sh (n|c|t|e|s|o|q|d|f)
98 17 karan
-n nick 
99 16 karan
-c channel
100 17 karan
-t start date in the format "YYYY-MM-DD HH:MM:SS" 
101 16 karan
-e end date in the same format as above
102 16 karan
-s search term 
103 16 karan
-o output file 
104 1 Gentle
-q quassel user defaults to $USER 
105 17 karan
-d quassel database location , defaults to /var/lib/quassel/quassel-storage.sqlite
106 1 Gentle
-f Change the time format, all formats that are accepted by the "date" command are allowed.
107 16 karan
108 16 karan
All the arguments are optional. Although if you run it without any arguments you would print out your whole backlog from all buffers. 
109 17 karan
110 16 karan
Example:
111 17 karan
112 16 karan
><pre>./quasselsearch.sh -n karan -c #quassel -t 2015-04-20 -e 2015-04-30 -o logs.txt -s quasseldroid </pre>
113 16 karan
114 16 karan
*Note*
115 16 karan
this tool is not maintained by quassel staff, use the github page for bugs or feature requests
116 16 karan
117 16 karan
*Note* 
118 1 Gentle
Since the tool uses sql to extract stuff, it could possibly work on postgresql cores too, if you do give it a try please inform me at karan 90 at g mail.c om (no spaces) so i can update the code. Thanks.