users@glassfish.java.net

Re: Can't get JDBCRealm to work with MySQL

From: <glassfish_at_javadesktop.org>
Date: Mon, 23 Apr 2007 09:28:44 PDT

Hi Rick,

I'm having the exact same problem.
You said you thought you found the sollution, but I don't believe that's it.
The group-table element is not shown in the gui and is indeed a bug, but it is saved in domain.xml, so it should work.

My datasource works, but just like you I can't get the authentication to work.

This is the content of my domain.xml file

        <auth-realm classname="com.sun.enterprise.security.auth.realm.jdbc.JDBCRealm" name="telemetry">
          <property name="jaas-context" value="jdbcRealm"/>
          <property name="datasource-jndi" value="jdbc/telemetrydb"/>
          <property name="user-table" value="users"/>
          <property name="user-name-column" value="userid"/>
          <property name="password-column" value="password"/>
          <property name="group-table" value="groups"/>
          <property name="group-name-column" value="groupid"/>
        </auth-realm>

My web.xml en sun-web.xml files seem to be correct. I've lost 2 days already trying to get this to work :-/

Has somebody done this before?

Grtz,

Kristof Taveirne
[Message sent by forum member 'kristof_taveirne' (kristof_taveirne)]

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