Hi there,
I just downloaded a wildfly server, but i can’t login using the demo user.
I checked the h2 database, but there are no users in there.
just empty tables
I got the zip from here:
https://downloads.camunda.cloud/release/camunda-bpm/wildfly/7.13/
server.log (78.1 KB)
Is there a script to create a user?
Or can I add a user to the database?
Thx in advance.
Nick
Hi @Nick,
after checking the logs it seems that everything happend as expected.
During the deployment of the invoice example the users are created: demo, john, peter and mary:
2020-06-26 11:56:17,105 INFO [org.camunda.bpm.container.impl.jboss.service.ProcessApplicationDeploymentService] (ServerService Thread Pool -- 80) Deployment summary for process archive 'camunda-invoice' of process application 'camunda-invoice':
invoiceBusinessDecisions.dmn
invoice.v2.bpmn
2020-06-26 11:56:17,803 INFO [org.camunda.bpm.application] (ServerService Thread Pool -- 80) ENGINE-07021 ProcessApplication 'camunda-invoice' registered for DB deployments [a9557adc-b78b-11ea-85d8-605718e7eb69, a8fe330e-b78b-11ea-85d8-605718e7eb69]. Will execute process definitions
invoice[version: 2, id: invoice:2:a95ca6cf-b78b-11ea-85d8-605718e7eb69]
ReviewInvoice[version: 1, id: ReviewInvoice:1:a9280238-b78b-11ea-85d8-605718e7eb69]
invoice[version: 1, id: invoice:1:a926f0c6-b78b-11ea-85d8-605718e7eb69]
Deployment does not provide any case definitions.
2020-06-26 11:56:17,926 INFO [org.camunda.bpm.example.invoice.InvoiceProcessApplication] (MSC service thread 1-8) No new instances of Invoice Receipt version 1 started, there are 3 instances running
2020-06-26 11:56:17,962 INFO [org.camunda.bpm.example.invoice.InvoiceProcessApplication] (MSC service thread 1-8) No new instances of Invoice Receipt version 2 started, there are 3 instances running
2020-06-26 11:56:18,101 INFO [org.jboss.as.server] (ServerService Thread Pool -- 46) WFLYSRV0010: Deployed "camunda-welcome.war" (runtime-name : "camunda-welcome.war")
2020-06-26 11:56:18,107 INFO [org.jboss.as.server] (ServerService Thread Pool -- 46) WFLYSRV0010: Deployed "camunda-webapp-jboss-7.13.0.war" (runtime-name : "camunda-webapp-jboss-7.13.0.war")
2020-06-26 11:56:18,109 INFO [org.jboss.as.server] (ServerService Thread Pool -- 46) WFLYSRV0010: Deployed "camunda-h2-webapp-7.13.0.war" (runtime-name : "camunda-h2-webapp-7.13.0.war")
2020-06-26 11:56:18,112 INFO [org.jboss.as.server] (ServerService Thread Pool -- 46) WFLYSRV0010: Deployed "camunda-example-invoice-7.13.0.war" (runtime-name : "camunda-example-invoice-7.13.0.war")
Have you tried demo/demo for login? Where did you check the users?
Cheers, Ingo
Hi Ingo,
Thx for the quick response.
I tried the demo user on all the applications shown on the welcome screen.
None of them work:
Login Failed : Wrong credentials, locked user or missing access rights to application
I could login to the h2 database with the sa user with this url:
http://localhost:8080/h2/h2
And i ran this query:
SELECT * FROM ACT_ID_USER
No rows returned.
Hi @Nick,
that’s a difficult case.
I would delete the database file by dropping the folder server\wildfly-19.0.0.Final\bin\camunda-h2-dbs and start again.
Hope this helps, Ingo
I just tried what you recommended, but that doesn’t work either.
I am using an openJDK version, whould that be the problem?
I don’t really see any errors that would indicate such a problem, but maybe.
I tried the add-user batchfile, but that doesn’t seem to do anything in the database.
Is there any other way to add users to the database?
I’d rather use a postgresql db anyway.
Kind regards,
Nick
Hi @Nick,
OpenJDK is fine. The supported (= tested) environments are listed here: https://docs.camunda.org/manual/develop/introduction/supported-environments/#java-runtime.
In realworld scenarios a lot of our users connect Camunda BPM to an existing LDAP Server. Then you can’t create the users with admin as the LDAP plugin is a ReadOnlyIdentityProvider: https://docs.camunda.org/manual/develop/user-guide/process-engine/identity-service/#the-ldap-identity-service.
You can create users with this REST endpoint: https://docs.camunda.org/manual/develop/reference/rest/user/post-create/
Or with the Java API. Here is the code, where the demo user is created: https://github.com/camunda/camunda-bpm-platform/blob/master/examples/invoice/src/main/java/org/camunda/bpm/example/invoice/DemoDataGenerator.java#L78-L83.
Are the other tables empty as well? You should find records in ACT_RE_PROCDEF and ACT_GE_PROPERTY and others.
Hope that helps, Ingo
Hmm, ok this is weird.
I just tried FireFox instead of Chrome and it works?!?
Also that H2 database is a little strange, because you can login to all kinds of different databases. h2, test, process-engine.
And then i can see all the tables, but only if i use: jdbc:h2:./camunda-h2-dbs/process-engine
Only then can I see all the records of data.
Oh well, I have a working instance.
Thanks for the help and sorry for the inconveniance.
I think i’ll reinstall chrome. I also have some other strange issues with it.
Kind regards,
Nick