Hi Paul,

*Smacks head* Yep; forgot about the --mail parameter in that script! That's a 
much better way!

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

Reply via email to