fmsadmin: where did you go?

I have a few scripts, including some Facter reporting “facts”, that make heavy use of FileMaker Server’s fmsadmin command. After a 14.0v4 on install on Yosemite I was puzzled to discover that one of the scripts wasn’t working.

Continue reading “fmsadmin: where did you go?”

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”

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.

Debugging Apache with OSXS 10.8 Server 2.2

Besides being a bit of a mouthful, debugging Apache configuration issues has gotten slightly more complicated after Apple released the Server 2.2 update for Mac OS X Server.

Formerly, you could do a basic configuration check this way:

apachectl -t

Continue reading “Debugging Apache with OSXS 10.8 Server 2.2”

Code Signing a FileMaker Runtime

I wanted to code sign a runtime to avoid issues with users who had the higher security level set on their 10.8 based systems. Although lowering these permissions or holding down the control key when the app is launched will all help with this issue, code signing seems a reasonable and desirable, and removed the support issue.

Continue reading “Code Signing a FileMaker Runtime”

List cron entries for all users on Mac OS X

I needed to investigate why a script was being run, and I was pretty sure cron was launching it. The problem was, little useful information was being logged, and no one was sure how it had been set up or what user it was under. Although launchd is now the preferred mechanism on Mac OS for these kinds of things, you’ll still see many systems where cron is being used.

First, you want to become the root user. The following Terminal command is one way to accomplish this:

sudo -s

Continue reading “List cron entries for all users on Mac OS X”

Managing Files with AppleScript

If you’re like most power FileMaker users, you’ve discovered that it’s a great tool for managing collections of things or for gathering disparate data sources for reporting. So you’ve probably wanted at some point to do one or more of these actions:

  • Get a list of files on your computer
  • Import a batch of files
  • Move files on your computer
  • Read the text of a file that doesn’t import correctly (e.g., HTML)

Continue reading “Managing Files with AppleScript”

Unleashing Mac OS X’s Color Picker in FileMaker

Color is one of the most important tools available to you when designing user interfaces. Using a little color can turn a drab wall of text into something attractive and readable.

Continue reading “Unleashing Mac OS X’s Color Picker in FileMaker”

1 2