1 Topic by dbanie (edited by dbanie 2016-06-21 16:12:10)

  • dbanie
  • Member
  • Offline
  • Registered: 2015-08-21
  • Posts: 10

Topic: Cannot send email

======== Required information ====
- iRedMail version (check /etc/iredmail-release):      v0.9.5-1
- Linux/BSD distribution name and version: Ubuntu Server 16.04
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL (MariaDB)
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? No
- Related log if you're reporting an issue:

/var/log/mail.log

Jun 21 14:59:52 advn-fileserver postfix/pickup[6489]: B6350E06EE: uid=0 from=<root>
Jun 21 14:59:52 advn-fileserver postfix/proxymap[9644]: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf is unavailable. unsupported dictionary type: mysql
Jun 21 14:59:52 advn-fileserver postfix/cleanup[9783]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@advn-fileserver.co"
Jun 21 14:59:52 advn-fileserver postfix/cleanup[9783]: warning: B6350E06EE: sender_bcc_maps map lookup problem -- message not accepted, try again later
Jun 21 14:59:52 advn-fileserver postfix/pickup[6489]: warning: maildrop/D55BCE068F: error writing B6350E06EE: queue file write error
Jun 21 14:59:53 advn-fileserver postfix/pickup[6489]: warning: B6A84E06EE: message has been queued for 1 days
 
# postconf -m
btree
cidr
environ
fail
hash
inline
internal
ldap
memcache
mysql
nis
pcre
pipemap
proxy
randmap
regexp
socketmap
sqlite
static
tcp
tcp
texthash
unionmap
unix

====

I already search in the forum and try to fix it but fail the error still exist, My disk space is not full only 20% Used. Please help?

Thanks in Advance,
dbanie

Post's attachments

Firefox_Screenshot_2016-06-21T08-00-20.389Z.png
Firefox_Screenshot_2016-06-21T08-00-20.389Z.png 48.75 kb, 1 downloads since 2016-06-21 

You don't have the permssions to download the attachments of this post.

----

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: Cannot send email

Do you have package 'postfix-mysql' installed?

3 Reply by dbanie

  • dbanie
  • Member
  • Offline
  • Registered: 2015-08-21
  • Posts: 10

Re: Cannot send email

ZhangHuangbin wrote:

Do you have package 'postfix-mysql' installed?

Hi Zhang,

Yes, I have it installed.

~# apt-get install postfix-mysql postfix-pcre
Reading package lists... Done
Building dependency tree       
Reading state information... Done
postfix-mysql is already the newest version (3.1.0-3).
postfix-pcre is already the newest version (3.1.0-3).
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.

4 Reply by ZhangHuangbin

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

Re: Cannot send email

dbanie wrote:

/etc/postfix/mysql/sender_bcc_maps_user.cf

Do you use 'localhost' or '127.0.0.1' as MySQL server address in /etc/postfix/mysql/*.cf?

Also, show us output of commands below please:

ls -dl /etc/postfix/mysql
ls -dl /etc/postfix/mysql/*

5 Reply by dbanie

  • dbanie
  • Member
  • Offline
  • Registered: 2015-08-21
  • Posts: 10

Re: Cannot send email

Hi Zhang,

I use 127.0.0.1 in all the .cf, below is the details

~# ls -dl /etc/postfix/mysql
drwxr-xr-x 2 root root 4096 Jun 23 11:24 /etc/postfix/mysql

~# ls -dl /etc/postfix/mysql/*
-rw-r----- 1 root postfix 322 Jun 20 11:58 /etc/postfix/mysql/catchall_maps.cf
-rw-r----- 1 root postfix 363 Jun 20 11:58 /etc/postfix/mysql/domain_alias_catchall_maps.cf
-rw-r----- 1 root postfix 404 Jun 20 11:58 /etc/postfix/mysql/domain_alias_maps.cf
-rw-r----- 1 root postfix 218 Jun 20 11:58 /etc/postfix/mysql/recipient_bcc_maps_domain.cf
-rw-r----- 1 root postfix 403 Jun 20 11:58 /etc/postfix/mysql/recipient_bcc_maps_user.cf
-rw-r----- 1 root postfix 214 Jun 20 11:58 /etc/postfix/mysql/relay_domains.cf
-rw-r----- 1 root postfix 215 Jun 20 11:58 /etc/postfix/mysql/sender_bcc_maps_domain.cf
-rw-r----- 1 root postfix 385 Jun 23 11:24 /etc/postfix/mysql/sender_bcc_maps_user.cf
-rw-r----- 1 root postfix 208 Jun 20 11:58 /etc/postfix/mysql/sender_dependent_relayhost_maps.cf
-rw-r----- 1 root postfix 359 Jun 20 11:58 /etc/postfix/mysql/sender_login_maps.cf
-rw-r----- 1 root postfix 202 Jun 20 11:58 /etc/postfix/mysql/transport_maps_domain.cf
-rw-r----- 1 root postfix 389 Jun 20 11:58 /etc/postfix/mysql/transport_maps_user.cf
-rw-r----- 1 root postfix 317 Jun 20 11:58 /etc/postfix/mysql/virtual_alias_maps.cf
-rw-r----- 1 root postfix 428 Jun 20 11:58 /etc/postfix/mysql/virtual_mailbox_domains.cf
-rw-r----- 1 root postfix 364 Jun 20 11:58 /etc/postfix/mysql/virtual_mailbox_maps.cf

~# grep "hosts" /etc/postfix/mysql/*.cf
/etc/postfix/mysql/catchall_maps.cf:hosts       = 127.0.0.1
/etc/postfix/mysql/domain_alias_catchall_maps.cf:hosts       = 127.0.0.1
/etc/postfix/mysql/domain_alias_maps.cf:hosts       = 127.0.0.1
/etc/postfix/mysql/recipient_bcc_maps_domain.cf:hosts       = 127.0.0.1
/etc/postfix/mysql/recipient_bcc_maps_user.cf:hosts       = 127.0.0.1
/etc/postfix/mysql/relay_domains.cf:hosts       = 127.0.0.1
/etc/postfix/mysql/sender_bcc_maps_domain.cf:hosts       = 127.0.0.1
/etc/postfix/mysql/sender_bcc_maps_user.cf:hosts       = 127.0.0.1
/etc/postfix/mysql/sender_dependent_relayhost_maps.cf:hosts       = 127.0.0.1
/etc/postfix/mysql/sender_login_maps.cf:hosts       = 127.0.0.1
/etc/postfix/mysql/transport_maps_domain.cf:hosts       = 127.0.0.1
/etc/postfix/mysql/transport_maps_user.cf:hosts       = 127.0.0.1
/etc/postfix/mysql/virtual_alias_maps.cf:hosts       = 127.0.0.1
/etc/postfix/mysql/virtual_mailbox_domains.cf:hosts       = 127.0.0.1
/etc/postfix/mysql/virtual_mailbox_maps.cf:hosts       = 127.0.0.1

/* My SQL Config */
~# egrep -w -R "host|bind-address" /etc/mysql/*.cnf
/etc/mysql/debian.cnf:host     = localhost
/etc/mysql/debian.cnf:host     = localhost
/etc/mysql/my.cnf:bind-address        = 127.0.0.1

TA,
dbanie

6 Reply by ZhangHuangbin

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

Re: Cannot send email

Weird, it's clueless, may need ssh access for more debug. Are you willing to buy a support ticket for this?
http://www.iredmail.org/support.html

7 Reply by dbanie

  • dbanie
  • Member
  • Offline
  • Registered: 2015-08-21
  • Posts: 10

Re: Cannot send email

ZhangHuangbin wrote:

Weird, it's clueless, may need ssh access for more debug. Are you willing to buy a support ticket for this?
http://www.iredmail.org/support.html

I'm willing to buying you coffee smile , But I manage to fixed it, it seems my postfix-sendmail need to reinstall

One last question because after it fixed, manage to sent the email but it seems my ISP block port 25 thats why i got this error on mail.log.

connect to alt1.gmail-smtp-in.l.google.com[173.194.72.27]:25: Connection timed out

is there any solution to change the default port to sent from roundcube maybe using port 465 or 587

Thanks in Advance,
dbanie

will buying you coffee after I manage to run it smile

8 Reply by ZhangHuangbin

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

Re: Cannot send email

Port 25 is used for communication between mail servers. If you ISP blocks port 25, other mail servers cannot send email to you at all, you won't receive any email from external network.

9 Reply by elfueda

  • elfueda
  • Member
  • Offline
  • Registered: 2013-08-22
  • Posts: 10

Re: Cannot send email

I have the same exact problem with the same exact troubleshooting. Reinstalled postfix didn't help. Any thoughts?

10 Reply by Cthulhu

  • Cthulhu
  • Member
  • Offline
  • Registered: 2019-06-04
  • Posts: 907

Re: Cannot send email

Yeah, main thought is opening an own thread and not dig out an nearly 6 year old one...

11 Reply by elfueda

  • elfueda
  • Member
  • Offline
  • Registered: 2013-08-22
  • Posts: 10

Re: Cannot send email

LOL. Yes, this problem still happens tho. Found out it was mysql.db that got corrupted. Ran the reinstall script:
mysql_install_db

Then imported the mysql.db I had saved.

12 Reply by elfueda

  • elfueda
  • Member
  • Offline
  • Registered: 2013-08-22
  • Posts: 10

Re: Cannot send email

btw, this is the top return on google when you search for the problem.

It apparently always has to do with credentials on the db. So, that's a good start to troubleshoot.