Project

General

Profile

Actions

Bug #78885

closed

Install tool database examination fails with non-omnipotent database user

Added by Joschi Kuphal over 7 years ago. Updated over 3 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Category:
Install Tool
Target version:
-
Start date:
2016-12-05
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
8
PHP Version:
7.0
Tags:
Complexity:
Is Regression:
Yes
Sprint Focus:

Description

With a fresh TYPO3 8.4 installation, it seems not possible to successfully run the installation wizard when

  • there are multiple databases,
  • the database user intended for installation * has the global privilege SHOW DATABASES, * has full privileges for the database intended for TYPO3, * has no privileges for all the other databases.

As soon as the database credentials are entered and submitted, it seems all databases get examined (e.g. for existing tables). During this process, the installer obviously even tries to access the databases which the given user has no access privileges for, resulting in the following error (see attached screenshot as well):

An exception occured in driver: Benutzer 'username'@'localhost' hat keine Zugriffsberechtigung für Datenbank 'bla'

(Translation: "User 'username'@'localhost' has no access privileges for database 'bla'". "username" and "bla" have been replaced in the error message. "bla" is another existing database which "username" has no access privileges for.)

After the first appearance of the above mentioned error, the installation attempt cannot be continued under no circumstances ("Oops ..." for all actions; no restart possible). All resources generated by the install tool have to be removed (which practically is a completeley fresh install).

The exact same setup worked (and works) flawlessly with TYPO3 7.x (and possibly before; not sure about TYPO3 8.0 - 8.3, didn't try these).

The only solution right now is to give the database user full access privileges for all databases — which works but surely isn't a viable solution.

Updates:


Files

typo3_install_tool_db_error.png (20.3 KB) typo3_install_tool_db_error.png Joschi Kuphal, 2016-12-05 09:51
Schermata 2018-05-18 alle 23.17.17.png (20.9 KB) Schermata 2018-05-18 alle 23.17.17.png Riccardo De Contardi, 2018-05-19 00:01
Schermata 2018-05-18 alle 23.17.33.png (75.2 KB) Schermata 2018-05-18 alle 23.17.33.png Riccardo De Contardi, 2018-05-19 00:02
Schermata 2018-05-18 alle 23.18.40.png (50 KB) Schermata 2018-05-18 alle 23.18.40.png Riccardo De Contardi, 2018-05-19 00:02
Schermata 2018-05-18 alle 23.27.29.png (70 KB) Schermata 2018-05-18 alle 23.27.29.png Riccardo De Contardi, 2018-05-19 00:02
db.png (31.1 KB) db.png Sybille Peters, 2018-05-20 12:48

Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Task #94978: Remove obosolete LOCK TABLE check from install toolClosedFrank Nägler2021-08-24

Actions
Actions

Also available in: Atom PDF