I have a Windows 2012 R2 server running FMS14 -- the software and OS are all up to date.
I am trying to connect remotely to a database on this server using the PHP API.
The server has a valid SSL certificate installed for both FMserver and IIS (i.e. my FMP client connections have a green padlock, and web connections can use HTTPS).
When I'm establishing the fm connection in my PHP script, if I define the server URL (the $hostspec property) as http://myserver.co.uk the connection works, and I can communicate with the database as expected.
However, if I define the server URL as https://myserver.co.uk then I get:
60 (Communication Error: (60) SSL certificate problem: unable to get local issuer certificate)
The fact that the http connection works indicates that my user, password, etc., are OK, and that the privilege set, layout names, etc. are all OK. The fact that I can get encrypted connections for FMP clients and for web pages (including WebD) indicates that my SSL certificates are OK (confirmed by the MMC certificate snap-in).
So, can anyone help me with why I can't connect securely with FM's PHP API? I'm a bit baffled!