Hello experts, I can not see the all status on Dashboard, it's show the like image broken icon. I checked on httpd.graphite.error it's showing:
> [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] mod_wsgi > (pid=9726): Target WSGI script > '/usr/local/pf/conf/httpd.conf.d/graphite-web.wsgi' cannot be loaded as > Python module. > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] mod_wsgi > (pid=9726): Exception occurred processing WSGI script > '/usr/local/pf/conf/httpd.conf.d/graphite-web.wsgi'. > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] Traceback (most > recent call last): > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] File > "/usr/local/pf/conf/httpd.conf.d/graphite-web.wsgi", line 20, in <module> > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] import > graphite.metrics.search > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] File > "/usr/lib/python2.6/site-packages/graphite/metrics/search.py", line 6, in > <module> > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] from > graphite.storage import is_pattern, match_entries > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] File > "/usr/lib/python2.6/site-packages/graphite/storage.py", line 7, in <module> > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] from > graphite.remote_storage import RemoteStore > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] File > "/usr/lib/python2.6/site-packages/graphite/remote_storage.py", line 8, in > <module> > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] from > graphite.util import unpickle > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] File > "/usr/lib/python2.6/site-packages/graphite/util.py", line 70, in <module> > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] defaultUser > = User.objects.get(username='default') > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] File > "/usr/lib/python2.6/site-packages/django/db/models/manager.py", line 131, > in get > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] return > self.get_query_set().get(*args, **kwargs) > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] File > "/usr/lib/python2.6/site-packages/django/db/models/query.py", line 361, in > get > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] num = > len(clone) > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] File > "/usr/lib/python2.6/site-packages/django/db/models/query.py", line 85, in > __len__ > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] > self._result_cache = list(self.iterator()) > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] File > "/usr/lib/python2.6/site-packages/django/db/models/query.py", line 291, in > iterator > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] for row in > compiler.results_iter(): > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] File > "/usr/lib/python2.6/site-packages/django/db/models/sql/compiler.py", line > 763, in results_iter > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] for rows in > self.execute_sql(MULTI): > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] File > "/usr/lib/python2.6/site-packages/django/db/models/sql/compiler.py", line > 817, in execute_sql > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] cursor = > self.connection.cursor() > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] File > "/usr/lib/python2.6/site-packages/django/db/backends/__init__.py", line > 319, in cursor > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] cursor = > util.CursorWrapper(self._cursor(), self) > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] File > "/usr/lib/python2.6/site-packages/django/db/backends/mysql/base.py", line > 387, in _cursor > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] > self.connection = Database.connect(**kwargs) > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] File > "/usr/lib64/python2.6/site-packages/MySQLdb/__init__.py", line 81, in > Connect > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] return > Connection(*args, **kwargs) > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] File > "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 187, in > __init__ > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] > super(Connection, self).__init__(*args, **kwargs2) > [Fri Jun 12 04:55:21 2015] [error] [client 10.126.123.239] > OperationalError: (1044, "Access denied for user 'pf'@'localhost' to > database 'pf_graphite'") > Here is some information related pf user on mysql: > mysql> show processlist; > > +------+------+-----------+------+---------+------+-------+------------------+ > | Id | User | Host | db | Command | Time | State | > Info | > > +------+------+-----------+------+---------+------+-------+------------------+ > | 1080 | pf | localhost | pf | Sleep | 7 | | > NULL | > | 1085 | pf | localhost | pf | Sleep | 961 | | > NULL | > | 1154 | pf | localhost | pf | Sleep | 42 | | > NULL | > | 1155 | pf | localhost | pf | Sleep | 42 | | > NULL | > | 1156 | pf | localhost | pf | Sleep | 42 | | > NULL | > | 1187 | root | localhost | pf | Query | 0 | NULL | show > processlist | > > +------+------+-----------+------+---------+------+-------+------------------+ > > mysql> show grants; > > +-----------------------------------------------------------------------------------------------------------+ > | Grants for pf@localhost > | > > +-----------------------------------------------------------------------------------------------------------+ > | GRANT USAGE ON *.* TO 'pf'@'localhost' IDENTIFIED BY PASSWORD > '*43399A596588D16D78025E279EDA3DB418048C03' | > | GRANT ALL PRIVILEGES ON `pf`.* TO 'pf'@'localhost' > | > > +-----------------------------------------------------------------------------------------------------------+ > mysql> select user from mysql.db where db='pf'; > +------+ > | user | > +------+ > | pf | > +------+ > mysql> show tables; > +---------------------+ > | Tables_in_pf | > +---------------------+ > | action | > | activation | > | billing | > | class | > | configfile | > | ifoctetslog | > | inline_accounting | > | iplog | > | iplog_archive | > | iplog_history | > | keyed | > | locationlog | > | locationlog_archive | > | node | > | node_category | > | node_useragent | > | password | > | person | > | pf_version | > | radacct | > | radacct_log | > | radius_nas | > | savedsearch | > | scan | > | sms_carrier | > | soh_filter_rules | > | soh_filters | > | traplog | > | trigger | > | userlog | > | violation | > | wrix | > +---------------------+ > 32 rows in set (0.00 sec) Do i miss any configuration? Thanks & Best regards,
------------------------------------------------------------------------------
_______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
