[web2py] SQLite WAL (write ahead logging)

2017-12-31 Thread lamest . email . ever
Interested in WAL for concurrency reasons. Any way to set this up with DAL definition? I'm used to it automatically creating the database if it does not exist (migrate=True). -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source co

[web2py] Re: File permission issues when running script as scheduler

2016-06-04 Thread lamest . email . ever
correct Niphlod, I was viewing through the appadmin and the colum names were shifted. It was not the timeout column that had a zero value. I increased the timeout (it was default value of something like 60 seconds) it is working now. Thanks again. On Friday, May 27, 2016 at 12:52:00 AM UTC-7, N

[web2py] Re: File permission issues when running script as scheduler

2016-05-26 Thread lamest . email . ever
Thank you for your response. I did run the scheduler process as www-data and it was able to open the file, however, new error on the database insert. scheduler_run table shows status of TIMEOUT on the task, but the timeout is set to zero, which should be unlimited? This script takes about 5 min

[web2py] File permission issues when running script as scheduler

2016-05-25 Thread lamest . email . ever
I have a simple application whose scheduler automatically backs up rolling log files in a database. There is an option in the controller to manually update whenever you want (rather than waiting for the log to roll). The scheduler task has to handle such cases by comparing two versions of the l