Thank you very much. One tuny line in your post he...

2009-07-02T11:56:56.116-04:00

Thank you very much. One tuny line in your post helped me look like a champ. :-)

You can normally pull your username password from C:\Adobe\LiveCycle8.2\jboss\server\all\deploy\adobe_ds.xml

I had to say, Thank You.

Hello everyone, Nice to see that you have similar...

2009-05-05T08:12:00.000-04:00

Hello everyone,

Nice to see that you have similar problems.

I can not connect to my MYSQL database during the configuration of Adobe LiveCycle ES with Websphere 7.0.

I have a message saying that livecylce does not support that king of connection ... so I try to configure my JDBC Datasource for MYSQL directly in Websphere.

I use the following Jar file: mysql-connector-java-5.0.4-bin.jar
username:adobe/password
databaseName:adobe.

I get the following error:

Messages
L'opération de connexion test pour la source de données MySQL JDBC Provider - ECI1 sur le serveur server1 au noeud ECINode01 a échoué avec l'exception suivante : java.sql.SQLException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: java.net.ConnectException: Connection refused: connect STACKTRACE: java.net.SocketException: java.net.ConnectException: Connection refused: connect at java.lang.Throwable.(Throwable.java:67) at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151) at com.mysql.jdbc.MysqlIO.(MysqlIO.java:280) at com.mysql.jdbc.Connection.createNewIO(Connection.java:1774) at com.mysql.jdbc.Connection.(Connection.java:437) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268) at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:406) at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:137) at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:110) at com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource.getPooledConnection(MysqlConnectionPoolDataSource.java:57) at com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(DSConfigurationHelper.java:1608) at com.ibm.ws.security.auth.ContextManagerImpl.runAs(ContextManagerImpl.java:4279) at com.ibm.ws.security.auth.ContextManagerImpl.runAsSystem(ContextManagerImpl.java:4367) at com.ibm.ws.security.core.SecurityContext.runAsSystem(SecurityContext.java:255) at com.ibm.ws.rsadapter.DSConfigurationHelper$2.run(DSConfigurationHelper.java:1624) at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118) at
...
com.ibm.io.async.ResultHandler.complete(ResultHandler.java:202) at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:766) at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:896) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1527) ** END NESTED EXCEPTION ** DSRA0010E: Etat SQL = 08S01, Code d'erreur = 0. Consultez les journaux JVM pour obtenir plus de détails.

I don't know why. Do you have any idea ?

Thank you.

Thanks very much! I was struggling to find the id...

2009-02-24T11:06:00.000-05:00

Thanks very much! I was struggling to find the id and password to access the system tables and this post got me going. Thanks!

Thanks! I am just noticing this as well and your p...

2008-12-04T11:59:00.000-05:00

Thanks! I am just noticing this as well and your post has saved me alot of research :)

Now if I can only figure out why, on my turnkey install of LiveCycle, that the JDBC component does not return back data that is known to exist in the db. Most likely a privilege issue of some sort...

Comments on Michael Imhoff: MySQL Configuration with Adobe LiveCycle ES Turnke...

Thank you very much. One tuny line in your post he...

Hello everyone, Nice to see that you have similar...

Thanks very much! I was struggling to find the id...

Thanks! I am just noticing this as well and your p...