./script/runner in crontab -e gives "Mysql:Error"

rubyonrails-talk
1

In direct answer to your question, you should be able to use script/ runner from cron. Here's how I do it:

1. log in as the user who owns the crontab 2. cd /to/someplace/other/than/your/rails/directory 3. /full/path/to/rails/root/script/runner -e production "Model.method"

If (3) works as expected, then simply copy that line into your
crontab. Note two things: You MUST specify your environment or live
with the default which is, I believe, development; and you should
quote the method call.

If it doesn't work, look at your production.log and your various
error logs. Don't look at the Web server logs, as there is no
interaction with your Web server. You may get a log entry if you have
invalid database login credentials.

Hope this helps.

2

Couple notes.

1) RailsCron is no longer supported by the author (that's me!). 2) I wrote daemon_generator, as the simplest possible background rails service. Typically, the example workflow is something like "do_my_service;sleep 10". Daemon_generator provides the startup scripts, monitoring, logging, etc. So you don't get cron-like scheduling, but I don't think that's what you want anyways.

-Kyle