#1039562 libchado-perl: fails to access database during installation

Package:
libchado-perl
Source:
libchado-perl
Submitter:
Andreas Beckmann
Date:
2023-07-11 06:18:06 UTC
Severity:
normal
Tags:
#1039562#5
Date:
2023-06-27 08:17:57 UTC
From:
To:
Hi,

during a test with piuparts I noticed your package fails to access its
database during intallation. A postgresql server is installed and
running before installing libchado-perl.

From the attached log (scroll to the bottom...):

  Setting up libchado-perl (1.31-6) ...
  DBI connect('dbname=gmod-chado;host=localhost;port=5432','chado',...) failed: connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL:  password authentication failed for user "chado"
  connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL:  password authentication failed for user "chado" at /usr/share/perl5/Bio/GMOD/DB/Config.pm line 233.
  Database access not correctly configured
  Check your configuration and run manually the database update:
  cd /usr/share/gmod/chado/
  export GMOD_ROOT=/usr/share/gmod/chado
  export PGPASSFILE=/usr/share/gmod/chado/pgpass
  For a new installation:
  make load_schema
  make prepdb
  OR
  make update to upgrade the schema from a previous install
  Processing triggers for libc-bin (2.36-9) ...
  Processing triggers for ca-certificates (20230311) ...
  Updating certificates in /etc/ssl/certs...
  0 added, 0 removed; done.
  Running hooks in /etc/ca-certificates/update.d...
  done.


libchado-perl does not seem to use dbconfig-common to configure its
database access.


cheers,

Andreas

#1039562#10
Date:
2023-07-10 15:02:10 UTC
From:
To:
Installation shows an "error" because it tries to connect to database with
configuration defaults (will fail at first install if default user/password
does not exists in database, and this is fine).

In case of "failure" using found configuration
(/usr/share/gmod/chado/conf/gmod-chado.conf)  , it explains the expected
setup steps to user and exists with code 0.

So "error" is not a real error , but just an install setup test to check if
user need to configure database access, and exit as expected with error
code 0 (and package is installed as expected).

#1039562#15
Date:
2023-07-11 06:15:49 UTC
From:
To:
Am Mon, Jul 10, 2023 at 11:19:52PM +0200 schrieb Étienne Mollier:

If you see a good reason to upload just do so.

I agree with Étienne that some wontfix tag would avoid that someone
might open another bug about the same case.

Thus I hereby have set severity to minor (which is appropriate with
Olivier's explanation) and have tagged the bug wontfix.

Kind regards

      Andreas.