Kodi Community Forum
MySQL DB's not being created - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: MySQL DB's not being created (/showthread.php?tid=128780)



MySQL DB's not being created - aconnell - 2012-04-13

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]+)\]?([^\\/]*)(?Sad?:[\\/]video_ts)[\\/]video_ts.ifo)?</regexp>
<regexp>[\._ \[\-\\/]([0-9]+)x([0-9]+)([^\\/]*)(?Sad?:[\\/]video_ts)[\\/]video_ts.ifo)?</regexp>
<regexp>[Ss]([0-9]+)[\.\-]?[Ee]([0-9]+)([^\\/]*)(?Sad?:[\\/]video_ts)[\\/]video_ts.ifo)?</regexp>
<regexp>[\._ \-\\/]([0-9]+)([0-9][0-9])([\._ \-][^\\/]*)(?Sad?:[\\/]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>



RE: MySQL DB's not being created - aconnell - 2012-04-13

***** NEVERMIND... didn't realize I didn't need to create the DB's... WIKI shoudl be updated... ******


RE: MySQL DB's not being created - jmarshall - 2012-04-14

The wiki is entirely accurate to our knowledge.

Please give us a link otherwise.


RE: MySQL DB's not being created - aconnell - 2012-04-14

You know what, it is accurate. I was following the instructions on the Lifehacker site and got th etwo confused. My bad... the wiki does not say to create the DBs:
http://wiki.xbmc.org/index.php?title=HOW-TO:Sync_multiple_libraries/Setting_up_MySQL#tab=Windows


RE: MySQL DB's not being created - jmarshall - 2012-04-14

Thanks - (un)fortunately we're not responsible for other peoples stuff Smile

Cheers,
Jonathan