1 (edited by drsys 2011-01-08 03:32:57)

Topic: SQL errors maybe ?

when i go to https://mailsrv.xxxxxx.cc/iredadmin/system/whitelist i get this :

_mysql_exceptions.OperationalError at /system/whitelist
(1045, "Access denied for user 'policyd'@'localhost' (using password: YES)")

Python    /usr/lib64/python2.4/site-packages/MySQLdb/connections.py in __init__, line 163
Web    GET https://mailsrv.xxxxxx.cc/iredadmin/system/whitelist
Traceback (innermost first)

/usr/lib64/python2.4/site-packages/MySQLdb/connections.py in __init__
        super(Connection, self).__init__(*args, **kwargs2) ...
▶ Local vars
/usr/lib64/python2.4/site-packages/MySQLdb/__init__.py in Connect
    return Connection(*args, **kwargs) ...
▶ Local vars
/usr/lib/python2.4/site-packages/web/db.py in _connect
        return self.db_module.connect(**keywords) ...
▶ Local vars
/usr/lib/python2.4/site-packages/web/db.py in _load_context
            ctx.db = self._connect(self.keywords) ...
▶ Local vars
/usr/lib/python2.4/site-packages/web/db.py in _getctx
            self._load_context(self._ctx) ...
▶ Local vars
/usr/lib/python2.4/site-packages/web/db.py in _db_cursor
        return self.ctx.db.cursor() ...
▶ Local vars
/usr/lib/python2.4/site-packages/web/db.py in query
        db_cursor = self._db_cursor() ...
▶ Local vars
/var/www/iredadmin/libs/policyd/whitelist.py in list
        self.count = self.db.query("""SELECT COUNT(*) as total FROM %s""" % (mapCategoryToTable[listcategory]) ) ...
▶ Local vars
/var/www/iredadmin/controllers/policyd/whitelist.py in GET
        total, entries = whitelistLib.list(listcategory=self.listcategory, cur_page=self.cur_page,) ...
▶ Local vars
/var/www/iredadmin/controllers/base.py in proxyfunc
            return func(self, *args, **kw) ...
▶ Local vars
/usr/lib/python2.4/site-packages/web/application.py in handle_class
            return tocall(*args) ...
▶ Local vars
/usr/lib/python2.4/site-packages/web/application.py in _delegate
            return handle_class(cls) ...
▶ Local vars
/usr/lib/python2.4/site-packages/web/application.py in handle
        return self._delegate(fn, self.fvars, args) ...
▶ Local vars
/usr/lib/python2.4/site-packages/web/application.py in process
                    return self.handle() ...
▶ Local vars
BODY




This happens also when i visit throtle in domains and accounts menu
https://mailsrv.xxxxxx.cc/iredadmin/pro … /xxxxxx.cc


_mysql_exceptions.OperationalError at /profile/domain/throttle/xxxxxx.cc
(1045, "Access denied for user 'policyd'@'localhost' (using password: YES)")

Python    /usr/lib64/python2.4/site-packages/MySQLdb/connections.py in __init__, line 163
Web    GET https://mailsrv.xxxxxx.cc/iredadmin/pro … /xxxxxx.cc
Traceback (innermost first)

/usr/lib64/python2.4/site-packages/MySQLdb/connections.py in __init__
        super(Connection, self).__init__(*args, **kwargs2) ...
▶ Local vars
/usr/lib64/python2.4/site-packages/MySQLdb/__init__.py in Connect
    return Connection(*args, **kwargs) ...
▶ Local vars
/usr/lib/python2.4/site-packages/web/db.py in _connect
        return self.db_module.connect(**keywords) ...
▶ Local vars
/usr/lib/python2.4/site-packages/web/db.py in _load_context
            ctx.db = self._connect(self.keywords) ...
▶ Local vars
/usr/lib/python2.4/site-packages/web/db.py in _getctx
            self._load_context(self._ctx) ...
▶ Local vars
/usr/lib/python2.4/site-packages/web/db.py in _db_cursor
        return self.ctx.db.cursor() ...
▶ Local vars
/usr/lib/python2.4/site-packages/web/db.py in query
        db_cursor = self._db_cursor() ...
▶ Local vars
/usr/lib/python2.4/site-packages/web/db.py in select
        return self.query(qout, processed=True) ...
▶ Local vars
/var/www/iredadmin/libs/policyd/throttle.py in list
                limit=1, ...
▶ Local vars
/var/www/iredadmin/controllers/ldap/domain.py in GET
                result_throttle = throttleLib.list(sender='@'+self.domain, recipient='@'+self.domain) ...
▶ Local vars
/var/www/iredadmin/controllers/base.py in proxyfunc
            return func(self, *args, **kw) ...
▶ Local vars
/usr/lib/python2.4/site-packages/web/application.py in handle_class
            return tocall(*args) ...
▶ Local vars
/usr/lib/python2.4/site-packages/web/application.py in _delegate
            return handle_class(cls) ...
▶ Local vars
/usr/lib/python2.4/site-packages/web/application.py in handle
        return self._delegate(fn, self.fvars, args) ...
▶ Local vars
/usr/lib/python2.4/site-packages/web/application.py in process
                    return self.handle() ...
▶ Local vars

2

Re: SQL errors maybe ?

(1045, "Access denied for user 'policyd'@'localhost' (using password: YES)")

You don't have correct password in settings.ini, in section '[policyd]'. please fix it first. Restarting apache is recommended.

3 (edited by drsys 2011-01-08 15:24:39)

Re: SQL errors maybe ?

where in the installation did we enter a password for policyd ? is it the mysql password ? i entered the mysql password but the problem persists .

4

Re: SQL errors maybe ?

Refer to the settings.ini, you can find it in /etc/policyd.conf.

# SQL Database used to store policyd data, eg. whitelist, blacklist.
# You can find related information in policyd config files:
#   - On RHEL/CentOS:   /etc/policyd.conf
#   - On Debian/Ubuntu: /etc/postfix-policyd.conf
#   - On FreeBSD:       /usr/local/etc/policyd.conf
# Related parameters:
#   host    -> MYSQLHOST
#   port    -> 3306 (Default)
#   db      -> MYSQLDBASE
#   user    -> MYSQLUSER
#   passwd  -> MYSQLPASS
dbn = mysql
host = 127.0.0.1
port = 3306
db = policyd
user = policyd
passwd = passwd

5

Re: SQL errors maybe ?

Problem Solved , Thank you Zhang