Sharing separate user profile's libraries over mySQL
#1
I want to have separate user profiles sharing separate mySQL db's to be able to watch from different devices equipped with xbmc.

I followed the wiki HOW-TO:Share libraries using mySQL

The user profiles are setup in xbmc to use separate databases. I'm thinking since each user's advancedsettings.xml is pointing to mySQL as defined the the wiki, that they will end up sharing a global database structure instead of a user profile's individual set of libraries.

In Portable devices and profiles, it seems to be for switching databases when you're mobile or at your primary location.

I once found an outside forum thread where a user had used <name>...</name> to individualize the databases.

I'm running 12.3 as of recently and <name></name> seems deprecated.

In the advancedsettings.xml template at HOW-TO:Share libraries -- XBMC Setup

Code:
<advancedsettings>
    <videodatabase>
        <type>mysql</type>
        <host>***.***.***.***</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xbmc</pass>
    </videodatabase>

    <musicdatabase>
        <type>mysql</type>
        <host>***.***.***.***</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xbmc</pass>
    </musicdatabase>

     <videolibrary>
          <importwatchedstate>true</importwatchedstate>
     </videolibrary>
</advancedsettings>

What I've done so far is to create a separate mySQL user for each user profile.

Being <name></name> seems no longer used, I am looking for a way to individualize sharing of libraries.

An ideal scenario would be:

XBMC living room
XBMC basement

XBMC users:

Dad (NC17 and below)
Mom (NC17 and below)
Dad + Mom similar interests (NC17 and below)
Teenager (R and below)
Child (PG and below)

If Dad wants to switch xbmc devices, he can share his libraries and not use a globally shared mySQL set of libraries.
Reply
#2
<name> is still used, it's just not required.
Reply

Logout Mark Read Team Forum Stats Members Help
Sharing separate user profile's libraries over mySQL0