Article ID: 124076, created on Dec 28, 2014, last review on Dec 28, 2014

  • Applies to:
  • Plesk Automation 11.5

Symptoms

When I tried to create subscription the task Prepare data for the database service in the webspace failed with the following error:

Unable to find a proper service node for allocating the 'example.com' subscription.
You should have at least one node that meets the following requirements:
- The node provides the following service(s): 'ppa_mysql'.
- 'MySQL' attribute(s) are assigned to the node.
- The node is marked as 'Ready to Provide'.

Cause

There is no service node with ppa_mysql package and MySQL server was added as external. However IP address of this database server was not set in a database resource.

Resolution

When registering an existing database server, the system does not add it to the list of available service nodes and does not automatically assign any provisioning attributes to this server. This server will be shown only in the list in Infrastructure > Database Servers.

Note that these database servers cannot be configured for automatic service provisioning. To use such a server for providing database services, you should assign its IP address to the corresponding MySQL database database resource type of a certain service template. This should be done in Products > Service Templates > select a template > Resources tab > select the MySQL database resource type > Activation Parameters > Edit. You could find more details in the following documentation

Search Words

'MySQL' attribute(s) are assigned to the node

Unable to find a proper service node

The node provides the following service(s): 'ppa_mysql'

33a70544d00d562bbc5b17762c4ed2b3 caea8340e2d186a540518d08602aa065 e0aff7830fa22f92062ee4db78133079

Email subscription for changes to this article
Save as PDF