[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