Hi 'bdaw'
You are wright, i made a mistake: it should be table 'roles' instead of 'UserRoles', but it doesn't solve the problem anyway. I read portal documentation once more to make sure i didn't forget anything and in the documentation it is said that 'The JBoss Application Server documentation is certainly the best reference ' for authentication configuration, so i read a part of chapter 8. http://docs.jboss.org/jbossas/jboss4guide/r5/html/ch8.chapter.html#ch8.dabaseserverloginmodule.sect I tried the dabaseserverloginmodule exemple: i created 2 tables Users and UserRoles (copy/paste of the exemple) | CREATE TABLE Users(username VARCHAR(64) PRIMARY KEY, passwd VARCHAR(64)) | CREATE TABLE UserRoles(username VARCHAR(64), userRoles VARCHAR(32)) | i inserted data | insert into UserRoles values('g.mahop','Authenticated') | insert into UserRoles values('g.mahop','Admin') | insert into Users values('g.mahop','toto') | I reconfigured the jboss-portal.sar/conf/login-config.xml file: | <login-module code="org.jboss.security.auth.spi.DatabaseServerLoginModule" | flag="required"> | <module-option name="dsJndiName">java:/PortalDS</module-option> | <module-option name="principalsQuery"> | select passwd from Users username where username=?</module-option> | <module-option name="rolesQuery"> | select userRoles, 'Roles' from UserRoles where username=?</module-option> | </login-module> | | This is what happends after i try to authenticate http://users.telenet.be/mistageorges/portalSnapshot/afterSubmit.JPG Obviously i am missing something but i can't find what. Do you see anything that seems not to be wright? I use JBOSS Portal 2.6GA (bundle version) with a mysql 4.1 database Thank for your help View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4060892#4060892 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4060892 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
