Bug ID 954268
Summary IRC client quassel, part quassel-core: not able to connect to SQLite and create a user there.
Classification openSUSE
Product openSUSE Distribution
Version Leap 42.1
Hardware x86-64
OS Other
Status NEW
Severity Normal
Priority P5 - None
Component Other
Assignee bnc-team-screening@forge.provo.novell.com
Reporter mcaj@suse.com
QA Contact qa-bugs@suse.de
Found By ---
Blocker ---

quassel-core not able to connect to SQLite


When I installed prure and fresh openSUSE Leap 4.1 and tried to setup the
quasselcore service I found this , I think its a bug.
Steps to reproduce are:

1. on openSUSE Leap 42.1 fresh updated machine install the quassel include
these packages: quassel-core quassel-base quassel-client quassel-mono.

2. setup SSL there via this howto: 
openssl req -x509 -nodes -days 365 -newkey rsa:4096 -keyout
~/.config/quassel-irc.org/quasselCert.pem -out
/var/lib/quasselcore/quasselCert.pem

3. enable listen the core on  $MACHINE-IP-ADDRESS
in the file /etc/sysconfig/quasselcore add line:
QUASSELCORE_LISTEN="$MACHINE-IP-ADDRESS" 

4. start service via:# systemctl start quasselcore.service and if you check the
status you can see this output:
systemctl status quasselcore.service 
quasselcore.service - Quassel Core
   Loaded: loaded (/usr/lib/systemd/system/quasselcore.service; disabled)
   Active: active (running) since Mon 2015-11-09 15:20:29 CET; 4s ago
 Main PID: 25284 (quasselcore)
   CGroup: /system.slice/quasselcore.service
           ������25284 /usr/bin/quasselcore --listen=$MACHINE-IP-ADDRESS
--configdir=/var/lib/quasselcore --logfile=/var/log/quassel/quasselcore

Nov 09 15:20:29 $MACHINE quasselcore[25284]: ("QSQLITE")
Nov 09 15:20:29 $MACHINE quasselcore[25284]: Core is currently not configured!
Please connect with a Quassel Client for basic setup.

so far so good now let do the basic setup with the  client
run :# quasselclient

5. add the core as your hostname $MACHINE
or $MACHINE-IP-ADDRESS on port 4242.
If you connect into the core you shold see the core configuration wizard.
click on "next". Now we are creating the Admin user, it can be any user let say
user: ircmaster with some *safe* password then click on next and select only
one storage Backed is available: SQLite and "Commit" it

we see please way window never finish ....

6. on the log file there are these messages:

2015-11-09 15:24:31 Info: Client connected from $MACHINE-IP-ADDRESS  
2015-11-09 15:24:31 Info: Closing server for basic setup. 
2015-11-09 15:27:58 Warning: Unable to open database SQLite for thread 0x9b7700 
2015-11-09 15:27:58 Warning: - out of memory Error opening database 
2015-11-09 15:27:58 Warning: Database connection "SQLite" for thread
QThread(0x9b7700) was lost, attempting to reconnect... 
2015-11-09 15:27:58 Warning: Unable to open database SQLite for thread 0x9b7700 
2015-11-09 15:27:58 Warning: - out of memory Error opening database 
2015-11-09 15:27:58 Error: FATAL: Selected storage backend is not available:
"SQLite" 

and if we check the service status:
# systemctl status quasselcore.service  -l
quasselcore.service - Quassel Core
   Loaded: loaded (/usr/lib/systemd/system/quasselcore.service; disabled)
   Active: failed (Result: exit-code) since Mon 2015-11-09 15:27:58 CET; 2min
59s ago
  Process: 25284 ExecStart=/usr/bin/quasselcore --listen=${QUASSELCORE_LISTEN}
--configdir=/var/lib/quasselcore --logfile=/var/log/quassel/quasselcore
(code=exited, status=1/FAILURE)
 Main PID: 25284 (code=exited, status=1/FAILURE)


PS for the SQL lite I installed:
sqlite2 and sqllite3, python-pysqlite, libQt5Sql5 and libQt5Sql5-sqlite 
packages.
if the quassel-core need different package it should be installed automatically
I think...


You are receiving this mail because: