Re: Postfix + Dovecot (+MySQL)

2016-09-21 Thread Andrew Pam via luv-main
On 21/09/16 22:51, Russell Coker via luv-main wrote:
> For my clients the number of vacation requests has been small enough that 
> it's 
> easier to just have them email or SMS me when they want it set up.

Yeah, that's what I do also.

Cheers,
Andrew
___
luv-main mailing list
luv-main@luv.asn.au
https://lists.luv.asn.au/cgi-bin/mailman/listinfo/luv-main


Re: Postfix + Dovecot (+MySQL)

2016-09-21 Thread Russell Coker via luv-main
On Wednesday, 21 September 2016 9:40:53 PM AEST Erik Christiansen via luv-main 
wrote:
> > On Tuesday, 20 September 2016 9:00:08 AM AEST Piers Rowan via luv-main 
wrote:
> > > The only thing left to do is set up vacation emails - any suggestions?
> > > Preferably with a way for users to manage them themselves (bearing in
> > > mind
> > > the Dovecot / SASL / MySQL thingo)
> > 
> > Never tried it, but I just found this with a quick search:
> > 
> > http://vacation-web.sourceforge.net/
> 
> Back in the day, vacation would create .forward, and run
> vi vacation.msg
> What more could one want?

Given that users are unable to run a command-line program like "vacation" 
nowadays a web based interface such as vacation-web is what Piers probably 
needs.  Whether vacation-web works as is desired is the issue.

For my clients the number of vacation requests has been small enough that it's 
easier to just have them email or SMS me when they want it set up.

-- 
My Main Blog http://etbe.coker.com.au/
My Documents Bloghttp://doc.coker.com.au/

___
luv-main mailing list
luv-main@luv.asn.au
https://lists.luv.asn.au/cgi-bin/mailman/listinfo/luv-main


Re: Postfix + Dovecot (+MySQL)

2016-09-21 Thread Chris Samuel via luv-main
On Wednesday, 21 September 2016 9:40:53 PM AEST Erik Christiansen via luv-main 
wrote:

> On debian, there is also:
> 
> $ apt-cache search vacation

Fedora/RHEL use the port of the 386bsd vacation program, the maintainer of 
which you may be familiar with (not that I've had to do much maintenance 
recently!).

http://www.csamuel.org/software/vacation

The Debian one is nice too, I actually use that on my home VM as it's Debian 
based. :-)

cheers,
Chris
-- 
 Chris Samuel  :  http://www.csamuel.org/  :  Melbourne, VIC

___
luv-main mailing list
luv-main@luv.asn.au
https://lists.luv.asn.au/cgi-bin/mailman/listinfo/luv-main


Re: Postfix + Dovecot (+MySQL)

2016-09-21 Thread Erik Christiansen via luv-main
On 21.09.16 19:20, Chris Samuel via luv-main wrote:
> On Tuesday, 20 September 2016 9:00:08 AM AEST Piers Rowan via luv-main wrote:
> 
> > The only thing left to do is set up vacation emails - any suggestions?
> > Preferably with a way for users to manage them themselves (bearing in mind
> > the Dovecot / SASL / MySQL thingo)
> 
> Never tried it, but I just found this with a quick search:
> 
> http://vacation-web.sourceforge.net/

On debian, there is also:

$ apt-cache search vacation
...
vacation - email autoresponder

If that's the same one I used more than 20 years ago, it auto-responds
only to the first mail received from each correspondent, to avoid
annoyance. Where/how it keeps the correspondents list may have changed
over the decades, perhaps.

Back in the day, vacation would create .forward, and run
vi vacation.msg
What more could one want?

Erik
___
luv-main mailing list
luv-main@luv.asn.au
https://lists.luv.asn.au/cgi-bin/mailman/listinfo/luv-main


Re: Postfix + Dovecot (+MySQL)

2016-09-21 Thread Chris Samuel via luv-main
On Tuesday, 20 September 2016 9:00:08 AM AEST Piers Rowan via luv-main wrote:

> The only thing left to do is set up vacation emails - any suggestions?
> Preferably with a way for users to manage them themselves (bearing in mind
> the Dovecot / SASL / MySQL thingo)

Never tried it, but I just found this with a quick search:

http://vacation-web.sourceforge.net/

Best of luck!
Chris
-- 
 Chris Samuel  :  http://www.csamuel.org/  :  Melbourne, VIC

___
luv-main mailing list
luv-main@luv.asn.au
https://lists.luv.asn.au/cgi-bin/mailman/listinfo/luv-main


Re: Postfix + Dovecot (+MySQL)

2016-09-19 Thread Russell Coker via luv-main
On Tuesday, 20 September 2016 9:00:08 AM AEST Piers Rowan via luv-main wrote:
> It looks like that all along I had not set up 587 on the VM. Thank you 
> for helping me circle back to the obvious!

No problems.

> The only thing left to do is set up vacation emails - any suggestions? 
> Preferably with a way for users to manage them themselves (bearing in 
> mind the Dovecot / SASL / MySQL thingo)

Sorry I don't know a good solution to this.  In the past I've done it manually 
with .forward files and I don't think I've ever done it on a server backed 
with MySQL in that manner.

Generally the things I blog about are a subset of things that I need to do 
myself or that people have paid me to do.  So far no-one who pays me has 
wanted enough vacation accounts to make it worth automating.

-- 
My Main Blog http://etbe.coker.com.au/
My Documents Bloghttp://doc.coker.com.au/

___
luv-main mailing list
luv-main@luv.asn.au
https://lists.luv.asn.au/cgi-bin/mailman/listinfo/luv-main


Re: Postfix + Dovecot (+MySQL)

2016-09-19 Thread Piers Rowan via luv-main



https://etbe.coker.com.au/2015/10/17/mail-server-training/



Looks like a good resource. The one I worked from had MySQL backed 
accounts and postadmin set up (+ a bunch of anti spam / anti virus stuff)




It looks like you have missed out a SASL authentication mechanism.  I
recommend using Dovecot as it's MUCH easier than getting Postfix to use MySQL
directly.  But following the above blog post is the easiest thing to do.  I
read my own blog posts when I have to do these things.  ;)



This:

1. Edit*/etc/postfix/master.cf*, uncomment the line for
   the*submission*service, and restart Postfix. This makes Postfix
   listen on port 587 which is allowed through most firewalls.


It looks like that all along I had not set up 587 on the VM. Thank you 
for helping me circle back to the obvious!


The only thing left to do is set up vacation emails - any suggestions? 
Preferably with a way for users to manage them themselves (bearing in 
mind the Dovecot / SASL / MySQL thingo)



Cheers
Piers
___
luv-main mailing list
luv-main@luv.asn.au
https://lists.luv.asn.au/cgi-bin/mailman/listinfo/luv-main


Re: Postfix + Dovecot (+MySQL)

2016-09-19 Thread Russell Coker via luv-main
On Monday, 19 September 2016 8:06:11 PM AEST Piers Rowan via luv-main wrote:
> I set up a VM a couple of weeks back as a mail server. I can send email 
> via web mail and I can get email in but I can't get it to relay.

https://etbe.coker.com.au/2015/10/17/mail-server-training/

Last year I ran a mail server training session for LUV, the above URL has the 
notes with a step by step description of this.  The SASL section in the above 
has all the notes on how to do it and shows how to test it.

It looks like you have missed out a SASL authentication mechanism.  I 
recommend using Dovecot as it's MUCH easier than getting Postfix to use MySQL 
directly.  But following the above blog post is the easiest thing to do.  I 
read my own blog posts when I have to do these things.  ;)

-- 
My Main Blog http://etbe.coker.com.au/
My Documents Bloghttp://doc.coker.com.au/

___
luv-main mailing list
luv-main@luv.asn.au
https://lists.luv.asn.au/cgi-bin/mailman/listinfo/luv-main


Postfix + Dovecot (+MySQL)

2016-09-19 Thread Piers Rowan via luv-main

Hi there,

I set up a VM a couple of weeks back as a mail server. I can send email 
via web mail and I can get email in but I can't get it to relay.


cat /etc/postfix/main.cf | grep restrictions
# overcome chroot restrictions. The alternative, having a copy of
# through Postfix.  See the smtpd_recipient_restrictions parameter
# relay mail to.  See the smtpd_recipient_restrictions description in
smtpd_relay_restrictions = 
permit_mynetworks,permit_sasl_authenticated,reject_unauth_destination

mua_client_restrictions = permit_sasl_authenticated,reject
mua_helo_restrictions = permit_sasl_authenticated,reject
mua_sender_restrictions = permit_sasl_authenticated,reject
smtpd_recipient_restrictions = 
permit_mynetworks,permit_sasl_authenticated,check_policy_service 
unix:/var/spool/postfix/postgrey/socket
smtpd_recipient_restrictions = reject_invalid_hostname, 
reject_unknown_recipient_domain, reject_unauth_pipelining, 
permit_mynetworks, reject_unauth_destination, permit_sasl_authenticated, 
check_policy_service unix:/var/spool/postfix/postgrey/socket, 
reject_rbl_client zen.spamhaus.org, reject_rbl_client bl.spamcop.net, 
reject_rbl_client dnsbl.sorbs.net, reject_rbl_client cbl.abuseat.org, 
reject_rbl_client b.barracudacentral.org, reject_rbl_client 
dnsbl-1.uceprotect.net,permit



cat /etc/postfix/master.cf | grep restrictions
  -o smtpd_client_restrictions=$mua_client_restrictions
  -o smtpd_helo_restrictions=$mua_helo_restrictions
  -o smtpd_sender_restrictions=$mua_sender_restrictions
  -o smtpd_recipient_restrictions=permit_sasl_authenticated,reject
#  -o smtpd_client_restrictions=$mua_client_restrictions
#  -o smtpd_helo_restrictions=$mua_helo_restrictions
#  -o smtpd_sender_restrictions=$mua_sender_restrictions
#  -o smtpd_recipient_restrictions=permit_sasl_authenticated,reject
-o smtpd_client_restrictions=
-o smtpd_helo_restrictions=
-o smtpd_sender_restrictions=
-o 
smtpd_recipient_restrictions=permit_mynetworks,permit_sasl_authenticated,reject


Any ideas? I'm not familiar with Postfix.

Thanks

Piers
___
luv-main mailing list
luv-main@luv.asn.au
https://lists.luv.asn.au/cgi-bin/mailman/listinfo/luv-main