users@glassfish.java.net

JDBCRealm problem

From: <glassfish_at_javadesktop.org>
Date: Sat, 24 Jan 2009 06:18:31 PST

Hello,
i'm using glassfish bundle with netbeans 6.5 when i tried to configure jdbcRealm with glassfish, i receive this error:
[i]PWC1412 : WebModule[/netescape] ServletContext.log() :HibernateFilter:DoAfterProcessing
PWC1412 : WebModule[/netescape] ServletContext.log() :HibernateFilterLong:DoAfterProcessing
        [LoginContext]: original security exception with detail msg replaced by new exception with empty detail msg
        [LoginContext]: original security exception: com.sun.enterprise.security.LoginException: Échec de la connexion JDBC pour carlos.
        [LoginContext]: login REQUIRED failure
        [LoginContext]: abort ignored
SEC5046 : Audit : Authentification refusée pour [carlos].
Web login failed: Login failed: javax.security.auth.login.LoginException: Security Exception
PWC1412 : WebModule[/netescape] ServletContext.log() :HibernateFilterLong:doFilter()
PWC1412 : WebModule[/netescape] ServletContext.log() :HibernateFilterLong:DoBeforeProcessing
PWC1412 : WebModule[/netescape] ServletContext.log() :HibernateFilter:doFilter()
PWC1412 : WebModule[/netescape] ServletContext.log() :HibernateFilter:DoBeforeProcessing
PWC1412 : WebModule[/netescape] ServletContext.log() :HibernateFilter:DoAfterProcessing
PWC1412 : WebModule[/netescape] ServletContext.log() :HibernateFilterLong:DoAfterProcessing
 [/i]
this is my domain.xml config:
[i]<auth-realm classname="com.sun.enterprise.security.auth.realm.jdbc.JDBCRealm" name="netescape-realm">
          <property name="jaas-context" value="jdbcRealm"/>
          <property name="datasource-jndi" value="jdbc/authen"/>
          <property name="user-table" value="utilisateur"/>
          <property name="user-name-column" value="identifiant"/>
          <property name="password-column" value="password"/>
          <property name="group-table" value="dictionnaire"/>
          <property name="group-name-column" value="nom"/>
</auth-realm>[/i]

this is the sql script using for the two tables Utilisateur and Dictionnaire:

[i]CREATE TABLE dictionnaire
(
  dictionnaireid bigint NOT NULL DEFAULT nextval('sequenceur'::regclass),
  dictionnaire boolean DEFAULT true,
  nom text,
  description text,
  "version" timestamp without time zone,
  CONSTRAINT pk_dictionnaire PRIMARY KEY (dictionnaireid)
)
[/i]
[i]CREATE TABLE utilisateur
(
  personneid bigint NOT NULL,
  dictionnaireid bigint,
  initiale text,
  signature bytea,
  "password" text,
  identifiant text,
)
[/i]
 
i don't if there are constraints with table when using jdbcRealm, because it's doesn't works.
thank you in advance.
[Message sent by forum member 'kokumbo' (kokumbo)]

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