More Databases on server (1 Viewer)

[UrbanSK]

Hi all,

I´am new to Mediaportal and just recently moved from gbPVR.

The reasong for me to move to Mediaportal was the doscovery of TvEngine.

I like the idee of a client/server aproach.

My suggestion for improvement.

Add more support for UNC paths and databases on the server.

This for sharing musik and divx movies.

Imagine the following setup:

Tvserver for recording TV programs
NAS storing my MP3s
NAS for storing my DivX movies
2 clients

Having support for UNC paths and having the media databases on the server would make this possible.

The if you save the client settings on the server setting up a new client would be easy.

Specify the DB connection and load an existing default client profile from the server.

It will take me a while to get basic knowledge of C# but sooner or later i will provide som utilities to this project.

Keep up the good work.

 

[onkl]

Just as a short note, I believe there was a plugin which let you choose a custom location for your databases. (I thought this was done from a multi-user on a single PC perspective.) Don't know if this plugin is still available, but it might be worth checking the repository for code.

 

[elliottmc]

Hi,

I would strongly support this proposal.

I have all my files stored on one central server, and access them from 3 computers. It's a pain to have to do the IMDB searches on all of the computers, and to have to do it again every time I reinstall MP or move the files (change the network location or whatever).

To have a database in the top level of each shared folder which has the music/video/tv database for that share would be a huge improvement, and should not be too difficult.

I'd do it myself if there was

(a) a general consensus that it is the right way to go
(b) I wasn't certain I'd make a mess of it and do more harm than good

Best wishes,

Mark

 

[HappyTalk]

copy MediaPortalDirs.xml (from mediaportal root folder) to ..\MyDocuments\Team MediaPortal\

Then edit this new file and change the database path so all machines point to the same version (via a share) on the main server. You can also share thumbs and other folders in this way. This one in MyDocs file will override the one in MP root folder so even when you update MP these paths & files will remain (assuming db structure doesn't change) (rtv told me about this)

 

[Sh4nn0w]

What i've been doing on my main server/client is to add files to the databases as follows:

\\192.168.x.x\Films\xyz.avi
\\192.168.x.x\Audio\xyz.mp3

etc, etc. And to setup paths to these shares in the format above e.g. \\192.169.x.x\Films

Then I just copy over the thumbs and database files if I do any updates onto the clients.

But now I think I'll give HappyTalk's idea a go.

 

[elliottmc]

Thanks to you both for the suggestions.

I had previously tried copying the database files themselves from one computer to another, and this didn't work, even though the network paths to the files on the server were all fine.

Maybe the best way to do this is to set up a share on the server to store the databases, as per the suggestion. I will do this at the weekend and report back.

Mark

 

[UrbanSK]

Hi All!

I think alla of your suggestion sounds good but they aren´t they all just workarounds?

I think i need to clarify my improvement suggestion.

1. Use the existing SQL Express installation used for TV Server(Engine)
2. Put the Client configuration in a database(SQL Express) and also where the shared data (MP3s, DivX movies,icons, etc) are stored.


As we allready have a transactional DB in place wy not make use of it.
Putting the SQLite DB on a share will surely work but i think using SQL Express would be a better sollution in the future.

I have also seen work in progress using MY Sql instead of SQL Express.
That also looks promising.

Urban

 

[hwahrmann]

Urban,

please note that the new TV Engine is not fully released yet.
All devs working for other parts are looking what experience we get with using SQL Excpress.
Soon or later all database access will be migrated away from sqlite.
but as we all are working on our free time on it,, it may take time.
And to be honest, it hasn't top priority.

regards,

Helmut