Reply to thread

Message

<blockquote data-quote="regeszter" data-source="post: 1123787" data-attributes="member: 15874">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?<ul>
<li data-xf-list-type="ul">The installer won't install a (new) MySQL server but you can use the existing MySQL instance of the TvServer if exists.</li>
<li data-xf-list-type="ul">The switching of the SQLite database or the MySQL database is &quot;hidden&quot;. The default is the SQLite. Hidden means no GUI to set it up. 
</li>
<li data-xf-list-type="ul">The MS SQL Server is not supported.</li>
<li data-xf-list-type="ul">Any plugin may not work in this new database environment. If you find any incompatible plugin, please share with us.</li>
</ul>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]&nbsp; &lt;section name=&quot;folderdatabase&quot;&gt;&nbsp; &nbsp; &lt;entry name=&quot;UseADO&quot;&gt;yes&lt;/entry&gt;&nbsp; &lt;/section&gt;&nbsp; &lt;section name=&quot;moviedatabase&quot;&gt;&nbsp; &nbsp; &lt;entry name=&quot;UseADO&quot;&gt;yes&lt;/entry&gt;&nbsp; &lt;/section&gt;&nbsp; &lt;section name=&quot;picturedatabase&quot;&gt;&nbsp; &nbsp; &lt;entry name=&quot;UseADO&quot;&gt;yes&lt;/entry&gt;&nbsp; &lt;/section&gt;[/code]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]&nbsp; &lt;section name=&quot;mpdatabase&quot;&gt;&nbsp; &nbsp; &lt;entry name=&quot;hostname&quot;&gt;localhost&lt;/entry&gt;&nbsp; &nbsp; &lt;entry name=&quot;username&quot;&gt;root&lt;/entry&gt;&nbsp; &nbsp; &lt;entry name=&quot;password&quot;&gt;MediaPortal&lt;/entry&gt;&nbsp; &lt;/section&gt;[/code]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<ul>
<li data-xf-list-type="ul">Little speed improvement 
</li>
<li data-xf-list-type="ul">Wake On Lan feature for database host</li>
<li data-xf-list-type="ul">Bugfixes</li>
<li data-xf-list-type="ul">Based on 1.11 Final</li>
<li data-xf-list-type="ul">Need new databases!</li>
</ul>MediaPortalSetup_1.11.0_2015-04-03-16-34<ul>
<li data-xf-list-type="ul">Bugfixes</li>
</ul>MediaPortalSetup_1.11.0_2015-04-11-08-56<ul>
<li data-xf-list-type="ul">Bugfixes</li>
</ul>This branch is OBSOLETED. The updated code is <a href="https://forum.team-mediaportal.com/threads/regeszters-mepo.121967/#post-1030437" target="_blank">here</a>.Do not forget upload logs (TvServer and client logs) if you report any issue.Regards,regeszter</blockquote>

[QUOTE="regeszter, post: 1123787, member: 15874"] Hi Community, I am working on a centralised database to better support the multi seat configurations. [U]What is the benefit?[/U] 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. [U]What are the limitations?[/U] [LIST] [*]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. [/LIST] [U]How can you activate it?[/U] 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] <section name="folderdatabase"> <entry name="UseADO">yes</entry> </section> <section name="moviedatabase"> <entry name="UseADO">yes</entry> </section> <section name="picturedatabase"> <entry name="UseADO">yes</entry> </section>[/code] 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] <section name="mpdatabase"> <entry name="hostname">localhost</entry> <entry name="username">root</entry> <entry name="password">MediaPortal</entry> </section>[/code] 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. [B][COLOR=#ff0000]Attention!!!! (Read this if you have an older version than MediaPortalSetup_1.11.0_2015-03-21-19-38)[/COLOR][/B] 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 [LIST] [*]Little speed improvement [*]Wake On Lan feature for database host [*]Bugfixes [*]Based on 1.11 Final [*]Need new databases! [/LIST] MediaPortalSetup_1.11.0_2015-04-03-16-34 [LIST] [*]Bugfixes [/LIST] MediaPortalSetup_1.11.0_2015-04-11-08-56 [LIST] [*]Bugfixes [/LIST] [SIZE=5][COLOR=#ff0000]This branch is OBSOLETED. The updated code is [URL='https://forum.team-mediaportal.com/threads/regeszters-mepo.121967/#post-1030437']here[/URL].[/COLOR][/SIZE] Do not forget upload logs (TvServer and client logs) if you report any issue. Regards, regeszter [/QUOTE]

Verification