Hello all, I'm having trouble getting the cleanup_database.pl script to automate. I logged in as koha and typed crontab -e, saved and was informed that a new crontab had been installed. I ran the script manually as koha and it worked perfectly. Here is my crontab: "0 3 * * 2-6 perl /usr/local/src/kohaclone/misc/cronjobs/cleanup_database.pl -v --sessions --zebraqueue 10 >>/var/log/koha/cleanup_database.log" Here is my syslog: "May 19 03:00:01 eucalyptus /USR/SBIN/CRON[15240]: (koha) CMD (perl /usr/local/src/kohaclone/misc/cronjobs/cleanup_database.pl -v --sessions --zebraqueue 10 >>/var/log/koha/cleanup_database.log)" /var/log/koha/cleanup_database.log doesn't get amended. Any obvious issues with my configuration? Any ideas how I can make this work? -- Cheers, Christopher Curry Assistant Technical Librarian / Assistant IT Officer American Philosophical Society 105 South Fifth Street Philadelphia, PA 19106-3386 Tel. (215) 599-4299 ccurry@amphilsoc.org <mailto:ccurry@amphilsoc.org> Main Library number: (215)440-3400 APS website: http://www.amphilsoc.org
Forgot to mention the most important point (maybe it was obvious?): zebraqueue and sessions tables are not being cleared, even though syslog tells me the cmd was run. I wish an error message would output to my log file, at least. As it is, I'm not sure what else to try. I'm not a cron master, so I assume I'm just missing something necessary for cron to function. I've read the cron manual, but I cannot determine what, if anything, I'm missing. Cheers, Christopher Curry Assistant Technical Librarian / Assistant IT Officer American Philosophical Society 105 South Fifth Street Philadelphia, PA 19106-3386 Tel. (215) 599-4299 ccurry@amphilsoc.org <mailto:ccurry@amphilsoc.org> Main Library number: (215)440-3400 APS website: http://www.amphilsoc.org On 05/19/2010 11:34 AM, Christopher Curry wrote:
Hello all,
I'm having trouble getting the cleanup_database.pl script to automate. I logged in as koha and typed crontab -e, saved and was informed that a new crontab had been installed. I ran the script manually as koha and it worked perfectly.
Here is my crontab:
"0 3 * * 2-6 perl /usr/local/src/kohaclone/misc/cronjobs/cleanup_database.pl -v --sessions --zebraqueue 10 >>/var/log/koha/cleanup_database.log"
Here is my syslog:
"May 19 03:00:01 eucalyptus /USR/SBIN/CRON[15240]: (koha) CMD (perl /usr/local/src/kohaclone/misc/cronjobs/cleanup_database.pl -v --sessions --zebraqueue 10 >>/var/log/koha/cleanup_database.log)"
/var/log/koha/cleanup_database.log doesn't get amended.
Any obvious issues with my configuration? Any ideas how I can make this work?
--
Cheers,
Christopher Curry Assistant Technical Librarian / Assistant IT Officer
American Philosophical Society 105 South Fifth Street Philadelphia, PA 19106-3386 Tel. (215) 599-4299
ccurry@amphilsoc.org <mailto:ccurry@amphilsoc.org>
Main Library number: (215)440-3400 APS website: http://www.amphilsoc.org
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
On 5/19/2010 10:34 AM, Christopher Curry wrote: ...
Here is my crontab:
"0 3 * * 2-6 perl /usr/local/src/kohaclone/misc/cronjobs/cleanup_database.pl -v --sessions --zebraqueue 10 >>/var/log/koha/cleanup_database.log" ...
Any obvious issues with my configuration? Any ideas how I can make this work?
Your crontab example doesn't show you setting the environmental variables that may be needed (PERL5LIB and KOHA_CONF). See the examples from the web page below and modify the paths as needed for your system. You likely have these variables specified for your shell (so running the same command from the shell works), but cron needs these values too. http://wiki.koha.org/doku.php?id=en:development:cronjobs Also, this may not apply to your OS, but whenever I have cron issues on FreeBSD, ensuring that absolute paths are specified can help. So I'd personally use "/usr/bin/perl" as the command, not just "perl", or even skip that entirely and let the system figure it out from the specified script's #! line (again, YMMV with OS flavor). -- Greg Barniskis, Computer Systems Integrator South Central Library System (SCLS) <gregb at scls.lib.wi.us>, (608) 242-4716
Greg, Thanks for the point in the right direction. I totally forgot about the ENV variables. That will probably take care of it and it explains why the script didn't run. I wish I could have seen the error message about not being about to find the perl modules. I would have recognized it. Cheers, Christopher Curry Assistant Technical Librarian / Assistant IT Officer American Philosophical Society 105 South Fifth Street Philadelphia, PA 19106-3386 Tel. (215) 599-4299 ccurry@amphilsoc.org <mailto:ccurry@amphilsoc.org> Main Library number: (215)440-3400 APS website: http://www.amphilsoc.org On 05/19/2010 12:15 PM, Greg Barniskis wrote:
On 5/19/2010 10:34 AM, Christopher Curry wrote: ...
Here is my crontab:
"0 3 * * 2-6 perl /usr/local/src/kohaclone/misc/cronjobs/cleanup_database.pl -v --sessions --zebraqueue 10 >>/var/log/koha/cleanup_database.log" ...
Any obvious issues with my configuration? Any ideas how I can make this work?
Your crontab example doesn't show you setting the environmental variables that may be needed (PERL5LIB and KOHA_CONF). See the examples from the web page below and modify the paths as needed for your system. You likely have these variables specified for your shell (so running the same command from the shell works), but cron needs these values too.
http://wiki.koha.org/doku.php?id=en:development:cronjobs
Also, this may not apply to your OS, but whenever I have cron issues on FreeBSD, ensuring that absolute paths are specified can help. So I'd personally use "/usr/bin/perl" as the command, not just "perl", or even skip that entirely and let the system figure it out from the specified script's #! line (again, YMMV with OS flavor).
setting MAILTO=youremailaddress might get you some error reports as well -reed 2010/5/20 Christopher Curry <ccurry@amphilsoc.org>:
Greg,
Thanks for the point in the right direction. I totally forgot about the ENV variables. That will probably take care of it and it explains why the script didn't run. I wish I could have seen the error message about not being about to find the perl modules. I would have recognized it.
Cheers,
Christopher Curry Assistant Technical Librarian / Assistant IT Officer
American Philosophical Society 105 South Fifth Street Philadelphia, PA 19106-3386 Tel. (215) 599-4299
ccurry@amphilsoc.org
Main Library number: (215)440-3400 APS website: http://www.amphilsoc.org
On 05/19/2010 12:15 PM, Greg Barniskis wrote:
On 5/19/2010 10:34 AM, Christopher Curry wrote: ...
Here is my crontab:
"0 3 * * 2-6 perl /usr/local/src/kohaclone/misc/cronjobs/cleanup_database.pl -v --sessions --zebraqueue 10 >>/var/log/koha/cleanup_database.log"
...
Any obvious issues with my configuration? Any ideas how I can make this work?
Your crontab example doesn't show you setting the environmental variables that may be needed (PERL5LIB and KOHA_CONF). See the examples from the web page below and modify the paths as needed for your system. You likely have these variables specified for your shell (so running the same command from the shell works), but cron needs these values too.
http://wiki.koha.org/doku.php?id=en:development:cronjobs
Also, this may not apply to your OS, but whenever I have cron issues on FreeBSD, ensuring that absolute paths are specified can help. So I'd personally use "/usr/bin/perl" as the command, not just "perl", or even skip that entirely and let the system figure it out from the specified script's #! line (again, YMMV with OS flavor).
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
setting as an envariable in the crontab I should say -reed On Thu, May 20, 2010 at 8:55 AM, Reed Wade <reed@catalyst.net.nz> wrote:
setting MAILTO=youremailaddress might get you some error reports as well
-reed
2010/5/20 Christopher Curry <ccurry@amphilsoc.org>:
Greg,
Thanks for the point in the right direction. I totally forgot about the ENV variables. That will probably take care of it and it explains why the script didn't run. I wish I could have seen the error message about not being about to find the perl modules. I would have recognized it.
Cheers,
Christopher Curry Assistant Technical Librarian / Assistant IT Officer
American Philosophical Society 105 South Fifth Street Philadelphia, PA 19106-3386 Tel. (215) 599-4299
ccurry@amphilsoc.org
Main Library number: (215)440-3400 APS website: http://www.amphilsoc.org
On 05/19/2010 12:15 PM, Greg Barniskis wrote:
On 5/19/2010 10:34 AM, Christopher Curry wrote: ...
Here is my crontab:
"0 3 * * 2-6 perl /usr/local/src/kohaclone/misc/cronjobs/cleanup_database.pl -v --sessions --zebraqueue 10 >>/var/log/koha/cleanup_database.log"
...
Any obvious issues with my configuration? Any ideas how I can make this work?
Your crontab example doesn't show you setting the environmental variables that may be needed (PERL5LIB and KOHA_CONF). See the examples from the web page below and modify the paths as needed for your system. You likely have these variables specified for your shell (so running the same command from the shell works), but cron needs these values too.
http://wiki.koha.org/doku.php?id=en:development:cronjobs
Also, this may not apply to your OS, but whenever I have cron issues on FreeBSD, ensuring that absolute paths are specified can help. So I'd personally use "/usr/bin/perl" as the command, not just "perl", or even skip that entirely and let the system figure it out from the specified script's #! line (again, YMMV with OS flavor).
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Has anyone devised a tutorial for staff using the KOHA catalog? Sample questions, searches, etc.? Thanks, Barbara L. Keef Reference & Technology Librarian Windham Public Library 217 Windham Center Rd. Windham, Maine 04062 207-892-1908
Barbara, First, it's Koha - not KOHA - it's a maori word, not an acronym. As for tutorials you can find the manual here: http://koha-community.org/documentation/ And then links to other documentation here: http://koha-community.org/documentation/other-docs/ Thanks Nicole C. Engard Documentation Manager On Wed, May 19, 2010 at 12:55 PM, Barbara Keef <bkeef@windham.lib.me.us> wrote:
Has anyone devised a tutorial for staff using the KOHA catalog? Sample questions, searches, etc.?
Thanks, Barbara L. Keef Reference & Technology Librarian Windham Public Library 217 Windham Center Rd. Windham, Maine 04062 207-892-1908
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hi Nicole, Useful links but those are not tutorials. And the only tutorials I see seem to focus on installation. Surely there are actual tutorials for circ staff??! We created some generic training exercises for Evergreen and they might be modifiable for Koha without too much trouble. Would that help, Barbara? Lori On Wed, May 19, 2010 at 10:19 AM, Nicole Engard <nengard@gmail.com> wrote:
Barbara,
First, it's Koha - not KOHA - it's a maori word, not an acronym.
As for tutorials you can find the manual here: http://koha-community.org/documentation/
And then links to other documentation here: http://koha-community.org/documentation/other-docs/
Thanks Nicole C. Engard Documentation Manager
On Wed, May 19, 2010 at 12:55 PM, Barbara Keef <bkeef@windham.lib.me.us> wrote:
Has anyone devised a tutorial for staff using the KOHA catalog? Sample questions, searches, etc.?
Thanks, Barbara L. Keef Reference & Technology Librarian Windham Public Library 217 Windham Center Rd. Windham, Maine 04062 207-892-1908
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Thanks, Lori for your comment. The tutorials are good, but we were looking for something like the most common questions asked by our users and the easiest and most accurate way to get to the answers. Questions such as "What's the latest James Patterson book your library has? What children's books are about boys sharing an adventure? Are your generic training exercises along those lines? Thanks! Barbara ----- Original Message ----- From: Lori Bowen Ayre To: Nicole Engard Cc: Barbara Keef ; Koha List Sent: Wednesday, May 19, 2010 4:00 PM Subject: Re: [Koha] Tutorial: Using the KOHA catalog Hi Nicole, Useful links but those are not tutorials. And the only tutorials I see seem to focus on installation. Surely there are actual tutorials for circ staff??! We created some generic training exercises for Evergreen and they might be modifiable for Koha without too much trouble. Would that help, Barbara? Lori On Wed, May 19, 2010 at 10:19 AM, Nicole Engard <nengard@gmail.com> wrote: Barbara, First, it's Koha - not KOHA - it's a maori word, not an acronym. As for tutorials you can find the manual here: http://koha-community.org/documentation/ And then links to other documentation here: http://koha-community.org/documentation/other-docs/ Thanks Nicole C. Engard Documentation Manager On Wed, May 19, 2010 at 12:55 PM, Barbara Keef <bkeef@windham.lib.me.us> wrote: > Has anyone devised a tutorial for staff using the KOHA catalog? Sample > questions, searches, etc.? > > Thanks, > Barbara L. Keef > Reference & Technology Librarian > Windham Public Library > 217 Windham Center Rd. > Windham, Maine 04062 > 207-892-1908 > > _______________________________________________ > Koha mailing list > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Barbara, Not so much. The exercises we developed were more about handling common circ functions and helping users with their accounts. On Wed, May 19, 2010 at 1:32 PM, Barbara Keef <bkeef@windham.lib.me.us>wrote:
Thanks, Lori for your comment. The tutorials are good, but we were looking for something like the most common questions asked by our users and the easiest and most accurate way to get to the answers. Questions such as "What's the latest James Patterson book your library has? What children's books are about boys sharing an adventure?
Are your generic training exercises along those lines?
Thanks!
Barbara
----- Original Message ----- *From:* Lori Bowen Ayre <lori.ayre@galecia.com> *To:* Nicole Engard <nengard@gmail.com> *Cc:* Barbara Keef <bkeef@windham.lib.me.us> ; Koha List<koha@lists.katipo.co.nz> *Sent:* Wednesday, May 19, 2010 4:00 PM *Subject:* Re: [Koha] Tutorial: Using the KOHA catalog
Hi Nicole,
Useful links but those are not tutorials. And the only tutorials I see seem to focus on installation. Surely there are actual tutorials for circ staff??!
We created some generic training exercises for Evergreen and they might be modifiable for Koha without too much trouble.
Would that help, Barbara?
Lori
On Wed, May 19, 2010 at 10:19 AM, Nicole Engard <nengard@gmail.com> wrote:
Barbara,
First, it's Koha - not KOHA - it's a maori word, not an acronym.
As for tutorials you can find the manual here: http://koha-community.org/documentation/
And then links to other documentation here: http://koha-community.org/documentation/other-docs/
Thanks Nicole C. Engard Documentation Manager
On Wed, May 19, 2010 at 12:55 PM, Barbara Keef <bkeef@windham.lib.me.us> wrote:
Has anyone devised a tutorial for staff using the KOHA catalog? Sample questions, searches, etc.?
Thanks, Barbara L. Keef Reference & Technology Librarian Windham Public Library 217 Windham Center Rd. Windham, Maine 04062 207-892-1908
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
The training materials on the NEKLS site are all tutorials - and the videos are tutorials as well - so while the manual isn't a tutorial - the links on other docs have lots of tutorials. And the manual itself is written the same way i did the training so many have used it to create their tutorials. Nicole On Wed, May 19, 2010 at 4:00 PM, Lori Bowen Ayre <lori.ayre@galecia.com> wrote:
Hi Nicole, Useful links but those are not tutorials. And the only tutorials I see seem to focus on installation. Surely there are actual tutorials for circ staff??! We created some generic training exercises for Evergreen and they might be modifiable for Koha without too much trouble. Would that help, Barbara? Lori
On Wed, May 19, 2010 at 10:19 AM, Nicole Engard <nengard@gmail.com> wrote:
Barbara,
First, it's Koha - not KOHA - it's a maori word, not an acronym.
As for tutorials you can find the manual here: http://koha-community.org/documentation/
And then links to other documentation here: http://koha-community.org/documentation/other-docs/
Thanks Nicole C. Engard Documentation Manager
On Wed, May 19, 2010 at 12:55 PM, Barbara Keef <bkeef@windham.lib.me.us> wrote:
Has anyone devised a tutorial for staff using the KOHA catalog? Sample questions, searches, etc.?
Thanks, Barbara L. Keef Reference & Technology Librarian Windham Public Library 217 Windham Center Rd. Windham, Maine 04062 207-892-1908
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Thanks for the clarification Nicole! On Wed, May 19, 2010 at 2:02 PM, Nicole Engard <nengard@gmail.com> wrote:
The training materials on the NEKLS site are all tutorials - and the videos are tutorials as well - so while the manual isn't a tutorial - the links on other docs have lots of tutorials.
And the manual itself is written the same way i did the training so many have used it to create their tutorials.
Nicole
On Wed, May 19, 2010 at 4:00 PM, Lori Bowen Ayre <lori.ayre@galecia.com> wrote:
Hi Nicole, Useful links but those are not tutorials. And the only tutorials I see seem to focus on installation. Surely there are actual tutorials for circ staff??! We created some generic training exercises for Evergreen and they might be modifiable for Koha without too much trouble. Would that help, Barbara? Lori
On Wed, May 19, 2010 at 10:19 AM, Nicole Engard <nengard@gmail.com> wrote:
Barbara,
First, it's Koha - not KOHA - it's a maori word, not an acronym.
As for tutorials you can find the manual here: http://koha-community.org/documentation/
And then links to other documentation here: http://koha-community.org/documentation/other-docs/
Thanks Nicole C. Engard Documentation Manager
On Wed, May 19, 2010 at 12:55 PM, Barbara Keef <bkeef@windham.lib.me.us
wrote:
Has anyone devised a tutorial for staff using the KOHA catalog? Sample questions, searches, etc.?
Thanks, Barbara L. Keef Reference & Technology Librarian Windham Public Library 217 Windham Center Rd. Windham, Maine 04062 207-892-1908
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hi everyone I've been developing some staff tutorials for Horowhenua Librarians who are (brave souls!) going live with Koha 3.2 next week. Give me a few more days to polish them, and I'll send them out. Cheers Rosalie 2010/5/20 Lori Bowen Ayre <lori.ayre@galecia.com>
Thanks for the clarification Nicole!
On Wed, May 19, 2010 at 2:02 PM, Nicole Engard <nengard@gmail.com> wrote:
The training materials on the NEKLS site are all tutorials - and the videos are tutorials as well - so while the manual isn't a tutorial - the links on other docs have lots of tutorials.
And the manual itself is written the same way i did the training so many have used it to create their tutorials.
Nicole
On Wed, May 19, 2010 at 4:00 PM, Lori Bowen Ayre <lori.ayre@galecia.com> wrote:
Hi Nicole, Useful links but those are not tutorials. And the only tutorials I see seem to focus on installation. Surely there are actual tutorials for circ staff??! We created some generic training exercises for Evergreen and they might be modifiable for Koha without too much trouble. Would that help, Barbara? Lori
On Wed, May 19, 2010 at 10:19 AM, Nicole Engard <nengard@gmail.com> wrote:
Barbara,
First, it's Koha - not KOHA - it's a maori word, not an acronym.
As for tutorials you can find the manual here: http://koha-community.org/documentation/
And then links to other documentation here: http://koha-community.org/documentation/other-docs/
Thanks Nicole C. Engard Documentation Manager
On Wed, May 19, 2010 at 12:55 PM, Barbara Keef <
bkeef@windham.lib.me.us>
wrote:
Has anyone devised a tutorial for staff using the KOHA catalog? Sample questions, searches, etc.?
Thanks, Barbara L. Keef Reference & Technology Librarian Windham Public Library 217 Windham Center Rd. Windham, Maine 04062 207-892-1908
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hello Moderator I've been posting to this list for 10 years. How come I've been dropped? Rosalie Blake
I'd be very interested in your tutorials. I've been trying to make sure our training materials are up to date on NExpress. Here's the link to our most recent training - last week! http://www.nexpresslibrary.org/may-2010-training/ - Sharon (NEKLS/NExpress) 2010/5/20 Rosalie Blake <rosablake@gmail.com>
Hi everyone I've been developing some staff tutorials for Horowhenua Librarians who are (brave souls!) going live with Koha 3.2 next week. Give me a few more days to polish them, and I'll send them out. Cheers Rosalie
2010/5/20 Lori Bowen Ayre <lori.ayre@galecia.com>
Thanks for the clarification Nicole!
On Wed, May 19, 2010 at 2:02 PM, Nicole Engard <nengard@gmail.com> wrote:
The training materials on the NEKLS site are all tutorials - and the videos are tutorials as well - so while the manual isn't a tutorial - the links on other docs have lots of tutorials.
And the manual itself is written the same way i did the training so many have used it to create their tutorials.
Nicole
On Wed, May 19, 2010 at 4:00 PM, Lori Bowen Ayre <lori.ayre@galecia.com> wrote:
Hi Nicole, Useful links but those are not tutorials. And the only tutorials I see seem to focus on installation. Surely there are actual tutorials for circ staff??! We created some generic training exercises for Evergreen and they might be modifiable for Koha without too much trouble. Would that help, Barbara? Lori
On Wed, May 19, 2010 at 10:19 AM, Nicole Engard <nengard@gmail.com> wrote:
Barbara,
First, it's Koha - not KOHA - it's a maori word, not an acronym.
As for tutorials you can find the manual here: http://koha-community.org/documentation/
And then links to other documentation here: http://koha-community.org/documentation/other-docs/
Thanks Nicole C. Engard Documentation Manager
On Wed, May 19, 2010 at 12:55 PM, Barbara Keef <
bkeef@windham.lib.me.us>
wrote:
Has anyone devised a tutorial for staff using the KOHA catalog? Sample questions, searches, etc.?
Thanks, Barbara L. Keef Reference & Technology Librarian Windham Public Library 217 Windham Center Rd. Windham, Maine 04062 207-892-1908
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Sharon Moreland Technology Consultant Northeast Kansas Library System
participants (8)
-
Barbara Keef -
Christopher Curry -
Greg Barniskis -
Lori Bowen Ayre -
Nicole Engard -
Reed Wade -
Rosalie Blake -
Sharon Moreland