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>
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');
INSERT INTO UserRoles VALUES('admin', 'Authenticated');