Lighttpd : PHP : Sqlite3

L

lordmor

Hi all,

I have a problem with PHP and Sqlite3 combination running on Lighttpd.

The problem is that when I'm trying to open the webpage I get the following error:
Code: 
Fatal error: Call to undefined function sqlite_open() in /usr/local/www/m4tr1x/db2.php on line 3

But in CLI is everything running okay. I mean when I run:
Code: 
php db2.php

I did some investigation and I found that PHP under Lighttpd is not loading it's .ini file, ...
Code: 
Configuration File (php.ini) Path 	/usr/local/etc 
Loaded Configuration File 	(none) 
Scan this dir for additional .ini files 	/usr/local/etc/php 
additional .ini files parsed 	(none)

...but in CLI it is okay
Code: 
php -i | grep \.ini
Configuration File (php.ini) Path => /usr/local/etc
Loaded Configuration File => /usr/local/etc/php.ini
Scan this dir for additional .ini files => /usr/local/etc/php
additional .ini files parsed => /usr/local/etc/php/extensions.ini
Classes => AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainException, EmptyIterator, FilterIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RegexIterator, RuntimeException, SimpleXMLIterator, SplFileInfo, SplFileObject, SplObjectStorage, SplTempFileObject, UnderflowException, UnexpectedValueException

So this (I think) is why I'm getting the above mentioned error.
Do anyone have idea what could be wrong and how can I fix it?

I tried rebuilding Sqlite, PHP and Lighttpd, but the result is still the same :(

Here is list of PHP, Sqlite and Lighttpd related ports that I have installed on my system:
Code: 
(ttyp2) root@core /usr/local/www/m4tr1x # pkg_version -v | grep php                                                                    21:52:28
php5-5.2.9                          =   up-to-date with port
php5-ctype-5.2.9                    =   up-to-date with port
php5-curl-5.2.9                     =   up-to-date with port
php5-dom-5.2.9                      =   up-to-date with port
php5-extensions-1.3                 =   up-to-date with port
php5-gd-5.2.9                       =   up-to-date with port
php5-imap-5.2.9                     =   up-to-date with port
php5-mbstring-5.2.9                 =   up-to-date with port
php5-mcrypt-5.2.9                   =   up-to-date with port
php5-mysql-5.2.9                    =   up-to-date with port
php5-mysqli-5.2.9                   =   up-to-date with port
php5-pcre-5.2.9                     =   up-to-date with port
php5-pdo-5.2.9                      =   up-to-date with port
php5-pdo_sqlite-5.2.9               =   up-to-date with port
php5-posix-5.2.9                    =   up-to-date with port
php5-session-5.2.9                  =   up-to-date with port
php5-simplexml-5.2.9                =   up-to-date with port
php5-spl-5.2.9                      =   up-to-date with port
php5-sqlite-5.2.9                   =   up-to-date with port
php5-xml-5.2.9                      =   up-to-date with port
php5-xmlreader-5.2.9                =   up-to-date with port
php5-xmlwriter-5.2.9                =   up-to-date with port
php5-zlib-5.2.9                     =   up-to-date with port
(ttyp2) root@core /usr/local/www/m4tr1x # pkg_version -v | grep sqlite                                                                 21:58:43
php5-pdo_sqlite-5.2.9               =   up-to-date with port
php5-sqlite-5.2.9                   =   up-to-date with port
sqlite3-3.6.11                      =   up-to-date with port
(ttyp2) root@core /usr/local/www/m4tr1x # pkg_version -v | grep lighttpd                                                               22:01:29
lighttpd-1.4.22                     =   up-to-date with port

And system related info
Code: 
(ttyp2) root@core /usr/local/www/m4tr1x # uname -a                                                                                     22:02:17
FreeBSD core.m4tr1x.ath.cx 7.1-RELEASE-p4 FreeBSD 7.1-RELEASE-p4 #1: Sat Apr  4 21:01:35 CEST 2009     root@core.matrix.net:/usr/obj/usr/src/sys/CORE  i386


Thanks a lot for any help,
LM
 
Ok, so I fixed the problem with loading .ini files. They are now properly loaded (problem was that webserver didn't had rights for reading those files).

But modules (sqlite and others) are not loaded anyway, any idea about that?


Thanks,
LM
 
Is ``display_startup_errors'' enabled in php.ini?
Anything useful in the lighttpd logfile?

Also, please attach your lighttpd.conf and php.ini.
 
[solved]

Hi Carpetsmoker,

I have "display_startup_errors" disabled, the only thing I could find in log was:

2009-04-15 20:37:06: (mod_fastcgi.c.2618) FastCGI-stderr: PHP Fatal error: Call to undefined function sqlite_open() in /usr/local/www/m4tr1x/test.php on line 5

But finally this issue is solved.
The problem was that the webserver didn't had sufficient rights for reading .ini files and loading modules. I mean that I had to do:

Code: 
#chmod o=r /usr/local/etc/php.ini
#chmod o=rx /usr/local/etc/php
#chmod o=r /usr/local/etc/extensions.ini
#chmod o=rx /usr/local/lib/php
#chmod o=rx /usr/local/lib/php/20060613 //this is where the modules are stored

This was probably caused by having umask set to 027 in .tcshrc

Thank you all for your time.
LM

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
PS: I admit that this was very stupid issue, but I'm still learning :stud
 
This was probably caused by having umask set to 027 in .tcshrc
Click to expand...

Having a umask of 027 is usually fine ... Just not for installing ports.
Always set umask to 022 when installing ports ... In fact, you will get a warning is umask != 022
 
Carpetsmoker said:
In fact, you will get a warning is umask != 022
Click to expand...

Yes I noticed that there is this warning, but I never had a problem so I successfully ignored it. Until now...

So thanks for the advice, I will be changing my umask before building ports from now on and will hope that I won't run into similar problems in the future :)
 
You must log in or register to reply here.
Back
Top