1 Topic by mehdizadeh_1986 (edited by mehdizadeh_1986 2013-12-29 13:57:19)

  • mehdizadeh_1986
  • Member
  • Offline
  • Registered: 2013-12-24
  • Posts: 18

Topic: iredmail error

==== Required information ====
- iRedMail version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Linux/BSD distribution name and version:
- Related log if you're reporting an issue:
====
hi all,

This is my first post smile
I am new in linux.
I install debian 7 (wheezly) and then install iredmail-0.8.6.
When i want to send an email with roundcube, it says:
"SMTP Error (451): Failed to add recipient "postmaster@mydomain.com" (4.3.0  <postmaster@mydomain.com>: Temporary lookup failure"

my mail.log is:


Dec 25 11:28:53 server1 postfix/smtpd[11193]: error: unsupported dictionary type: pcre
Dec 25 11:28:53 server1 postfix/smtpd[11193]: connect from localhost[127.0.0.1]
Dec 25 11:28:53 server1 postfix/proxymap[10996]: warning: mysql:/etc/postfix/mysql/virtual_mailbox_domains.cf is unavailable. unsupported dictionary type: mysql
Dec 25 11:28:53 server1 postfix/trivial-rewrite[10980]: warning: proxy:mysql:/etc/postfix/mysql/virtual_mailbox_domains.cf: table lookup problem
Dec 25 11:28:53 server1 postfix/trivial-rewrite[10980]: warning: virtual_mailbox_domains lookup failure
Dec 25 11:28:53 server1 postfix/smtpd[11193]: NOQUEUE: reject: RCPT from localhost[127.0.0.1]: 451 4.3.0 <postmaster@mydomail.com>: Temporary lookup failure; from=<postmaster@zharfserver.com> to=<postmaster@mydomail.com> proto=ESMTP helo=<127.0.0.1>
Dec 25 11:28:53 server1 roundcube: SMTP Error: SMTP error: Failed to add recipient 'postmaster@mydomail.com' in /usr/share/apache2/roundcubemail-0.9.5/program/include/rcmail.php on line 1035 (POST /mail/?_unlock=loading1387958333193&_lang=undefined?_task=mail&_action=send)
Dec 25 11:28:53 server1 postfix/smtpd[11193]: disconnect from localhost[127.0.0.1]

thanks.

----

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,091

Re: iredmail error

Do you have package "postfix-mysql" installed?

3 Reply by mehdizadeh_1986

  • mehdizadeh_1986
  • Member
  • Offline
  • Registered: 2013-12-24
  • Posts: 18

Re: iredmail error

ZhangHuangbin wrote:

Do you have package "postfix-mysql" installed?

yes!

4 Reply by ZhangHuangbin

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

Re: iredmail error

Could you please show us output of below commands?

# postconf -m
# dpkg -l | grep -i 'postfix'

5 Reply by mehdizadeh_1986 (edited by mehdizadeh_1986 2013-12-28 13:02:20)

  • mehdizadeh_1986
  • Member
  • Offline
  • Registered: 2013-12-24
  • Posts: 18

Re: iredmail error

ZhangHuangbin wrote:

Could you please show us output of below commands?

# postconf -m

btree
cidr
environ
fail
hash
internal
memcache
nis
pcre
proxy
regexp
sdbm
sqlite
static
tcp
texthash
unix

I found that "mysql" is not listed here. What shoud i do? 


# dpkg -l | grep -i 'postfix'

ii  postfix                               2.9.6-2                            amd64        High-performance mail transport agent
ii  postfix-cluebringer                   2.0.10-1                           all          anti-spam plugin for Postfix
ii  postfix-cluebringer-mysql             2.0.10-1                           all          metapackage for mysql support in postfix-cluebringer
ii  postfix-cluebringer-pgsql             2.0.10-1                           all          metapackage for postgresql support in postfix-cluebringer
ii  postfix-doc                           2.9.6-2                            all          Documentation for Postfix
ii  postfix-mysql                         2.9.6-2                            amd64        MySQL map support for Postfix

6 Reply by ZhangHuangbin

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

Re: iredmail error

mehdizadeh_1986 wrote:

I found that "mysql" is not listed here. What shoud i do?

Package "postfix-mysql" is used for mysql support in Postfix, but i don't know why it doesn't work for you.
Did you try removing postfix-mysql then reinstall it and restart Postfix service?

7 Reply by camel1cz

  • camel1cz
  • camel1cz
  • Member
  • Offline
  • From: Czech Republic
  • Registered: 2013-04-20
  • Posts: 220

Re: iredmail error

Config of available maps is in file /etc/postfix/dynamicmaps.cf
What is the contents of this file on your system?

It should be something like:

# Postfix dynamic maps configuration file.
#
#type    location of .so file            open function    (mkmap func)
#====    ================================    =============    ============
tcp    /usr/lib/postfix/dict_tcp.so        dict_tcp_open
sqlite    /usr/lib/postfix/dict_sqlite.so        dict_sqlite_open
pcre    /usr/lib/postfix/dict_pcre.so        dict_pcre_open
mysql    /usr/lib/postfix/dict_mysql.so        dict_mysql_open

Mainly the last line is important and seems it's missing in your config. Either try to add it manually or do the uninstall, reinstall of the postfix-mysql and restart postfix by executing:

apt-get --purge remove postfix-mysql
apt-get install postfix-mysql
service postfix restart

8 Reply by mehdizadeh_1986 (edited by mehdizadeh_1986 2013-12-29 15:47:05)

  • mehdizadeh_1986
  • Member
  • Offline
  • Registered: 2013-12-24
  • Posts: 18

Re: iredmail error

ZhangHuangbin wrote:
mehdizadeh_1986 wrote:

I found that "mysql" is not listed here. What shoud i do?

Package "postfix-mysql" is used for mysql support in Postfix, but i don't know why it doesn't work for you.
Did you try removing postfix-mysql then reinstall it and restart Postfix service?

Yes, i remove and reinstall it.

9 Reply by mehdizadeh_1986

  • mehdizadeh_1986
  • Member
  • Offline
  • Registered: 2013-12-24
  • Posts: 18

Re: iredmail error

camel1cz wrote:

Config of available maps is in file /etc/postfix/dynamicmaps.cf
What is the contents of this file on your system?

It should be something like:

# Postfix dynamic maps configuration file.
#
#type    location of .so file            open function    (mkmap func)
#====    ================================    =============    ============
tcp    /usr/lib/postfix/dict_tcp.so        dict_tcp_open
sqlite    /usr/lib/postfix/dict_sqlite.so        dict_sqlite_open
pcre    /usr/lib/postfix/dict_pcre.so        dict_pcre_open
mysql    /usr/lib/postfix/dict_mysql.so        dict_mysql_open

Mainly the last line is important and seems it's missing in your config. Either try to add it manually or do the uninstall, reinstall of the postfix-mysql and restart postfix by executing:

apt-get --purge remove postfix-mysql
apt-get install postfix-mysql
service postfix restart

I add it manually.
#postconf -m
btree
cidr
environ
fail
hash
internal
memcache
mysql
nis
pcre
proxy
regexp
sdbm
sqlite
static
tcp
texthash
unix

thank you, one of my error disappeared.

10 Reply by mehdizadeh_1986

  • mehdizadeh_1986
  • Member
  • Offline
  • Registered: 2013-12-24
  • Posts: 18

Re: iredmail error

I still have error in rouncube:
SMTP Error (451): Failed to add recipient "postmaster@mydomain.com" (4.3.0 <postmaster@mydomain.com>: Temporary lookup failure).

mail.log:
Dec 29 09:30:32 server1 postfix/smtpd[5114]: connect from localhost[127.0.0.1]
Dec 29 09:30:32 server1 postfix/smtpd[5114]: NOQUEUE: reject: RCPT from localhost[127.0.0.1]: 451 4.3.0 <postmaster@mydomainserver.com>: Temporary lookup failure; from=<postmaster@mydomainfserver.com> to=<postmaster@mydomainserver.com> proto=ESMTP helo=<127.0.0.1>
Dec 29 09:30:32 server1 roundcube: SMTP Error: SMTP error: Failed to add recipient 'postmaster@zharfserver.com' in /usr/share/apache2/roundcubemail-0.9.5/program/include/rcmail.php on line 1035 (POST /mail/?_unlock=loading1388296832173&_lang=undefined?_task=mail&_action=send)
Dec 29 09:30:32 server1 postfix/smtpd[5114]: disconnect from localhost[127.0.0.1]
Dec 29 09:30:40 server1 postfix/pickup[4415]: 639712C0103: uid=1000 from=<zharf>
Dec 29 09:30:40 server1 postfix/proxymap[4419]: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf is unavailable. open /etc/postfix/mysql/sender_bcc_maps_domain.cf: Permission denied
Dec 29 09:30:40 server1 postfix/cleanup[4897]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf lookup error for "zharf@server1.mydomain.com"
Dec 29 09:30:40 server1 postfix/cleanup[4897]: warning: 639712C0103: sender_bcc_maps lookup problem
Dec 29 09:30:40 server1 postfix/pickup[4415]: warning: maildrop/2F5692C0102: error writing 639712C0103: queue file write error
Dec 29 09:30:40 server1 postfix/pickup[4415]: 641D32C0103: uid=0 from=<root>
Dec 29 09:30:40 server1 postfix/proxymap[4419]: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf is unavailable. open /etc/postfix/mysql/sender_bcc_maps_domain.cf: Permission denied
Dec 29 09:30:40 server1 postfix/cleanup[4418]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf lookup error for "root@server1.mydomain.com"
Dec 29 09:30:40 server1 postfix/cleanup[4418]: warning: 641D32C0103: sender_bcc_maps lookup problem
Dec 29 09:30:40 server1 postfix/pickup[4415]: warning: maildrop/3E76D2C0100: error writing 641D32C0103: queue file write error
Dec 29 09:30:40 server1 postfix/pickup[4415]: warning: 6488B2C0103: message has been queued for 3 days
Dec 29 09:30:40 server1 postfix/pickup[4415]: 6488B2C0103: uid=0 from=<root>
Dec 29 09:30:40 server1 postfix/proxymap[4419]: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf is unavailable. open /etc/postfix/mysql/sender_bcc_maps_domain.cf: Permission denied
Dec 29 09:30:40 server1 postfix/cleanup[4897]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf lookup error for "root@server1.mydomain.com"
Dec 29 09:30:40 server1 postfix/cleanup[4897]: warning: 6488B2C0103: sender_bcc_maps lookup problem
Dec 29 09:30:40 server1 postfix/pickup[4415]: warning: maildrop/A2E4A2C00FE: error writing 6488B2C0103: queue file write error
Dec 29 09:30:40 server1 postfix/pickup[4415]: 64D202C0103: uid=0 from=<root>
Dec 29 09:30:40 server1 postfix/proxymap[4419]: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf is unavailable. open /etc/postfix/mysql/sender_bcc_maps_domain.cf: Permission denied
Dec 29 09:30:40 server1 postfix/cleanup[4418]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf lookup error for "root@server1.mydomain.com"
Dec 29 09:30:40 server1 postfix/cleanup[4418]: warning: 64D202C0103: sender_bcc_maps lookup problem
Dec 29 09:30:40 server1 postfix/pickup[4415]: warning: maildrop/1F93E2C0101: error writing 64D202C0103: queue file write error
Dec 29 09:30:40 server1 postfix/pickup[4415]: warning: 651052C0103: message has been queued for 3 days
Dec 29 09:30:40 server1 postfix/pickup[4415]: 651052C0103: uid=0 from=<root>
Dec 29 09:30:40 server1 postfix/proxymap[4419]: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf is unavailable. open /etc/postfix/mysql/sender_bcc_maps_domain.cf: Permission denied
Dec 29 09:30:40 server1 postfix/cleanup[4897]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf lookup error for "root@server1.mydomain.com"
Dec 29 09:30:40 server1 postfix/cleanup[4897]: warning: 651052C0103: sender_bcc_maps lookup problem
Dec 29 09:30:40 server1 postfix/pickup[4415]: warning: maildrop/713DA2C00FA: error writing 651052C0103: queue file write error
Dec 29 09:30:40 server1 postfix/pickup[4415]: warning: 6549F2C0103: message has been queued for 2 days
Dec 29 09:30:40 server1 postfix/pickup[4415]: 6549F2C0103: uid=1000 from=<zharf>
Dec 29 09:30:40 server1 postfix/proxymap[4419]: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf is unavailable. open /etc/postfix/mysql/sender_bcc_maps_domain.cf: Permission denied
Dec 29 09:30:40 server1 postfix/cleanup[4418]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf lookup error for "zharf@server1.mydomain.com"
Dec 29 09:30:40 server1 postfix/cleanup[4418]: warning: 6549F2C0103: sender_bcc_maps lookup problem
Dec 29 09:30:40 server1 postfix/pickup[4415]: warning: maildrop/6F9142C00FF: error writing 6549F2C0103: queue file write error
Dec 29 09:30:40 server1 postfix/pickup[4415]: warning: 659132C0103: message has been queued for 3 days
Dec 29 09:30:40 server1 postfix/pickup[4415]: 659132C0103: uid=0 from=<root>
Dec 29 09:30:40 server1 postfix/proxymap[4419]: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf is unavailable. open /etc/postfix/mysql/sender_bcc_maps_domain.cf: Permission denied
Dec 29 09:30:40 server1 postfix/cleanup[4897]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf lookup error for "root@server1.mydomain.com"
Dec 29 09:30:40 server1 postfix/cleanup[4897]: warning: 659132C0103: sender_bcc_maps lookup problem
Dec 29 09:30:40 server1 postfix/pickup[4415]: warning: maildrop/A3DD22C00FD: error writing 659132C0103: queue file write error
Dec 29 09:30:40 server1 postfix/pickup[4415]: warning: 65C832C0103: message has been queued for 3 days
Dec 29 09:30:40 server1 postfix/pickup[4415]: 65C832C0103: uid=0 from=<root>
Dec 29 09:30:40 server1 postfix/proxymap[4419]: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf is unavailable. open /etc/postfix/mysql/sender_bcc_maps_domain.cf: Permission denied
Dec 29 09:30:40 server1 postfix/cleanup[4418]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf lookup error for "root@server1.mydomain.com"
Dec 29 09:30:40 server1 postfix/cleanup[4418]: warning: 65C832C0103: sender_bcc_maps lookup problem
Dec 29 09:30:40 server1 postfix/pickup[4415]: warning: maildrop/526E82C00FB: error writing 65C832C0103: queue file write error
Dec 29 09:30:40 server1 postfix/pickup[4415]: warning: 660792C0103: message has been queued for 3 days
Dec 29 09:30:40 server1 postfix/pickup[4415]: 660792C0103: uid=0 from=<root>
Dec 29 09:30:40 server1 postfix/proxymap[4419]: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf is unavailable. open /etc/postfix/mysql/sender_bcc_maps_domain.cf: Permission denied
Dec 29 09:30:40 server1 postfix/cleanup[4897]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf lookup error for "root@server1.mydomain.com"
Dec 29 09:30:40 server1 postfix/cleanup[4897]: warning: 660792C0103: sender_bcc_maps lookup problem
Dec 29 09:30:40 server1 postfix/pickup[4415]: warning: maildrop/D752C2C00FC: error writing 660792C0103: queue file write error

------------------------------------------------------------------------------------------------------------------------------------
why i have root@server1.mydomain.com , zharf@server1.mydomain.com ,postmaster@mydomainserver.com?
Is it right?

Thanks for your help.

11 Reply by ZhangHuangbin

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

Re: iredmail error

All files under /etc/postfix/mysql/ should be owned by user 'root', group 'postfix', file permission 0640.

12 Reply by camel1cz

  • camel1cz
  • camel1cz
  • Member
  • Offline
  • From: Czech Republic
  • Registered: 2013-04-20
  • Posts: 220

Re: iredmail error

Also from the very last line in your log I assume you have wrong permissions of queue directories - should be:

root@email:/var/spool/postfix# ls -l
total 88
drwx------  2 postfix root     20480 Dec 29 10:46 active
drwx------  2 postfix root      4096 Dec 29 08:15 bounce
drwx------  2 postfix root      4096 Apr  9  2013 corrupt
drwx------ 18 postfix root      4096 May 27  2013 defer
drwx------ 18 postfix root      4096 May 27  2013 deferred
drwxr-xr-x  2 root    root      4096 Dec 10 12:19 dev
srw-rw-rw-  1 postfix postfix      0 Nov 26 14:24 dovecot-auth
drwxr-xr-x  3 root    root      4096 Dec 26 19:24 etc
drwx------  2 postfix root      4096 Nov 18 12:12 flush
drwx------  2 postfix root      4096 Apr  9  2013 hold
drwx------  2 postfix root      4096 Dec 29 10:46 incoming
drwxr-xr-x  3 root    root      4096 Apr  9  2013 lib
drwx-wx--T  2 postfix postdrop  4096 Dec 29 10:25 maildrop
drwxr-xr-x  2 root    root      4096 Dec 19 13:25 pid
drwx------  2 postfix root      4096 Dec 26 19:24 private
drwx--s---  2 postfix postdrop  4096 Dec 26 19:24 public
drwx------  2 postfix root      4096 Apr  9  2013 saved
drwx------  2 postfix root      4096 Dec 28 19:15 trace
drwxr-xr-x  3 root    root      4096 Apr  9  2013 usr

Btw. it's very strange you have such issues, I guess you did something wrong during/after installation.

13 Reply by mehdizadeh_1986

  • mehdizadeh_1986
  • Member
  • Offline
  • Registered: 2013-12-24
  • Posts: 18

Re: iredmail error

camel1cz wrote:

permissions of queue directories

They are like yours!

I checked configuration files. i think they are right.
Any idea?

14 Reply by mehdizadeh_1986 (edited by mehdizadeh_1986 2013-12-29 18:10:43)

  • mehdizadeh_1986
  • Member
  • Offline
  • Registered: 2013-12-24
  • Posts: 18

Re: iredmail error

ZhangHuangbin wrote:

All files under /etc/postfix/mysql/ should be owned by user 'root', group 'postfix', file permission 0640.

-rw-rw---- 1 root  www-data 296 Dec 22 14:10 catchall_maps.cf
-rw-rw---- 1 root  www-data 363 Dec 22 14:10 domain_alias_catchall_maps.cf
-rw-rw---- 1 root  www-data 404 Dec 22 14:10 domain_alias_maps.cf
-rw-rw---- 1 root  www-data 218 Dec 22 14:10 recipient_bcc_maps_domain.cf
-rw-rw---- 1 root  www-data 403 Dec 22 14:10 recipient_bcc_maps_user.cf
-rw-rw---- 1 root  www-data 214 Dec 22 14:10 relay_domains.cf
-rw-rw---- 1 root  www-data 215 Dec 22 14:10 sender_bcc_maps_domain.cf
-rwxrwxrwx 1 root  www-data 386 Dec 29 09:21 sender_bcc_maps_user.cf
-rwxr-xr-x 1 zharf www-data 385 Dec 29 09:21 sender_bcc_maps_user.cf~  <=====
-rw-rw---- 1 root  www-data 359 Dec 22 14:10 sender_login_maps.cf
-rw-rw---- 1 root  www-data 217 Dec 22 14:10 transport_maps_domain.cf
-rw-rw---- 1 root  www-data 389 Dec 22 14:10 transport_maps_user.cf
-rw-rw---- 1 root  www-data 317 Dec 22 14:10 virtual_alias_maps.cf
-rwxrwxrwx 1 root  www-data 428 Dec 22 14:10 virtual_mailbox_domains.cf
-rw-rw---- 1 root  www-data 364 Dec 22 14:10 virtual_mailbox_maps.cf

just one of them is not root and i can't modify.

15 Reply by camel1cz

  • camel1cz
  • camel1cz
  • Member
  • Offline
  • From: Czech Republic
  • Registered: 2013-04-20
  • Posts: 220

Re: iredmail error

To the config file permissions:
- you have wrong group of ownership of all map files (www-data),
- fix it by executing:

chown root:postfix /etc/postfix/mysql/*.cf
chmod 0640 /etc/postfix/mysql/*.cf

To the queue permissins:
- your system complains about not beeing able to write to the folder /var/spool/postfix/maildrop / please post the output of:

ls -l /var/spool/postfix

16 Reply by mehdizadeh_1986

  • mehdizadeh_1986
  • Member
  • Offline
  • Registered: 2013-12-24
  • Posts: 18

Re: iredmail error

camel1cz wrote:
ls -l /var/spool/postfix

drwx------ 2 postfix root     4096 Dec 25 10:54 active
drwx------ 2 postfix root     4096 Dec 25 10:54 bounce
drwx------ 2 postfix root     4096 Dec 12 13:05 corrupt
drwx------ 2 postfix root     4096 Dec 12 13:05 defer
drwx------ 2 postfix root     4096 Dec 12 13:05 deferred
drwxr-xr-x 2 root    root     4096 Dec 30 09:00 dev
srw-rw-rw- 1 postfix postfix     0 Dec 30 09:00 dovecot-auth
drwxr-xr-x 3 root    root     4096 Dec 30 09:00 etc
drwx------ 2 postfix root     4096 Dec 12 13:05 flush
drwx------ 2 postfix root     4096 Dec 12 13:06 hold
drwx------ 2 postfix root     4096 Dec 30 09:07 incoming
drwxr-xr-x 3 root    root     4096 Dec 30 09:00 lib
drwx-wx--T 2 postfix postdrop 4096 Dec 28 13:05 maildrop
drwxr-xr-x 2 root    root     4096 Dec 15 13:31 pid
drwx------ 2 postfix root     4096 Dec 30 09:00 private
drwx--s--- 2 postfix postdrop 4096 Dec 30 09:00 public
drwx------ 2 postfix root     4096 Dec 12 13:05 saved
drwx------ 2 postfix root     4096 Dec 12 13:06 trace
drwxr-xr-x 3 root    root     4096 Dec 12 13:05 usr
drwxrwxrwx 3 root    root     4096 Dec 15 09:49 var

17 Reply by camel1cz

  • camel1cz
  • camel1cz
  • Member
  • Offline
  • From: Czech Republic
  • Registered: 2013-04-20
  • Posts: 220

Re: iredmail error

Seems OK / what is in your logs when you try to send email? (don't forget to restart postfix before trying)

18 Reply by mehdizadeh_1986

  • mehdizadeh_1986
  • Member
  • Offline
  • Registered: 2013-12-24
  • Posts: 18

Re: iredmail error

camel1cz wrote:

Seems OK / what is in your logs when you try to send email? (don't forget to restart postfix before trying)

Jan  1 08:39:44 server1 postfix/smtpd[5933]: error: unsupported dictionary type: pcre
Jan  1 08:39:45 server1 postfix/smtpd[5933]: connect from localhost[127.0.0.1]
Jan  1 08:39:45 server1 cbpolicyd[4190]: module=Core, action=pass, host=127.0.0.1, from=127.0.0.1, to=postmaster@zharfserver.com, reason=db_failure_bypass
Jan  1 08:39:45 server1 postfix/smtpd[5933]: 1748D2C101E: client=localhost[127.0.0.1], sasl_method=LOGIN, sasl_username=postmaster@mydomain.com
Jan  1 08:39:46 server1 cbpolicyd[4189]: module=Core, action=pass, host=127.0.0.1, from=127.0.0.1, to=postmaster@mydomain.com, reason=db_failure_bypass
Jan  1 08:39:46 server1 postfix/cleanup[5938]: 1748D2C101E: message-id=<cb61cae309cdd95c5ae93c73e4cbaf7e@mydomain.com>
Jan  1 08:39:46 server1 postfix/qmgr[5916]: 1748D2C101E: from=<postmaster@mydomain.com>, size=551, nrcpt=1 (queue active)
Jan  1 08:39:46 server1 roundcube: User postmaster@mydomain.com [127.0.0.1]; Message for postmaster@zharfserver.com; 250: 2.0.0 Ok: queued as 1748D2C101E
Jan  1 08:39:46 server1 roundcube: IMAP Error: Could not save message in Sent in /usr/share/apache2/roundcubemail-0.9.5/program/steps/mail/sendmail.inc on line 779 (POST /mail/?_unlock=loading1388552984409&_lang=undefined?_task=mail&_action=send)
Jan  1 08:39:46 server1 postfix/smtpd[5933]: disconnect from localhost[127.0.0.1]

19 Reply by camel1cz

  • camel1cz
  • camel1cz
  • Member
  • Offline
  • From: Czech Republic
  • Registered: 2013-04-20
  • Posts: 220

Re: iredmail error

mehdizadeh_1986 wrote:

Jan  1 08:39:44 server1 postfix/smtpd[5933]: error: unsupported dictionary type: pcre

Is pcre in the output of:

postconf -m

and is the package postfix-pcre installed?

Also check for errors/warnings after restart of postfix - such problems can be caused by error in config file (eg. syntax error etc.)

20 Reply by mehdizadeh_1986 (edited by mehdizadeh_1986 2014-01-04 12:55:48)

  • mehdizadeh_1986
  • Member
  • Offline
  • Registered: 2013-12-24
  • Posts: 18

Re: iredmail error

sorry for my late answer.

camel1cz wrote:

Is pcre in the output of postconf -m

I installed postfix-pcre and then restart postfix. Now pcre  is in the output of postconf -m.

And now error changed to(mail.log):

Jan  4 08:18:16 server1 postfix/smtpd[5273]: connect from localhost[127.0.0.1]
Jan  4 08:18:16 server1 cbpolicyd[4378]: module=Core, action=pass, host=127.0.0.1, from=127.0.0.1, to=postmaster@mydomain.com, reason=db_failure_bypass
Jan  4 08:18:16 server1 postfix/smtpd[5273]: C37C12C101D: client=localhost[127.0.0.1], sasl_method=LOGIN, sasl_username=postmaster@mydomain.com
Jan  4 08:18:17 server1 cbpolicyd[4375]: module=Core, action=pass, host=127.0.0.1, from=127.0.0.1, to=postmaster@mydomain.com, reason=db_failure_bypass
Jan  4 08:18:17 server1 postfix/cleanup[5277]: C37C12C101D: message-id=<486ce131082cb6624fc68731f97339c4@mydomain.com>
Jan  4 08:18:17 server1 postfix/qmgr[4453]: C37C12C101D: from=<postmaster@mydomain.com>, size=550, nrcpt=1 (queue active)
Jan  4 08:18:17 server1 roundcube: User postmaster@mydomain.com [127.0.0.1]; Message for postmaster@mydomain.com; 250: 2.0.0 Ok: queued as C37C12C101D
Jan  4 08:18:17 server1 roundcube: IMAP Error: Could not save message in Sent in /usr/share/apache2/roundcubemail-0.9.5/program/steps/mail/sendmail.inc on line 779 (POST /mail/?_unlock=loading1388810896066&_lang=undefined?_task=mail&_action=send)
Jan  4 08:18:17 server1 postfix/smtpd[5273]: disconnect from localhost[127.0.0.1]
Jan  4 08:18:19 server1 postfix/smtpd[5298]: connect from localhost[127.0.0.1]
Jan  4 08:18:19 server1 postfix/smtpd[5298]: 521372C102A: client=localhost[127.0.0.1]
Jan  4 08:18:19 server1 postfix/cleanup[5277]: 521372C102A: message-id=<486ce131082cb6624fc68731f97339c4@mydomain.com>
Jan  4 08:18:19 server1 postfix/qmgr[4453]: 521372C102A: from=<postmaster@mydomain.com>, size=1626, nrcpt=1 (queue active)
Jan  4 08:18:19 server1 postfix/smtpd[5298]: disconnect from localhost[127.0.0.1]
Jan  4 08:18:19 server1 amavis[2897]: (02897-01) Passed CLEAN {RelayedInternal}, MYNETS/MYUSERS LOCAL [127.0.0.1]:37506 [127.0.0.1] <postmaster@mydomain.com> -> <postmaster@mydomain.com>, Queue-ID: C37C12C101D, Message-ID: <486ce131082cb6624fc68731f97339c4@mydomain.com>, mail_id: H_wELZkHrY3V, Hits: -8.819, size: 550, queued_as: 521372C102A, dkim_new=dkim:mydomain.com, 1506 ms
Jan  4 08:18:19 server1 postfix/pipe[5150]: 521372C102A: to=<postmaster@mydomain.com>, relay=dovecot, delay=0.17, delays=0.07/0/0/0.1, dsn=4.3.0, status=deferred (temporary failure)
Jan  4 08:18:19 server1 postfix/smtp[5285]: C37C12C101D: to=<postmaster@mydomain.com>, relay=127.0.0.1[127.0.0.1]:10024, delay=3, delays=1.3/0.03/0.02/1.6, dsn=2.0.0, status=sent (250 2.0.0 from MTA(smtp:[127.0.0.1]:10025): 250 2.0.0 Ok: queued as 521372C102A)
Jan  4 08:18:19 server1 postfix/qmgr[4453]: C37C12C101D: removed

21 Reply by camel1cz

  • camel1cz
  • camel1cz
  • Member
  • Offline
  • From: Czech Republic
  • Registered: 2013-04-20
  • Posts: 220

Re: iredmail error

Is cluebringer running correctly on your system?

Try to restart it

/etc/init.d/postfix-cluebringer restart

and check relevant lines in /var/log/cbpolicyd.log - post it here if possible.

22 Reply by ZhangHuangbin

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

Re: iredmail error

mehdizadeh_1986 wrote:

Jan  4 08:18:17 server1 cbpolicyd[4375]: module=Core, action=pass, host=127.0.0.1, from=127.0.0.1, to=postmaster@mydomain.com, reason=db_failure_bypass

I guess you don't have correct SQL username/password in Cluebringer config file.

Personally, if an iRedMail installation has so many unexpected error/issues, i prefer to re-install server os then re-install iRedMail to get a working one.

23 Reply by mehdizadeh_1986

  • mehdizadeh_1986
  • Member
  • Offline
  • Registered: 2013-12-24
  • Posts: 18

Re: iredmail error

camel1cz wrote:

check relevant lines in /var/log/cbpolicyd.log

root@server1:/home/zharf# tail -f /var/log/cbpolicyd.log
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/local/lib/postfix-cluebringer /usr/lib/postfix-cluebringer /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl .) at (eval 27) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Pg, Proxy, Sponge.
at /usr/lib/postfix-cluebringer/cbp/dbilayer.pm line 119
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/local/lib/postfix-cluebringer /usr/lib/postfix-cluebringer /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl .) at (eval 27) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Pg, Proxy, Sponge.
at /usr/lib/postfix-cluebringer/cbp/dbilayer.pm line 119

ZhangHuangbin wrote:

Personally, if an iRedMail installation has so many unexpected error/issues, i prefer to re-install server os then re-install iRedMail to get a working one.

I reinstall mysql and iredmail but it has still error and also i can't reinstall debian again.

Sorry, I don't know  what these errors mean.

Thanks for your help.

24 Reply by ZhangHuangbin

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

Re: iredmail error

mehdizadeh_1986 wrote:

install_driver(mysql) failed: Can't locate DBD/mysql.pm

It means you don't have package "p5-DBD-mysql" installed.

25 Reply by camel1cz (edited by camel1cz 2014-01-05 17:56:11)

  • camel1cz
  • camel1cz
  • Member
  • Offline
  • From: Czech Republic
  • Registered: 2013-04-20
  • Posts: 220

Re: iredmail error

On Debian the package is called libdbd-mysql-perl

So install it by running

apt-cache search libdbd-mysql-perl