That was it!
Best Regards,
-Seth
On Apr 3, 5:52 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
> can you try add
>
> db.commit()
>
> This is not necessary for normal controllers but perhaps it is
> necessary for Cron.
> @Achipa, could you clarify this aspect of cron?
>
> Massimo
>
> On Apr 3, 7:45 pm, seth <seth.le...@gmail.com> wrote:
>
> > 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
-~----------~----~----~----~------~----~------~--~---
