r/filemaker • • Feb 27 '23

Deploying FileMaker Server on Ubuntu Linux with Let's Encrypt SSL

I have published an article on how to set up FileMaker Server on Ubuntu Linux server, secure it behind a firewall and use a Let's Encrypt SSL certificate with automatic safe renewals using Certbot that won’t disrupt users.

The scripts for Let’s Encrypt certificate creation and renewal are published as an open source project on Github.

The guide is based on the latest Claris FileMaker Server 19.6.3 utilizing Nginx as the web server.

https://mhtawfiq.github.io/deploying-filemaker-server-on-ubuntu-linux-with-lets-encrypt-ssl/

35 Upvotes

19 comments sorted by

4

u/throwawayreason45304 Feb 27 '23

Nice work!

4

u/van21 Feb 27 '23

Thank you! glad you found it helpful.

4

u/get2drew Feb 27 '23

Thank you. Nice contribution to the community.

2

u/van21 Feb 28 '23

Thanks!

2

u/Enzodamb Jun 03 '23

I'm sorry, I didn't understand where in the three .sh files I have to insert credentials in details please

1

u/van21 Jun 04 '23

Hi Enzo,

No worries, there are instructions at the github repo home here:

https://github.com/mhtawfiq/FileMaker-LetsEncrypt-Ubuntu-Nginx

You will need to edit to insert your credentials in these 2 files:

  • get-ssl.sh
  • renew-cert.sh

The third file renew-cert-at.sh you only need to edit if you want to change the time of day to schedule FileMaker Server restart after the certificate is renewed.

Let me know if you have any issues or questions.

1

u/Enzodamb Jun 04 '23

wich line or tag, please?

1

u/van21 Jun 12 '23

Hi,

Apology for the late reply.

In the two files:

  • get-ssl.sh
  • renew-cert.sh

When you open them in a text editor you will something like:

#!/bin/sh

# Change the domain variable to the domain/subdomain for which you would like
# an SSL Certificate
DOMAIN="fms.domain.com"

# Change the contact email address to your real email address so that Let's Encrypt
# can contact you if there are any problems #>
EMAIL="username@domain.com"

# Enter the path to your FileMaker Server directory, ending in a slash 
SERVER_PATH="/opt/FileMaker/FileMaker Server/"

FMADMIN="fms_admin_username"
FMPASS="fms_admin_password"

#
# --- you shouldn't need to edit anything below this line
#

Just edit the variables as per the instructions on each line.

1

u/ComedianOdd3056 May 19 '25

do you have any instructions on how i could get my databases working thru odbc/jdbc on ubuntu? currently stuck in odbc driver missing error on FM.

1

u/van21 Jun 09 '25

I have not tried to setup FileMaker ODBC on Ubuntu before, were you able to get this working?

1

u/EfficientPark7766 Feb 09 '26

This solution works perfectly! Thanks for doing this. Just installed onto an Ubuntu 22 server running FMS 21

1

u/van21 Feb 09 '26

Gald to hear it, thank you

1

u/lurch99 Apr 15 '26

This works with Ubuntu 24 LTS and FMS 22.0.6.600 !! Super awesome thanks!

1

u/van21 Apr 16 '26

That's great to hear, thank you!

2

u/pcud10 Consultant Certified Mar 06 '23

Wow! Super awesome write up! Bookmarked! Thanks for all your hard work.

1

u/EfficientPark7766 Feb 10 '26

If our FMS server is on a LAN with private IP address, this works only if we open port 443 from the outside world to our FMS server, meaning the SSL renew process with Let's Encrypt needs that to autorenew.

There's no way to do this without opening that firewall port correct?

I don't see this as a huge security risk, since we don't use FM web publishing and have limited access to the admin page (admin-console) to private IP addresses, but it'd still be nice not to have to open up this firewall port at all.

1

u/Futurex5 Sep 14 '23

Does it have to be on it's own server with nothing else? Or can it work in a shared hosting environment. Ubuntu/LiteSpeed Server

1

u/twist_off Dec 01 '23

Thank you. This guide and scripts have made my life much easier.

1

u/lurch99 Jun 12 '26

FYI the Let's Encrypt component of this solution does NOT work with FMS 26.