Debian Bug report logs - #657092
SQLite 2.x is not present any more in php5-sqlite

Toggle useless messages

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

From: Tobias Birmili <birmili@mecodia.de>

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

Subject: roundcube-sqlite: doesn't work with php5-sqlite in wheezy anymore

Date: Mon, 23 Jan 2012 23:51:12 +0100

Package: roundcube
Version: 0.7-3
Severity: grave
Justification: renders package unusable

Dear Maintainer,

   * What led up to the situation?
	did an aptitude safe-upgrade which upgraded php5-* to 5.3.9-1
   * What was the outcome of this action?
	roundcube couln't connect to the sqlite database
	because sqlite.so isn't included anymore.


-- System Information:
Debian Release: wheezy/sid
  APT prefers testing
  APT policy: (990, 'testing'), (500, 'unstable')
Architecture: amd64 (x86_64)

Kernel: Linux 3.1.0-1-amd64 (SMP w/8 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages roundcube-sqlite depends on:
ii  php-mdb2-driver-sqlite  1.5.0b2-1
ii  sqlite                  2.8.17-7

roundcube-sqlite recommends no packages.

roundcube-sqlite suggests no packages.

Versions of packages roundcube-core depends on:
ii  apache2-mpm-prefork [httpd]  2.2.21-5
ii  dbconfig-common              1.8.47+nmu1
ii  debconf [debconf-2.0]        1.5.41
ii  libjs-jquery                 1.7.1-1
ii  libjs-jquery-ui              1.8.ooops.16+dfsg-1
ii  libmagic1                    5.09-2
ii  nginx-full [httpd]           1.1.12-1
ii  php-auth                     1.6.2-1
ii  php-mail-mime                1.8.0-2
ii  php-mdb2                     2.5.0b2-1
ii  php-net-smtp                 1.6.1-1
ii  php-net-socket               1.0.9-2
ii  php5                         5.3.8.0-1
ii  php5-gd                      5.3.8.0-1+b1
ii  php5-intl                    5.3.8.0-1+b1
ii  php5-mcrypt                  5.3.8.0-1+b1
ii  php5-pspell                  5.3.8.0-1+b1
ii  tinymce                      3.4.3.2+dfsg0-1
ii  ucf                          3.0025+nmu2

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

Versions of packages roundcube depends on:
ii  roundcube-core  0.7-3

-- debconf information:
  roundcube/password-confirm: (password omitted)
  roundcube/mysql/admin-pass: (password omitted)
  roundcube/mysql/app-pass: (password omitted)
  roundcube/app-password-confirm: (password omitted)
  roundcube/pgsql/app-pass: (password omitted)
  roundcube/pgsql/admin-pass: (password omitted)
  roundcube/upgrade-error: abort
  roundcube/pgsql/authmethod-user: password
  roundcube/purge: false
* roundcube/dbconfig-install: true
  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:
  roundcube/pgsql/authmethod-admin: ident
  roundcube/dbconfig-remove:
  roundcube/pgsql/admin-user: postgres
  roundcube/internal/skip-preseed: false
  roundcube/db/app-user:
  roundcube/dbconfig-reinstall: false
  roundcube/mysql/method: unix socket
  roundcube/remove-error: abort
  roundcube/restart-webserver: true
* roundcube/dbconfig-upgrade: true
  roundcube/remote/port:
  roundcube/pgsql/method: unix socket
  roundcube/pgsql/manualconf:
  roundcube/db/basepath: /var/lib/dbconfig-common/sqlite/roundcube
  roundcube/pgsql/no-empty-passwords:
  roundcube/passwords-do-not-match:
  roundcube/internal/reconfiguring: false
  roundcube/reconfigure-webserver: apache2, lighttpd
* roundcube/database-type: sqlite
  roundcube/remote/host:
  roundcube/missing-db-package-error: abort

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

From: Vincent Bernat <bernat@debian.org>

To: Tobias Birmili <birmili@mecodia.de>

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

Subject: Re: Bug#657092: roundcube-sqlite: doesn't work with php5-sqlite in wheezy anymore

Date: Tue, 24 Jan 2012 06:21:57 +0100

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

assign 657092 php5-sqlite
severity 657092 important
title 657092 SQLite 2 support, needed by Roundcube, has been removed from php5-sqlite.
thanks

OoO La  nuit ayant déjà  recouvert d'encre ce  jour du lundi  23 janvier
2012, vers 23:51, Tobias Birmili <birmili@mecodia.de> disait :

> Dear Maintainer,

>    * What led up to the situation?
> 	did an aptitude safe-upgrade which upgraded php5-* to 5.3.9-1
>    * What was the outcome of this action?
> 	roundcube couln't connect to the sqlite database
> 	because sqlite.so isn't included anymore.

Well, I  can't really  see what I  could do.  The bug should  be against
php5-sqlite which does not ship SQLite 2 support anymore. Let's transfer
this bug.

For php5-sqlite  maintainer: Roundcube needs  SQLite 2 support.  It does
not  support SQLite  3. Is  it possible  to add  back SQLite  support in
php5-sqlite?
-- 
Vincent Bernat ☯ http://vincent.bernat.im

Replace repetitive expressions by calls to a common function.
            - The Elements of Programming Style (Kernighan & Plauger)

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

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

From: Ondřej Surý <ondrej@debian.org>

To: 657092@bugs.debian.org

Cc: Vincent Bernat <bernat@debian.org>, Debian PHP Maintainers <pkg-php-maint@lists.alioth.debian.org>, Debian Roundcube Maintainers <pkg-roundcube-maintainers@lists.alioth.debian.org>, "Laszlo Boszormenyi (GCS)" <gcs@debian.hu>

Subject: Re: [php-maint] Processed: reassign 657092 to php5-sqlite ...

Date: Tue, 24 Jan 2012 09:23:44 +0100

Hi,

> For php5-sqlite  maintainer: Roundcube needs  SQLite 2 support.  It does
> not  support SQLite  3. Is  it possible  to add  back SQLite  support in
> php5-sqlite?

sorry, but not a chance. sqlite(2) is 6 years overdue and unmaintained upstream.
And it is my opinion it should be removed from wheezy completely and php5-sqlite
was one of the obstacles.

Also we will ship php5-5.4.x in wheezy where upstream had removed sqlite
extension as well. So it doesn't really make sense to

I could add Breaks: roundcube header to the php5-sqlite package, but I would
need a version number where it will be fixed, so I can add versioned dependency.

Roundcube has to deal with the fact it's using 6 years old unmaintained code.

I am sorry I cannot help you, but we just could not drag old code just because
few stuborn reverse dependencies.

O.
-- 
Ondřej Surý <ondrej@sury.org>
http://blog.rfc1925.org/

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

From: Lior Kaplan <kaplan@debian.org>

To: Ondřej Surý <ondrej@debian.org>

Cc: 657092@bugs.debian.org, Vincent Bernat <bernat@debian.org>, Debian PHP Maintainers <pkg-php-maint@lists.alioth.debian.org>, Debian Roundcube Maintainers <pkg-roundcube-maintainers@lists.alioth.debian.org>, "Laszlo Boszormenyi (GCS)" <gcs@debian.hu>

Subject: Re: [php-maint] Processed: reassign 657092 to php5-sqlite ...

Date: Tue, 24 Jan 2012 10:55:35 +0200

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

On Tue, Jan 24, 2012 at 10:23 AM, Ondřej Surý <ondrej@debian.org> wrote:

> Hi,
>
> > For php5-sqlite  maintainer: Roundcube needs  SQLite 2 support.  It does
> > not  support SQLite  3. Is  it possible  to add  back SQLite  support in
> > php5-sqlite?
>
> sorry, but not a chance. sqlite(2) is 6 years overdue and unmaintained
> upstream.
> And it is my opinion it should be removed from wheezy completely and
> php5-sqlite
> was one of the obstacles.
>

Hi,

While the above is true and I agree with it, I think the solution lays
elsewhere.

from the roundcube packages, roundcube-sqlite is the package that depends
on sqlite and php-mdb2-driver-sqlite which depends directly on php5-sqlte.

The php-mdb2-driver-sqlite hasn't been updated in debia for the last two
and a half years, in that time its upstream have added sqlite3 and
pdo_sqlite support, see http://pear.php.net/package/MDB2/download/2.4.1 (we
have 1.5.0b2).

I think this bug should be reassign to it, and its upgrade should let
roundcube to work with updated sqlite versions.

Kaplan

[Message part 2 (text/html, inline)]

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

From: Vincent Bernat <bernat@debian.org>

To: Ondřej Surý <ondrej@debian.org>

Cc: 657092@bugs.debian.org, Debian PHP Maintainers <pkg-php-maint@lists.alioth.debian.org>, Debian Roundcube Maintainers <pkg-roundcube-maintainers@lists.alioth.debian.org>, "Laszlo Boszormenyi \(GCS\)" <gcs@debian.hu>

Subject: Re: [php-maint] Processed: reassign 657092 to php5-sqlite ...

Date: Tue, 24 Jan 2012 13:46:07 +0100

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

OoO En cette  matinée ensoleillée du mardi 24  janvier 2012, vers 09:23,
Ondřej Surý <ondrej@debian.org> disait :

>> For php5-sqlite  maintainer: Roundcube needs  SQLite 2 support.  It does
>> not  support SQLite  3. Is  it possible  to add  back SQLite  support in
>> php5-sqlite?

> sorry, but not a chance. sqlite(2) is 6 years overdue and unmaintained upstream.
> And it is my opinion it should be removed from wheezy completely and php5-sqlite
> was one of the obstacles.

> Also we will ship php5-5.4.x in wheezy where upstream had removed sqlite
> extension as well. So it doesn't really make sense to

> I could add Breaks: roundcube header to the php5-sqlite package, but I would
> need a version number where it will be fixed, so I can add versioned dependency.

> Roundcube has to deal with the fact it's using 6 years old unmaintained code.

> I am sorry I cannot help you, but we just could not drag old code just because
> few stuborn reverse dependencies.

OK, I reassign the bug to roundcube then. I didn't know that sqlite2 was
not supported any more for such a long time.
-- 
Vincent Bernat ☯ http://vincent.bernat.im

panic ("Splunge!");
	2.2.16 /usr/src/linux/drivers/scsi/psi240i.c

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

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

From: Vincent Bernat <bernat@debian.org>

To: Lior Kaplan <kaplan@debian.org>

Cc: Ondřej Surý <ondrej@debian.org>, 657092@bugs.debian.org, Debian PHP Maintainers <pkg-php-maint@lists.alioth.debian.org>, Debian Roundcube Maintainers <pkg-roundcube-maintainers@lists.alioth.debian.org>, "Laszlo Boszormenyi \(GCS\)" <gcs@debian.hu>

Subject: Re: [php-maint] Processed: reassign 657092 to php5-sqlite ...

Date: Tue, 24 Jan 2012 13:52:34 +0100

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

OoO En cette  matinée ensoleillée du mardi 24  janvier 2012, vers 09:55,
Lior Kaplan <kaplan@debian.org> disait :

> While the above is true and I agree with it, I think the solution
> lays elsewhere.

> from the roundcube packages, roundcube-sqlite is the package that
> depends on sqlite and php-mdb2-driver-sqlite which depends directly
> on php5-sqlte.

> The php-mdb2-driver-sqlite hasn't been updated in debia for the last
> two and a half years, in that time its upstream have added sqlite3
> and pdo_sqlite support, see http://pear.php.net/package/MDB2/download
> /2.4.1 (we have 1.5.0b2).

> I think this bug should be reassign to it, and its upgrade should let
> roundcube to work with updated sqlite versions.

We  could update php-mdb2-driver-sqlite  but Roundcube  explicitely says
that sqlite 3.x is not supported (in INSTALL).
-- 
Vincent Bernat ☯ http://vincent.bernat.im

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

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

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

From: Soren Stoutner <soren@smallbusinesstech.net>

To: 657092@bugs.debian.org

Subject: Reassign

Date: Fri, 27 Jan 2012 14:24:50 -0700

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

It seems to me this bug should be moved to roundcube-sqlite and upgraded to 
serious because it completely breaks all roundcube installations that rely on 
sqlite.

-- 
Soren Stoutner
Small Business Tech Solutions
623-262-6169
soren@smallbusinesstech.net
www.smallbusinesstech.net

[signature.asc (application/pgp-signature, inline)]

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

From: Vincent Bernat <bernat@debian.org>

To: Soren Stoutner <soren@smallbusinesstech.net>

Cc: 657092@bugs.debian.org

Subject: Re: Bug#657092: Reassign

Date: Sat, 28 Jan 2012 01:18:38 +0100

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

OoO  En cette  soirée bien  amorcée du  vendredi 27  janvier  2012, vers
22:24, Soren Stoutner <soren@smallbusinesstech.net> disait :

> It seems to me this bug should be moved to roundcube-sqlite and upgraded to 
> serious because it completely breaks all roundcube installations that rely on 
> sqlite.

I have  reassigned and  raised the priority.  Unless someone  comes with
some patch to make Roundcube compatible with SQLite 3.x, this means that
support for SQLite will just be dropped.
-- 
Vincent Bernat ☯ http://vincent.bernat.im

Make sure your code "does nothing" gracefully.
            - The Elements of Programming Style (Kernighan & Plauger)

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

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

From: Soren Stoutner <soren@smallbusinesstech.net>

To: 657092@bugs.debian.org

Subject: Re: Bug#657092: Reassign

Date: Fri, 27 Jan 2012 17:40:42 -0700

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

Vincent,

On Friday, January 27, 2012 05:18:38 PM Vincent Bernat wrote:
> OoO  En cette  soirée bien  amorcée du  vendredi 27  janvier  2012, vers
> 
> I have  reassigned and  raised the priority.  Unless someone  comes with
> some patch to make Roundcube compatible with SQLite 3.x, this means that
> support for SQLite will just be dropped.

You are correct.  I'm not holding out hope that this gets fixed anytime soon, 
although I am going to file a bug with upstream.  It looks like in the meantime 
I am going to have to migrate all of my current installations to roundcube-
mysql.

I also raised the severity level to grave as this is more appropriate for this 
situation given that the package is completely unusable.

Soren

-- 
Soren Stoutner
Small Business Tech Solutions
623-262-6169
soren@smallbusinesstech.net
www.smallbusinesstech.net

[signature.asc (application/pgp-signature, inline)]

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

From: Soren Stoutner <soren@smallbusinesstech.net>

To: 657092@bugs.debian.org

Subject: Upstream Bug Report

Date: Fri, 27 Jan 2012 21:34:25 -0700

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

A bug report has been opened upstream at 
http://trac.roundcube.net/ticket/1488332

-- 
Soren Stoutner
Small Business Tech Solutions
623-262-6169
soren@smallbusinesstech.net
www.smallbusinesstech.net

[signature.asc (application/pgp-signature, inline)]

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

From: Vincent Bernat <bernat@debian.org>

To: Soren Stoutner <soren@smallbusinesstech.net>

Cc: 657092@bugs.debian.org

Subject: Re: Bug#657092: Upstream Bug Report

Date: Sun, 29 Jan 2012 13:14:56 +0100

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

OoO En cette fin de nuit  blanche du samedi 28 janvier 2012, vers 05:34,
Soren Stoutner <soren@smallbusinesstech.net> disait :

> A bug report has been opened upstream at 
> http://trac.roundcube.net/ticket/1488332

Thanks. The answer from Alec leave little hope for a solution before the
next Debian  release. I  will have to  drop roundcube-sqlite  package (I
cannot just Depends  on earlier versions of php5  package since it would
block the migration to testing).
-- 
Vincent Bernat ☯ http://vincent.bernat.im

panic("Lucy in the sky....");
	2.2.16 /usr/src/linux/arch/sparc64/kernel/starfire.c

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

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

From: Vincent Bernat <bernat@debian.org>

To: 657092-close@bugs.debian.org

Subject: Bug#657092: fixed in roundcube 0.7.1-2

Date: Tue, 07 Feb 2012 17:04:11 +0000

Source: roundcube
Source-Version: 0.7.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.7.1-2_all.deb
  to main/r/roundcube/roundcube-core_0.7.1-2_all.deb
roundcube-mysql_0.7.1-2_all.deb
  to main/r/roundcube/roundcube-mysql_0.7.1-2_all.deb
roundcube-pgsql_0.7.1-2_all.deb
  to main/r/roundcube/roundcube-pgsql_0.7.1-2_all.deb
roundcube-plugins_0.7.1-2_all.deb
  to main/r/roundcube/roundcube-plugins_0.7.1-2_all.deb
roundcube_0.7.1-2.debian.tar.gz
  to main/r/roundcube/roundcube_0.7.1-2.debian.tar.gz
roundcube_0.7.1-2.dsc
  to main/r/roundcube/roundcube_0.7.1-2.dsc
roundcube_0.7.1-2_all.deb
  to main/r/roundcube/roundcube_0.7.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 657092@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: Tue, 07 Feb 2012 17:37:52 +0100
Source: roundcube
Binary: roundcube-core roundcube roundcube-mysql roundcube-pgsql roundcube-plugins
Architecture: source all
Version: 0.7.1-2
Distribution: unstable
Urgency: high
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-plugins - skinnable AJAX based webmail solution for IMAP servers - plugins
Closes: 657092
Changes: 
 roundcube (0.7.1-2) unstable; urgency=high
 .
   * Remove roundcube-sqlite package since php5 package does not ship
     SQLite 2.x support anymore. Roundcube is incompatible with SQLite 3.x.
     Closes: #657092.
   * Urgency set to high for php5 migration into testing.
Checksums-Sha1: 
 6e47af88999e798707c6fba0ebb94745aa8ec323 1579 roundcube_0.7.1-2.dsc
 52dded14820679d6bf442ad267b3e9c2c9d67f33 49554 roundcube_0.7.1-2.debian.tar.gz
 2534b1c20ceb0e3ac1aea5aa07bbd80484b108e0 1021806 roundcube-core_0.7.1-2_all.deb
 737d26a1c6c4435daec84f97fc1457f7bda1f82a 27020 roundcube_0.7.1-2_all.deb
 8c8b53ed8795106f40942c272994939176b74b98 26342 roundcube-mysql_0.7.1-2_all.deb
 91cdce200a2bbc6de67cfb396dc5d0c4f3e570bb 26340 roundcube-pgsql_0.7.1-2_all.deb
 113983b395f71d7f72270368d959ef175543ea31 318460 roundcube-plugins_0.7.1-2_all.deb
Checksums-Sha256: 
 74ed6b50fa5e1b22cbbe51b840e69e7a19fb05c20de9ef5573fb0bc3b3f42fa5 1579 roundcube_0.7.1-2.dsc
 92163849151a4fcde9710b1b89fdd8cf377edf977c88db42e654ee57dc2c4282 49554 roundcube_0.7.1-2.debian.tar.gz
 2f399fea5c138ba5fe0af8831b7b1fb260bff8ecf621c346b5e9cbf2ebd23450 1021806 roundcube-core_0.7.1-2_all.deb
 eedd354c5108a20e19ac79a708d8d18ab5ad910cfadb89f7e95c6e0ff45c8264 27020 roundcube_0.7.1-2_all.deb
 c6e4a1e4fc0fd0006075b41c45495362d900cd5edee87994fa2eb22c4d6391cc 26342 roundcube-mysql_0.7.1-2_all.deb
 975448668495a0f47b37a3facfad0e3d5009644ce7a51cadb21790eb7502cc05 26340 roundcube-pgsql_0.7.1-2_all.deb
 7258d195adde6882e66e2ff02abe01d86e9743104d119f2c424b6bb8c2f84f5a 318460 roundcube-plugins_0.7.1-2_all.deb
Files: 
 2f0daf859ea3f7cf4465640a7b4cd5c5 1579 web extra roundcube_0.7.1-2.dsc
 4c4be7c13e8b3da24d4d63226a001867 49554 web extra roundcube_0.7.1-2.debian.tar.gz
 39323f2a039f8b9e86b2a0a715bf8017 1021806 web extra roundcube-core_0.7.1-2_all.deb
 89277847c1bab2e558e42ffeb51c3811 27020 web extra roundcube_0.7.1-2_all.deb
 fc65e49489aa7487ba4a4c6154a70300 26342 web extra roundcube-mysql_0.7.1-2_all.deb
 d3ace408149be8e69358b52e147ad855 26340 web extra roundcube-pgsql_0.7.1-2_all.deb
 f4813ed52bcf569c24a85f01f06ab9c7 318460 web extra roundcube-plugins_0.7.1-2_all.deb

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

iEYEARECAAYFAk8xV7QACgkQKFvXofIqeU6CFQCZAW5HUovefqRHJiyrz/B8dqG7
X+wAn2E/oGRHybHksSJJ7tQxKVJOpwrw
=VgQb
-----END PGP SIGNATURE-----

Send a report that this bug log contains spam.