Hi all, Please help me with this issue as I am completely puzzled...
Some background: I am using mysql, jboss 4 and the org.jboss.security.auth.spi.DatabaseServerLoginModule . Everything works fine until there is a new requirement in my program. The status of the user must not be 'NEW' in order to pass the login, so I added "<module-option name="principalsQuery">SELECT u.PASSWORD FROM user u WHERE u.USERNAME=? and u.status <> 'NEW'</module-option>" Which works ok for the first time, i.e. if I have just started the server and user status == 'NEW', it fails and works perfectly, but if the user successfully logged in the first time, then I changed the status of the user to 'NEW' and logoff the user and try to log in again, it login successfully?? It seems that JBoss is caching the login details?? Or am I setting things wrong?? Many thx Kevin View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3914950#3914950 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3914950 ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
