MySQL Database: Multiple XBMC HTPC's with 1 Shared Library

(2012-03-08 00:26)parrydave Wrote:  I need a little help! New to mysql and having a few problems. Have everything set up and sharing libraries from MySQL. But i'm struggling to apply the index tweaks in post #5 of this thread.

When I apply the code, it reports back:
Query OK, 0 records affected
Records: 0 Duplicates: 0 Warnings: 0

But I have 200+ records in the movie table. Why are no records updated? Could it be an access problem? I'm logged into root.

thanks for any advice
Dave

you can check to see if the key has been applied to the table

show index from table_name;

Make sure that they key you were trying to add appears in the list and you are fine.

(2012-03-01 22:28)MrWedel Wrote:  XBMC is presenting itself as "mobile" and there are no "mobile" user on the server and it does not help if I add a user to the server called mobile and gives is alpine as psw..

Again, not an expert... but...

Did you remember to add the mobile user to the folder permissions?

OR

On WHS, grant permission to Guest/Everyone to the folder you are sharing

(2012-04-03 18:59)T800 Wrote:  if I set up a MySQL database now and then a few weeks later I want to add another HTPC and use that with the MySQL database how do I add another machine at a later date?

On your new machine just copy over the advancedsettings.xml from your existing install (or create a new one)

Quote:Also if I don't share my thumbnail folder and each machine has there own one (copied originally from the main HTPC) when are the images updated/added to the thumbnail folder?

I believe they are done when its first added to the library, so the machine that does the first scan for the new content will be the one ending up with the thumbs. I believe this is why there are suggestions to only update the library on one machine, and then set up a scheduled sync of the thumbnail folder across the others in cases where the thumbnail folder is not shared

(2012-03-08 07:52)thrak76 Wrote:  I'm getting the error "firewall exception rule not applied" or something like that, when i get done with the initial configuration of MySQL.

I've forwarded the port 3306 in my router, and added an exception for the installer and the TCP/UDP ports in windows firewall.

I go through the user creation in the server and create the databases.
When running the command: SELECT host,user from mysql.user;
I get a return with the ip 127.0.0.1, instead of the machine ip. I'm lost. Should i be pointing the AS.xml to that ip address, or my machine's local ip, as set with the router?

Thats the host where the user is allowed to connect from, in your case, the user will only be allowed to connect from the machine that MySQL is installed on (which kinda defeats the purpose of doing this)

127.0.0.1 = localhost = your network loopback interface

You need to let the user be able to connect from all the machines that will be running XBMC. And each advancedsettings.xml file should have the ip of the server running MySQL. If you are running an instance of XBMC on the same machine as you are running MySQL, on that machine only, you can use either the full ip or the loopback and both will work, provided the MySQL user has been granted permission to connect that way

This can be accomplished by either creating individual host records for the user in MySQL, an IP based wildcard record for the user depending on your local network config (as an example, "192.168.0.%" will allow you to connect from any ip within the 192.168.0 range)

or just set host to "%" which will allow it to connect from any host/ip combo.. simplest way to accomplish this:

GRANT ALL ON *.* TO 'USER'@'%';

Be advised though, the command above gives all rights from all hosts to USER, but unless you have any ecommerce websites running on that same MySQL DB you should be fine

I have an external HDD connected to my Airport Extreme Router which acts as an AIRDISK, this is what I'm currently using as one of my sources. Could I install mysql to run on the HDD or do I need a dedicated computer or NAS like a QNAP to achieve this?

You need some sort of server - computer og nas.

hello everyone

just had a read through recent discussion, sorry if I'm duplicating - I'm not sure if I am or not.

I've put a thread in 'windows' but perhaps should have joined in here - I think I've got a permissions problem with MySQL but no idea how to diagnose or fix. Can anyone help?

my thread: http://goo.gl/8n5id

thanks very much.

So, I tried to read as much of this as possible before posting and didn't see anyone having the same issues as myself.

I had the MySQL database set up and working perfectly, and then I decided to upgrade from WHS to WHS 11.

I got MySQL installed as per some of the instructions in this thread, however now when I go to open the command prompt, it asks for my password. I enter it and hit enter, then the window closes really quickly with no error message or anything.

Any ideas? I have uninstalled and re-installed several times. I believe the ports are forwarded through both my firewall and router, although I don't see how that could affect the program in this manner.

Thanks for any help, and sorry if it has been addressed already.

I installed XBMC w/ a shared library on my homeserver (WHS 2011) using the standard guide and mySQL.

Initial Library was Adult (not XXX!) films / TV shows. I also created a 2nd profile (Kids). I renamed the default Master profile to Adult.

I then installed XBMC on 2 more W7 PCs and also pointed them to the shared libraries.

Now I have a strange issue :
- Sometimes when I log-on as "Adult" profile, I can view the adult videos / tv shows when browing via files but when I look at Library (Movies / TV SHows) its giving the kids movies (but without the thumbnails).
- Other times it works fine.

Any ideas where to start looking why it is sometimes getting confused?

(2012-04-27 01:26)ethanol Wrote:  I installed XBMC w/ a shared library on my homeserver (WHS 2011) using the standard guide and mySQL.

Initial Library was Adult (not XXX!) films / TV shows. I also created a 2nd profile (Kids). I renamed the default Master profile to Adult.

I then installed XBMC on 2 more W7 PCs and also pointed them to the shared libraries.

Now I have a strange issue :
- Sometimes when I log-on as "Adult" profile, I can view the adult videos / tv shows when browing via files but when I look at Library (Movies / TV SHows) its giving the kids movies (but without the thumbnails).
- Other times it works fine.

Any ideas where to start looking why it is sometimes getting confused?

I noticed the same. I also have 2 profiles. After a clean start, the first switch in profile correctly switches the library, bur when I switch back, I see the entries of the 2nd profile.Restarting XBMC resolves the issue and then libraries are correct again. The only solution so far is to restart XBMC after have switched profiles.

I actually just posted something on this error to see if others also have this:
http://forum.xbmc.org/showthread.php?tid=131250

forgot to mention: my inital setup was the masterprofile and 1 additional profile. As an alternative I tried creating 2 profiles and not use the masterprofile, but I ended up with the same behaviour.

are you by any chance also running Openelec 2.0 beta3?