Project

General

Profile

Quassel Logging » History » Version 21

TC01, 08/06/2017 07:41 PM

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 21 TC01
WARNING: there are security vulnerabilities in quasselsuche, we strongly recommend not using it.
48 21 TC01
49 5 brot
A webbased Quassel-Search-Engine for Quassel IRC
50 5 brot
51 5 brot
!quassel_backlog_search.png!
52 5 brot
53 5 brot
*Download*
54 6 m4yer
Snapshots and git version tracker can be found here: http://m4yer.minad.de/quassel/
55 5 brot
56 5 brot
*Note*
57 5 brot
this tool is not maintained by quassel staff, contact m4yer on Freenode for bugs or feature requests
58 8 avih
59 8 avih
h3. Windows - Portable quasselsuche
60 8 avih
61 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.
62 8 avih
63 12 avih
* Note - If you don't know your username/password, run show-password.bat
64 12 avih
65 8 avih
*Download*
66 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
67 1 Gentle
68 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
69 8 avih
70 8 avih
*Note*
71 11 avih
this tool is not maintained by quassel staff, contact Avi Halachmi (avih on Freenode) for bugs or feature requests
72 16 karan
73 16 karan
h3. Quasselsearch
74 16 karan
75 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
76 18 karan
77 16 karan
Requirements: Gnu awk, sqlite3 backend
78 17 karan
How to use: Add yourself to the group "quasselcore" and then just run the script normally by doing "./quasselsearch <options>"
79 16 karan
80 1 Gentle
The available options are : 
81 17 karan
Usage : quasselsearch.sh (n|c|t|e|s|o|q|d|f)
82 17 karan
-n nick 
83 17 karan
-c channel
84 16 karan
-t start date in the format "YYYY-MM-DD HH:MM:SS" 
85 17 karan
-e end date in the same format as above
86 16 karan
-s search term 
87 16 karan
-o output file 
88 16 karan
-q quassel user defaults to $USER 
89 1 Gentle
-d quassel database location , defaults to /var/lib/quassel/quassel-storage.sqlite
90 17 karan
-f Change the time format, all formats that are accepted by the "date" command are allowed.
91 1 Gentle
92 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. 
93 16 karan
94 17 karan
Example:
95 16 karan
96 17 karan
><pre>./quasselsearch.sh -n karan -c #quassel -t 2015-04-20 -e 2015-04-30 -o logs.txt -s quasseldroid </pre>
97 16 karan
98 16 karan
*Note*
99 16 karan
this tool is not maintained by quassel staff, use the github page for bugs or feature requests
100 16 karan
101 16 karan
*Note* 
102 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.