Hi all, please excuse the newby question.

I run OSX servers with Filemaker and Terascript (formerly Witango, before that Tango). Terascript talks to Filemaker via JDBC so I have installed the Filemaker Xdbc extensions (JDBC, ODBC). It is a listener process that waits for JDBC commands and interprets them and passes them on to Filemaker and returns the results.

The process is xdbc_listener and in both the Server and Client version of Filemaker it has a memory leak and slowly grows in memory footprint until it reaches the limit of the server and then crashes. In FMP (client) it brings up a dialog box with an option to click Reopen. On Server there is no outward sign, just that JDBC calls fail.

I am trying to write a script to test if xdbc_listener is running. If it is, the script should just write to a log file and die nicely. If not, it should trigger a restart of the process.

I have edited an old script that I use on older servers to test if FileMaker has crashed but it doesn't seem to correctly ascertain whether or not the process is running:

Code:

#!/bin/sh
 
#checking to see if fmxdbc_listener exists and writing to a variable

/bin/ps ax |grep fmxdbc_listener |egrep -v "grep|checkfmxdbc" > /dev/null 2>&1

#echo "$checkfmxdbc"

if [ $? = "0" ]; then
	echo "fmxdbc_listener is still Running - `date`" >>  /checkfmxdbc.log
else
	echo "ERROR - fmxdbc_listener is NOT Running - `date`" >>  /checkfmxdbc.log
	cd /Applications/FileMaker\ Pro\ 11\ Advanced/Extensions/xDBC\ Support/fmxdbc_listener.bundle/Contents/MacOS/
	./fmxdbc_listener -u &
fi

Any assistance with this would be greatly appreciated.

I am running:
OSX 10.6.8 on Mac mini with 2Gb RAM
Terascript Server 6.07
Filemaker Server 11.0.3 w/XDBC plug-in 11.3.81 (on one server)
Filemaker Client 11.0.4 w/XDBC plug-in 11.3.76 (on the other)