Share all details related to your problem, including any error messages you may have received.
I was getting invalid username or password error when trying to login using default administrator username & password i.e. spadmin & admin respectively.
When I ran query in database console to check value of password for display_name=“spadmin” in spt_identity table I got NULL value, but when checked init.xml file it has password=admin for identity spadmin.
Then I ran an update query in spt_identity table in identityiq database → UPDATE spt_identity SET password=‘1:p+qvPBo4Rig8PYlNWbr3Zg==’ WHERE name=‘spadmin’; After running this query I was able to login but getting exception page instead of home page with error “he system has encountered a serious error while processing your request. See your system administrator.”
Tried to re-import init.xml using iiq console but it is showing that spadmin does not have console access.
Can someone please suggest what should be the remedy. All screenshots attached.
Do you have any other admin user?If not, then can you try creating another admin, for example iiqadmin with spadmin password and assign system admin capability to see if you are able to authenticate, use below command
Yes, I’ve tried fresh installation so many times for 8.4
After running init.xml, I check the spadmin identity in mysql server, it’s not taking all the data in the table for that identity.
While you were running the DB script did you capture any errors?
Usually, you might see them when you are running DBScripts generated once you have made modifications within the IdentityExtended or any other extended attribute xml?
Could you please check attached document with this reply where in the end of running import init.xml command I could see some warnings and error. Does it gives some idea on the issue?
In create_identityiq_tables.mysql I’ve commented out mysql commands and uncommented aurora commands for idenityiq & identityiqah db.
I’m using xampp for which has both application server (tomcat) and database server that support aurora commands.
this can happen due to some mishap that could’ve happened while modifying the following:
Extended.hbm
Files because if you see it is calling out the following exception:
SQL Error: 1105, SQLState: HY000
2024-04-13T14:10:53,265 ERROR main engine.jdbc.spi.SqlExceptionHelper:142 - Parameter of prepared statement which is set through mysql_send_long_data() is longer than ‘max_long_data_size’ bytes
I got this issue when I was careless while modifying my IIQ 8.3 extended attributes and the iiq.properties file.
Issue is resolved now.
I’ve reinstalled the whole thing and before running commands in sql to create the tables, I have added updated the my.config file in mysql/bin folder.
