1 Topic by dbanie

  • dbanie
  • Member
  • Offline
  • Registered: 2015-08-21
  • Posts: 8

Topic: Vmail password changed cannot login to email

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.2
- Linux/BSD distribution name and version: Debian
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Apache/2.2.22 (Debian)
- Manage mail accounts with iRedAdmin-Pro?
- Related log if you're reporting an issue:
====

Hi Mr. Zhang

I'm stupidly change the vmail password from phpMyAdmin, my intention is to fix the cluebringer web ui.
now i cannot login to may email from webmail (roundcube). Below is the log from mail.info & mail.warn in /var/log

Aug 21 18:43:10 mail postfix/pickup[5239]: 00D44E7F: uid=0 from=<fail2ban@mail.com>
Aug 21 18:43:10 mail postfix/cleanup[5372]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "fail2ban@mail.com"
Aug 21 18:43:10 mail postfix/cleanup[5372]: warning: 00D44E7F: sender_bcc_maps lookup problem
Aug 21 18:43:10 mail postfix/pickup[5239]: warning: maildrop/6330160E: error writing 00D44E7F: queue file write error
Aug 21 18:43:11 mail postfix/pickup[5239]: 013BCE7F: uid=0 from=<fail2ban@mail.com>
Aug 21 18:43:11 mail postfix/cleanup[5371]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "fail2ban@mail.com"
Aug 21 18:43:11 mail postfix/cleanup[5371]: warning: 013BCE7F: sender_bcc_maps lookup problem
Aug 21 18:43:11 mail postfix/pickup[5239]: warning: maildrop/CBE55AAA: error writing 013BCE7F: queue file write error
Aug 21 18:43:12 mail postfix/pickup[5239]: 01A64E7F: uid=0 from=<fail2ban@mail.com>
Aug 21 18:43:12 mail postfix/cleanup[5372]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "fail2ban@mail.com"
Aug 21 18:43:12 mail postfix/cleanup[5372]: warning: 01A64E7F: sender_bcc_maps lookup problem
Aug 21 18:43:12 mail postfix/pickup[5239]: warning: maildrop/AFF99E9E: error writing 01A64E7F: queue file write error
Aug 21 18:43:13 mail postfix/pickup[5239]: 02118E7F: uid=0 from=<fail2ban@mail.com>
Aug 21 18:43:13 mail postfix/cleanup[5371]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "fail2ban@mail.com"
Aug 21 18:43:13 mail postfix/cleanup[5371]: warning: 02118E7F: sender_bcc_maps lookup problem
Aug 21 18:43:13 mail postfix/pickup[5239]: warning: maildrop/AE447668: error writing 02118E7F: queue file write error
Aug 21 18:43:14 mail postfix/pickup[5239]: 02A07E7F: uid=0 from=<fail2ban@mail.com>
Aug 21 18:43:14 mail postfix/cleanup[5372]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "fail2ban@mail.com"
Aug 21 18:43:14 mail postfix/cleanup[5372]: warning: 02A07E7F: sender_bcc_maps lookup problem
Aug 21 18:43:14 mail postfix/pickup[5239]: warning: maildrop/B5FF06FB: error writing 02A07E7F: queue file write error

how i suppose to know the original vmail password to make it run normail again.

Thank you,
dbanie

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: Vmail password changed cannot login to email

Check any file under /etc/postfix/mysql/.

3 Reply by dbanie (edited by dbanie 2015-08-21 20:20:42)

  • dbanie
  • Member
  • Offline
  • Registered: 2015-08-21
  • Posts: 8

Re: Vmail password changed cannot login to email

Hi Zhang,

Yes I already check it and replace it using below command

UPDATE mysql.user SET Password=PASSWORD('password that describe in *.cf') WHERE user='vmail' AND host='localhost';

but still when i logged in only spinning and the log shows the same error

UPDATE::

It solved smile after I reboot my server everything come back to normal, Thanks Mr.Zhang