MySQL Community Server as Policy Store!

If you attempt to use MySQL community version with the SiteMinder bundled Datadirect ODBC drivers, it will show an error message saying it's not supported and fail to work.

It's possible however to use this un-supported version by below configuration
1) Install MySQL odbc drivers 32 bit (Windows) (download from mysql site)
2) Configure the datasource and enter the username/password
3) Point to the datasource name in SMCONSOLE, Connect should be successful now
4) Use mysql command line to run the SQL scripts
- enter "source \db\tier2\MySQL\sm_mysql_ps.sql"
- XPS sql script file db\tier2\MySQL\MySQL.sql, edit the last create table statement
from
CREATE TABLE xpsKey
(
    kyObject        INT         NOT NULL,
    kyValue         VARCHAR(767)    NOT NULL,

to

CREATE TABLE xpsKey
(
    kyObject        INT         NOT NULL,
    kyValue         VARCHAR(255)    NOT NULL,

Run it like earlier command
5) That's it. Continue the xpsddinstall commands as per documentation and you have a running mysql community server as policy store.