MySQL DB's not being created
#1
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>
Reply
#2
***** NEVERMIND... didn't realize I didn't need to create the DB's... WIKI shoudl be updated... ******
Reply
#3
The wiki is entirely accurate to our knowledge.

Please give us a link otherwise.
Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.


[Image: badge.gif]
Reply
#4
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...ab=Windows
Reply
#5
Thanks - (un)fortunately we're not responsible for other peoples stuff Smile

Cheers,
Jonathan
Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.


[Image: badge.gif]
Reply
 
Thread Rating:
  • 0 Vote(s) - 0 Average



Logout Mark Read Team Forum Stats Members Help
MySQL DB's not being created00