Debian Bug report logs - #519104
roundcube: pgsql backend not working - too old MDB2_Driver_pgsql

Toggle useless messages

Message #5 received at submit@bugs.debian.org (full text, mbox, reply):

From: Grzegorz Sobański <silk@boktor.net>

To: Debian Bug Tracking System <submit@bugs.debian.org>

Subject: roundcube: pgsql backend not working - too old MDB2_Driver_pgsql

Date: Tue, 10 Mar 2009 14:48:01 +0100

Package: roundcube
Version: 0.2~stable-1
Severity: important


MDB2_Driver_pgsql (php-mdb2-driver-pgsql) in debian sid is in version 1.4.1.
Roundecube 0.2 requires 1.5.0a to work with postgres.

Effect of upgrade from roundcube 0.1 to 0.2:
- roundcube is unable to connect to database

Logs:
[10-Mar-2009 14:45:53 +0100] DB Error: setOption: [Error message:
unknown option disable_smart_seqname]
 in /usr/share/roundcube/program/include/rcube_mdb2.php on line 100 (GET
 /mail/)

Upgrade renders roundcube unusable for all (?) postgres users.
See: http://trac.roundcube.net/ticket/1485680


-- System Information:
Debian Release: squeeze/sid
  APT prefers unstable
  APT policy: (500, 'unstable'), (1, 'experimental')
Architecture: amd64 (x86_64)

Kernel: Linux 2.6.25-2-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages roundcube depends on:
ii  roundcube-core              0.2~stable-1 skinnable AJAX based webmail solut
ii  roundcube-mysql [roundcube- 0.2~stable-1 metapackage providing MySQL depend
ii  roundcube-pgsql [roundcube- 0.2~stable-1 metapackage providing PostgreSQL d

roundcube recommends no packages.

roundcube suggests no packages.

Versions of packages roundcube-core depends on:
ii  apache2                   2.2.11-2       Apache HTTP Server metapackage
ii  apache2-mpm-prefork [http 2.2.11-2       Apache HTTP Server - traditional n
ii  dbconfig-common           1.8.40         common framework for packaging dat
ii  debconf [debconf-2.0]     1.5.26         Debian configuration management sy
ii  libmagic1                 4.26-2         File type determination library us
ii  php-auth                  1.6.1-1        PHP PEAR modules for creating an a
ii  php-mail-mime             1.5.2-0.1      PHP PEAR module for creating MIME 
ii  php-mdb2                  2.4.1-1        PHP PEAR module to provide a commo
ii  php-net-smtp              1.3.1-1        PHP PEAR module implementing SMTP 
ii  php-net-socket            1.0.9-2        PHP PEAR Network Socket Interface 
ii  php5                      5.2.6.dfsg.1-3 server-side, HTML-embedded scripti
ii  php5-gd                   5.2.6.dfsg.1-3 GD module for php5
ii  php5-mcrypt               5.2.6.dfsg.1-3 MCrypt module for php5
ii  roundcube-mysql [roundcub 0.2~stable-1   metapackage providing MySQL depend
ii  roundcube-pgsql [roundcub 0.2~stable-1   metapackage providing PostgreSQL d
ii  tinymce                   3.2.1.1-0.1    platform independent web based Jav
ii  ucf                       3.0016         Update Configuration File: preserv

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

Message #10 received at 519104@bugs.debian.org (full text, mbox, reply):

From: Vincent Bernat <bernat@debian.org>

To: Grzegorz Sobański <silk@boktor.net>

Cc: 519104@bugs.debian.org

Subject: Re: Bug#519104: roundcube: pgsql backend not working - too old MDB2_Driver_pgsql

Date: Tue, 10 Mar 2009 19:45:06 +0100

[Message part 1 (text/plain, inline)]

OoO En ce début d'après-midi nuageux  du mardi 10 mars 2009, vers 14:48,
Grzegorz Sobański <silk@boktor.net> disait :

> MDB2_Driver_pgsql (php-mdb2-driver-pgsql) in debian sid is in version 1.4.1.
> Roundecube 0.2 requires 1.5.0a to work with postgres.

> Effect of upgrade from roundcube 0.1 to 0.2:
> - roundcube is unable to connect to database

> Logs:
> [10-Mar-2009 14:45:53 +0100] DB Error: setOption: [Error message:
> unknown option disable_smart_seqname]
>  in /usr/share/roundcube/program/include/rcube_mdb2.php on line 100 (GET
>  /mail/)

> Upgrade renders roundcube unusable for all (?) postgres users.
> See: http://trac.roundcube.net/ticket/1485680

Thanks for the feedback!

Googling a bit, I see that the option "disable_smart_seqname" is here to
get better performance. Therefore, I  propose to just patch roundcube to
not  use this  option. Having  a small  performance impact  seems  to be
better than to have a non working program.

What do you think?
-- 
I WILL NOT MOCK MRS. DUMBFACE
I WILL NOT MOCK MRS. DUMBFACE
I WILL NOT MOCK MRS. DUMBFACE
-+- Bart Simpson on chalkboard in episode 2F21

[Message part 2 (application/pgp-signature, inline)]

Message #15 received at 519104@bugs.debian.org (full text, mbox, reply):

From: Grzegorz Sobański <silk@boktor.net>

To: Vincent Bernat <bernat@debian.org>

Cc: 519104@bugs.debian.org

Subject: Re: Bug#519104: roundcube: pgsql backend not working - too old MDB2_Driver_pgsql

Date: Wed, 11 Mar 2009 12:49:02 +0100

[Message part 1 (text/plain, inline)]

* Vincent Bernat <bernat@debian.org> [2009-03-10 19:52]:
> Googling a bit, I see that the option "disable_smart_seqname" is here to
> get better performance. Therefore, I  propose to just patch roundcube to

Yeas, seems so.

> not  use this  option. Having  a small  performance impact  seems  to be
> better than to have a non working program.
> 
> What do you think?

Ok, I patched roudcube (oneline comment patch in attachement ;) )
and it now works. Well, sort of.

I hit another bug: http://trac.roundcube.net/ticket/1484954
So now users can't edit their identieties (saving them to db fails).
Solution is the same as before - update php-mdb2-driver-pgsql to 1.5.0.

What is more - from the bug above it seems this affects sqlite backend, too.

Should I fill a wishlist bug against php-mdb2-driver-pgsql for new
version?
I know it is called 'alpha', but considering date when it was released
and that probably a lot of people is using it...

greetings
silk

[519104-workaround.patch (text/x-diff, attachment)]

Message #20 received at 519104@bugs.debian.org (full text, mbox, reply):

From: Vincent Bernat <bernat@debian.org>

To: Grzegorz Sobański <silk@boktor.net>

Cc: 519104@bugs.debian.org, control@bugs.debian.org

Subject: Re: Bug#519104: roundcube: pgsql backend not working - too old MDB2_Driver_pgsql

Date: Wed, 11 Mar 2009 18:42:23 +0100

[Message part 1 (text/plain, inline)]

clone 519104 -1
retitle -1 Cannot edit identities due to too old MDB2 driver
severity -1 normal
thanks

OoO  Pendant le  temps de  midi du  mercredi 11  mars 2009,  vers 12:49,
Grzegorz Sobański <silk@boktor.net> disait :

> I hit another bug: http://trac.roundcube.net/ticket/1484954
> So now users can't edit their identieties (saving them to db fails).
> Solution is the same as before - update php-mdb2-driver-pgsql to 1.5.0.

> What  is more  -  from the  bug  above it  seems  this affects  sqlite
> backend, too.

Ok, this  is another  bug. Unfortunately,  it seems to  be no  easy work
around. We'll have to wait until a more recent mdb2 driver is packaged.

> Should I fill a wishlist bug against php-mdb2-driver-pgsql for new
> version?

Yes, please.
-- 
Let the data structure the program.
            - The Elements of Programming Style (Kernighan & Plauger)

[Message part 2 (application/pgp-signature, inline)]

Message #27 received at 519104-close@bugs.debian.org (full text, mbox, reply):

From: Vincent Bernat <bernat@debian.org>

To: 519104-close@bugs.debian.org

Subject: Bug#519104: fixed in roundcube 0.2~stable-2

Date: Wed, 11 Mar 2009 18:02:09 +0000

Source: roundcube
Source-Version: 0.2~stable-2

We believe that the bug you reported is fixed in the latest version of
roundcube, which is due to be installed in the Debian FTP archive:

roundcube-core_0.2~stable-2_all.deb
  to pool/main/r/roundcube/roundcube-core_0.2~stable-2_all.deb
roundcube-mysql_0.2~stable-2_all.deb
  to pool/main/r/roundcube/roundcube-mysql_0.2~stable-2_all.deb
roundcube-pgsql_0.2~stable-2_all.deb
  to pool/main/r/roundcube/roundcube-pgsql_0.2~stable-2_all.deb
roundcube-sqlite_0.2~stable-2_all.deb
  to pool/main/r/roundcube/roundcube-sqlite_0.2~stable-2_all.deb
roundcube_0.2~stable-2.diff.gz
  to pool/main/r/roundcube/roundcube_0.2~stable-2.diff.gz
roundcube_0.2~stable-2.dsc
  to pool/main/r/roundcube/roundcube_0.2~stable-2.dsc
roundcube_0.2~stable-2_all.deb
  to pool/main/r/roundcube/roundcube_0.2~stable-2_all.deb



A summary of the changes between this version and the previous one is
attached.

Thank you for reporting the bug, which will now be closed.  If you
have further comments please address them to 519104@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Vincent Bernat <bernat@debian.org> (supplier of updated roundcube package)

(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing ftpmaster@debian.org)


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Format: 1.8
Date: Wed, 11 Mar 2009 18:49:32 +0100
Source: roundcube
Binary: roundcube-core roundcube roundcube-mysql roundcube-pgsql roundcube-sqlite
Architecture: source all
Version: 0.2~stable-2
Distribution: unstable
Urgency: low
Maintainer: Debian Roundcube Maintainers <pkg-roundcube-maintainers@lists.alioth.debian.org>
Changed-By: Vincent Bernat <bernat@debian.org>
Description: 
 roundcube  - skinnable AJAX based webmail solution for IMAP servers - metapack
 roundcube-core - skinnable AJAX based webmail solution for IMAP servers
 roundcube-mysql - metapackage providing MySQL dependencies for RoundCube
 roundcube-pgsql - metapackage providing PostgreSQL dependencies for RoundCube
 roundcube-sqlite - metapackage providing sqlite dependencies for RoundCube
Closes: 515806 516683 519104
Changes: 
 roundcube (0.2~stable-2) unstable; urgency=low
 .
   * Update debconf translations:
       + French, thanks to Christian Perrier. Closes: #515806.
       + Swedish, thanks to Martin Bagge. Closes: #516683.
   * Drop virtual package roundcube-db and add dependencies on real package
     instead: this way, we can have versioned dependencies on those to avoid
     version mismatch between packages.
   * Add a patch to not use a MDB2 feature not present in the Debian
     package. Thanks to Grzegorz Sobański for the patch. Closes: #519104.
Checksums-Sha1: 
 2e0ed7671e68f70db31dccaa9fe5eba019fa1d47 1417 roundcube_0.2~stable-2.dsc
 5c284965e2791bb8fd4b9511dcc8dac102628f0c 27172 roundcube_0.2~stable-2.diff.gz
 773a455d2fb7712e8eb0e365720b3dd7909100da 697288 roundcube-core_0.2~stable-2_all.deb
 eee1772371e11cd69b5642bedc73589d4976ecfa 14856 roundcube_0.2~stable-2_all.deb
 ef06dfbecfa7d6046b29dbf5257b964e03282f25 14172 roundcube-mysql_0.2~stable-2_all.deb
 20139f58c6f5d718b89a5295e907537e489169ef 14180 roundcube-pgsql_0.2~stable-2_all.deb
 8d6fad0beb194f558c376c5cb879f3a18f778aef 14148 roundcube-sqlite_0.2~stable-2_all.deb
Checksums-Sha256: 
 3d711f8fdb06091c5c7ba8713e3ef072459181f6839a8a9c9c8420d095f3269d 1417 roundcube_0.2~stable-2.dsc
 adcaad80e6f48f1480b42b12b4523249628f6062014f0813a6b609edb4349ba8 27172 roundcube_0.2~stable-2.diff.gz
 32a7ab8d5e91a7d4448d46e8c9151bea27a9edf17183ccccafdaf3efd2ecc3bf 697288 roundcube-core_0.2~stable-2_all.deb
 ff99fdbcfb5c100f05f277716295b9663d9b4214a40c3abeb747e337e6fe9990 14856 roundcube_0.2~stable-2_all.deb
 acb87e1105c189eb1a0ed491962ec42d9eadee15027724447859ca321afd8f51 14172 roundcube-mysql_0.2~stable-2_all.deb
 c19f62f55c85012ac283c1b953f564572f71ae373e7fe259920727fe98cc3df9 14180 roundcube-pgsql_0.2~stable-2_all.deb
 d716f1e58f6c55d274ec2fdc16e16a36a1684cdf6544d2f71bd7c44e93b0a728 14148 roundcube-sqlite_0.2~stable-2_all.deb
Files: 
 d07f9b2228d13193d1a68cc9c153e486 1417 web extra roundcube_0.2~stable-2.dsc
 0c9f543db2fd7b291b375db3da46240b 27172 web extra roundcube_0.2~stable-2.diff.gz
 c00bf0ca57f5bcf3e2dfc2e2270277bb 697288 web extra roundcube-core_0.2~stable-2_all.deb
 3baa5e8bb71e5b45777920401b539202 14856 web extra roundcube_0.2~stable-2_all.deb
 417d521473c8dbd2c3777e69923ddfa5 14172 web extra roundcube-mysql_0.2~stable-2_all.deb
 f6de62680f7b80d96ef40128bcff5b46 14180 web extra roundcube-pgsql_0.2~stable-2_all.deb
 834c1f98ae358018d19eacd7dc54418e 14148 web extra roundcube-sqlite_0.2~stable-2_all.deb

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkm3+tcACgkQKFvXofIqeU4s7ACfbZq+0GUZhJr1faysGCsrO/aj
hUwAnjZGu89cc7zLw1431uX4jx/NaezT
=7a0d
-----END PGP SIGNATURE-----

Send a report that this bug log contains spam.