1 Topic by bozhinov

  • bozhinov
  • Member
  • Offline
  • Registered: 2011-06-03
  • Posts: 4

Topic: Mysql auth issue while installing 0.7.2

Hello,

You ve been great help before. I hope you assist again.

I installed iRedMail on FreeBSD 8.2 again. (fresh jail)
This time I get:

root@192.168.0.113 not authorized to access the mysql server

then I granted them:

GRANT ALL ON *.* TO 'root'@'192.168.0.113';
flush privileges;

and now I get:
ERROR 1045 (28000): Access denied for user 'root'@'192.168.0.113' (using password: YES)

and every time I have to edit the .iRedMail.installation.status file and remove the sql import and config parts
and then remove all extra lines from the make.conf and rc.conf files

Why is it not using localhost ? (localhost == 192.168.0.113 but there is nothing in the hosts file but what is listed in the install guide for FreeBSD)

Is there something I could edit in the install script ?

FYI: the installation of Apache22 failed for mod_ldap_authz something so I removed it cause I use Mysql anyway.

----

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: Mysql auth issue while installing 0.7.2

bozhinov wrote:

GRANT ALL ON *.* TO 'root'@'192.168.0.113';

You should set a password for 'root@192.168.0.113' like this:

$ mysql -uroot -p
mysql> GRANT ALL ON *.* TO 'root'@'192.168.0.113' IDENTIFIED BY 'plain_password';
bozhinov wrote:

Why is it not using localhost ? (localhost == 192.168.0.113 but there is nothing in the hosts file but what is listed in the install guide for FreeBSD)

You should make sure localhost is mapping to correct IP address in jail.