Unable to log in / Reset admin password

Unable to log in / Reset admin password

I have just (well yesterday) installed the latest version of ServiceDesk Plus; and it is setup as the trial version.

 

I am in the process of setting this up so i have created a new admin account called admin.

 

I deleted all the other admin accounts.

 

Connected my AD to ServiceDesk and sync'ed the users; i rebooted the server and i was able to log in using my admin account without any issues.

 

So like i said i did a lot more of the config of ServiceDesk, and logged out last night.

 

This morning, i am not able to log in using my admin account, all i get is unknown user or wrong password type of message.

 

After checking google i found your information on resetting the admin account.

 

I am using the buildin PGSQL database server

 

I did the following (after going to the pgsql bin folder)

 

 

psql.exe -U sdpadmin -p 65432 -d servicedesk -h 127.0.0.1

 

(logged in using sdp@123)

 

Select al.login_id"Login ID",au.first_name"Name",al.name"Login Name" from aaaauthorizedrole aar left join aaarole ar on aar.role_id=ar.role_id left 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 sduser sd on au.user_id=sd.userid where ar.name like 'SDOrgAdmin' and sd.status='ACTIVE';

 

this give the output of

 

Login ID | Name  | Login Name

----------+-------+------------

      312 | Admin | admin

(1 row)

 

i then did

 

pdate AaaPassword set password='$2a$12$fZUC9IK8E/AwtCxMKnCfiu830qUyYB/JRhWpi2k1vgWLC6iLFAgxa', SALT=pgp_sym_encrypt('$2a$12$fZUC9IK8E/AwtCxMKnCfiu','SChar@123Mas!er','s2k-mode=1, cipher-algo=aes256'), algorithm='bcrypt' where password_id in (select ap.password_id from aaaaccpassword ap left join aaaaccount ac on ac.account_id=ap.account_id left join aaalogin al on al.login_id=ac.login_id where al.login_id=312);

 

which gives the output as

UPDATE 1

 

I tied to login and i am getting the same error

 

I tried rebooting and still the same

 

When i try and log in i get the option of "Not in Domain" or the name of my domain

 

I then redid the above and also did this command

 

update globalconfig set paramvalue='true' where parameter='Enable_LocalAuthentication_Login';

 

after a reboot i am still getting the same issues

 

Any ideas to what to try next? as i dont want to uninstall and reinstall and restart all of the config as it took 4 hours yesterday to do (and yes i did all of the config)

 

Thanks


                  New to ADSelfService Plus?