Atomicorp

Posted: **Fri Jun 22, 2012 3:54 am**

Does /usr/lib64/php/modules/sqlite3.so belong to a package? To check: rpm -qf /usr/lib64/php/modules/sqlite3.so

Does either /etc/php.ini or a file in /etc/php.d/ load sqlite3.so? To check: grep extension=sqlite3\.so /etc/php.ini and grep extension=sqlite3\.so /etc/php.d/*

Posted: **Sat Jun 23, 2012 6:15 pm**

Yes, this error only began after the Zend upgrade

Code: Select all

[root@abbey ~]# rpm -qf /usr/lib64/php/modules/sqlite3.so
php-pdo-5.3.14-6.el6.art.x86_64

Yes. sqlite has a home:

Code: Select all

[root@abbey etc]# grep extension=sqlite3\.so /etc/php.ini
[root@abbey etc]# grep extension=sqlite3\.so /etc/php.d/*
/etc/php.d/sqlite3.ini:extension=sqlite3.so

breun wrote:Does /usr/lib64/php/modules/sqlite3.so belong to a package? To check: rpm -qf /usr/lib64/php/modules/sqlite3.so

Does either /etc/php.ini or a file in /etc/php.d/ load sqlite3.so? To check: grep extension=sqlite3\.so /etc/php.ini and grep extension=sqlite3\.so /etc/php.d/*

Posted: **Sun Jun 24, 2012 11:24 am**

"Good news everybody!" (no points for this pop culture reference)

I just did a fresh Centos 6 install then a yum upgrade to get to the latest and greatest everything that was installed by default.

No php is installed by default.

I enabled the atomic repo then did a yum install php php-gd php-pdo BOOM:

Code: Select all

 # php -v
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/sqlite3.so' - /usr/lib64/php/modules/sqlite3.so: undefined symbol: sqlite3_stmt_readonly in Unknown on line 0
PHP 5.3.14 (cli) (built: Jun 14 2012 16:34:56)
Copyright (c) 1997-2012 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2012 Zend Technologies

OK, so what's causing this? Lets see.....

Code: Select all

# yum remove php-pdo
(stuff gets removed)

# php -v

PHP 5.3.14 (cli) (built: Jun 14 2012 16:34:56)
Copyright (c) 1997-2012 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2012 Zend Technologies

So, it is php-pdo's sqlite3.so, is it?

Code: Select all


#yum install php-pdo

# php -v
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/sqlite3.so' - /usr/lib64/php/modules/sqlite3.so: undefined symbol: sqlite3_stmt_readonly in Unknown on line 0
PHP 5.3.14 (cli) (built: Jun 14 2012 16:34:56)
Copyright (c) 1997-2012 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2012 Zend Technologies

Yum. Definitely something screwy about the sqlite3.so that gets loaded when php-pdo is installed.

Now let's look at php-sqlite to see if that has any effect

Code: Select all

# yum install php-sqlite 

# php -v

PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/sqlite3.so' - /usr/lib64/php/modules/sqlite3.so: undefined symbol: sqlite3_stmt_readonly in Unknown on line 0
PHP 5.3.14 (cli) (built: Jun 14 2012 16:34:56)
Copyright (c) 1997-2012 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2012 Zend Technologies


# yum remove php-pdo

# php -v

PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/sqlite3.so' - /usr/lib64/php/modules/sqlite3.so: undefined symbol: sqlite3_stmt_readonly in Unknown on line 0
PHP 5.3.14 (cli) (built: Jun 14 2012 16:34:56)
Copyright (c) 1997-2012 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2012 Zend Technologies

So the same sqlite3.so gets loaded if you have php-sqlite installed and creates the same error.

Therefore there's a problem with the sqlite3.so in php-pdo and php-sqlite in the 5.3.14-6 Centos 6 x86_64 rpms.

I have no explanation as to why this error does not crop up if you upgrade from 5.3.13 or earlier to 5.3.14-6

Faris.

Posted: **Sun Jun 24, 2012 8:04 pm**

At least your efforts duplicated mine and I don't look like a complete and total idiot. Maybe a little...

Posted: **Mon Jul 23, 2012 1:59 am**

This thread is a bit stale - not sure it's still an open issue.

Please take this with a huge grain of salt, but I saw the same error message out of php -i, related to sqlite3.so on CentOS 6. A bit of googling brought me here.

I finally got past it by yum upgrading from sqlite-3.7.0.1-1.el6.art.x86_64 to sqlite-3.7.9-1.el6.art.x86_64. Thought I'd post it in case someone else happens upon this thread while searching that same error message.

Posted: **Mon Jul 23, 2012 9:23 am**

Thanks for the update. I was actually going to come and ask KrazyBob if he'd found a solution. So it sounds like a small issue with the sqlite package and that just needed to be updated? That's great.

It would be nice to hear some good news from KrazyBob .. did things get sorted out in general?

I'm just commissioning some new Virtuozzo servers then migrating all my Containers from the old servers over to them. I expect I'm in for some fun (NOT)

Posted: **Wed Aug 21, 2013 3:05 am**

I get

Code: Select all

PHP Warning:  PHP Startup: Unable to load dynamic library '/var/asl/usr/lib64//php/modules/sqlite3.so' - /var/asl/usr/lib64//php/modules/sqlite3.so: undefined symbol: sqlite3_stmt_readonly in Unknown on line 0

when running aum -u. the rest follows as

Code: Select all

  ASL version is current: 3.2.14-31.el6.art [60G[[1;32mOK[0m]
  APPINV rules are current: 201308071122 [60G[[1;32mOK[0m]
  CLAMAV rules are current: 201308201206 [60G[[1;32mOK[0m]
  GEOMAP rules are current: 201308200913 [60G[[1;32mOK[0m]
  MODSEC rules are current: 201308201652 [60G[[1;32mOK[0m]
  OSSEC rules are current: 201308161428 [60G[[1;32mOK[0m]

everything is current.

Atomicorp

Restoring VZRESTORE to a different IP

Re: Restoring VZRESTORE to a different IP

Re: Restoring VZRESTORE to a different IP

Re: Restoring VZRESTORE to a different IP

Re: Restoring VZRESTORE to a different IP

Re: Restoring VZRESTORE to a different IP

Re: Restoring VZRESTORE to a different IP

Re: Restoring VZRESTORE to a different IP