XBMC/mySQL Not Creating Databases

longsh0t · 2012-07-19 22:55

A little bit of info on my environment:

Movies and TV Shows in an UnRaid server. Sources in XBMC added as SMB (SMB://mediaserver1/movies, SMB://showserver1/tvshows)
mySQL running in a VM with Windows 7 64-bit. Firewall completely turned off for testing.
XBMC running on Windows 7 64-bit.

I followed the steps in the following wiki to sync up my XBMC installs.

http://wiki.xbmc.org/index.php?title=HOW..._libraries

I had a question regarding this as I can't seem to get it working. At what point will XBMC create the mySQL databases? As far as I can tell a new database never gets created in mySQL. If I'm reading correctly, XBMC should create a database in the following directory on the VM I'm using for mySQL.

C:\ProgramData\MySQL\MySQL Server 5.5\data

The only databases I see are "mySQL", "test", "performance_schema" and "information_schema" when I run SHOW DATABASES; in the mySQL command prompt. I see nothing related to XBMC.

GavinCampbell · 2012-07-20 04:34

Did you modify the advancedsettings.xml file to point to the mysql server?

Check the logs. Maybe its having problems connecting.

jazzyjeff · 2012-07-20 09:15

How is your advanced settings laid out?

Do you have the line in the XML file with name? <name>******<\name>
If you do have this line in the videos and music section in the advanced settings remove it. It is not necessary any more since the update of xbmc 11.

Hope this helps.

FranWilder · 2012-09-27 21:44

Have you been able to resolve this?
I have the same problem. I am running mysql on linux and my advancesettings.xml looks like this:

Code:

<advancedsettings>

  <useddsfanart>true</useddsfanart>

  <cputempcommand>cputemp</cputempcommand>

  <gputempcommand>gputemp</gputempcommand>

  <samba>

    <clienttimeout>30</clienttimeout>

  </samba>

  <network>

    <disableipv6>true</disableipv6>

  </network>

 <videodatabase>

        <type>mysql</type>

        <host>10.0.0.1<host>

        <port>3306</port>

        <user>xbmc</user>

        <pass>password</pass>

    </videodatabase>

</advancedsettings>

FranWilder · 2012-09-27 22:03

My bad.
I just saw that I missed a "/" in the "</host>" tag.

GavinCampbell Junior Member Posts: 37 Joined: Jan 2012 Reputation: 0	2012-07-20 04:34 Post: #2 Did you modify the advancedsettings.xml file to point to the mysql server? Check the logs. Maybe its having problems connecting.
	find quote

jazzyjeff Junior Member Posts: 8 Joined: Mar 2012 Reputation: 0	2012-07-20 09:15 Post: #3 How is your advanced settings laid out? Do you have the line in the XML file with name? <name>******<\name> If you do have this line in the videos and music section in the advanced settings remove it. It is not necessary any more since the update of xbmc 11. Hope this helps.
	find quote

FranWilder Junior Member Posts: 6 Joined: May 2012 Reputation: 0	2012-09-27 22:03 Post: #5 My bad. I just saw that I missed a "/" in the "</host>" tag.
	find quote