Upgrade 12.5 authpsa No such user

[moswak]

After upgrade 12.08 to 12.5 login to mailbox does not work

mail.log shows:
authpsa[10692]: No such user '[email protected]' in mail authorization database

i tried
plesk repair mail
and
/usr/local/psa/admin/sbin/mchk --with-spam

bur it doenst help

when i set the current password for mailbox again ist works.
but i cant do this on a server with hundreds of mailboxes.

can i repair or reset mail authorization database ?

 

[mizar]

Mchk part (mail_auth_dump) will fill auth database for mail - does it completed successfully?
To make sure that database re-created you can delete or move /var/spool/postfix/plesk/passwd* files.

 

[moswak]

>> Mchk part (mail_auth_dump) will fill auth database for mail - does it completed successfully?

[root@]# /usr/local/psa/admin/sbin/mchk --with-spam
==> Checking for: mailsrv_conf_init... ok
==> Checking for: mail_handlers_init... ok
==> Checking for: mailsrv_entities_dump... ok
==> Checking for: mail_admin_aliases... ok
==> Checking for: mail_auth_dump... ok
==> Checking for: mailman_lists_dump... ok
==> Checking for: mail_kav8_restore... ok
==> Checking for: mail_responder_restore... ok
==> Checking for: mail_imap_restore... ok
==> Checking for: mail_spam_restore... ok
==> Checking for: mail_grey_restore... ok
==> Checking for: mail_mailbox_restore... ok
==> Checking for: mail_spf_restore... ok
==> Checking for: mail_dk_restore... ok
==> Checking for: mail_drweb_restore... not found, skipped
==> Checking for: mail_outgoing_restore... ok
==> Checking for: mail_transport_restore... ok

yes no problems.

>> To make sure that database re-created you can delete or move /var/spool/postfix/plesk/passwd* files.

the files were re-created
same error :-(
No such user '[email protected]' in mail authorization database

 

[IgorG]

Do you use any custom (not from Odin repository) webmail version? I meet this issue when custom version of Roundcube was used.

 

[moswak]

No, i use the normal Roundcube shipped with Plesk.

/usr/local/psa/admin/sbin/mail_auth_view

shows no entrys.
this is the problem ?

 

[IgorG]

shows no entrys.

Try to use this KB article as possible workaround - http://kb.odin.com/en/125538

 

[moswak]

i try
mysql> select concat(m.mail_name,'@',d.name) as mail, a.type as 'passwd type', a.password from domains d, mail m, accounts a where m.dom_id=d.id and m.account_id=a.id;

there are no empty passwords. the mail accounts exist.
this looks normal.

i also try

mysql> SELECT CONCAT_WS('@',mail.mail_name,domains.name),accounts.password FROM domains,mail,accounts WHERE domains.id=mail.dom_id AND accounts.id=mail.account_id AND accounts.password='' ORDER BY domains.name ASC,mail.mail_name ASC;

no results

/usr/local/psa/admin/sbin/mail_auth_view | grep '$AES'

no results

mysql> select * from mail where account_id not in (select id from accounts);

no results

/usr/lib64/plesk-9.0/remote_mail_restore/mail_auth_dump

without error

do not know further. on this server are very few mailboxes. I think I set the new Password?