Setting up FileMaker Pro Server on a new Mac Mini, running OS X Mavericks, I wanted to add a Scheduled Backup of the Server databases to go to a Dropbox folder. The idea was to add another level of backup that was offsite in the event of fire or theft of the server hardware.
Problems with Backup Path Validity in FileMaker Server 13
In the FileMaker Server Admin Console,
1) Click on Schedules
2) Add a new schedule by clicking the small calendar icon
3) Select your databases to back up, then click ‘Next’.
4) The second screen you will see is where you set the path to where you want the databases saved. In this case, I am aiming for a folder called ‘FileMaker-Database-Backup’ inside of Dropbox.
5) Enter the Backup Folder Path
6) Click Validate
7) Check Status — It should read ‘Valid Path’
Instead, my Status read “Not a Valid Path”.
According to FileMaker’s Help, setting up an alternate path should be easy.
Defining a backup folder path
In the left pane of the Admin Console, under the ‘Configuration’ section, you see a ‘Database Server’ option. Select this and in the right pane should display the Database Server configuration panel. Click the “Default Folders” tab and you will see a “Backup Folder” section below the “Database Folders” section. By default, backups will be saved to the “Backups” folder in the FileMaker Server installation path. If you want to change the location of where backups are saved, type a valid path into the “Path:” field, in accordance with the syntax example shown just below that field.
I tried entering the path to Dropbox, but each time I clicked ‘ Validate’, I received the message ‘Not a Valid Path’. I asked another developer if he had encountered this and he suggested that Symbolic Links were the solution. Apparently, I could add a Symbolic Link referencing the Dropbox folder to the Backups folder and then add it to the Path and Validate.
I attempted to get Symbolic Links working. Symbol Links are a kind of alias or shortcut with super Unix powers. Unfortunately Terminal is required to create these links and my Terminal skills are somewhere between rusty and nonexistent. It took me twenty minutes to figure out how the ‘cd’ (change directory) command worked in Terminal again — it has been a long time since I used it. Anyway, I took another 15 minutes on creating a Symbolic Link.
Finally I came up with this:
ln -s /Users/USERNAMEGOESHERE/Dropbox/ Dropbox
The link seemed to be created (an icon for the link appeared in my Backup Directory), but my path validation to this shortcut still failed in the FileMaker Server Admin Console.
It occurred to me that the Path validity issue might have something to do with Permissions, because I have had instances where I upload a database to FileMaker Server and although it is viewable, when I tried to add records, I get ‘Database is locked’ messages. The solution to this locked database issue, is to Close the file on FileMaker Server and do a ‘Get Info’ on the file and set the permissions to allow Read & Write.
The Solution: Change the Privileges on the Dropbox Folder
I decided to experiment with changing the permissions on the DropBox folders.
Select Dropbox folder
To do this, I located the Dropbox folder in the Home directory of the FileMaker Server computer. The Home directory is the one with the little house icon in the sidebar.
I clicked on the Dropbox folder and then selected ‘Get Info’ from the ‘File’ menu. (Command I)
Add fmserver to Privilege List
If the user ‘fmserver’ is not in the Sharing and Permissions list, click the small plus sign icon to add it.
1) Add a user by clicking the small plus sign, bottom left
2) Select User
3) Click Select to confirm.
Set Read & Write Privileges
Now set the privileges for fmserver from Read Only to Read & Write by clicking on the small up/down arrows next to the User’s Privilege.
Now go back to your Path and try Validating. Note that I had to do the same Get Info and assign privileges to the Folder ‘FileMaker-Database-Backup’ inside the Dropbox folder that was my ultimate destination. Your path should Validate now.
Dropbox backups running successfully
In hindsight, if I had read the FileMaker Help files more thoroughly, I might have caught this line:
Tips for specifying a valid path:
Ensure that the folder has permissions set correctly so that FileMaker Server can read and write to the folder.
The permissions issue for backup paths depends on your initial setup of FileMaker Server. fmserver is the default user, but it is possible to set it to the same user as your login. If you do that, you may not encounter these path setting problems.