Your message dated Sat, 23 Jun 2012 13:05:47 +0200
with message-id <[email protected]>
and subject line Re: Bug#678541: roundcube-pgsql: roundcube cannot connect to
postgresql after purge and complete reinstall
has caused the Debian Bug report #678541,
regarding roundcube-pgsql: roundcube cannot connect to postgresql after purge
and complete reinstall
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
678541: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=678541
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
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@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
--- End Message ---
--- Begin Message ---
❦ 23 juin 2012 12:22 CEST, Vincent Bernat <[email protected]> :
>> 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.
>
> After some investigation, it appears that PostgreSQL now listens only on
> 5433 (SSL) while PHP is not aware of this change. Setting `$dbport` to
> `'5433'` solves the problem.
>
> I don't know the correct way to fix this. I don't think this should be
> fixed in roundcube. Either PHP should default to 5433 instead of 5432
> (like psql is doing right now) or dbconfig-common should default to
> 5433.
>
> I have filed a bug against php5-pgsql (#678626) about this. I am marking
> this bug as being blocked but the new bug in the mean time.
I have been told in #678626 that PostgreSQL is listening on 5433 only if
there is some other version already installed. This allows to run both
versions in parallel.
Therefore, you can:
1. Reconfigure the appropriate PostgreSQL instance to listen on port
5432 (I suppose that the previous version has been uninstalled).
2. dpkg-reconfigure -plow roundcube-core and specify 5433 as the port
to use.
--
Make sure comments and code agree.
- The Elements of Programming Style (Kernighan & Plauger)
pgpZ6cQQcKr8e.pgp
Description: PGP signature
--- End Message ---
