JDBC Users and Group Services

We will now see how to add a new service using a database as a storage medium:

1. From the Welcome page click the Users, Groups, Roles link on the Menu Security section.

   Note

   You have to be logged in as Administrator in order to activate this function.

   

2. Click the Add new in the User Group Services menu

3. Click the JDBC link on top of the page

   • Insert jdbcservice in the Name text field.
   • Select Weak PBE from Password encryption combo box.
   • Select default from Password policy combo box.
   • Select org.postgresql.Driver from Driver class name combo box.
   • Insert jdbc:postgresql://localhost/storm_track_sql in the Connection URL text field.
   • Insert geosolutions in the Username text field.
   • Insert Geos in the Password text field.
   • Check the Create database tables checkbox

   

4. Click the Save button.

Now we are going to add a user to the newly added user/group service:

1. From the Welcome page click the Users, Groups, Roles link on the Menu Security section

2. Click on the User/Groups tab

3. Click on the jdbcservice link and the user/groups form will appear

   

4. Click on the edit link to the right of the jdbcservice link

5. Click on the Users tab

6. Click on the Add new user button

   • Insert postgres in the User name, Password and Confirm Password text fields.
   • Select the ADMIN element in the Available list of the Roles taken from active role service: default menu
   • Click the arrow right button to add the element to the Selected list

   

7. Click the Save button.

We will use this service in the JDBC Authentication section to create a new Authentication Provider.