1 Topic by stefan.w

  • stefan.w
  • Member
  • Offline
  • Registered: 2014-10-27
  • Posts: 3

Topic: iredadminpro policyd mysql error

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

I've just iRedMail together with iRedMailPro following the 2 guides below:

http://www.iredmail.org/docs/install.ir … buntu.html
http://iredmail.org/wiki/index.php?titl … SQL/Debian

For some reason I receive the following error in apache when I click on the default domainname in the Domains and Accounts page.

[Mon Oct 27 13:52:34 2014] [error] [client 10.100.0.159] OperationalError: (1045, "Access denied for user 'policyd'@'localhost' (using password: YES)")
[Mon Oct 27 13:52:34 2014] [error] [client 10.100.0.159]

I have checked /usr/share/apache2/iredadmin/settings.py and it seems that there is no policy_db_password in this file, but also I can not find this password in /root/iRedMail-0.8.7/config.

When I look in mysql as root I can not find a DB called policyd.

Please advise

----

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: iredadminpro policyd mysql error

Hi Stefan,

Do you have file '/etc/init.d/postfix-policyd'? If yes, please find SQL database info in file /etc/postfix-policyd.conf. if not, you must have file /etc/cluebringer/cluebringer.conf.

For Policyd, it uses SQL database "postfixpolicyd". For Cluebringer, it's database "cluebringer".

3 Reply by stefan.w

  • stefan.w
  • Member
  • Offline
  • Registered: 2014-10-27
  • Posts: 3

Re: iredadminpro policyd mysql error

Zhang,

Thanks for the response.

I have /etc/init.d/postfix-cluebringer but not postfix-policyd.

The file /etc/postfix-policyd.conf is not located on my server currently, /etc/cluebringer/cluebringer.conf is.

I've already tried changing the following in /usr/share/apache2/iredadmin/settings.py:

policyd_db_name = 'policyd'
policyd_db_user = 'policyd'
policyd_db_password = 'password'

to

policyd_db_name = 'cluebringer'
policyd_db_user = 'cluebringer'
policyd_db_password = 'password'

But then it still says the same in the apache log, so I've changed the db settings in settings.py to cluebringer but it still tries to login with policyd. Is there any other place where I should change the database connection?

[Tue Oct 28 10:48:07 2014] [error] [client 10.100.0.159] OperationalError: (1045, "Access denied for user 'policyd'@'localhost' (using password: YES)")

4 Reply by stefan.w

  • stefan.w
  • Member
  • Offline
  • Registered: 2014-10-27
  • Posts: 3

Re: iredadminpro policyd mysql error

I have managed to fix the problem myself, for some reason my settings.py had a typo in it.