This seems ominous: omniORB: (0) Warning: SSL CA certificate location is not set. SSL transport disabled.

Image for post
Image for post

Working with Claris’ FileMaker Server Command Line Interface (CLI) allows you to configure your server to your needs and in some instances allows you to adjust settings that are not available within the Admin Console. When executing commands, if you encounter a warning message that begins “omniORB” followed by the date, time and something to do with the SSL, you may have concerns… And rightly so, “SSL transport disabled” doesn’t sound good, right? …

Diagnosing & Fixing A New Installation Of Zabbix 5 Appliance With “Database Error — Connection Refused” Message

Image for post
Image for post

If you’ve recently deployed Zabbix 5 using the downloadable Appliance package and a few hours, days or weeks later you log in and encounter a message telling you “Database Error — Connection Refused”, your heart will sink and your plans for the day are likely derailed. All that work setting it up, configuring the templates, adding the hosts and action notifications, wasted… Devastating. You’re probably coming to terms with having to spend the day building it from scratch again… But wait! …

What is this new script step in FileMaker 19 and how does it work?

Image for post
Image for post
Execute FileMaker Data API Sample File

FileMaker 19 introduced some game changing functionality to the platform, including the JavaScript functions and Add-Ons. Another last-minute feature that made it into the release was the Execute FileMaker Data API script step. Documentation is sparse at this time, so we set out to find out what it does and how it works. Let’s jump in…

What Does It Do?

This new script step allows a developer to query the database in a couple of ways and, more importantly, have the results returned in JSON format. Much of the data…

How to take advantage of web services’ webhooks within a FileMaker database

Image for post
Image for post

More and more online services are utilizing webhooks as a resource-light way to respond to an event, often times pushing around some data. So if we as FileMaker developers want to take advantage of these webhooks, how can we go about it? Well, dig in and find out!

What Is A Webhook?

A webhook (sometimes known as an HTTP callback or Reverse API) is an HTTP request (usually a POST or GET) made by a web application in response to an event taking place that is worthy of notification or some other…

Is your FileMaker Pro 19 installation running as a trial license despite adding the license certificate?

Image for post
Image for post
FileMaker Pro 19 — Enter License

In the process of setting up a machine for a client recently, we encountered an issue where FileMaker Pro 19 was installed, with the license certificate in the downloads folder as it should be, but we were asked for the license certificate each time the app was launched. And when it did launch, the app was in trial mode with an expiration date. But wait, we have a valid license…

Specifications

We’ve not encountered this with the multitude of other installations we’ve done of late…

It Might Take A “While” For Us To Achieve This

Image for post
Image for post

The JSON functions were introduced in FileMaker 16 and since then, as it’s native functionality, we’ve used these functions for passing around data in script parameters and more. Often times, we’ll be, say, clicking a button on a layout and passing multiple JSON formatted script parameters to the script being executed. But we began wondering if there was a quicker way of extracting the parameters into variables in the script, and it turns out there is…

Set Variable

Let’s assume for the rest of this article that we’re clicking a…

Adding Additional Disk Space To An Existing Volume

Image for post
Image for post
FileMaker Server on AWS

It’s not uncommon, as a FileMaker database begins to grow, that the volume originally set up on an AWS instance begins to run out of space. To tackle this, you could launch a new instance with a larger volume, but that seems like a bunch of work and there’s a much simpler way of solving this problem. Let’s find out how…

Modifying A Volume

As always, before starting anything like this, ensure you have a backup. That applies to your database file(s) and you could image your server also. …

Warning 156 fms.myserver.com Schedule “HOURLY_BACKUP_USB” aborted; the destination “filemac:/BackUps/” is not writable.

Image for post
Image for post
FileMaker Server & macOS 10.15

If you upgrade your Mac server to macOS 10.15 Catalina, you might find that your backup schedules to external drives start failing with an error number 156. Although apparently fixed in FileMaker 18.0.4, it’s rearing its head again, but there is a simple fix.

What’s The Issue?

macOS Catalina introduced a swath of new features and changes, including a whole bunch of security adjustments. …

Changes In FileMaker 19 Have Broken Existing Custom Default Fields

Image for post
Image for post
Fixing Custom Default Fields In FileMaker 19

Custom default fields were introduced in FileMaker 17 and proved to be immensely useful. The functionality allows for the automatic creation of fields when making a new table, ensuring consistency for fields like primary keys or creation/modification timestamps for example. If you had set this up in 17, when FileMaker 18 was released, they continued to work. But try it with FileMaker 19 and your custom default fields are gone. Don’t panic, it’s a pretty simple fix.

What’s Changed?

There are a couple of things that have changed with default fields in…

An Overview Of The Key New Features In Claris FileMaker Pro 19

Image for post
Image for post

FileMaker Pro 19 is now available, and with the release come a bunch of awesome new features to further enhance the capabilities of the platform. In this post we’ll check out, in brief, some of the key new features and in further posts we’ll dig into a select few a bit deeper.

New Product Logo

First up and perhaps the most obvious change is a new product logo for FileMaker, taking on the new Claris logo announced at the 2019 Developer Conference.

Sounds Essential

FileMaker Developers; Data Magicians

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store