Have you try to read
http://blogs.sun.com/swchan/entry/jdbcrealm_in_glassfish_with_mysql
This is a doc for v2.
According to your error message, there is an issue with userid column.
Can you check that the schema is correct for usertable and grouptable?
glassfish_at_javadesktop.org wrote:
> Someone can help me please?
> [Message sent by forum member 'josecarlosbarros' (josecarlosbarros)]
>
> http://forums.java.net/jive/thread.jspa?messageID=317038
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>
>