[Koha] How disable sending email

[Paul A]

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-bounces at lists.katipo.co.nz] On Behalf Of Paul A
> Sent: April-06-17 10:20 AM
> To: koha at 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-bounces at lists.katipo.co.nz] On Behalf Of
>> Katrin
>> Sent: April-06-17 2:34 AM
>> To: koha at 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 <TimK at 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 at 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.
>
>