Serverless TV Server possible? (1 Viewer)

[mapstae]

Hi team,

I would like to avoid installing a full blown DB server (either MS or MySQL) just to have TV Server running.
Is it possible to setup/configure/hack TV Server in some manner to make it use a serverless DB, like a Jet/MSAccess or SQLite? Maybe an experimental version?

Thanks!

 

[mm1352000]

Hello mapstae

The DB is a pretty important part of TV Server. After all, it stores your channels, schedules, EPG info, and 99% of the settings.
The Gentle.NET DB access framework that we use does support other DB engines, but I've never seen them used and we don't provide support for them. If you are technical and have the time to look into it, you could try investigating that option. Otherwise I recommend you go for SQL Server compact or express.

mm

 

[mapstae]

Got TVService working using SQLite ... on Windows 8 x64
This is what I did:

- Install MP TV Server as normal.

- Close DB config window (MSSQL/MySQL choice) when opened.

- Do not run configuration at the end of setup wizard.

- Copy the following files to "%ProgramFiles%\Team MediaPortal\MediaPortal TV Server" (or "%ProgramFiles(x86)%\Team MediaPortal\MediaPortal TV Server" for x64):
- Gentle.Provider.SQLite.dll -> http://sourceforge.net/projects/gopf/files/Gentle.NET/1.5.0/Gentle-1.5.0.zip/download
- System.Data.SQLite.dll -> http://sourceforge.net/projects/gopf/files/Gentle.NET/1.5.0/Gentle-1.5.0.zip/download
- sqlite3.dll -> http://www.sqlite.org/sqlite-dll-win32-x86-3071300.zip

- Copy empty SQLite-format DB to "%ProgramData%\Team MediaPortal\MediaPortal TV Server".
This was created importing one clean DB from MSSQL using SQLite2009 Pro Enterprise Manager (http://osenxpsuite.net) from a VM where I installed TV Server over MSSQL as normal.

- Add SQLite provider assembly to TVService.exe.config and SetupTV.exe.config at %ProgramData%\Team MediaPortal\MediaPortal TV Server:
<dependentAssembly>
<assemblyIdentity name="Gentle.Provider.SQLite"
publicKeyToken="80b5de62e27be49b"
culture="neutral" />
<bindingRedirect oldVersion="1.5.0.29053-1.5.0.29111" newVersion="1.5.0.29087" />
</dependentAssembly>

- Change the default provider to SQLite in "%ProgramData%\Team MediaPortal\MediaPortal TV Server\Gentle.config" and point it to DB3 location, as follows:
<DefaultProvider name="SQLite" connectionString="Data Source=C:\ProgramData\Team MediaPortal\MediaPortal TV Server\MpTvDb.db3;Pooling=true;FailIfMissing=true" />

- Uncomment SQLite provider in "%ProgramData%\Team MediaPortal\MediaPortal TV Server\Gentle.config":
<Providers>
<Provider name="SQLite" assembly="Gentle.Provider.SQLite" />
</Providers>

- Load DB in your favorite SQLite administration tool (ie. SQLite2009 Pro Enterprise Manager (http://osenxpsuite.net)) and change the server name (from my VM) with the computer name in table "Server". Otherwise the following error was being logged:
2012-08-31 18:44:55.640247 [TVService(6)]: Controller: sorry, master/slave server setups are not supported. Since there is already another server in the db, we exit here.


After all this, TVService runs well, without errors in \log folder.
However, TV-Server Configuration tool still prompts for MSSQL/MySQL configuration.
It may be looking to some hint to decide that DB is not configured.
Ideas?

Thanks!

 

[mapstae]

I am also interested in SQL Server Compact Edition. How can I setup this?

 

[cnicolas]

However, TV-Server Configuration tool still prompts for MSSQL/MySQL configuration.

I have the same problem.

I could be nice if anyone have a patch / workaround.

Thanks