Question Auto-create databases using PHP

[FlyingParrot]

Server operating system version

Ubuntu 22.04.5 LTS

Plesk version and microupdate number

Plesk Obsidian 18.0.69 #2

Hey,

is there any way to auto-create postgresql databases using php? I'm developing a multi-tenancy-software and it's required to create databases for each tenant they need one. How do I configure that in Plesk? Is that even possible?
I'm getting the php error "SQLSTATE[42501]: Insufficient privilege: 7 ERROR: permission denied to create database" but I couldn't find any settings for this in plesk. Maybe it's possible manually via SSH?

Thanks.

 

[scsa20]

Make sure whatever user you're using for creating the database has the CREATEDB role. Please note though that doing it that way the database will not show up in plesk due to plesk's internal database won't showing the new one, so ideally you'll want to use plesk's api instead for creating it. You can learn more about using plesk's API over at New Remote Plesk REST API for Automation and Introduction

 

[Kaspar]

As @scsa20 already suggested, using the Plesk REST API to create databases is your best option.