[FX.php List] Re: Error 802 - Unable to open file

[Dale Bengston]

Further research and Console log analysis brought me to the smoking gun: the Cisco AnyConnect VPN client.

I grudgingly* installed AnyConnect on Monday to connect to a new client’s VPN. Subsequently, Cisco AnyConnect killed FMS, killed web access to FMS and caused major slowdowns to every browser page load. The slow browser loads caused barrages of errors in Console that ultimately  led me to the culprit, and a resolution. I uninstalled AnyConnect and reinstalled with its web security “features” turned off. I now have my Mac back.

* I have a hate-hate relationship with Cisco VPN clients. Their previous-generation IPSec client was a buggy mess. When Apple came up with its own built-in Cisco IPSec VPN client, I happily switched to it and reduced my kernel panics by 100%.

Another D+ for Cisco. Too bad I can’t send them a bill for lost work time.

Dale

On Jun 27, 2014, at 12:48 PM, Dale Bengston <dale.bengston at gmail.com> wrote:

> Hi everyone,
> 
> Here’s a new one for me. I had to uninstall/reinstall my dev server’s FMS12, and now I’m getting an error 802 (Unable to open file) when I try to connect via the web. Here’s what I’ve eliminated as causes:
> 
> * Accounts, privilege sets: The databases I’m using are backups of files from the production server, so I know (and have verified) that the proper extended privileges are set for XML web access. The user account I’m using in FX.php is the same as always, and the same as the live server.
> 
> * File permissions (OS X): I can log into the files client-server and create add/edit/delete records. Permissions are set correctly on the physical files.
> 
> * File corruption: I can log into the databases client-server and all functions as expected.
> 
> * Web server connection: I get 200 from Apache using localhost or the IP address of my machine, but error 802 from FX.php. (If I intentionally put in an IP address with no FMS, I get the expected [FX_Error: message="FX: cURL could not retrieve Post data in RetrieveFM7Data(). A bad URL is the most likely reason." code=100 mode=return level=notice prefix="" info=“”].)
> 
> --a break in the action--
> 
> Okay, I have shut down FMS one more time, repaired permissions and restarted, I am not able to bring FMS back up. The log files say:
> 
> 6/27/14 12:41:18.058 PM com.filemaker.syslogger[89]: Starting Database Server process...
> 6/27/14 12:41:18.083 PM com.filemaker.syslogger[89]: Database Server process has terminated abnormally.
> 6/27/14 12:41:18.194 PM com.filemaker.syslogger[670]: FileMaker Database Server has detected that a required network port (5003) is already in use by another application (probably FileMaker Pro running on this machine). FileMaker Database Server cannot continue and will now shut down.
> 
> Since I just restarted, I definitely do not have FileMaker Pro running and taking port 5003. (And no I don’t have the OS X firewall tuned on, ever.) Anybody have any clue what’s killing my FMS?
> 
> FX.php v 6.0
> OS X Mavericks 10.9.3
> FileMaker Server 12 v12.0.6.600 (Mavericks release)
> 
> Thanks,
> Dale
> 
>