• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

Question XML-API add db_user

Peter_S

New Pleskian
Server operating system version
Ubuntu 20.04
Plesk version and microupdate number
Plesk Obsidian 18.0.51
I want to add a db-user with access to all databases within the specified site-id.
When I use following schema, then I get an error.

<packet>
<database>
<add-db-user>
<webspace-id>@site-id@</webspace-id>
<login>@db_user@</login>
<password>@db_password@</password>
</add-db-user>
</database>
</packet>

<?xml version="1.0"?>
<packet version="1.6.9.1">
<system>
<status>error</status>
<errcode>1014</errcode>
<errtext>Parser error: Request is invalid. Error in line 1: Element 'login': This element is not expected. Expected is ( db-server-id ).</errtext>
</system>
</packet>

What is going wrong? I don't want to give access to all databases on the db-server, only for the databases in the side-id.

If I use db-id instead, then it works fine.

Best regards, Peter
 
You're almost there. The error message isn't particular clear, but it gives a hint about whats being expected. You'll need to include the <db-server-id> node in your package request.
 
Last edited:
Back
Top