Roundup Tracker - Issues

Issue 2551222

classification
config.ini doesn't list all available databases
Type: behavior Severity: minor
Components: Database Versions: 2.2.0
process
Status: closed
:
: : rouilj, tekberg
Priority: :

Created on 2022-07-18 21:39 by tekberg, last changed 2022-07-19 14:37 by tekberg.

Messages
msg7612 Author: [hidden] (tekberg) Date: 2022-07-18 21:39
I was updating my config.ini moving from 2.1 to 2.2. I noticed that the line 

# Available backends: anydbm, sqlite

near line 572 was missing databases.

I know that mysql and postgresql are available, but are not shown in this list. I tried to follow 
the code but got lost, otherwise I'd suggest a fix.
msg7613 Author: [hidden] (rouilj) Date: 2022-07-18 22:31
Hi Tom:

In message <1658180366.64.0.166927370587.issue2551222@roundup.psfhosted.org>,
Tom Ekberg writes:
>I was updating my config.ini moving from 2.1 to 2.2. I noticed that the line 
>
># Available backends: anydbm, sqlite
>
>near line 572 was missing databases.
>
>I know that mysql and postgresql are available, but are not shown
>in this list. I tried to follow the code but got lost, otherwise
>I'd suggest a fix.

Are you sure that your virtual environment has psycopg2 and MySQLdb
installed? If the import of those packages fails, they won't show up
when the config file is created.

What happens if you fire up the python in your virtual env and run:

  import psycopg2

or 
  import MySQLdb
?

-- rouilj
msg7614 Author: [hidden] (tekberg) Date: 2022-07-19 14:37
If I run the roundup-admin command updateconfig using my venv it shows 
postgresql as one of the DB options.
History
Date User Action Args
2022-07-19 14:37:53tekbergsetstatus: new -> closed
messages: + msg7614
2022-07-18 22:31:52rouiljsetmessages: + msg7613
2022-07-18 21:39:26tekbergcreate