Topic: mysql is not configured properly
==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.3
- Linux/BSD distribution name and version: FreeBSD 10.2 jail
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): LDAP
- Web server (Apache or Nginx): NGINX
- Manage mail accounts with iRedAdmin-Pro? No
- Related log if you're reporting an issue:
====
I reinstalled iRedMail after fixing some permissions issues in jail management.
There is no errors anymore, but nothing works 'out-of-the-box'.
It seems that all components have trouble to access to MySQL databases.
For example, /var/log/sogo shows errors "could not open channel <MySQL4Channel..."
The databases are present in MySQL:
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| amavisd |
| iredadmin |
| iredapd |
| mysql |
| performance_schema |
| sogo |
| test |
+--------------------+
8 rows in set (0.02 sec)
The users are present in MySQL:
mysql> select user,host from mysql.user;
+-----------+-------------------+
| user | host |
+-----------+-------------------+
| root | 127.0.0.1 |
| root | ::1 |
| amavisd | localhost |
| iredadmin | localhost |
| iredapd | localhost |
| root | localhost |
| sogo | localhost |
| root | mail.flytrace.com |
+-----------+-------------------+
8 rows in set (0.00 sec)
Some grants are present:
mysql> show grants for 'iredadmin'@'localhost';
+------------------------------------------------------------------------------------------------
------------------+
| Grants for iredadmin@localhost
|
+------------------------------------------------------------------------------------------------
------------------+
| GRANT USAGE ON *.* TO 'iredadmin'@'localhost' IDENTIFIED BY PASSWORD '*88E2910C47B9AE8E25B17DD1
A226072D2BB97AE1' |
| GRANT ALL PRIVILEGES ON `iredadmin`.* TO 'iredadmin'@'localhost'
|
+------------------------------------------------------------------------------------------------
------------------+
2 rows in set (0.01 sec)
mysql> show grants for 'iredapd'@'localhost';
+----------------------------------------------------------------------------------------------------------------+
| Grants for iredapd@localhost |
+----------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'iredapd'@'localhost' IDENTIFIED BY PASSWORD '*AC851CA84AF672FBF3C0CC5D02F7229128D831E9' |
| GRANT ALL PRIVILEGES ON `iredapd`.* TO 'iredapd'@'localhost' |
+----------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
mysql> show grants for 'sogo'@'localhost';
+-------------------------------------------------------------------------------------------------------------+
| Grants for sogo@localhost |
+-------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'sogo'@'localhost' IDENTIFIED BY PASSWORD '*03FA2C7B49675D711B3515FABE34314FA82E6B5F' |
| GRANT ALL PRIVILEGES ON `sogo`.* TO 'sogo'@'localhost' |
+-------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
Before getting all grants for anybody, I would ask the developers if they have any idea about a possible reason of my problem...
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.