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: 4
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: 9,011
Joined: May 2009
Reputation: 163
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
rcmiller1981 Offline
Junior Member
Posts: 4
Joined: Oct 2014
Reputation: 0
Post: #333
I have updates to use 14.0 on both servers. They for some odd reason pull different ALPHA's from the PPA, however. they are still using two different Databases. The first is using XBMC-Videos88 and the second is using XBMC-Videos90. They are some how using the exact same Music Database.

How can I resolve this, do I have to get them to the exact same alpha?
Do they increment the number every alpha?

Again the advancedsettings.xml:
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>10.0.0.10</host>
<port>3306</port>
<name>XBMC-Videos</name>
<user>xbmc</user>
<pass>password</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>10.0.0.10</host>
<port>3306</port>
<name>XBMC-Music</name>
<user>xbmc</user>
<pass>password</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
</advancedsettings>

media-2 is:

11:29:32 T:140243038746560 NOTICE: Starting Kodi (14.0-ALPHA5 Git:b5947af). Platform: Linux x86 64-bit
11:29:32 T:140243038746560 NOTICE: Using Release Kodi x64 build

Media-1 is:
11:36:42 T:140371563239296 NOTICE: Starting XBMC (14.0-ALPHA1 Git:a891415). Platform: Linux x86 64-bit
11:36:42 T:140371563239296 NOTICE: Using Release XBMC x64 build
(This post was last modified: 2014-10-20 19:25 by rcmiller1981.)
find quote
rcmiller1981 Offline
Junior Member
Posts: 4
Joined: Oct 2014
Reputation: 0
Post: #334
I am just going to take it back to Gotham!
find quote
nickr Online
Donor
Posts: 9,011
Joined: May 2009
Reputation: 163
Location: Christchurch NZ
Post: #335
The database version changes during development. http://kodi.wiki/view/Database_version

You are using helix, you are helping development, but you risk breakage.

If I have helped you or increased your knowledge, click the plus button and increase my reputation :)
find quote
rcmiller1981 Offline
Junior Member
Posts: 4
Joined: Oct 2014
Reputation: 0
Post: #336
that's brilliant, wish i would have seen it earlier. i thought the number was a glitch. perhaps I need to read the big giant bolded headers.
find quote
Post Reply