Cadet 1st Class Cadet 1st Class
Cadet 1st Class
9207 views

Failed to login SSC after moving DB from MySQL to SQL Server

Jump to solution

We change the database from MySql to SQL Server 2008
we already config and the database is already seed by bundle from Fortify_PCI_Basic_Seed_Bundle-2018_Q1, Fortify_Process_Seed_Bundle-2018_Q1 and Fortify_Report_Seed_Bundle-2018_Q1

the issue is happening when we try to login, using admin & pass admin is incorrect, would you help us for this issue.. is there another way to reset the password??

FYI, we've try this but still nothing happen:

UPDATE fortifyuser
SET requirePasswordChange='Y', failedLoginAttempts=0, dateFrozen=NULL, suspended='N', secPass='b0521d842e68c870af598b81aa8cd6d1728611b1e5568397e420b2d026172b74', salt='P7D4co4mI/4='
WHERE username='<admin_user>';

Thanks.

0 Likes
1 Solution

Accepted Solutions
Micro Focus Expert
Micro Focus Expert

Hi,

Please verify the current value for the propertyName 'user.lookup.strategy' in the table 'configproperty' using below query.
select * from configproperty where propertyName = 'user.lookup.strategy'

The propertyValue may be 2 (LDAP users first, fallback to local users - 2 OR LDAP users exclusive, fallback to local administrator - 3)

If so, run below query to update the User Lookup Strategy to "Local users first, fallback to LDAP users (compatibility)"
update configproperty set propertyValue = 1 where propertyName = 'user.lookup.strategy'

Once this change has been performed, please run the query to reset the 'admin' user password to the default value (i.e. admin).

UPDATE fortifyuser SET requirePasswordChange='Y', failedLoginAttempts=0, dateFrozen=NULL, suspended='N', secPass='b0521d842e68c870af598b81aa8cd6d1728611b1e5568397e420b2d026172b74', salt='P7D4co4mI/4=' WHERE userName='admin';

Restart the Tomcat server and attempt to login to SSC (with default username and password) post these changes.

Regards,
Tejesh Chandra K H

View solution in original post

0 Likes
2 Replies
Micro Focus Expert
Micro Focus Expert

Hi,

Please verify the current value for the propertyName 'user.lookup.strategy' in the table 'configproperty' using below query.
select * from configproperty where propertyName = 'user.lookup.strategy'

The propertyValue may be 2 (LDAP users first, fallback to local users - 2 OR LDAP users exclusive, fallback to local administrator - 3)

If so, run below query to update the User Lookup Strategy to "Local users first, fallback to LDAP users (compatibility)"
update configproperty set propertyValue = 1 where propertyName = 'user.lookup.strategy'

Once this change has been performed, please run the query to reset the 'admin' user password to the default value (i.e. admin).

UPDATE fortifyuser SET requirePasswordChange='Y', failedLoginAttempts=0, dateFrozen=NULL, suspended='N', secPass='b0521d842e68c870af598b81aa8cd6d1728611b1e5568397e420b2d026172b74', salt='P7D4co4mI/4=' WHERE userName='admin';

Restart the Tomcat server and attempt to login to SSC (with default username and password) post these changes.

Regards,
Tejesh Chandra K H

View solution in original post

0 Likes
Cadet 1st Class Cadet 1st Class
Cadet 1st Class

HI,

thanks for your advice.. now we can login onto SSC after we update the query.

Regards,

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.