Upgrade to Apache2 and PHP5 fails

[gounthar]

Hi,

I've been using Serendipity for more than one year without any problem.
Recently, I decided to upgrade my Linux distribution, and Apache 2.0 moved to 2.4, PHP 4 became PHP 5.
Since then, Serendipity doesn't work anymore, and gives me that message :
PHP Fatal error: Call to undefined function sqlite_open() in /webs/serendipity/include/db/sqlite.inc.php on line 54
In my php.ini, I have :
extension=sqlite.so
The library sqlite can be found at :
/usr/lib/php/extensions/no-debug-non-zts-20060613/sqlite.so

What did I miss?

Thanks in advance.

[garvinhicking]

Hi!

You compiled your PHP5 without SQLite support, so the sqlite.so line in your config doesn'T seem to take effect?

If you create a <?php phpinfo(); ?> script, check if the sqlite info box is there?

Regards,
Garvin

[gounthar]

Hi,

thanks for your answer. In fact, I didn't compile PHP by myself, I used a package from http://www.linuxpackages.net/pkg_details.php?id=9972.
In the README.Slackware, I see some dependencies :
pdo_sqlite.so needs sqlite3 >= 3.3
sqlite.so needs sqlite >= 2.8.17

I do think I have these packages, but I will double check.

I'll try the phpinfo tonight.
Thanks a lot!

Gounthar

[gounthar]

The phpinfo doesn't give me a box for sqlite, but a box for pdo_sqlite.

Configure command :
'--with-sqlite=shared'
After reinstalling the sqlite library, I still have this message when lauching Apache :
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/extensions/no-debug-non-zts-20060613/sqlite.so' - libsqlite.so.0: cannot open shared object file: No such file or directory in Unknown on line 0

[garvinhicking]

Hi!

Sadly this sounds as if you still don't have the libsqlite.so.0 file on your system. Did you recompile PHP after you installed libsqlite?

Maybe you'll need to jump to the PHP forums/newsgroups for help on this.

Regards,
Garvin

[gounthar]

Hi Garvin,

I do have the libsqlite.so.0 file on my system. I'll try to recompile PHP by myself, and see if that solves my problem.
I'll try to find a PHP forum to help me.

Thanks a lot for your help!

Gounthar

[gounthar]

Hi,

finally, I removed all apache, php, sqlite packages, and reinstalled everything from source. It now works.
Thanks for your help.