Debian Bug report logs - #437796
php5-sqlite: pdo_sqlite wrongly links to libsqlite3

Toggle useless messages

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

From: "Julien Goodwin" <julieng@strategicdata.com.au>

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

Subject: php5-sqlite: Does not include PDO driver

Date: Tue, 14 Aug 2007 13:24:09 +1000

Package: php5-sqlite
Version: 5.2.3-1+b1
Severity: important

The package appears to not actually include the PDO driver as is claimed
by the description.

-- System Information:
Debian Release: etch/sid
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: i386 (i686)

Kernel: Linux 2.6.22-1-686 (SMP w/2 CPU cores)
Locale: LANG=en_AU.UTF-8, LC_CTYPE=en_AU.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

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

From: Steve Langasek <vorlon@debian.org>

To: Julien Goodwin <julieng@strategicdata.com.au>, 437757-done@bugs.debian.org

Subject: Re: [php-maint] Bug#437757: php5-sqlite: Does not include PDO driver

Date: Mon, 13 Aug 2007 21:38:01 -0700

On Tue, Aug 14, 2007 at 01:24:09PM +1000, Julien Goodwin wrote:
> Package: php5-sqlite
> Version: 5.2.3-1+b1
> Severity: important

> The package appears to not actually include the PDO driver as is claimed
> by the description.

Yes, it does.

$ dpkg -c p/php5/php5-sqlite_5.2.3-1+b1_i386.deb |grep pdo
-rw-r--r-- root/root     19192 2007-06-21 20:59:28 ./usr/lib/php5/20060613+lfs/pdo_sqlite.so
-rw-r--r-- root/root        62 2007-06-21 20:59:26 ./etc/php5/conf.d/pdo_sqlite.ini
$

-- 
Steve Langasek                   Give me a lever long enough and a Free OS
Debian Developer                   to set it on, and I can move the world.
vorlon@debian.org                                   http://www.debian.org/

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

From: Julien Goodwin <julien.goodwin@strategicdata.com.au>

To: control@bugs.debian.org, 437757@bugs.debian.org

Cc: Steve Langasek <vorlon@debian.org>

Subject: Re: [php-maint] Bug#437757: php5-sqlite: Does not include PDO driver

Date: Tue, 14 Aug 2007 15:26:52 +1000

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

reassign 437757 php5-sqlite3
retitle 437757 php5-sqlite3: Should recommend/suggest php5-sqlite for
the PDO driver.
severity 437757 wishlist
thanks

On 14/08/2007 2:38 PM, Steve Langasek wrote:
> On Tue, Aug 14, 2007 at 01:24:09PM +1000, Julien Goodwin wrote:
>> Package: php5-sqlite
>> Version: 5.2.3-1+b1
OK, my bad. I don't know how I screwed that up.

I was somehow confusing php5-sqlite & php5-sqlite3. Now I've sorted that
 it seems obvious that php5-sqlite3 should at least suggest, and ideally
recommend php5-sqlite and add a note to the package description that
php5-sqlite provides the sqlite driver for php5-sqlite3.

Thanks,
Julien

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

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

From: Steve Langasek <vorlon@debian.org>

To: Julien Goodwin <julien.goodwin@strategicdata.com.au>

Cc: 437757@bugs.debian.org

Subject: Re: [php-maint] Bug#437757: php5-sqlite: Does not include PDO driver

Date: Tue, 14 Aug 2007 00:08:20 -0700

clone 437757 -1
reassign -1 php5-sqlite
retitle -1 php5-sqlite: pdo_sqlite wrongly links to libsqlite3
severity -1 important
thanks

On Tue, Aug 14, 2007 at 03:26:52PM +1000, Julien Goodwin wrote:
> reassign 437757 php5-sqlite3
> retitle 437757 php5-sqlite3: Should recommend/suggest php5-sqlite for
> the PDO driver.
> severity 437757 wishlist
> thanks

> On 14/08/2007 2:38 PM, Steve Langasek wrote:
> > On Tue, Aug 14, 2007 at 01:24:09PM +1000, Julien Goodwin wrote:
> >> Package: php5-sqlite
> >> Version: 5.2.3-1+b1
> OK, my bad. I don't know how I screwed that up.

> I was somehow confusing php5-sqlite & php5-sqlite3. Now I've sorted that
>  it seems obvious that php5-sqlite3 should at least suggest, and ideally
> recommend php5-sqlite and add a note to the package description that
> php5-sqlite provides the sqlite driver for php5-sqlite3.

Huh?  No, it shouldn't.  php5-sqlite and php5-sqlite3 are packages for two
different versions of sqlite, there is no reason at all that one should
recommend the other.

But it seems that the pdo module in php5-sqlite is linked against libsqlite3
when it's supposed to be linked against libsqlite0.  This is a result of
libaprutil1-dev pulling in libsqlite3-dev in addition to php5's own
build-dependency on libsqlite0-dev, and preference apparently being given to
the wrong one of the two libraries at build time.

It may be that we should consider a migration from sqlite2 to sqlite3 in
php5 for lenny, but for the moment this is at least a bug for having skew
between pdo_sqlite.so and sqlite.so.

-- 
Steve Langasek                   Give me a lever long enough and a Free OS
Debian Developer                   to set it on, and I can move the world.
vorlon@debian.org                                   http://www.debian.org/

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

From: sean finney <seanius@debian.org>

To: pkg-php-maint@lists.alioth.debian.org

Cc: 495575@bugs.debian.org, 437796@bugs.debian.org

Subject: Re: [php-maint] preparing an upload for php5

Date: Wed, 20 Aug 2008 21:24:22 +0200

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

okay, in a response to the response to myself in response to thijs...

On Wednesday 20 August 2008 08:07:53 pm sean finney wrote:
> On Wednesday 20 August 2008 07:34:20 pm sean finney wrote:
> > On Wednesday 20 August 2008 12:29:37 am Thijs Kinkhorst wrote:
> > > We've got some pending issues in svn including a fix for a serious bug.
> > > Any thoughts about uploading that sometime soon?
> >
> > okay, i'll fire off a build/upload right now :)
>
> er, nix that, there are two more fixes we want first, as raphael pointed
> out to me on irc:
>
> - libmysqlclient_r rollback

is this really necessary?  from my reading of #495575 (added to cc), this only 
affects mixed etch/lenny systems.  furthermore it seems to me that 
libaprutil1 would need to be updated to use the non-_r libmysqlclient as 
well, which hasn't yet happened.

> - sqlite linking problem

as far as i can tell, there isn't a problem here (cc'ing the BR for this too, 
#437796).  there are three sqlite extensions in php:

- sqlite: an sqlite2-api-using extension
- sqlite3: an sqlite3-api-using extension, available via pecl
- pdo_sqlite: an sqlite3-api-using extension that exports a PDO interface

where the first and last are provided by the core php package.

from reading http://www.mail-archive.com/internals@lists.php.net/msg37751.html 
i get the impression that "this is the way it's supposed to be", or at least 
not an important severity bug that needs to be fixed just before the release.


therefore i'm relegating both of these issues to further list discussion, and 
proceeding with the previously aborted build/tag.


	sean

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

Message #50 received at 437796-done@bugs.debian.org (full text, mbox, reply):

From: Raphael Geissert <geissert@debian.org>

To: 437796-done@bugs.debian.org

Subject: Re: Bug#437796: php5-sqlite: pdo_sqlite wrongly links to libsqlite3

Date: Fri, 5 Mar 2010 00:39:57 -0600

Source: php5
Source-Version: 5.3.1-4

As of 5.3.1-4, sqlite, sqlite3 and pdo_sqlite (for sqlite3) are all built and 
shipped in php5-sqlite. Although there was no bug in the first place, with the 
inclusion of the sqlite3 extension everything is provided now.

I'm therefore closing this bug.

Cheers,
-- 
Raphael Geissert - Debian Developer
www.debian.org - get.debian.net

Send a report that this bug log contains spam.