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
Thats all for now. Now, you are ready to use your new RDBMS based security with WLS and MySQL.
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.
ReplyDeleteIs there any way to get through it?
Thanks in advance!
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.
ReplyDeleteIs there any way to get through it?
Thanks in advance!
I know this is a very old article. But you can also use the rdbms_security_store_mssql sql and replace IMAGE with MEDIUMBLOB.
ReplyDeleteSkavat,
ReplyDeletethanks :)
-M
Hello.
ReplyDeleteWhere 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
Found it:
ReplyDeleteMW_HOME/wlsserver/common/bin/config.sh for mac.