Activiti 6 Oracle DB - superusers admin not working

[vinothnivas]

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

[abhinavmishra14]

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=jdbcracle: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=jdbcracle: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_
admin	3	NULL	Administrator	admin@activiti.alfresco.com	admin	NULL

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

login	password	first_name	last_name	email
admin	b8f57d6d6ec0a60dfe2e20182d4615b12e321cad9e2979e0b9f81e0d6eda78ad9b6dcfe53e4e22d1	NULL	Administrator	NULL