• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

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