• Hi, Pleskians! We are running a UX testing of our upcoming product intended for server management and monitoring.
    We would like to invite you to have a call with us and have some fun checking our prototype. The agenda is pretty simple - we bring new design and some scenarios that you need to walk through and succeed. We will be watching and taking insights for further development of the design.
    If you would like to participate, please use this link to book a meeting. We will sent the link to the clickable prototype at the meeting.
  • (Plesk for Windows):
    MySQL Connector/ODBC 3.51, 5.1, and 5.3 are no longer shipped with Plesk because they have reached end of life. MariaDB Connector/ODBC 64-bit 3.2.4 is now used instead.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.

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