Database Location

General discussion about Universal Media Server (no support or requests)
dtmoc
Posts: 6
Joined: Sat May 26, 2018 1:37 am

Database Location

Post by dtmoc »

I did a quick search and checked in app as well but could not find anything on this...

Is there a way to relocate the UMS Database?
It is currently consuming almost 13GB on the system drive and I'd like to relocate it to free up space.

Thanks!!
User avatar
SubJunk
Lead Developer
Posts: 3705
Joined: Sun May 27, 2012 4:12 pm

Re: Database Location

Post by SubJunk »

Yes, if you are on Windows you can select "Universal Media Server (Select Profile)" from the Start Menu and choose where you want
dtmoc
Posts: 6
Joined: Sat May 26, 2018 1:37 am

Re: [Solved] Database Location

Post by dtmoc »

Hi SubJunk,

Not what I would call "intuitive" LOL.
But thanks!

I changed the location with a new profile.
Also, new DB is only 500 MB, not 12,000 MB.
I'm sure it will grow over time - but that will be OK in its new "home".

Only issue...
Lots of 503 errors as it tried (failed) to get album graphics.

dtmoc
dtmoc
Posts: 6
Joined: Sat May 26, 2018 1:37 am

Re: [Solved] Database Location

Post by dtmoc »

Well - since moving the files and using the Start menu option to select new profile location, UMS keeps rebuilding it's database in the original HDD-C path (C:\ProgramData\UMS). In the startup info it does show the correct "new" path for the .conf file.

The change does not seem to stick and the database consumes just under 15GB each time, consuming all space on the - intentionally smaller - system drive.

See excerpt from log at startup of UMS...
Temp/Working directories remain on HDD-C
Profile and contents of .conf point to HDD-F
But none of these paths implicate the "space hog database" which gets continually rebuilt at C:\ProgramData\UMS

10:35:51 INFO Working directory: C:\Program Files (x86)\Universal Media Server
10:35:51 INFO Temporary directory: C:\Users\ADMINI~1\AppData\Local\Temp\1\UMS
10:35:51 INFO Logging configuration file: C:\Program Files (x86)\Universal Media Server\logback.xml
10:35:51 INFO Logfile: F:\UMS Profile\debug.log
10:35:51 INFO
10:35:51 INFO Profile directory: F:\UMS Profile
10:35:51 INFO Profile directory permissions: drwx
10:35:51 INFO Profile configuration file: F:\UMS Profile\UMS.conf
10:35:51 INFO Profile configuration file permissions: -rwx
10:35:51 INFO Profile name: C2D-2530-01S
10:35:51 INFO
10:35:51 INFO Web configuration file: F:\UMS Profile\WEB.conf
10:35:51 WARN Web configuration file not found: File "F:\UMS Profile\WEB.conf" not found
10:35:51 INFO


Any other suggestions?
UMS is Windows v 7.0.1
User avatar
SubJunk
Lead Developer
Posts: 3705
Joined: Sun May 27, 2012 4:12 pm

Re: [Solved] Database Location

Post by SubJunk »

Please provide full TRACE logs and I'll look into it
dtmoc
Posts: 6
Joined: Sat May 26, 2018 1:37 am

Re: Database Location

Post by dtmoc »

Thanks for you response.
I was able to "fix" it.

Not sure if it is the "correct" way but it seems to be working.

Within the Application Menu there are a number of options but these two were the initial focus...
1) Universal Media Server
2) Universal Media Server (Select Profile)

From setup UMS installed itself in the Startup folder using (1) and when UMS started this way it seemed to "reset" and place all files back on the default paths. I found that when I used the (2) option it would ask me for the db location and it did not have an issue - so I looked further into that.

I ended up creating a program shortcut as follows...
[ "C:\Program Files (x86)\Universal Media Server\UMS.exe" profile="F:\UMS Profile" ] that "starts from" [ "F:\UMS Profile" ]
and named it "StartMyUMS". (of course the entries above do not contain the square brackets)

This I then placed in my start menu (for convenience and replaced the link to (1) with my shortcut.
My HDD-C has remained happy and UMS runs as it should.
theceo
Posts: 4
Joined: Tue Jul 03, 2018 10:00 pm

Re: Database Location

Post by theceo »

I think you can do this changing server location is not a big deal
dtmoc
Posts: 6
Joined: Sat May 26, 2018 1:37 am

Re: Database Location

Post by dtmoc »

I agree! No problem.
May help for it to be easier in the future sometime!

Thanks for your posts.
theceo
Posts: 4
Joined: Tue Jul 03, 2018 10:00 pm

Re: Database Location

Post by theceo »

I agree with subjunk
dtmoc
Posts: 6
Joined: Sat May 26, 2018 1:37 am

Re: Database Location

Post by dtmoc »

theceo

Not sure what you're "agreeing" with...

But if it's the first statement made by subjunk - it will only work with a manual start of UMS using the start menu item for selecting a profile and then navigating to the correct location to choose it. But when using the default installation of UMS - and no edits are made as I mentioned above - any reboot will simply use the default database location again. Of course you could shutdown UMS after a system restart and start it manually using the option to select a profile but that is pointless if you want to be sure UMS is available for streaming.
Post Reply