GC

Subcontractor

Field Service

Home Builder

Manufacturing

Custom Solutions

 

DocuWrx

844-DOCUWRX

DocuWrx is a premiere FileMaker developer. Our flagship solution, Kosmas, is an end-to-end vertical market solution for the construction industry. DocuWrx also creates first class custom business solutions for many different industries including hospitality, retail, property management, healthcare, manufacturing, and many more. If you are looking for a custom solution for for your business or are interested in Kosmas, inquire below.

Custom Kosmas

Installing SSL Certificates for Filemaker Server

Installing SSL Certificates for Filemaker Server Using GoDaddy or Similar Domain Registrar or Domain Hosting Company on OS X 10.9 Mavericks

You need to have CSR before you request SSL Certificate.

Requesting CSR

In order to generate your CSR file, you need to make sure that you have the privilege to write on /Library/FileMaker Server/CStore. To do that:

  1. Go to /Library/FileMaker Server/CStore.
  2. Right click on an empty field and click Get Info.
  3. On the Sharing & Permissions tab, look to see that the user you’re using has privilege to Read & Write. If this is not true:
    1. Check the lock icon on the bottom right. If it is locked, click the icon to unlock it.
    2. Enter the admin username and password.
    3. Click on privilege field next to your username, and choose Read & Write from the dropdown box.
    4. Click on the lock icon again to lock it.

Now we have to go to Terminal to generate CSR.

  1. Go to Terminal.
  2. type fmsadmin certificate create server_name (server_name can be whatever you want, but it has to match with the url of your site.

Sample command: fmsadmin certificate create company.docuwrx.com

If there are no error messages popping up in your terminal and you are just directed to next command line, everything is good.

For GoDaddy, we have to use the text inside CSR we just generated to request SSL Certificate instead of using the actual file.

  1. Go to /Library/FileMaker Server/CStore and right click on serverRequest.pem.
  2. Hover your mouse over Open With and select Other.
  3. On the Enable drop-down list, select change Recommended Applications to All Applications.
  4. Select TextEdit and click Open.
  5. Copy the whole text from TextEdit. We will use this later.

Next, go to GoDaddy or other domain hosting website that offers SSL Certificates. Although I have only listed what you need to do in GoDaddy, the steps for requesting SSL certificates should be similar even if you did not choose to use GoDaddy.

Requesting SSL Certificate from GoDaddy.com

  1. Log in to your account.
  2. Check if you have purchased a SSL certificate. If not, purchase one.
  3. Click on the My Account on the upper right corner.
  4. Click on Visit My Account button.
  5. Click on SSL Certificates
  6. If you’re renewing your SSL certificate, click options besides the name of the server that needs certificate renewal.
  7. If you’re requesting a new certificate for a server that currently does not have a SSL certificate, launch the newly bought certificate by clicking on the Launch button.
  8. On the window that opens that says Hosting Options on the top, select Third Party, Dedicated Server, or Virtual Dedicated Server since we are using Filemaker Server. If you are in other hosting company’s website and they have an option for Filemaker Server, select that option.
  9. On the text box that appears under Enter your CSR below, paste the text we got from serverRequest.pem, including everything.
  10. Signature algorithm should be SHA-1.

This is important. Most hosting companies will try to convince you that SHA-2 is better, but Filemaker Server operates on SHA-1. Choose SHA-1.

  1. Certificate issuing organization is Go Daddy or whatever company you’re going to use.
  2. Agree to terms and conditions and click Next.
  3. Confirm that the information was entered correctly. And finalize the process.

Final steps

  1. Within 72 hours, you should get an email from Go Daddy confirming that the SSL certificate has been issued.
  2. Follow the url in the email.
  3. Click on the server that you requested SSL certificate for.
  4. Click on Download on the top.
  5. Select Other for server type on the window that pops up and download the zip file.
  6. Transfer the files inside the zip file to Desktop of the server you’re trying to install the SSL certificate (not a necessary step, but makes everything easier). There should be two files: one with complex-looking name that looks like hexadecimals (for example: 45a546f5acd.crt) and another one called gd_bundle.crt. We will not use gd_bundle.crt.
  7. Got to Terminal.
  8. Type fmsadmin certificate import path_to_file. File_name should be the name of the crt file you’re using (for example: 45a546f5acd.crt)

Sample command: fmsadmin certificate import /Users/docuwrx/Desktop/45a546f5acd.crt

  1. If there are no error messages displayed on the terminal window, everything is good.
  2. Restart your server.

And you’re done!