[ZendTo] Re: SQLite3 database is not created and no errors in log file

[Scott B. Anderson]

This is exactly the behavior I found.  Check Julien's response to me.  I didn't get a chance to verify it because I switched to MySQL setup instead and it worked immediately on Ubuntu 12.04 with the recent system upgrade. (so it's closer to the 12.10 than 12.04 release, from what I can tell)

Scott Anderson


-----Original Message-----
From: zendto-bounces at zend.to [mailto:zendto-bounces at zend.to] On Behalf Of Paolo Perfetti
Sent: Monday, May 13, 2013 9:35 AM
To: zendto at zend.to
Subject: [ZendTo] SQLite3 database is not created and no errors in log file

(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
_______________________________________________
ZendTo mailing list
ZendTo at zend.to
http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto
...

-- 
ImproMed LLC
--