Database: Refactor MP1 database for multi seat usage (4 Viewers)

framug

Super Moderator
  • Team MediaPortal
  • January 31, 2005
    5,044
    1,046
    South of France
    Home Country
    France France
    @Anthony :
    What I found sometimes is because if DEV machine, we install all DEV environnement.
    And, what we make is working on this PC.
    Therefore, pushing all files (.DLL, .exe, ....) in another PC without DEV environnement doesn't work.
    That why, if you can, maybe installing your change in MP 1.29 "production" machine could help to see if it works or not.
     

    Anthony Vaughan

    MP Donator
  • Premium Supporter
  • June 25, 2015
    516
    281
    Home Country
    United Kingdom United Kingdom
    Unfortunately we are still experiencing headwinds. :(
    Articles I have been reading seem to suggest that .NET Framework 4.5 should be loaded for Entity Framework.

    As it happens, I use 4.8 for my other software so all of my machines have the latest .NET frameworks.

    I suspect this is the root of the issue and maybe it's a good thing that this came up now if that is the case.

    Anyway, it would be good to know what .NET Framework you have installed.
     

    CyberSimian

    Test Group
  • Team MediaPortal
  • June 10, 2013
    2,465
    1,488
    Southampton
    Home Country
    United Kingdom United Kingdom
    Are you using a centralized configuration (i.e. do you have MediaPortalDirs.xml in the users/documents folder)? Does MediaPortalDirs.xml contain what you would normally expect?
    I have never modified "MediaPortalDirs.xml", so I am using the default file in the default location.

    I wonder whether the fact that you are using dual-boot is affecting what the path would be. It's a stretch ... Do you have a machine available that you could use as a test machine that boots straight into Windows?
    The Bootit boot manager would not have caused this, as it hides completely the other operating-system partitions so that the booted partition cannot see them. Unfortunately, I use Bootit on all of my systems.

    are you installing any extensions?
    The only extensions that are installed are the ones that are included in the install package.

    My Windows 7 machine has .NET Framework 4.8 and 4 Multi-targeting pack.
    My production system has .NET 4.8 (see screen shot). This is all that is needed for MP 1.29, but perhaps the database changes introduce a new dependency?

    installed_programs.jpg

    I tried searching for the error message, and found these two pages (among others) where the authors had similar problems:


    I don't know whether these apply to this case.

    -- from CyberSimian in the UK
     

    Anthony Vaughan

    MP Donator
  • Premium Supporter
  • June 25, 2015
    516
    281
    Home Country
    United Kingdom United Kingdom
    I don't know whether these apply to this case.
    Yes, I already had a look at those. The thing is that I use EF with SQLite all over the place and have got the configuration working with other commercial organizations as well.

    My production system has .NET 4.8 (see screen shot). This is all that is needed for MP 1.29, but perhaps the database changes introduce a new dependency?
    You seem to have everything setup correctly - which is what I would have expected anyway :) .

    On my Windows 7 machine, I have uninstalled all of the .NET Frameworks to force the MP install to install its minimum requirements. Everything ran exactly as expected with .NET 4.5 installed.

    So I don't think it's to do with the .NET Frameworks. Yet something is interfering with the access to the databases.

    Would you please send me a copy of your MediaPortalDirs.xml file?
     

    Anthony Vaughan

    MP Donator
  • Premium Supporter
  • June 25, 2015
    516
    281
    Home Country
    United Kingdom United Kingdom
    What I found sometimes is because if DEV machine, we install all DEV environnement.
    And, what we make is working on this PC.
    Therefore, pushing all files (.DLL, .exe, ....) in another PC without DEV environnement doesn't work.
    That why, if you can, maybe installing your change in MP 1.29 "production" machine could help to see if it works or not.
    I have run the procedure of installing MP 1.29, applying the BAT file in the refactor zip file, removing old database files, and then running MP, on six machines; four of which are production machines, one machine with Windows 7 installed and a development machine that I use to develop all of my code.

    I have been running the refactored version of MP in a production environment for about seven months :) . It has proven to be stable for me; and that is with up to four client machines running simultaneously against one set of client databases (because the whole point of my changes were to produce a multi-user version of MP1).

    I think I have proven that the system works. However, that is not to say that we won't hit set-ups that do not adhere to the norm and that is why I think it is so essential to test the refactored version thoroughly before it is rolled out.

    CyberSimian's set-up seems to have hit a problem immediately and, as yet, I have no idea why his set-up doesn't run properly.
     

    Anthony Vaughan

    MP Donator
  • Premium Supporter
  • June 25, 2015
    516
    281
    Home Country
    United Kingdom United Kingdom
    Attached is the version from my production system. (One disadvantage of a multiboot system is that the test partition is not accessible when the HTPC is in use. :( )
    All looks standard there.

    I'm out of ideas. I guess what we need is for someone with a standard set-up to give this a go to validate that the basic set-up is/or is not working.
     

    catavolt

    Design Group Manager
  • Team MediaPortal
  • August 13, 2007
    13,660
    9,861
    Königstein (Taunus)
    Home Country
    Germany Germany
    Just tried the refactoring: Result: Every copy command was answered with "Access denied" :oops:
    Maybe because I did not stop TVServer and/or I am using MariaDB as SQL-Server ;)
     

    CyberSimian

    Test Group
  • Team MediaPortal
  • June 10, 2013
    2,465
    1,488
    Southampton
    Home Country
    United Kingdom United Kingdom
    Every copy command was answered with "Access denied"
    I got that the first time that I tried installing the updates. The solution: you need to Run as Administrator.

    I also stopped TV Server before running the BAT file, and rebooted after. I am not sure that stopping TV Server is necessary, but it seemed to me to be a worthwhile precaution.

    -- from CyberSimian in the UK
     

    Users who are viewing this thread

    Similar threads

    Hi, must be really a while, cuz I can not remember any post from you ;) But might be also that I joined the team too late. Yes, there will be many things. Main reason is simply, that MP2 is not developed based on MP1. I for example never used MP1. I tried it lately to test voice control and was shocked about many inconsistancies in...
    Hi, must be really a while, cuz I can not remember any post from you ;) But might be also that I joined the team too late. Yes...
    It´s been a while... :) Well, simply the reason is cause MP1 was working so well... :) Now I decided to upgrade my old servers and...
    Replies
    1
    Views
    976
    MP1 MP2 To NAS or not? DE
    What would the best alternative be if this doesn't work fluidly?
    What would the best alternative be if this doesn't work fluidly?
    Recently my main SSD on my HTPC died, taking away the main OS and MP along with it. How I was using it was to store the media...
    Replies
    17
    Views
    930
    Then you didn’t use Nereus Skin in MP2. tMM does a great job in combination with MP2 it’s the best, if you ask me.
    Then you didn’t use Nereus Skin in MP2. tMM does a great job in combination with MP2 it’s the best, if you ask me.
    I have been a relatively happy user of MP1 for quite a while. My setup is a dedicated HTPC connected to my TV, a TV capture device...
    Replies
    8
    Views
    1K
    Ok, the importer also remembers the queue of items that are still needed to be processed in settings file. If there is something stuck, it will try again on next server start and probably stuck again. But removing the media source also removes the associated queue. The server's TV plugin automatically creates the media sources for...
    Ok, the importer also remembers the queue of items that are still needed to be processed in settings file. If there is something...
    Hi, I’ve been struggling with MP 2 now for several weeks. Initially all was fine. Then in the client, the listings of recorded TV...
    Replies
    8
    Views
    1K
    It is looking and working very well now and I am almost at the point of switching my HTPC to MP2, madvr would definitely push me over the edge for sure.;)
    It is looking and working very well now and I am almost at the point of switching my HTPC to MP2, madvr would definitely push me...
    We are proud to present MediaPortal 2.3 MediaPortal 2.3 is a full-blown media center software that addresses the most common user...
    Replies
    4
    Views
    4K
    Top Bottom