| Solution |
This script will help to add a new test user when the existing add-super-admin.sql script does not add a new test user.
Step 1. Log in to FortiSIEM through SSH using admin user access.
Create a file with the name reset-admin-password.sql:
vim /opt/phoenix/deployment/add-super-test-admin.sql
Step 2. Enter below SQL queries below in the file and save the file.
INSERT INTO ph_user VALUES (nextval ('ph_global_gen'), 1283889301935, 1, 0, 1283889301935, 0, true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'test', 'test', true, NULL, (select id from ph_rbac_profile where name='Full Admin'));
INSERT INTO ph_contact VALUES (nextval ('ph_global_gen'), 1283889301935, 1, 0, 1283889301935, 0, NULL, NULL, NULL, NULL, NULL, 'not_set', NULL, NULL, NULL, false, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO ph_user2contact VALUES (currval('ph_global_gen')-1, currval('ph_global_gen'));
INSERT INTO ph_sec_ident VALUES (nextval ('ph_global_gen'), 1283889301938, 0, 1283889301938, 0, 0, 1, 'test', 'Test*123', NULL, currval('ph_global_gen')-2, NULL);
Step 3. Run the command below:
psql -d phoenixdb -U phoenix -f /opt/phoenix/deployment/add-super-test-admin.sql
This will reset admin credentials, and the script will work. Now, try to log in using the credentials below.
Username:- test
Password:- Test*123
Admin password can be reset from the GUI.
Related articles:
Technical Tip: Reset root credentials on rocky Linux machine in FortiSIEM
Technical Tip: Reset root credentials on rocky Linux machine in FortiSIEM
|
