Re: [Koha] How disable sending email

2017-04-06 Thread 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-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


Re: [Koha] How disable sending email

2017-04-06 Thread Craig Butosi
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


Re: [Koha] How disable sending email

2017-04-06 Thread Paul A

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


Re: [Koha] How disable sending email

2017-04-06 Thread Craig Butosi
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;

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
>>> ,
>>> t...@mysouthland.com<mailto:t...@mysouthland.com>
>>> ___
>>> Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz
>>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>>
>> ___
>> Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>
> ___
> Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

___
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


Re: [Koha] How disable sending email

2017-04-06 Thread Stefano Bargioni
Tim, emails are governed by crontabs
/etc/cron.daily/koha-common
/etc/cron.d/koha-common
HTH. Stefano

> 
> 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


Re: [Koha] How disable sending email

2017-04-06 Thread Katrin
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  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
,
t...@mysouthland.com
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] How disable sending email

2017-04-05 Thread Liz Rea
If you installed with packages, you can run

sudo koha-email-disable instancename

where instancename is the name of your instance. This will disable all
emails, including things like hold notices and all of the enhanced notices.

Cheers,
Liz


On 06/04/17 06: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  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
>>> ,
>>> t...@mysouthland.com
>>> ___
>>> Koha mailing list  http://koha-community.org
>>> Koha@lists.katipo.co.nz
>>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>>
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] How disable sending email

2017-04-05 Thread Eric Bégin

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  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
,
t...@mysouthland.com
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] How disable sending email

2017-04-05 Thread Jonathan Druart
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  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
> ,
> t...@mysouthland.com
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] How disable sending email

2017-04-05 Thread Tim Koop
Oh yeah, our version is 3.14.00.000.

I know it's old.  We are planning a new installation "soon".

I tried implementing the patch for bug 15854, but it didn't work.  So now we 
want to just disable all email sending until we get the latest version 
installed.

Is there a quick setting called "Enable/Disable sending email" or something?

Thanks!

--
Tim


-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Tim Koop
Sent: Wednesday, April 05, 2017 12:37 PM
To: koha@lists.katipo.co.nz
Subject: [Koha] How disable sending email

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
,
t...@mysouthland.com
___
Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz 
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha