Directus: Database permissions

Created on 7 Apr 2020 · 4Comments · Source: directus/directus

Hello there, I finally figured out how to connect the (Cloud SQL) database to Directus (latest version) running on App Engine, all server requirements are met.
When I run the setup, in the database configuration it connects now successfully unlike many many failed tries, however running the installation fires up the following alert:
Permission denied: Superadmin Only
GCP doesn't allow users to have the SUPER privileges on Cloud SQL
Is there any way to make directus only uses the privileges I already have ?
And is there anyway I can create the tables myself in the database and bypass that ?
If yes please provide me the tables I should create and how I can configurate the config files to run with the database (if there are any new files created, possibly an API folder as I read somewhere or anything else, I will appreciate it if I can get a detailed method).

Thanks !

Source

Varulv1997

All 4 comments

Hey @Varulv1997! That error means that you didn't pass the super admin token when installing subsequent projects. See https://docs.directus.io/api/projects.html#create-a-project

It's there to prevent unauthorized people from installing additional projects in your api

rijkvanzanten on 7 Apr 2020

👎1

@rijkvanzanten The problem is, I still never ran the installation, just in the middle of it whilst connecting the database in the setup it fires up that error, it's because Google's Cloud SQL service doesn't allow its users to have the super privileges, what I'm asking is, is there any way so that Directus can use lower privileges beyond Cloud SQL's limits.
Thanks

Varulv1997 on 7 Apr 2020

👎1