Forum Racacax

Bonsoir tout le monde

Je viens d'installer mon NAS DS 116, j'ai suivi un tuto pour regroupé les données de mes films.
j'ai bien créer mon utilisateur kodi avec ses autorisations, activé NFS, etc
j'ai creer mon fichier advancedsettings, mais ils n'arrive pas a fonctionnée, l'ip est bonne etc.

voici le debogage :

20:32:38.002 T:8792 NOTICE: No settings file to load (special://xbmc/system/advancedsettings.xml)
20:32:38.003 T:8792 NOTICE: Loaded settings file from special://profile/advancedsettings.xml
20:32:38.004 T:8792 NOTICE: Contents of special://profile/advancedsettings.xml are...
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.1.22</host>
<port>3306</port>
<user>kodi</user>
<pass>*****</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.22</host>
<port>3306</port>
<user>kodi</user>
<pass>*****</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
</advancedsettings>

ligne error :

20:32:40.908 T:6524 ERROR: Unable to open database: MyMusic60 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:32:41.926 T:6524 ERROR: Unable to open database: MyMusic59 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:32:42.944 T:6524 ERROR: Unable to open database: MyMusic58 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:32:43.969 T:6524 ERROR: Unable to open database: MyMusic57 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:32:44.988 T:6524 ERROR: Unable to open database: MyMusic56 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:32:46.018 T:6524 ERROR: Unable to open database: MyMusic55 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:32:47.038 T:6524 ERROR: Unable to open database: MyMusic54 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:32:48.053 T:6524 ERROR: Unable to open database: MyMusic53 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:32:49.078 T:6524 ERROR: Unable to open database: MyMusic52 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:32:50.095 T:6524 ERROR: Unable to open database: MyMusic51 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:32:51.135 T:6524 ERROR: Unable to open database: MyMusic50 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:32:52.151 T:6524 ERROR: Unable to open database: MyMusic49 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:32:53.167 T:6524 ERROR: Unable to open database: MyMusic48 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:32:54.187 T:6524 ERROR: Unable to open database: MyMusic47 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:32:55.204 T:6524 ERROR: Unable to open database: MyMusic46 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:32:56.225 T:6524 ERROR: Unable to open database: MyMusic45 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:32:57.244 T:6524 ERROR: Unable to open database: MyMusic44 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:32:58.262 T:6524 ERROR: Unable to open database: MyMusic43 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:32:59.282 T:6524 ERROR: Unable to open database: MyMusic42 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:00.306 T:6524 ERROR: Unable to open database: MyMusic41 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:01.430 T:6524 ERROR: Unable to open database: MyMusic40 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:02.447 T:6524 ERROR: Unable to open database: MyMusic39 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:03.467 T:6524 ERROR: Unable to open database: MyMusic38 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:04.481 T:6524 ERROR: Unable to open database: MyMusic37 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:05.495 T:6524 ERROR: Unable to open database: MyMusic36 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:06.514 T:6524 ERROR: Unable to open database: MyMusic35 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:07.526 T:6524 ERROR: Unable to open database: MyMusic34 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:08.539 T:6524 ERROR: Unable to open database: MyMusic33 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:09.566 T:6524 ERROR: Unable to open database: MyMusic32 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:10.581 T:6524 ERROR: Unable to open database: MyMusic60 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:10.581 T:6524 ERROR: Unable to create new database
20:33:11.596 T:6524 ERROR: Unable to open database: MyVideos107 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:12.654 T:6524 ERROR: Unable to open database: MyVideos106 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:13.670 T:6524 ERROR: Unable to open database: MyVideos105 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:14.688 T:6524 ERROR: Unable to open database: MyVideos104 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:15.705 T:6524 ERROR: Unable to open database: MyVideos103 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:16.821 T:6524 ERROR: Unable to open database: MyVideos102 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:17.897 T:6524 ERROR: Unable to open database: MyVideos101 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:18.913 T:6524 ERROR: Unable to open database: MyVideos100 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:19.943 T:6524 ERROR: Unable to open database: MyVideos99 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:20.960 T:6524 ERROR: Unable to open database: MyVideos98 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:21.979 T:6524 ERROR: Unable to open database: MyVideos97 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:23.007 T:6524 ERROR: Unable to open database: MyVideos96 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:24.025 T:6524 ERROR: Unable to open database: MyVideos95 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:25.055 T:6524 ERROR: Unable to open database: MyVideos94 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:26.072 T:6524 ERROR: Unable to open database: MyVideos93 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:27.090 T:6524 ERROR: Unable to open database: MyVideos92 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:28.152 T:6524 ERROR: Unable to open database: MyVideos91 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:29.168 T:6524 ERROR: Unable to open database: MyVideos90 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:30.193 T:6524 ERROR: Unable to open database: MyVideos89 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:31.210 T:6524 ERROR: Unable to open database: MyVideos88 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:32.226 T:6524 ERROR: Unable to open database: MyVideos87 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:33.241 T:6524 ERROR: Unable to open database: MyVideos86 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:34.261 T:6524 ERROR: Unable to open database: MyVideos85 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:35.325 T:6524 ERROR: Unable to open database: MyVideos84 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:36.342 T:6524 ERROR: Unable to open database: MyVideos83 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:37.359 T:6524 ERROR: Unable to open database: MyVideos82 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:38.375 T:6524 ERROR: Unable to open database: MyVideos81 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:39.392 T:6524 ERROR: Unable to open database: MyVideos80 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:40.408 T:6524 ERROR: Unable to open database: MyVideos79 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:41.425 T:6524 ERROR: Unable to open database: MyVideos78 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:42.443 T:6524 ERROR: Unable to open database: MyVideos77 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:43.521 T:6524 ERROR: Unable to open database: MyVideos76 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:44.542 T:6524 ERROR: Unable to open database: MyVideos75 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:45.561 T:6524 ERROR: Unable to open database: MyVideos107 [2003](Can't connect to MySQL server on '192.168.1.22' (10061))
20:33:45.561 T:6524 ERROR: Unable to create new database

merci de votre aide

Bonsoir,
D'après ce que je peux lire, le serveur MySQL ne fonctionne pas ou les identifiants sont faux car il n'arrive pas à s'y connecter.

oui mais est ce que j'aurais oublier quelque chose car j'ai tout suivi a la lettre

Je viens d essayer quelque chose

En voulant m identifier sur phpmyadmin en tant que Kodi ça fonctionne pas.

Bienvenue dans phpMyAdmin
#1045 - Access denied for user 'Kodi'@'localhost' (using password: YES)

mysqli_real_connect(): (HY000/1045): Access denied for user 'Kodi'@'localhost' (using password: YES)

Cela veut dire que le mot de passe est juste mauvais. Es-tu sûr de toi ? Peut-être l'as- tu mal entré ?

mon acces au phpmyadmin fonctionne si je passe en local host, mais le tuto dit d etre en tout client %

je comprend pas ça fonctionne tjr pas

est ce que ce serait pas du a la nouvelle version de mariadb 10 ??? y a pas une requete a envoyer ???

racacax a écrit :Cela veut dire que le mot de passe est juste mauvais. Es-tu sûr de toi ? Peut-être l'as- tu mal entré ?

je suis sur que le code est bon j'a verifier plusieurs fois

Si ton serveur MySQL est sur un autre appareil, il faut autoriser l'accès en externe. Je ne m'y connais pas trop par contre à ce niveau là.

racacax a écrit :Si ton serveur MySQL est sur un autre appareil, il faut autoriser l'accès en externe. Je ne m'y connais pas trop par contre à ce niveau là.

c'est un NAS reseau, et les tuto ne parle pas d'autorisation externe, mais quand je m'identifie sur phpmyadmin en faisant kodi et pass kodi, il me refuse l'acces je pense que le probleme viens de la. j'ai tapé l'ip 192.168.1.22 qui pointe vers mon NAS mais il a pas besoin d'une adresse plus complete pour pointé vers les dossier de film ? si il faut j'ai 2 erreurs, l'acces au compte kodi sur phpmyadmin et l'adresse complete 192.168.1.22/video/films ?

voila la confing du fichier avancedsetting :

<advancedsettings>
<videodatabase> (peux etre modifié le nom qui pointe vers le dossier et sous dossier ? ???)
<type>mysql</type>
<host>192.168.1.22</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.22</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
</advancedsettings>