Hosting, web installer and error

[VsDims]

I am trying to install a cms via a web installer, and at the installation stage the error occurs "Sorry, but an error occurred while trying to install Winter CMS.

Unable to run migrations. SQLSTATE[42501]: Insufficient privilege: 7 ERROR: permission denied for schema public at character 14 (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))"

The hosting on which I deploy the CMS does not want to give the rights to the public scheme. Is there an alternative way to install Winter CMS?

[mjauvin]

You can use composer as stated in the docs.

ref. https://wintercms.com/docs/v1.2/docs/architecture/using-composer

[bennothommo]

@VsDims presuming you are using PostgreSQL, your host still needs to make your user account the "owner" of the database you wish to install to (per this Stack Overflow answer).

If that's not possible, unfortunately, that's not a very accommodating website host and you should probably seek another one. Even on shared hosting platforms, nearly all hosts out there will give you full rights to at least one database.

[LukeTowers]

@VsDims schemes in Postgre are what databases are in mysql I believe so just have them create a new scheme for you that you do have access to and tell the installer to use that instead. @bennothommo does the installer support configuring the postgres scheme as well as the database?

[bennothommo]

@LukeTowers not sure - it'd be whatever Laravel supports. I don't think our migration system differs much from theirs.

[bennothommo]

Apparently the PostgreSQL config in Laravel supports a schema key in the database config, so the schema can be changed from the default public schema. Perhaps the host can assign them to a new schema.

Schemas are more like namespaces from my brief skim over the docs. It can be made up of many databases.

[LukeTowers]

@bennothommo right, I'm wondering if the web installer has a UI to set that value.

[bennothommo]

Not currently, no. It certainly could though - albeit it looks like this sort of limitation is very rare.

[LukeTowers]

@bennothommo if you could add that in that would be appreciated, I've seen other projects that need to set that value in their db config.