Revenir au contenu principal
OpenID

Sujet: Bug sur le matrix 2.1 entre Openelec et mysql  (Lu 1162 fois) sujet précédent - sujet suivant

0 Membres et 1 Invité sur ce sujet
Bug sur le matrix 2.1 entre Openelec et mysql
Alors voila avec xbmc (pas kodi), sur le matrix 2.1, tout marchais bien entre le matrix et mysql.
mysql sur un qnap, et le matrix qui y accède. Le qnap contient à la fois les films/séries et la db mysql. Autant faire simple non...

j'ai le skin aeon nox (aeon en tout cas, nox je pense).

Depuis quelques temps, il n'affiche plus les infos venant de Mysql et dans le log il ne semble même plus pouvoir se connecter sur l'ip du mysql (alors qu'il lit les films sans soucis, donc l'ip est accessible).

en tentant tout plein de configs différentes, je suis tombé sur la partie "source video" la ou on spécifie l'endroit de la source (l'ip/path de mon qnap) et le type de source (films, series, ...) ainsi que le scraper associé.

et la, oh malheur, lorsque je configure ma source, il ne semble pas la mémoriser. parce que dès que je sort de la config et que j'y reviens, ... y'as plus rien faut tout refaire.

Mike .. une idée?



- XBMC 12 Openelec sur Raspberry pi  B

Re : Bug sur le matrix 2.1 entre Openelec et mysql
Réponse #1
Debug log.
Pas de mise à jour du NAS ?
Pour une aide efficace (et pour les logs), on clique
-----> :cheerleader: --ici--:cheerleader: <-----

  • Panorappix
  • [*][*][*][*][*][*][*]
  • Fondateur
  • Tipiak!
Re&nbsp;:
Réponse #2
Pb d'accès à la base visiblement

Re : Bug sur le matrix 2.1 entre Openelec et mysql
Réponse #3
Of course le debug log me dis que c'est pas joignable


01:00:11 T:1984892928  NOTICE: Running database version Addons16
01:00:11 T:1984892928   DEBUG: Initialize, updating databases...
01:00:11 T:1984892928  NOTICE: Running database version ViewModes6
01:00:11 T:1984892928  NOTICE: Running database version Textures13
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic46 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic45 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic44 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic43 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic42 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic41 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic40 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic39 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic38 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic37 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic36 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic35 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic34 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic33 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic32 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic31 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic30 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic29 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic28 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic27 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic26 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic25 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic24 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic23 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic22 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic21 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic20 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic19 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic18 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyMusic46 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to create new database
01:00:11 T:1984892928   ERROR: Unable to open database: MyVideos78 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyVideos77 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyVideos76 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyVideos75 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyVideos74 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyVideos73 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyVideos72 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyVideos71 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyVideos70 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyVideos69 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyVideos68 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyVideos67 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyVideos66 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyVideos65 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyVideos64 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyVideos63 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyVideos62 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyVideos61 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyVideos60 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to open database: MyVideos78 [2003](Can't connect to MySQL server on '10.0.1.12' (101))
01:00:11 T:1984892928   ERROR: Unable to create new database


Depuis le serveur qnap (10.0.1.12), ou myphpadmin est installé, pas de soucis pour s'y connecter...
Depuis le server windows2012 (10.0.1.27), pas de soucis pour accéder a la 10.0.1.12 en smb et en mysql sur le port 3306
Depuis le windows 7, idem pas de soucis pour que se soit en smb ou avec "my sql workbench", j'y accède...

Mon fichier advance settings :
<advancedsettings>
  <videodatabase>
    <type>mysql</type>
    <host>10.0.1.12</host>
    <port>3306</port>
    <user>xbmc</user>
    <pass>xbmc</pass>
  </videodatabase>
  <musicdatabase>
    <type>mysql</type>
    <host>10.0.1.12</host>
    <port>3306</port>
    <user>xbmc</user>
    <pass>xbmc</pass>
  </musicdatabase>
<pathsubstitution>
  <substitute>
    <from>special://masterprofile/Thumbnails/</from>
    <to>smb://moonshiner/xbmc/thumbnails/</to>
  </substitute>
</pathsubstitution>
  <videolibrary>
    <importwatchedstate>true</importwatchedstate>
    <importresumepoint>true</importresumepoint>
  </videolibrary>
  <loglevel>1</loglevel>
</advancedsettings>


mon user xbmc sur la db :
xbmc 	% 	Yes 	ALL PRIVILEGES 	Yes 	Edit Privileges Edit Privileges	Export Export

le nas a été mis a jour régulièrement, mais je ne vois nulle part une "nouvelle" option qui ferait que ca bloque.

Je sens que je vais y aller en brute force et réinstaller un nouvel openelec...
mais je n'aime pas vraiment cette solution radicale.



- XBMC 12 Openelec sur Raspberry pi  B

 
SimplePortal 1.0.0 Beta 1 © 2008-2014