Kodi Community Forum

I have invested 8 hours into getting MySQL to work and am not having much luck.

I can not get XBMC to create the default MySQL databases (eg MyVideosXX). I have tried this with MySQL server installed on a Windows machine and a Mac and neither seems to be working. Also, I have tried on the Frodo release candidate as well as one of the recent nightlies. If I use the <name> tag in the advancedsettings.xml, I can get XBMC to create a database on the mysql server, but nothing else happens (XBMC's are not syncing with mysql).

Also, I have ensured that I input the following commands into the mysql server:

CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
GRANT ALL ON *.* TO 'xbmc';

If it is any help, here is the link for my XBMC log in pastebin: http://pastebin.com/yJ2aZADH

Here is what my advancedsettings.xml looks like:

<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.1.30</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>

<musicdatabase>
<type>mysql</type>
<host>192.168.1.30</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</musicdatabase>
</advancedsettings>

Does anybody know why this is occuring?

Thank you in advance![/php]

Can you post the full debug log? The snippet you posted doesn't seem to have any info on MySQL related stuff.

Here is my full log: http://pastebin.com/2AgkqLrX

Thanks for your help.

Your xml file is bad

20:49:18 T:140735231267200 ERROR: Error loading special://profile/advancedsettings.xml, Line 0

Martin

Seems something is wrong with the advancedsettings.xml file. Can you paste the contents?

I appologize, I am not sure how to embed pastebin. Here is the link of what I have in my advancedsettings.xml: http://pastebin.com/ASaEuBGT

Looks fine to me. If you're making this file with something like TextEdit, make sure that the file is a plaintext file and not a rich text file. Not sure what else it could be.

I used a different text editor to create my XML file and it worked! Thanks again for all your help on this issue.