1

Topic: whitelist error.

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

https://mail.doma.in/iredadmin/system/blacklist
https://mail.doma.in/iredadmin/system/whitelist
result in :

internal server error

log :


[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4] Traceback (most recent call last):
[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4]   File "/usr/lib/pymodules/python2.7/web/application.py", line 242, in process
[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4]     return self.handle()
[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4]   File "/usr/lib/pymodules/python2.7/web/application.py", line 233, in handle
[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4]     return self._delegate(fn, self.fvars, args)
[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4]   File "/usr/lib/pymodules/python2.7/web/application.py", line 415, in _delegate
[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4]     return handle_class(cls)
[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4]   File "/usr/lib/pymodules/python2.7/web/application.py", line 390, in handle_class
[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4]     return tocall(*args)
[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4]   File "/usr/share/apache2/iredadmin/controllers/decorators.py", line 21, in proxyfunc
[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4]     return func(self, *args, **kw)
[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4]   File "/usr/share/apache2/iredadmin/controllers/policyd/whitelist.py", line 19, in GET
[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4]     total, entries = whitelistLib.list(listcategory=self.listcategory, cur_page=self.cur_page,)
[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4]   File "/usr/share/apache2/iredadmin/libs/policyd/whitelist.py", line 29, in list
[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4]     self.count = self.db.query("""SELECT COUNT(_whitelist) as total FROM %s""" % (mapCategoryToTable[listcategory]))
[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4]   File "/usr/lib/pymodules/python2.7/web/db.py", line 610, in query
[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4]     db_cursor = self._db_cursor()
[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4]   File "/usr/lib/pymodules/python2.7/web/db.py", line 541, in _db_cursor
[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4]     return self.ctx.db.cursor()
[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4]   File "/usr/lib/pymodules/python2.7/web/db.py", line 482, in _getctx
[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4]     self._load_context(self._ctx)
[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4]   File "/usr/lib/pymodules/python2.7/web/db.py", line 493, in _load_context
[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4]     ctx.db = self._connect(self.keywords)
[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4]   File "/usr/lib/pymodules/python2.7/web/db.py", line 521, in _connect
[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4]     return self.db_module.connect(**keywords)
[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4]   File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 81, in Connect
[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4]     return Connection(*args, **kwargs)
[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4]   File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 187, in __init__
[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4]     super(Connection, self).__init__(*args, **kwargs2)
[Wed Aug 15 01:30:45 2012] [error] [client 1.2.3.4] OperationalError: (1045, "Access denied for user 'iredadmin'@'localhost' (using password: NO)")


[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4] Traceback (most recent call last):
[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4]   File "/usr/lib/pymodules/python2.7/web/application.py", line 242, in process
[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4]     return self.handle()
[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4]   File "/usr/lib/pymodules/python2.7/web/application.py", line 233, in handle
[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4]     return self._delegate(fn, self.fvars, args)
[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4]   File "/usr/lib/pymodules/python2.7/web/application.py", line 415, in _delegate
[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4]     return handle_class(cls)
[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4]   File "/usr/lib/pymodules/python2.7/web/application.py", line 390, in handle_class
[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4]     return tocall(*args)
[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4]   File "/usr/share/apache2/iredadmin/controllers/decorators.py", line 21, in proxyfunc
[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4]     return func(self, *args, **kw)
[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4]   File "/usr/share/apache2/iredadmin/controllers/policyd/blacklist.py", line 19, in GET
[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4]     total, entries = blacklistLib.list(listcategory=self.listcategory, cur_page=self.cur_page)
[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4]   File "/usr/share/apache2/iredadmin/libs/policyd/blacklist.py", line 37, in list
[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4]     self.count = self.db.query("""SELECT COUNT(%s) as total FROM %s""" % (mapTableToPrimaryKey[dbtable], dbtable))
[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4]   File "/usr/lib/pymodules/python2.7/web/db.py", line 610, in query
[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4]     db_cursor = self._db_cursor()
[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4]   File "/usr/lib/pymodules/python2.7/web/db.py", line 541, in _db_cursor
[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4]     return self.ctx.db.cursor()
[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4]   File "/usr/lib/pymodules/python2.7/web/db.py", line 482, in _getctx
[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4]     self._load_context(self._ctx)
[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4]   File "/usr/lib/pymodules/python2.7/web/db.py", line 493, in _load_context
[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4]     ctx.db = self._connect(self.keywords)
[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4]   File "/usr/lib/pymodules/python2.7/web/db.py", line 521, in _connect
[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4]     return self.db_module.connect(**keywords)
[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4]   File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 81, in Connect
[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4]     return Connection(*args, **kwargs)
[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4]   File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 187, in __init__
[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4]     super(Connection, self).__init__(*args, **kwargs2)
[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4] OperationalError: (1045, "Access denied for user 'iredadmin'@'localhost' (using password: NO)")

How to resolve?

Thanx in advance

2

Re: whitelist error.

Jochie wrote:

[Wed Aug 15 01:32:55 2012] [error] [client 1.2.3.4] OperationalError: (1045, "Access denied for user 'iredadmin'@'localhost' (using password: NO)")

You don't have password for MySQL user "iredadmin" in iRedAdmin config file: settings.ini?