User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:57.0) Gecko/20100101 Firefox/57.0 Build Identifier: php -v PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/pdo_sqlite.so' - /usr/lib64/php/modules/pdo_sqlite.so: undefined symbol: sqlite3_column_table_name in Unknown on line 0 PHP 7.1.10 (cli) (built: Sep 27 2017 05:17:09) ( NTS ) Copyright (c) 1997-2017 The PHP Group Zend Engine v3.1.0, Copyright (c) 1998-2017 Zend Technologies with Zend OPcache v7.1.10, Copyright (c) 1999-2017, by Zend Technologies Reproducible: Always Steps to Reproduce: 1. php -v 2. 3. Actual Results: php -v reproduces startup warning consistently. Expected Results: Expect accessibility to pdo_sqlite driver without complaints. pdo_sqlite should provide support for sqlite
Sorry but I cannot reproduce: $ php -v PHP 7.1.10 (cli) (built: Sep 27 2017 05:17:09) ( NTS ) Copyright (c) 1997-2017 The PHP Group Zend Engine v3.1.0, Copyright (c) 1998-2017 Zend Technologies $ php --modules | grep sql pdo_sqlite sqlite3 Need more information: ldd /usr/lib64/php/modules/pdo_sqlite.so rpm --verify php-pdo sqlite-libs
Needinfo response: ldd /usr/lib64/php/modules/pdo_sqlite.so linux-vdso.so.1 (0x00007ffdbad97000) librt.so.1 => /lib64/librt.so.1 (0x00007fdd7496c000) libsqlite3.so.0 => /usr/local/lib/libsqlite3.so.0 (0x00007fdd7469f000) libc.so.6 => /lib64/libc.so.6 (0x00007fdd742ca000) libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fdd740ab000) libdl.so.2 => /lib64/libdl.so.2 (0x00007fdd73ea7000) /lib64/ld-linux-x86-64.so.2 (0x00007fdd74d7b000) rpm --verify php-pdo sqlite-libs S.5....T. c /etc/php-zts.d/20-sqlite3.ini S.5....T. c /etc/php-zts.d/30-pdo_sqlite.ini Addl. Info: php --modules|grep sql PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/pdo_sqlite.so' - /usr/lib64/php/modules/pdo_sqlite.so: undefined symbol: sqlite3_column_table_name in Unknown on line 0 mysqli mysqlnd pdo_mysql pdo_pgsql pgsql sqlite3 NOTE: Command "dnf list \*sqlite\* |grep pdo" do not return pdo_sqlite
> libsqlite3.so.0 => /usr/local/lib/libsqlite3.so.0 (0x00007fdd7469f000) You are not using system libsqlite, but a manually installed version build with bad options. Sorry, this cannot be supported
Where is compliant Fedora libsqlite version in repo? ALL installed software is from following repos: repo id repo name status PlexHTRepo PlexHTRepo 28 *fedora Fedora 26 - x86_64 53,907 *rpmfusion-free RPM Fusion for Fedora 26 - Free 536 *rpmfusion-free-updates RPM Fusion for Fedora 26 - Free - Updates 172 *rpmfusion-nonfree RPM Fusion for Fedora 26 - Nonfree 174 *rpmfusion-nonfree-updates RPM Fusion for Fedora 26 - Nonfree - Updates 21 *updates Fedora 26 - x86_64 - Updates 9,790 *updates-testing Fedora 26 - x86_64 - Test Updates 2,726 dnf list libsql\*: Last metadata expiration check: 23:55:06 ago on Mon 23 Oct 2017 06:33:39 AM CDT. Installed Packages libsqlite3x.x86_64 20071018-20.fc26 @fedora libsqlite3x-devel.x86_64 20071018-20.fc26 @fedora Available Packages libsqlite3x.i686 20071018-20.fc26 fedora libsqlite3x-devel.i686 20071018-20.fc26 fedora dnf info libsqlite3x Last metadata expiration check: 23:55:22 ago on Mon 23 Oct 2017 06:33:39 AM CDT. Installed Packages Name : libsqlite3x Version : 20071018 Release : 20.fc26 Arch : x86_64 Size : 71 k Source : libsqlite3x-20071018-20.fc26.src.rpm Repo : @System From repo : fedora Summary : A C++ Wrapper for the SQLite3 embeddable SQL database engine URL : http://www.wanderinghorse.net/computing/sqlite/ License : zlib Description : sqlite3 is a slick embedded SQL server written in C. It's easy to : use, powerful, and quite fast. sqlite3x is a C++ wrapper API for : working with sqlite3 databases that uses exceptions.
sqlite-libs is the right package to use. (but /usr/local/lib/... one should be removed, this is a faulty part)
Faulty libsqlite3.so.0 returns after completing following steps: 1. dnf remove php-pdo 2. ldd /usr/lib64/php/modules/pdo_sqlite.so: No such file or directory 3. dnf install php-pdo 4. dnf info php-pdo Last metadata expiration check: 0:26:10 ago on Tue 24 Oct 2017 03:58:42 PM CDT. Installed Packages Name : php-pdo Version : 7.1.10 Release : 1.fc26 Arch : x86_64 Size : 385 k Source : php-7.1.10-1.fc26.src.rpm Repo : @System From repo : updates Summary : A database access abstraction module for PHP applications URL : http://www.php.net/ License : PHP Description : The php-pdo package contains a dynamic shared object that will add : a database access abstraction layer to PHP. This module provides : a common interface for accessing MySQL, PostgreSQL or other : databases. 5. dnf repoquery --installed -l php-pdo /etc/php-zts.d/20-pdo.ini /etc/php-zts.d/20-sqlite3.ini /etc/php-zts.d/30-pdo_sqlite.ini /etc/php.d/20-pdo.ini /etc/php.d/20-sqlite3.ini /etc/php.d/30-pdo_sqlite.ini /usr/lib64/php-zts/modules/pdo.so /usr/lib64/php-zts/modules/pdo_sqlite.so /usr/lib64/php-zts/modules/sqlite3.so /usr/lib64/php/modules/pdo.so /usr/lib64/php/modules/pdo_sqlite.so /usr/lib64/php/modules/sqlite3.so 6. ldd /usr/lib64/php/modules/pdo_sqlite.so linux-vdso.so.1 (0x00007ffff7a61000) librt.so.1 => /lib64/librt.so.1 (0x00007fad3ed33000) libsqlite3.so.0 => /usr/local/lib/libsqlite3.so.0 (0x00007fad3ea66000) libc.so.6 => /lib64/libc.so.6 (0x00007fad3e691000) libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fad3e472000) libdl.so.2 => /lib64/libdl.so.2 (0x00007fad3e26e000) /lib64/ld-linux-x86-64.so.2 (0x00007fad3f142000) 7. dnf downgrade php-pdo ( php-pdo.x86_64 7.1.6-1.fc26) 8. systemctl stop httpd php-fpm 9. systemctl start httpd php-fpm 10. php -v PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/pdo_sqlite.so' - /usr/lib64/php/modules/pdo_sqlite.so: undefined symbol: sqlite3_column_table_name in Unknown on line 0 PHP 7.1.6 (cli) (built: Jun 7 2017 08:46:55) ( NTS ) Copyright (c) 1997-2017 The PHP Group Zend Engine v3.1.0, Copyright (c) 1998-2017 Zend Technologies with Zend OPcache v7.1.6, Copyright (c) 1999-2017, by Zend Technologies What else can I do?
> libsqlite3.so.0 => /usr/local/lib/libsqlite3.so.0 (0x00007fad3ea66000) rm /usr/local/lib/libsqlite3.so.0
This message is a reminder that Fedora 26 is nearing its end of life. Approximately 4 (four) weeks from now Fedora will stop maintaining and issuing updates for Fedora 26. It is Fedora's policy to close all bug reports from releases that are no longer maintained. At that time this bug will be closed as EOL if it remains open with a Fedora 'version' of '26'. Package Maintainer: If you wish for this bug to remain open because you plan to fix it in a currently maintained version, simply change the 'version' to a later Fedora version. Thank you for reporting this issue and we are sorry that we were not able to fix it before Fedora 26 is end of life. If you would still like to see this bug fixed and are able to reproduce it against a later version of Fedora, you are encouraged change the 'version' to a later Fedora version prior this bug is closed as described in the policy above. Although we aim to fix as many bugs as possible during every release's lifetime, sometimes those efforts are overtaken by events. Often a more recent Fedora release includes newer upstream software that fixes bugs or makes them obsolete.
Fedora 26 changed to end-of-life (EOL) status on 2018-05-29. Fedora 26 is no longer maintained, which means that it will not receive any further security or bug fix updates. As a result we are closing this bug. If you can reproduce this bug against a currently maintained version of Fedora please feel free to reopen this bug against that version. If you are unable to reopen this bug, please file a new report against the current release. If you experience problems, please add a comment to this bug. Thank you for reporting this bug and we are sorry it could not be fixed.