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

[Paolo Perfetti]

Dear Scott,
   regarding Jules' response my db file doesn't exist at all while test 
dropoff files are correctly located under /var/zendto/dropoffs/.
I would love to avoid using MySQL to keep setup simple and 
"self-contained" so I will keep trying to solve this issue.

Paolo

On 13/05/2013 17:12, Scott B. Anderson wrote:
> 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
> ...
>