OK – this is probably one of these ‘Doh’ questions but here goes …
I have PostgreSQL on a linux box (‘A’) along with the audio in a shared folder so that it will always be available. I have mAirList running on windows boxes (‘B’, ‘C’ etc) with the network database pointing to ‘A’.
I am trying to set up the storages on the database but have hit a problem. The audio is on ‘A’ so when trying to enter a folder using the ‘default location’ section of mAirListDB the drive references are with respect to ‘B’. I have tried using UNC names but must be doing something wrong as noting is found.
I would think this scenario is quite common so I must be mission something obvious - any pointers?
First of all, it doesn’t matter where the PostgreSQL server is running. In your scenario, it’s on the same server as the shared folders, but that doesn’t really matter.
In general, it should suffice to enter the UNC name (\server\somefolder) in the “default location” field (see attached screenshot). If the folder is accessible from all clients in your network, everything should be ok. Remember to restart mAirList/mAirListDB on all clients after you made changes to the storage location.
If you happen to keep a local, synchronized copy on any PC (some people do so to prevent playback trouble in case of network dropouts), you can enter that local folder in the configuration - mAirList will then read all files from that local folder instead of the shared folder on the server. If you don’t have such a local copy, leave the “local folder” field empty.
Thanks Torben
All sorted now - part of the problem was that the shared drive wanted a username and password which could not be passed.
We have got around that with a bit of bodgery but is the addition of username/password a possible enhancement to the manage storage section of the database?
Ron.
That’s not possible, because it’s not the job of the application to connect the network folder (there is no way to pass a username and password when opening a file from a shared folder). That must be done on OS level first.
True.
OK - thanks for the help with this.