Page History

...

By default, Geronimo is using a .properties file realm for authentication named geronimo-admin, which is used by JMX server, Administration Console, Online-deploy and MEJB applications. However, you may not want to use it for production use. Alternatively, you can use database or LDAP realms in a production environment. To demonstrate how to replace the default realm, we will use 2 two samples as followed:

...

1. Create a database named SecurityDatabase using DB manager in the administration console.
2. Create two tables Users and Groups to store user credential and group information. SQL

   Code Block
   SQL
   create table users(username varchar(15),password varchar(15)); create table groups(username varchar(15),groupname varchar(15)); insert into users values('userone','p1'); insert into users values('usertwo','p2'); insert into users values('userthree','p3'); insert into groups values('userone','admin'); insert into groups values('usertwo','admin'); insert into groups values('userthree','user');

   In the DB manager portlet copy and paste the above SQL into SQL Commands box and select the SecurityDatabase database and press Run SQL button to create the tables.

...