AWStats and iRedMail Login Problems: Difference between revisions
From KlavoWiki
Jump to navigationJump to search
Created page with "iRedMail uses SHA512 password hashes and Apache is unable to read these passwords. You will need to use a MD5 password hashes for Apache to read the password. Rather than ch..." |
m Davidk moved page iRedMail AWStats to AWStats and iRedMail Login Problems without leaving a redirect |
(No difference)
|
Latest revision as of 10:23, 5 July 2016
iRedMail uses SHA512 password hashes and Apache is unable to read these passwords. You will need to use a MD5 password hashes for Apache to read the password. Rather than changing the password I decided to create a new account specifically for AWStats. Looking at the AWStats configuration file it is looking for a user that has global domain rights. Based on this information I crated a new use within the SQL database.
Create a MD5 password.
doveadm pw -s 'MD5' -p 'ThisisMyPassword' | awk -F'{MD5}' '{print $2}'
Copy the MD5 password and use in the next commands.
Enter the SQL CLI
mysql -pMyLongandComplexSQLPassword vmail
Create a new user for AWStats. Username awstats with password from previous MD5 hash.
insert into mailbox (username, password, name, isglobaladmin, created) values ('awstats', '$1$xDPIzoZn$TKtQTV0qig0G7L.EoY2ay1', 'AWStats User', 1, now());
Change the password for user awstats
update mailbox set modified=now(), password='$1$3b.qn8Vu$FDI/.rO9YrCFDQsmC11GE.' where username='awstats';
Delete awstats user
delete from mailbox where username='awstats';
Display all Global Admins
select username, name, password, name from mailbox where isglobaladmin=1;