I am newbie of JBoss and Portal.
Just installed JBoss 4.0.3 + Portal 2.2.1 + MySQL 4.1
I am trying DatabaseServerLoginModule in login-config.xml.
| <application-policy name = "portal">
| <authentication>
| <login-module code =
"org.jboss.security.auth.spi.DatabaseServerLoginModule"
| flag = "required">
| <module-option name =
"unauthenticatedIdentity">guest</module-option>
| <module-option name =
"dsJndiName">java:/PortalDS</module-option>
| <module-option name = "principalsQuery">SELECT PASSWD FROM
USERS WHERE USERNAME=?</module-option>
| <module-option name = "rolesQuery">SELECT USERROLES, 'Roles'
FROM USERROLES WHERE USERNAME=?</module-option>
| </login-module>
| </authentication>
| </application-policy>
|
Tables are created as follow:
| CREATE TABLE Users (
| userName VARCHAR(64) PRIMARY KEY,
| passwd VARCHAR(64)
| );
|
| INSERT INTO Users VALUES('admin', 'admin');
|
| CREATE TABLE UserRoles (
| userName VARCHAR(32) NOT NULL,
| userRoles VARCHAR(32) NOT NULL
| );
|
| INSERT INTO UserRoles VALUES('admin', 'admin');
|
However, after i login, Error 403, unauthorized access come out.
Then, i try to update the UserRoles of admin from "admin" to "Authenticated"
INSERT INTO UserRoles VALUES('admin', 'Authenticated');
it successfully log me in after updating the table. But this time, i have no
way to get access to CMS and management pages anymore.
I guess it is related to the Roles definition. Does anyone can help on this?
After explored with JBoss portal, i just quite confused on the ModelLoginModule
and DatabaseServerLoginModule. I know ModelLoginModule is working together with
UserModule and RoleModule. Does that mean DatabaseServerLoginModule or other
loginmodule can't work with UserModule and RoleModule?
Thanks!
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3947119#3947119
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3947119
-------------------------------------------------------
All the advantages of Linux Managed Hosting--Without the Cost and Risk!
Fully trained technicians. The highest number of Red Hat certifications in
the hosting industry. Fanatical Support. Click to learn more
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
