Question Database - Related to "domain" (API)

[Haugli92]

Server operating system version

Ubuntu 22.04.5 LTS

Plesk version and microupdate number

18.0.66 Update #2

Hi,

Is it not possible to set "Related to" on a database through any of the APIs?

I've been debugging and reading through the documentation but haven't found anything about this.

 

[Vladimir C.]

Hello! This functionality is yet to be implemented in Plesk. The feature request already exist and you could vote for it here:

Feature Suggestions – Your Ideas for Plesk

 

[Haugli92]

Hello! This functionality is yet to be implemented in Plesk. The feature request already exist and you could vote for it here:

Feature Suggestions – Your Ideas for Plesk

I see. Thanks for the response. Voted.

 

[tertek]

What happened to this functionality? Is it implemented yet?

uservoice is not active anymore. Where are these kind of feature requests managed now? cannot find it on features.plesk.com

 

[Sebahat.hadzhi]

Hi, @tertek . The feature request in question had only 7 votes and was not prioritized for further evaluation after the migration off UserVoice due to low demand. Please feel free to submit a new request on features.plesk.com. I will re-propose it to our team.

 

[tertek]

Hi @Sebahat.hadzhi thank you for your response. Allright, I may submit the request.

Do you know by any chance, where in the database I can find the "related database" for a site?
I could not find it...

 

[Sebahat.hadzhi]

Could you please try the following query and let me know if it works for you:

SELECT
    db.id,
    db.name AS database_name,
    db.type,
    db.dom_id,
    d.name AS domain
FROM data_bases AS db
LEFT JOIN domains AS d
    ON db.dom_id = d.id;

 

[tertek]

This does not work: all dom_id == 1, hence it shows only the parent domain id. I need to know which subdomain id is assigned to which database.

 

[Sebahat.hadzhi]

Thank you for the confirmation. Unfortunately, I don't think that's possible through the Plesk database, because databases are attached to the parent hosting object.