Hello,
I am discovering Qlustar (being a ROCKS admin since a long time). My first test with Qlustar 10.x was sucessful; qluman-qt started correctly, I browsed the windows with no problem.
I reinstalled everything from scratch to run Qlustar 11, installed qluman-qt with apt install and using the singularity image : both version give the error
(...) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 393, in connect return self.dbapi.connect(*cargs, **cparams) sqlalchemy.exc.OperationalError: (sqlite3. OperationalError) unable to open database file
I wonder why SQLITE3 is invoqued because during the installation, there was a prompt for mysql root's password. MariaDB is running, and a Qlustar Database exists and populated : mysql -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 48 Server version: 10.1.41-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04 Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> use Qlustar; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A
Database changed MariaDB [Qlustar]> select * from Users; +----+-------+--------+---------------+----------------+------------------------------------------------+---------------------+ | id | name | passwd | real_name | email | info | last_changed | +----+-------+--------+---------------+----------------+------------------------------------------------+---------------------+ | 1 | admin | $......| Admin account | root@localhost | Admin user | 2019-11-05 08:49:36 | | 2 | root | $......| cli user | root@beosrv-c | user used by the qluman command line interface | 2019-10-30 10:57:10 | +----+-------+--------+---------------+----------------+------------------------------------------------+---------------------+ 2 rows in set (0.00 sec)
Any clue will be welcome !
Thanks
Alain ---
Dr Alain EMPAIN, Bioinformatics University of Liège CHU, GIGA-R (B34, +1), alain.empain@uliege.be Rue des Martyrs, 11 B-4550 Nandrin Mobile: +32 497 701764 HOME:+32 85 512341
"A" == Alain EMPAIN alain.empain@ulg.ac.be writes:
Hi Alain,
A> Hello, I am discovering Qlustar (being a ROCKS admin since a long A> time). My first test with Qlustar 10.x was sucessful; qluman-qt A> started correctly, I browsed the windows with no problem.
happy to see you trying Qlustar.
A> I reinstalled everything from scratch to run Qlustar 11, A> installed qluman-qt with apt install and using the singularity A> image : both version give the error
A> (...) File A> "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", A> line A> 393, in connect A> return self.dbapi.connect(*cargs, **cparams) A> sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) A> unable to open database file
A> I wonder why SQLITE3 is invoqued because during the installation, A> there was a prompt for mysql root's password.
The sqlite DB is a new feature we introduced with the latest updates to store user commands executed via the RXengine in. We assume that you discovered a small bug that we will fix shortly. As a work around you can try to execute
$ mkdir $HOME/.config/Qluman
This is where the sqlite DB should be stored and if the dir doesn't exist it will fail. Can you please let us know whether this fixes your problem?
Best,
Roland