Graphite

graphite.wsgi cannot be loaded as Python module

Asked by Blue Jakester

I searched this forum and also with Google but didn't find a solution to this. I'm working with a new installation of graphite:

Centos 3.10.0-229.20.1.el7.x86_64 #1 SMP Tue Nov 3 19:10:07 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux

Django:
Python 2.7.5 (default, Nov 20 2015, 02:00:19)
[GCC 4.8.5 20150623 (Red Hat 4.8.5-4)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import django
>>> print(django.get_version())
1.4

python-whisper-0.9.15-1.el7.noarch

mod_wsgi-3.4-12.el7_0.x86_64

I'm trying to access the graphite web page on this host. These errors are coming from: /opt/graphite/storage/log/webapp/error.log

Any guidance would be greatly appreciated.

[Wed Aug 10 16:30:16.085031 2016] [:error] [pid 1343] [remote 10.2.25.43:208] mod_wsgi (pid=1343): Target WSGI script '/opt/graphite/conf/graphite.wsgi' cannot be loaded as Python module.
[Wed Aug 10 16:30:16.085072 2016] [:error] [pid 1343] [remote 10.2.25.43:208] mod_wsgi (pid=1343): Exception occurred processing WSGI script '/opt/graphite/conf/graphite.wsgi'.
[Wed Aug 10 16:30:16.085111 2016] [:error] [pid 1343] [remote 10.2.25.43:208] Traceback (most recent call last):
[Wed Aug 10 16:30:16.085138 2016] [:error] [pid 1343] [remote 10.2.25.43:208] File "/opt/graphite/conf/graphite.wsgi", line 46, in <module>
[Wed Aug 10 16:30:16.085178 2016] [:error] [pid 1343] [remote 10.2.25.43:208] import graphite.metrics.search # noqa
[Wed Aug 10 16:30:16.085195 2016] [:error] [pid 1343] [remote 10.2.25.43:208] File "/usr/lib/python2.7/site-packages/graphite/metrics/search.py", line 6, in <module>
[Wed Aug 10 16:30:16.085221 2016] [:error] [pid 1343] [remote 10.2.25.43:208] from graphite.storage import is_pattern, match_entries
[Wed Aug 10 16:30:16.085236 2016] [:error] [pid 1343] [remote 10.2.25.43:208] File "/usr/lib/python2.7/site-packages/graphite/storage.py", line 9, in <module>
[Wed Aug 10 16:30:16.085260 2016] [:error] [pid 1343] [remote 10.2.25.43:208] from graphite.remote_storage import RemoteStore
[Wed Aug 10 16:30:16.085274 2016] [:error] [pid 1343] [remote 10.2.25.43:208] File "/usr/lib/python2.7/site-packages/graphite/remote_storage.py", line 8, in <module>
[Wed Aug 10 16:30:16.085298 2016] [:error] [pid 1343] [remote 10.2.25.43:208] from graphite.util import unpickle
[Wed Aug 10 16:30:16.085312 2016] [:error] [pid 1343] [remote 10.2.25.43:208] File "/usr/lib/python2.7/site-packages/graphite/util.py", line 81, in <module>
[Wed Aug 10 16:30:16.085335 2016] [:error] [pid 1343] [remote 10.2.25.43:208] defaultUser = User.objects.get(username='default')
[Wed Aug 10 16:30:16.085350 2016] [:error] [pid 1343] [remote 10.2.25.43:208] File "/usr/lib/python2.7/site-packages/django/db/models/manager.py", line 131, in get
[Wed Aug 10 16:30:16.085374 2016] [:error] [pid 1343] [remote 10.2.25.43:208] return self.get_query_set().get(*args, **kwargs)
[Wed Aug 10 16:30:16.085388 2016] [:error] [pid 1343] [remote 10.2.25.43:208] File "/usr/lib/python2.7/site-packages/django/db/models/query.py", line 361, in get
[Wed Aug 10 16:30:16.085411 2016] [:error] [pid 1343] [remote 10.2.25.43:208] num = len(clone)
[Wed Aug 10 16:30:16.085426 2016] [:error] [pid 1343] [remote 10.2.25.43:208] File "/usr/lib/python2.7/site-packages/django/db/models/query.py", line 85, in __len__
[Wed Aug 10 16:30:16.085448 2016] [:error] [pid 1343] [remote 10.2.25.43:208] self._result_cache = list(self.iterator())
[Wed Aug 10 16:30:16.085462 2016] [:error] [pid 1343] [remote 10.2.25.43:208] File "/usr/lib/python2.7/site-packages/django/db/models/query.py", line 291, in iterator
[Wed Aug 10 16:30:16.085485 2016] [:error] [pid 1343] [remote 10.2.25.43:208] for row in compiler.results_iter():
[Wed Aug 10 16:30:16.085499 2016] [:error] [pid 1343] [remote 10.2.25.43:208] File "/usr/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 763, in results_iter
[Wed Aug 10 16:30:16.085533 2016] [:error] [pid 1343] [remote 10.2.25.43:208] for rows in self.execute_sql(MULTI):
[Wed Aug 10 16:30:16.085549 2016] [:error] [pid 1343] [remote 10.2.25.43:208] File "/usr/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 818, in execute_sql
[Wed Aug 10 16:30:16.085595 2016] [:error] [pid 1343] [remote 10.2.25.43:208] cursor.execute(sql, params)
[Wed Aug 10 16:30:16.085612 2016] [:error] [pid 1343] [remote 10.2.25.43:208] File "/usr/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py", line 337, in execute
[Wed Aug 10 16:30:16.085647 2016] [:error] [pid 1343] [remote 10.2.25.43:208] return Database.Cursor.execute(self, query, params)
[Wed Aug 10 16:30:16.085675 2016] [:error] [pid 1343] [remote 10.2.25.43:208] DatabaseError: no such table: auth_user
[Wed Aug 10 16:30:16.301281 2016] [:error] [pid 1342] [remote 10.2.25.43:208] mod_wsgi (pid=1342): Target WSGI script '/opt/graphite/conf/graphite.wsgi' cannot be loaded as Python module.
[Wed Aug 10 16:30:16.301312 2016] [:error] [pid 1342] [remote 10.2.25.43:208] mod_wsgi (pid=1342): Exception occurred processing WSGI script '/opt/graphite/conf/graphite.wsgi'.
[Wed Aug 10 16:30:16.301343 2016] [:error] [pid 1342] [remote 10.2.25.43:208] Traceback (most recent call last):
[Wed Aug 10 16:30:16.301368 2016] [:error] [pid 1342] [remote 10.2.25.43:208] File "/opt/graphite/conf/graphite.wsgi", line 46, in <module>
[Wed Aug 10 16:30:16.301407 2016] [:error] [pid 1342] [remote 10.2.25.43:208] import graphite.metrics.search # noqa
[Wed Aug 10 16:30:16.301423 2016] [:error] [pid 1342] [remote 10.2.25.43:208] File "/usr/lib/python2.7/site-packages/graphite/metrics/search.py", line 6, in <module>
[Wed Aug 10 16:30:16.301450 2016] [:error] [pid 1342] [remote 10.2.25.43:208] from graphite.storage import is_pattern, match_entries
[Wed Aug 10 16:30:16.301465 2016] [:error] [pid 1342] [remote 10.2.25.43:208] File "/usr/lib/python2.7/site-packages/graphite/storage.py", line 9, in <module>
[Wed Aug 10 16:30:16.301489 2016] [:error] [pid 1342] [remote 10.2.25.43:208] from graphite.remote_storage import RemoteStore
[Wed Aug 10 16:30:16.301504 2016] [:error] [pid 1342] [remote 10.2.25.43:208] File "/usr/lib/python2.7/site-packages/graphite/remote_storage.py", line 8, in <module>
[Wed Aug 10 16:30:16.301527 2016] [:error] [pid 1342] [remote 10.2.25.43:208] from graphite.util import unpickle
[Wed Aug 10 16:30:16.301541 2016] [:error] [pid 1342] [remote 10.2.25.43:208] File "/usr/lib/python2.7/site-packages/graphite/util.py", line 81, in <module>
[Wed Aug 10 16:30:16.301565 2016] [:error] [pid 1342] [remote 10.2.25.43:208] defaultUser = User.objects.get(username='default')
[Wed Aug 10 16:30:16.301580 2016] [:error] [pid 1342] [remote 10.2.25.43:208] File "/usr/lib/python2.7/site-packages/django/db/models/manager.py", line 131, in get
[Wed Aug 10 16:30:16.301604 2016] [:error] [pid 1342] [remote 10.2.25.43:208] return self.get_query_set().get(*args, **kwargs)
[Wed Aug 10 16:30:16.301619 2016] [:error] [pid 1342] [remote 10.2.25.43:208] File "/usr/lib/python2.7/site-packages/django/db/models/query.py", line 361, in get
[Wed Aug 10 16:30:16.301642 2016] [:error] [pid 1342] [remote 10.2.25.43:208] num = len(clone)
[Wed Aug 10 16:30:16.301657 2016] [:error] [pid 1342] [remote 10.2.25.43:208] File "/usr/lib/python2.7/site-packages/django/db/models/query.py", line 85, in __len__
[Wed Aug 10 16:30:16.301679 2016] [:error] [pid 1342] [remote 10.2.25.43:208] self._result_cache = list(self.iterator())
[Wed Aug 10 16:30:16.301693 2016] [:error] [pid 1342] [remote 10.2.25.43:208] File "/usr/lib/python2.7/site-packages/django/db/models/query.py", line 291, in iterator
[Wed Aug 10 16:30:16.301716 2016] [:error] [pid 1342] [remote 10.2.25.43:208] for row in compiler.results_iter():
[Wed Aug 10 16:30:16.301730 2016] [:error] [pid 1342] [remote 10.2.25.43:208] File "/usr/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 763, in results_iter
[Wed Aug 10 16:30:16.301754 2016] [:error] [pid 1342] [remote 10.2.25.43:208] for rows in self.execute_sql(MULTI):
[Wed Aug 10 16:30:16.301768 2016] [:error] [pid 1342] [remote 10.2.25.43:208] File "/usr/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 818, in execute_sql
[Wed Aug 10 16:30:16.301806 2016] [:error] [pid 1342] [remote 10.2.25.43:208] cursor.execute(sql, params)
[Wed Aug 10 16:30:16.301822 2016] [:error] [pid 1342] [remote 10.2.25.43:208] File "/usr/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py", line 337, in execute
[Wed Aug 10 16:30:16.301846 2016] [:error] [pid 1342] [remote 10.2.25.43:208] return Database.Cursor.execute(self, query, params)
[Wed Aug 10 16:30:16.301891 2016] [:error] [pid 1342] [remote 10.2.25.43:208] DatabaseError: no such table: auth_user

Question information

Language:
English Edit question
Status:
Expired
For:
Graphite Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Denis Zhdanov (deniszhdanov) said : 		#1

Already answered in https://answers.launchpad.net/graphite/+question/187148

"Go to /opt/graphite/webapp/graphite/
Run python ./manage.py syncdb"

Revision history for this message
Blue Jakester (bluejakester) said : 		#2

Thanks for the suggestion Denis. I'm still encountering an error and the web interface doesn't appear. Browser shows "The server encountered an internal error or misconfiguration and was unable to complete your request."

# pwd
/opt/graphite/webapp/graphite

# python ./manage.py syncdb
Creating tables ...
Installing custom SQL ...
Installing indexes ...
Installed 0 object(s) from 0 fixture(s)

From: /opt/graphite/storage/log/webapp/error.log

[Thu Aug 11 14:49:53.296142 2016] [:error] [pid 1379] [remote 10.2.25.43:148] mod_wsgi (pid=1379): Target WSGI script '/opt/graphite/conf/graphite.wsgi' cannot be loaded as Python module.
[Thu Aug 11 14:49:53.296200 2016] [:error] [pid 1379] [remote 10.2.25.43:148] mod_wsgi (pid=1379): Exception occurred processing WSGI script '/opt/graphite/conf/graphite.wsgi'.
[Thu Aug 11 14:49:53.296233 2016] [:error] [pid 1379] [remote 10.2.25.43:148] Traceback (most recent call last):
[Thu Aug 11 14:49:53.296263 2016] [:error] [pid 1379] [remote 10.2.25.43:148] File "/opt/graphite/conf/graphite.wsgi", line 46, in <module>
[Thu Aug 11 14:49:53.296306 2016] [:error] [pid 1379] [remote 10.2.25.43:148] import graphite.metrics.search # noqa
[Thu Aug 11 14:49:53.296323 2016] [:error] [pid 1379] [remote 10.2.25.43:148] File "/usr/lib/python2.7/site-packages/graphite/metrics/search.py", line 6, in <module>
[Thu Aug 11 14:49:53.296349 2016] [:error] [pid 1379] [remote 10.2.25.43:148] from graphite.storage import is_pattern, match_entries
[Thu Aug 11 14:49:53.296363 2016] [:error] [pid 1379] [remote 10.2.25.43:148] File "/usr/lib/python2.7/site-packages/graphite/storage.py", line 9, in <module>
[Thu Aug 11 14:49:53.296401 2016] [:error] [pid 1379] [remote 10.2.25.43:148] from graphite.remote_storage import RemoteStore
[Thu Aug 11 14:49:53.296416 2016] [:error] [pid 1379] [remote 10.2.25.43:148] File "/usr/lib/python2.7/site-packages/graphite/remote_storage.py", line 8, in <module>
[Thu Aug 11 14:49:53.296440 2016] [:error] [pid 1379] [remote 10.2.25.43:148] from graphite.util import unpickle
[Thu Aug 11 14:49:53.296454 2016] [:error] [pid 1379] [remote 10.2.25.43:148] File "/usr/lib/python2.7/site-packages/graphite/util.py", line 81, in <module>
[Thu Aug 11 14:49:53.296477 2016] [:error] [pid 1379] [remote 10.2.25.43:148] defaultUser = User.objects.get(username='default')
[Thu Aug 11 14:49:53.296491 2016] [:error] [pid 1379] [remote 10.2.25.43:148] File "/usr/lib/python2.7/site-packages/django/db/models/manager.py", line 131, in get
[Thu Aug 11 14:49:53.296526 2016] [:error] [pid 1379] [remote 10.2.25.43:148] return self.get_query_set().get(*args, **kwargs)
[Thu Aug 11 14:49:53.296542 2016] [:error] [pid 1379] [remote 10.2.25.43:148] File "/usr/lib/python2.7/site-packages/django/db/models/query.py", line 361, in get
[Thu Aug 11 14:49:53.296590 2016] [:error] [pid 1379] [remote 10.2.25.43:148] num = len(clone)
[Thu Aug 11 14:49:53.296608 2016] [:error] [pid 1379] [remote 10.2.25.43:148] File "/usr/lib/python2.7/site-packages/django/db/models/query.py", line 85, in __len__
[Thu Aug 11 14:49:53.296661 2016] [:error] [pid 1379] [remote 10.2.25.43:148] self._result_cache = list(self.iterator())
[Thu Aug 11 14:49:53.296685 2016] [:error] [pid 1379] [remote 10.2.25.43:148] File "/usr/lib/python2.7/site-packages/django/db/models/query.py", line 291, in iterator
[Thu Aug 11 14:49:53.296710 2016] [:error] [pid 1379] [remote 10.2.25.43:148] for row in compiler.results_iter():
[Thu Aug 11 14:49:53.296725 2016] [:error] [pid 1379] [remote 10.2.25.43:148] File "/usr/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 763, in results_iter
[Thu Aug 11 14:49:53.296749 2016] [:error] [pid 1379] [remote 10.2.25.43:148] for rows in self.execute_sql(MULTI):
[Thu Aug 11 14:49:53.296763 2016] [:error] [pid 1379] [remote 10.2.25.43:148] File "/usr/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 818, in execute_sql
[Thu Aug 11 14:49:53.296785 2016] [:error] [pid 1379] [remote 10.2.25.43:148] cursor.execute(sql, params)
[Thu Aug 11 14:49:53.296800 2016] [:error] [pid 1379] [remote 10.2.25.43:148] File "/usr/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py", line 337, in execute
[Thu Aug 11 14:49:53.296824 2016] [:error] [pid 1379] [remote 10.2.25.43:148] return Database.Cursor.execute(self, query, params)
[Thu Aug 11 14:49:53.296850 2016] [:error] [pid 1379] [remote 10.2.25.43:148] DatabaseError: no such table: auth_user
[Thu Aug 11 14:49:53.468806 2016] [:error] [pid 1378] [remote 10.2.25.43:140] mod_wsgi (pid=1378): Target WSGI script '/opt/graphite/conf/graphite.wsgi' cannot be loaded as Python module.
[Thu Aug 11 14:49:53.468852 2016] [:error] [pid 1378] [remote 10.2.25.43:140] mod_wsgi (pid=1378): Exception occurred processing WSGI script '/opt/graphite/conf/graphite.wsgi'.
[Thu Aug 11 14:49:53.468894 2016] [:error] [pid 1378] [remote 10.2.25.43:140] Traceback (most recent call last):
[Thu Aug 11 14:49:53.468938 2016] [:error] [pid 1378] [remote 10.2.25.43:140] File "/opt/graphite/conf/graphite.wsgi", line 46, in <module>
[Thu Aug 11 14:49:53.469002 2016] [:error] [pid 1378] [remote 10.2.25.43:140] import graphite.metrics.search # noqa
[Thu Aug 11 14:49:53.469030 2016] [:error] [pid 1378] [remote 10.2.25.43:140] File "/usr/lib/python2.7/site-packages/graphite/metrics/search.py", line 6, in <module>
[Thu Aug 11 14:49:53.469075 2016] [:error] [pid 1378] [remote 10.2.25.43:140] from graphite.storage import is_pattern, match_entries
[Thu Aug 11 14:49:53.469101 2016] [:error] [pid 1378] [remote 10.2.25.43:140] File "/usr/lib/python2.7/site-packages/graphite/storage.py", line 9, in <module>
[Thu Aug 11 14:49:53.469161 2016] [:error] [pid 1378] [remote 10.2.25.43:140] from graphite.remote_storage import RemoteStore
[Thu Aug 11 14:49:53.469190 2016] [:error] [pid 1378] [remote 10.2.25.43:140] File "/usr/lib/python2.7/site-packages/graphite/remote_storage.py", line 8, in <module>
[Thu Aug 11 14:49:53.469234 2016] [:error] [pid 1378] [remote 10.2.25.43:140] from graphite.util import unpickle
[Thu Aug 11 14:49:53.469262 2016] [:error] [pid 1378] [remote 10.2.25.43:140] File "/usr/lib/python2.7/site-packages/graphite/util.py", line 81, in <module>
[Thu Aug 11 14:49:53.469308 2016] [:error] [pid 1378] [remote 10.2.25.43:140] defaultUser = User.objects.get(username='default')
[Thu Aug 11 14:49:53.469336 2016] [:error] [pid 1378] [remote 10.2.25.43:140] File "/usr/lib/python2.7/site-packages/django/db/models/manager.py", line 131, in get
[Thu Aug 11 14:49:53.469384 2016] [:error] [pid 1378] [remote 10.2.25.43:140] return self.get_query_set().get(*args, **kwargs)
[Thu Aug 11 14:49:53.469414 2016] [:error] [pid 1378] [remote 10.2.25.43:140] File "/usr/lib/python2.7/site-packages/django/db/models/query.py", line 361, in get
[Thu Aug 11 14:49:53.469460 2016] [:error] [pid 1378] [remote 10.2.25.43:140] num = len(clone)
[Thu Aug 11 14:49:53.469488 2016] [:error] [pid 1378] [remote 10.2.25.43:140] File "/usr/lib/python2.7/site-packages/django/db/models/query.py", line 85, in __len__
[Thu Aug 11 14:49:53.469532 2016] [:error] [pid 1378] [remote 10.2.25.43:140] self._result_cache = list(self.iterator())
[Thu Aug 11 14:49:53.469557 2016] [:error] [pid 1378] [remote 10.2.25.43:140] File "/usr/lib/python2.7/site-packages/django/db/models/query.py", line 291, in iterator
[Thu Aug 11 14:49:53.469598 2016] [:error] [pid 1378] [remote 10.2.25.43:140] for row in compiler.results_iter():
[Thu Aug 11 14:49:53.469650 2016] [:error] [pid 1378] [remote 10.2.25.43:140] File "/usr/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 763, in results_iter
[Thu Aug 11 14:49:53.469712 2016] [:error] [pid 1378] [remote 10.2.25.43:140] for rows in self.execute_sql(MULTI):
[Thu Aug 11 14:49:53.469741 2016] [:error] [pid 1378] [remote 10.2.25.43:140] File "/usr/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 818, in execute_sql
[Thu Aug 11 14:49:53.469788 2016] [:error] [pid 1378] [remote 10.2.25.43:140] cursor.execute(sql, params)
[Thu Aug 11 14:49:53.469815 2016] [:error] [pid 1378] [remote 10.2.25.43:140] File "/usr/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py", line 337, in execute
[Thu Aug 11 14:49:53.469859 2016] [:error] [pid 1378] [remote 10.2.25.43:140] return Database.Cursor.execute(self, query, params)
[Thu Aug 11 14:49:53.469902 2016] [:error] [pid 1378] [remote 10.2.25.43:140] DatabaseError: no such table: auth_user

Revision history for this message
Launchpad Janitor (janitor) said : 		#3

This question was expired because it remained in the 'Open' state without activity for the last 15 days.