Tag Archives: FileMaker Server

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.

Here’s one that came up just recently. Client wanted to know what accounts had been used to access databases, but they were largely using generic account names.

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

What Are Your Imports Waiting For? FileMaker 13 Perform Script on Server – Part II

Introduction

I hope that since our previous blog post you have been exploring the possibilities created by FileMaker’s Perform Script on Server (PSoS). This article is a continuation of the PSoS discussion and includes more cool things you can do with it, specifically running database imports on FileMaker Server.

This spring I presented these techniques at four FileMaker Dev Meetups on the West Coast. As promised, I’m posting my techniques here, as well as uploading the example database files I have been using to do the import on server examples.

Continue reading What Are Your Imports Waiting For? FileMaker 13 Perform Script on Server – Part II

100x Faster – Flight Testing FileMaker 13 Perform Script on Server – Part I

Introduction

Since the release of FileMaker 13 we have been exploring a new feature called “Perform Script on Server” (PSoS) and trust me there are many cool things you can do with it. I’m going to describe how PSoS works, how it’s best implemented, and how our tests show PSoS can drastically improve database performance, more than 100x in some situations. However, there are also a number of considerations before you run wild and convert scripts to execute via PSoS. So, I’ll cover these as well.
 

Continue reading 100x Faster – Flight Testing FileMaker 13 Perform Script on Server – Part I

Java Applet Issues with Java 7 Update 51

Applets now are required to contain additional information in their .jnlp files to document the files used, either external or local. But if you are working with older code, such as the FileMaker 11 Server Admin Console, the required manifest information is missing and your applet will halt with an exception like this:

Adding in the missing manifest is obviously preferable, but when not in a position to do this we can workaround this requirement with the new Exception Site List dialog in the Java control panel. You can get to this by clicking the Security tab and then the Edit Site List…

Continue reading Java Applet Issues with Java 7 Update 51

Enable Logging of Client Usage Statistics in FileMaker Server

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

We can get a little bit visibility into this by enabling the Access logs, but these only show when users log or out and open or close databases. There is an option however in the Admin Console that can show you real-time usage:

Client_Statistics

It turns out that when the Log client statistics…. check box is checked, this data is logged to (on Mac OS) /Library/FileMaker Server/Logs/ClientStats.log. But only when this check box is ticked and the Clients tab is selected. (This behavior has changed in FMS 15 — it will now stick between reboots).

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

Recipe for testing JDBC connection to FileMaker Server

FileMaker Server Advanced allows external systems to connect to its hosted database files via ODBC and JDBC. The remote systems can then run SQL commands against the hosted databases. Often the hard part is getting all the infrastructure ready for this. That includes the correct extended permissions on the FileMaker database file, needed drivers, firewall settings, etc.

FileMaker provides a test program you can use to check if a JDBC connection is working. It is a bit buried on their site, but can be found at: JDBC Test Application

Continue reading Recipe for testing JDBC connection to FileMaker Server