Page 1 sur 1

500 : Internal Server Error HELP!!!

Publié : 18 juin 2019, 11:15
par michael3131
Bonjour,


depuis hier, sans raison, impossible de me connecter à l'interface.


J'ai une erreur 500 Internal Server Error.

je fais une petite recherche et je vois sur le forum une recherche de log a faire , mais vu que je suis loin de tout capter au fichier si une âme charitable peut m'aider... Merci d'avance :mrgreen:

Code : Tout sélectionner

pi@raspberrypi:/var/www/html/log $ tail -n 50 http.error
#6 /var/www/html/core/class/jeedom.class.php(393): jeedom::apiAccess('CIXh(bla bla bla )y...')
#7 /var/www/html/plugins/rfxcom/core/php/jeeRfxcom.php(19): jeedom::apiAccess('C                         IXh(bla bla bla )y...', 'rfxcom')
#8 {main}
  thrown in /var/www/html/core/class/DB.class.php on line 41
[Sat Jun 15 17:36:04.677038 2019] [:error] [pid 28186] [client 127.0.0.1:37752]                          PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000] [2002] Connection refus                         ed in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=loca.                         ..', 'jeedom', 'c63c0eb2977c724', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/config.class.php(145): DB::Prepare('SELECT `value`
...', Array, 0)
#4 /var/www/html/core/class/jeedom.class.php(355): config::byKey('api', 'core')
#5 /var/www/html/core/class/jeedom.class.php(399): jeedom::getApiKey('core')
#6 /var/www/html/core/class/jeedom.class.php(393): jeedom::apiAccess('CIXh(bla bla bla )y...')
#7 /var/www/html/plugins/rfxcom/core/php/jeeRfxcom.php(19): jeedom::apiAccess('C                         IXh(bla bla bla )y...', 'rfxcom')
#8 {main}
  thrown in /var/www/html/core/class/DB.class.php on line 41
[Sat Jun 15 17:36:04.697513 2019] [:error] [pid 25835] [client 127.0.0.1:37754]                          PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000] [2002] Connection refus                         ed in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=loca.                         ..', 'jeedom', 'c63c0eb2977c724', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/config.class.php(145): DB::Prepare('SELECT `value`
...', Array, 0)
#4 /var/www/html/core/class/jeedom.class.php(355): config::byKey('api', 'core')
#5 /var/www/html/core/class/jeedom.class.php(399): jeedom::getApiKey('core')
#6 /var/www/html/core/class/jeedom.class.php(393): jeedom::apiAccess('CIXh(bla bla bla )y...')
#7 /var/www/html/plugins/rfxcom/core/php/jeeRfxcom.php(19): jeedom::apiAccess('C (bla bla bla )8y...', 'rfxcom')
#8 {main}
  thrown in /var/www/html/core/class/DB.class.php on line 41
[Sun Jun 16 07:17:10.432929 2019] [mpm_prefork:notice] [pid 667] AH00163: Apache                         /2.4.25 (Raspbian) configured -- resuming normal operations
[Sun Jun 16 07:17:10.446246 2019] [core:notice] [pid 667] AH00094: Command line:                          '/usr/sbin/apache2'
[Mon Jun 17 17:01:50.076833 2019] [:error] [pid 15274] [client 10.0.0.11:49460]                          PHP Fatal error:  Uncaught Error: Call to a member function setOptions() on null                          in /var/www/html/core/ajax/user.ajax.php:63\nStack trace:\n#0 {main}\n  thrown                          in /var/www/html/core/ajax/user.ajax.php on line 63, referer: http://10.0.0.30/i                         ndex.php?v=d&p=dashboard
[Mon Jun 17 17:02:00.362059 2019] [:error] [pid 24088] [client 10.0.0.11:49461]                          PHP Fatal error:  Uncaught Error: Call to a member function setOptions() on null                          in /var/www/html/core/ajax/user.ajax.php:63\nStack trace:\n#0 {main}\n  thrown                          in /var/www/html/core/ajax/user.ajax.php on line 63, referer: http://10.0.0.30/i                         ndex.php?v=d&p=dashboard
[Mon Jun 17 17:02:44.008163 2019] [:error] [pid 31687] [client 10.0.0.11:49503]                          PHP Fatal error:  Uncaught Error: Call to a member function setOptions() on null                          in /var/www/html/core/ajax/user.ajax.php:63\nStack trace:\n#0 {main}\n  thrown                          in /var/www/html/core/ajax/user.ajax.php on line 63, referer: http://10.0.0.30/i                         ndex.php?v=d&p=dashboard
[Mon Jun 17 18:30:43.309585 2019] [:error] [pid 29275] [client 10.0.0.11:50185]                          PHP Fatal error:  Uncaught Error: Call to a member function setOptions() on null                          in /var/www/html/core/ajax/user.ajax.php:63\nStack trace:\n#0 {main}\n  thrown                          in /var/www/html/core/ajax/user.ajax.php on line 63, referer: http://10.0.0.30/i                         ndex.php?v=d&p=dashboard
[Mon Jun 17 18:31:14.344395 2019] [:error] [pid 24088] [client 10.0.0.11:50186]                          PHP Fatal error:  Uncaught Error: Call to a member function setOptions() on null                          in /var/www/html/core/ajax/user.ajax.php:63\nStack trace:\n#0 {main}\n  thrown                          in /var/www/html/core/ajax/user.ajax.php on line 63, referer: http://10.0.0.30/i                         ndex.php?v=d&p=dashboard
[Mon Jun 17 18:17:08.928962 2019] [mpm_prefork:notice] [pid 541] AH00163: Apache                         /2.4.25 (Raspbian) configured -- resuming normal operations
[Mon Jun 17 18:17:08.930147 2019] [core:notice] [pid 541] AH00094: Command line:                          '/usr/sbin/apache2'
[Mon Jun 17 18:38:23.029305 2019] [:error] [pid 787] [client 10.0.0.11:50273] PH                         P Fatal error:  Uncaught Error: Call to a member function setOptions() on null i                         n /var/www/html/core/ajax/user.ajax.php:63\nStack trace:\n#0 {main}\n  thrown in                          /var/www/html/core/ajax/user.ajax.php on line 63, referer: http://10.0.0.30/ind                         ex.php?v=d&p=dashboard
[Mon Jun 17 18:39:26.598790 2019] [:error] [pid 781] [client 10.0.0.11:50291] PH                         P Fatal error:  Uncaught Error: Call to a member function setOptions() on null i                         n /var/www/html/core/ajax/user.ajax.php:63\nStack trace:\n#0 {main}\n  thrown in                          /var/www/html/core/ajax/user.ajax.php on line 63, referer: http://10.0.0.30/ind                         ex.php?v=d&p=dashboard
[Mon Jun 17 19:05:25.109942 2019] [:error] [pid 781] [client 10.0.0.11:50665] PH                         P Fatal error:  Uncaught Error: Call to a member function setOptions() on null i                         n /var/www/html/core/ajax/user.ajax.php:63\nStack trace:\n#0 {main}\n  thrown in                          /var/www/html/core/ajax/user.ajax.php on line 63, referer: http://10.0.0.30/ind                         ex.php?v=d&p=dashboard
[Mon Jun 17 19:05:33.352159 2019] [:error] [pid 3251] [client 10.0.0.11:50666] P                         HP Fatal error:  Uncaught Error: Call to a member function setOptions() on null                          in /var/www/html/core/ajax/user.ajax.php:63\nStack trace:\n#0 {main}\n  thrown i                         n /var/www/html/core/ajax/user.ajax.php on line 63, referer: http://10.0.0.30/in                         dex.php?v=d&p=dashboard
[Mon Jun 17 21:02:21.724093 2019] [:error] [pid 787] [client 10.0.0.15:50072] PH                         P Fatal error:  Uncaught Error: Call to a member function setOptions() on null i                         n /var/www/html/core/ajax/user.ajax.php:63\nStack trace:\n#0 {main}\n  thrown in                          /var/www/html/core/ajax/user.ajax.php on line 63, referer: http://10.0.0.30/ind                         ex.php?v=d&m=camera&p=panel
[Mon Jun 17 22:03:51.868183 2019] [:error] [pid 781] [client 10.0.0.15:52275] PH                         P Fatal error:  Uncaught Error: Call to a member function setOptions() on null i                         n /var/www/html/core/ajax/user.ajax.php:63\nStack trace:\n#0 {main}\n  th[Mon Ju                         n 17 23:17:08.727183 2019] [mpm_prefork:notice] [pid 581] AH00163: Apache/2.4.25                          (Raspbian) configured -- resuming normal operations
[Mon Jun 17 23:17:08.727778 2019] [core:notice] [pid 581] AH00094: Command line:                          '/usr/sbin/apache2'
[Tue Jun 18 00:20:42.177749 2019] [:error] [pid 774] [client 10.0.0.8:63415] PHP                          Fatal error:  Uncaught Error: Call to a member function setOptions() on null in                          /var/www/html/core/ajax/user.ajax.php:63\nStack trace:\n#0 {main}\n  thrown in                          /var/www/html/core/ajax/user.ajax.php on line 63, referer: http://10.0.0.30/inde                         x.php?v=d&p=dashboard
[Tue Jun 18 05:17:27.811842 2019] [:error] [pid 775] [client 10.0.0.8:63455] PHP                          Fatal error:  Uncaught Error: Call to a member function setOptions() on null in                          /var/www/html/core/ajax/user.ajax.php:63\nStack trace:\n#0 {main}\n  thrown in                          /var/www/html/core/ajax/user.ajax.php on line 63, referer: http://10.0.0.30/inde                         x.php?v=d&p=dashboard
[Tue Jun 18 07:28:20.354125 2019] [:error] [pid 8783] [client 10.0.0.12:63023] P                         HP Fatal error:  Uncaught Error: Call to a member function setOptions() on null                          in /var/www/html/core/ajax/user.ajax.php:63\nStack trace:\n#0 {main}\n  thrown i                         n /var/www/html/core/ajax/user.ajax.php on line 63, referer: http://10.0.0.30/in                         dex.php?v=d&p=dashboard
[Tue Jun 18 07:34:04.951607 2019] [:error] [pid 8319] [client 10.0.0.12:63465] P                         HP Fatal error:  Uncaught Error: Call to a member function setOptions() on null                          in /var/www/html/core/ajax/user.ajax.php:63\nStack trace:\n#0 {main}\n  thrown i                         n /var/www/html/core/ajax/user.ajax.php on line 63, referer: http://10.0.0.30/in                         dex.php?v=d&p=dashboard

Re: 500 : Internal Server Error HELP!!!

Publié : 18 juin 2019, 11:20
par michael3131
PHP FATAL ERROR d’après ma petite analyse de noob mais apres que faire ...


il y a deux semaines je me suis dit il va faloir virer cette carte SD et mettre un SDD ( que j'ai acheté en plus ) je commence en m'en mordre les doigts

Re: 500 : Internal Server Error HELP!!!

Publié : 19 juin 2019, 10:44
par schwarzy77
Bonjour,

Dans le log apparait cela: PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] Connection refus

Cela signifie que les informations de connexion vers mysql sont incorrectes. Il faut donc que tu vérifies ces informations dans le fichier de configuration de jeedom.

Re: 500 : Internal Server Error HELP!!!

Publié : 19 juin 2019, 11:31
par michael3131
bonjour et merci pour ta réponse schwarzy77

Fichier de configuration trouvable via SSH ? Si oui lequel et son emplacement (dsl j'en demande bcp)

je vais fouiner et voir si je trouve

Re: 500 : Internal Server Error HELP!!!

Publié : 19 juin 2019, 21:08
par akenad
michael3131 a écrit :
18 juin 2019, 11:15
... J'ai une erreur 500 Internal Server Error.
... SQLSTATE[HY000] [2002] Connection refused

Bonjour @michael3131,


L'origine du problème peut dépendre de ta version actuelle du Jeedom Core.

A creuser :

- plugin vieillissant que n'aime pas trop Jeedom v3.3.x
- droits sur les fichiers
- service mysql arrêté

akenad :)

Re: 500 : Internal Server Error HELP!!!

Publié : 20 juin 2019, 14:51
par schwarzy77
michael3131 a écrit :
19 juin 2019, 11:31
bonjour et merci pour ta réponse schwarzy77

Fichier de configuration trouvable via SSH ? Si oui lequel et son emplacement (dsl j'en demande bcp)

je vais fouiner et voir si je trouve
Bonjour,
oui trouvable en ssh, le fichier en question est /var/www/html/core/config/common.config.php
Tu peux toujours tester de te connecter à Mysql avec les informations renseignées dans ce fichier. Et vérifier aussi que le processus Mysql fonctionne
(avec la commande suivante: ps aux|grep mysql).