[Nano07]

Hello Guys,

I was wondering if someone has experience with this and can give me a hand.

I have a setup like this:

- MacPro (Leopard - 192.168.1.8): mysql (MAMP) + XBMC 10.1
- Macbook (SnowLeopard): XBMC 10.1
- AppleTV1: XBMC 10.1


MacPro

This is what I did to set up the server:

1) Installed XBMC
2) MacPro - Installed MAMP
3) Configured mysql following instructions on this post

http://lifehacker.com/5634515/how-to-syn...-the-house

Basically what I did is:

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


Then created an xml file called: "advancedsettings.xml" with this text inside...

<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.1.8</host>
<port>8889</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>
</advancedsettings>

... and copied it to

~/Library/Application Support/XBMC/userdata




Macbook (SnowLeopard): XBMC 10.1
added advancedsettings.xml to ~/Library/Application Support/XBMC/userdata



AppleTV1: XBMC 10.1
Added advancedsettings.xml to: /Applications/XBMC.app/contents/resources/XBMC/userdata

I'm really not sure if I did this correctly?



TEST RESULTS

- XBMC running on Server- OK runs fine, it's able to populate the database, and communicates fine with mysql.

- XBMC running on Macbook - VERY SLOW and becomes irresponsive
I open XBMC and when I go into TVSHOWS for example, it takes forever to navigate through the library. When it finally does, it shows the correct information, but when I try to play the file it says that it doesn't exist in the library (if I navigate through 'FILES' menu, they play alright).
So next, I added 'skip-name-resolve' under [mysqld] in my.cnf(*) and restarted the mysql service, but nothing seems to have changed.
(*) Because I have MAMP and the 'my.cnf' file didn't exist, I had to create it by copying /Applications/MAMP/Library/support-files/my-small.cnf to /Applications/MAMP/db/mysql/my.cnf (notice that I renamed it).

- XBMC running on AppleTV1 - Nothing seems to happen. It's still using the local library...


Can someone help me fix the issue in my Macbook and my AppleTV?


Thanks!

[Nano07]

Bump! anyone willing to help me? please...

[blackopsdave]

I have exactly the same issue.

ATV2.0 to mysql db on my qnap is fine, but it I add the advancedsettings.xml to the correct file on my macbook xbmc runs rreeeaaaalllyyyy sssslllooowww.

[blackopsdave]

Further tests reveal it is definitely the connection to mysql that is the problem.

If I keep the advancedsettings.xml file there, but edit out the:


<videodatabase>
<type>mysql</type>
<host>192.168.1.12</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>

it works fine - I can use my nas as storage and view on my macbook.

[Nano07]

Further tests reveal it is definitely the connection to mysql that is the problem.

If I keep the advancedsettings.xml file there, but edit out the:


<videodatabase>
<type>mysql</type>
<host>192.168.1.12</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>

it works fine - I can use my nas as storage and view on my macbook.

You mean, that you can view though video files and not using the library correct?

How did you install mysql in the Server? Is it a Mac? Did you use MAMP?

[blackopsdave]

If I remove the mysql connection info I guess xbmc reverts back to the previous library which was held on the macbook but links to the movies on my nas.

I've got a QNAP 210, with mysql and phpmyadmin installed on it. Works fine.

I've enabled logging on xbmc I can see the fps go down to 1.2 ish fps on the main screen, as soon as I go to the (empty) Library > Movies it ramps up to 59.9fps.

[blackopsdave]

I'll post full logs tomoz.