Re: [Mailman-Users] Postfix relay_domains and MySQL tables (uncertainties of the beginner)

[Mark Sapiro]

On 2/25/19 8:51 AM, Davide Marchi wrote:
> Hi Friends,
> I've just installed Mailman 2.1.23 on Debian Stretch, Postfix+Dovecot
> with "virtual_domains" "virtual_users" "virtual_aliases" on MySQL, and
> all seems works fine, but not tested again.
> I write you for clarification before to start.
> 
> I'm not shure about the Postfix option:
> 
> postconf -e 'relay_domains = lists.example.com'


This looks like Debian stuff and probably has to do with
postfix_to_mailman.py. Please see  and
.

-- 
Mark Sapiro The highway is for gamblers,
San Francisco Bay Area, Californiabetter use your sense - B. Dylan
--
Mailman-Users mailing list Mailman-Users@python.org
https://mail.python.org/mailman/listinfo/mailman-users
Mailman FAQ: http://wiki.list.org/x/AgA3
Security Policy: http://wiki.list.org/x/QIA9
Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/
Unsubscribe: 
https://mail.python.org/mailman/options/mailman-users/archive%40jab.org

Re: [Mailman-Users] Starting mailman on reboot

[Mark Sapiro]

On 2/26/19 5:56 AM, Odhiambo Washington wrote:
> On Tue, 26 Feb 2019 at 15:23, mailman-admin 
> wrote:
> 
>> Am 26.02.19 um 08:59 schrieb Odhiambo Washington:
>>> Server: Ubuntu 18.01
>>>
>>> I have followed these:
>>> http://www.gnu.org/software/mailman/mailman-install/node42.html
>>>
>>>  % update-rc.d mailman defaults
>>>
>>> But still, mailman doesn't start on reboot.
>>>
>>> Nothing in the logs suggest any reason.
>>>
>>
>> Ubuntu 18.04 is a systemd based distro.
>> Per default it is not using system V init system anymore.
>>
>> Check systemd-sysv-generator for getting those running.
>>
> 
> The man page for systemd-sysv-generator is ... well, let me not say.



systemd-sysv-generator runs at boot to generate temporary systemd
services from /etc/init.d/* scripts for backwards compatibility with
SysV init.

If you have copied the init script from misc/mailman to
/etc/init.d/mailman, it should work with systemd. Note that the script
is misc/mailman, not scripts/mailman as it says in the manual. (I'm
fixing that.)

-- 
Mark Sapiro The highway is for gamblers,
San Francisco Bay Area, Californiabetter use your sense - B. Dylan
--
Mailman-Users mailing list Mailman-Users@python.org
https://mail.python.org/mailman/listinfo/mailman-users
Mailman FAQ: http://wiki.list.org/x/AgA3
Security Policy: http://wiki.list.org/x/QIA9
Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/
Unsubscribe: 
https://mail.python.org/mailman/options/mailman-users/archive%40jab.org

[Mailman-Users] Postfix relay_domains and MySQL tables (uncertainties of the beginner)

[Davide Marchi]

Hi Friends,
I've just installed Mailman 2.1.23 on Debian Stretch, Postfix+Dovecot 
with "virtual_domains" "virtual_users" "virtual_aliases" on MySQL, and 
all seems works fine, but not tested again.

I write you for clarification before to start.

I'm not shure about the Postfix option:

postconf -e 'relay_domains = lists.example.com'

I'm using this mail server as a normal mail server and not just for 
Mailman only, so
I would not like this parameter to create problems with sending / 
receiving mail from other users (outside Mailman)


And again since I have not read anything on the net about it, could be 
create any Mailman problems if I use MySQL as described above?



1) virtual_domains table for holds the list of domains that I will use 
as virtual_mailbox_domains in Postfix:


"
user = mailuser
password = 123456789
hosts = 127.0.0.1
dbname = mailserver
query = SELECT 1 FROM virtual_domains WHERE name='%s'
"


2) virtual_users the table contains information about my users which is 
mapping email addresses (virtual_mailbox_maps) to the location of the 
user’s mailbox in Postfix:


"
user = mailuser
password = 123456789
hosts = 127.0.0.1
dbname = mailserver
query = SELECT 1 FROM virtual_users WHERE email='%s'
"

3) virtual_aliases table for mapping that information about my users for 
forwarding emails from one email address to others (virtual_alias_maps 
mapping)


"
user = mailuser
password = 123456789
hosts = 127.0.0.1
dbname = mailserver
query = SELECT destination FROM virtual_aliases WHERE source='%s'
"

4) and last but not last "/etc/postfix/mysql-email2email.cf" for the 
latter mapping:


"
user = mailuser
password = 123456789
hosts = 127.0.0.1
dbname = mailserver
query = SELECT email FROM virtual_users WHERE email='%s'
"

virtual_alias_maps=mysql:/etc/postfix/mysql-virtual-alias-maps.cf,mysql:/etc/postfix/mysql-email2email.cf





Many many thanks to all!

Davide
--
Mailman-Users mailing list Mailman-Users@python.org
https://mail.python.org/mailman/listinfo/mailman-users
Mailman FAQ: http://wiki.list.org/x/AgA3
Security Policy: http://wiki.list.org/x/QIA9
Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/
Unsubscribe: 
https://mail.python.org/mailman/options/mailman-users/archive%40jab.org

Re: [Mailman-Users] Starting mailman on reboot

[Odhiambo Washington]

On Tue, 26 Feb 2019 at 15:23, mailman-admin 
wrote:

> Am 26.02.19 um 08:59 schrieb Odhiambo Washington:
> > Server: Ubuntu 18.01
> >
> > I have followed these:
> > http://www.gnu.org/software/mailman/mailman-install/node42.html
> >
> >  % update-rc.d mailman defaults
> >
> > But still, mailman doesn't start on reboot.
> >
> > Nothing in the logs suggest any reason.
> >
>
> Ubuntu 18.04 is a systemd based distro.
> Per default it is not using system V init system anymore.
>
> Check systemd-sysv-generator for getting those running.
>

The man page for systemd-sysv-generator is ... well, let me not say.

Let me Google.


-- 
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", grep ^[^#] :-)
--
Mailman-Users mailing list Mailman-Users@python.org
https://mail.python.org/mailman/listinfo/mailman-users
Mailman FAQ: http://wiki.list.org/x/AgA3
Security Policy: http://wiki.list.org/x/QIA9
Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/
Unsubscribe: 
https://mail.python.org/mailman/options/mailman-users/archive%40jab.org

Re: [Mailman-Users] Starting mailman on reboot

[mailman-admin]

Am 26.02.19 um 08:59 schrieb Odhiambo Washington:
> Server: Ubuntu 18.01
> 
> I have followed these:
> http://www.gnu.org/software/mailman/mailman-install/node42.html
> 
>  % update-rc.d mailman defaults
> 
> But still, mailman doesn't start on reboot.
> 
> Nothing in the logs suggest any reason.
> 

Ubuntu 18.04 is a systemd based distro.
Per default it is not using system V init system anymore.

Check systemd-sysv-generator for getting those running.


Kind regards,
Christian Mack
--
Mailman-Users mailing list Mailman-Users@python.org
https://mail.python.org/mailman/listinfo/mailman-users
Mailman FAQ: http://wiki.list.org/x/AgA3
Security Policy: http://wiki.list.org/x/QIA9
Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/
Unsubscribe: 
https://mail.python.org/mailman/options/mailman-users/archive%40jab.org

[Mailman-Users] Starting mailman on reboot

[Odhiambo Washington]

Server: Ubuntu 18.01

I have followed these:
http://www.gnu.org/software/mailman/mailman-install/node42.html

 % update-rc.d mailman defaults

But still, mailman doesn't start on reboot.

Nothing in the logs suggest any reason.


-- 
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", grep ^[^#] :-)
--
Mailman-Users mailing list Mailman-Users@python.org
https://mail.python.org/mailman/listinfo/mailman-users
Mailman FAQ: http://wiki.list.org/x/AgA3
Security Policy: http://wiki.list.org/x/QIA9
Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/
Unsubscribe: 
https://mail.python.org/mailman/options/mailman-users/archive%40jab.org