Hi Amit et al,
So I was working with the developer who is trying to modify the script that was mentioned before. I don’t know why, but he said he blew away the MySQL database on RDS and made a new one.
So, I tried to do what I had done before, where I used mysql and ran/sourced the “create_identityiq_tables-8.4.mysql” to create the identityiq, etc. schemas in the database.
It looks like that worked again and I can see the 3 identityiq databases (iq, iqah, and iqPlugin) in mysql.
But I have a question… I don’t recall for 100% if, when I ran the create sql script, if it created some users in the new databases??
I could’ve sworn that when i ran the create the last week, that it created at least the spadmin user in the spt_identity table in the identiyiq database, but after I just ran the create sql script, it did create the 3 databases and schemas, but it looks like there is no data in the databases/tables, and no users in the spt_identity table?
Can someone tell me/confirm that immediately after running the create script, should there actually be any data in the databases, esp. in the spt_identity table?
Sorry, I know this is a kind of strange question…but I just want to confirm that the create sql script worked correctly.
Thanks,
Jim
EDIT 1: I was just reading this: 8.4 IdentityIQ Installation Guide - Compass
and I see that mentions running “iiq console” and importing “init.xml”… Is THAT what populates the initial data (e.g., the “spadmin” user, etc.) into the database?
If so that might explain what I don’t have any data in the database yet… I have not run “iiq console”.
Can someone confirm that for me?
Thanks