Hi Massimo,
Thanks for the quick response. I've since tried the same on another
machine (this time ubuntu linux) and am having the same trouble, this
time there is no dbhash error.
In case anyone wants to verify my troubles, here are the relevant
parts...
[web2py crontab] /applications/cronworks/cron/crontab
*/1 * * * * root *default/crontest
[External crontab] crontab -e
0-59/1 * * * * cd /home/seth/web2py && python web2py.py -M -R
applications/cronworks/controllers/default.py -C -D 1 >> /tmp/
cronworks.output 2>&1
I've tried with and without the -M and -R
[Model] db.py
db.define_table('cron',
db.Field('word', 'string'))
[Controller] default.py - crontest()
def crontest():
print "INSIDE CRONTEST"
db.cron.insert(word='thisisatest')
As with before, I can verify that the method is being run every
minute, and that the insert works when the method is called via the
url.
[cronworks.output]
INFO:root:Hard cron daemon started
DEBUG:root:External cron invocation
DEBUG:root:WEB2PY CRON: Trying to acquire lock
DEBUG:root:WEB2PY CRON: Locked
INFO:root:WEB2PY CRON (ext): Application: cronworks executing
*default/crontest in /home/seth/web2py at 2009-04-04 00:35:02.115734
DEBUG:root:WEB2PY CRON: Releasing cron lock
DEBUG:root:WEB2PY CRON done
INFO:root:WEB2PY CRON Call returned: default applications appear to
be installed already
web2py Enterprise Web Framework
Created by Massimo Di Pierro, Copyright 2007-2009
Version 1.59 (2009-03-16 13:10:16)
Database drivers available: SQLite3
INSIDE CRONTEST
None
Thank you kindly for your time, and keep up the great work with
web2py!
Cheers.
-Seth
On Apr 2, 5:06 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
> I do not know if this is related but sqlite that ships on python for
> macosx has known bugs. This would not be the only one. You should use
> the binary distribution on OSX which does not seem to have these
> problems.
>
> On Apr 2, 6:29 pm, seth <seth.le...@gmail.com> wrote:
>
> > I'm having trouble doing a db.table.insert from an external cron on
> > macosx.
>
> > The system cron file
>
> > 0-59/1 * * * * cd /Users/username/Desktop/appname/web2py && python
> > web2py.py -R applications/appname/controllers/test.py -C -D 1 >> /tmp/
> > cron.output 2>&1
>
> > The crontab file in appname/cron directory
>
> > */10 * * * * root *test/callcron
>
> > I can see the callcron method is successfully being called every ten
> > minutes from the cron.output file.
>
> > But, in cron.output I get the following error
> > WARNING:root:unable to import dbhash
>
> > and none of the db.table.inserts put anything in the database.
> > Although, when I hit the controller/action via the URL everything
> > works fine and I get entries in the database.
>
> > I've also tried the -S appname and -M switches, with no changes.
>
> > I've followed the following posts
>
> >http://groups.google.com/group/web2py/browse_thread/thread/cfe89bfa9d...
>
> > and
>
> >http://groups.google.com/group/web2py/browse_thread/thread/9acf0aae73...
>
> > with the same results.
>
> > I'm new to web2py so I may be missing something obvious :)
>
> > Thanks in advance,
> > -Seth
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
