FMS14 compatibility

[pfroelicher]

Hi Forum, 

has anyone tested the latest ZULU version with Filemaker Server FMS 14?

Any information appreciated. 

Yours

Pierre

[taylorsharpe]

I just tried installing Zulu 1.2 on a FMS 14.0.1.204.  When I try to publish it, it errors out with the following error:  

Calendar Publishing Error

java.sql.SQLException: Could not connect to database at http://127.0.0.1:16020/fmi/xml/FMPXMLRESULT.xml?-db=EltonRicheyComplete&-lay=ProscNoSuchTable&-view: Only received 144 bytes in XML response. Header bytes received: That was the last attempt (out of 5); will not retry.

​I wonder if there will be an update or what is the problem.

TAYLOR SHARPE

PS:  Installed on a Mac OS X 10.10.3

Edited May 27, 2015 by taylorsharpe

[pfroelicher]

Elton, 

did you get this result in the browser or in the Filemaker server console log?

I get these errors always in the fms console logs, since years.. but my solution works...:-)

[joevmartin]

We resolved this issue in a ticket, but I would like to post the answer here as well:

First, let's get you on the latest version so we are not running into previously resolved issues, you can download it here:
https://s3.amazonaws.com/static.360works.com/360Works+Zulu+1.357.zip

After you run the installer, navigate to the file below:
Windows:
Program Files/360Works/Application/webapps/Zulu/META-INF/context.xml

Mac:
Library/360Works/Application/webapps/Zulu/META-INF/context.xml

remove the port number from this line:
Parameter name="jdbc.host" value="127.0.0.1:16020" overide="false"

So that it reads:
Parameter name="jdbc.host" value="127.0.0.1" overide="false"

Let me know if that fixes the issue.

Thanks,

Joe Martin
Certified FileMaker Developer
360 Works
(866) 662-9185
 

[pfroelicher]

Joe, this worked fine for me FMS14 with OSX10.10.3

However I try to tweak the installation a bit and run OSX server on the same machine, mainly for websites and Open Directory. 

I know, that it is none of you business to support non plain vanilla stuff.. but with FMS13 I had it working. 

Now I get

Calendar Publishing Error

java.sql.SQLException: Could not connect to database at http://127.0.0.1/fmi/xml/FMPXMLRESULT.xml?-db=ZuluSampleData&-lay=ProscNoSuchTable&-view: Server returned unexpected status code: 404 for URL "http://127.0.0.1/fmi/xml/FMPXMLRESULT.xml?-db=ZuluSampleData&-lay=ProscNoSuchTable&-view" message: 

Not Found

The requested URL /fmi/xml/FMPXMLRESULT.xml was not found on this server.

---

Apache Server at 127.0.0.1 Port 80

when I publish. XML is enabled, Web publishing is On, CWP is on and the localhost/zulu page loads OK, however the webserver I had to switch off. 

Do you have a hint how to make this work?

Yours

Pierre

[joevmartin]

The Filemaker Web Server is really a very customized configuration of the Apache Web Server, instantiating it's own web root (/Library/Filemaker Server/HTTPServer/htdocs) and server root variable, among other things.

In order for Zulu to work, Filemaker Web Server needs to be up and running, redirecting our requests to the proper channel.

While it is possible to further configure the Filemaker Web Server to use a different web root, and open directory, but typically the computer where Filemaker is installed should only be used for Filemaker Server.

If you would like to poke around, the conf files for the Web Server reside at:

/Library/FileMaker Server/HTTPServer/conf/httpd.conf

/Library/FileMaker Server/Admin/admin-helper/WEB-INF/conf/mod-proxy.conf

Thanks,

Joe Martin
Certified FileMaker Developer
360 Works
(866) 662-9185

[pfroelicher]

Joe, 

 I had it all working, even with server.app running, I had websites turned off and had fms server handle all the httpd stuff. 

Now I changed my setup (upgrade to fms14.v2, OS10.10.4 and Server4.1.3)  and have server.app do httpd, and use por 8001 and 8011 and reverse proxies with a webapp for filemaker as described in this link Revers proxyTutorial. 

But now I get again the error:

Calendar Publishing Error

java.sql.SQLException: Could not connect to database at http://127.0.0.1/fmi/xml/FMPXMLRESULT.xml?-db=ZuluSampleData&-lay=ProscNoSuchTable&-view: Server returned unexpected status code: 404 for URL "http://127.0.0.1/fmi/xml/FMPXMLRESULT.xml?-db=ZuluSampleData&-lay=ProscNoSuchTable&-view" message: 

Not Found

The requested URL /fmi/xml/FMPXMLRESULT.xml was not found on this server.

 

I know it is not plain vanilla, but I am sure it should be able to work..or make workable. 

The setup is quite cool and permits use of all server funcionality AND fms...hmmm.. exept.. zulu.. up to now. 

Help or hints appreciated. 

Pierre

Edited July 9, 2015 by pfroelicher
additions

[joevmartin]

Can you access Zulu over port 42424? http://localhost:42424/zulu

OSX Server and FMS server running in conjunction isn't a supported configuration for Zulu, but if you can live with accessing it over port 42424 that might be the best way to go about it.

Thanks,

Joe Martin

[pfroelicher]

Yes I can access localhost/zulu just fine with https

Or I can access fmserver.myhost:42424/zulu with http

I confess :-) that I run fmserver.myhost.com at Port 8001 and ssl at Port 8080 and access.myserver.com for for the apple server. Then I use reverse proxy as described in the tutorial. 

But somehow the zulu instalation does not like that. 

IF I can acess 42424 port...then how do I have to alter the publish script or my calendar accesses?

Thanks Pierre

[joevmartin]

At the bottom of the "Publish" script, find the script step:

Set Variable [$port; Value:If ( $installationOption = "Plugin" ; ":8040" )]

Change it to:

Set Variable [$port; Value:42424]

That should do it, run the script and let me know if that works.

Thanks,

Joe Martin