Step-by-step for FileMaker Cloud

Although setting up your AWS account and creating a new FileMaker Cloud instance is a fairly easy process, it does have dozens of steps, and a few places where you could easily take a wrong turn. On this post we’ll go through each step in the configuration of your Amazon AWS account and requesting your first server.
Continue reading “Step-by-step for FileMaker Cloud”

SSL Certificates with FileMaker

Intro: SSL Basics

SSL certificates are a very common way to secure client/server network connections, and the FileMaker platform has made use of them for many years. Starting with version 15 however, FileMaker introduced a number of security changes, in handling SSL and certificates, on both the server and the clients. But where do they come into play, and how might this affect your deployments?

Continue reading “SSL Certificates with FileMaker”

Facter Reporting for FileMaker Server

Recently we’ve been thinking about how we can better monitor the collection of systems that we manage. These can be client servers with very diverse configurations, access, or functions. Additionally, we have our own array of systems, almost as diverse as our clients’.

Continue reading “Facter Reporting for FileMaker Server”

Updated FileMaker Fail2ban Files

As an aid to improving the security of your server, Fail2ban is an open source component that checks for signs of abusive activity in your logs, and when these are detected, blocks an address (or possibly a subnet) for a given period of time. In May of  ’13 I blogged about how to set up Fail2ban rules to check the FileMaker Server event logs (http://buzz.beezwax.net/mVfrR7).

Continue reading “Updated FileMaker Fail2ban Files”

Summarizing FileMaker Server Access.log data

Various times I’ve needed to do some quick summaries of how a given server and its databases were being used. When using Mac OS X, I may use shell commands to get a quick summary of what’s happening on a particular server.

Continue reading “Summarizing FileMaker Server Access.log data”

Listing hosted FileMaker files from the shell

As part of a shell script I’m cooking up, one of the required tasks is to list all currently hosted database files on a Mac OS based FileMaker server. This may get deployed over multiple servers, and I want to keep it as simple and trouble free as possible.

Continue reading “Listing hosted FileMaker files from the shell”

Enable Logging of Client Usage Statistics in FileMaker Server

I was looking for a way to monitor client usage of FileMaker Servers over time.

Continue reading “Enable Logging of Client Usage Statistics in FileMaker Server”

Summarize how often databases are opened in FileMaker Server

We needed to quickly know how often various databases were being opened on a client’s server.

If you have Access logging enabled and are using a Mac OS based system, this shell snippet will give you a nice summary of how often each database has been opened:

awk -F" '{ if($3 == " opening database ") print $4;}' '/Library/FileMaker Server/Logs/Access.log' | sort | uniq -c

Unfortunately, it won’t show you a count for databases that were never opened within the scope of the current access log.

Simon.

Fail2Ban with FileMaker Server

I needed to configure a FileMaker Server (FMS) that would be an isolated system and accessible via the Internet.

Besides other precautions, like locking it down on the firewall as much as possible, changing the default SSH port, etc., I wanted to give the system some ability to defend itself against malicious access. FMS will prevent this to some extent, largely due to how the FMS Admin Console and the FileMaker client are designed.

Continue reading “Fail2Ban with FileMaker Server”

1 2 3