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

[Paolo Perfetti]

Dear list,
	I finally found out the problem.

In /opt/zendto/lib/SQLite3.php I've modified line 44 to use SQLite3 
flags as documented in [0]

This is the original line:
if ( ! ($this->database = new SQLite3($sqlitename,0666)) ) {

and this is the working one:
if ( ! ($this->database = new SQLite3($sqlitename, 
SQLITE3_OPEN_READWRITE | SQLITE3_OPEN_CREATE)) ) {

This modification seems to solve my problems and I hope it will be 
useful to others.

Ciao,
	Paolo


[0] http://www.php.net/manual/en/sqlite3.construct.php

On 13/05/2013 18:47, Paolo Perfetti wrote:
> 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
>> ...
>>
>
> _______________________________________________
> ZendTo mailing list
> ZendTo at zend.to
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto
>