Could not publish forms after configuring Mysql with orbeon

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Could not publish forms after configuring Mysql with orbeon

Arun_ideas
I have installed Orbeon today and it worked good until i tried changing the database to Mysql.

I followed the steps that are explained here  ,after installing Mysql on my windows 7 system.

Now after doing so, i could not publish any forms , meaning i get the button disabled.

So went in and checked the Orbeon.log file and found that , it has got some trouble saving the form. I have pasted the error below. Also attached the log file for reference.orbeon.log

2011-11-30 18:27:55,246 ERROR XFormsServer  - xforms-submit-error - setting throwable {throwable: "org.orbeon.oxf.xforms.submission.XFormsSubmissionException:  (processing submission response): xforms:submission for submission id: search-submission, error code received when submitting instance: 500
null, line -1, column -1: xforms:submission for submission id: search-submission, error code received when submitting instance: 500
        at org.orbeon.oxf.xforms.submission.XFormsModelSubmission.getReplacer(XFormsModelSubmission.java:672)
        at org.orbeon.oxf.xforms.submission.RegularSubmission$1.call(RegularSubmission.java:96)
        at org.orbeon.oxf.xforms.submission.RegularSubmission$1.call(RegularSubmission.java:69)
:
:
:
:
:
:
2011-11-30 18:27:55,264 WARN  XFormsServer  - xxforms:instance() - instance not found {instance id: "fr-uuid"}
2011-11-30 18:27:55,264 WARN  XFormsServer  - xxforms:instance() - instance not found {instance id: "fr-save-locally-file-name"}
2011-11-30 18:27:55,289 WARN  XFormsServer  - xxforms:instance() - instance not found {instance id: "fr-uuid"}
2011-11-30 18:27:55,289 WARN  XFormsServer  - xxforms:instance() - instance not found {instance id: "fr-save-locally-file-name"}
2011-11-30 18:27:55,409 INFO  ProcessorService  - /fr/orbeon/builder/summary - Timing: 364 - Cache hits for cache.main: 1204, fault: 0, adds: 0, expirations: 0, success rate: 100%
2011-11-30 18:27:55,474 INFO  ProcessorService  - /xforms-server/dynamic/90e91d56c69f3934d8bd91e135d91746 - Received request
2011-11-30 18:27:55,477 INFO  ProcessorService  - /apps/fr/style/orbeon-logo-trimmed-transparent-30.png - Received request
2011-11-30 18:27:55,482 INFO  ProcessorService  - /apps/fr/style/orbeon-logo-trimmed-transparent-30.png - Timing: 5 - Cache hits for cache.main: 12, fault: 0, adds: 0, expirations: 0, success rate: 100%
2011-11-30 18:27:55,483 INFO  ProcessorService  - /xforms-server/dynamic/90e91d56c69f3934d8bd91e135d91746 - Timing: 9 - Cache hits for cache.main: 7, fault: 0, adds: 0, expirations: 0, success rate: 100%
2011-11-30 18:27:58,671 INFO  ProcessorService  - /xforms-server - Received request


Reply | Threaded
Open this post in threaded view
|

Re: Could not publish forms after configuring Mysql with orbeon

Binesh Gummadi
Is your mysql server on the same machine as your webserver? orbeon user is unable to access your mysql server. Check 'orbeon' user privileges.

2011-11-30 18:27:55,183 ERROR ProcessorService  - Exception at oxf:/apps/fr/persistence/mysql/search.xpl (executing XSLT transformation)
javax.naming.NamingException: Cannot create PoolableConnectionFactory (Access denied for user 'orbeon'@'localhost' (using password: YES))


Binesh Gummadi
Senior Software Engineer
rivetlogic
Voice +1.703.879.5740
Skype binesh.gummadi_rivetlogic
GTalk [hidden email]
Calendarbinesh gummadi's calendar



On Wed, Nov 30, 2011 at 8:20 AM, Arun_ideas <[hidden email]> wrote:
I have installed Orbeon today and it worked good until i tried changing the
database to Mysql.

I followed the steps that are explained
http://wiki.orbeon.com/forms/doc/developer-guide/form-runner/oracle-and-mysql-persistence-layers
here   ,after installing Mysql on my windows 7 system.

Now after doing so, i could not publish any forms , meaning i get the button
disabled.

So went in and checked the Orbeon.log file and found that , it has got some
trouble saving the form. I have pasted the error below. Also attached the
log file for reference.
http://orbeon-forms-ops-users.24843.n4.nabble.com/file/n4122943/orbeon.log
orbeon.log

/2011-11-30 18:27:55,246 ERROR XFormsServer  - xforms-submit-error - setting
throwable {throwable:
"org.orbeon.oxf.xforms.submission.XFormsSubmissionException:  (processing
submission response): xforms:submission for submission id:
search-submission, error code received when submitting instance: 500
null, line -1, column -1: xforms:submission for submission id:
search-submission, error code received when submitting instance: 500
       at
org.orbeon.oxf.xforms.submission.XFormsModelSubmission.getReplacer(XFormsModelSubmission.java:672)
       at
org.orbeon.oxf.xforms.submission.RegularSubmission$1.call(RegularSubmission.java:96)
       at
org.orbeon.oxf.xforms.submission.RegularSubmission$1.call(RegularSubmission.java:69)
:
:
:
:
:
:
2011-11-30 18:27:55,264 WARN  XFormsServer  - xxforms:instance() - instance
not found {instance id: "fr-uuid"}
2011-11-30 18:27:55,264 WARN  XFormsServer  - xxforms:instance() - instance
not found {instance id: "fr-save-locally-file-name"}
2011-11-30 18:27:55,289 WARN  XFormsServer  - xxforms:instance() - instance
not found {instance id: "fr-uuid"}
2011-11-30 18:27:55,289 WARN  XFormsServer  - xxforms:instance() - instance
not found {instance id: "fr-save-locally-file-name"}
2011-11-30 18:27:55,409 INFO  ProcessorService  - /fr/orbeon/builder/summary
- Timing: 364 - Cache hits for cache.main: 1204, fault: 0, adds: 0,
expirations: 0, success rate: 100%
2011-11-30 18:27:55,474 INFO  ProcessorService  -
/xforms-server/dynamic/90e91d56c69f3934d8bd91e135d91746 - Received request
2011-11-30 18:27:55,477 INFO  ProcessorService  -
/apps/fr/style/orbeon-logo-trimmed-transparent-30.png - Received request
2011-11-30 18:27:55,482 INFO  ProcessorService  -
/apps/fr/style/orbeon-logo-trimmed-transparent-30.png - Timing: 5 - Cache
hits for cache.main: 12, fault: 0, adds: 0, expirations: 0, success rate:
100%
2011-11-30 18:27:55,483 INFO  ProcessorService  -
/xforms-server/dynamic/90e91d56c69f3934d8bd91e135d91746 - Timing: 9 - Cache
hits for cache.main: 7, fault: 0, adds: 0, expirations: 0, success rate:
100%
2011-11-30 18:27:58,671 INFO  ProcessorService  - /xforms-server - Received
request
/



--
View this message in context: http://orbeon-forms-ops-users.24843.n4.nabble.com/Could-not-publish-forms-after-configuring-Mysql-with-orbeon-tp4122943p4122943.html
Sent from the Orbeon Forms (ops-users) mailing list archive at Nabble.com.


--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws




--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: Could not publish forms after configuring Mysql with orbeon

Arun_ideas
Thank you !!

I worked now ! I did not notice the Access denied error. Mysql was in the same machine.

I was under an impression that the data will be stored in tables directly, but later i understood that it still in the XML format uploaded in to Mysql , Any idea to extract the data in to csv/excel ?