Debian Bug report logs - #519293
Cannot edit identities due to too old MDB2 driver

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 #35 received at 519293-close@bugs.debian.org (full text, mbox, reply):

From: Vincent Bernat <bernat@debian.org>

To: 519293-close@bugs.debian.org

Subject: Bug#519293: fixed in roundcube 0.2.1-2

Date: Sat, 16 May 2009 13:47:16 +0000

Source: roundcube
Source-Version: 0.2.1-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.1-2_all.deb
  to pool/main/r/roundcube/roundcube-core_0.2.1-2_all.deb
roundcube-mysql_0.2.1-2_all.deb
  to pool/main/r/roundcube/roundcube-mysql_0.2.1-2_all.deb
roundcube-pgsql_0.2.1-2_all.deb
  to pool/main/r/roundcube/roundcube-pgsql_0.2.1-2_all.deb
roundcube-sqlite_0.2.1-2_all.deb
  to pool/main/r/roundcube/roundcube-sqlite_0.2.1-2_all.deb
roundcube_0.2.1-2.diff.gz
  to pool/main/r/roundcube/roundcube_0.2.1-2.diff.gz
roundcube_0.2.1-2.dsc
  to pool/main/r/roundcube/roundcube_0.2.1-2.dsc
roundcube_0.2.1-2_all.deb
  to pool/main/r/roundcube/roundcube_0.2.1-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 519293@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: Sat, 16 May 2009 15:30:17 +0200
Source: roundcube
Binary: roundcube-core roundcube roundcube-mysql roundcube-pgsql roundcube-sqlite
Architecture: source all
Version: 0.2.1-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: 519104 519293 520004 520024 526696 528796
Changes: 
 roundcube (0.2.1-2) unstable; urgency=low
 .
   * Update debconf translations:
       + German, thanks to Helge Kreutzmann. Closes: #520004.
       + Japanese, thanks to Hideki Yamane. Closes: #520024.
       + Spanish, thanks to Francisco Javier. Closes: #526696.
       + Russian, thanks to Yuri Kozlov. Closes: #528796.
   * Depend on php-mdb2-* (>= 1.5.0b2) since it is needed to fix some
     bugs. Closes: #519104, #519293. Remove not needed any more patch from
     debian/patches/series. Keep it in debian/patches to help backports.
Checksums-Sha1: 
 3761bc98f184e0d3343f68b97dc5f1def428de9b 1382 roundcube_0.2.1-2.dsc
 87e8249bd4dccd40877d4cfe61e9b1abe6c33cbf 27620 roundcube_0.2.1-2.diff.gz
 796c03c1963f890cfb3c2242a27570bf2d6b494f 689714 roundcube-core_0.2.1-2_all.deb
 c0a5559e2e7ae512809051d1a085504219690630 11310 roundcube_0.2.1-2_all.deb
 e86a6c340dff82a8d83bd97ccd68ab62a811ec69 10586 roundcube-mysql_0.2.1-2_all.deb
 bc07f9652a6b21071da29fc1f9cd63392c2ec536 10590 roundcube-pgsql_0.2.1-2_all.deb
 ab0e4e3adfe1591a55d0adcd0c51bfc0c452ecdc 10550 roundcube-sqlite_0.2.1-2_all.deb
Checksums-Sha256: 
 2bf1397aea6ff46eb7caf5e5b7efa65afc1cff85eb66a964898ebac338f5089f 1382 roundcube_0.2.1-2.dsc
 4b6afb414ba424c406e3e617eb2b2a768fac35e73d2decce21f507fd68a297c7 27620 roundcube_0.2.1-2.diff.gz
 4fa430fb4a6ff8778397c56f165e3fc27ddacb384824cd3cb6f4ad6e72c1c2ce 689714 roundcube-core_0.2.1-2_all.deb
 3279c5783f97bc31370c7bbd66a19162d43e77c854aeea34b7cc956c5d8399ef 11310 roundcube_0.2.1-2_all.deb
 5f8f287d74daed4caf480e7633c2fc1b45a6a0c232030b9a980160808818a5b7 10586 roundcube-mysql_0.2.1-2_all.deb
 8b3988a485232fcb53db42c2fb0fec6ffa10d00b2dd4cd1827e7efd7b6c63b2b 10590 roundcube-pgsql_0.2.1-2_all.deb
 d034942935715f4fe6a5de98d7039b7659ae537f841134b57ddf92fa48928233 10550 roundcube-sqlite_0.2.1-2_all.deb
Files: 
 3ea107fa87420c17ea151e0ade277543 1382 web extra roundcube_0.2.1-2.dsc
 af0d80036f47461635263351f047b9a7 27620 web extra roundcube_0.2.1-2.diff.gz
 771f3feb7a36a5a32fb0e7b60790064a 689714 web extra roundcube-core_0.2.1-2_all.deb
 b2e5eac71162425a66e0801da7b7e943 11310 web extra roundcube_0.2.1-2_all.deb
 d248cac0bafdfb8550cd0ebd2d978097 10586 web extra roundcube-mysql_0.2.1-2_all.deb
 9683e5a3fe67d9c5f64b03519b34e3e6 10590 web extra roundcube-pgsql_0.2.1-2_all.deb
 fb5e78fc6460118616ffadef38f49865 10550 web extra roundcube-sqlite_0.2.1-2_all.deb

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

iEYEARECAAYFAkoOwDUACgkQKFvXofIqeU6e+wCaA0RIE8yt/tanXDAn2Yt0b9pa
pakAn25aFzKEeQTJQnly3uuoL0L/EmvG
=5gFI
-----END PGP SIGNATURE-----

Send a report that this bug log contains spam.