MySQL server for one machine

you have to check if the db is already created witin MySql (mysql>SHOW DATABASES. Try to install a MySql frontend like http://www.heidisql.com/download.php and getting access to the server.
Make sure the db user is having GRANT rights (dbo - database owner) - GRANT ALL ON *.* TO 'xbmc';.

The created db name will be different from the name in your advancedsetting.xml. When using xbmc_video the db name will be xbmc_videoXX (XX number, not sure which one).

Did you install MySQL as a service (so it runs on all accounts)?
http://dev.mysql.com/doc/refman/5.1/en/w...rvice.html

thanks for the fast reply.
I so embrassed I thought 'xbcm' as password in advancedsetting.xml is wrong so i changed it to my MySQL user pasword.
After changing the password back to 'xbmc', bookmarks are exchanged.
The frontend shows the two dbs (myvideo60, mymusic18) andthey don't seem to be empty. the service seem to run (mysqld.exe, run by use SYSTEM)
However, now I have a different issue (that wasn't when the db wasn't accessed) the databases won't update.
Both clients 'display' some version of outdated database of my videos. I tried clearing, importing, removing libraries.
Could it be connected to sources.xml? Or premission to change the db in windows? Will posting my log help?

Are all clients running the same version of xbmc? that I believe is a requirement for mysql databases.

And make sure you are not specifying a <name> for the databases in your advancedsettings.xml Eden handles database creation and all that itself and does not like it when you interfere.

Other than that, make sure you follow the wiki entry for mysql as it is the most up-to-date source for mysql databases in xbmc

http://wiki.xbmc.org/index.php?title=HOW..._libraries


EDIT:

A debug log would certainly help

All clients are EDEN RC2 and they are the same version since it's one OS in one machine.
this is my log link: edit: I posted the log files w/o enabling DEBUG mode. posting a correct log might take a few days.
I don't know what you mean by db name, but I can tell that after the 'pass' mistake I simply copy/paste the advancedsettings.xml in the wiki (which I followed to my best understanding).
I imported the video library file from my current running portable client (which works well when MySQL db is not accessed by XBMC). I also tried removing all media folders/paths from the different client in order to 'reset' XBMC's db but it doesn't work.
Can it be related to the fact that one user had admin rights and the other doesn't?

took a while but here's my DEBUG log.
http://pastebin.com/JFqV03ee
Can anyone help?
EDIT:
I've found this thread and bug report that seem to be relavant (since my sql share is local) however I have no idea how to fix it like suggested there.
EDIT 2:
After reading through the bug report, and using the workaround suggested (sharing the media dirs and then using SMB as the source) I can finally say that syncing works in the computer.
It would be nice if this was mentioned in the WIKI.

Now the next step, I'd to have one instance as the main one: choose the skin and interface, thumbnails, posters etc.
I've used the path substitute for thumbnails, sources and addon data. However, when I choose a thumbnail, install an addon it doesn't change the other XBMC instances.
What am I doing wrong/what more do I need to do?
Plus, is there a way to make thumbnails load faster? since the path sub they load really slow and it's critical since I use the banner to select the tv show..

Once again I answering myself:
I've used Symlink for the thumbnails, addons and addon_data folder (the rest is path sub)so the instances are pretty much identical. The last challenge left is the GUI: when using path substitute on guisetting.xml, the forwarded intance doesn't apply the setting and destroys the setting for the original instance.
Does anyone know of another methof of achieving this?

(2012-04-01 23:43)BoomBang Wrote:  Once again I answering myself:
I've used Symlink for the thumbnails, addons and addon_data folder (the rest is path sub)so the instances are pretty much identical. The last challenge left is the GUI: when using path substitute on guisetting.xml, the forwarded intance doesn't apply the setting and destroys the setting for the original instance.
Does anyone know of another methof of achieving this?

I'd love to know how to fix this too. I have a WHS 2011 box serving all my media using NFS (rather than SMB) with path subs for the sources.xml, Thumbnails and addon_data folders and a MySQL DB for the media libraries.

My attempts this evening to sub guisettings.xml has fallen flat on its face; every time either machine is rebooted, the file is overwritten on the share with a default one. This is really annoying as it's proving that there isn't a permissions problem etc.

I'm running the Aeon MQ3 skin and what I'm trying to achieve is identical settings over both (and eventually other) machines.

I've read somewhere that XBMC will reset the guisettings.xml file on shutdown so this might not be fixable. I did try removing write permissions from the file to prevent this, but XMBC gets wise to this and refuses to access it at all.

Any help would be greatly appriciated.

Do NOT attempt to load guisettings.xml via path substitution. This file is written to reasonably regularly by XBMC, and thus you'll quite likely screw something up with 2 machines writing the same thing. Further, much of the content is machine-specific.