Tag Archives: Mac

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. When run, the script was complaining that the fmsadmin command was missing, yet I could still run the command when I typed it in the Terminal. Puzzled, I eventually found that the shell’s whereis command was returning a different path from what I had in my script’s environment.

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.

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

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.


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.

There are a few ways to get the needed certificates, but in my case I got them as part of my Mac OS Developer account at Apple. I won’t go in to the details right now (possibly I’ll update this later to include this), so here I am assuming you’ve already gone through the needed steps to get the certificates into your keychain.

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.

The human eye is tuned to perceive color. This makes it a key tool for helping users quickly sort through complex information. This isn’t to say that your layout should be a tacky rainbow of hues. All it takes is a little deliberate and tasteful formatting here and there to increase usability for your users. This post presents a technique that allows users on Mac OS (sorry Windows users!) to harness the power of color by unleashing the Color Picker in their solution. It’s pretty simple really; all you need is a global field and one custom function!

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

Area Disclosure in FileMaker Using Sub-Summary Parts

The attached file demonstrates a technique for opening/closing areas of a record, allowing a user to hide the information they don’t want to see.

FileMaker File:  DisclosureAreas2.fp7

Continue reading Area Disclosure in FileMaker Using Sub-Summary Parts