Gestione domini virtual con postfixadmin - Revision history

Gabriele.vivinetto: /* Dovecot 2.x (Wheezy) */

2020-10-19T15:08:44Z

Dovecot 2.x (Wheezy)

← Older revision		Revision as of 15:08, 19 October 2020
Line 362:		Line 362:
	sudo invoke-rc.d dovecot restart		sudo invoke-rc.d dovecot restart

	==Dovecot 2.x ~~(Wheezy)~~==		==Dovecot 2.x==

	* Installare i pacchetti:		* Installare i pacchetti:
Line 391:		Line 391:


	* Impostare i dettagli SQL '''ATTENZIONE, ~~CAMBIARE~~ PASSWORD UID E GID NELLA QUERY''':		* Impostare i dettagli SQL '''ATTENZIONE, CONTROLLARE PASSWORD UID E GID NELLA QUERY''':

	~~sudoedit /etc/dovecot/dovecot-sql.conf.ext~~

	<pre>		<pre>
Line 414:		Line 412:
	CONCAT('/home/vmail/',maildir) AS home, \\		CONCAT('/home/vmail/',maildir) AS home, \\
	concat('maildir:/home/vmail/', maildir) as mail, \\		concat('maildir:/home/vmail/', maildir) as mail, \\
	S(id postfix -u) AS uid, \\		$(id postfix -u) AS uid, \\
	$(id postfix -g) AS gid \\		$(id postfix -g) AS gid \\
	FROM \\		FROM \\
Line 422:		Line 420:
	EOFile		EOFile
	</pre>		</pre>

			sudoedit /etc/dovecot/dovecot-sql.conf.ext

	===Impostazione Autenticazione SASL tramite dovecot===		===Impostazione Autenticazione SASL tramite dovecot===

Gabriele.vivinetto: /* Fix per Debian Buster */

2020-03-10T18:44:05Z

Fix per Debian Buster

← Older revision		Revision as of 18:44, 10 March 2020
Line 122:		Line 122:
	==Fix per Debian Buster==		==Fix per Debian Buster==

	sed -e 's_Alias /postfixadmin /usr/share/postfixadmin_Alias /postfixadmin /usr/share/postfixadmin/public_' /etc/apache2/conf-enabled/postfixadmin.conf		sed -i -e 's_Alias /postfixadmin /usr/share/postfixadmin_Alias /postfixadmin /usr/share/postfixadmin/public_' /etc/apache2/conf-enabled/postfixadmin.conf

	mkdir -p /usr/share/postfixadmin/lib/../templates_c		systemctl restart apache2
	chown www-data /usr/share/postfixadmin/lib/../templates_c -R
	chmod 700 /usr/share/postfixadmin/lib/../templates_c		mkdir -p /usr/share/postfixadmin/lib/../templates_c
			chown www-data /usr/share/postfixadmin/lib/../templates_c -R
			chmod 700 /usr/share/postfixadmin/lib/../templates_c

	===Riferimenti===		===Riferimenti===
	*[https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=926252 #926252 - postfixadmin: apache2 configuration does not point to public folder - Debian Bug report logs]		*[https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=926252 #926252 - postfixadmin: apache2 configuration does not point to public folder - Debian Bug report logs]
	*[https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=926253 #926253 - postfixadmin: /usr/share/postfixadmin/lib/../templates_c does not exist on new installation - Debian Bug report logs]		*[https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=926253 #926253 - postfixadmin: /usr/share/postfixadmin/lib/../templates_c does not exist on new installation - Debian Bug report logs]


	=Configurazione Web=		=Configurazione Web=

Gabriele.vivinetto: /* Preconfigurazione */

2020-03-10T18:42:22Z

Preconfigurazione

@@ Line 118: / Line 118: @@
 $CONF['special_alias_control'] = 'YES';
 </pre>
 * Andare alla pagina di setup, e controllare che tutto sia ok:

Gabriele.vivinetto: /* Configurazione postfix */

2019-12-11T13:36:33Z

Configurazione postfix

← Older revision		Revision as of 13:36, 11 December 2019
Line 243:		Line 243:

	* Impostare permission:		* Impostare permission:
			sudo chown postfix:postfix /etc/postfix/mysql_*.cf
	sudo chmod o-r /etc/postfix/mysql_*.cf		sudo chmod o-r /etc/postfix/mysql_*.cf

Gabriele.vivinetto: /* Dovecot 2.x (Wheezy) */

2019-12-11T11:27:58Z

Dovecot 2.x (Wheezy)

← Older revision		Revision as of 11:27, 11 December 2019
Line 352:		Line 352:
	sudoedit /etc/dovecot/conf.d/10-auth.conf		sudoedit /etc/dovecot/conf.d/10-auth.conf

	disable_plaintext_auth = no		#disable_plaintext_auth = no

			#!include auth-system.conf.ext
	!include auth-sql.conf.ext		!include auth-sql.conf.ext


	* Impostare dettagli mailbox		* Impostare dettagli mailbox
Line 361:		Line 363:
	mail_location = maildir:/home/vmail/%d/%n		mail_location = maildir:/home/vmail/%d/%n

	* Impostare i valori corretti di uid e gui di ~~postfic~~ rilevati precedentemente:		* Impostare i valori corretti di uid e gui di postfix rilevati precedentemente:
	sudoedit /etc/dovecot/conf.d/10-mail.conf		sudoedit /etc/dovecot/conf.d/10-mail.conf

Line 376:		Line 378:

	<pre>		<pre>
			cat \| sudo tee -a /etc/dovecot/dovecot-sql.conf.ext <<EOFile
	driver = mysql		driver = mysql

	connect = dbname=postfixadmin user=postfixadmin host=127.0.0.1 password=~~postfixpassword~~		connect = dbname=postfixadmin user=postfixadmin host=127.0.0.1 password=$(sudo cat /etc/dbconfig-common/postfixadmin.conf \| grep -v '#' \| grep dbc_dbpass\| cut -f 2 --delimiter='=' \| tr -d "'")
	default_pass_scheme = MD5		default_pass_scheme = MD5

	password_query = \		password_query = \\
	SELECT \		SELECT \\
	password \		password \\
	FROM \		FROM \\
	mailbox \		mailbox \\
	WHERE \		WHERE \\
	username = '%u'		username = '%u'

	user_query = \		user_query = \\
	SELECT \		SELECT \\
	CONCAT('/home/vmail/',maildir) AS home, \		CONCAT('/home/vmail/',maildir) AS home, \\
	concat('maildir:/home/vmail/', maildir) as mail, \		concat('maildir:/home/vmail/', maildir) as mail, \\
	~~101~~ AS uid, \		S(id postfix -u) AS uid, \\
	~~101~~ AS gid \		$(id postfix -g) AS gid \\
	FROM \		FROM \\
	mailbox \		mailbox \\
	WHERE \		WHERE \\
	username = '%u'		username = '%u'
			EOFile
	</pre>		</pre>

Gabriele.vivinetto: /* Configurazione postfix */

2019-12-11T11:14:48Z

Configurazione postfix

← Older revision		Revision as of 11:14, 11 December 2019
Line 150:		Line 150:
	<pre>		<pre>
	cat \| sudo tee -a /etc/postfix/main.cf <<EOFile		cat \| sudo tee -a /etc/postfix/main.cf <<EOFile
	virtual_uid_maps = static:~~102~~		virtual_uid_maps = static:$(id postfix -u)
	virtual_minimum_uid = ~~102~~		virtual_minimum_uid = $(id postfix -u)
	virtual_gid_maps = static:~~105~~		virtual_gid_maps = static:$(id postfix -g)
	virtual_transport = virtual		virtual_transport = virtual
	virtual_mailbox_base = /home/vmail		virtual_mailbox_base = /home/vmail
Line 163:		Line 163:
	</pre>		</pre>

	* ~~Correggere UID e GID~~		* Verificare
	sudoedit /etc/postfix/main.cf		sudoedit /etc/postfix/main.cf

Line 175:		Line 175:

	* Alias map:		* Alias map:

	<pre>		<pre>
	cat \| sudo tee /etc/postfix/mysql_virtual_alias_maps.cf <<EOFile		cat \| sudo tee /etc/postfix/mysql_virtual_alias_maps.cf <<EOFile
	user = postfixadmin		user = postfixadmin
	password = ~~postfixpassword~~		password = $(sudo cat /etc/dbconfig-common/postfixadmin.conf \| grep -v '#' \| grep dbc_dbpass\| cut -f 2 --delimiter='=' \| tr -d "'")
	hosts = 127.0.0.1		hosts = 127.0.0.1
	dbname = postfixadmin		dbname = postfixadmin
Line 185:		Line 186:
	</pre>		</pre>

	* ~~Cambiare la password:~~		* Verificare

	~~sudoedit~~ /etc/postfix/mysql_virtual_alias_maps.cf		sudo cat /etc/postfix/mysql_virtual_alias_maps.cf

	'''NOTA: /etc/aliases servirà SOLO per gli alias LOCALI cioè le mail inviate a destinatari SENZA DOMINIO'''		'''NOTA: /etc/aliases servirà SOLO per gli alias LOCALI cioè le mail inviate a destinatari SENZA DOMINIO'''
Line 195:		Line 196:
	cat \| sudo tee /etc/postfix/mysql_virtual_domains_maps.cf<<EOFile		cat \| sudo tee /etc/postfix/mysql_virtual_domains_maps.cf<<EOFile
	user = postfixadmin		user = postfixadmin
	password = ~~postfixpassword~~		password = $(sudo cat /etc/dbconfig-common/postfixadmin.conf \| grep -v '#' \| grep dbc_dbpass\| cut -f 2 --delimiter='=' \| tr -d "'")
	hosts = 127.0.0.1		hosts = 127.0.0.1
	dbname = postfixadmin		dbname = postfixadmin
Line 205:		Line 206:


	* ~~Cambiare la password~~:		* Verificare:

	~~sudoedit~~ /etc/postfix/mysql_virtual_domains_maps.cf		sudo cat /etc/postfix/mysql_virtual_domains_maps.cf

	* Mailbox virtuali		* Mailbox virtuali
Line 213:		Line 214:
	cat \| sudo tee /etc/postfix/mysql_virtual_mailbox_maps.cf <<EOFile		cat \| sudo tee /etc/postfix/mysql_virtual_mailbox_maps.cf <<EOFile
	user = postfixadmin		user = postfixadmin
	password = ~~postfixpassword~~		password = $(sudo cat /etc/dbconfig-common/postfixadmin.conf \| grep -v '#' \| grep dbc_dbpass\| cut -f 2 --delimiter='=' \| tr -d "'")
	hosts = 127.0.0.1		hosts = 127.0.0.1
	table = mailbox		table = mailbox
Line 222:		Line 223:
	</pre>		</pre>

	* ~~Cambiare la password~~:		* Verificare:

	~~sudoedit~~ /etc/postfix/mysql_virtual_mailbox_maps.cf		sudo cat /etc/postfix/mysql_virtual_mailbox_maps.cf

	* Backup MX relay_domains		* Backup MX relay_domains
Line 230:		Line 231:
	cat \| sudo tee /etc/postfix/mysql_relay_domains_maps.cf <<EOFile		cat \| sudo tee /etc/postfix/mysql_relay_domains_maps.cf <<EOFile
	user = postfixadmin		user = postfixadmin
	password = ~~postfixpassword~~		password = $(sudo cat /etc/dbconfig-common/postfixadmin.conf \| grep -v '#' \| grep dbc_dbpass\| cut -f 2 --delimiter='=' \| tr -d "'")
	hosts = 127.0.0.1		hosts = 127.0.0.1
	dbname = postfixadmin		dbname = postfixadmin
Line 237:		Line 238:
	</pre>		</pre>

	* ~~Cambiare la password:~~		* Verificare

			sudo cat /etc/postfix/mysql_relay_domains_maps.cf

	~~sudoedit~~ /etc/postfix/~~mysql_relay_domains_maps~~.cf		* Impostare permission:
			sudo chmod o-r /etc/postfix/mysql_*.cf

	* Creazione folders:		* Creazione folders:
Line 263:		Line 267:
	</pre>		</pre>

	~~sudo /etc/init~~.~~d/postfix restart~~		systemctl restart postfix.service

	=Configurazione Dovecot=		=Configurazione Dovecot=

Gabriele.vivinetto: /* Riferimenti */

2016-03-31T16:46:21Z

Riferimenti

← Older revision		Revision as of 16:46, 31 March 2016
Line 428:		Line 428:
	===Riferimenti===		===Riferimenti===
	*[http://wiki2.dovecot.org/HowTo/PostfixAndDovecotSASL HowTo/PostfixAndDovecotSASL - Dovecot Wiki]		*[http://wiki2.dovecot.org/HowTo/PostfixAndDovecotSASL HowTo/PostfixAndDovecotSASL - Dovecot Wiki]
			*[http://serverfault.com/questions/463812/postfix-auth-login-no-longer-being-offered-for-smtp-auth-after-upgrade-from-ub dovecot - Postfix "AUTH-LOGIN" no longer being offered for smtp auth after upgrade from Ubuntu 10.04 to 12.04.1 - Server Fault]

	=Upgrade=		=Upgrade=

Gabriele.vivinetto: /* Impostazione Autenticazione SASL tramite dovecot */

2016-03-31T16:45:26Z

Impostazione Autenticazione SASL tramite dovecot

← Older revision		Revision as of 16:45, 31 March 2016
Line 411:		Line 411:
	...		...
	</pre>		</pre>

			* Impostare anche il metodo di autenticazione LOGI, altrimenti gli eventuali componenti DotNet smtp client non riusciranno ad autenticarsi
			sudoedit /etc/dovecot/conf.d/10-auth.conf

			auth_mechanisms = plain login


	* Ricordarsi di impostare anche Postifx per l'utilizzo di questo metodo di autenticazione sasl: [[Gestione domini virtual con postfixadmin#Autenticazione SASL tramite Dovecot\|Autenticazione SASL tramite Dovecot in Postfix]]		* Ricordarsi di impostare anche Postifx per l'utilizzo di questo metodo di autenticazione sasl: [[Gestione domini virtual con postfixadmin#Autenticazione SASL tramite Dovecot\|Autenticazione SASL tramite Dovecot in Postfix]]

Gabriele.vivinetto: /* Dovecot 2.x (Wheezy) */

2016-03-11T08:40:40Z

Dovecot 2.x (Wheezy)

← Older revision		Revision as of 08:40, 11 March 2016
Line 341:		Line 341:

	==Dovecot 2.x (Wheezy)==		==Dovecot 2.x (Wheezy)==

			* Installare i pacchetti:
			sudo apt-get install dovecot-imapd dovecot-mysql

	* Impostare autenticazione:		* Impostare autenticazione:

Gabriele.vivinetto: /* Autenticazione SASL tramite Dovecot */

2016-03-04T10:59:31Z

Autenticazione SASL tramite Dovecot

← Older revision		Revision as of 10:59, 4 March 2016
Line 258:		Line 258:

	<pre>		<pre>
			smtpd_sasl_auth_enable = yes
	smtpd_sasl_type = dovecot		smtpd_sasl_type = dovecot
	smtpd_sasl_path = private/auth		smtpd_sasl_path = private/auth
	</pre>		</pre>

	sudo ~~invoke-rc~~.d postfix restart		sudo /etc/init.d/postfix restart

	=Configurazione Dovecot=		=Configurazione Dovecot=