Reset Postfix Admin password

1. Get the Encrypted Version of the string that you want to set as password :

dovecot -s MD5-CRYPT -p <yournewpassword> | sed ‘s/{MD5-CRYPT}//’

2. Copy the output

3. Login to Mysql database

4. Use database Vmail or whatever in your case.

5.Run the following query :

update admin set password='<above copied output>’ where username = ‘<username>’

####################

Admin password Lost

doveadm pw -s SHA512-CRYPT -p YOUR_NEW_PASSWORD

And edit database :

docker exec -it mariadb bash

# mysql -u root -p

mysql> use postfix;

mysql> UPDATE admin SET password = '{SHA512-CRYPT}HASH' WHERE username = 'user@domain.tld';

Query OK, 1 row affected (0.00 sec)

Rows matched: 1  Changed: 1  Warnings: 0

mysql> quit

exit

##################

Postfixadmin

1. Делаем шифрованный пароль при помощи команды

       dovecot pw -s MD5-CRYPT -p password | sed 's/{MD5-CRYPT}//'

2. Заходи в mysql

              mysql -u root –p

3. Выбираем базу

               use postfixadmin;

4. Смотрим учетку администратора.

        select * from admin;

5. Меняем пароль

              update admin set password='хеш пароль' where username='admin@blablabla.ru';

-----------------------------------------------------

Ubuntu 11.1 

dovecot

doveadm pw -s MD5-CRYPT -p YOUR_PASSWORD | sed 's/{MD5-CRYPT}//'

$1$ZbwsgmXZ$W.Rg5Cr8SuP663u41xTja/

# mysql -u postfix_admin -p

mysql> show databases;

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

| Database           |

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

| information_schema |

| mail               |

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

2 rows in set (0.00 sec)

mysql> use mail;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> show tables;

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

| Tables_in_mail        |

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

| admin                 |

| alias                 |

| alias_domain          |

| config                |

| domain                |

| domain_admins         |

| fetchmail             |

| log                   |

| mailbox               |

| quota                 |

| quota2                |

| vacation              |

| vacation_notification |

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

13 rows in set (0.00 sec)

select * from admin;

1

select * from admin;

mysql> select * from admin;

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

| username                          | password                           | created             | modified            | active |

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

| arielfx@emang.ganteng.de          | $1$f383ade6$zU86FBNFzlJHStY5LLLEB/ | 2014-03-09 18:02:58 | 2015-02-16 21:03:50 |      0 |

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

1 rows in set (0.00 sec)

mysql>

mysql> update admin set password='$1$ZbwsgmXZ$W.Rg5Cr8SuP663u41xTja/' where username='arielfx@emang.ganteng.de';