On 2017-04-06 10:32 AM, Craig Butosi wrote:
Hi Paul,
*Smacks head* Yep; forgot about the --mail parameter in that script! That's a
much better way!
Hi Craig,
FYI I wrote the following routine that we run every day (the "days"
numbers modified as required and remove "-v" for a cron job):
./bin/cronjobs/cleanup_database.pl --import 1 -v &&
./bin/cronjobs/cleanup_database.pl --mail -v &&
./bin/cronjobs/cleanup_database.pl --sessions -v &&
./bin/cronjobs/cleanup_database.pl --logs 20 -v &&
./bin/cronjobs/cleanup_database.pl --zebraqueue 1 -v
We once went for about three weeks without running it and wondered why
our nightly backups had increased by ~150 Mbs ;={
Best -- Paul
Thanks,
Craig Butosi, MA, MLIS, B Mus (Hons.)
LIBRARY SERVICES MANAGER
THE ROYAL CONSERVATORY
TELUS Centre for Performance and Learning
273 Bloor Street West
Toronto, ON M5S 1W2
416.408.2824 x338
www.rcmusic.ca
-----Original Message-----
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Paul A
Sent: April-06-17 10:20 AM
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] How disable sending email
On 2017-04-06 09:58 AM, Craig Butosi wrote:
Hi all,
Katrin wrote:
But be careful and check and clean the message_queue table before
turning email on again
This is very useful! I never thought to do this should I have to disable koha
email. So, from a command line perspective, would the following SQL statement
achieve this (or be appropriate) in, say, 16.05 on Ubuntu 14.04?
USE {your_koha_sqldb_name_here};
DELETE * FROM message_queue;
We use (as koha_owner):
/usr/share/koha$ ./bin/cronjobs/cleanup_database.pl --mail -v
Best -- Paul
Thanks!
Craig Butosi, MA, MLIS, B Mus (Hons.)
LIBRARY SERVICES MANAGER
THE ROYAL CONSERVATORY
TELUS Centre for Performance and Learning
273 Bloor Street West
Toronto, ON M5S 1W2
416.408.2824 x338
www.rcmusic.ca
-----Original Message-----
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of
Katrin
Sent: April-06-17 2:34 AM
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] How disable sending email
But be careful and check and clean the message_queue table before
turning email on again - you don't want to end up sending out a lot of
outdated emails unexpectedly :)
Katrin
On 05.04.2017 20:09, Eric Bégin wrote:
Tim,
Meanwhile, you can comment out the process_message_queue.pl script
from your cronjob.
Eric
On 2017-04-05 14:01, Jonathan Druart wrote:
Hi Tim,
This is certainly dues to bug 15854.
It has been fixed in all stable releases.
Regards,
Jonathan
On Wed, 5 Apr 2017 at 14:37 Tim Koop <t...@mysouthland.com> wrote:
Our Koha is sending duplicated emails for checkin notices.
Is there an easy way to disable this for everybody until we can
upgrade Koha to get it fixed?
Thanks.
Tim Koop
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
Note: This email message and any attachments are intended only for the use of
the individual to which it is addressed, and may contain information that is
privileged, confidential and exempt from disclosure under applicable law. If
the recipient of this email is not the intended recipient (or the employee or
agent responsible for delivering the email to the intended recipient), you are
hereby notified that any review, dissemination, distribution or copying or
other use of this message is strictly prohibited. If you have received this
communication in error, please notify the sender immediately by return email
and delete this message and attachments from your system, thank you.
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha