PDA

View Full Version : Is sqlite disabled by default???


sykkes
03-30-2010, 08:56 PM
I'm using a CloudLinux VPS Image with VPS.net with ISPManager Pro pre-installed on it. I found that when installed, sqlite wasn't enabled so I went into ISPManager's PHP Modules configuration section, and enabled php_pdo and pdo_sqlite as per the php.net documentations. However having done this (and restarted Apache and even reboot the vps) I'm still getting the same "Fatal error: Call to undefined function sqlite_open() in..." error when I try to open an sqlite v2 database in php...I've narrowed it down to being something to do with sqlite not being 'enabled' globally in php, when it was compiled, because if i load a phpinfo file up, I can clearly see in the parameter list "--without-sqlite" so I gathered that here is the problem.

I already asked VPS.net is there a way around this, but now they're expecting me to pay $10 to open a ticket to 'solve' something which should imho be enabled by default. Is there any reason why sqlite is disabled like this (does ISPManager compile php this way by default for whatever reason), or are VPS.net the ones who configured it that way? :???:

Thanks...

slava
03-31-2010, 01:16 AM
What's show php-cgi -m or php -m command ? What operation system you have?

sykkes
03-31-2010, 01:50 AM
"php-cgi -m"
[PHP Modules]
bz2
calendar
ctype
curl
date
dbase
exif
ftp
gettext
gmp
hash
iconv
libxml
mbstring
mime_magic
mysql
mysqli
openssl
pcntl
pcre
PDO
pdo_mysql
pdo_sqlite
posix
pspell
Reflection
session
shmop
SimpleXML
sockets
SPL
standard
sysvmsg
sysvsem
sysvshm
tokenizer
wddx
xml
zlib

[Zend Modules]



"php -m"
[PHP Modules]
bz2
calendar
ctype
curl
date
dbase
exif
ftp
gettext
gmp
hash
iconv
libxml
mbstring
mime_magic
mysql
mysqli
openssl
pcntl
pcre
PDO
pdo_mysql
pdo_sqlite
posix
pspell
Reflection
session
shmop
SimpleXML
sockets
SPL
standard
sysvmsg
sysvsem
sysvshm
tokenizer
wddx
xml
zlib

[Zend Modules]



I have 'CloudLinux' by VPS.net:
2.6.18-264.2.1.el5.7.cloudlinuxxen

sykkes
03-31-2010, 05:50 PM
sorry if i'm rushing you, but any update on this? it's urgent i get my vps back online and i need to know if i'm wasting my time with ISPManager. all i need is sqlite...and yet even with that i have trouble.

sykkes
04-10-2010, 02:21 AM
so no answer to this then? has nobody got an idea, even?

art
04-13-2010, 04:53 AM
You need sqlite extension. Not pod_sqlite. See to http://be.php.net/manual/en/book.sqlite.php

You can try install it from ISPManager - PHP Extensions

sykkes
04-13-2010, 05:07 AM
You need sqlite extension. Not pod_sqlite. See to http://be.php.net/manual/en/book.sqlite.php

You can try install it from ISPManager - PHP Extensions

i have enabled anything i can see named 'sqlite' in the php extensions. otherwise the '--without-sqlite' compilation flag is where the problem lies?

slava
04-13-2010, 07:14 PM
ISPmanager instal the software from repositories of your operating system, we do not compile the given software (such as PHP/Apache/MySQL/MTA).

Possibly it is necessary for you to access in technical support of from whom buy a server for recompilation with flags as you needed (as a variant) or upgrades installed PHP to new version, possible it is "bug" in the old version PHP.