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

Reply via email to