Resolved Could not find password for account id '2648'. Return empty password

[Andrei C]

Everyday after Backup Panel (Tasks from Backup Manager), I receive next error:

<?xml version="1.0" encoding="utf-8"?>
<execution-result status="error">
<object name="domain.ru" type="domain">
<message severity="error" id="416a91ad-e5e7-480b-b6b4-a60157b8eaae" code="InformationalException">
<description>Could not find password for account id '2648'. Return empty password</description>
</message>
</object>
</execution-result>

Resolve -> only reconfigure domain.
How can I automatic fix this problem?

 

[IgorG]

This error occurs due to null password for some email accounts. You can follow the steps given below to fix this error.

Run the mysql query given below to check the email account.

select * from mail where account_id=XXXX

Then you will be able to find the email account. You can rest the password of the email account.

 

[jcgalvez]

Hello, I'm really shame to ask this, but how should I access to the mysql file, and to which database, if posible a mini howto would be great, My backups have exactly the same issue, and I double checked every single mail account on the offending domain, and all have a password assigned, but I had no way to access this mysql query/file that you mention.

Thank you a lot

Javier

 

[IgorG]

Access to Plesk psa database:

cd %plesk_dir%\MySQL\bin
mysql -P8306 -uadmin -p<plesk_admin_password> psa

But I strongly recommend you contact Parallels Support Team if you are not familiar with SQL.

 

[jcgalvez]

Hello,

The correct commands for ignorants like me :-D are the following

(assuming that plesk is instaled on a 64 bit server, windows 2008, on the default c drive)
cd 'C:\Program Files (x86)\Parallels\Plesk\MySQL\bin'

.\mysql.exe -p8306 -uadmin -pmyadminpass psa

select from mail where account_id=2648;

it's necesary to put the semicolon at the end of the sentence

I found the error (user without password) and I simply deleted the offending mail.

Thru the control panel while choosing the user gave me the following error

Internal error: MEAOPO.Mailbox.GetMailbox failed (Error code 1)
File: Agent.php
Line: 212
Type: PleskUtilException

so deleting the offending mailbox cured the problem.

Would be great if this errors are fixed thru the Plesk Check & Repair program, so there is no acounts without password, or somehow damaged

Sincerely,

Javier

 

[InderS]

you can try resetting password for the email account which are having null passwords.

 

[Jhow Plug]

I cannot backup plesk settings, see error .

Does he quote id 0 ?
Strange to be id zero

How can I solve ?
Thank you

C:\Program Files (x86)\Iperius Backup>cd C:\Program Files (x86)\Parallels\Plesk\bin

C:\Program Files (x86)\Parallels\Plesk\bin>pleskbackup.exe --server --configuration -output-file "D:\Backup_Plesk\configuration.zip"
Could not find password for account id '0'. Return empty password
Could not find password for account id '0'. Return empty password
Could not find password for account id '0'. Return empty password
Could not find password for account id '0'. Return empty password
Could not find password for account id '0'. Return empty password
Could not find password for account id '0'. Return empty password

The backup failed with errors!

 

[Jhow Plug]

I cannot backup plesk settings, see error .

Does he quote id 0 ?
Strange to be id zero

How can I solve ?
Thank you

I could already see the error

But when does this happen.
The backup is interrupted and becomes invalid, doesn't it just skip this client? Is there any command to ask him to move on?

 

[IgorG]

Could not find password for account id '0'. Return empty password
Could not find password for account id '0'. Return empty password
Could not find password for account id '0'. Return empty password

You can find out the affected mail accounts with the following SQL query in Plesk database, for example:

mysql> SELECT concat(mail.mail_name,'@',domains.name) as email FROM mail INNER JOIN domains ON mail.dom_id=domains.id WHERE mail.account_id=0;
+---------------+
| email        |
+---------------+
| [email protected] |
+---------------+

Please update the password for the affected domain manually.

 

[Jhow Plug]

Você pode descobrir as contas de e-mail afetadas com a seguinte consulta SQL no banco de dados Plesk, por exemplo:

[CÓDIGO] mysql> SELECT concat (mail.mail_name, '@', domains.name) como e-mail FROM mail INNER JOIN domínios ON mail.dom_id = domains.id WHERE mail.account_id = 0;
+ --------------- +
| email |
+ --------------- +
| nome@domínio.com |
+ --------------- + [/ CODE]

Atualize a senha do domínio afetado manualmente.

Thank you