I tried your example and it did not work even in my case. Did some changes and
it started working. Here's what i did:
1) Change the schema of the tables:
User table:
|
| CREATE TABLE `users` (
| `userid` varchar(255) NOT NULL default '',
| `Password` varchar(255) NOT NULL default '',
| PRIMARY KEY (`userid`)
| ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
| Roles table:
|
| CREATE TABLE `roles` (
| `roleid` varchar(255) NOT NULL default '',
| `userid` varchar(255) NOT NULL default '',
|
| PRIMARY KEY (`roleid`)
| ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
| Data in the tables:
|
| insert into users values ('user','user');
| insert into users values ('Admin','admin');
|
| insert into roles values('Admin','Admin');
| insert into roles values('user','User');
|
2) Change the contents in the login-config.xml to:
<application-policy name = "jaastest">
| <authentication>
| <login-module code =
"org.jboss.security.auth.spi.DatabaseServerLoginModule"
| flag = "required">
| <module-option name =
"dsJndiName">java:/jaastestDatasource</module-option>
| <module-option name = "principalsQuery">select Password
from users where userid=?</module-option>
| <module-option name = "rolesQuery">select roleid, 'Roles' from
Roles where userid=?</module-option>
| </login-module>
| </authentication>
| </application-policy>
|
Thats it. No changes to any other files. This worked for me.
Let us know, if you still have any issues.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3983291#3983291
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3983291
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user
