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

  Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
rcmiller1981 Offline
Junior Member
Posts: 1
Joined: Oct 2014
Reputation: 0
Post: #331
I have set up a shared database with
mysql Ver 14.14 Distrib 5.5.37, for debian-linux-gnu (x86_64) using readline 6.2,
and
First Device Media-1:
XBMC (13.1 Git:f2acae7).
Platform: x86 Linux 64-bit
Using Release XBMC x64 build, compiled Jun6 2014 by GCC 4.8.1 for x86 Linux 64-bit 3.11.10

second device Media-2:
XBMC (14.0-ALPHA1 Git:201407162054-7eed7e6).
Platform: Linux x86 64-bit
Using Release XBMC x64 build

this is the advancedsettings.xml file:
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>10.0.0.10</host>
<port>3306</port>
<user>xbmc</user>
<pass>password</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>10.0.0.10</host>
<port>3306</port>
<user>xbmc</user>
<pass>password</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
</advancedsettings>

I started the first media center, (Media-1) and populated the DB, then started the second media center, (Media-2) and it created a new database called "MyVideos88", I tried adding a <NAME> tag to the advancedsettings.xml but it still creates a new DB with the <NAME> tag and "88" appended to the name.

any idea why, I know they are two different version and I am going to update to same versions now. Any other Ideas let me know.
find quote
nickr Online
Donor
Posts: 8,974
Joined: May 2009
Reputation: 161
Location: Christchurch NZ
Post: #332
13 and 14 use different database schemas. You need to run the same version on all clients for MySQL to work.

If I have helped you or increased your knowledge, click the plus button and increase my reputation :)
find quote
Post Reply