1. No user installed addons are supported, python or otherwise.
2. No, they really are not supported.
3. They are not coming back
4. Read from 1. again

Any mention of illegal streaming sites, addons or any pirated material will not be tolerated. This is not democracy and any offenders will be banned and posts deleted immediately without warning.

Other than that, we hope you enjoy MrMC so far and we welcome any input and feedback you might have.

Team MrMC.

Multiple profile mySQL Database connection fails

Support for any MySQL database connection issues
User avatar
logan_x50
Posts: 89
Joined: 07 May 2016, 06:54

Multiple profile mySQL Database connection fails

Post by logan_x50 » 01 Oct 2016, 14:47

I have just set up external mySQL (mySQL is hosted on my NAS)

I have 2 Profiles; 1 for the kids movies and tv and 1 for the parents movies and tv. in order to seperate the content for each profile i chose different name for the video and music database. so profile 1 the video database name is DadVideo and profile 2 the video database name is MyVideo. same logic for music database names

If i switch between profiles mrmc will fail to connect to the database and not show the movies or tv for the profile i switched to

this can be rectified by going to settings>services>mySQL client and toggle the "enable" radio button off/on

However, not very kid friendly so will have to go back to a local database which is a pity. can this be fixed in a future MrMC version please?

User avatar
logan_x50
Posts: 89
Joined: 07 May 2016, 06:54

Re: Multiple profile mySQL Database connection fails

Post by logan_x50 » 04 Oct 2016, 09:20

I thought that swapping to a local database for one of the profiles would fix it but it doesn't.

Guess mrmc needs some logic to check the database location and make a new connection on each login

User avatar
amet
Team MrMC
Posts: 2040
Joined: 26 Oct 2015, 16:59

Re: Multiple profile mySQL Database connection fails

Post by amet » 05 Oct 2016, 15:04

I am looking into it, thanks for bringing it up.

User avatar
amet
Team MrMC
Posts: 2040
Joined: 26 Oct 2015, 16:59

Re: Multiple profile mySQL Database connection fails

Post by amet » 05 Oct 2016, 15:15

hm, I fail to reproduce this ...

my daughter has a separate Mysql database, called ana_v/ana_m ... I have a default one for our stuff... when I added her mysql database to her profile it all loads nicely.. just her tvshows and movies , switch back to master and I get our stuff.

are you sure you created profile correctly? I chose "Start Fresh" when creating new profile for both offered choices.

User avatar
logan_x50
Posts: 89
Joined: 07 May 2016, 06:54

Re: Multiple profile mySQL Database connection fails

Post by logan_x50 » 06 Oct 2016, 08:29

Hi Amet,

thanks for looking into it. pretty sure. one variation from your description is i'm using the default mysql myVideo for the non-master profile (for no good reason). I'll try and flatten the entire environment and start from scratch with master profile using default and the kids with their own mysql naming...be back in about two weeks:(

User avatar
amet
Team MrMC
Posts: 2040
Joined: 26 Oct 2015, 16:59

Re: Multiple profile mySQL Database connection fails

Post by amet » 06 Oct 2016, 11:32

hey logan_x50,

Database naming is not important at all(looking at the code), its important to start the new profile "from scratch" .. it will ask you if you want to copy from existing or start clean, choose start clean and setup that user with its own database name.

database credential are saved within new user profile and that gets loaded on switch, hence you should only see whats in the users database.

if you are not getting these results, please note down exact steps to reproduce it and I'll try to do the same on my side.

thanks, ttys
amet

User avatar
logan_x50
Posts: 89
Joined: 07 May 2016, 06:54

Re: Multiple profile mySQL Database connection fails

Post by logan_x50 » 06 Oct 2016, 13:05

thanks again. I just started with 1 fire tv and noted the steps

uninstalled mrmc and reinstalled
Step:
1. master user profile - enabled mysql leaving the default MyVideos database name. mrmc creates the database on my nas. aok
2. created the sources to videos and tv and scanned. so far so good

3. now create a new profile (kids). i leave every option as default. so i don't touch where the profile is created, sources as "separate" and as you said "start fresh" is default so i also (and have always) use that option. so literally just hit the fire tv ok button a few times to create a new profile, i'm not selecting anything other than the default options
4.log-off master user and log on to the newly created profile
5. run through the process of setting up mysql but this time change the database names to "kidsVideos" and "kidsMusic". created on my nas aok.
6. create the media sources, scan. aok. library updated.

now i log-off kids profile and back into master profile and :( no go
in order to bring the master profile movies and tv library back i need to toggle the mysql services off/on

same if i then switch back kids profile

i can't imagine what i'm doing that's different to how you have it working amet???

from your description the anomaly is the "get's loaded on switch". that doesn't seem to happen for me. one thing that is a little strange is if i look at the "Videos" menu when the library menus of Movies and TV Shows aren't loaded then i do see the sources that i created listed. does that mean that the database is loaded and there's something with the "library" loading?

can i post an image or movie to make this any clearer for you?

User avatar
amet
Team MrMC
Posts: 2040
Joined: 26 Oct 2015, 16:59

Re: Multiple profile mySQL Database connection fails

Post by amet » 06 Oct 2016, 13:22

Thats exactly how I am setting it up, only difference is I do it on tvOS and my OSX test environment.

I'll test later on ftv and see if I can reproduce there.

One thing to note is that if you are looking at recently added (on home screen) as indicator for library loaded, it could take few seconds for that content to refresh.

If you specifically enter movies/tvshow folder, you still don't see the correct content?

User avatar
logan_x50
Posts: 89
Joined: 07 May 2016, 06:54

Re: Multiple profile mySQL Database connection fails

Post by logan_x50 » 06 Oct 2016, 15:37

hi amet, that's why i thought a photo might help....in fact the "Movies" and "Tv Shows" menu doesn't show up on the home page at all. So that's why its obvious that its not working. as soon as i toggle the mySQL Client off/on and back out to the home screen the Movies and Tv Show menu's will appear with the recently added thumbnails populating shortly afterwards

User avatar
amet
Team MrMC
Posts: 2040
Joined: 26 Oct 2015, 16:59

Re: Multiple profile mySQL Database connection fails

Post by amet » 06 Oct 2016, 16:17

Maybe a debuglog ? Start one, switch to the other and let us see the log.

Checked again, all okay here on tvOS... I am lost :(

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest