After reinstal SD+ I have problems with LogIn. Default administrator/administrator account isn't working, as well as guest acconut.
Then, connected to DataBase, tried to reset the administrator account by following instructions on the link:
C:\ManageEngine\ServiceDesk\pgsql\bin>psql.exe -U postgres -p 65432 -d servicedesk
psql (9.2.4)
WARNING: Console code page (866) differs from Windows code page (1251)
8-bit characters might not work correctly. See psql reference
page "Notes for Windows users" for details.
Type "help" for help.
servicedesk=# select al.login_id"Login ID",au.first_name"Name",al.name"Login Nam
e" from aaaauthorizedrole aar left join aaarole ar on aar.role_id=ar.role_id lef
t join aaaaccount aa on aar.account_id=aa.account_id left join aaalogin al on aa
.login_id=al.login_id left join aaauser au on al.user_id=au.user_id left join sd
user sd on au.user_id=sd.userid where aar.role_id=4 and sd.status='ACTIVE';
Login ID | Name | Login Name
----------+------+------------
(0 rows)
servicedesk=# update AaaPassword set
servicedesk-# password='$2a$12$fZUC9IK8E/AwtCxMKnCfiu830qUyYB/JRhWpi2k1vgWLC6iLF
Agxa',
servicedesk-# SALT='$2a$12$fZUC9IK8E/AwtCxMKnCfiu' where algorithm='bcrypt' and
password_id in (select ap.password_id from aaaaccpassword ap left join aaaaccoun
t ac on ac.account_id=ap.account_id left join aaalogin al on al.login_id=ac.logi
n_id where al.login_id='Login_Id');
ERROR: invalid input syntax for integer: "Login_Id"
LINE 3: ...n al on al.login_id=ac.login_id where al.login_id='Login_Id'...
^
What a should do?
Thanks & Regards,
Mikhail