38 |
38 |
39 addgroup --system dovemail |
39 addgroup --system dovemail |
40 |
40 |
41 |
41 |
42 Configuring PostgreSQL |
42 Configuring PostgreSQL |
43 (for more details see: http://vmm.localdomain.org/PreparingPostgreSQL) |
43 (for more details see: |
|
44 http://vmm.localdomain.org/installation/postgresql_configuration.html) |
44 |
45 |
45 * /etc/postgresql/8.4/main/pg_hba.conf |
46 * /etc/postgresql/8.4/main/pg_hba.conf |
46 [ if you prefer to connect via TCP/IP ] |
47 [ if you prefer to connect via TCP/IP ] |
47 # IPv4 local connections: |
48 # IPv4 local connections: |
48 host mailsys +mailsys 127.0.0.1/32 md5 |
49 host mailsys +mailsys 127.0.0.1/32 md5 |
154 Configuring Postfix's master.cf |
155 Configuring Postfix's master.cf |
155 |
156 |
156 /!\ Only required with Dovecot v.1.x. |
157 /!\ Only required with Dovecot v.1.x. |
157 # Add Dovecot's deliver agent |
158 # Add Dovecot's deliver agent |
158 dovecot unix - n n - - pipe |
159 dovecot unix - n n - - pipe |
159 flags=DORhu user=nobody argv=/usr/local/lib/dovecot/deliver -f ${sender} -d ${user}@${nexthop} -n -m ${extension} |
160 flags=DORhu user=nobody argv=/usr/local/lib/dovecot/deliver -f ${sender} |
|
161 -d ${user}@${nexthop} -n -m ${extension} |
160 |
162 |
161 |
163 |
162 |
164 |
163 Configuring Postfix's main.cf |
165 Configuring Postfix's main.cf |
|
166 sql = pgsql:${config_directory}/ |
|
167 proxysql = proxy:${sql} |
|
168 |
164 # relocated users from the database |
169 # relocated users from the database |
165 #relocated_maps = pgsql:/etc/postfix/pgsql-relocated_maps.cf |
170 #relocated_maps = ${proxysql}pgsql-relocated_maps.cf |
166 |
171 |
167 # transport settings from our database |
172 # transport settings from our database |
168 transport_maps = pgsql:/etc/postfix/pgsql-transport_maps.cf |
173 transport_maps = ${proxysql}pgsql-transport_maps.cf |
169 |
174 |
170 # virtual domains |
175 # virtual domains |
171 virtual_mailbox_domains = pgsql:/etc/postfix/pgsql-virtual_mailbox_domains.cf |
176 virtual_mailbox_domains = ${proxysql}pgsql-virtual_mailbox_domains.cf |
172 virtual_alias_maps = pgsql:/etc/postfix/pgsql-virtual_alias_maps.cf |
177 virtual_alias_maps = ${proxysql}pgsql-virtual_alias_maps.cf |
173 virtual_minimum_uid = 70000 |
178 virtual_minimum_uid = 70000 |
174 virtual_uid_maps = pgsql:/etc/postfix/pgsql-virtual_uid_maps.cf |
179 virtual_uid_maps = ${sql}pgsql-virtual_uid_maps.cf |
175 virtual_gid_maps = pgsql:/etc/postfix/pgsql-virtual_gid_maps.cf |
180 virtual_gid_maps = ${sql}pgsql-virtual_gid_maps.cf |
176 virtual_mailbox_base = / |
181 virtual_mailbox_base = / |
177 virtual_mailbox_maps = pgsql:/etc/postfix/pgsql-virtual_mailbox_maps.cf |
182 virtual_mailbox_maps = ${proxysql}pgsql-virtual_mailbox_maps.cf |
178 |
183 |
179 # dovecot LDA (only recommended with Dovecot v1.x) |
184 # dovecot LDA (only recommended with Dovecot v1.x) |
180 #dovecot_destination_recipient_limit = 1 |
185 #dovecot_destination_recipient_limit = 1 |
181 #virtual_transport = dovecot: |
186 #virtual_transport = dovecot: |
182 |
187 |