[ZendTo] SQLite3 database is not created and no errors in log file
Paolo Perfetti
paolo.perfetti at bo.ingv.it
Mon May 13 15:35:28 BST 2013
(I've seen a recent messages with similar symptoms but I'm not sure
situation is the same [0])
I'm using SQLite3 as backend but ZendTo (fresh install) seems not able
to create the database file (no sqlite file in the default directory
/var/zendto/). Permissions seem corrects and there is no problem writing
log file located in the same directory.
root at web-stuff:/opt/zendto/lib# ls -sla /var/zendto/
total 52
4 drwxrwxr-x 7 www-data www-data 4096 mag 13 16:00 .
4 drwxr-xr-x 13 root root 4096 mag 10 17:15 ..
4 drwxrwxrwx 2 www-data www-data 4096 mag 13 16:00 db
4 drwxr-xr-x 7 www-data www-data 4096 mag 13 14:57 dropoffs
4 drwxr-xr-x 2 www-data www-data 4096 mag 13 14:57 incoming
4 drwxr-xr-x 2 www-data www-data 4096 feb 19 22:54 library
4 drwxr-xr-x 2 www-data www-data 4096 mag 10 17:15 rrd
24 -rw-r--r-- 1 www-data www-data 19085 mag 13 16:00 zendto.log
I've investigated adding some debug print in /opt/zendto/lib/SQLite3.php
and it seems to correctly execute DBConnect and DBSetupDatabase
functions (in fact my /var/zend/zend.log is full of
"[ZendTo]: initial setup of database complete" messages)
No errors are showing in apache error log.
Is it possible that it doesn't flush the database to disk after creating
it?
I'm testing it on an amd64 Debian testing box and I paste some relevant
information below:
apache2 2.2.22-13
apache2-doc 2.2.22-13
apache2-mpm-prefork 2.2.22-13
apache2-utils 2.2.22-13
apache2.2-bin 2.2.22-13
apache2.2-common 2.2.22-13
libapache2-mod-php5 5.4.4-14
php5 5.4.4-14
php5-common 5.4.4-14
php5-sqlite 5.4.4-14
zendto 4.11-9
zendto-repo 1.1-1
root at web-stuff:/opt/zendto/lib# cat /etc/apt/sources.list.d/zendto.list
deb http://zend.to/apt lynx main
Thanks for your help,
Paolo
[0] http://mailman.ecs.soton.ac.uk/pipermail/zendto/2013-May/002102.html
More information about the ZendTo
mailing list