There was an error communicating with the database. Please contact the application administrator.

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

There was an error communicating with the database. Please contact the application administrator.

ammarwa
Hi , i am new in orbeon
i just running Bitnami Tomcat 8.5.24-2 in the google Cloud , but after i do
every thing in Orbeon Doc , i still get , "There was an error communicating
with the database. Please contact the application administrator."

My Config like following :

in server.xml

<Server port="8005" shutdown="SHUTDOWN">
  <Listener className="org.apache.catalina.startup.VersionLoggerListener"/>
 
 
  <Listener className="org.apache.catalina.core.AprLifecycleListener"
SSLEngine="on"/>
 
  <Listener
className="org.apache.catalina.core.JreMemoryLeakPreventionListener"/>
  <Listener
className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"/>
  <Listener
className="org.apache.catalina.core.ThreadLocalLeakPreventionListener"/>

 
<GlobalNamingResources>
    <Resource
                name="jdbc/mysql"
                    driverClassName="com.mysql.jdbc.Driver"
                        auth="Container"
                            type="javax.sql.DataSource"
                                initialSize="3"
                                    maxActive="10"
                                        maxIdle="10"
                                            maxWait="30000"
                                               
poolPreparedStatements="true"
    testOnBorrow="true"
    validationQuery="select 1"
        username="orbeon"
            password="orbeon"
               
url="jdbc:mysql://localhost:3306/orbeon?useUnicode=true&amp;characterEncoding=UTF8"/>
  </GlobalNamingResources>


<Service name="Catalina">




   
    <Connector port="8009" protocol="AJP/1.3" redirectPort="8443"/>


   

   
    <Engine name="Catalina" defaultHost="localhost">

     
     

     
      <Realm className="org.apache.catalina.realm.LockOutRealm">
       
        <Realm className="org.apache.catalina.realm.UserDatabaseRealm"
resourceName="UserDatabase"/>
      </Realm>

<Host name="localhost" appBase="webapps" unpackWARs="true" autoDeploy="true"
startStopThreads="-1">

       
       

       
        <Valve
className=&quot;org.apache.catalina.valves.AccessLogValve&quot;
directory=&quot;logs&quot; prefix=&quot;localhost_access_log$
        &lt;property as=&quot;xs:string&quot;
                         
name=&quot;oxf.fr.persistence.provider.orbeon.library.*&quot;
                                    value=&quot;mysql&quot;/>
      </Host>
    </Engine>
  </Service>
</Server>

########################################
/opt/bitnami/apache-tomcat/webapps/orbeon/WEB-INF/resources/config

<properties xmlns:xs="http://www.w3.org/2001/XMLSchema"
                    xmlns:oxf="http://www.orbeon.com/oxf/processors">
                        <property as="xs:string"
                                         
name="oxf.fr.persistence.provider.*.*.*"
                                                    value="mysql"/>

                                            </properties>



--
Sent from: http://discuss.orbeon.com/

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
Reply | Threaded
Open this post in threaded view
|

Re: There was an error communicating with the database. Please contact the application administrator.

Alessandro  Vernet
Administrator
Hi Ammar,

You put the `Resource` inside `GlobalNamingResources`. Instead, could you
try creating a `Context` for Orbeon Forms, and adding the `Resource` inside
that `Context`. You can find an example thereof in the section linked below.

https://doc.orbeon.com/installation/tomcat.html#custom-context-within-serverxml

You'll let me know if this helps. If you're still having an issue with this,
could you stop Tomcat, remove your `orbeon.log`, restart Tomcat, reproduce
the problem, and attach your new `orbeon.log` to your response?

Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
--
Sent from: http://discuss.orbeon.com/

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
Reply | Threaded
Open this post in threaded view
|

Re: There was an error communicating with the database. Please contact the application administrator.

Alessandro  Vernet
Administrator
Hi Ammar,

Did you get a chance to try putting the `Resource` inside the `Context`, and
if you did, did that solve the problem you were seeing with MySQL?

Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
--
Sent from: http://discuss.orbeon.com/

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet