Skip to main content

ManageEngine ServiceDesk Plus - Reset password

Let's reset the default administrator's password to 'admin'

# Search for psql
sudo find / -name psql

# Change directory
cd /home/tuyendq/ManageEngine/ServiceDesk/pgsql/bin

# Login to postgres, database servicdesk
./psql -U postgres -p 65432 -d servicedesk -h localhost

# Check login_id with SDAdmin role (administrator)
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 aar.role_id=2 and sd.status='ACTIVE';

# Reset login_id's password to 'admin'
update AaaPassword set password='$2a$12$fZUC9IK8E/AwtCxMKnCfiu830qUyYB/JRhWpi2k1vgWLC6iLFAgxa', SALT='$2a$12$fZUC9IK8E/AwtCxMKnCfiu' where algorithm='bcrypt' and 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=2);

# #Quit
# \q
Labels:

Popular posts from this blog

RHEL: firewall-cmd

firewall-cmd - firewall d c om m an d line client
Read more

Generative AI: Notes

"Gen AI, or generative artificial intelligence, is a type of artificial intelligence that can create new content, such as text, images, or music. It does this by learning from a large dataset of existing content and then using that knowledge to generate new content that is similar to the original data."
Read more

[Microsoft Outlook]: Set .pst and .ost files location with ForcePSTPath Registry Key

Set .pst and .ost files location with ForcePSTPath Registry Key The ForcePSTPath registry key is supported by Microsoft Outlook 2003 and later. In Microsoft Outlook 2003 and 2007, it applies to new profiles only. Microsoft Outlook 2013 and Outlook 2016 it applies to new accounts created in a profile. Microsoft Outlook 2013 saves .pst in   %userprofile%\Documents\Outlook Files folder by default. We can change that default setting by adding a new string registry key called ForcePSTPath and set the value to the folder that we want to save those files. Set Microsoft Outlook 2013 always save new .pst and .ost files to D:\Data\Mail folder OST file reached the maximum size The OST File Has Reached The Maximum Size
Read more