MySQL DB's not being created

  Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
aconnell Offline
Junior Member
Posts: 14
Joined: Apr 2012
Reputation: 0
Post: #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>
find quote
aconnell Offline
Junior Member
Posts: 14
Joined: Apr 2012
Reputation: 0
Post: #2
***** NEVERMIND... didn't realize I didn't need to create the DB's... WIKI shoudl be updated... ******
find quote
jmarshall Offline
Team-XBMC Developer
Posts: 25,688
Joined: Oct 2003
Reputation: 169
Post: #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]
find quote
aconnell Offline
Junior Member
Posts: 14
Joined: Apr 2012
Reputation: 0
Post: #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
find quote
jmarshall Offline
Team-XBMC Developer
Posts: 25,688
Joined: Oct 2003
Reputation: 169
Post: #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]
(This post was last modified: 2012-04-14 02:26 by jmarshall.)
find quote