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 12:59:51 +0100

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........