Idea Details

Provide MySQL queries for SS, PS, logs, and users

Last activity 06-03-2019 08:43 PM
Anon Anon's profile image
03-05-2015 11:21 AM

SQL Queries are provided to create session store, policy store, audit log, and sample users for oracle and ms sql.  Providing them for MySQL would be nice.


Comments

03-05-2015 10:52 PM

Dale dale_huggins

It is available on Policy Server installation directory under Tier2 Directory.

 

 

[smuser@U136470 MySQL]$ ls -ltr

total 100

-rwxrwxr-x. 1 smuser smuser  2474 Aug 18  2014 sm_mysql_ss.sql.unicode

-rwxrwxr-x. 1 smuser smuser   122 Aug 18  2014 sm_mysql_logs_delete.sql

-rwxrwxr-x. 1 smuser smuser  5415 Aug 18  2014 smsampleusers_mysql.sql

-rwxrwxr-x. 1 smuser smuser   252 Aug 18  2014 sm_mysql_ss_delete.sql

-rwxrwxr-x. 1 smuser smuser  2474 Aug 18  2014 sm_mysql_ss.sql

-rwxrwxr-x. 1 smuser smuser  1898 Aug 18  2014 sm_mysql_ps_delete.sql

-rwxrwxr-x. 1 smuser smuser 28391 Aug 18  2014 sm_mysql_ps.sql.unicode

-rwxrwxr-x. 1 smuser smuser 28432 Aug 18  2014 sm_mysql_ps.sql

-rwxrwxr-x. 1 smuser smuser   895 Aug 18  2014 sm_mysql_logs_upgrade_12.5_to_12.52.sql

-rwxrwxr-x. 1 smuser smuser   156 Aug 18  2014 sm_mysql_logs_upgrade_12.51_to_12.52.sql

-rwxrwxr-x. 1 smuser smuser  3281 Aug 18  2014 sm_mysql_logs.sql

-rwxrwxr-x. 1 smuser smuser   179 Aug 18  2014 MySQL_ReadMe.txt

[smuser@U136470 MySQL]$ pwd

/programfiles/ps/CA/siteminder/db/tier2/MySQL

[smuser@U136470 MySQL]$

 

 

Regards

 

Hubert