2011-06-26, 20:25
I'm having problems with setting up a library with MySQL. The database doesn't want to populate. The scrape process doesn't seem to be able to write to the database. I have followed the tutorial word by word, but it's not working. I'm using the latest stable version of XBMC and MySQL server for Windows (running Win7 x64).This is what I did:
- Install XBMC
- Installed MySQL server for Windows
- Added the databases and user + grant permissions as per the tutorial
- Verified the xbmc_video and xbmc_music databases excist
- Verified that the user xbmc has wildcard permissions
- Added the advancedsettings.xml to:
C:\Users\<username>\AppData\Roaming\XBMC\userdata
With the following contents:
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.1.5</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.5</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_music</name>
</musicdatabase>
</advancedsettings>
192.168.1.5 is the address of the local host which has the MySQL server running. I also tried: localhost, 127.0.0.1 and the machine's netbiosname.
- When I start XBMC after having configured MySQL, the xbmc_video database gets populated with the various tables. I then add a source in XBMC which is a folder that has a couple of TV shows just for testing purposes, called: c:\test
- I then choose the TVDB scraper and then it just doesn't do anything. The source is added, but nothing is added to the library. I can confirm this as I can't enable 'library mode' and a 'select' on the 'tvshow' table shows it's empty.
I can confirm that my folder and files have the proper naming conventions, as I have tried using the default XBMC library database (i.e: not MySQL) and then the scraper does its work and creates a library, thus allowing me to enable 'library mode'.
I've turned on debugging in XBMC and this is what I get when I add a source:
I've already tried beginning from scratch, i.e: uninstalling XBMC, XBMC's userdata, MySQL and MYSQL's userdata. I even tried this on another 'clean' machine and I get exactly the same issue.
Can anyone help please? I've been at this all day now and I'm losing my mind here...this is so frustrating...
- Install XBMC
- Installed MySQL server for Windows
- Added the databases and user + grant permissions as per the tutorial
- Verified the xbmc_video and xbmc_music databases excist
- Verified that the user xbmc has wildcard permissions
- Added the advancedsettings.xml to:
C:\Users\<username>\AppData\Roaming\XBMC\userdata
With the following contents:
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.1.5</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.5</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_music</name>
</musicdatabase>
</advancedsettings>
192.168.1.5 is the address of the local host which has the MySQL server running. I also tried: localhost, 127.0.0.1 and the machine's netbiosname.
- When I start XBMC after having configured MySQL, the xbmc_video database gets populated with the various tables. I then add a source in XBMC which is a folder that has a couple of TV shows just for testing purposes, called: c:\test
- I then choose the TVDB scraper and then it just doesn't do anything. The source is added, but nothing is added to the library. I can confirm this as I can't enable 'library mode' and a 'select' on the 'tvshow' table shows it's empty.
I can confirm that my folder and files have the proper naming conventions, as I have tried using the default XBMC library database (i.e: not MySQL) and then the scraper does its work and creates a library, thus allowing me to enable 'library mode'.
I've turned on debugging in XBMC and this is what I get when I add a source:
Quote:9:29:08 T:3628 M:2853249024 DEBUG: Mysql execute: update path set strContent = '', strScraper='', strHash='',strSettings='',useFolderNames=0,scanRecursive=0 where strPath like '%c:\\test\\%'
19:29:08 T:3628 M:2853244928 DEBUG: Mysql execute: insert into path (idPath, strPath, strContent, strScraper) values (NULL,'c:\\test\\','','')
19:29:08 T:3628 M:2853232640 ERROR: SQL: Undefined MySQL error: Code (1062)
Query: insert into path (idPath, strPath, strContent, strScraper) values (NULL,'c:\\test\\','','')
19:29:08 T:3628 M:2853208064 ERROR: CVideoDatabase::AddPath unable to addpath (insert into path (idPath, strPath, strContent, strScraper) values (NULL,'c:\\test\\','',''))
I've already tried beginning from scratch, i.e: uninstalling XBMC, XBMC's userdata, MySQL and MYSQL's userdata. I even tried this on another 'clean' machine and I get exactly the same issue.
Can anyone help please? I've been at this all day now and I'm losing my mind here...this is so frustrating...