Hello,
A little background. I have set up “MySQL” several times in the past to sync all my media. But this time I am having a bit of trouble and I am hoping someone can guide me in the right direction.
I have MySQL set up on a Windows 8.1 machine. Everything looks good regarding the databases because I can see both the VideoXXX and the MusicXX when I query the database.
Here is my advancedsettings code:
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.11.2</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.11.2</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
</advancedsettings>And my passwords file is:
<passwords>
<path>
<from pathversion="1">smb://192.168.11.2/e/Movies</from>
<to pathversion="1">smb://xxx:[email protected]/e/Movies/</to>
</path>
<path>
<from pathversion="1">smb://192.168.11.2/e/Music</from>
<to pathversion="1">smb://xxx:[email protected]/e/Music/</to>
</path>
<path>
<from pathversion="1">smb://192.168.11.2/e/Recorded TV</from>
<to pathversion="1">smb://xxx:[email protected]/e/Recorded TV/</to>
</path>
<path>
<from pathversion="1">smb://192.168.11.2/e/TV Shows</from>
<to pathversion="1">smb://xxx:[email protected]/e/TV Shows/</to>
</path>
</passwords>With
xxx:xxxxxxbeing username:password and the “e” after the IP address is the drive letter that the various media is stored on.
My old server didn’t have to use the drive letter; therefore it was smb://xxx.xxx.xxx.xxx/Movies, smb://xxx.xxx.xxx.xxx/TV Shows, etc. Is the drive letter tripping me up? Is there something else I am missing or doing wrong?
Thanks!