1 Topic by Jochie

  • Jochie
  • Jochie
  • Member
  • Offline
  • Registered: 2010-09-23
  • Posts: 100

Topic: internal error on whitelist/blacklist overview from Pro admin

==== Required information ====
- iRedMail version:  1.8.2
- 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:


====

link : https://mailserver/iredadmin/system/blacklist

log says : OperationalError: (1045, "Access denied for user 'iredadmin'@'localhost' (using password: NO)")


I would like to see my whitelist and/or blacklist, but some authorisation seems to be missing.
Can you help ?

----

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

Re: internal error on whitelist/blacklist overview from Pro admin

Jochie wrote:

log says : OperationalError: (1045, "Access denied for user 'iredadmin'@'localhost' (using password: NO)")

Do you have correct username/password in iRedAdmin-Pro config file? for example:

[iredadmin]
# Database used to store iRedAdmin data. e.g. sessions, log.                                        
host = 127.0.0.1
port = 3306
db = iredadmin
user = iredadmin
passwd = secret_passwd

3 Reply by Jochie

  • Jochie
  • Jochie
  • Member
  • Offline
  • Registered: 2010-09-23
  • Posts: 100

Re: internal error on whitelist/blacklist overview from Pro admin

Yes,
I can login the MySQL dbase with the credentials from my config.
Unfortunately i can't seem to find the correct issue here.

Under
the option :

[policyd]

# Enable policyd integration: True, False.
enabled = True

# SQL Database used to store policyd data, eg. whitelist, blacklist.
# You can find related information in policyd config files:
#   - On RHEL/CentOS:   /etc/policyd.conf
#   - On Debian/Ubuntu: /etc/postfix-policyd.conf
#   - On FreeBSD:       /usr/local/etc/policyd.conf
# Related parameters:
#   host    -> MYSQLHOST
#   port    -> 3306 (Default)
#   db      -> MYSQLDBASE
#   user    -> MYSQLUSER
#   passwd  -> MYSQLPASS

#host = host_of_policyd_sql_server
#port = port_of_policyd_sql_server
#db = policyd
#user = policyd
#passwd = password_of_policyd_db
host = 127.0.0.1
port = 3306
db =
user =
passwd =

Should this be empty?


ZhangHuangbin wrote:
Jochie wrote:

log says : OperationalError: (1045, "Access denied for user 'iredadmin'@'localhost' (using password: NO)")

Do you have correct username/password in iRedAdmin-Pro config file? for example:

[iredadmin]
# Database used to store iRedAdmin data. e.g. sessions, log.                                        
host = 127.0.0.1
port = 3306
db = iredadmin
user = iredadmin
passwd = secret_passwd

4 Reply by ZhangHuangbin

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

Re: internal error on whitelist/blacklist overview from Pro admin

Jochie wrote:

Should this be empty?

No. Please fill correct settings in section "[policyd]". You can find SQL username/password in /etc/postfix-policyd.conf.

5 Reply by Jochie (edited by Jochie 2012-10-25 03:32:12)

  • Jochie
  • Jochie
  • Member
  • Offline
  • Registered: 2010-09-23
  • Posts: 100

Re: internal error on whitelist/blacklist overview from Pro admin

ZhangHuangbin wrote:
Jochie wrote:

Should this be empty?

No. Please fill correct settings in section "[policyd]". You can find SQL username/password in /etc/postfix-policyd.conf.

edit : /etc/postfix-policyd.conf
^^
This file isnt present.
Thats weird.

Do you have any idea how it could be absent?

What should i do to get it up and running?

Thanks

6 Reply by ZhangHuangbin

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

Re: internal error on whitelist/blacklist overview from Pro admin

Jochie wrote:

edit : /etc/postfix-policyd.conf
^^
This file isnt present.

Do you have package postfix-policyd installed on your Debian 6?