[Eskalibur]

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

[chrischambers]

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

[damire80]

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

[Raytestrak]

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.

[damire80]

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?

[Dilligaf]

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

[Raytestrak]

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

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.

[flhthemi]

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...

[damire80]

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

[Dilligaf]

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??

[Raytestrak]

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.

[damire80]

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

[jmh2002]

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.

[Milhouse]

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...)

[jmh2002]

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