• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

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