FileMaker Server 18

I’m quite a bit puzzled: There is a FileMaker database A hosted on a FMS 18 (Mac mini), 10.13.0.10 Working with database A using a FM Pro client as well as running FMS Script Schedules (SSS) or Perform Script on Server (PSoS), everything works fine. Database A has an external FileMaker FileMaker database B attached to it, which is hosted on another Mac mini 10.14.0.10 Opening database A in FileMaker Pro Client App on local network 10.13.0.1/24 on any computer and accessing database B (which is on fmnet:/10.14.0.10/B) works perfectly fine. Using SSS or PSoS on database B fails. It’s as if database B is simply not there for FMS. However,…

We're currently running a FM database on FMS v16 with web access via code generated by the old PHP site assistant. Our IT Security people require us to upgrade the server from OS X 10.12 Sierra to 10.15 Catalina, so of course that means we have to take FMS from v16 to v18. I've read that the PHP code generated by PHP site assistant is not compatible with the newer PHP which comes with FMS v18. I'm going to need some help from our web group to upgrade the web code and I first need to be able to describe the problem as they have no FileMaker experience. Does anybody know which version of PHP is used by the site assistant and which version comes with FMS v18 and FMS v19…

We're using Server 18 and aren't ready to update to Server 19 yet. One of our users has a new laptop running Monterey and has Filemaker Pro 19 installed since Filemaker 18 isn't supported. Would it be safe for them to use Filemaker Pro 19 to access files hosted on Server 18, or could that lead to issues like database corruption? Thanks!

Running the solution with a newly installed FileMaker 18 Server on MacOS X works fine, upgrading to 18v4 the solution still runs well, with one exception; there is no WebDirect. I have toggled all buttons for CWP, DATA API, and WebDirect in the admin console, I have also attempted all the restart options of the command line tool, this one: ``` fmsadmin restart wpe ``` amongst other; To no avail. Where do I search for this error? Port 443 nor 80 are available according to `lsof -Pn`

Hi all, So I had some troubles getting the SSL Cert installed on both of my dev and production servers. Long story short, I had to reinstall Filemaker Server 18 (version 18.0.4.428) on the dev (Windows 2012R2) to get the SSL cert to work and it now does work on our developer server. (Green checkboxes, 👍 ) However, I’m now unable to get the Web Publishing Engine Master Machine started with the Java Runtime Engine on the dev server after re installation. I have tried using OpenJDK to get it working and I upload the zip file from https://adoptium.net/?variant=openjdk8&jvmVariant=hotspot The file I get is "OpenJDK8U-jdk_x64_windows_hotspot_8u302b08", but it either gives…

Hi, Where can I find the installer files for the Mac version of FileMaker 18 Server? All that's available on the Claris website now is version 19. Cheers

I just migrated our FileMaker Server from a Mac Mini running MacOS High Sierra and FMS 17 to a Mac Mini running MacOS Catalina and FMS 18. Everything went well except getting FMS to backup to an external Hard Drive. I simply unplugged the External HD from the previous server and plugged it into the new server. It mounts no problem. I gave "fmserver" "Read & Write" access to the drive AND the folders on the drive it needs access to. I can read and write by dragging files onto the drive, but when I try to enter that Default Backup Folder Path under Configuration>Folders in FMS Admin Console I am told that "The path is not valid.". I used the e…

Is there a way to query CWP using FMPXMLRESULT as payload to create new records in FileMaker? Goal is to be able to insert records from command line using curl from FMPXMLRESULT files to avoid a somewhat clunky query from FileMaker XML import. I tried the following: cd /tmp/ curl -X POST -kL -o /tmp/findany.fmpxmresult.xml "user:[email protected]/fmi/xml/FMPXMLRESULT.xml?-db=PushTest&-lay=Table&-findany" curl -X POST -kL --data @findany.fmpxmlresult.xml "user:[email protected]/fmi/xml/FMPXMLRESULT.xml?-db=PushTest&-lay=Table&-new" A new record is created, however the payload is ignored. Payload below FTR <?xml version="1.0" encoding="utf-…

Hello, We run several FMS18 instances on Mac OSX machines. Randomly, more often on Fri / Sat / Sun, Filemaker server will shut down and disconnect all clients - curiously always at the same time, around 11:55 PM - , and I am unable to restart it from the command line and the web admin drops offline. The only way to bring it back to life is to reboot the entire machine. Is there any scheduled update job at 11:55 PM that I should be aware of that would cause this behavior?

This is strange. Two FMS18 servers on Mac. Both run a similar database file I had synced with mirrorsync. One of the tables is not that important but slowed mirrorsync down, so I decided to not mirror that table between server 1 and server 2, but instead make server 2 an external data source to server 1. I add server 2 as external data source to server 1. Then, things start to get weird. The table I wanted from eh external source I deleted from server 1. Yet, when I add server 2 as external datasource, it defaults back to the local file? I can tell that's what's happening according to two observations: server 2 has the ta…

I am using Filemaker Server 18 on Windows Server 2012 R2 Been using it for years with no issues Currently when I log in to the console it is very sluggish. When I get to the Dashboard it shows No databases, then it auto refreshes and the database list appears. Within 15 seconds of scrolling the database list to open files the screen refreshes. This situations is happening over and over in a loop. Any Thoughts on what is causing this issue?

Dear All, We have installed FileMaker Server 18. We have added a custom SSL certificate to FileMaker Server 18. On FileMaker Pro, we can view the green encrypted symbol and can able to access the Server DB. But on FileMaker WebDirect, we can't open the Server DB using the Domain name. We have received the error "No such file or directory" on connecting externally. On the internal network, we have received the error "Rejected request from RFC1918 IP to public server address" when we opening the WebDirect using Domain name. Can anyone help us to solve this issue? Thanks.

Hi. I finally went to the filemaker server 18 after being on 12 all these years, as you all recommended. I'm having a serious problem. I took all my database files and brought them to the fm server 18. There's 126 files. I clicked on open all and only 92 files open. Many files are similar, just for a different school year. Going crazy as I promised we'll be up by Monday. If I can't resolve this I have to go back to 12. Any help on this? Mike

One of my FileMaker Server 18 installs has been having a recurring problem for 2 months. It's 18.0.4.428 on macOS 10.14.6 on an older Mac mini (2012) with a 2.3GHz Core i7 and 16GB RAM with 71% free space on the boot volume and 375GB free (of 700GB) free on the external backup volume. Disk First Aid has been run on all volumes. This recurring problem started in late May. Since we were in a work-from-home situation, no updates had been performed on this machine for quite some time prior to this behavior starting. Essentially, some server process is shutting down all databases at the same time without being prompted to do so; meanwhile the admin console indicates that …

Hi everyone. I´m running a setup with the FM18 Server ( 18.0.1.123) on Win, ODBC mySQL tables and clients using Wed Direct both on Win and OSX through Chrome. Part of the solution is creation of contracts, so the clients use Web Direct and I´m using a server-side script to create the PDF and send the PDF on mail to the client who made it. I would like the script to insert the newly created file into a container for archive, but I´m fairly new to writing scripts on the server, and doest now exactly how I can debug them as I can with FM Advanced on my MacBook. Please advice. The script now sucessfully creates the PDF to the temp folder on the server, and sends…

On a clean install of Filemaker server 18 on a windows box running W10 Enterprise edition. The hosted files shows "Opening" from the Admin console, and that is how far it can go. The files never get opened. Have done couple of restarts but same problem. Have tried both encrypted and non encrypted files, same problem. Any advice on what might be the cause?

On a clean install of FMS18, fresh install of Mojave, web publishing will not run. I initially addressed the problem by wiping the Mac-mini hard drive and reinstalling OS X Mojave 10.14.6. (Mac mini is 2018 model with 16gb RAM and >400gb free HD space.) Then installed FMS 18.0.4. Installed the certificate and the Java JDK 8 update 242. Files accessed by FM Pro work fine, with green lock and normal behavior. WebDirect called from browser on the server using http://127.0.0.1/fmi/webd refuses to connect (with Chrome 81 and Safari 12.1). WebDirect over the local network refuses to work, too. FMS Admin console shows no problem. WPE.log shows no errors. Activity Monitor sho…

Hi, When is it recommended to create an SSL certificate and why? Currently running a couple small files - mostly project management stuff - with a couple inhouse computers. We're not hosting anything on the web or connecting anywhere outside of the physical building where the server is located. The set up is a mac mini server thats running FMS 18, connecting to about four iMacs. How important is the encryption? Can other people get on the server and use the files? Can they alter the files or the servers if the files are required to sign in to access? Kind regards, Filo

I have a macmini running Catalina. I'm trying to uninstall Filemaker Server 15 so that I can install Filemaker Server 18. However the 15 uninstaller does not work on Catalina. Is there another way to uninstall FMS 15?

Hello, I got two import script steps where 2nd one is activated when the 1st one fails but the problem is user should select the file twice. Can I save the selected file path into a variable and use that path to import 2nd time. Thank for your reply.

Hello, my FMS18 instances generally run very stably. With one exception: On two different machines, randomly, but always around midnight, FMS will crash in a very weird way. I'm running FMS 18.0.4.428 - All networking on the MacOS instance will work just normally - However, all FMS functions will suddenly be completely unavailable. That includes FMP connections; XML and API connections; webdirect connection - even the admin website is unavailable. - I can't even restart it from the command line- fmsadmin start or stop server only yields 'Error: 10502 (Host unreachable). The only thing that fixes it, temporarily, is a hard re…

Hi all, I have a idea to establish progressive backup on AWS S3 bucket. Client has a 3GB database (on aws machine) , and I we already use progressive backup in every 5 minutes. But, in case that main server crushes down, we have another, backup server, also AWS machine. Now, client wants that in trouble situation, save data as much as possible, and came up with this idea - progressive backup on AWS S3. Is this possible? Does anyone tried this? Thanks in advance, Ve

I'm having something odd happening. I'm running FMS18 on a server on my LAN. When I run admin console on that machine, everything is as it should be. SSL certificate is installed, valid license, expected databases are open. When I access via another computer on the LAN, using IP address:16000/admin-console, I am able to login and it shows the server is running BUT no databases are there, license shows as expired and there is no installed SSL certificate. In the past, I've had issues where firewall software prevented accessing the console over my LAN - but I've never had a situation where I could log into the console from another machine, but server reported all thi…

Hi all This the last thing I need to implement on our Server as per FileMaker's installation and configuration guide: Make the virtual memory swap file a static size so Windows doesn’t attempt to adjust it. Use the recommended file size amount Am I right in thinking that this is in the attached section? If so, on which drives should I be specifying the swap file size? And what would the initial and maximum size be? Thank you

Hey... Thanks in advance for your thoughts and the time reading this. I am currently running server 17, no issues, however, my SSL certificate just expired. Before I go through all the new motions and get a new certificate, you think I should switch to 18 now? Since the world is ending, my server is slower and its a good time to back it up and upgrade to 18. Are there anything noteworthy about switching to 18 at this point and will installing a certificate be any easier in 18? I thought installing a certificate on 17 was a pain in the you know what. Any thought appreciated. I am also running my server on a Mac. Been very happy, no issues to speak of. …

HI, I have files loaded into filemaker server 18 and suddenly they all keep randomly opening and closing. Very strange. Anyone know of such an issue? TIA

Hello there ... hoping everyone healthy and solvent! Trying to become as well versed as possible navigating the top calls stats log in order to better troubleshoot some issues we have from time to time. Does anyone know of a document or source of explanations for the remote calls listed in the log? I.E Download List, Upload List, Compare Modification, etc. It's rather maddening attempting to troubleshoot when you don't have this level of understanding. Thanks so much.

Has anyone worked with Websocket APIs and Filemaker Server? I'm interested in connecting FMS to Discord's Websocket API. Is it possible to do this natively? If not, does anyone have suggestions of what I might look into? Thanks!

HI all - I have two folders inside of the Databases folder which contain numerous files - these are DepotMaestro and TCM. I am trying to setup backup schedules for each of the subfolders. The path I am using is for the subfolder is: filemac:/NewMiniHD/Library/FileMaker Server/Data/Databases/DepotMaestro/ filemac:/NewMiniHD/Library/FileMaker Server/Data/Databases/TCM/ Both show the Not A Valid Path error. What am I doing wrong? Mojave, 18.0.3.319

Have copied a shell script which works in other settings onto a new machine Changes paths - it zips a backup folder and does a ditto command to copy as a zip file to an external drive I worked out that I needed to change the sudoers file to allow no password access to the script. Running the shell script in terminal was requiring a password, now it doesn't Added the fmserver user to that too. If I run the sh script from the admin console as fmserver it fails straight away, if I run it as the local user with its password it appears to run but in fact times out with a fail message, both of which are about invalid account name or password …

I recently purchased a new server for our FileMaker databases to live on. To migrate our databases, I simply copy and pasted the Database folder from the old server to the new server. The old server was running Windows Server 2016, and the new server is running Windows Server 2019. The clients are running on Windows 10. The Clients are running FMP version 18.0.3.317 and the Server is running FMS version 18.0.1.123 The server is in our building, and all clients are accessing it locally using Bonjour. After the migration, all of our Container Fields are displaying a 404 page. I have attempting the following troubleshooting steps: Disabled f…

Hi, just upgraded to Filemaker Server 18 on Windows 2019 Server. In the Logs, during the backup, he often says something like "The file hasnt changed since the last backup so I am saving a hardlink to the original file only". (This isnt the exact text - its translated from German). When I look at the backups though it looks like the Server really actually did backup the exact file, which is the behaviour I want. What gives? Is this a false message of some sort? I absolutely do not want him "not" to back up dormant files. I transfer the files elsewhere later and for that I dont want any hard links or similar. I want the full file. In…

Hello, we have filemaker server 18 hosted on windows server 2012, the server is connected to an APC ups thats keeps the server running for 40 minutes when power is loss, after power is loss we have to manually close the databases and stop the FM server , then we shutdown the windows server .... i would like to know if there is an automated command that close the databases and stop FM server when power loss is detected?

Hi all Our server decided to shutdown just now due to windows updates. Here is the FMS log: 2019-12-11 17:18:45.641 +0000 Information 745 FM Stopping FileMaker Server processes... 2019-12-11 17:18:45.675 +0000 Information 704 FM Stopping Database Server process... 2019-12-11 17:18:45.704 +0000 Information 488 FM Stopping Database Server... 2019-12-11 17:18:45.734 +0000 Information 410 FM Stopping FileMaker Database Engine... 2019-12-11 17:18:45.770 +0000 Information 140 FM Closing database "BS"... 2019-12-11 17:18:45.778 +0000 Information 140 FM Closing database "Case_Feedback"... …

Hello, I'm new to FMP and want to set up a single database solution for a small team of 4 people. Our systems aren't running the latest MacOS to keep our older Macs reliable, so the server won't run on our system. I'm wondering what the best option might be for such a small team - can we a use a file sharing system to serve up the database to the other 3 people on my development team? Or do we need to buy into a cloud based server to do this? Thanks in advance!

So we have a FMServer 14 (FMS1), I installed a new Windows Server 2016 and installed FMServer 18 (FMS2) on it, moved all the databases and everything was working great. The "start" database references 20 other DBs and opens them in tabs and sub-boxes. We turn off FMS1 and the Start DB can't open any of the sub DBs. The client found an old email from the previous designer which hints that the scripts were referencing FMS1's IP address. Now I'm not sure what direction to go to. Anyone seen this kind of behaviour? I'm a network/infrastructure engineer and this is totally out of my league.

Hi everyone, I am trying to run a server sided script that will import a found set. The server sided script opens a handler file that opens data file 1, does the find, imports into data file 2. However, the search works in script debugger but imports all records. The script opens layout A, searches goes to layout b, imports. Also the import of the selected fields seems not be remembered. I am stuck..... Thank you

Windows Server 2016 Desktop version with updates through 8/17/2019. FileMaker server version 18 with current update installed. Installed in the default location. Required ports or forwarded to the server and are open on the server. 80, 443, 2399, 5003, 16000 I can’t connect to the Windows FileMaker server from my Mac running FileMaker Pro (18 updated) when I try to up “Upload to Host” I get a “Connection Failed” error.

Im wondering if there are any issues installing server 18 on a Mojave system. Also what is the best java version to install ( if needed) thanks

I'm trying to have FM18 server generate a .ics calendar file from a calculated field. I have a calculated field that has the url formatted: If I were to type that into a browser it will download a .ics calendar file just fine. However if I use 'insert from url' to insert the .ics file into a container. It doesn't seem to work. Can you think of another method for FM18 server to generate a .ics file? I'm hosted on a remote server where plugins really aren't an option.

Why would I be getting this on install? MacOS Catalina, latest MacBook Pro, just recently installed Python 3, Django, PIP, Eclipse which had me install the latest JDK from Oracle. Thanks!

https://community.filemaker.com/en/s/article/Startup-Restoration

FYI, FMS 18v3 is out and fixes a subtle bug: sometimes after a reboot on macOS, the apache / httpd server fails to start up. As a result, FMPro works fine, but WebDirect will be dead, and there's no notifications. See https://community.filemaker.com/en/s/article/Software-Update-FileMaker-Server-18-0-3

Hello, I have been trying to figure this out for weeks and have gotten nowhere. I have a script that ran perfectly fine on server 17 and it also works when run locally on Pro 17 or 18, but it won't complete a perform find function when run on server 18. I was wondering if anyone has experienced this and might be able to take a look at my script steps to see if I am causing something that isn't viable in server 18 scripting. The Pro or Go client calls a local script called "Send SMS to Server", then the server runs a script called "Send SMS on Server" . Here are screenshots of both scripts that were working on server 17. The script kicks back…

HELP! This is driving me nuts. Need to send emails with an attachment from server side script. The attachment path calculates correctly, as far as I can tell. Permissions are 777 (I Know...), but the file still does not attach! This is the variable calculation that yields the path: "/Samsung SSD/Library/FileMaker Server/Data/Documents/"&$filename Only problem is: attachments don't attach! I have tried every iteration I could think of: "filemac:/Samsung SSD/Library/FileMaker Server/Data/Documents/"&$filename "/$filename" "<Documents>/"&$filename What am I missing here??? …

Hello, I have a FileMaker server 18 installation that’s crashing about once a week. When I look at the event log for the time of the crash. I see client 1 not responding, client 2 not responding etc. until all clients are disconnected. All databases show as open in the server console. From a client PC no open files are listed for the host. If I telnet to the server from a workstation on port 5003 a connection can’t be established. Stopping and starting the database server does not help. Restarting the FileMaker service does not restore operation. The server is still communicating with the network. I can open a web page or browse other computers on the network. Res…

Hi: I am planning the upgrade to 18, I have 3 questions 1- I will host my own server, as I do now with 11. We are 9 users, normally not more than 5 are connected. I don’t want to install a Windows server so I will go with a Mac. I am thinking of the basic Mac Mini upgrading memory to 16 GB, is it OK? 2- Of the above 9 users, 4 are occasional. I have 4 FMPA 17 individual licenses. If I buy 5 user licenses, can these 4 occasional users connect to the server with the individual FMPA 17 licenses, or do I have to buy the 9 user licenses? 3 - I will keep using Super Container, no point in using time to move to remote containers (tons of files) …

Hi All, Do we need SSL Certificate for FM Server Child server that we use to for Web Hosting (WebDirect)? Regards, Khurshid Khan

Hi All, Hoping you can assist. I have FMS18 running on Mac #1 in the office. This hosts a database with a lot of container fields. I recently moved the container fields external and during this move, have lost a lot of them. IN addition, the database is struggling to save new uploads to external storage. Ideally, I want the database file, hosted on Mac #, with external storage on an external HDD which is USB3 to Mac #1 All clients are on the same Network;. What am i doing wrong, because can't get it to work. Right now, I've moved the storage folders back onto the Mac #1, but am getting an error "Cant write to external storage"

Hi folks. I'm thinking of upgrading an FMS server, a physical machine that I own and administer, so I wanted some input on whether FM Server is going to benefit from more cores, as for example found in AMD's Ryzen CPUs or whether I should instead opt for less cores but with more performance per core (Intel). Does it utilize threads extensively when many clients are issuing requests, and if yes, has it been like that since, say, version 12 or is it just a recent development? And also, is this behavior similar in both macOS and Windows or are they different?

Hey Folks Im running Server 17 and have a number of scripts configured to run. Recently, some have stopped executing. What I mean is I select it to run (or the server runs it as scheduled) and then when I run it manually, there are records that have not been processed. So I checked logs log. "Last Scripting Error (802)" Any recommendations how to resolve this?

What's the latest version of FMP / FMPA that gets along well w FMS16? I'm in a workplace where I have access to version upgrades, but we're working with files hosted on Server v16.

I currently spend about $60 per month to a company that hosts my FMP 14 databases on a shared server. How complicated would this be to manage on my own? I am not interested in hosting sites for anybody else, just those for my own company. What kind of dedicated computer gear would I need to make this happen? Would I need to have a dedicated IP address? Can this be done by a rube like myself or would it be better to continue paying someone else for this work?

I am reworking my process of using FMP server side script. Run Server Scheduled Script every 45 minutes Log in to FTP get directory listing (plugin / curl) Create Record for each file in listing Fetch file via (plugin / curl) to text field Write file to server's Document folder Move file on FTP to sub directory (compete) Import files from document folder in to table It works but think kludgy and FMS probably requires more overhead to deal with the FTP plugin. Is there a way to do the following Run a server sequence script every 45 minutes Run a bash script on server login and fetch new files from ftp (ne…

Hi everyone, I recenetly installed a fresh copy of FM Server 18 on a new isolated VPS and tried to copy over the most basic setup which included installation of 2 Server Plugins: ExcelInjector made by Linear Blue BaseElements I simply copied them from my production deployment over the the extension folder as depicted below. However, when I flick the switches as below: They simply fail to load. I am getting an error as below: MServer Error 474 Plug-in failed to load: BaseElements.fmx64 The plugins work perfectly fine on the production server running FM 17. I have moved the same plugins several times from dev se…

TMS Software, LLC, introduces its new FileMaker Admin Console application for FileMaker Version 18, making use of the Admin API, FMSADMIN calls, and the Data API. It is released to the FileMaker community at no cost. Why would someone want to use this software when FileMaker has a perfectly good web Admin console? Here are several reasons. By getting the same information in a FileMaker solution, developers can use the information in conjunction with other FileMaker solutions. The web Admin Console does not allow you to turn off the automatic 7 daily preserved backups. The web Admin Console no longer generates CSR requests for FileMaker Server. …