2015-07-22, 20:03
Hi
I have tried alot and looking on the wiki for how to get the kodi v. 14.2 to work with MYSQL. But no matter what i do i can´t figure out where the problem is. so i´m gonna paste my info here so I hope you have some solutions ;-)
the advancedsettings.xml file looks like this
----------------------------------------------------------------------------------------------------------------
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.169.40.118</host>
<port>3306</port>
<user>kodi</user>
<pass>xxxxxxxx</pass>
<name>kodi_video<name>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.169.40.118</host>
<port>3306</port>
<user>kodi</user>
<pass>xxxxxxxx</pass>
<name>kodi_music<name>
</musicdatabase>
</advancedsettings>
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
sources.xml file
-----------------------------------------------------------------------------------------------------------------------
<sources>
<programs>
<default> pathversion="1"></default>
</programs>
<video>
<default> pathversion="1"></default>
<source>
<name>TV Shows</name>
<path pathversion="1">smb://NAS/Serier/</path>
</source>
<source>
<name>Movies</name>
<path pathversion="1">smb://NAS/film/</path>
</source>
<name>Main Music Collection</name>
<path pathversion="1">smb://NAS/music/</path>
</source>
</video>
<Music>
<source>
<name>Main Music Collection</name>
<path pathversion="1">smb://NAS/music/</path>
</Music>
<allowsharing>true</allowsharing>
</sources>
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
see this is where i don´t understand it. I have put these two files into the right folder under my user. C:\Users\Jann\AppData\Roaming\Kodi\userdata
but the mysql database doesn´t seem to make a schema or tables under the Kodi Table, isn´t it suppose to do that?
The user i have made on the mysql is kodi with the same password as in the advancedsettings.xml file
I have also made a USER on the NAS (synology) with the exact same credentials and password.
To me it seems like there is no link between the 2.... like the kodi won´t look into the mysql?
I have confirmed this by logging into the mysql and seen the kodi table (none what so ever). there is nothing when i look into kodi itself it doesn´t refer to the sources. Just seems like a brand new kodi install.
any suggestions?
I have tried alot and looking on the wiki for how to get the kodi v. 14.2 to work with MYSQL. But no matter what i do i can´t figure out where the problem is. so i´m gonna paste my info here so I hope you have some solutions ;-)
the advancedsettings.xml file looks like this
----------------------------------------------------------------------------------------------------------------
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.169.40.118</host>
<port>3306</port>
<user>kodi</user>
<pass>xxxxxxxx</pass>
<name>kodi_video<name>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.169.40.118</host>
<port>3306</port>
<user>kodi</user>
<pass>xxxxxxxx</pass>
<name>kodi_music<name>
</musicdatabase>
</advancedsettings>
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
sources.xml file
-----------------------------------------------------------------------------------------------------------------------
<sources>
<programs>
<default> pathversion="1"></default>
</programs>
<video>
<default> pathversion="1"></default>
<source>
<name>TV Shows</name>
<path pathversion="1">smb://NAS/Serier/</path>
</source>
<source>
<name>Movies</name>
<path pathversion="1">smb://NAS/film/</path>
</source>
<name>Main Music Collection</name>
<path pathversion="1">smb://NAS/music/</path>
</source>
</video>
<Music>
<source>
<name>Main Music Collection</name>
<path pathversion="1">smb://NAS/music/</path>
</Music>
<allowsharing>true</allowsharing>
</sources>
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
see this is where i don´t understand it. I have put these two files into the right folder under my user. C:\Users\Jann\AppData\Roaming\Kodi\userdata
but the mysql database doesn´t seem to make a schema or tables under the Kodi Table, isn´t it suppose to do that?
The user i have made on the mysql is kodi with the same password as in the advancedsettings.xml file
I have also made a USER on the NAS (synology) with the exact same credentials and password.
To me it seems like there is no link between the 2.... like the kodi won´t look into the mysql?
I have confirmed this by logging into the mysql and seen the kodi table (none what so ever). there is nothing when i look into kodi itself it doesn´t refer to the sources. Just seems like a brand new kodi install.
any suggestions?