Sqlite doesn't work on VestaCP

[delicousbob]

Hallo,

is there an easy way to implement sqlite in VestaCP?
I tried to install sqlite on my Debian7 64bit server with apt-get install php5-sqlite and restarted the server,
but it seems not to be loaded by php.

I tried to install TaskBoard on the webspace (http://taskboard.matthewross.me/)
They say that it's only needs PHP5 w/SQLite pdo on the server to get it to work.

Is there a official / proper way to install sqlite on VestaCP?

Thank you and kind regards
Robert

[skurudo]

Show please output and then we talk about what work or what don't work )

Code: Select all

php -m

[skurudo]

I think this case about Requirements:
* A web server running PHP with sqlite enabled. Developed and tested under Apache2 running PHP 5.5+.

* The server must have sqlite and php5-sqlite installed, as well as the rewrite and expires Apache modules.

* Note: For Apache v2.3.9 and later, virtual host for a site should have AllowOverride All for TaskBoard root directory. Otherwise, .htaccess files will be completely ignored.]

[delicousbob]

Thanks skurudo for your rapid response :)
First of all - I love this control panel! :) it works so great!

my "php -m" shows:

SpoilerShow

PHP Deprecated: Comments starting with '#' are deprecated in /etc/php5/cli/conf.d/sqlite3.ini on line 1 in Unknown on line 0
PHP Warning: Module 'sqlite3' already loaded in Unknown on line 0
[PHP Modules]
bcmath
bz2
calendar
Core
ctype
curl
date
dba
dom
ereg
exif
fileinfo
filter
ftp
gd
gettext
hash
iconv
intl
json
libxml
mbstring
mcrypt
mhash
mysql
mysqli
openssl
pcntl
pcre
PDO
pdo_mysql
pdo_sqlite
Phar
posix
pspell
Reflection
session
shmop
SimpleXML
soap
sockets
SPL
sqlite3
standard
sysvmsg
sysvsem
sysvshm
tokenizer
wddx
xml
xmlreader
xmlwriter
zip
zlib

--- > I managed to get Sqlite to work on my system after the activation of the Apache module expires:
here is what i did to get it to work on debian 7x64 with vestacp:

Code: Select all

apt-get install sqlite
apt-get install sqlite3
apt-get install php5-sqlite
service apache2 restart 
//activated the Apache modules:
a2enmod rewrite
a2enmod expires
service apache2 restart

* Note: For Apache v2.3.9 and later, virtual host for a site should have AllowOverride All for TaskBoard root directory. Otherwise, .htaccess files will be completely ignored.
-> i tried to activate AllowOverride All in .htaccess but it after it the page wasn't reachable Error500
without this settings it worked fine :)

I'll test some other scripts that use sqlite if it works at all or just for "Taskboard" and will let you know if it does.
--> Update: Just testet another sqlite app from kanboard.net -> worked fine with sqlite!

Thank you kind regards!
Robert

[skurudo]

First of all - I love this control panel! :) it works so great!

Thanks, we love this panel too ;-)

I managed to get Sqlite to work on my system after the activation of the Apache module expires:
here is what i did to get it to work on debian 7x64 with vestacp

Robert, one question - do you use php 5.4 on your server or newer version?

[delicousbob]

My php version is 5.4 acording to "php -v"

PHP 5.4.39-0+deb7u2 (cli) (built: Mar 25 2015 08:33:29)
Copyright (c) 1997-2014 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2014 Zend Technologies

Thank you for your great work!! It's the best panel out there ;-)

[skurudo]

* Note: For Apache v2.3.9 and later, virtual host for a site should have AllowOverride All for TaskBoard root directory. Otherwise, .htaccess files will be completely ignored.
-> i tried to activate AllowOverride All in .htaccess but it after it the page wasn't reachable Error500
without this settings it worked fine :)

I made a copy from TaskBoard github page, don't tested myself this option.
sqllite work fine with Joomla and some scripts, no doubt :)

[skurudo]

Thank you for your great work!! It's the best panel out there ;-)

Thanks ;-) Glad to help you.