1 Topic by ketan.aagja (edited by ketan.aagja 2013-12-21 02:50:56)

  • ketan.aagja
  • Member
  • Offline
  • From: UK
  • Registered: 2012-05-15
  • Posts: 252

Topic: unable to connect to DNS - Amavisd issue

==== Required information ====
- iRedMail version: iRedAdmin -Pro 2.0, iRedAdmin 0.8.6
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):  LDAP
- Linux/BSD distribution name and version: CentOS 6.5 Final
- Related log if you're reporting an issue:
====


Dec 20 18:22:55 mail1 amavis[4307]: (04307-01) (!)connect_to_sql: unable to connect to DSN 'DBI:mysql:database=amavisd;host=127.0.0.1;port=3306': Can't connect to MySQL server on '127.0.0.1' (111)
Dec 20 18:22:55 mail1 amavis[4307]: (04307-01) (!!)TROUBLE in check_mail: gen_mail_id FAILED: connect_to_sql: unable to connect to any dataset at (eval 113) line 252.
Dec 20 18:22:55 mail1 amavis[4307]: (04307-01) (!)PRESERVING EVIDENCE in /var/spool/amavisd/tmp/amavis-20131220T182255-04307-1DfSNnxD
Dec 20 18:22:55 mail1 amavis[4306]: (04306-02) (!)connect_to_sql: unable to connect to DSN 'DBI:mysql:database=amavisd;host=127.0.0.1;port=3306': Can't connect to MySQL server on '127.0.0.1' (111)
Dec 20 18:22:55 mail1 amavis[4306]: (04306-02) (!!)TROUBLE in check_mail: gen_mail_id FAILED: connect_to_sql: unable to connect to any dataset at (eval 113) line 252.
Dec 20 18:22:55 mail1 amavis[4306]: (04306-02) (!)PRESERVING EVIDENCE in /var/spool/amavisd/tmp/amavis-20131220T182255-04306-_ElatCuH

----

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: unable to connect to DNS - Amavisd issue

ketan.aagja wrote:

Can't connect to MySQL server on '127.0.0.1' (111)

Amavisd cannot connect to MySQL server on '127.0.0.1', do you have correct SQL username and password in Amavisd setting "@storage_sql_dsn" in config file /etc/amavisd/amavisd.conf?

3 Reply by ketan.aagja

  • ketan.aagja
  • Member
  • Offline
  • From: UK
  • Registered: 2012-05-15
  • Posts: 252

Re: unable to connect to DNS - Amavisd issue

yes zhang, it was having correct user name and password but as it was live secondary mail server we could not wait further to rectify the issue and as primary server was working fine we rebuild our secondary server with latest iRedMail server.

But now this is new server setup and all new... now if I go to domain properties in my iRedAdmin-Pro panel and try to assign "Domain quota size or Default quota of new user" to something else it is not allowing. it is just stays as it is without changing anything. no respective logs are also generated to detect the issue here...

4 Reply by ZhangHuangbin

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

Re: unable to connect to DNS - Amavisd issue

ketan.aagja wrote:

now if I go to domain properties in my iRedAdmin-Pro panel and try to assign "Domain quota size or Default quota of new user" to something else it is not allowing.

Sorry, are you talking about the same issue or a new one?
Did you try the latest iRedAdmin-Pro-LDAP-2.1? And did you upgrade your iRedMail to the latest stable release, 0.8.6?

5 Reply by ketan.aagja (edited by ketan.aagja 2013-12-24 18:27:10)

  • ketan.aagja
  • Member
  • Offline
  • From: UK
  • Registered: 2012-05-15
  • Posts: 252

Re: unable to connect to DNS - Amavisd issue

Yes Zhang, its newly installed iRedAdmin-Pro-LDAP-2.1 where "Domain quota size or Default quota of new user" not getting updated. This is new installation not upgrade where this issue is happening.

Attached is the screenshot of server edition for reference.

Post's attachments

iredadminpro.JPG
iredadminpro.JPG 27.75 kb, file has never been downloaded. 

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

6 Reply by ZhangHuangbin

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

Re: unable to connect to DNS - Amavisd issue

It's confirmed it's a bug in iRedAdmin-Pro-LDAP-2.1, fixed moment ago. I will release a new version soon.
Thanks very much for your feedback.