V8-archive: Installation fails with Permission denied: Superadmin Only

[vladaman]

When running new installation after entering DB credentials I get error:

"Permission denied: Superadmin Only"

Installer does not continue. Running on Apache2, PHP 7.2 and Ubuntu 18.

[rijkvanzanten]

Is this the first project you're installing? Do you have an __api.json file in the config folder?

[mukhortov]

Same issue. Making a new install with a newly created MySQL DB.

First I get an error saying SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

If I click install button for the second time I get Permission denied: Superadmin Only

I have __api.json file in the config folder. And when I check the DB structure I can see Directus tables:

But I can't bypass the "Database Connection" step.

If I refresh the page it asks for a super-admin password and restarts new project creation flow.

Environment:

[lolmos]

I'm getting the same thing with GoDaddy:

1. I get the green ticks before installation
2. add the info for project/user/psswrd -> database/databaseuser/psswrD
3. i Message: ![image](https://user-images.githubusercontent.com/7524918/80281728-7d049b80-870d-11ea-9d99-cabe9f486abc.png)
4. try to install again but get message : Permission denied: Superadmin Only

5. if I go to home i get Statement could not be executed (42S02 - 1146 - Table 'lab-d1-1.directus_settings' doesn't exist)

6. the database has been poplulated with these tables:
   

shared hosting. Running PHP 7.4

[LesterLogic]

Also seeing this error after getting the max key length error. Stuck at same point as mukhortov and lolmos. __api.json file does exist in config folder with superadmin token.

[ricoxor]

Same issue. It's because of MariaDB

[ricoxor]

I found a way.
Edit this file : /src/core/Directus/Util/Installation/stubs/config.stub
Change utf8mb4 to utf8
Remove all files in /config
Restart install

[LesterLogic]

Same issue after the above changes. Not running MariaDB.

[LesterLogic]

https://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes

This article on Stack Overflow describes the issue in my case. Running MySQL 5.6. No option to upgrade in my case as I'm on shared hosting.

[lolmos]

have MySQL version 5.6.47-cll-lve. Have tried the change suggested by @ricoxor to no avail.

[LesterLogic]

I got it working on my installation:

Open this file: migrations\install\20180220023152_create_collections_presets_table.php
Change line 15 from 'limit' => 255 to 'limit' => 190

The total key length has to be below 255 characters on MySQL 5.6. I also changed the collation on all tables and columns to utf8_general_ci.

[mukhortov]

Worked for me. Thanks, @LesterLogic! 🙌

[lolmos]

thanks @LesterLogic this works for me too!!

[envake]

@LesterLogic awesome thanks for sharing this!

[cironis-adam]

@LesterLogic Thanks for sharing that. Helped us to! 🙏