1 Topic by stannicek

  • stannicek
  • Member
  • Offline
  • Registered: 2015-01-06
  • Posts: 35

Topic: iRedAPD 1.5.0 - wrong pgsql backend credentials used - amavis plugins

==== Required information ====
- iRedMail version: 0.9.0
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): PGSQL
- Web server (Apache or Nginx): Apache
- Linux/BSD distribution name and version: CentOS 6.X
- Related log if you're reporting an issue:
====

iRedAPD-1.5.0/libs/amavisd/core.py line 126-130 contains connect credentials to amavis db, but there are credentials pointing to vmail database -> this make all amavis plugins to fail using pgsql backend.

wrong :
     db = psycopg2.connect(host=settings.sql_server,
                                      port=int(settings.sql_port),
                                      database=settings.sql_db,
                                      user=settings.sql_user,
                                      password=settings.sql_password)

correct :
     db = psycopg2.connect(host=settings.amavisd_db_server,
                                      port=int(settings.amavisd_db_port),
                                      database=settings.amavisd_db_name,
                                      user=settings.amavisd_db_user,
                                      password=settings.amavisd_db_password)

settings.py:

Please, correct me, if i'm wrong.

Best Regards,
Stanislav

----

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: 30,768

Re: iRedAPD 1.5.0 - wrong pgsql backend credentials used - amavis plugins

You're correct. Thanks for the feedback.

BTW, iRedMail-0.9.1 final release will have sql connection pool support, and the code you mentioned above was removed (because we don't need to create sql connection here).