users@glassfish.java.net

Re: Glassfish and setting up FORM based authentication

From: <glassfish_at_javadesktop.org>
Date: Thu, 31 Jul 2008 07:04:30 PDT

I now have this in my logging:

[#|2008-07-31T15:40:52.044+0200|INFO|sun-appserver9.1|javax.enterprise.system.core.security|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;marcel;|SEC5046: Audit: Authentication refused for [marcel].|#]

[#|2008-07-31T15:40:52.044+0200|FINEST|sun-appserver9.1|javax.enterprise.system.core.security|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8080-0;ClassName=com.sun.enterprise.security.auth.LoginContextDriver;MethodName=doPasswordLogin;_RequestID=5a89e3ae-884b-4bbd-a80c-1b0e3479a31e;|doPasswordLogin fails

I have this in my database:
SQL> describe users
 Name Null? Type
 ----------------------------------------- -------- ----------------------------
 USERNAME NOT NULL VARCHAR2(64)
 PASSWORD NOT NULL VARCHAR2(64)

SQL> describe groups
 Name Null? Type
 ----------------------------------------- -------- ----------------------------
 ID NOT NULL NUMBER
 USERNAME NOT NULL VARCHAR2(64)
 GROUPNAME NOT NULL VARCHAR2(64)

SQL> select * from users;

USERNAME
----------------------------------------------------------------
PASSWORD
----------------------------------------------------------------
marcel
202cb962ac59075b964b07152d234b70
SQL> select * from groups;

        ID USERNAME
---------- ----------------------------------------------------------------
GROUPNAME
----------------------------------------------------------------
         1 marcel
USERS

I login with username "marcel" and password "123".
I've made a MD5 of 123 and put that in the users table under password.
[Message sent by forum member 'marcelkoopman' (marcelkoopman)]

http://forums.java.net/jive/thread.jspa?messageID=290651