Tuesday, November 11, 2008

MySQL Configuration with Adobe LiveCycle ES Turnkey

I just did a fresh install of the Adobe LiveCycle ES Update 1 Turnkey (8.2) and ran into an issue when trying to connect to the MySQL instance it installs using the basic MySQL GUI tools. If you receive "either the server service or the configuration file could not be found. startup variables and service section are therefore disabled" when opening the MySQL GUI Administrator tools, then check out the following steps:
  • Backup C:\Adobe\LiveCycle8.2\mysql\my.ini
  • Launch the MySQL Administrator
  • When prompted to sign in, hold the Ctrl key and click the "Skip" button that appears
  • Click on Startup Variables, and hit "Choose Option File" at the bottom and select C:\Adobe\LiveCycle8.2\mysql\my.ini
  • Then go back to the Server Control and make sure that "Config Filename" is correct under the "Configure Service" tab.

You should then be able to stop and start the services and connect with the correct password. You can normally pull your username password from C:\Adobe\LiveCycle8.2\jboss\server\all\deploy\adobe_ds.xml if you're not sure what it is after going through the generic install.

This however doesn't solve all my issues, as my "default" account doesn't have the same privileges as say the root account would, but then again, the root account doesn't seem to exist...

http://bugs.mysql.com/bug.php?id=24824

4 comments:

  1. 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...

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

    ReplyDelete
  3. Anonymous8:12 AM

    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.

    ReplyDelete
  4. Anonymous11:56 AM

    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.

    ReplyDelete