-
1. Re: How to modify jbpm-console to make it retrieve user and role list from database?
kifayath Sep 2, 2012 6:34 AM (in response to thomas.setiabudi)Hi Thomas
I am also looking for same information.
regards
kaif
-
2. Re: How to modify jbpm-console to make it retrieve user and role list from database?
swiderski.maciej Sep 3, 2012 1:53 AM (in response to thomas.setiabudi)1 of 1 people found this helpfulYou need to configure security domain in JBoss Application Server that is used by jbpm-console. To do so, go to standalone.xml and modify section for jbpm-console security domain, for more details about configuring data base realms check JBoss AS documentation.
HTH
-
3. Re: How to modify jbpm-console to make it retrieve user and role list from database?
thomas.setiabudi Sep 7, 2012 5:11 AM (in response to swiderski.maciej)Hi Maciej Swiderski,
Thanks for pointing that.
I changed the security domain in standalone.xml
then when I want to logs in, I got this message from jbpm console
"You are not authorized to use this application"(I attached the screenshot)
How do I get my Database User and Roles authorized to login into jbpm-console?
Any help is appreciated.
Regards,
Thomas Setiabudi
-
notAuthorized.PNG 41.0 KB
-
-
4. Re: How to modify jbpm-console to make it retrieve user and role list from database?
swiderski.maciej Sep 7, 2012 5:13 AM (in response to thomas.setiabudi)you need to add one of following roles into your users to be able to access console:
- user
- admin
- manager
Only those roles are allowed to access console.
HTH
-
5. Re: How to modify jbpm-console to make it retrieve user and role list from database?
thomas.setiabudi Sep 7, 2012 5:23 AM (in response to swiderski.maciej)wow thats real quick answer!
Thank you very much, I can log in with my Database user now.
by the way, where are those authorized roles: user, admin, and manager is defined?
-
6. Re: How to modify jbpm-console to make it retrieve user and role list from database?
thomas.setiabudi Sep 7, 2012 5:44 AM (in response to swiderski.maciej)Just in case someone need to do the same thing, here are some technical detail on how to make jbpm-console get list of user and roles from database.
My Environment:
1. JBPM5.3 default installer
2. Changed the DB to SQL Server https://community.jboss.org/wiki/SetUpJBPM53ToUseMSSQLServer2008
3. change the security-domain of jbpm-console in JBoss AS 7's standalone.xml
if my database tables are:
dbo.User(UserLogon VARCHAR(64) PRIMARY KEY, Password VARCHAR(64))
dbo.UserRole (UserLogon VARCHAR(64), RoleName VARCHAR(32))
in standalone.xml look for this section:
<security-domain name="jbpm-console" cache-type="default"> <authentication> <login-module code="UsersRoles" flag="required"> <module-option name="usersProperties" value="${jboss.server.config.dir}/users.properties"/> <module-option name="rolesProperties" value="${jboss.server.config.dir}/roles.properties"/> </login-module> </authentication> </security-domain>
and change it to:
<security-domain name="jbpm-console" cache-type="default"> <authentication> <login-module code="org.jboss.security.auth.spi.DatabaseServerLoginModule" flag="required"> <module-option name="dsJndiName" value="java:jboss/datasources/jbpmDS"/> <module-option name="principalsQuery" value="select Password from dbo.User where UserLogon=?"/> <module-option name="rolesQuery" value="select RoleName, 'Roles' from dbo.UserRole where UserLogon=?"/> </login-module> </authentication> </security-domain>
Hope it can be useful
-
7. Re: How to modify jbpm-console to make it retrieve user and role list from database?
yogesh02 Aug 14, 2013 2:28 AM (in response to thomas.setiabudi)Hi Thomas,
I followed the same as you mentioned above but still getting the "Authentication Failed" on jbpm console.
I'm using jbpm5.4 with oracle database.
Please help!!
Thanks in advance.
-
8. Re: How to modify jbpm-console to make it retrieve user and role list from database?
thomas.setiabudi Aug 26, 2013 4:46 AM (in response to yogesh02)Hi Yogesh Gupta?
what is your current configuration?
-
9. Re: How to modify jbpm-console to make it retrieve user and role list from database?
yogesh02 Aug 26, 2013 7:11 AM (in response to thomas.setiabudi)Hi Thomas,
I'm using jbpm5.4 with oracle 11g.
My requirement is- I want to retrieve the users from database.
Thanks in advance....
-
10. Re: How to modify jbpm-console to make it retrieve user and role list from database?
kannan123 Nov 27, 2014 5:18 AM (in response to yogesh02)Hi
I can login with my database user but cannot assign task to the user. From many post i understood that want to register the custom UserGroupCallBack. How can i do this. I am using jbpm 5.4.
Regards
Kannan
-
11. Re: How to modify jbpm-console to make it retrieve user and role list from database?
arulbrave Dec 6, 2014 2:00 AM (in response to thomas.setiabudi)Thanks Thomas Setiabudi.. This post Realy helped me a lot.....!
-
12. Re: How to modify jbpm-console to make it retrieve user and role list from database?
abhijitkumar1903 Jul 17, 2015 7:04 AM (in response to thomas.setiabudi)Can you please help me with this JBPM6.2 to retrieve Users and Role from Mysql DB