-
1. Re: Problem creating security-domain with jboss-cli (wildfly 12)
simkam Oct 31, 2018 7:41 AM (in response to r.fernandon)Hi,
putting the entire query to quotes should work.
"rolesQuery"=> "SELECT name, 'Roles' FROM user_x_roles WHERE username = ?",\
-
2. Re: Problem creating security-domain with jboss-cli (wildfly 12)
r.fernandon Oct 31, 2018 12:52 PM (in response to simkam)hello Martin, now I have this error:
macbook-ricardo:bin r.fernandon$ ./jboss-cli.sh --connect --command="/subsystem=security/security-domain=App/authentication=classic/login-module=Database:add(code=Database,flag=required,module-options=[("dsJndiName"=>"java:jboss/datasources/DS"),("principalsQuery"=>"select pass from user where username=?"),("rolesQuery"=>"select name, 'Roles' from user_x_roles where username=?"),("unauthenticatedIdentity"=>"guest")])"
'pass' is assumed to be a command(s) but the commands to execute have been specified by another argument: [/subsystem=security/security-domain=App/authentication=classic/login-module=Database:add(code=Database,flag=required,module-options=[(dsJndiName=>java:jboss/datasources/DS),(principalsQuery=>select]
-
3. Re: Problem creating security-domain with jboss-cli (wildfly 12)
simkam Nov 1, 2018 9:11 AM (in response to r.fernandon)just escape all inner quotes in command, this sequence works for me:
./jboss-cli.sh --connect --command="/subsystem=security/security-domain=App:add()"
./jboss-cli.sh --connect --command="/subsystem=security/security-domain=App/authentication=classic:add()"
./jboss-cli.sh --connect --command="/subsystem=security/security-domain=App/authentication=classic/login-module=Database:add(code=Database,flag=required,module-options=[(\"dsJndiName\"=>\"java:jboss/datasources/DS\"),(\"principalsQuery\"=>\"select pass from user where username=?\"),(\"rolesQuery\"=>\"select name, 'Roles' from user_x_roles where username=?\"),(\"unauthenticatedIdentity\"=>\"guest\")])"
-
4. Re: Problem creating security-domain with jboss-cli (wildfly 12)
r.fernandon Nov 2, 2018 7:00 PM (in response to simkam)Martin, It worked!
tks