Project

General

Profile

Quassel Logging » History » Version 20

rikai, 01/31/2017 03:26 AM
Update ordering of dumplog notes to put the postgres version at the end, so it doesn't seem like the notes are about that. ;)

1 1 Gentle
h1. Quassel Logging
2 1 Gentle
3 7 seezer
{{toc}}
4 7 seezer
5 1 Gentle
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.
6 1 Gentle
7 1 Gentle
h2. Tools
8 1 Gentle
9 1 Gentle
h3. dumplog
10 1 Gentle
11 1 Gentle
this tool (written in Python) dumps quassel logs to a file. Currently it exports mIRC format.
12 1 Gentle
You can get it at
13 1 Gentle
14 15 Anonymous
> attachment:dumplog-0.0.1.tar.gz
15 1 Gentle
16 1 Gentle
it is rather self-explanatory, telling you if something went wrong. you can run it with
17 1 Gentle
18 1 Gentle
*default database path (ok for most unixes)*
19 1 Gentle
<pre>python dumplog.py -u username -n network -c "#channel" -o channel.log</pre>
20 1 Gentle
21 1 Gentle
*custom database path (Windows etc.)*
22 2 Gentle
<pre>python dumplog.py -d "C:\Quassel\quassel-storage.sqlite"</pre>
23 1 Gentle
24 1 Gentle
**Examples:**
25 1 Gentle
>*show users in quasseldb*
26 1 Gentle
><pre>python dumplog.py</pre>
27 1 Gentle
>
28 1 Gentle
>*show networks for quassel user john*
29 1 Gentle
><pre>python dumplog.py -u john</pre>
30 1 Gentle
>
31 1 Gentle
>*show channels for network Freenode for user john*
32 1 Gentle
><pre>python dumplog.py -u john -n Freenode</pre>
33 1 Gentle
>
34 1 Gentle
>*dump channel #quassel on network Freenode for user john to file quassel.log*
35 1 Gentle
><pre>python dumplog.py -u john -n Freenode -c "#quassel" -o quassel.log</pre>
36 1 Gentle
37 4 Gentle
*Limitations / Known Issues*
38 4 Gentle
nasty charset conversion takes place, gonna be fixed soon
39 1 Gentle
topics will only be properly parsed with English logs, need to talk with Sput/EgS about that ;P
40 20 rikai
dumplog currently only handles sqlite databases, for postgres support, a somewhat hacky but working script is available at "this github mirror":https://github.com/rikai/Quassel-DumpLog-Mirror
41 4 Gentle
42 3 Gentle
*Note*
43 1 Gentle
this tool is not maintained by quassel staff, contact Gentle on Freenode for bugs or feature requests
44 5 brot
45 5 brot
h3. quasselsuche
46 5 brot
47 5 brot
A webbased Quassel-Search-Engine for Quassel IRC
48 5 brot
49 5 brot
!quassel_backlog_search.png!
50 5 brot
51 5 brot
*Download*
52 6 m4yer
Snapshots and git version tracker can be found here: http://m4yer.minad.de/quassel/
53 5 brot
54 5 brot
*Note*
55 5 brot
this tool is not maintained by quassel staff, contact m4yer on Freenode for bugs or feature requests
56 8 avih
57 8 avih
h3. Windows - Portable quasselsuche
58 8 avih
59 14 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.
60 8 avih
61 12 avih
* Note - If you don't know your username/password, run show-password.bat
62 12 avih
63 8 avih
*Download*
64 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
65 1 Gentle
66 12 avih
* 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
67 8 avih
68 8 avih
*Note*
69 11 avih
this tool is not maintained by quassel staff, contact Avi Halachmi (avih on Freenode) for bugs or feature requests
70 16 karan
71 16 karan
h3. Quasselsearch
72 16 karan
73 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
74 18 karan
75 16 karan
Requirements: Gnu awk, sqlite3 backend
76 17 karan
How to use: Add yourself to the group "quasselcore" and then just run the script normally by doing "./quasselsearch <options>"
77 16 karan
78 1 Gentle
The available options are : 
79 17 karan
Usage : quasselsearch.sh (n|c|t|e|s|o|q|d|f)
80 17 karan
-n nick 
81 17 karan
-c channel
82 16 karan
-t start date in the format "YYYY-MM-DD HH:MM:SS" 
83 17 karan
-e end date in the same format as above
84 16 karan
-s search term 
85 16 karan
-o output file 
86 16 karan
-q quassel user defaults to $USER 
87 1 Gentle
-d quassel database location , defaults to /var/lib/quassel/quassel-storage.sqlite
88 17 karan
-f Change the time format, all formats that are accepted by the "date" command are allowed.
89 1 Gentle
90 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. 
91 16 karan
92 17 karan
Example:
93 16 karan
94 17 karan
><pre>./quasselsearch.sh -n karan -c #quassel -t 2015-04-20 -e 2015-04-30 -o logs.txt -s quasseldroid </pre>
95 16 karan
96 16 karan
*Note*
97 16 karan
this tool is not maintained by quassel staff, use the github page for bugs or feature requests
98 16 karan
99 16 karan
*Note* 
100 16 karan
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.