users@glassfish.java.net

Re: How to: use Form based auth via JDBCRealm:oracle in Glassfish 3.0

From: Felipe Gaścho <fgaucho_at_gmail.com>
Date: Fri, 15 Jan 2010 13:00:30 +0100

if you are on Windows, you can find the same commands translated to
windows here:

http://kenai.com/projects/puj/sources/arena/content/arena-puj/setup.bat

2010/1/15 Felipe Gaścho <fgaucho_at_gmail.com>:
> Realm jdbc_wonderland does not exists
>
> something is definitely wrong with the realm configuration
>
> hint: you can use the asadmin CLI to try to create the jdbc realm manually.
>
> open a console and then type
>
> asadmin create-jdbc-connection-pool --datasourceclassname
> com.mysql.jdbc.jdbc2.optional.MysqlDataSource --restype
> javax.sql.ConnectionPoolDataSource --property
> "User=$MYSQL_USER:Password=$MYSQL_PASSWORD:URL=$DB_URL" jdbc/arenaPool
>
> asadmin --user=$ASADMIN_USER create-jdbc-resource --connectionpoolid
> jdbc/arenaPool jdbc/arena
>
> asadmin create-auth-realm
> --classname=com.sun.enterprise.security.auth.realm.jdbc.JDBCRealm
> --property group-table=PUJ_AUTH_GROUPTABLE:user-table=PUJ_AUTH_USERTABLE:user-name-column=LOGIN:password-column=PASSWORD:group-name-column=GROUPID:jaas-context=jdbcRealm:datasource-jndi=jdbc/arena:digest-algorithm=MD5:charset=utf8
> arena-realm
>
>
> of course, replacing the names by your local ones..
>
> than you try again........
>



-- 
------------------------------------------
   Felipe Gaścho
   10+ Java Programmer
   CEJUG Senior Advisor