Hello Luca,

i think you probably updated django and it try to use the sqlite file instead of the mysql database.


Check the file /usr/lib/python2.7/site-packages/graphite/local_settings.py to see if it use sqlite or mysql, if it use sqlite then do that:

ln -sf /usr/local/pf/var/conf/local_settings.py /usr/lib/python2.7/site-packages/graphite/local_settings.py


Regards

Fabrice



Le 2018-02-16 à 04:27, luca comes via PacketFence-users a écrit :

Hi Fabrice,

I changed the permissions but now I can see the real error. As shown in the log file attached it seems that it cannot connect to the DB but I can't understand why, mariadb is running and PF is working fine. What query is made and which user is used?


Thanks


Luca



------------------------------------------------------------------------
*Da:* Durand fabrice via PacketFence-users <[email protected]>
*Inviato:* venerdì 16 febbraio 2018 04:04
*A:* [email protected]
*Cc:* Durand fabrice
*Oggetto:* Re: [PacketFence-users] Image Broken

Hello Luca,

it 's suppose to be the pf user who own this file.

Regards

Fabrice


Le 2018-02-15 à 08:48, luca comes via PacketFence-users a écrit :
Hi all,
I have a problem with my dashboard's graphs. In my cluster when the master node is started I see the images broken but when I shut it and second node takes ownership graphs are ok. Graphite is started but if I try to connect to it I receive a generic Internal Server Error. In the httpd.graphite.error log I can see this:

/Feb 15 14:43:57 pfnac01 httpd_graphite_err: [Thu Feb 15 13:43:57.609768 2018] [:error] [pid 29198] [client 192.168.167.50:39658] mod_wsgi (pid=29198): Target WSGI script '/usr/local/pf/conf/httpd.conf.d/graphite-web.wsgi' cannot be loaded as Python module./ /Feb 15 14:43:57 pfnac01 httpd_graphite_err: [Thu Feb 15 13:43:57.609792 2018] [:error] [pid 29198] [client 192.168.167.50:39658] mod_wsgi (pid=29198): Exception occurred processing WSGI script '/usr/local/pf/conf/httpd.conf.d/graphite-web.wsgi'./ /Feb 15 14:43:57 pfnac01 httpd_graphite_err: [Thu Feb 15 13:43:57.609817 2018] [:error] [pid 29198] [client 192.168.167.50:39658] Traceback (most recent call last):/ /Feb 15 14:43:57 pfnac01 httpd_graphite_err: [Thu Feb 15 13:43:57.609835 2018] [:error] [pid 29198] [client 192.168.167.50:39658]   File "/usr/local/pf/conf/httpd.conf.d/graphite-web.wsgi", line 18, in <module>/ /Feb 15 14:43:57 pfnac01 httpd_graphite_err: [Thu Feb 15 13:43:57.609865 2018] [:error] [pid 29198] [client 192.168.167.50:39658]     from graphite.logger import log/ /Feb 15 14:43:57 pfnac01 httpd_graphite_err: [Thu Feb 15 13:43:57.609877 2018] [:error] [pid 29198] [client 192.168.167.50:39658]   File "/usr/lib/python2.7/site-packages/graphite/logger.py", line 84, in <module>/ /Feb 15 14:43:57 pfnac01 httpd_graphite_err: [Thu Feb 15 13:43:57.609907 2018] [:error] [pid 29198] [client 192.168.167.50:39658]     log = GraphiteLogger() # import-shared logger instance/ /Feb 15 14:43:57 pfnac01 httpd_graphite_err: [Thu Feb 15 13:43:57.609916 2018] [:error] [pid 29198] [client 192.168.167.50:39658]   File "/usr/lib/python2.7/site-packages/graphite/logger.py", line 40, in __init__/ /Feb 15 14:43:57 pfnac01 httpd_graphite_err: [Thu Feb 15 13:43:57.609929 2018] [:error] [pid 29198] [client 192.168.167.50:39658]     self.infoHandler = FileHandler(self.infoLogFile)/ /Feb 15 14:43:57 pfnac01 httpd_graphite_err: [Thu Feb 15 13:43:57.609936 2018] [:error] [pid 29198] [client 192.168.167.50:39658]   File "/usr/lib64/python2.7/logging/__init__.py", line 902, in __init__/ /Feb 15 14:43:57 pfnac01 httpd_graphite_err: [Thu Feb 15 13:43:57.609949 2018] [:error] [pid 29198] [client 192.168.167.50:39658]  StreamHandler.__init__(self, self._open())/ /Feb 15 14:43:57 pfnac01 httpd_graphite_err: [Thu Feb 15 13:43:57.609956 2018] [:error] [pid 29198] [client 192.168.167.50:39658]   File "/usr/lib64/python2.7/logging/__init__.py", line 925, in _open/ /Feb 15 14:43:57 pfnac01 httpd_graphite_err: [Thu Feb 15 13:43:57.609967 2018] [:error] [pid 29198] [client 192.168.167.50:39658]     stream = open(self.baseFilename, self.mode)/ /Feb 15 14:43:57 pfnac01 httpd_graphite_err: [Thu Feb 15 13:43:57.609985 2018] [:error] [pid 29198] [client 192.168.167.50:39658] IOError: [Errno 13] Permission denied: '/var/log/graphite-web/info.log'/

It seems a problem on the permission to the log file but the /var/log/graphite-web is empty just as on the other two nodes. Anyway I tried to create the info.log file and set permissions on it:

/[root@pfnac01 ~]# ll /var/log/graphite-web//
/total 0/
/-rwxr-xr-x 1 apache apache 0 Feb 15 14:33 info.log/

The problem is not solved, do you know what I can check? I'm running PF 7.4.0 on CentOS 7.

Thanks

Luca



Inviato da Outlook <http://aka.ms/weboutlook>



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org!http://sdm.link/slashdot


_______________________________________________
PacketFence-users mailing list
[email protected] <mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/packetfence-users



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot


_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users

Reply via email to