[Pkg-roundcube-maintainers] Bug#678541: roundcube-pgsql: roundcube cannot connect to postgresql after purge and complete reinstall

Fri Jun 22 15:35:15 UTC 2012

Package: roundcube
Version: 0.7.2-2
Severity: grave
Justification: renders package unusable

Dear Maintainer,
*** Please consider answering these questions, where appropriate ***

The problem appear after an upgrade from postgresql 8.x to 9.x and un upgrade from roundcube 0.5.x to 0.7.x.
After upgrade, when I try to load the rouncube web page from a brower, I get the error:

DATABASE ERROR: CONNECTION FAILED!

Unable to connect to the database!
Please contact your server-administrator.

Looking in the /var/log/roundcube/error log file, I noticed this kind of errors:

[12-Jun-2012 07:44:17 UTC] PHP Warning:  date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /usr/share/roundcube/program/include/rcube_config.php on line 96
[12-Jun-2012 07:44:17 UTC] PHP Warning:  date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /usr/share/roundcube/program/include/rcube_config.php on line 97
[12-Jun-2012 07:44:17 UTC] MDB2 Error: connect failed (-24): _doConnect: [Error message: unable to establish a connection]
[Native message: ]

[12-Jun-2012 07:44:17 UTC] PHP Warning:  date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /usr/share/roundcube/program/include/main.inc on line 2178
[12-Jun-2012 07:44:17 +0000]: DB Error: _doConnect: [Error message: unable to establish a connection]
[Native message: ]
 ** pgsql(pgsql)://roundcube:xxx at localhost/roundcube in /usr/share/roundcube/program/include/rcube_mdb2.php on line 104 (GET /webmail/)
[12-Jun-2012 07:44:18 UTC] PHP Warning:  date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /usr/share/roundcube/program/include/rcube_mdb2.php on line 603

So I tried to reconfigure roundcube database connection, without success. I also tried to completely
purge roundcube, remove all trace I could see from the previous configuration, and reinstall it
from scratch. I get the same errors (both in the web page and in the log file).

I tried to change the connection to the database (tried both unix socket and TCP/IP, tried both ident
and password for authentication). Nothing worked.

I tried to look at the posgresql pg_hba.conf file, it allowed peer method for local connections and md5 method
for host connection, both in IPv4 and IPv6. I tried to connect to the roundcube database from the
command line using a non-priviledged user, with command line "psql -h localhost -U roundcube roundcube". It
did succeed with the same password that was configured in the $dbpass setting in /etc/roundcube/debian-db.php.
When connecting to the database from the command line, the command /d does display the tables that were
created at some point by one of the attempts to reconfigure roundcube, so I guess the tables are here and
the access rights for the roundcube user are set up correctly.

However, I still get always the same errors from the web page.

I would have expected that reconfiguration would have allowed roundcube to connect properly to the
database, juste as psql command line tool do.

-- System Information:
Debian Release: wheezy/sid
  APT prefers testing
  APT policy: (990, 'testing'), (980, 'stable-updates'), (980, 'stable'), (90, 'experimental'), (90, 'unstable')
Architecture: armel (armv5tel)

Kernel: Linux 2.6.39.4-11
Locale: LANG=fr_FR.utf8, LC_CTYPE=fr_FR.utf8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages roundcube-pgsql depends on:
ii  php-mdb2-driver-pgsql                      1.5.0b2-1
ii  postgresql-client-9.1 [postgresql-client]  9.1.4-1

roundcube-pgsql recommends no packages.

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

Versions of packages roundcube-core depends on:
ii  apache2-mpm-prefork [httpd]  2.2.22-7
ii  dbconfig-common              1.8.47+nmu1
ii  debconf [debconf-2.0]        1.5.43
ii  libjs-jquery                 1.7.2+debian-1
ii  libjs-jquery-ui              1.8.ooops.20+dfsg-1
ii  libmagic1                    5.11-1
ii  php-auth                     1.6.2-1
ii  php-mail-mime                1.8.4-1
ii  php-mdb2                     2.5.0b3-2
ii  php-net-smtp                 1.6.1-1
ii  php-net-socket               1.0.9-2
ii  php5                         5.4.4~rc2-1
ii  php5-gd                      5.4.4~rc2-1
ii  php5-intl                    5.4.4~rc2-1
ii  php5-mcrypt                  5.4.4~rc2-1
ii  php5-pspell                  5.4.4~rc2-1
ii  tinymce                      3.4.8+dfsg0-1
ii  ucf                          3.0025+nmu3

Versions of packages roundcube-core suggests:
ii  php-auth-sasl      1.0.4-1
pn  php-crypt-gpg      <none>
ii  roundcube-plugins  0.7.2-2

Versions of packages roundcube depends on:
ii  roundcube-core  0.7.2-2

-- debconf information:
  roundcube/dbconfig-reinstall: false
  roundcube/mysql/method: unix socket
  roundcube/upgrade-error: abort
* roundcube/pgsql/authmethod-user: password
  roundcube/purge: false
* roundcube/dbconfig-install: true
* roundcube/db/dbname: roundcube
* roundcube/language: fr_FR
  roundcube/remove-error: abort
* roundcube/remote/newhost: localhost
  roundcube/pgsql/changeconf: false
* roundcube/restart-webserver: true
  roundcube/upgrade-backup: true
  roundcube/dbconfig-upgrade: true
* roundcube/install-error: ignore
* roundcube/remote/port:
  roundcube/mysql/admin-user: root
* roundcube/pgsql/method: tcp/ip
  roundcube/pgsql/manualconf:
* roundcube/hosts: ssl://smtp.spaceroots.org:993
  roundcube/db/basepath:
* roundcube/pgsql/authmethod-admin: password
  roundcube/dbconfig-remove:
* roundcube/pgsql/no-empty-passwords:
* roundcube/pgsql/admin-user: postgres
  roundcube/passwords-do-not-match:
  roundcube/internal/reconfiguring: false
* roundcube/reconfigure-webserver: apache2
* roundcube/database-type: pgsql
* roundcube/remote/host: localhost
  roundcube/internal/skip-preseed: true
* roundcube/db/app-user: roundcube
  roundcube/missing-db-package-error: abort