[BULLIT]

Hey Guy's ,

Just wanted to confirm this is possible before I jump into this. Is it possible to set up two different MySQL db's and have two different profiles on 2 XBMC installs. I would like a different DB for the kids and one for me. Thanks in advance.

[BULLIT]

Anyone

[jmarshall]

Yes - advancedsettings.xml is profile based, so you should be able to point at a different server.

[BULLIT]

Thanks.

[jhsrennie]

See http://wiki.xbmc.org/?title=Advancedsett...atabase.3E

Unless you have two MySQL servers, or two MySQL installations listening on different ports, you'll need to use different database names for the two separate databases. It should work fine.

JR

[reblutus]

My goal is the same here: to create a profile for the kids.

So I added on my apple tv 2 an advancessettings.xml in

/private/var/mobile/Library/Preferences/XBMC/userdata/profiles/kids/advancedsettings.xml

Which is basically a modified copy of my main advancedssettings.xml in /private/var/mobile/Library/Preferences/XBMC/userdata/advancedsettings.xml , with this content:

<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.111.105</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video_kids</name>
</videodatabase>

<musicdatabase>
<type>mysql</type>
<host>192.168.111.105</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_music_kids</name>
</musicdatabase>
</advancedsettings>

Then when I try to change the profile in "settings > profiles" or on the login screen, XBMC freezes and the only thing I can do is reboot.

What did I do wrong?

Note that the tables are not created. I tried to manually create the databases, but it did not help.

[jhsrennie]

Enable debug logging and have a look at the log. There might be some clues there.

JR

[reblutus]

Enable debug logging and have a look at the log. There might be some clues there.

JR

ok here is what I get right before the freeze:

08:19:33 T:98996224 M:122314752 DEBUG: ------ Window Deinit (Settings.xml) ------
08:19:33 T:98996224 M:122314752 DEBUG: ------ Window Init (SettingsProfile.xml) ------
08:19:33 T:98996224 M:122314752 INFO: Loading skin file: SettingsProfile.xml
08:19:47 T:98996224 M:124903424 INFO: Loading skin file: DialogContextMenu.xml
08:19:47 T:98996224 M:124895232 DEBUG: ------ Window Init (DialogContextMenu.xml) ------
08:19:50 T:98996224 M:123568128 DEBUG: ------ Window Deinit (DialogContextMenu.xml) ------
08:19:50 T:98996224 M:124727296 DEBUG: NetworkMessage - Signaling network services to stop
08:19:50 T:98996224 M:124727296 NOTICE: ES: Stopping event server
08:19:50 T:98996224 M:124727296 DEBUG: NetworkMessage - Waiting for network services to stop
08:19:50 T:98996224 M:124727296 NOTICE: stopping upnp
08:19:50 T:97931264 M:124710912 DEBUG: Thread JSONRPC::CTCPServer 97931264 terminating
08:19:50 T:101658624 M:124731392 NOTICE: ES: UDP Event server stopped
08:19:50 T:101658624 M:124731392 DEBUG: Thread EventServer 101658624 terminating
08:19:51 T:98996224 M:124772352 NOTICE: stopping zeroconf publishing
08:19:51 T:98996224 M:124772352 NOTICE: Webserver: Stopping...
08:19:51 T:121384960 M:124772352 DEBUG: Thread Jobworker 121384960 terminating (autodelete)
08:19:51 T:108335104 M:124784640 DEBUG: Thread Jobworker 108335104 terminating (autodelete)
08:19:53 T:75370496 M:124788736 DEBUG: Thread Jobworker 75370496 terminating (autodelete)

[jhsrennie]

Can you pop the whole log on pastebin.com.

JR