[WiP] - Centralised database in My Video, My Pictures and folder settings

Discussion in 'Area 51 - Testing Area' started by regeszter, February 6, 2015.

  1. regeszter
    • Premium Supporter

    regeszter Retired Team Member

    Joined:
    October 29, 2005
    Messages:
    5,335
    Likes Received:
    2,863
    Ratings:
    +5,152 / 18
    Home Country:
    Hungary Hungary
    Hi Community,

    I am working on a centralised database to better support the multi seat configurations.

    What is the benefit?

    If you have more then one clients, you will see the same picture and video database on all clients without needs any external plugin to synchronise it.

    What are the limitations?

    • The installer won't install a (new) MySQL server but you can use the existing MySQL instance of the TvServer if exists.
    • The switching of the SQLite database or the MySQL database is "hidden". The default is the SQLite. Hidden means no GUI to set it up.
    • The MS SQL Server is not supported.
    • Any plugin may not work in this new database environment. If you find any incompatible plugin, please share with us.
    How can you activate it?

    There is no GUI to switch the database backend yet but you can insert this rows to c:\ProgramData\Team MediaPortal\MediaPortal\MediaPortal.xml.

    Code (Text):
    1.   <section name="folderdatabase">
    2.     <entry name="UseADO">yes</entry>
    3.   </section>
    4.   <section name="moviedatabase">
    5.     <entry name="UseADO">yes</entry>
    6.   </section>
    7.   <section name="picturedatabase">
    8.     <entry name="UseADO">yes</entry>
    9.   </section>
    If you want to use a different MySQL server from TvServer, you have to add this section to the config. The values are samples of course.

    Code (Text):
    1.   <section name="mpdatabase">
    2.     <entry name="hostname">localhost</entry>
    3.     <entry name="username">root</entry>
    4.     <entry name="password">MediaPortal</entry>
    5.   </section>
    The folderdatabase holds your layout and sort settings in My Video, My Pictures and My Music plugins.
    The moviedatabase holds your video database and watched status in My Video plugin.
    The picturedatabase holds your picture database in My Pictures plugin. You use it when you select date view.

    After you switch the database backend, the Configure.exe or the MediaPortal.exe will create an empty database on first start. The old database files will be untouched so you can use it later if you reinstall the official release.



    There is not automatic database migration between the SQLite and the MySQL database but you can create NFO files from the movies before switch the database backend and import they after switch it. Or you can use the IMDB scatter of course.


    Attention!!!! (Read this if you have an older version than MediaPortalSetup_1.11.0_2015-03-21-19-38)

    The new versions requires new database because of the old one was created with wrong characters/collation. Do not install it without drop the old databases! The installer wont drop the databases. You need to do that. Sorry.



    Change log:

    MediaPortalSetup_1.11.0_2015-03-21-19-38
    • Little speed improvement
    • Wake On Lan feature for database host
    • Bugfixes
    • Based on 1.11 Final
    • Need new databases!

    MediaPortalSetup_1.11.0_2015-04-03-16-34
    • Bugfixes

    MediaPortalSetup_1.11.0_2015-04-11-08-56
    • Bugfixes

    This branch is OBSOLETED. The updated code is here.

    Do not forget upload logs (TvServer and client logs) if you report any issue.

    Regards,
    regeszter
     
    Last edited: April 18, 2016
    • Like Like x 5
    • Thank You! Thank You! x 4
    • Great Idea! Great Idea! x 2
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. Edalex
    • Premium Supporter

    Edalex Community Plugin Dev

    Joined:
    January 3, 2008
    Messages:
    2,908
    Likes Received:
    713
    Gender:
    Male
    Location:
    Saratov
    Ratings:
    +1,229 / 9
    Home Country:
    Russian Federation Russian Federation
    Show System Specs
    That should be done long time ago.
    Also we need MySQL version of MovPics and MPTVSeries :oops:
     
    • Agree Agree x 4
  4. regeszter
    • Premium Supporter

    regeszter Retired Team Member

    Joined:
    October 29, 2005
    Messages:
    5,335
    Likes Received:
    2,863
    Ratings:
    +5,152 / 18
    Home Country:
    Hungary Hungary
    @ltfearme ,

    It is possible to do the same in MovingPictures and MPTVSeries? ;)
     
    • Agree Agree x 2
  5. HTPCSourcer
    • Team MediaPortal
    • Administrator

    HTPCSourcer MP2 Product Manager

    Joined:
    May 16, 2008
    Messages:
    10,770
    Likes Received:
    1,125
    Gender:
    Male
    Ratings:
    +2,408 / 22
    Home Country:
    Germany Germany
    Show System Specs
    Well, then unfortunately one potential user less :(

    I am using MS SQL because of a WSUS server on my WS 2012 E installation, which requires it by default. Not much sense to have another database in parallel...
     
  6. Edalex
    • Premium Supporter

    Edalex Community Plugin Dev

    Joined:
    January 3, 2008
    Messages:
    2,908
    Likes Received:
    713
    Gender:
    Male
    Location:
    Saratov
    Ratings:
    +1,229 / 9
    Home Country:
    Russian Federation Russian Federation
    Show System Specs
    • Thank You! Thank You! x 1
  7. regeszter
    • Premium Supporter

    regeszter Retired Team Member

    Joined:
    October 29, 2005
    Messages:
    5,335
    Likes Received:
    2,863
    Ratings:
    +5,152 / 18
    Home Country:
    Hungary Hungary
    I agree with you but most users use the MySQL which installing with TvServer by default.
     
  8. HTPCSourcer
    • Team MediaPortal
    • Administrator

    HTPCSourcer MP2 Product Manager

    Joined:
    May 16, 2008
    Messages:
    10,770
    Likes Received:
    1,125
    Gender:
    Male
    Ratings:
    +2,408 / 22
    Home Country:
    Germany Germany
    Show System Specs
    In reference to comments made in the MP2 section: Have you guys thought redirecting your efforts towards MP2 in order to speed up its development so that it could (not just eventually but soon) replace MP1?

    My personal feeling is that all the effort made to develop workarounds for design limitations of MP1 would be better spent on MP2, which offers numerous advantages over MP1.
     
  9. regeszter
    • Premium Supporter

    regeszter Retired Team Member

    Joined:
    October 29, 2005
    Messages:
    5,335
    Likes Received:
    2,863
    Ratings:
    +5,152 / 18
    Home Country:
    Hungary Hungary
    I am not planning to leave MP1. It is a hobby. :)
     
    • Like Like x 3
  10. Edalex
    • Premium Supporter

    Edalex Community Plugin Dev

    Joined:
    January 3, 2008
    Messages:
    2,908
    Likes Received:
    713
    Gender:
    Male
    Location:
    Saratov
    Ratings:
    +1,229 / 9
    Home Country:
    Russian Federation Russian Federation
    Show System Specs
    Me neither. MP1 does all what i want..almost. Which it doesnt do Im coding myself
     
    • Agree Agree x 2
    • Like Like x 1
  11. ltfearme
    • Premium Supporter

    ltfearme Community Plugin Dev

    Joined:
    June 10, 2007
    Messages:
    6,556
    Likes Received:
    4,416
    Gender:
    Male
    Occupation:
    Software Test Engineer
    Location:
    Sydney
    Ratings:
    +5,632 / 0
    Home Country:
    Australia Australia
    Anything is possible, why don't you announce your feature in the respective plugin forum, you may get the interest of another dev that would like to add support.

    I would not need such a feature even with 4 pcs in the same house so it's unlikely I would look at doing it anytime soon, there is just so many other features I would like to see first.

    Thanks for your work ;)
     
    • Thank You! Thank You! x 3
    • Like Like x 1
    • Agree Agree x 1
Loading...

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!