New installation, Form Runner Home won't load

If you've just setup Orbeon Forms to use MySQL, your database is empty, and
it is thus natural that the Form Runner home page has no deployed form to
show, isn't it? Try loading Form Builder, creating a form, saving it, and
publishing it. Does it then show on the Form Runner home page?

Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
--
View this message in context: http://discuss.orbeon.com/New-installation-Form-Runner-Home-won-t-load-tp4662404p4662421.html

Sent from the Orbeon Forms community mailing list mailing list archive at Nabble.com.

--
You received this message because you are subscribed to a topic in the Google Groups "Orbeon Forms" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/orbeon/7mlTi_ZVZY4/unsubscribe.
To unsubscribe from this group and all its topics, send an email to [hidden email].
To post to this group, send email to [hidden email].

The samples forms are in eXist. So indeed, if you disable the eXist
persistence layer, by setting `oxf.fr.persistence.exist.active` to `false`,
then you won't have the sample forms.

If you'd like to use the sample forms, and thus want to keep eXist, a couple
of things come to mind:

- Is your WEB-INF/exist-data writable by the user running Tomcat?
- Could you have some configuration, e.g. firewall, that prevents Orbeon
Forms from connecting to eXist or to itself via HTTP? Is this on your local
machine, or on a server? If the former, I would run Charles locally, add the
properties mentioned in the blog linked below to my properties-local.xml,
and debug what is going on.

http://blog.orbeon.com/2013/04/let-charles-help-you-monitor-http.html

Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
--
View this message in context: http://discuss.orbeon.com/New-installation-Form-Runner-Home-won-t-load-tp4662404p4662436.html

Sent from the Orbeon Forms community mailing list mailing list archive at Nabble.com.

--
You received this message because you are subscribed to a topic in the Google Groups "Orbeon Forms" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/orbeon/7mlTi_ZVZY4/unsubscribe.
To unsubscribe from this group and all its topics, send an email to [hidden email].
To post to this group, send email to [hidden email].

Hi Daniel,

So you're saying that this is with a "verbatim" install of Orbeon Forms
2016.3 CE, with no changes whatsoever to any configuration file (web.xml,
properties-local.xml…)? And in that case, you're getting an error when
loading the Form Runner home page, correct? If if that is the case, could
you delete the orbeon.log, restart Tomcat, reproduce the problem, and attach
the orbeon.log to a response?

Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
--
View this message in context: http://discuss.orbeon.com/New-installation-Form-Runner-Home-won-t-load-tp4662404p4662448.html

Sent from the Orbeon Forms community mailing list mailing list archive at Nabble.com.

--
You received this message because you are subscribed to a topic in the Google Groups "Orbeon Forms" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/orbeon/7mlTi_ZVZY4/unsubscribe.
To unsubscribe from this group and all its topics, send an email to [hidden email].
To post to this group, send email to [hidden email].

I installed orbeon-2016.3.201612302139-CE on CentOS 7 running tomcat 7, with openjdk 1.8.0_131. I added the schema and db tables for mysql and added a connector into context.xml. When I click on Form Runner Home or any of the sample forms, it sits for several minutes and then throws "There was an error running the process. Please contact the application administrator."  I've attached the logs which include the errors, but I can't find anything actionable in them. I enabled debugging for FormRunner, so there is hopefully enough information, but I don't know why it is timing out just over 2 minutes after I click. Here's a subset of the attached log. 

2017-05-02 19:17:49,101 DEBUG XFormsServer  -   start dispatching {name: "xforms-ready", target: "fr-model"}

2017-05-02 19:17:49,101 DEBUG XFormsServer  -     start handler {name: "xforms-ready", phase: "target", observer: "fr-model"}

2017-05-02 19:17:49,101 DEBUG XFormsServer  -       interpreter - start executing {action name: "xf:send"}

2017-05-02 19:17:49,103 DEBUG XFormsServer  -         start submission {id: "fr-default-submission"}

2017-05-02 19:17:49,105 DEBUG XFormsServer  -           optimized dispatching {name: "xforms-submit-serialize", target: "fr-default-sub

mission", native handlers called: "0"}

2017-05-02 19:17:49,105 DEBUG XFormsServer  -           start connecting {type: "regular"}

2017-05-02 19:19:56,654 DEBUG XFormsServer  -           end connecting {time (ms): "127549"}

2017-05-02 19:19:56,654 DEBUG XFormsServer  -           start handling result

2017-05-02 19:19:56,655 DEBUG XFormsServer  -           end handling result {time (ms): "1"}

2017-05-02 19:19:56,655 DEBUG XFormsServer  -         end submission {time (ms): "127552"}

2017-05-02 19:19:56,686 ERROR XFormsServer  -         xforms-submit-error - Connection timed out (Connection timed out)

...

2017-05-02 19:19:56,710 ERROR PageFlowControllerProcessor  - error caught {controller: "oxf:/apps/fr/page-flow.xml", method: "GET", path: "/fr/service/exist/form"}

2017-05-02 19:19:56,815 ERROR PageFlowControllerProcessor  - 

+----------------------------------------------------------------------------------------------------------------------+

|An Error has Occurred                                                                                                 |

|----------------------------------------------------------------------------------------------------------------------|

|Exception in extension function HttpStatusCodeException(code = 500, resource = None, throwable = )                    |

|----------------------------------------------------------------------------------------------------------------------|

|Application Call Stack                                                                                                |

|----------------------------------------------------------------------------------------------------------------------|

|oxf:/apps/fr/page-flow.xml                                                        |reading page view data output |  33|

|······················································································································|

|element=<service path="/fr/service/exist/form(/([^/]+)(/([^/]+))?)?" default-submission="persistence/form-instance.xml|

|view   =persistence/exist/form.xpl                                                                                    |

|----------------------------------------------------------------------------------------------------------------------|

|oxf:/apps/fr/persistence/exist/form.xpl                                           |reading processor output      |  87|

|······················································································································|

|element=<p:output name="response" ref="data"/>                                                                        |

|name   =response                                                                                                      |

|ref    =data                                                                                                          |

|----------------------------------------------------------------------------------------------------------------------|

|oxf:/ops/xforms/xforms-submission.xpl                                             |reading processor output      |  75|

|······················································································································|

|element=<p:output name="document" id="binary-document"/>                                                              |

|name   =document                                                                                                      |

|id     =binary-document                                                                                               |

|----------------------------------------------------------------------------------------------------------------------|

|----------------------------------------------------------------------------------------------------------------------|

|Exception: org.orbeon.oxf.http.HttpStatusCodeException                                                                |

|----------------------------------------------------------------------------------------------------------------------|

...

2017-05-02 19:19:56,856 ERROR XFormsServer  -             

+----------------------------------------------------------------------------------------------------------------------+

|An Error has Occurred                                                                                                 |

|----------------------------------------------------------------------------------------------------------------------|

|[No error message provided.]                                                                                          |

|----------------------------------------------------------------------------------------------------------------------|

|Application Call Stack                                                                                                |

|----------------------------------------------------------------------------------------------------------------------|

|----------------------------------------------------------------------------------------------------------------------|

|Exception: org.orbeon.oxf.xforms.action.XFormsAPI$SubmitException                                                     |

|-------------------------------------------------------------------------------------------------------

--
You received this message because you are subscribed to a topic in the Google Groups "Orbeon Forms" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/orbeon/7mlTi_ZVZY4/unsubscribe.
To unsubscribe from this group and all its topics, send an email to [hidden email].
To post to this group, send email to [hidden email].

OK Daniel, so at least you can connect to eXist. I don't think those eXist
warning are a problem. Could you try taking this  crud.xpl
<http://discuss.orbeon.com/file/n4662455/crud.xpl>  , and putting it under
WEB-INF/resources/apps/fr/persistence/exist/crud.xpl. Then try loading the
Bookshelf summary page (as you did for the log you sent earlier). In the
orbeon.log, look for `url-generator-config`. This should give us the URL
that Orbeon Forms tries to load from eXist, and this should be just before
the `java.net.ConnectException`:

http://localhost:8080/orbeon/fr/orbeon/bookshelf/summary

From the log you had earlier, I suspect that URL is:

2.mgcsops.net:8080/orbeon/exist/rest/db/orbeon/fr/orbeon/bookshelf/form/form.xhtml

This, I imagine, is the URL of your server, but Orbeon Forms can't connect
to it. Maybe, with your setup, you need to use another host name for
loopback connections, like http://localhost:8080/orbeon. You can instruct
Orbeon Forms to do so by setting `oxf.url-rewriting.service.base-uri`in your
properties-local.xml. More on this at:

https://doc.orbeon.com/configuration/properties/general.html#url-rewriting

You'll let me know if this helps!

Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
--
View this message in context: http://discuss.orbeon.com/New-installation-Form-Runner-Home-won-t-load-tp4662404p4662455.html
Sent from the Orbeon Forms community mailing list mailing list archive at Nabble.com.

--
You received this message because you are subscribed to a topic in the Google Groups "Orbeon Forms" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/orbeon/7mlTi_ZVZY4/unsubscribe.
To unsubscribe from this group and all its topics, send an email to [hidden email].
To post to this group, send email to [hidden email].

Yes Daniel: just create those "missing" directories. A number of those
"built-in" files are in jars, but you can override them by placing them in
WEB-INF/resources, under the same path. If you're interested in how this
works, the loading follows an order that is defined (and that you can
override), in your web.xml.

Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
--
View this message in context: http://discuss.orbeon.com/New-installation-Form-Runner-Home-won-t-load-tp4662404p4662462.html

Sent from the Orbeon Forms community mailing list mailing list archive at Nabble.com.

--
You received this message because you are subscribed to a topic in the Google Groups "Orbeon Forms" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/orbeon/7mlTi_ZVZY4/unsubscribe.
To unsubscribe from this group and all its topics, send an email to [hidden email].
To post to this group, send email to [hidden email].

OK Daniel, so at least you can connect to eXist. I don't think those eXist
warning are a problem. Could you try taking this  crud.xpl
<http://discuss.orbeon.com/file/n4662455/crud.xpl>  , and putting it under
WEB-INF/resources/apps/fr/persistence/exist/crud.xpl. Then try loading the
Bookshelf summary page (as you did for the log you sent earlier). In the
orbeon.log, look for `url-generator-config`. This should give us the URL
that Orbeon Forms tries to load from eXist, and this should be just before
the `java.net.ConnectException`:

http://localhost:8080/orbeon/fr/orbeon/bookshelf/summary

From the log you had earlier, I suspect that URL is:

2.mgcsops.net:8080/orbeon/exist/rest/db/orbeon/fr/orbeon/bookshelf/form/form.xhtml

This, I imagine, is the URL of your server, but Orbeon Forms can't connect
to it. Maybe, with your setup, you need to use another host name for
loopback connections, like http://localhost:8080/orbeon. You can instruct
Orbeon Forms to do so by setting `oxf.url-rewriting.service.base-uri`in your
properties-local.xml. More on this at:

https://doc.orbeon.com/configuration/properties/general.html#url-rewriting

You'll let me know if this helps!

Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
--
View this message in context: http://discuss.orbeon.com/New-installation-Form-Runner-Home-won-t-load-tp4662404p4662455.html
Sent from the Orbeon Forms community mailing list mailing list archive at Nabble.com.

--
You received this message because you are subscribed to a topic in the Google Groups "Orbeon Forms" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/orbeon/7mlTi_ZVZY4/unsubscribe.
To unsubscribe from this group and all its topics, send an email to [hidden email].
To post to this group, send email to [hidden email].

Daniel,

I'm not sure either. Could you please also attach the new orbeon.log you get
after adding the crud.xpl? And have you tried adding the
`oxf.url-rewriting.service.base-uri`property in your properties-local.xml,
as mentioned earlier?

Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
--
View this message in context: http://discuss.orbeon.com/New-installation-Form-Runner-Home-won-t-load-tp4662404p4662466.html

Sent from the Orbeon Forms community mailing list mailing list archive at Nabble.com.

--
You received this message because you are subscribed to a topic in the Google Groups "Orbeon Forms" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/orbeon/7mlTi_ZVZY4/unsubscribe.
To unsubscribe from this group and all its topics, send an email to [hidden email].
To post to this group, send email to [hidden email].