Just a couple more data points in case they are useful. The -R was indeed unnecessary in the crontab, but it doesn't seem to be the cause of the problem, as db.commit() is still required in order to successfully insert into the database. Also, running the web2py shell (-M -S appname) also requires a db.commit() in order to update the db.
Thanks again, -Seth On Apr 4, 8:23 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > The -R may be causing the problem. Running scripts instead of action > requires manual committing the db. > > On Apr 4, 5:40 am, AchipA <attila.cs...@gmail.com> wrote: > > > BTW Just out of curiosity, why are you calling -R ...test.py in your > > crontab ? It looks fairly redundant to me (you should call it within > > appname'scron/crontab). > > > 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 > > > On Apr 3, 1:29 am, seth <seth.le...@gmail.com> wrote: > > > > I'm having trouble doing a db.table.insert from anexternalcronon > > > macosx. > > > > The systemcronfile > > > > 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/crondirectory > > > > */10 * * * * root *test/callcron > > > > I can see the callcron method is successfully being called every ten > > > minutes from thecron.output file. > > > > But, incron.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 -~----------~----~----~----~------~----~------~--~---
