2011-07-08, 02:42
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!
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!