Activiti 6 Oracle DB - superusers admin not working

cancel
Showing results for 
Search instead for 
Did you mean: 
vinothnivas
Member II

Activiti 6 Oracle DB - superusers admin not working

Hi,

I have installed activiti 6 community edition. It was working fine with in memory h2 db. I changed to Oracle DB and restarted the server. I am able to login with default users like kermit,gonzo,fozzie. But unable to login with admin/test superusers. Please let me know what could be the issue here.

Thanks,

Vinoth

1 Reply
abhinavmishra14
Advanced

Re: Activiti 6 Oracle DB - superusers admin not working

It should work. Default administrator user and password for both apps are: admin|admin

Cross check if you have following configs right:

# Oracle10g DB Config, ojdbc driver for oracle is required as it doesn't ship ootb with activiti-app
datasource.driver=oracle.jdbc.driver.OracleDriver
datasource.url=jdbcSmiley Surprisedracle:thin:@localhost:1521:activiti6ui
#Created user and password after installation
datasource.username=activiti
datasource.password=activiti
hibernate.dialect=org.hibernate.dialect.Oracle10gDialect

hibernate.show_sql=true
#hibernate.generate_statistics=false

If you are using activiti-admin, then check the configs for this app as well:

# Oracle10g DB Config, ojdbc driver for oracle is required as it doesn't ship ootb with activiti-admin
datasource.driver=oracle.jdbc.driver.OracleDriver
datasource.url=jdbcSmiley Surprisedracle:thin:@localhost:1521:activitiadmin
#Created user and password after installation
datasource.username=activiti
datasource.password=activiti

hibernate.dialect=org.hibernate.dialect.Oracle10gDialect

Restart the application server and tail the log to see if everything looks correct.  Once server starts up successfully, you can connect to DB and check the 'acti_id_user' table in 'activiti6ui' database to see the values are populated properly. You can see user and password in the table. You can change/update if needed.

id_rev_first_last_email_pwd_picture_id_
admin3NULLAdministratoradmin@activiti.alfresco.comadminNULL

Same way you can check the 'user_info' table for 'activitiadmin' database 

loginpasswordfirst_namelast_nameemail
adminb8f57d6d6ec0a60dfe2e20182d4615b12e321cad9e2979e0b9f81e0d6eda78ad9b6dcfe53e4e22d1NULLAdministratorNULL
~Abhinav
(ACSCE, AWS SAA, Azure Admin)