Monday, September 1, 2008

Using MySQL as RDBMS Security Store for Weblogic Server

One of the truely new features of the Weblogic Server 10gR3 is the ability to get rid of the embedded LDAP server for security realms. You can now configure your own RDBMS based security. This means the RDBMS is not only used for users and groups but for all security related ressources. A must for the use of the new SAML2 features.

For more details have a look at the official documentation at

Oracle recommends that you configure your RDBMS security store during domain creation using the configuration wizzard.

This is by far the most easiest way to do the job. The only thing you have to do is to start the wizzard. Select "Create new Weblogic Domain", tell it the prefered user name, template and JDK and here comes the magic:
Tell the wizzard, that you would like to "Customize Environment and Service Settings". The first page, that displays after this is the "Configure RDBMS Security Store Database".

Fill in the required parameters and click through the remaining pages. Finish the wizzard but DO NOT start the server.

Now you have to create the DB tables. Look at the \wlserver_10.3\server\lib and find the needed .sql scripts. There is no MySQL Version. But this is not too hard. Take the Pointbase-Version and modify all occurences of BLOB(1M) to BLOB. This should be enough. Now create the schema and the tables and start your domain.

Thats all for now. Now, you are ready to use your new RDBMS based security with WLS and MySQL.