Edit report at https://bugs.php.net/bug.php?id=48614&edit=1
ID: 48614
Comment by: seyferseed at mail dot ru
Reported by: kaspernj at gmail dot com
Summary: Loading "pdo_sqlite.so" fails: undefined symbol:
sqlite3_libversion
Status: Assigned
Type: Bug
Package: PDO related
Operating System: Ubuntu Jaunty
PHP Version: 5.3.0RC4
Assigned To: scottmac
Block user comment: N
Private report: N
New Comment:
I have this bug on PHP 5.5.3-1ubuntu2 (cli) (built: Oct 9 2013 14:49:12)
PHP Warning: PHP Startup: Unable to load dynamic library
'/usr/lib/php5/20121212/pdo_sqlite.so' - /usr/lib/php5/20121212/pdo_sqlite.so: undefined
symbol: php_pdo_unregister_driver in Unknown on line 0
Previous Comments:
------------------------------------------------------------------------
[2013-08-12 16:40:32] michaeld at owl-online dot de
"Bug" still exists in php-5.4.17:
WÃRK-ARAUND (four us) ;-):
1. install sqlite3-devel
2. use this in you configure command (add /usr)
--with-pdo-sqlite=shared,/usr
Cheers,
MD
------------------------------------------------------------------------
[2012-06-27 10:29:25] rs at bytecamp dot net
This bug still exists in PHP-5.4.4.
When will it ever be fixed?
------------------------------------------------------------------------
[2012-06-13 02:43:34] kris dot glynn at virginaustralia dot com
I've just ran into this exact issue compiling php-5.3.13
I used..
--without-sqlite --with-sqlite3=shared --with-pdo-sqlite=shared
.. which still produced the "undefined symbol: sqlite3_libversion" error.
It wasn't until I tried the patch above to configure script from "jd at cpanel dot
net" that the error goes away.
My question is why are we still having to do this with php-5.3.13 ? Am I missing something ?
My exact configure options are below..
./configure --with-apxs2=/data/www2/apache/bin/apxs --prefix=/data/www2/apache
--with-config-file-path=/data/www2/apache/php --with-openssl=/data/www2/apache
--with-curl=/data/www2/apache --with-gd --enable-gd-native-ttf --with-png-dir=/data/www2/apache
--with-jpeg-dir=/data/www2/apache --with-freetype-dir=/data/www2/apache --with-xpm-dir=/usr/X11R6/
--with-zlib-dir=/data/www2/apache --with-oci8=instantclient,/usr/lib/oracle/10.2.0.4/client/lib
--with-libxml-dir=/data/www2/apache --with-mysql=/data/www2/apache --with-ldap=/data/www2/apache
--with-pear=$BASE_PATH/pear/ --enable-pdo=shared --without-sqlite --with-sqlite3=shared
--with-pdo-sqlite=shared --with-pdo-oci=shared,instantclient,/usr,10.2.0.4
--with-pdo-mysql=shared,/data/www2/apache --with-mcrypt=/data/www2/apache
(all the dependencies for php as you can see above exist in /data/www2/apache)
------------------------------------------------------------------------
[2010-10-14 19:21:32] jd at cpanel dot net
The problem is that pdo_sqlite compiles against the embedded copy of sqlite3 but doesn't
include the sqlite3 object files in the final pdo_sqlite.so.
Ugly patch directly against the configure script:
--- php-5.3.3.orig/configure 2010-07-21 05:53:06.000000000 -0500
+++ php-5.3.3/configure 2010-10-14 09:40:17.000000000 -0500
@@ -75183,6 +75183,12 @@
else
# use bundled libs
+
+ # This change is anchored here to avoid patch being misapplied. This really only needs to be
added
+ # when pdo_sqlite is compiled shared and using the bundled sqlite3. It shouldn't hurt
so long as the
+ # bundled sqlite3 is used though.
+ shared_objects_pdo_sqlite="$shared_objects_pdo_sqlite
ext/sqlite3/libsqlite/sqlite3.lo"
+
if test "$enable_maintainer_zts" = "yes"; then
threadsafe_flags="-DSQLITE_THREADSAFE=1"
else
------------------------------------------------------------------------
[2010-06-08 12:52:20] kontakt at beberlei dot de
You can get this working with the following configure:
--without-sqlite --with-sqlite3=shared --with-pdo-sqlite=shared,/usr
More information in this thread: http://news.php.net/php.pdo/427
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
https://bugs.php.net/bug.php?id=48614
--
Edit this bug report at https://bugs.php.net/bug.php?id=48614&edit=1