[Pkg-roundcube-maintainers] Bug#1016182: roundcube-pgsql: bad parsing of connection parameters to posgres database

Bernard bern at taranig.net
Thu Jul 28 16:45:00 BST 2022


Package: roundcube-pgsql
Version: 1.4.13+dfsg.1-1~deb11u1
Severity: normal

Dear Maintainer,

Context :
Two instances of poestgresql, one is listening on socket 5432 (/var/run/postgresql/.s.PGSQL.5432),
one is listening on socket 5433

roundcube database is on the 5433 instance

connection string is defined in /etc/roundcube/debian-db.php 

with
  $dbserver=urlencode('/var/run/postgresql');
  # or else $dbserver='%2Fvar%2Frun%2Fpostgresql';
  $dbport='5433';
connection is ok

with
  $dbserver='unix(/var/run/postgresql:5433)';
  $dbport='';
connection is ok

but with
  $dbserver='unix(/var/run/postgresql)';
  $dbport='5433';
log analysis shows that roundcube tries to connect thru socket 5432 to the database ":5433/roundcube"
which is not what I expected...


-- System Information:
Debian Release: 11.3
  APT prefers stable-security
  APT policy: (990, 'stable-security'), (900, 'stable'), (500, 'stable-updates')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 5.10.0-15-amd64 (SMP w/4 CPU threads)
Kernel taint flags: TAINT_OOT_MODULE, TAINT_UNSIGNED_MODULE
Locale: LANG=fr_FR.UTF-8, LC_CTYPE=fr_FR.UTF-8 (charmap=UTF-8), LANGUAGE not set
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages roundcube-pgsql depends on:
pn  php-pgsql                                 <none>
ii  postgresql-client                         13+225
ii  postgresql-client-13 [postgresql-client]  13.7-0+deb11u1

roundcube-pgsql recommends no packages.

Versions of packages roundcube-pgsql suggests:
pn  postgresql  <none>



More information about the Pkg-roundcube-maintainers mailing list