I have tried adding bind-address=, skip-host-cache, skip-name-resolve to my.cnf and restarting but no success
I can log into roundcube db via cli using username and password from iRedMail.tips file and also iredadmin db using details from iRedMail.tips
I see this error in maillog when accessing roundcube
roundcube: <ecbv3f00> DB Error: SQLSTATE[HY000] [1130] Host '10.1.1.5' is not allowed to connect to this MySQL server in /usr/local/www/roundcube/program/lib/Roundcube/rcube_db.php on line 177 (GET /mail/)
Nov 7 20:22:26 mx2 roundcube: <ecbv3f00> DB Error: SQLSTATE[HY000] [1130] Host '10.1.1.5' is not allowed to connect to this MySQL server (GET /mail/)
Nov 7 20:23:13 mx2 postfix/pickup[17123]: 129B27237F: uid=0 from=<root>
Nov 7 20:23:13 mx2 roundcube: <ecbv3f00> DB Error: SQLSTATE[HY000] [1130] Host '10.1.1.5' is not allowed to connect to this MySQL server in /usr/local/www/roundcube/program/lib/Roundcube/rcube_db.php on line 177 (GET /mail/)
and this in uwsgi when accessing /iredadmin
xxx.xxx.xxx.xxx [pid: 5989|app: 0|req: 13/13] xxx.xxx.xxx.xxx () {50 vars in 785 bytes} [Sat Nov 7 20:05:50 2015] GET /iredadmin => generated 21 bytes in 6 msecs (HTTP/1.1 500) 1 headers in 63 bytes (2 switches on core 0)
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/web/application.py", line 237, in process
return p(lambda: process(processors))
File "/usr/local/lib/python2.7/site-packages/web/session.py", line 84, in _processor
self._cleanup()
File "/usr/local/lib/python2.7/site-packages/web/session.py", line 172, in _cleanup
self.store.cleanup(timeout)
File "/usr/local/lib/python2.7/site-packages/web/session.py", line 319, in cleanup
self.db.delete(self.table, where="$last_allowed_time > atime", vars=locals())
File "/usr/local/lib/python2.7/site-packages/web/db.py", line 906, in delete
db_cursor = self._db_cursor()
File "/usr/local/lib/python2.7/site-packages/web/db.py", line 566, in _db_cursor
return self.ctx.db.cursor()
File "/usr/local/lib/python2.7/site-packages/web/db.py", line 507, in _getctx
self._load_context(self._ctx)
File "/usr/local/lib/python2.7/site-packages/web/db.py", line 518, in _load_context
ctx.db = self._connect(self.keywords)
File "/usr/local/lib/python2.7/site-packages/web/db.py", line 546, in _connect
return self.db_module.connect(**keywords)
File "/usr/local/lib/python2.7/site-packages/MySQLdb/__init__.py", line 81, in Connect
return Connection(*args, **kwargs)
File "/usr/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 193, in __init__
super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (1130, "Host '10.1.1.5' is not allowed to connect to this MySQL server")