Centralized Database; LAN?

Post a reply

Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:

BBCode is ON
[img] is ON
[url] is ON
Smilies are ON

Topic review
   

Expand view Topic review: Centralized Database; LAN?

Re: Centralized Database; LAN?

by Oldetowne » Mon Sep 07, 2015 9:52 am

Hard to believe that so many years have passed and this basic functionality has yet to be incorporated into the product. Being able to access the database from other systems is not even close to the multi-user interaction that is absolutely necessary in our modern shared computer environments. Note the dates on the forum entries. This thread began in 2006 and now, in 2015, nearly a decade later we still are no closer to a proper solution. Even MediaMonkey users who predominantly use clients to simply play music experience crashes due to the updating of usage information. Hopefully someone at MediaMonkey can locate a developer with the knowledge to provide a good solution, or the modern world may eclipse the capabilities of our, otherwise, much loved product.

Re: Centralized Database; LAN?

by dtsig » Sun Sep 06, 2015 8:44 am

Yes it is *shared* but it isn't multi user.

Re: Centralized Database; LAN?

by Jaspa » Sun Sep 06, 2015 3:04 am

I am using MM for many years, in a LAN. I move the MM.ini file to the folder <Program files> and add (in the system paragraph of the MM.INI file) following line:

[System]
DBName=z:\MediaMonkey\MM.db

of course, the drive letter is dependend of the LAN configuration.

Works flawlessly for all computers in the LAN.

HTH - Jan

Re: Centralized Database; LAN?

by Bello » Sun Aug 30, 2015 3:52 am

I would also prefere a mySQL database which is provided by most NAS systems.

Re: Centralized Database; LAN?

by dtsig » Sat Aug 29, 2015 7:15 am

Not being able to be shared IS the biggest problem with SqlLite. I personally think it does become a bit more unstable with large dbs (just me I know .. ). SqlServer would be nice but it would be nicer if using generic sql I could use the db of my choice. If i have mySql loaded .. why not allow that ..

Re: Centralized Database; LAN?

by CCS86 » Fri Aug 28, 2015 5:47 pm

I have been hoping for this forever!

Re: Centralized Database; LAN?

by Lowlander » Mon Aug 04, 2014 3:53 pm

ManMachine wrote:That's the scariest thing because if you say yes and the connection is back MM will replace your DB by a blank one (horror!!!)
That's not true, the old DB will still be there. Instead MediaMonkey will use a new blank DB in the default location. Just re-adding the DBName database redirect with MediaMonkey closed will resolve this. Also it asked to create a new DB and you've said yes to that.

SQLite doesn't work well in a shared environment, however this only is an issue if you need multiple write access to the database. If you only require read access from all but one PC you can use the Media Server instead to share your media. I use this setup to share my Library among PCs, smartphones and smartTVs/Blu-Ray and it works wonders. The only performance issue (SQL errrors) I run into has been written off to overly complex AutoPlaylists), but I'm still using my 11 year old DB. That's despite using many of the beta releases. Of course I do backup the database daily and also do weekly sequential backups. But that's what many do with important files on their PC.

Now I personally do hope they go for a better database provider for MediaMonkey 5, with my personal preference leaning to SQL Server.

Re: Centralized Database; LAN?

by ManMachine » Mon Aug 04, 2014 9:06 am

I really would like to have a more sophisticated way to have a centralized DB.

My DB is 5 years old and it always worked centralized. Every computer at home uses MM with centralized DB.

The current solution to centralize the DB requires a lot of patience due to performance and and connection errors. I can tell a lot about the difficulties on keeping my central database alive over all these years. Actually if it wasn't for the problems I have learned to overcome my DB would be even older.
Example: When the network connection fails MM produces SQL errors which in most of the cases result on having to kill MediaMonkey.exe with the task manager. Sometimes MM even proposes to create a new DB! That's the scariest thing because if you say yes and the connection is back MM will replace your DB by a blank one (horror!!!) That's what made me start again 5 years ago. I have implemented redundant backup systems for my DB. It's my biggest asset. The collection can be rebuild but not the listening history.
With a DB of that age I can program intelligent lists proposing least or most listened songs of my 80000 song collection. The statistics I can get are amazing.

by Peke » Mon Jan 23, 2006 8:55 am

I support that kind of idea, something similar I have managed with warious Plugins and Winamp ~5 ago Years over 10 Base-T LAN it is matter only on setting of Winamp Plugins LAN managment (WinGate at that timewith Per user access) and all worked Like a charm. Now With S-Ata Raid HDDs 1Gb Lan (100Mbit per client) everything can be made, only part That needs to be done is SQL <-> MM Lib calls needs to be made and all will work great Even searches all thru Burning from Filee server will be still tricky.

by task » Mon Jan 23, 2006 7:48 am

I see a better solution for an centralized database than working with
with hardcoded paths in an .ini-file.

My suggestion is to have an real Client/Server-solution like it is implemented in professional database applications.

For example:
1. The database is stored on the server.
2. On the Server a daemon (process) is running which has access to the
database and listens to a specific tcp/ip-Port on the network.
3. On the Client, mediamonkey is startet and makes a connection to the
server-daemon (over the tcp/ip-port from the server).
4. Now the client gets all the information it needs from the server, including
the music-files (could be the same port or a different).

The client-modul (Mediamonkey) could also be startet at the server.
This is needed if you have only one system. The communication over the
port will be the same.

Additionally this could be expanded by:
A. Userspecific configurations:
The user has to authorize in the mediamonkey-db when he starts
the client-modul. That means you have to specify a username/password
and the ip-address/portnummer of your db-server.
Then you get your userspecific view to the database including
your playlists and setups which are stored in the database.
This will also work over internet!!!
B. Configuration whether to use the local (client) soundcard or the
remote (server) soundcard.

think about this for discussion. This is not new. I used a similiar system for
some years ( www.andantico.de). Unfortunately there is no further
development any more so I decided to go for Mediamonkey.
It has also a working prelisten-funtionality.

One thing will possibly not be available, that is the connection to winamp
including all the winamp-plugins. But maybee there could be written a
special mediamonkey-winamp-interface.

by Teknojnky » Mon Jan 16, 2006 2:38 pm

pierre wrote:Anyway, it is still not sufficient for a completely shared library, because when a MM instance updates the DB, the other one(s) have to be aware of the update. So I agree : would be great to have it implemented !
Watched folders works well for this. I've modified the library/files from remote computers while having MM open on a different computer (using a network shared installation/library) and it works fine for me.

by pierre » Mon Jan 16, 2006 9:27 am

m_bojangles: There's probably no need to use Access... Have you tried auto-organize (Ctrl-R) of the files ? There are special <Folder> and <Path> fields that might help you in this case : try a mask like

Code: Select all

\\ServerName\<Path>
You can also use <Path:2> if you don't want to include the 2 first folders of your path... See MM help !

Anyway, it is still not sufficient for a completely shared library, because when a MM instance updates the DB, the other one(s) have to be aware of the update. So I agree : would be great to have it implemented !

by m_bojangles » Sat Jan 14, 2006 12:55 am

I really want to do this so that I can access, listen to and synch music on both the upstairs PC (where my wife's Zen Micro is) and my downstairs PC (where my Archos is). Trouble is... I've been using MM for years, have 30,000 tracks and can't afford to lose my playcounts, ratings, datestamp for adding to the library (my backup scheme is based off of this) and other metadata. So can the paths be updated via a direct Update query in MS Access?

by m_bojangles » Sat Jan 14, 2006 12:23 am

I really want to do this so that I can access, listen to and synch music on both the upstairs PC (where my wife's Zen Micro is) and my downstairs PC (where my Archos is). Trouble is... I've been using MM for years, have 30,000 tracks and can't afford to lose my playcounts, ratings, datestamp for adding to the library (my backup scheme is based off of this) and other metadata. So can the paths be updated via a direct Update query in MS Access?

by Balinsky » Thu Jan 12, 2006 5:13 pm

My database is on my Lan as well if your tracks are inaccesible you just have to rescan them using the network location for the files as well.

Yes you will lose all your play count and such. But If I am right you are new so it shouldn't be that bad. It made me mad when I had to do it as well.

Top