Applicable to:
- Plesk for Linux
- Plesk for Windows
Symptoms
-
Accessing a subscription via Plesk > Subscriptions fails with the following warning:
PLESK_WARN: Warning: No subscriptions are listed for your account; therefore, no operations are available. Please contact your service provider for assistance with subscribing to the services.
PLESK_WARN: Access to the foreign subscription is denied.
-
The following errors can be found in the
/var/log/plesk/panel.log
or%plesk_dir%admin\logs\php_error.log
files with the enabled debug logging:CONFIG_TEXT: DEBUG [panel] Smb_Exception: Access to the foreign subscription is denied.
WARN [panel] No subscriptions are listed for your account; therefore, no operations are available.
Please contact your service provider for assistance with subscribing to the services.
DEBUG [panel] Unable to access task/task-progress without subscription -
The enabled show.sql_query option in the panel.ini file provides with the following info in the
/var/log/plesk/panel.log
or%plesk_dir%admin\logs\php_error.log
files:CONFIG_TEXT: DEBUG [dbquery] [38] SQL: SELECT
domains
.* FROMdomains
WHERE (cl_id
= 1 ANDwebspace_id
= '0' ANDid
= '-1')
Cause
Database inconsistencies in the smb_users
table.
The smb_users.subscriptionDomainId
table contains an incorrect value:
# plesk db "select id,login,subscriptionDomainId from smb_users where subscriptionDomainId='-1'"
+----+----------------------+----------------------+
| id | login | subscriptionDomainId |
+----+----------------------+----------------------+
| 1 | admin | -1 |
| 1 | user1 | -1 |
+----+----------------------+----------------------+
Resolution
-
Create a backup of the
psa
database. -
Update the
subscriptionDomainId
value with the proper value:# plesk db "update smb_users set subscriptionDomainId="0" where subscriptionDomainId="-1" and isBuiltIn=1;"
Comments
1 comment
Never knew that I had a dozen accounts with this problem until I saw the error today. thanks for this article.. all fixed.
Please sign in to leave a comment.