• The APS Catalog has been deprecated and removed from all Plesk Obsidian versions.
    Applications already installed from the APS Catalog will continue working. However, Plesk will no longer provide support for APS applications.
  • Please be aware: with the Plesk Obsidian 18.0.78 release, the support for the ngx_pagespeed.so module will be deprecated and removed from the sw-nginx package.

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