Activate mail service on domain button is greyed out

By
Sergey Babkevych
-
0
2306

Symptoms

Mail service is disabled for subscription in * *> Mail > Mail Settings and it is not possible to enable it through control panel, because“Activate mail service on domain” button is greyed out, but subscription is active.

Resolution

  1. Create dump of Plesk database:

Plesk for Windows 
C:Program FilesParallelsPleskMySQLbin>mysqldump -uadmin -pPASSWORD -P8306 psa >psa.dump 
Plesk for Linux 
mysqldump -uadmin -pcat /etc/psa/.psa.shadow psa >psa.dump

  1. Login to Plesk database:

Plesk for Windows C:Program FilesParallelsPleskMySQLbin>mysql -uadmin -pPASSWORD -P8306 psa

Plesk for Linux 
mysql -uadmin -pcat /etc/psa/.psa.shadow psa

  1. Find domain with disabled mail service:

    mysql> select * from DomainServices where type='mail' and dom_id=(select id from domains where name='domain.tld'); +-----+--------+------+--------+---------------+----------------+ | id | dom_id | type | status | parameters_id | ipCollectionId | +-----+--------+------+--------+---------------+----------------+ | 167 | 61 | mail | 2 | 229 | 167 | +-----+--------+------+--------+---------------+----------------+ 1 row in set (0.00 sec)

where ‘domain.com’ is a primary subscription’s domain.

mysql> update DomainServices set status=0 where type='mail' and id=167; Query OK, 1 row affected (0.00 sec)

Cause

Such kind of misconfiguration could be the result of manually changed parameters in database.