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

[Jules]

Many thanks for finding that, I've corrected the main source and will 
produce an update at some point soon for this fix.

Shout at me if you urgently want an updated package for this fix. :-)

Jules.

On 16/05/2013 12:43, Paolo Perfetti wrote:
> 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
>>
> _______________________________________________
> ZendTo mailing list
> ZendTo at zend.to
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto
>
> Jules
>
> -- 
> Julian Field MEng MBCS CITP CEng
>
> 'It's in Apple's DNA that technology alone is not enough. It's
>   technology married with liberal arts, married with the humanities,
>   that yields us the result that makes our hearts sing.' - Steve Jobs
>
> www.Zend.To
> Twitter: @JulesFM
> PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654