Camunda(jboss) with mysql - Need Help

[jhansi]

Hi,

I have downloaded and installed camunda-bpm-jboss-7.2.0-alpha1.tar. I am trying to connect mysql database .Below are the steps i have followed to do so.

1.  I have created folder com/mysql/jdbc/main under camunda-jboss home directory and has placed module.xml(content below mentioned) and mysql-connector-java-5.1.17-bin.jar file.

Module.xml

<?xml version="1.0" encoding="UTF-8"?>

<module xmlns="urn:jboss:module:1.4" name="com.mysql.jdbc">

  <resources>

     <resource-root path="mysql-connector-java-5.1.17-bin.jar"/>              

  </resources>

  <dependencies>

     <module name="javax.api"/>

  </dependencies>

</module>

2.Datasources and xa datasources mentioned in standalone.xml,domain.xml .I have attachedthe files above for your reference.

In my server log file i have noticed some missing dependencies.I have attached file above for your reference.

Please guide me on how to proceed further.

Thanks,

jhansi.

[jhansi]

Hi,

Now i am able to connect to mysql. But i got one more issue while integrating openldap through camunda. Please find the attached standalone.xml file where i have enabled ldap integration code.

when i am trying to login through camunda with login credentials username-jhansi and password - jhansi i am not able to login and the error message it is showing in the screen is  Login Failed: Wrong credentials or missing access rights to application.

In server logs it is showing error.I have attached server log file and ldap tree screen shots for your reference.Please help me out to solve the same.

Thanks,

jhansi.

[kpmg.t...@gmail.com]

Am Samstag, 16. August 2014 08:35:40 UTC+2 schrieb jhansi:
> Hi Jhansi,

i have the same problem, i want to configure Jboss 7.2 with mysql and get some problems due to the dependencies:

"JBAS014775: New missing/unsatisfied dependencies:
service jboss.jdbc-driver.mysql (missing) dependents: [service jboss.data-source.java:jboss/datasources/MySqlDS, service jboss.driver-demander.java:jboss/datasources/MySqlDS]"

Can you please tell how did you configure the file in Jboss.

thanks

Marcel

[Christian Lipphardt]

Hi Marcel,

Please see [1] for a great guide on how to configure a mysql or postgresql database inside JBoss AS 7.

Cheers,

Christian

[1] http://wiki.aiwsolutions.net/2014/02/12/add-mysql-and-postgresql-driver-for-jboss-7/

[kpmg.t...@gmail.com]

Am Freitag, 26. September 2014 11:05:04 UTC+2 schrieb Christian Lipphardt:
Hi Christian,

thanks for replying. The article was important. I can load the Driver. My mistake: they are a difference between the configuration on the module.xml for Jboss 7.1.0 Final and Jboss 7.2.0. Please refer you on this article:

https://developer.jboss.org/wiki/JBossAS720-JavaEEApplicationDevelopment-02HowToConfigureMySqlDataSource

Cheers

Marcel

[kstoe...@gmail.com]

Hi,

I also have an Issue with JBoss and MySQL. I followed the above mentioned hints but I could not get it running.

I use the camunda-bpm-jboss-7.2.0 Server.

I created the folders and the files:
camunda-bpm-jboss-7.2.0\server\jboss-as-7.2.0.Final\modules\system\layers\base\com\mysql\main
- module.xml
- and added the mysql-connector-java-5.1.34-bin.jar
I manually created the mysql-connector-java-5.1.34-bin.jar.index file as supposed by [1]

My module.xml contains the following:
<code>

<?xml version="1.0" encoding="UTF-8"?>

<module xmlns="urn:jboss:module:1.1" name="com.mysql">
<resources>
<resource-root path="mysql-connector-java-5.1.34-bin.jar"/>

</resources>
<dependencies>
<module name="javax.api"/>
</dependencies>
</module>

<code>

My standalone.xml is configured the following way:

<code>
<subsystem xmlns="urn:jboss:domain:datasources:1.1">
<datasources>
<datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true">
<connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1</connection-url>
<driver>h2</driver>
<security>
<user-name>sa</user-name>
<password>sa</password>
</security>
</datasource>
<datasource jta="true" jndi-name="java:jboss/datasources/ProcessEngine" pool-name="ProcessEngine" enabled="true" use-java-context="true" use-ccm="true">
<connection-url>jdbc:mysql://localhost:3306/camundaTestDB</connection-url>
<driver>com.mysql</driver>
<security>
<user-name>camundadbuser</user-name>
<password>camundapw</password>
</security>
</datasource>
<drivers>
<driver name="com.mysql" module="com.mysql">
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
</driver>
<driver name="h2" module="com.h2database.h2">
<xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
</driver>
</drivers>
</datasources>
</subsystem>
<code>

When I start the Server I get the following error(s):

13:58:09,791 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 26) JBAS014612: Operation ("add") failed - address: ([
("subsystem" => "datasources"),
("jdbc-driver" => "com_mysql")
]): org.jboss.msc.service.DuplicateServiceException: Service jboss.jdbc-driver.com_mysql is already registered

13:58:10,614 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) "JBAS014784: Failed executing subsystem datasources boot operations"

JBAS014775: New missing/unsatisfied dependencies:
service jboss.naming.context.java.jboss.datasources.ProcessEngine (missing) dependents: [service org.camunda.bpm.platform.process-engine.default]

Can somebody tell me what I did wrong?
Thank you!
Karl-Heinz


[1] https://developer.jboss.org/wiki/JBossAS720-JavaEEApplicationDevelopment-02HowToConfigureMySqlDataSource

[kstoe...@gmail.com]

the <code> tags are not in the files, I used them for marking the code inside the post

[Christian Lipphardt]

Hi,

Remove the *.index file, it is not needed. Dunno who wrote that. Put the
Check for typos in module.xml, path, standalone.xml regarding your changes.

Basically the "name"-attribute in the modules.xml must match the value
of the <driver module="your_module_name">.
<driver name="your_driver_name"> must match the
<datasource><driver>your_driver_name</driver>...

Cheers,
Christian

[kstoe...@gmail.com]

Hi Christian,

I removed the index file, and I checked all the names and they are all the same now:
standalone.xml

<drivers><driver name="com.mysql" module="com.mysql">

<datasource><driver>com.mysql</driver>
module.xml

<module xmlns="urn:jboss:module:1.1" name="com.mysql">

Here I get the same error again:
18:07:48,629 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 26) JBAS010404: Deploying non-JDBC-compliant driver class com.mysql.fabric.jdbc.FabricMySQLDriver (version 5.1)
18:07:48,722 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 26) JBAS014612: Operation ("add") failed - address: ([

("subsystem" => "datasources"),

("jdbc-driver" => "com.mysql")

]): org.jboss.msc.service.DuplicateServiceException: Service jboss.jdbc-driver.com_mysql is already registered

Then I also tried a different version:
standalone.xml
<drivers><driver name="mysql" module="com.mysql">
<datasource><driver>mysql</driver>
module.xml

<module xmlns="urn:jboss:module:1.1" name="com.mysql">

18:06:00,077 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 26) JBAS010404: Deploying non-JDBC-compliant driver class com.mysql.jdbc.Driver (version 5.1)
18:06:00,077 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 26) JBAS010404: Deploying non-JDBC-compliant driver class com.mysql.fabric.jdbc.FabricMySQLDriver (version 5.1)
18:06:00,093 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 26) JBAS014612: Operation ("add") failed - address: ([

("subsystem" => "datasources"),

("jdbc-driver" => "mysql")
]): org.jboss.msc.service.DuplicateServiceException: Service jboss.jdbc-driver.mysql is already registered

It seems that the jdbc is registered twice but I do not know why and where. And I also do not know where he got the "com_mysql" from I never entered it like this...
I also tried to download the camunda-bpm-jboss file again but it is still the same. :(

Please help!
Thanks
Karl-Heinz

[Christian Lipphardt]

Hi,

I remember now. There is an issue with the newer mysql drivers. They contain two jdbc driver definitions inside and jboss tries to install them both but fails. I know that version 5.1.21 is working.

Cheers,
Christian

--
You received this message because you are subscribed to the Google Groups "camunda BPM users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to camunda-bpm-us...@googlegroups.com.
To post to this group, send email to camunda-...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/camunda-bpm-users/e2d78e94-a63f-4e7a-8c0b-6ab178ad7734%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[kstoe...@gmail.com]

Hi Christian,

now I tried the driver version 5.1.21 and this one works fine.
Thank you so much.

Greetings,
Karl-Heinz