[LeeZee]

Hi,

Trying to get my 2 Pi with XBMC to share the MySQL library on my Synology NAS. I think I'm almost there this is what I've done so far.

Create a new database on MyPHPAdmin with the name xbmc_videos
Created a user xbmc
Password xbmc
Gave this all permissions
Created an advanced settings.xml with the following text

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

192.168.0.4 is the IP of MyPHPAdmin

Deleted the local database and then did a scrape.

played a movie and then stopped it half way through. Went to other pi and no update of resume from.

Which log file should I post?

Help needed please!

[LeeZee]

Log

[brantje]

No need to create an database. xbmc will do it by itself, therefore you the xbmc ser needs create database permissions.

[LeeZee]

The dadabase is never being created. How do I create the database permissions?

---

I have created a user and granted all privileges.


GRANT ALL PRIVILEGES ON *.* TO 'xbmc'@'%' IDENTIFIED BY PASSWORD '*EC4F5173DE994BFEAB7040A4A32B4ED6DE26F6F0' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON `xbmc\_%`.* TO 'xbmc'@'%';

[Milhouse]

Can you repost the latest log without all the Cec noise?

Code:

grep -vi ceclog /storage/.xbmc/temp/xbmc.log | pastebinit

I'll have worn out my mousewheel before getting to anything relevant.

[LeeZee]

Restarted and took new log. Sorry as I'm sure you can tell I'm a total noob.

New Log

---

There seems to be a problem when it tries to load the advanced settings.

[tuborg]

Line 51:

Code:

07:58:26 T:1102917632   ERROR: Error loading special://profile/advancedsettings.xml, no <advancedsettings> node

The file needs to be located at ~/.xbmc/userdata/advancedsettings.xml

No spaces or any other changes to the filename.

Edit: Actually I misread that. Are you sure your file begins with <advancedsettings> and ends with </advancedsettings>?

[LeeZee]

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

---

smb://LIVINGROOM PI._smb._tcp.local/Userdata/advancedsettings

[LeeZee]

This is where I have created the advancedsettings.xml via finder and above is a copy and paste of what I have in the file.

[Ned Scott]

Make sure it is a plain text file and not a rich text file or saved as an "XML" file from MS word or whatever. It needs to be plain text.

[LeeZee]

Pretty sure it is, it says XML across it and is the same as the source file etc.

---

Uploaded with ImageShack.us

[tuborg]

You forgot the .xml on the filename.

Also like what Ned Scott said. The preview pane shows a lot of junk that should not be in the file (not sure if it causes problems). Create it with a text editor and save as plain text with filename advancedsettings.xml with only the lines that you pasted earlier.

[LeeZee]

I got

Thanks for everyones help!