mac XDBC won't start

[tv_kid]

Hi there

 

I'm trying to get SyncDeK to connect to FMS 13 on a clients' server.  I have it working successfully on my own development server, but for some reason, ODBC/JDBC won't start on the clients' machine.  

 

FMS 13.0.5.520 on OSX 10.8.5

 

Apart from ODBC / JDBC access, FMS has installed and deployed correctly.  Although ODBC/JDBC is ’switched on’ in the Admin Console, there is no ’tick’ on the left hand side.  Additionally, the fm_xdbclistener process is not listed in the Mac 'Activity Monitor'.

 

I have attempted to start the xdbc process from the command line by using "fmsadmin start xdbc"  but receive an error message ("Error: 10017 (Requested object is disabled)".

 

When I attempt to connect via JDBC (from SyncDeK) I get the following message: "Couldn't build table profiles, caused by: [FileMaker][FileMaker JDBC] Connection refused. Check that the host address and port are correct and that xDBC sharing is enabled on the host."  This appears to confirm that the XDBC service is not running.

 

I've got a call in with FileMaker support, but wanted to see if anyone else had come across this problem before?  I've been tearing my hair out all day trying to fix it, and have reinstalled FMS twice...

 

Thanks in advance.

 

[Wim Decorte]

Do a disk verification/repair?  Could be that the privileges are out of whack.  Make sure to stop FMS completely before you do that.

[tv_kid]

Hi Wim

 

Thanks for the suggestion.  I tried that, and although it did repair a lot of things, it hasn't changed the situation unfortunately.

 

Cheers

 

Matt

[Wim Decorte]

Check the FMS events log, for the time that you start up FMS and tried to do it from the command line, perhaps the event log has a little more detail that can be useful.

Also verify that nothing else is using port 2399 (FM's ODBC port)

[tv_kid]

Hi Wim

 

I've taken a look and it doesn't appear to shed any further light on it. It just lists the error as "XDBC connections are not allowed", but I've included the event log from FMS startup in case you can spot something I've missed...  

2015-02-04 20:45:42.791 +0000	Information	743	Server FMS13	Starting FileMaker Server processes...
2015-02-04 20:45:42.792 +0000	Information	703	Server FMS13	Starting HTTP Server process...
2015-02-04 20:45:42.845 +0000	Information	703	Server FMS13	Starting Progressive Backup process...
2015-02-04 20:45:42.847 +0000	Information	703	Server FMS13	Starting Database Server process...
2015-02-04 20:45:42.850 +0000	Information	703	Server FMS13	Starting Admin Server process...
2015-02-04 20:45:43.828 +0000	Information	162	Server FMS13	Starting FileMaker Server 13.0v5 x64 (11-05-2014)...
2015-02-04 20:45:43.828 +0000	Information	763	Server FMS13	Running on Mac OS X 10.8.5 (Build 12F45), with 2 logical processor core(s)
2015-02-04 20:45:43.828 +0000	Information	657	Server FMS13	Client access logging disabled.
2015-02-04 20:45:43.828 +0000	Information	178	Server FMS13	Maximum size of log file: 40 MB
2015-02-04 20:45:43.828 +0000	Information	658	Server FMS13	Email notification to administrators: None
2015-02-04 20:45:43.831 +0000	Information	703	Server FMS13	Starting FileMaker Script Engine process...
2015-02-04 20:45:43.857 +0000	Information	174	Server FMS13	Statistics logging disabled.
2015-02-04 20:45:43.896 +0000	Information	606	Server FMS13	Default database location: filemac:/MacHD/Library/FileMaker Server/Data/Databases/
2015-02-04 20:45:43.898 +0000	Information	622	Server FMS13	Additional database folder [1] disabled.
2015-02-04 20:45:43.899 +0000	Information	622	Server FMS13	Additional database folder [2] disabled.
2015-02-04 20:45:43.905 +0000	Information	614	Server FMS13	Maximum number of FileMaker Pro client connections permitted by FileMaker Server License: Unrestricted
2015-02-04 20:45:43.906 +0000	Information	616	Server FMS13	Maximum number of Custom Web Publishing connections permitted by FileMaker Server License: Unrestricted
2015-02-04 20:45:43.907 +0000	Information	751	Server FMS13	Maximum number of concurrent FileMaker WebDirect and Go clients permitted by FileMaker Server License: Unrestricted
2015-02-04 20:45:44.029 +0000	Information	74	Server FMS13	Maximum number of files to host: 125
2015-02-04 20:45:44.036 +0000	Information	936	Server FMS13	Maximum number of Perform Script on Server sessions to run simultaneously: 25
2015-02-04 20:45:44.029 +0000	Information	472	Server FMS13	Server scheduling enabled.
2015-02-04 20:45:44.036 +0000	Information	466	Server FMS13	File list filtering: Disabled
2015-02-04 20:45:44.039 +0000	Information	126	Server FMS13	Schedule "Daily" scheduled for 02/04/2015 11:00 PM.
2015-02-04 20:45:44.039 +0000	Information	500	Server FMS13	Client authentication method: FileMaker accounts only
2015-02-04 20:45:44.052 +0000	Information	596	Server FMS13	Disconnect idle clients disabled.
2015-02-04 20:45:44.052 +0000	Information	492	Server FMS13	Sample statistics every 30 seconds.
2015-02-04 20:45:44.065 +0000	Information	620	Server FMS13	Runtime Solutions custom database extensions: Disabled
2015-02-04 20:45:44.098 +0000	Information	434	Server FMS13	Default backup location: filemac:/MacHD/Library/FileMaker Server/Data/Backups/
2015-02-04 20:45:44.107 +0000	Information	514	Server FMS13	Administrator authentication method: Password required
2015-02-04 20:45:44.109 +0000	Information	498	Server FMS13	Secure (SSL) Network Encryption: Disabled
2015-02-04 20:45:44.110 +0000	Information	938	Server FMS13	Progressive downloading: Disabled
2015-02-04 20:45:44.123 +0000	Information	779	Server FMS13	Progressive backup is disabled.
2015-02-04 20:45:44.126 +0000	Information	406	Server FMS13	Starting FileMaker Database Engine...
2015-02-04 20:45:44.453 +0000	Information	116	Server FMS13	Server host name type: Custom
2015-02-04 20:45:44.456 +0000	Information	120	Server FMS13	Server host name: Server FMS13
2015-02-04 20:45:44.458 +0000	Information	36	Server FMS13	Network address(es): 127.0.0.1:5003
2015-02-04 20:45:44.468 +0000	Information	613	Server FMS13	Maximum number of FileMaker Pro client connections configured in FileMaker Server: 250
2015-02-04 20:45:44.479 +0000	Information	615	Server FMS13	Maximum number of Custom Web Publishing connections configured in FileMaker Server: 200
2015-02-04 20:45:44.979 +0000	Information	166	Server FMS13	Database cache size: 512 MB.
2015-02-04 20:45:44.991 +0000	Information	408	Server FMS13	FileMaker Database Engine started.
2015-02-04 20:45:45.012 +0000	Information	773	Server FMS13	FileMaker Script Engine support of Install Plug-In File script step disabled.
2015-02-04 20:45:45.085 +0000	Information	486	Server FMS13	FileMaker Server started.
2015-02-04 20:45:45.115 +0000	Information	418	Server FMS13	Opening database "FMServer_Sample"...
2015-02-04 20:45:45.116 +0000	Information	418	Server FMS13	Opening database "SampleCFYD"...
2015-02-04 20:45:45.118 +0000	Information	418	Server FMS13	Opening database "SampleNewDriver"...
2015-02-04 20:45:45.119 +0000	Information	418	Server FMS13	Opening database "SampleCFYD__AuditLog"...
2015-02-04 20:45:45.119 +0000	Information	418	Server FMS13	Opening database "SampleCFYD__Data"...
2015-02-04 20:45:45.120 +0000	Information	418	Server FMS13	Opening database "SampleNewDriver__AuditLog"...
2015-02-04 20:45:45.121 +0000	Information	418	Server FMS13	Opening database "SampleNewDriver__Data"...
2015-02-04 20:45:45.385 +0000	Information	184	Server FMS13	Opened database "FMServer_Sample".
2015-02-04 20:45:45.884 +0000	Information	703	Server FMS13	Starting Web Publishing Engine process...
2015-02-04 20:45:45.886 +0000	Information	703	Server FMS13	Starting Java Web Publishing Engine process...
2015-02-04 20:45:46.889 +0000	Information	744	Server FMS13	FileMaker Server processes started.
2015-02-04 20:45:47.780 +0000	Information	184	Server FMS13	Opened database "SampleCFYD".
2015-02-04 20:45:47.782 +0000	Information	184	Server FMS13	Opened database "SampleNewDriver".
2015-02-04 20:45:47.790 +0000	Information	184	Server FMS13	Opened database "SampleCFYD__AuditLog".
2015-02-04 20:45:47.791 +0000	Information	184	Server FMS13	Opened database "SampleCFYD__Data".
2015-02-04 20:45:47.791 +0000	Information	184	Server FMS13	Opened database "SampleNewDriver__AuditLog".
2015-02-04 20:45:47.793 +0000	Information	184	Server FMS13	Opened database "SampleNewDriver__Data".
2015-02-04 20:51:21.692 +0000	Information	518	Server FMS13	Administrator connected: "fmsadmin [127.0.0.1]" (fmadminserver).
2015-02-04 20:51:31.834 +0000	Information	518	Server FMS13	Administrator connected: "Admin [127.0.0.1]" (admin console).
2015-02-04 20:52:03.529 +0000	Information	608	Server FMS13	XDBC connections are not allowed.
2015-02-04 20:52:25.655 +0000	Information	608	Server FMS13	XDBC connections are not allowed.
2015-02-04 20:55:39.178 +0000	Information	520	Server FMS13	Administrator disconnected: "Admin [127.0.0.1]" (admin console).
 

How would I check that nothing else is using port 2399?  Can I use the port scan option in the Network Utility app?

 

Thanks in advance.

 

Matt

[Wim Decorte]

All that the log tells us is that FMS starts with the xDBC setting toggled off.  When you try and turn it on from the admin console or command line, what does the event log say then?

 

As to finding out if something else is using port 2399, do a google on the netstat command that you can run from terminal.

[tv_kid]

Hi Wim

The entries at the end of the log ("XDBC connections are not allowed") appear when I attempt to start XDBC from the command line or within the admin console.

Netstat doesn't show anything using port 2399.

Thanks for your continued advice.

Matt

[NovaChan]

I have the same issue! Nothing is reported on port 2399 in netstat of lsof. Also repaired disk permissions.

 

When attempting to turn on xDBC, I only get this in the FMS log:

 

XDBC connections are not allowed.

 

Please update the thread if you make progress.

[Wim Decorte]

Is that in 13 or 12?

 

If in 13: did you buy an xDBC connection pack?

[Claus Lavendt]

Huh ?

Wim, there is no such thing as a requirement to purchase an xDBC connection pack in FMS13.....

xDBC allows (as far as I remember) 50 concurrent connections, but since the server advanced was taken off the pricelist, this has been included in the server.

 

I have previously experienced some problems with parts of the FMS hanging or refusing to start. In many occasions, it helped to just reboot the machine....

Sometimes a re-install will do the trick...

[Wim Decorte]

Huh ?

Wim, there is no such thing as a requirement to purchase an xDBC connection pack in FMS13.....

 

Thanks for setting me straight, Claus!  I got mixed up with the Go/WebD connection packs.  Made me think for a minute that the same applied to xDBC connections

[NovaChan]

This is FMS 13.5. I just tried reinstalling FMS and rebooting. No difference.

 

I'm seeing other issues too:

- Can't connect to web server when trying to enable web publishing

- FMS won't start itself after system reboots. I have to force it using launchctl

 

I just tried starting from scratch with a fresh VM image. Still no luck. Maybe there's something flawed with this image.

[tv_kid]

I only managed to resolve this by reinstalling the OS   .  On a clean install of OS X XDBC works fine.  Only now I can't seem to get SyncDek to install....  

[mkos]

I recently encountered this issue. Here's what resolved it for me:

I re-ran the Deployment Assistant, turning ODBC off. I then re-ran it again, turning ODBC on.

I'm not sure if this was needed, but prior to running the Deployment Assistant, we asked the users to log off and we closed the database files, so that they were no longer hosted.

My FMS version: 14.0.4.412.

Edited March 14, 2017 by mkos