Missing sqlite extension for php53u

[sagi]

The php53u package seems to be missing the sqlite extension. According to the PHP documentation, this extension is enabled by default since PHP 5, so this may break many applications.

[BJ Dierkes (derks)]

Thank you for the report. After a bit of deliberation with my colleague we were able to finally figure out what is going on here with sqlite.

In PHP 5.2, support for SQLite3 was provided by PDO_SQLITE while the -sqlite extension provided support for sqlite2, etc. See [1]. As of PHP 5.3.0 [2], support for SQLite3 is bundled with PHP and enabled by default. Though there is no -sqlite subpackage, if you look at a phpinfo() page you will see both PDO_SQLITE and SQLite3 support enabled:

PDO drivers => mysql, odbc, sqlite
pdo_sqlite
PDO Driver for SQLite 3.x => enabled
SQLite Library => 3.3.6
sqlite3
SQLite3 support => enabled
SQLite3 module version => 0.7-dev
SQLite Library => 3.7.3
sqlite3.extension_dir => no value => no value

Please let us know if you have any further questions about that. To clarify this situation, we will add 'Provides: php53u-sqlite' under php53u-common.

References:

[1] http://www.php.net/manual/en/sqlite.installation.php
[2] http://www.php.net/manual/en/sqlite3.installation.php

[sagi (d-launchpad-sagi-org)]

Thanks. I ran another test and it looks like the sqlite3 extension is available with the CLI package but not with the Apache module. I compared the phpinfo() results of both and the web version is missing the sqlite3 part.

[Jeffrey Ness (jeffrey-ness)]

Thanks for your input sagi,

It does seem I've been able to reproduce what you are mentioning above:

# php -v
PHP 5.3.5 (cli) (built: Feb 10 2011 10:09:20)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies

php-cli shows sqlite3 support
---------------------------------------
# php -i 2>&1 | grep -i sqlite3
sqlite3
SQLite3 support => enabled
SQLite3 module version => 0.7-dev
sqlite3.extension_dir => no value => no value

phpinfo() via mod_php does not
-----------------------------------------------
]# curl localhost | grep -i sqlite3
  % Total % Received % Xferd Average Speed Time Time Time Current
                                 Dload Upload Total Spent Left Speed
100 43903 0 43903 0 0 3394k 0 --:--:-- --:--:-- --:--:-- 8685k
<tr><td class="e">Configure Command </td><td class="v"> &#039;./configure&#039; &#039;--build=x86_64-redhat-linux-gnu&#039; &#039;--host=x86_64-redhat-linux-gnu&#039; &#039;--target=x86_64-redhat-linux-gnu&#039; &#039;--program-prefix=&#039; &#039;--prefix=/usr&#039; &#039;--exec-prefix=/usr&#039; &#039;--bindir=/usr/bin&#039; &#039;--sbindir=/usr/sbin&#039; &#039;--sysconfdir=/etc&#039; &#039;--datadir=/usr/share&#039; &#039;--includedir=/usr/include&#039; &#039;--libdir=/usr/lib64&#039; &#039;--libexecdir=/usr/libexec&#039; &#039;--localstatedir=/var&#039; &#039;--sharedstatedir=/usr/com&#039; &#039;--mandir=/usr/share/man&#039; &#039;--infodir=/usr/share/info&#039; &#039;--cache-file=../config.cache&#039; &#039;--with-libdir=lib64&#039; &#039;--with-config-file-path=/etc&#039; &#039;--with-config-file-scan-dir=/etc/php.d&#039; &#039;--disable-debug&#039; &#039;--with-pic&#039; &#039;--disable-rpath&#039; &#039;--without-pear&#039; &#039;--with-bz2&#039; &#039;--with-exec-dir=/usr/bin&#039; &#039;--with-freetype-dir=/usr&#039; &#039;--with-png-dir=/usr&#039; &#039;--with-xpm-dir=/usr&#039; &#039;--enable-gd-native-ttf&#039; &#039;--with-t1lib=/usr&#039; &#039;--without-gdbm&#039; &#039;--with-gettext&#039; &#039;--with-gmp&#039; &#039;--with-iconv&#039; &#039;--with-jpeg-dir=/usr&#039; &#039;--with-openssl&#039; &#039;--with-pcre-regex&#039; &#039;--with-zlib&#039; &#039;--with-layout=GNU&#039; &#039;--enable-exif&#039; &#039;--enable-ftp&#039; &#039;--enable-magic-quotes&#039; &#039;--enable-sockets&#039; &#039;--enable-sysvsem&#039; &#039;--enable-sysvshm&#039; &#039;--enable-sysvmsg&#039; &#039;--with-kerberos&#039; &#039;--enable-ucd-snmp-hack&#039; &#039;--enable-shmop&#039; &#039;--enable-calendar&#039; &#039;--without-mime-magic&#039; &#039;--without-sqlite&#039; &#039;--with-libxml-dir=/usr&#039; &#039;--with-xml&#039; &#039;--with-system-tzdata&#039; &#039;--with-apxs2=/usr/sbin/apxs&#039; &#039;--without-mysql&#039; &#039;--without-gd&#039; &#039;--disable-dom&#039; &#039;--disable-dba&#039; &#039;--without-unixODBC&#039; &#039;--disable-pdo&#039; &#039;--disable-xmlreader&#039; &#039;--disable-xmlwriter&#039; &#039;--without-sqlite3&#039; &#039;--disable-phar&#039; &#039;--disable-fileinfo&#039; &#039;--disable-json&#039; &#039;--without-pspell&#039; &#039;--disable-wddx&#039; &#039;--without-curl&#039; &#039;--dis...

[Jeffrey Ness (jeffrey-ness)]

Hello sagi,

I have been able to pinpoint the issue causing sqlite3 to not be included in the Apache PHP Module.

A fix for this issue, and the latest source of 5.3.6 have been pushed to the IUS Testing repositories. If you would test out this package and verify functionality we would really appreciate it.

     yum install php53u --enablerepo=ius-testing

Thanks

[Jeffrey Ness (jeffrey-ness)]

A fix for this has been pushed to php53u version 5.3.6-1 which is currently in IUS Stable:

* Thu Mar 17 2011 Jeffrey Ness <email address hidden> - 5.3.6-1.ius
- Latest source from upstream, full changelog available from:
  http://php.net/ChangeLog-5.php#5.3.6
- CVEs addressed: CVE-2011-1153, CVE-2011-1092, CVE-2011-0708, CVE-2011-0421
- Removed: php-5.3.4-bug53512.patch, fixed upstream
- Removed --without-sqlite3 from without_shared, this module is now built
  in and no longer shared