2012-04-13, 17:16
Scenario: Brand new install using the latest version of XBMC on a Windows 7 x64 machine. Installed MySQL on a Windows Server 2008 R2 x64 machine and run through the steps to create a new user "xbmc" and two databases.
I am able to connect remotely to the MySQL Server using the user xbmc and I can see the databases are empty with MySQL Workbench.
After configuring the advancedsettings.xml file and starting up XBMC, I don't see any changes in the databases (no schema added). So I look in the log and see this:
[...]
11:06:37 T:6620 ERROR: Unable to open database: xbmc_video1 [1049](Unknown database 'xbmc_video1')
11:06:37 T:6620 NOTICE: Old database found - updating from version 0 to 60
11:06:37 T:6620 ERROR: SQL: The source database was unexpectedly empty.
11:06:37 T:6620 ERROR: Unable to copy old database xbmc_video to new version xbmc_video60
11:06:38 T:6620 ERROR: Unable to open database: xbmc_video60 [1049](Unknown database 'xbmc_video60')
[...]
11:06:37 T:6620 ERROR: Unable to open database: xbmc_music1 [1049](Unknown database 'xbmc_music1')
11:06:37 T:6620 NOTICE: Old database found - updating from version 0 to 18
11:06:37 T:6620 ERROR: SQL: The source database was unexpectedly empty.
11:06:37 T:6620 ERROR: Unable to copy old database xbmc_music to new version xbmc_music18
11:06:38 T:6620 NOTICE: initialize done
11:06:38 T:6620 NOTICE: Running the application...
11:11:50 T:6620 ERROR: Unable to open database: xbmc_music18 [1049](Unknown database 'xbmc_music18')
[...]
It appears to me that XBMC is having a hard time creating the database... these errors keep repeating as I leave XBMC running.... any ideas what I've done wrong here? Just for completeness, here's my advancedsettings.xml:
<?xml version="1.0" encoding="utf-8"?>
<advancedsettings>
<sorttokens>
<token>the</token>
<token>a</token>
<token>an</token>
</sorttokens>
<tvshowmatching append="no">
<regexp>\[[Ss]([0-9]+)\]_\[[Ee]([0-9]+)\]?([^\\/]*)(??:[\\/]video_ts)[\\/]video_ts.ifo)?</regexp>
<regexp>[\._ \[\-\\/]([0-9]+)x([0-9]+)([^\\/]*)(??:[\\/]video_ts)[\\/]video_ts.ifo)?</regexp>
<regexp>[Ss]([0-9]+)[\.\-]?[Ee]([0-9]+)([^\\/]*)(??:[\\/]video_ts)[\\/]video_ts.ifo)?</regexp>
<regexp>[\._ \-\\/]([0-9]+)([0-9][0-9])([\._ \-][^\\/]*)(??:[\\/]video_ts)[\\/]video_ts.ifo)?</regexp>
</tvshowmatching>
<video>
<playcountminimumpercent>101</playcountminimumpercent>
</video>
<videoextensions>
<!-- add>.ex1|.ex2</add -->
<remove>.dat|.bin</remove>
</videoextensions>
<!-- Database Sharing/Synchronization -->
<videodatabase>
<type>mysql</type>
<host>rivercity-app01</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>rivercity-app01</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_music</name>
</musicdatabase>
<pathsubstitution>
<pathsubstitution>
<substitute>
<from>special://masterprofile/addon_data/</from>
<to>smb://rivercity-nas1/dvd/xbmc/addon_data/</to>
</substitute>
<substitute>
<from>special://masterprofile/thumbnails/</from>
<to>smb://rivercity-nas1/dvd/xbmc/thumbnails/</to>
</substitute>
<substitute>
<from>special://masterprofile/playlists/</from>
<to>smb://rivercity-nas1/dvd/xbmc/playlists/</to>
</substitute>
<substitute>
<from>special://masterprofile/sources/</from>
<to>smb://rivercity-nas1/dvd/xbmc/sources/</to>
</substitute>
</pathsubstitution>
</pathsubstitution>
</advancedsettings>
I am able to connect remotely to the MySQL Server using the user xbmc and I can see the databases are empty with MySQL Workbench.
After configuring the advancedsettings.xml file and starting up XBMC, I don't see any changes in the databases (no schema added). So I look in the log and see this:
[...]
11:06:37 T:6620 ERROR: Unable to open database: xbmc_video1 [1049](Unknown database 'xbmc_video1')
11:06:37 T:6620 NOTICE: Old database found - updating from version 0 to 60
11:06:37 T:6620 ERROR: SQL: The source database was unexpectedly empty.
11:06:37 T:6620 ERROR: Unable to copy old database xbmc_video to new version xbmc_video60
11:06:38 T:6620 ERROR: Unable to open database: xbmc_video60 [1049](Unknown database 'xbmc_video60')
[...]
11:06:37 T:6620 ERROR: Unable to open database: xbmc_music1 [1049](Unknown database 'xbmc_music1')
11:06:37 T:6620 NOTICE: Old database found - updating from version 0 to 18
11:06:37 T:6620 ERROR: SQL: The source database was unexpectedly empty.
11:06:37 T:6620 ERROR: Unable to copy old database xbmc_music to new version xbmc_music18
11:06:38 T:6620 NOTICE: initialize done
11:06:38 T:6620 NOTICE: Running the application...
11:11:50 T:6620 ERROR: Unable to open database: xbmc_music18 [1049](Unknown database 'xbmc_music18')
[...]
It appears to me that XBMC is having a hard time creating the database... these errors keep repeating as I leave XBMC running.... any ideas what I've done wrong here? Just for completeness, here's my advancedsettings.xml:
<?xml version="1.0" encoding="utf-8"?>
<advancedsettings>
<sorttokens>
<token>the</token>
<token>a</token>
<token>an</token>
</sorttokens>
<tvshowmatching append="no">
<regexp>\[[Ss]([0-9]+)\]_\[[Ee]([0-9]+)\]?([^\\/]*)(??:[\\/]video_ts)[\\/]video_ts.ifo)?</regexp>
<regexp>[\._ \[\-\\/]([0-9]+)x([0-9]+)([^\\/]*)(??:[\\/]video_ts)[\\/]video_ts.ifo)?</regexp>
<regexp>[Ss]([0-9]+)[\.\-]?[Ee]([0-9]+)([^\\/]*)(??:[\\/]video_ts)[\\/]video_ts.ifo)?</regexp>
<regexp>[\._ \-\\/]([0-9]+)([0-9][0-9])([\._ \-][^\\/]*)(??:[\\/]video_ts)[\\/]video_ts.ifo)?</regexp>
</tvshowmatching>
<video>
<playcountminimumpercent>101</playcountminimumpercent>
</video>
<videoextensions>
<!-- add>.ex1|.ex2</add -->
<remove>.dat|.bin</remove>
</videoextensions>
<!-- Database Sharing/Synchronization -->
<videodatabase>
<type>mysql</type>
<host>rivercity-app01</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>rivercity-app01</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_music</name>
</musicdatabase>
<pathsubstitution>
<pathsubstitution>
<substitute>
<from>special://masterprofile/addon_data/</from>
<to>smb://rivercity-nas1/dvd/xbmc/addon_data/</to>
</substitute>
<substitute>
<from>special://masterprofile/thumbnails/</from>
<to>smb://rivercity-nas1/dvd/xbmc/thumbnails/</to>
</substitute>
<substitute>
<from>special://masterprofile/playlists/</from>
<to>smb://rivercity-nas1/dvd/xbmc/playlists/</to>
</substitute>
<substitute>
<from>special://masterprofile/sources/</from>
<to>smb://rivercity-nas1/dvd/xbmc/sources/</to>
</substitute>
</pathsubstitution>
</pathsubstitution>
</advancedsettings>