File Structure
The FileMaker Server instance is hosted on a DigitalOcean droplet running Ubuntu 22.04 LTS. The droplet is configured with a 250GB storage volume that is attached to the FileMaker Server.
The following sections describe the file structure of the FileMaker Server.
Home Directory /home/prime
All of the FileMaker related documents have been stored in a several folders with a naming convention of fms-<purpose>. The following folders
are currently in use:
Shell Scripts Folder fms-scripts
This folder contains all of the scripts that are used to manage the FileMaker Server. The following scripts are available for use:
Clone and Open a FileMaker Database clone-db-and-open.sh
This script is used to clone a database and open it. This script is used by the Web CRM to quickly provision testing environments.
Remove a FileMaker Database remove-db.sh
This script is used to remove a database from the FileMaker Server. This script is used by the Web CRM to quickly remove testing environments.
SSL Scripts fms-ssl
This folder contains the scripts that are used to automatically renew FileMaker Server's SSL certificate. Certbot is configured to automatically renew the SSL certificate for the FileMaker CRM every three months. This process does not require any manual intervention. If an issue arises with the automatic renewal process, you can use the following instructions to manually obtain or renew the SSL certificate: https://docs.primehomesolutions.com/filemaker-crm/Development/ssl-certificate
Supplemental Storage /mnt/volume_sfo3_01
volume_sfo3_01 is a 250GB storage volume that is attached to the FileMaker Server. This volume is used to
store all of the large files that are used by the FileMaker Server.
The following folders are located on this volume:
FileMaker Databases fms-databases
This folder is where all of the live databases (.fmp12 files) are located. Files in this folder appear under the Databases tab
of the FileMaker admin console.
Any files that are located under this tab MUST have the proper access privileges. FileMaker server expects the files/directories to have the fmserver user and fmsadmin group assigned to them.
FileMaker Backups fms-backups
This folder contains all backups created by the FileMaker Server. There are two types of backups kept in this folder:
Full Server Backups
Full server backups are created once daily. They include a backup of each active .fmp12 database and include a backup
of the FileMaker Server config called backup.config.
Full server backups have the following naming convention: FMS_2023-07-21_0000
Database Backups
Database backups are created on intervals defined in the Backup Schedules tab of the FileMaker Server. These
are individual backups of the .fmp12 databases.
Database backups have the following naming convention: Backup - Hourly_2023-07-21_1200
FileMaker Clones fms-clones
This folder contains all clones created by the FileMaker Server. For organizational purposes, I have chosen to keep
this folder separate from the fms-backups folder.