Using MySQL as RDBMS Security Store for Weblogic Server

Markus Eisele
6
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 http://edocs.bea.com/wls/docs103/secmanage/rdbms.html

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.

Post a Comment

6Comments

  1. Very useful post! But I'm having an issue with mySQL... When I try to import the rdbms_security_store_pointbase sql file I get a "max key length is 767 bytes" mySQL error... I noticed that there are several tables with a varchar(400) attribute set as a primary key. I use utf-8 encoding for my DB because I want it to support Greek.
    Is there any way to get through it?
    Thanks in advance!

    ReplyDelete
  2. Very useful post! But I'm having an issue with mySQL... When I try to import the rdbms_security_store_pointbase sql file I get a "max key length is 767 bytes" mySQL error... I noticed that there are several tables with a varchar(400) attribute set as a primary key. I use utf-8 encoding for my DB because I want it to support Greek.
    Is there any way to get through it?
    Thanks in advance!

    ReplyDelete
  3. I know this is a very old article. But you can also use the rdbms_security_store_mssql sql and replace IMAGE with MEDIUMBLOB.

    ReplyDelete
  4. Hello.

    Where do I find the wizard you are refering to, i'm using a MAC osX. I create new domains via the terminal, and through there I dont seem to have the possibility to configure RDBMS security Store. Can I do it in the console?

    -Skvat

    ReplyDelete
  5. Found it:

    MW_HOME/wlsserver/common/bin/config.sh for mac.

    ReplyDelete
Post a Comment