1 Topic by neozimpi@gmail.com (edited by neozimpi@gmail.com 2020-08-05 14:53:03)

  • neozimpi@gmail.com
  • Member
  • Offline
  • From: Berlin, Germany
  • Registered: 2015-03-04
  • Posts: 99

Topic: mail server rebuild on new system

==== NEW-SERVER ====
- iRedMail version 1.3.1 MARIADB edition.
- Deployed with iRedMail downloadable installer
- Linux/BSD distribution name and version: Debian 10.5
- Store mail accounts in MYSQL
- Web server Nginx
- Manage mail accounts with iRedAdmin-Pro?: No
====

==== OLD-SERVER ====
- iRedMail version 0.8.7 MYSQL edition.
- Deployed with iRedMail downloadable installer
- Linux/BSD distribution name and version: Debian 9.12
- Store mail accounts in LDAP
- Web server apache2
- Manage mail accounts with iRedAdmin-Pro?: No
====

Hello,

we ran into an issue with our so far great working mailserver.
it ran for 5 years and did its job very well.

Now we are forced to move servers and update the config.
Previosly we used the mysql ldap solution with relayhost_map ldap config.
we backed up everything und moved from debian 9 to 10.
We installed with the latest iredadmin script.
worked like charm.
so we copied out postfix and dovecot config.
At this point some problems occoured.
Dovecot and all other parts where fine but postfix threw a lot of errors.
I checked the log and found that relayhost config was for ldap in postfix/main.cfg.
changed them to mysql and renamed the ldap folder to mysql.
I got less errors but still not working.
I stumbled across the iredmail docu:
https://docs.iredmail.org/upgrade.iredm … 0.9.5.html
"MySQL/MariaDB backend special"
Which helped a bit.

"" Create sql lookup file by copying an existing file:""
i did:
service postfix reload
service postfix restart

same with dovecot.
not working.

So this is where i am stuck now.

/var/log/mail.log:
postfix/proxymap[26152]: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf is unavailable. unsupported dictionary type: mysql
postfix/cleanup[26136]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "user@mail"
postfix/cleanup[26136]: warning: 0A8286158D: sender_bcc_maps map lookup problem -- message not accepted, try again later
postfix/pickup[25869]: warning: maildrop/22D366146E: error writing 0A8286158D: queue file write error
postfix/pickup[25869]: 0B2606158D: uid=1000 from=<user>

/var/log/mail.warn:
mail dovecot: master: Warning: Killed with signal 15 (by pid=3383 uid=0 code=kill)
mail postfix/proxymap[6862]: warning: mysql:/etc/postfix/mysql/catchall_maps.cf: query failed: Connection was killed
mail postfix/smtpd[6885]: warning: proxy:mysql:/etc/postfix/mysql/catchall_maps.cf lookup error for "smtp@mail.local"
mail postfix/proxymap[6871]: warning: mysql:/etc/postfix/mysql/virtual_alias_maps.cf: query failed: Connection was killed
mail postfix/smtpd[6890]: warning: proxy:mysql:/etc/postfix/mysql/virtual_alias_maps.cf lookup error for "smtp@mail.local"
mail postfix/proxymap[6862]: warning: mysql:/etc/postfix/mysql/virtual_alias_maps.cf: query failed: Connection was killed
mail postfix/smtpd[6899]: warning: proxy:mysql:/etc/postfix/mysql/virtual_alias_maps.cf lookup error for "smtp@mail.local"
mail postfix/smtpd[6866]: warning: proxy:mysql:/etc/postfix/mysql/virtual_alias_maps.cf lookup error for "smtp@mail.local"

we can receive mails via getmail but are unable to send andy.

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: mail server rebuild on new system

neozimpi@gmail.com wrote:

postfix/proxymap[26152]: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf is unavailable. unsupported dictionary type: mysql

Install package "postfix-mysql" should fix this error.

3 Reply by neozimpi@gmail.com (edited by neozimpi@gmail.com 2020-08-10 21:51:35)

  • neozimpi@gmail.com
  • Member
  • Offline
  • From: Berlin, Germany
  • Registered: 2015-03-04
  • Posts: 99

Re: mail server rebuild on new system

ZhangHuangbin wrote:
neozimpi@gmail.com wrote:

postfix/proxymap[26152]: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf is unavailable. unsupported dictionary type: mysql

Install package "postfix-mysql" should fix this error.

postfix-mysql is installed.
dpkg-reconfigure returned:

:::
Adding mysql map entry to /etc/postfix/dynamicmaps.cf
postconf: warning: mysql:/etc/postfix/mysql/virtual_mailbox_maps.cf: unused parameter: debuglevel=0
postconf: warning: mysql:/etc/postfix/mysql/virtual_mailbox_maps.cf: unused parameter: query_filter=(&(objectClass=mailUser)(|(mail=%s)(&(enabledService=shadowaddress)(shadowAddress=%s)))(accountStatus=active)(enabledService=mail)(enabledService=deliver))
postconf: warning: mysql:/etc/postfix/mysql/virtual_mailbox_maps.cf: unused parameter: start_tls=no
postconf: warning: mysql:/etc/postfix/mysql/virtual_mailbox_maps.cf: unused parameter: bind_pw=
postconf: warning: mysql:/etc/postfix/mysql/virtual_mailbox_maps.cf: unused parameter: bind=yes
postconf: warning: mysql:/etc/postfix/mysql/virtual_mailbox_maps.cf: unused parameter: scope=sub
postconf: warning: mysql:/etc/postfix/mysql/virtual_mailbox_maps.cf: unused parameter: version=3
postconf: warning: mysql:/etc/postfix/mysql/virtual_mailbox_maps.cf: unused parameter: bind_dn=cn=vmail,dc=mail,dc=user
postconf: warning: mysql:/etc/postfix/mysql/virtual_mailbox_maps.cf: unused parameter: server_host=127.0.0.1
postconf: warning: mysql:/etc/postfix/mysql/virtual_mailbox_maps.cf: unused parameter: server_port=389
postconf: warning: mysql:/etc/postfix/mysql/virtual_mailbox_maps.cf: unused parameter: result_attribute=mailMessageStore
postconf: warning: mysql:/etc/postfix/mysql/virtual_mailbox_maps.cf: unused parameter: search_base=o=domains,dc=mail,dc=user
postconf: warning: mysql:/etc/postfix/mysql/transport_maps_user.cf: unused parameter: debuglevel=0
postconf: warning: mysql:/etc/postfix/mysql/transport_maps_user.cf: unused parameter: query_filter=(&(objectClass=mailUser)(mail=%s)(accountStatus=active)(enabledService=mail))
postconf: warning: mysql:/etc/postfix/mysql/transport_maps_user.cf: unused parameter: start_tls=no
postconf: warning: mysql:/etc/postfix/mysql/transport_maps_user.cf: unused parameter: bind_pw=
postconf: warning: mysql:/etc/postfix/mysql/transport_maps_user.cf: unused parameter: bind=yes
postconf: warning: mysql:/etc/postfix/mysql/transport_maps_user.cf: unused parameter: scope=one
postconf: warning: mysql:/etc/postfix/mysql/transport_maps_user.cf: unused parameter: version=3
postconf: warning: mysql:/etc/postfix/mysql/transport_maps_user.cf: unused parameter: bind_dn=cn=vmail,dc=mail,dc=user
postconf: warning: mysql:/etc/postfix/mysql/transport_maps_user.cf: unused parameter: server_host=127.0.0.1
postconf: warning: mysql:/etc/postfix/mysql/transport_maps_user.cf: unused parameter: server_port=389
postconf: warning: mysql:/etc/postfix/mysql/transport_maps_user.cf: unused parameter: result_attribute=mtaTransport
postconf: warning: mysql:/etc/postfix/mysql/transport_maps_user.cf: unused parameter: search_base=ou=Users,domainName=%d,o=domains,dc=mail,dc=user
postconf: warning: mysql:/etc/postfix/mysql/transport_maps_domain.cf: unused parameter: debuglevel=0
postconf: warning: mysql:/etc/postfix/mysql/transport_maps_domain.cf: unused parameter: query_filter=(&(objectClass=mailDomain)(accountStatus=active)(enabledService=mail)(|(domainName=%s)(domainAliasName=%s)))
postconf: warning: mysql:/etc/postfix/mysql/transport_maps_domain.cf: unused parameter: start_tls=no
postconf: warning: mysql:/etc/postfix/mysql/transport_maps_domain.cf: unused parameter: bind_pw=
postconf: warning: mysql:/etc/postfix/mysql/transport_maps_domain.cf: unused parameter: bind=yes
postconf: warning: mysql:/etc/postfix/mysql/transport_maps_domain.cf: unused parameter: scope=one
postconf: warning: mysql:/etc/postfix/mysql/transport_maps_domain.cf: unused parameter: version=3
postconf: warning: mysql:/etc/postfix/mysql/transport_maps_domain.cf: unused parameter: bind_dn=cn=vmail,dc=mail,dc=user
postconf: warning: mysql:/etc/postfix/mysql/transport_maps_domain.cf: unused parameter: server_host=127.0.0.1
postconf: warning: mysql:/etc/postfix/mysql/transport_maps_domain.cf: unused parameter: server_port=389
postconf: warning: mysql:/etc/postfix/mysql/transport_maps_domain.cf: unused parameter: result_attribute=mtaTransport
postconf: warning: mysql:/etc/postfix/mysql/transport_maps_domain.cf: unused parameter: search_base=o=domains,dc=mail,dc=user
postconf: warning: mysql:/etc/postfix/mysql/virtual_mailbox_domains.cf: unused parameter: debuglevel=0
postconf: warning: mysql:/etc/postfix/mysql/virtual_mailbox_domains.cf: unused parameter: query_filter=(&(objectClass=mailDomain)(|(domainName=%s)(&(enabledService=domainalias)(domainAliasName=%s)))(!(domainBackupMX=yes))(accountStatus=active)(enabledService=mail))
postconf: warning: mysql:/etc/postfix/mysql/virtual_mailbox_domains.cf: unused parameter: start_tls=no
postconf: warning: mysql:/etc/postfix/mysql/virtual_mailbox_domains.cf: unused parameter: bind_pw=
postconf: warning: mysql:/etc/postfix/mysql/virtual_mailbox_domains.cf: unused parameter: bind=yes
postconf: warning: mysql:/etc/postfix/mysql/virtual_mailbox_domains.cf: unused parameter: scope=one
postconf: warning: mysql:/etc/postfix/mysql/virtual_mailbox_domains.cf: unused parameter: version=3
postconf: warning: mysql:/etc/postfix/mysql/virtual_mailbox_domains.cf: unused parameter: bind_dn=cn=vmail,dc=mail,dc=user
postconf: warning: mysql:/etc/postfix/mysql/virtual_mailbox_domains.cf: unused parameter: server_host=127.0.0.1
postconf: warning: mysql:/etc/postfix/mysql/virtual_mailbox_domains.cf: unused parameter: server_port=389
postconf: warning: mysql:/etc/postfix/mysql/virtual_mailbox_domains.cf: unused parameter: result_attribute=domainName
postconf: warning: mysql:/etc/postfix/mysql/virtual_mailbox_domains.cf: unused parameter: search_base=o=domains,dc=mail,dc=user
postconf: warning: mysql:/etc/postfix/mysql/virtual_alias_maps.cf: unused parameter: debuglevel=0
postconf: warning: mysql:/etc/postfix/mysql/virtual_alias_maps.cf: unused parameter: query_filter=(&(|(mail=%s)(shadowAddress=%s))(accountStatus=active)(enabledService=mail)(enabledService=deliver)(|(objectClass=mailAlias)(&(objectClass=mailUser)(enabledService=forward))))
postconf: warning: mysql:/etc/postfix/mysql/virtual_alias_maps.cf: unused parameter: start_tls=no
postconf: warning: mysql:/etc/postfix/mysql/virtual_alias_maps.cf: unused parameter: bind_pw=
postconf: warning: mysql:/etc/postfix/mysql/virtual_alias_maps.cf: unused parameter: bind=yes
postconf: warning: mysql:/etc/postfix/mysql/virtual_alias_maps.cf: unused parameter: scope=sub
postconf: warning: mysql:/etc/postfix/mysql/virtual_alias_maps.cf: unused parameter: version=3
postconf: warning: mysql:/etc/postfix/mysql/virtual_alias_maps.cf: unused parameter: bind_dn=cn=vmail,dc=mail,dc=user
postconf: warning: mysql:/etc/postfix/mysql/virtual_alias_maps.cf: unused parameter: server_host=127.0.0.1
postconf: warning: mysql:/etc/postfix/mysql/virtual_alias_maps.cf: unused parameter: server_port=389
postconf: warning: mysql:/etc/postfix/mysql/virtual_alias_maps.cf: unused parameter: result_attribute=mailForwardingAddress
postconf: warning: mysql:/etc/postfix/mysql/virtual_alias_maps.cf: unused parameter: search_base=o=domains,dc=mail,dc=user
postconf: warning: mysql:/etc/postfix/mysql/virtual_group_maps.cf: unused parameter: debuglevel=0
postconf: warning: mysql:/etc/postfix/mysql/virtual_group_maps.cf: unused parameter: query_filter=(&(accountStatus=active)(enabledService=mail)(enabledService=deliver)(|(&(|(memberOfGroup=%s)(shadowAddress=%s))(objectClass=mailUser))(&(memberOfGroup=%s)(!(shadowAddress=%s))(|(objectClass=mailExternalUser)(objectClass=mailList)(objectClass=mailAlias)))))
postconf: warning: mysql:/etc/postfix/mysql/virtual_group_maps.cf: unused parameter: start_tls=no
postconf: warning: mysql:/etc/postfix/mysql/virtual_group_maps.cf: unused parameter: bind_pw=
postconf: warning: mysql:/etc/postfix/mysql/virtual_group_maps.cf: unused parameter: bind=yes
postconf: warning: mysql:/etc/postfix/mysql/virtual_group_maps.cf: unused parameter: scope=sub
postconf: warning: mysql:/etc/postfix/mysql/virtual_group_maps.cf: unused parameter: version=3
postconf: warning: mysql:/etc/postfix/mysql/virtual_group_maps.cf: unused parameter: bind_dn=cn=vmail,dc=mail,dc=user
postconf: warning: mysql:/etc/postfix/mysql/virtual_group_maps.cf: unused parameter: server_host=127.0.0.1
postconf: warning: mysql:/etc/postfix/mysql/virtual_group_maps.cf: unused parameter: server_port=389
postconf: warning: mysql:/etc/postfix/mysql/virtual_group_maps.cf: unused parameter: result_attribute=mail
postconf: warning: mysql:/etc/postfix/mysql/virtual_group_maps.cf: unused parameter: search_base=o=domains,dc=mail,dc=user
postconf: warning: mysql:/etc/postfix/mysql/virtual_group_members_maps.cf: unused parameter: debuglevel=0
postconf: warning: mysql:/etc/postfix/mysql/virtual_group_members_maps.cf: unused parameter: query_filter=(&(objectClass=mailUser)(accountStatus=active)(enabledService=mail)(enabledService=deliver)(|(mail=%s)(&(enabledService=shadowaddress)(shadowAddress=%s))))
postconf: warning: mysql:/etc/postfix/mysql/virtual_group_members_maps.cf: unused parameter: start_tls=no
postconf: warning: mysql:/etc/postfix/mysql/virtual_group_members_maps.cf: unused parameter: bind_pw=
postconf: warning: mysql:/etc/postfix/mysql/virtual_group_members_maps.cf: unused parameter: bind=yes
postconf: warning: mysql:/etc/postfix/mysql/virtual_group_members_maps.cf: unused parameter: scope=sub
postconf: warning: mysql:/etc/postfix/mysql/virtual_group_members_maps.cf: unused parameter: version=3
postconf: warning: mysql:/etc/postfix/mysql/virtual_group_members_maps.cf: unused parameter: bind_dn=cn=vmail,dc=mail,dc=user
postconf: warning: mysql:/etc/postfix/mysql/virtual_group_members_maps.cf: unused parameter: server_host=127.0.0.1
postconf: warning: mysql:/etc/postfix/mysql/virtual_group_members_maps.cf: unused parameter: server_port=389
postconf: warning: mysql:/etc/postfix/mysql/virtual_group_members_maps.cf: unused parameter: result_attribute=mail
postconf: warning: mysql:/etc/postfix/mysql/virtual_group_members_maps.cf: unused parameter: search_base=o=domains,dc=mail,dc=user
postconf: warning: mysql:/etc/postfix/mysql/catchall_maps.cf: unused parameter: debuglevel=0
postconf: warning: mysql:/etc/postfix/mysql/catchall_maps.cf: unused parameter: query_filter=(&(objectClass=mailUser)(accountStatus=active)(|(mail=@%d)(shadowAddress=@%d)))
postconf: warning: mysql:/etc/postfix/mysql/catchall_maps.cf: unused parameter: start_tls=no
postconf: warning: mysql:/etc/postfix/mysql/catchall_maps.cf: unused parameter: bind_pw=
postconf: warning: mysql:/etc/postfix/mysql/catchall_maps.cf: unused parameter: bind=yes
postconf: warning: mysql:/etc/postfix/mysql/catchall_maps.cf: unused parameter: scope=sub
postconf: warning: mysql:/etc/postfix/mysql/catchall_maps.cf: unused parameter: version=3
postconf: warning: mysql:/etc/postfix/mysql/catchall_maps.cf: unused parameter: bind_dn=cn=vmail,dc=mail,dc=user
postconf: warning: mysql:/etc/postfix/mysql/catchall_maps.cf: unused parameter: server_host=127.0.0.1
postconf: warning: mysql:/etc/postfix/mysql/catchall_maps.cf: unused parameter: server_port=389
postconf: warning: mysql:/etc/postfix/mysql/catchall_maps.cf: unused parameter: result_attribute=mailForwardingAddress
postconf: warning: mysql:/etc/postfix/mysql/catchall_maps.cf: unused parameter: search_base=o=domains,dc=mail,dc=user
postconf: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf: unused parameter: debuglevel=0
postconf: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf: unused parameter: query_filter=(&(|(mail=%s)(&(enabledService=shadowaddress)(shadowAddress=%s)))(objectClass=mailUser)(accountStatus=active)(enabledService=mail)(enabledService=senderbcc))
postconf: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf: unused parameter: start_tls=no
postconf: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf: unused parameter: bind_pw=
postconf: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf: unused parameter: bind=yes
postconf: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf: unused parameter: scope=one
postconf: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf: unused parameter: version=3
postconf: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf: unused parameter: bind_dn=cn=vmail,dc=mail,dc=user
postconf: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf: unused parameter: server_host=127.0.0.1
postconf: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf: unused parameter: server_port=389
postconf: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf: unused parameter: result_attribute=userSenderBccAddress
postconf: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf: unused parameter: search_base=ou=Users,domainName=%d,o=domains,dc=mail,dc=user
postconf: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf: unused parameter: debuglevel=0
postconf: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf: unused parameter: query_filter=(&(objectClass=mailDomain)(|(domainName=%d)(domainAliasName=%d))(accountStatus=active)(enabledService=mail)(enabledService=senderbcc))
postconf: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf: unused parameter: start_tls=no
postconf: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf: unused parameter: bind_pw=
postconf: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf: unused parameter: bind=yes
postconf: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf: unused parameter: scope=one
postconf: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf: unused parameter: version=3
postconf: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf: unused parameter: bind_dn=cn=vmail,dc=mail,dc=user
postconf: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf: unused parameter: server_host=127.0.0.1
postconf: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf: unused parameter: server_port=389
postconf: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf: unused parameter: result_attribute=domainSenderBccAddress
postconf: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf: unused parameter: search_base=o=domains,dc=mail,dc=user
postconf: warning: mysql:/etc/postfix/mysql/recipient_bcc_maps_user.cf: unused parameter: debuglevel=0
postconf: warning: mysql:/etc/postfix/mysql/recipient_bcc_maps_user.cf: unused parameter: query_filter=(&(|(mail=%s)(&(enabledService=shadowaddress)(shadowAddress=%s)))(objectClass=mailUser)(accountStatus=active)(enabledService=mail)(enabledService=recipientbcc))
postconf: warning: mysql:/etc/postfix/mysql/recipient_bcc_maps_user.cf: unused parameter: start_tls=no
postconf: warning: mysql:/etc/postfix/mysql/recipient_bcc_maps_user.cf: unused parameter: bind_pw=
postconf: warning: mysql:/etc/postfix/mysql/recipient_bcc_maps_user.cf: unused parameter: bind=yes
postconf: warning: mysql:/etc/postfix/mysql/recipient_bcc_maps_user.cf: unused parameter: scope=one
postconf: warning: mysql:/etc/postfix/mysql/recipient_bcc_maps_user.cf: unused parameter: version=3
postconf: warning: mysql:/etc/postfix/mysql/recipient_bcc_maps_user.cf: unused parameter: bind_dn=cn=vmail,dc=mail,dc=user
postconf: warning: mysql:/etc/postfix/mysql/recipient_bcc_maps_user.cf: unused parameter: server_host=127.0.0.1
postconf: warning: mysql:/etc/postfix/mysql/recipient_bcc_maps_user.cf: unused parameter: server_port=389
postconf: warning: mysql:/etc/postfix/mysql/recipient_bcc_maps_user.cf: unused parameter: result_attribute=userRecipientBccAddress
postconf: warning: mysql:/etc/postfix/mysql/recipient_bcc_maps_user.cf: unused parameter: search_base=ou=Users,domainName=%d,o=domains,dc=mail,dc=user
postconf: warning: mysql:/etc/postfix/mysql/recipient_bcc_maps_domain.cf: unused parameter: debuglevel=0
postconf: warning: mysql:/etc/postfix/mysql/recipient_bcc_maps_domain.cf: unused parameter: query_filter=(&(objectClass=mailDomain)(|(domainName=%d)(domainAliasName=%d))(accountStatus=active)(enabledService=mail)(enabledService=recipientbcc))
postconf: warning: mysql:/etc/postfix/mysql/recipient_bcc_maps_domain.cf: unused parameter: start_tls=no
postconf: warning: mysql:/etc/postfix/mysql/recipient_bcc_maps_domain.cf: unused parameter: bind_pw=
postconf: warning: mysql:/etc/postfix/mysql/recipient_bcc_maps_domain.cf: unused parameter: bind=yes
postconf: warning: mysql:/etc/postfix/mysql/recipient_bcc_maps_domain.cf: unused parameter: scope=one
postconf: warning: mysql:/etc/postfix/mysql/recipient_bcc_maps_domain.cf: unused parameter: version=3
postconf: warning: mysql:/etc/postfix/mysql/recipient_bcc_maps_domain.cf: unused parameter: bind_dn=cn=vmail,dc=mail,dc=user
postconf: warning: mysql:/etc/postfix/mysql/recipient_bcc_maps_domain.cf: unused parameter: server_host=127.0.0.1
postconf: warning: mysql:/etc/postfix/mysql/recipient_bcc_maps_domain.cf: unused parameter: server_port=389
postconf: warning: mysql:/etc/postfix/mysql/recipient_bcc_maps_domain.cf: unused parameter: result_attribute=domainRecipientBccAddress
postconf: warning: mysql:/etc/postfix/mysql/recipient_bcc_maps_domain.cf: unused parameter: search_base=o=domains,dc=mail,dc=user
postconf: warning: mysql:/etc/postfix/mysql/relay_domains.cf: unused parameter: debuglevel=0
postconf: warning: mysql:/etc/postfix/mysql/relay_domains.cf: unused parameter: query_filter=(&(objectClass=mailDomain)(|(domainName=%s)(&(enabledService=domainalias)(domainAliasName=%s)))(domainBackupMX=yes)(accountStatus=active)(enabledService=mail))
postconf: warning: mysql:/etc/postfix/mysql/relay_domains.cf: unused parameter: start_tls=no
postconf: warning: mysql:/etc/postfix/mysql/relay_domains.cf: unused parameter: bind_pw=
postconf: warning: mysql:/etc/postfix/mysql/relay_domains.cf: unused parameter: bind=yes
postconf: warning: mysql:/etc/postfix/mysql/relay_domains.cf: unused parameter: scope=one
postconf: warning: mysql:/etc/postfix/mysql/relay_domains.cf: unused parameter: version=3
postconf: warning: mysql:/etc/postfix/mysql/relay_domains.cf: unused parameter: bind_dn=cn=vmail,dc=mail,dc=user
postconf: warning: mysql:/etc/postfix/mysql/relay_domains.cf: unused parameter: server_host=127.0.0.1
postconf: warning: mysql:/etc/postfix/mysql/relay_domains.cf: unused parameter: server_port=389
postconf: warning: mysql:/etc/postfix/mysql/relay_domains.cf: unused parameter: result_attribute=domainName
postconf: warning: mysql:/etc/postfix/mysql/relay_domains.cf: unused parameter: search_base=o=domains,dc=mail,dc=user
postconf: warning: mysql:/etc/postfix/mysql/sender_login_maps.cf: unused parameter: debuglevel=0
postconf: warning: mysql:/etc/postfix/mysql/sender_login_maps.cf: unused parameter: query_filter=(&(objectClass=mailUser)(accountStatus=active)(enabledService=mail)(enabledService=smtp)(|(mail=%s)(&(enabledService=shadowaddress)(shadowAddress=%s))))
postconf: warning: mysql:/etc/postfix/mysql/sender_login_maps.cf: unused parameter: start_tls=no
postconf: warning: mysql:/etc/postfix/mysql/sender_login_maps.cf: unused parameter: bind_pw=
postconf: warning: mysql:/etc/postfix/mysql/sender_login_maps.cf: unused parameter: bind=yes
postconf: warning: mysql:/etc/postfix/mysql/sender_login_maps.cf: unused parameter: scope=sub
postconf: warning: mysql:/etc/postfix/mysql/sender_login_maps.cf: unused parameter: version=3
postconf: warning: mysql:/etc/postfix/mysql/sender_login_maps.cf: unused parameter: bind_dn=cn=vmail,dc=mail,dc=user
postconf: warning: mysql:/etc/postfix/mysql/sender_login_maps.cf: unused parameter: server_host=127.0.0.1
postconf: warning: mysql:/etc/postfix/mysql/sender_login_maps.cf: unused parameter: server_port=389
postconf: warning: mysql:/etc/postfix/mysql/sender_login_maps.cf: unused parameter: result_attribute=mail
postconf: warning: mysql:/etc/postfix/mysql/sender_login_maps.cf: unused parameter: search_base=o=domains,dc=mail,dc=user
postconf: warning: /etc/postfix/main.cf: unused parameter: smtp_sender_dependent_authreceive_override_optionsentication=yes
:::

mysql:/etc/postfix/mysql/sender_login_maps.cf
for exampe was
mysql:/etc/postfix/ldap/sender_login_maps.cf

just changed the folder name from ldap to mysql so the path is ok. i gues the syntax or format for these files may be diffrent on mysql.

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: mail server rebuild on new system

Do not leak passwords in pasted content ...

5 Reply by neozimpi@gmail.com

  • neozimpi@gmail.com
  • Member
  • Offline
  • From: Berlin, Germany
  • Registered: 2015-03-04
  • Posts: 99

Re: mail server rebuild on new system

ZhangHuangbin wrote:

Do not leak passwords in pasted content ...

thx for the hint. I checked and found none in my post.


presume i have installed "ldap - mysql nginx" version of iredmail.
how would i convert the server to "mysql - mysql - nginx" ?

I think this approach would fix my server since we copied the config from the old server.

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: mail server rebuild on new system

neozimpi@gmail.com wrote:

thx for the hint. I checked and found none in my post.

Because i removed them for you.

neozimpi@gmail.com wrote:

presume i have installed "ldap - mysql nginx" version of iredmail.
how would i convert the server to "mysql - mysql - nginx" ?

Setup a new server with mysql + nginx, then migrate mail accounts and mailboxes.

7 Reply by neozimpi@gmail.com

  • neozimpi@gmail.com
  • Member
  • Offline
  • From: Berlin, Germany
  • Registered: 2015-03-04
  • Posts: 99

Re: mail server rebuild on new system

ZhangHuangbin wrote:
neozimpi@gmail.com wrote:

thx for the hint. I checked and found none in my post.

Because i removed them for you.

neozimpi@gmail.com wrote:

presume i have installed "ldap - mysql nginx" version of iredmail.
how would i convert the server to "mysql - mysql - nginx" ?

Setup a new server with mysql + nginx, then migrate mail accounts and mailboxes.

can i force the iredmail installer to accept new configs.
it displays skipped config when i try to re run it.

8 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: mail server rebuild on new system

neozimpi@gmail.com wrote:

can i force the iredmail installer to accept new configs.
it displays skipped config when i try to re run it.

Yes.