Kodi Community Forum
HOW-TO:Share libraries using MySQL: Wiki Edition - Printable Version

Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: Tips, tricks, and step by step guides (https://forum.kodi.tv/forumdisplay.php?fid=110)
--- Thread: HOW-TO:Share libraries using MySQL: Wiki Edition (/showthread.php?tid=157572)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - Eskalibur - 2015-05-19

Hey, I've got a few raspberries connected to a db in MySQL.
I'd like to know if it's possible to make a second db.
For example, if I watch a movie it gets marked as "seen". For my room mate, seeing the list of movies he's not seen, the movie won't show up as "not seen."
Is it possible to change what names kodi gives to the databases?
Eg: mymusicJB
MymoviesJB


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - chrischambers - 2015-05-19

(2015-05-19, 13:39)Eskalibur Wrote: Hey, I've got a few raspberries connected to a db in MySQL.
I'd like to know if it's possible to make a second db.
For example, if I watch a movie it gets marked as "seen". For my room mate, seeing the list of movies he's not seen, the movie won't show up as "not seen."
Is it possible to change what names kodi gives to the databases?
Eg: mymusicJB
MymoviesJB

I would put the following reference in your AdvanceSetting.xls

<videodatabase>
<type>mysql</type>
<host>XXX.XXX.XXX.XXX</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>MyVideosJB</name>
</videodatabase>

<musicdatabase>
<type>mysql</type>
<host>XXX.XXX.XXX.XXX</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>MyVideosJB</name>
</musicdatabase>

and do the same for the other person, but call it something different, this will create a second DB in your SQL Database


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - damire80 - 2015-06-01

can someone help...

i have exported my movies from my laptop and those movies have been added to my wifes computer!! so now how do i get them talking to each other ? if i pause on one so i can resume on the other?

cheers


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - Raytestrak - 2015-06-01

(2015-06-01, 13:00)damire80 Wrote: can someone help...

i have exported my movies from my laptop and those movies have been added to my wifes computer!! so now how do i get them talking to each other ? if i pause on one so i can resume on the other?

cheers

That's exactly what a central database does for you. You make sure all media is accessible from all computers via shares/unc paths, scan those into a mysql database and connect your kodi client to that mysql database. Just follow the guide.


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - damire80 - 2015-06-02

yeah i realize that is what it does! but they are not talking to each other... that is why i am asking what haven't i done?


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - Dilligaf - 2015-06-02

Pause won't set a resume point. You must stop the video in order for a resume point to be created.


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - Raytestrak - 2015-06-02

(2015-06-02, 08:47)Dilligaf Wrote: Pause won't set a resume point. You must stop the video in order for a resume point to be created.

I meant to mention that Big Grin

(2015-06-02, 08:41)damire80 Wrote: yeah i realize that is what it does! but they are not talking to each other... that is why i am asking what haven't i done?

Make sure your sources.xml, password.xml (passwords.xml?) and the advancedsettings.xml contain the same values.
What OS('es) are you using? I'm using windows, kodibuntu, openelec and android without any problems. Can you access your shares from all clients? If so, what does the log say about the database? Maybe you have a firewall issue? Before starting a mysql setup, your network needs to be in order.


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - flhthemi - 2015-06-02

(2015-06-02, 08:41)damire80 Wrote: yeah i realize that is what it does! but they are not talking to each other... that is why i am asking what haven't i done?

How about a list of EXACTLY what you HAVE done?

The way I'm reading things it sounds like you copied the movies from one PC to another. The idea behind using MySQL is to have the movies/videos in ONE location. Like a shared folder on a PC or a NAS device.

I found this article very helpful when I set mine up a couple years ago. Keep in mind the basics will work but MySQL has been updated. You could probably install 5.5 and get it going and then update MySQL...


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - damire80 - 2015-06-03

no i haven't just copied movies from one computer to another.... i set up MySQL when i add a library one my main computer there are then accessible on all my other devices that i have add the advancedsettings.xml, but its not allowing me to start something on one device then continue watching on another


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - Dilligaf - 2015-06-03

(2015-06-03, 08:10)damire80 Wrote: no i haven't just copied movies from one computer to another.... i set up MySQL when i add a library one my main computer there are then accessible on all my other devices that i have add the advancedsettings.xml, but its not allowing me to start something on one device then continue watching on another

If you start watching a video on one install then STOP the video (NOT PAUSE) you should then be able to select the same video on another install and you will be prompted to resume from xxx or restart from beginning. . In your previous post you said you paused on the first machine, does it work if you STOP??


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - Raytestrak - 2015-06-03

(2015-06-03, 08:33)Dilligaf Wrote:
(2015-06-03, 08:10)damire80 Wrote: no i haven't just copied movies from one computer to another.... i set up MySQL when i add a library one my main computer there are then accessible on all my other devices that i have add the advancedsettings.xml, but its not allowing me to start something on one device then continue watching on another

If you start watching a video on one install then STOP the video (NOT PAUSE) you should then be able to select the same video on another install and you will be prompted to resume from xxx or restart from beginning. . In your previous post you said you paused on the first machine, does it work if you STOP??

When using the same MySQL database, yes.


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - damire80 - 2015-06-03

ok sorry i tried stop and no it doesn't work.....


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - jmh2002 - 2015-06-03

Im trying to recall (and I could be wrong), but I think a trick might be that you need to have System>Video>File Lists>Default Select Action set to: "Choose" in order to be presented with the option to "Resume" in the situation where you try to start playing the video again on another device?

Try it and see if it helps. Certainly on my previous mySQL setup it all worked for me, and yes I also confirm that you must stop the video in order for a resume point to be created.


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - Milhouse - 2015-06-03

(2015-06-03, 12:16)jmh2002 Wrote: Im trying to recall (and I could be wrong), but I think a trick might be that you need to have System>Video>File Lists>Default Select Action set to: "Choose" in order to be presented with the option to "Resume" in the situation where you try to start playing the video again on another device?

Try it and see if it helps. Certainly on my previous mySQL setup it all worked for me, and yes I also confirm that you must stop the video in order for a resume point to be created.

Not saying you're wrong, but I get the "Resume"/"Start from beginning" options when I have Play as the "Default Select Action" (now starting to wonder if I should...)


RE: HOW-TO:Share libraries using MySQL: Wiki Edition - jmh2002 - 2015-06-03

ok good, I wasnt sure because I was trying to remember back to my first mySQL setup with Eden! Big Grin


This forum uses Lukasz Tkacz MyBB addons.