1

Topic: Access denied for user 'iredadmin'@'localhost' (using password: YES)

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

I get the following error
Error: mysql(127.0.0.1): Connect failed to database (iredadmin): Access denied for user 'iredadmin'@'localhost' (using password: YES)
dict: Error: dict sql lookup failed: Not connected to database

I can logon to Iredadmin Panel and setup accounts, I can logon to LDAP,  I can logon onto roundcube but I can't send or receive email because it will not connect to mysql database.

settings.ini

[iredadmin]
# Database used to store iRedAdmin data. e.g. sessions, log.
host =  127.0.0.1
port =  3306
db = iredadmin
user = iredadmin
passwd = my_password  my_password is unecrypted if I try to put an encrypted value in I get an internal service error

I have re ran this several times
mysql -uroot -p
mysql> USE iredadmin;
mysql> SOURCE /var/www/iRedAdmin-0.2/docs/samples/iredadmin.sql;
mysql> GRANT SELECT,INSERT,UPDATE,DELETE ON iredadmin.* TO iredadmin@localhost IDENTIFIED BY 'my_ password';
mysql> FLUSH PRIVILEGES;

I don't know where to go from here

2

Re: Access denied for user 'iredadmin'@'localhost' (using password: YES)

pdugganjr wrote:

I get the following error

Where did you get this error message? In /var/log/dovecot.log?
If so, please make sure you have correct MySQL username/password in /etc/dovecot/dovecot-used-quota.conf.

pdugganjr wrote:

passwd = my_password  my_password is unecrypted if I try to put an encrypted value in I get an internal service error

Please use plain text password here.

3

Re: Access denied for user 'iredadmin'@'localhost' (using password: YES)

ZhangHuangbin wrote:
pdugganjr wrote:

I get the following error

Where did you get this error message? In /var/log/dovecot.log?
If so, please make sure you have correct MySQL username/password in /etc/dovecot/dovecot-used-quota.conf.

pdugganjr wrote:

passwd = my_password  my_password is unecrypted if I try to put an encrypted value in I get an internal service error

Please use plain text password here.

that solved the connection problem but now I am getting a SMTP error
Nov 13 15:50:35 www roundcube: SMTP Error: SMTP error: Failed to add recipient 'pdugganjr@comcast.net' in /var/www/roundcubemail-0.8.2/program/include/main.inc on line 1485 (POST /roundcube/?_unlock=loading1352821812383&_lang=undefined?_task=mail&_action=send)
Nov 13 15:50:35 www postfix/smtpd[26520]: disconnect from www.dugganegroup.com[127.0.0.1]

Thanks for your help

4

Re: Access denied for user 'iredadmin'@'localhost' (using password: YES)

I'm having the same SMTP problem. Any brilliant ideas, guys?

5

Re: Access denied for user 'iredadmin'@'localhost' (using password: YES)

pdugganjr wrote:

that solved the connection problem but now I am getting a SMTP error
Nov 13 15:50:35 www roundcube: SMTP Error: SMTP error: Failed to add recipient 'pdugganjr@comcast.net' in /var/www/roundcubemail-0.8.2/program/include/main.inc on line 1485 (POST /roundcube/?_unlock=loading1352821812383&_lang=undefined?_task=mail&_action=send)
Nov 13 15:50:35 www postfix/smtpd[26520]: disconnect from www.dugganegroup.com[127.0.0.1]

Could you please paste log of full smtp session?

6

Re: Access denied for user 'iredadmin'@'localhost' (using password: YES)

ZhangHuangbin wrote:
pdugganjr wrote:

that solved the connection problem but now I am getting a SMTP error
Nov 13 15:50:35 www roundcube: SMTP Error: SMTP error: Failed to add recipient 'pdugganjr@comcast.net' in /var/www/roundcubemail-0.8.2/program/include/main.inc on line 1485 (POST /roundcube/?_unlock=loading1352821812383&_lang=undefined?_task=mail&_action=send)
Nov 13 15:50:35 www postfix/smtpd[26520]: disconnect from www.dugganegroup.com[127.0.0.1]

Could you please paste log of full smtp session?


I have attached the relevent logs from

Dovecot.log, maillog, sieve.log, ssl_access_log, ssl_request_log, there was no ssl_error in the log

7

Re: Access denied for user 'iredadmin'@'localhost' (using password: YES)

pdugganjr wrote:
ZhangHuangbin wrote:
pdugganjr wrote:

that solved the connection problem but now I am getting a SMTP error
Nov 13 15:50:35 www roundcube: SMTP Error: SMTP error: Failed to add recipient 'pdugganjr@comcast.net' in /var/www/roundcubemail-0.8.2/program/include/main.inc on line 1485 (POST /roundcube/?_unlock=loading1352821812383&_lang=undefined?_task=mail&_action=send)
Nov 13 15:50:35 www postfix/smtpd[26520]: disconnect from www.dugganegroup.com[127.0.0.1]

Could you please paste log of full smtp session?


I have attached the relevent logs from

Dovecot.log, maillog, sieve.log, ssl_access_log, ssl_request_log, there was no ssl_error in the log


Zhang I have checked the cn=vmail password in dovecot-lapd, postfix lapd dir/all files, amavisd.conf awstarts.conf as well as phpldapadmin they all match. everything works except I can't send or receive emails.

I need to get my email working

8

Re: Access denied for user 'iredadmin'@'localhost' (using password: YES)

pdugganjr wrote:
pdugganjr wrote:
ZhangHuangbin wrote:

Could you please paste log of full smtp session?


I have attached the relevent logs from

Dovecot.log, maillog, sieve.log, ssl_access_log, ssl_request_log, there was no ssl_error in the log


Zhang I have checked the cn=vmail password in dovecot-lapd, postfix lapd dir/all files, amavisd.conf awstarts.conf as well as phpldapadmin they all match. everything works except I can't send or receive emails.

I need to get my email working

Zhang my fault I needed to restart iredapd service everything is working fine now.