undefined symbol: sqlite3_libversion

Eli L

Well-Known Member
Aug 9, 2007
61
1
58
Bellingham, Washington, United States
cPanel Access Level
Root Administrator
Can you tell me in more detail the steps I would follow to make this work using EasyApache, FLCLFan?
  1. Edit or Create /var/cpanel/easy/apache/rawopts/all_php5 and put the following in the file
    Code:
    --with-sqlite3=shared
    --with-pdo-sqlite=shared,/usr
  2. Make sure "PDO" is checked in Exhaustive Options List in Easy Apache.
  3. Save and Build

I think I had to manually add "extension=sqlite3.so" to my php.ini file for some reason though.

I think thats about it.
 

morefood2001

Active Member
Mar 18, 2008
28
0
51
This error is still present in PHP 5.3.3.

I simply commented out the extension that is causing this error (no one uses it on the server, thankfully), but now that it is gone, what happens to all the log files? Simple, the errors stay in there until someone cleans them out. I've found that when these customer log files grow too much, it slows down backups and eventually causes grief.

To prevent this (preventative maintenance), Below is an easy to run command as root which cleaned out the error that all my customer log files were showing without affecting their other errors. Note, your non-zts directory may have a different number, so you should double check.

find /home/ -iname 'error_log' -exec \
sed -i '/no-debug-non-zts-20090626/d' {} +

This basically goes through every directory under /home looking for the file error_log. If it finds one, it will run sed on that file. Sed will look through each line of the file for "no-debug-non-zts-20090626", if that is found, it will delete that line from the file and continue scanning. The result is a cleaner log file for all of your customers.
 

mk1200

Registered
Aug 19, 2009
1
0
51
I don't have all_php5: /var/cpanel/easy/apache/rawopts/all_php5

I'm running CentOS 5.5, PHP 5.3.3 and php.ini has these lines:
extension=pdo.so
extension=pdo_sqlite.so
extension=sqlite.so
extension=pdo_mysql.so

How should I fix this?

If this works:
You can get this working with the following configure:

--without-sqlite --with-sqlite3=shared --with-pdo-sqlite=shared,/usr
Can someone spell it out for me? I've never done it manually or ran configure.