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

[Vincent Bernat]

 ❦ 22 juin 2012 17:35 CEST, Luc Maisonobe <luc at spaceroots.org> :

> 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.
-- 
Don't just echo the code with comments - make every comment count.
            - The Elements of Programming Style (Kernighan & Plauger)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 835 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-roundcube-maintainers/attachments/20120623/5af6ee9e/attachment.pgp>