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'.
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.
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