can't figure out shared mysql database
#1
Ok, I spent hours yesterday trying to figure this out, I just can't seem to grasp what I'm doing wrong and why it's acting up.

I believe I have followed the instructions at XBMC for setting this up
http://wiki.xbmc.org/index.php?title=HOW...ng_up_XBMC

Both the server and the client connects to and manages the sql-part. They just wont use the same databases, no matter what I do. If I remove everything I find of settings on the client and delete the sql-database it had created, it will still create a new (empty) database instead of using the existing.

If I add <name>myvideos60</name> to the advancedsettings.xml file and reboot, the name tag is stripped from the file and it again creates a new (empty) database.

Code:
server
OS: Windows 7
XBMC: eden
Video DB: myvideos60
Music DB: mymusic18

<advancedsettings>
    <videodatabase>
        <type>mysql</type>
        <host>127.0.0.1</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xbmc</pass>
    </videodatabase>

    <musicdatabase>
        <type>mysql</type>
        <host>127.0.0.1</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xbmc</pass>
    </musicdatabase>
</advancedsettings>


client
OS: openelec (raspberry pi)
XBMC: 12 alpha3
Video DB: myvideos64
Music DB: mymusic20

<advancedsettings>
    <videodatabase>
        <type>mysql</type>
        <host>192.168.1.101</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xbmc</pass>
    </videodatabase>

    <musicdatabase>
        <type>mysql</type>
        <host>192.168.1.101</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xbmc</pass>
    </musicdatabase>
</advancedsettings>

Updated the server to XBMC 12 alpha5 and I'm still having the same issues.
Reply
#2
That's because the version on the Raspberry Pi and your computer are using different versions of XBMC, which require different versions of the video database. Since it looks like the R-Pi is running a build from the alpha 3 monthly cycle, try installing an alpha 3 monthly build (wiki) for Windows.
Reply
#3
And now my server (win7, XBMC 12 alpha5) creates/uses myvideos68 and mymusic27.... :\


(2012-08-27, 08:06)Ned Scott Wrote: That's because the version on the Raspberry Pi and your computer are using different versions of XBMC, which require different versions of the video database. Since it looks like the R-Pi is running a build from the alpha 3 monthly cycle, try installing an alpha 3 monthly build (wiki) for Windows.
thanks, will try Smile
Reply

Logout Mark Read Team Forum Stats Members Help
can't figure out shared mysql database0