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]+)\]?([^\\/]*)(??:[\\/]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> 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 Cheers, Jonathan |