Installation will nicht gelingen

Vorweg:
ich hatte die Nextcloud schon öfters erfolgreich installiert, sowohl lokal, als auch in Web. Nun will es nicht gelingen und es sind, egal wie ich Parameter verändere immer die gleichen, aber für mich leider nicht nachvollziehbaren Probleme. Gefühlt habe ich in den letzten 3 Tagen das gesamte Internet gelesen und alle – meist recht simplen- Lösungen fruchten nicht.

Meldung bei Installationsversuch:
Error while trying to create admin user: Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [1045] Access denied for user ‘cloud_Karl’@‘localhost’ (using password: YES)

Ich interpretiere daraus, dass cloud_Karl nicht auf die Datenbank zugreifen kann.

Wie ging ich vor:

  1. Installation von XAMP, Apache und MySql gestartet
  2. Per phpmyadmin eine neue Datenbank erzeugt: cloud
  3. Per phpmyadmin einen neuen Benutzer angelegt: cloud-Karl, Rechte alle
  4. Config.inc.php verändert:
    $cfg[‘Servers’][$i][‘auth_type’] = ‘cookie’;
    $cfg[‘Servers’][$i][‘user’] = ‘’;
    $cfg[‘Servers’][$i][‘password’] = ‘’;
    $cfg[‘Servers’][$i][‘extension’] = ‘mysqli’;
    $cfg[‘Servers’][$i][‘AllowNoPassword’] = false;
    $cfg[‘Lang’] = ‘’;
  5. Check ob cloud_Karl sich anmelden kann: OK
  6. Check ob cloud_Karl Benutzerkonten anlegen kann: OK
  7. Check ob cloud_Karl Tabellen anlegen kann: OK
  8. Ordner nc unter htdocs angelegt und alle Dateien hineingeschoben
  9. Browser: 127.0.0.1/nc aufgerufen
  10. Daten für adminaccount eingetragen
  11. Daten für die Datenbank eingetragen:
    Datenbank-Benutzer: cloud_Karl
    Datenbank-Passwort: xxx (das Passwort von cloud_Karl
    Datenbank-Name: cloud
    Datenbank-Host:127.0.0.1:3306

Beim Datenbank-Host habe ich alles probiert 127.0.0.1 oder localhost mit oder ohne Port, habe Port auch mal auf 3307 geändert natürlich auch in der config.

Absolut nichts hat gefruchtet.

Der Frust ist nun ziemlich hoch, weil, ich schon oft nextcloud installierte und nun nach gefühlten 1000 Versuchen es sich nicht lösen lässt.

Wie oben beschrieben, dieses Problem tritt öfters auf aber beschrieben Lösungen scheinen (sollte ich sie richtig umgesetzt haben) nicht fruchten.

Ich freue mich sehr über hilfreiche Hinweise

lg Detlef

Diese Annahme ist korrekt.

Planloses Probieren führt zu selten zu einer Lösung, ich würdest es lieber mit einer strukturierten Vorgehensweise probieren :wink:

  1. Stelle fest ob Deine Datenbank läuft und, auf welchem Port bzw. Socket sie Verbindungen entgegen nimmt (Die Befehle müssen an Deine Gegebenheiten angepasst werden):

    # grep -E "port|socket" /etc/mysql/my.cnf
    # ps -ef | grep "mysql"
    # netstat -lpn |grep "mysql"
    
  2. Teste, ob Du von der Konsole auf die Datenbank zugreifen kannst.

    # mysql -v
       oder
    # mysql -v -S <socker-pfad>/mysql.sock
    
  3. Stelle fest, welche Datenbank-User angelegt sind, über welche Schnittstelle diese zugreifen dürfen und/oder lege bei Bedarf einen User an. Siehe hierzu:

    Db credentials not working after host migration

  4. Entscheide dich wie Du nun auf die Datenbank zugreifen willst, über einen Socket oder über eine Netzwerkverbindung (Hinweis: Eine Socket-Verbindung ist immer schneller als eine Netzwerkbindung) und passe anschließend Deine Nextcloud-Konfiguration an.

vielen Dank für die Antworten
@ j-ed
sehe ich das richtig, dass du aus dem linux-lager kommst?

Bei mir ist alles unter einer windows-haube
die datenbank läuft, denn ich kann darauf zugreifen und damit machen was ich möchte, expliziert auch mit dem aufgeführten Benutzer.
Wenn ich nun deine Punkte 1-3 prüfe, ja es geht, aber eben über phpmyadmin und nicht über die Installationsanweisungen von nextcloud, da gibt es das Rechteproblem

Die Rechte von cloud_Karl sind grant, das Passwort ist bestimmt richtig

ich bin ratlos

ich hab gerade ein déjà-vu… die frage taucht im forum regelmässig auf.
mir ist die lösung aber nicht klar.

Genau Reiner,
das Problem wird immer wieder veröffentlicht und DIE Lösung finde ich oder scheint nicht einfach auffindbar.
Donnerstag und Freitag versuchte ich es auf der Arbeit (win Serv 2019 ) und dann heute den ganzen Tag daheim Win10 Pro, komme mir inzwischen schon zu blöd vor, denn es ist immer das gleiche Problem. Daher denke ich - mehr als null bekommen es hin, das Problem ist ein Grundsätzliches.

Deinen Aussage scheinen eher spekulativen und wenig sicheren Charakter zu haben. Gerade bei einer Windows Installation solltest Du wissen auf, ob der Server über das Netzwerk erreichbar ist und auf welchem Porter hört. (Siehe " Other Database Properties") in der folgenden Beschreibung:

Darüber hinaus scheint unter Windows auch ein Menüpunkt “Command Prompt (MariaDB …” angelegt zu werden. Wenn Du dieses öffnest solltest Du die Abfragen der Datenbankuser durchführen können. Wie ist das Ergebnis?

@Reiner_Nippes Ich stimme Dir hier vollkommen zu. Entweder versuchen sich in letzter Zeit sehr viele IT-Neulinge an dem Thema und glauben “mal eben kurz” ewas installieren zu können oder es gibt ein generelles Problem im Installationsablauf von Nextcloud.

die drei kürzesten computer witze?

  • müsste laufen.
  • ich hab’ nix gemacht.
  • machen wir mal eben kurz.

back2problem: @j-ed irgendeine ahnung, was da schief laufen könnte?

1 Like

@j-ed soweit ist er ja gekommen.

was ist das? hab’ ich noch nie gesehen:

da bräuchte das linux lager mal etwas mehr erläuterung. wie verirrt sich ein lamp-stack auf ein windows. (und nennt man das dann nicht wamp?)

p.s. gerade mal wieder den check gemacht. mein playbook läuft auf einer linux kiste (aws ec2, ubuntu18) mit

curl -s https://raw.githubusercontent.com/ReinerNippes/nextcloud/nextcloud-reloaded/prepare_system.sh | /bin/bash
git clone --branch nextcloud-reloaded https://github.com/ReinerNippes/nextcloud
cd nextcloud
./nextcloud.yml -e "nextcloud_fqdn=your-domain-de nextcloud_webserver_type=nginx nextcloud_certificate_type='acme.sh' nextcloud_db_type=mysql"

sauber durch.

dabei wird die datenbank und der nextcloud-user angelegt:

und mit occ maintenance:install nextcloud initiert.

und das funktioniert seit zwei jahren so.

@Reiner_Nippes Ich habe noch nicht eine Bildschirmausgabe gesehen, die vom “Command Prompt (MariaDB…)” gemacht wurde. Es wird immer nur geschrieben, dass es gehen würde ohne aber den Beweis dafür zu erbringen. Darauf kann man meines Erachtens jedoch nicht aufbauen, da es einfach zu viele mögliche Fehlerquellen gibt.

@nc-detlef so’n SHOW GRANTS FOR 'cloud_Karl'@'localhost'; wäre cool.

@all vielen Dank für die Unterstützung
ich habe heute morgen cloud_Karl entfernt und neu erzeugt

Grants for cloud_Karl@localhost

GRANT ALL PRIVILEGES ON . TO ‘cloud_Karl’@‘localhost’ IDENTIFIED BY PASSWORD ‘*BDDDB6E32434F89AA9FCCED71C50D03C3009CE54’ WITH GRANT OPTION
GRANT ALL PRIVILEGES ON cloud.cloud TO ‘cloud_Karl’@‘localhost’

Und siehe da, es klappt ich vermute nun einfach einen blöden unentdeckten Tippfehler, denn auch gestern hatte ich schon das “Gefühl” alle Rechte seien richtig.

Leider geht es mit fast dem gleichen Problem weiter:

Error while trying to create admin user: Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [1045] Access denied for user ‘oc_detlef’@‘localhost’ (using password: YES)

Der Benutzer oc_detlef wurde jedoch in der Datenbank eingetragen worden

Wofür sollte dieser User sein bzw. wofür hast Du diesen eingerichtet, in die Nextcloud-Konfigurationsdatei? Nextcloud verwendet üblicherweise einen einzigen Datenbank-User um Daten aus den eigenen Tabellen zu lesen oder zu schreiben,

hallo j-ed

wenn ich die installation starte werde ich doch aufgefordert für die nextcloud ein Administartorkonto anzulegen. Um genau diesen User handelt es sich

hier die dazugehörige Maske

seit nun fast einer woche bin ich daran den Fehler zu finden. Es möchte einfach nicht klappen.

Ich finde es verwunderlich, dass der Admin-Account angelegt wird aber ein Passwort nicht in der Datenbank zu finden ist.

Bitte, vieleicht hat einer eine Idee.

hier mal den ersten Teil der log-datei

{“reqId”:“NdofBRsFKmfI5adSGFJb”,“level”:3,“time”:“2020-01-23T14:27:08+00:00”,“remoteAddr”:“127.0.0.1”,“user”:"–",“app”:“PHP”,“method”:“GET”,“url”:"/nextcloud/",“message”:“You are using a fallback implementation of the intl extension. Installing the native one is highly recommended instead. at C:\xampp\htdocs\nextcloud\3rdparty\patchwork\utf8\src\Patchwork\Utf8\Bootup\intl.php#18”,“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0”,“version”:""}
{“reqId”:“RGMCoA0VxnP04UMZ6E4N”,“level”:3,“time”:“2020-01-23T14:27:39+00:00”,“remoteAddr”:“127.0.0.1”,“user”:"–",“app”:“mysql.setup”,“method”:“POST”,“url”:"/nextcloud/index.php",“message”:{“Exception”:“Doctrine\DBAL\Exception\SyntaxErrorException”,“Message”:“An exception occurred while executing ‘CREATE USER ‘oc_detlef’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘XwDvNoVLm971J7wijVj1+W1dKwGlpc’’:\n\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘BY ‘XwDvNoVLm971J7wijVj1+W1dKwGlpc’’ at line 1”,“Code”:0,“Trace”:[{“file”:“C:\xampp\htdocs\nextcloud\3rdparty\doctrine\dbal\lib\Doctrine\DBAL\DBALException.php”,“line”:169,“function”:“convertException”,“class”:“Doctrine\DBAL\Driver\AbstractMySQLDriver”,“type”:"->",“args”:[“An exception occurred while executing ‘CREATE USER ‘oc_detlef’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘XwDvNoVLm971J7wijVj1+W1dKwGlpc’’:\n\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘BY ‘XwDvNoVLm971J7wijVj1+W1dKwGlpc’’ at line 1”,{“errorInfo”:[“42000”,1064,“You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘BY ‘XwDvNoVLm971J7wijVj1+W1dKwGlpc’’ at line 1”],“class”:“Doctrine\DBAL\Driver\PDOException”}]},{“file”:“C:\xampp\htdocs\nextcloud\3rdparty\doctrine\dbal\lib\Doctrine\DBAL\DBALException.php”,“line”:145,“function”:“wrapException”,“class”:“Doctrine\DBAL\DBALException”,“type”:"::",“args”:[{“class”:“Doctrine\DBAL\Driver\PDOMySql\Driver”},{“errorInfo”:[“42000”,1064,“You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘BY ‘XwDvNoVLm971J7wijVj1+W1dKwGlpc’’ at line 1”],“class”:“Doctrine\DBAL\Driver\PDOException”},“An exception occurred while executing ‘CREATE USER ‘oc_detlef’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘XwDvNoVLm971J7wijVj1+W1dKwGlpc’’:\n\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘BY ‘XwDvNoVLm971J7wijVj1+W1dKwGlpc’’ at line 1”]},{“file”:“C:\xampp\htdocs\nextcloud\3rdparty\doctrine\dbal\lib\Doctrine\DBAL\Connection.php”,“line”:1063,“function”:“driverExceptionDuringQuery”,“class”:“Doctrine\DBAL\DBALException”,“type”:"::",“args”:[{“class”:“Doctrine\DBAL\Driver\PDOMySql\Driver”},{“errorInfo”:[“42000”,1064,“You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘BY ‘XwDvNoVLm971J7wijVj1+W1dKwGlpc’’ at line 1”],“class”:“Doctrine\DBAL\Driver\PDOException”},“CREATE USER ‘oc_detlef’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘XwDvNoVLm971J7wijVj1+W1dKwGlpc’”,[]]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\DB\Connection.php”,“line”:220,“function”:“executeUpdate”,“class”:“Doctrine\DBAL\Connection”,“type”:"->",“args”:[“CREATE USER ‘oc_detlef’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘XwDvNoVLm971J7wijVj1+W1dKwGlpc’”,[],[]]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup\MySQL.php”,“line”:106,“function”:“executeUpdate”,“class”:“OC\DB\Connection”,“type”:"->",“args”:[“CREATE USER ‘oc_detlef’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘XwDvNoVLm971J7wijVj1+W1dKwGlpc’”]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup\MySQL.php”,“line”:151,“function”:“createDBUser”,“class”:“OC\Setup\MySQL”,“type”:"->",“args”:[{“class”:“OC\DB\Connection”}]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup\MySQL.php”,“line”:52,“function”:“createSpecificUser”,“class”:“OC\Setup\MySQL”,“type”:"->",“args”:[“detlef”,{“class”:“OC\DB\Connection”}]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup.php”,“line”:358,“function”:“setupDatabase”,“class”:“OC\Setup\MySQL”,“type”:"->",“args”:[“detlef”]},{“file”:“C:\xampp\htdocs\nextcloud\core\Controller\SetupController.php”,“line”:76,“function”:“install”,“class”:“OC\Setup”,“type”:"->",“args”:["*** sensitive parameters replaced "]},{“file”:“C:\xampp\htdocs\nextcloud\lib\base.php”,“line”:946,“function”:“run”,“class”:“OC\Core\Controller\SetupController”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:“C:\xampp\htdocs\nextcloud\index.php”,“line”:38,“function”:“handleRequest”,“class”:“OC”,“type”:"::",“args”:[]}],“File”:“C:\xampp\htdocs\nextcloud\3rdparty\doctrine\dbal\lib\Doctrine\DBAL\Driver\AbstractMySQLDriver.php”,“Line”:79,“Previous”:{“Exception”:“Doctrine\DBAL\Driver\PDOException”,“Message”:“SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘BY ‘XwDvNoVLm971J7wijVj1+W1dKwGlpc’’ at line 1”,“Code”:“42000”,“Trace”:[{“file”:“C:\xampp\htdocs\nextcloud\3rdparty\doctrine\dbal\lib\Doctrine\DBAL\Connection.php”,“line”:1060,“function”:“exec”,“class”:“Doctrine\DBAL\Driver\PDOConnection”,“type”:"->",“args”:[“CREATE USER ‘oc_detlef’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘XwDvNoVLm971J7wijVj1+W1dKwGlpc’”]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\DB\Connection.php”,“line”:220,“function”:“executeUpdate”,“class”:“Doctrine\DBAL\Connection”,“type”:"->",“args”:[“CREATE USER ‘oc_detlef’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘XwDvNoVLm971J7wijVj1+W1dKwGlpc’”,[],[]]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup\MySQL.php”,“line”:106,“function”:“executeUpdate”,“class”:“OC\DB\Connection”,“type”:"->",“args”:[“CREATE USER ‘oc_detlef’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘XwDvNoVLm971J7wijVj1+W1dKwGlpc’”]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup\MySQL.php”,“line”:151,“function”:“createDBUser”,“class”:“OC\Setup\MySQL”,“type”:"->",“args”:[{“class”:“OC\DB\Connection”}]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup\MySQL.php”,“line”:52,“function”:“createSpecificUser”,“class”:“OC\Setup\MySQL”,“type”:"->",“args”:[“detlef”,{“class”:“OC\DB\Connection”}]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup.php”,“line”:358,“function”:“setupDatabase”,“class”:“OC\Setup\MySQL”,“type”:"->",“args”:[“detlef”]},{“file”:“C:\xampp\htdocs\nextcloud\core\Controller\SetupController.php”,“line”:76,“function”:“install”,“class”:“OC\Setup”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:“C:\xampp\htdocs\nextcloud\lib\base.php”,“line”:946,“function”:“run”,“class”:“OC\Core\Controller\SetupController”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:“C:\xampp\htdocs\nextcloud\index.php”,“line”:38,“function”:“handleRequest”,“class”:“OC”,“type”:"::",“args”:[]}],“File”:“C:\xampp\htdocs\nextcloud\3rdparty\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php”,“Line”:43,“Previous”:{“Exception”:“PDOException”,“Message”:“SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘BY ‘XwDvNoVLm971J7wijVj1+W1dKwGlpc’’ at line 1”,“Code”:“42000”,“Trace”:[{“file”:“C:\xampp\htdocs\nextcloud\3rdparty\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php”,“line”:41,“function”:“exec”,“class”:“PDO”,“type”:"->",“args”:[“CREATE USER ‘oc_detlef’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘XwDvNoVLm971J7wijVj1+W1dKwGlpc’”]},{“file”:“C:\xampp\htdocs\nextcloud\3rdparty\doctrine\dbal\lib\Doctrine\DBAL\Connection.php”,“line”:1060,“function”:“exec”,“class”:“Doctrine\DBAL\Driver\PDOConnection”,“type”:"->",“args”:[“CREATE USER ‘oc_detlef’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘XwDvNoVLm971J7wijVj1+W1dKwGlpc’”]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\DB\Connection.php”,“line”:220,“function”:“executeUpdate”,“class”:“Doctrine\DBAL\Connection”,“type”:"->",“args”:[“CREATE USER ‘oc_detlef’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘XwDvNoVLm971J7wijVj1+W1dKwGlpc’”,[],[]]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup\MySQL.php”,“line”:106,“function”:“executeUpdate”,“class”:“OC\DB\Connection”,“type”:"->",“args”:[“CREATE USER ‘oc_detlef’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘XwDvNoVLm971J7wijVj1+W1dKwGlpc’”]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup\MySQL.php”,“line”:151,“function”:“createDBUser”,“class”:“OC\Setup\MySQL”,“type”:"->",“args”:[{“class”:“OC\DB\Connection”}]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup\MySQL.php”,“line”:52,“function”:“createSpecificUser”,“class”:“OC\Setup\MySQL”,“type”:"->",“args”:[“detlef”,{“class”:“OC\DB\Connection”}]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup.php”,“line”:358,“function”:“setupDatabase”,“class”:“OC\Setup\MySQL”,“type”:"->",“args”:[“detlef”]},{“file”:“C:\xampp\htdocs\nextcloud\core\Controller\SetupController.php”,“line”:76,“function”:“install”,“class”:“OC\Setup”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:“C:\xampp\htdocs\nextcloud\lib\base.php”,“line”:946,“function”:“run”,“class”:“OC\Core\Controller\SetupController”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:“C:\xampp\htdocs\nextcloud\index.php”,“line”:38,“function”:“handleRequest”,“class”:“OC”,“type”:"::",“args”:[]}],“File”:“C:\xampp\htdocs\nextcloud\3rdparty\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php”,“Line”:41}},“CustomMessage”:“Database user creation failed.”},“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0”,“version”:“18.0.0.10”}
{“reqId”:“RGMCoA0VxnP04UMZ6E4N”,“level”:3,“time”:“2020-01-23T14:27:39+00:00”,“remoteAddr”:“127.0.0.1”,“user”:"–",“app”:“PHP”,“method”:“POST”,“url”:"/nextcloud/index.php",“message”:“You are using a fallback implementation of the intl extension. Installing the native one is highly recommended instead. at C:\xampp\htdocs\nextcloud\3rdparty\patchwork\utf8\src\Patchwork\Utf8\Bootup\intl.php#18”,“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0”,“version”:“18.0.0.10”}
{“reqId”:“ewF790jHF6eUR0CCoiHa”,“level”:3,“time”:“2020-01-23T14:37:43+00:00”,“remoteAddr”:“127.0.0.1”,“user”:"–",“app”:“mysql.setup”,“method”:“POST”,“url”:"/nextcloud/index.php",“message”:{“Exception”:“Doctrine\DBAL\Exception\SyntaxErrorException”,“Message”:“An exception occurred while executing ‘CREATE USER ‘oc_cloud_Karl’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘+khrqq5KNhtPcJ8wRFRz7KOJAVQeW2’’:\n\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘BY ‘+khrqq5KNhtPcJ8wRFRz7KOJAVQeW2’’ at line 1”,“Code”:0,“Trace”:[{“file”:“C:\xampp\htdocs\nextcloud\3rdparty\doctrine\dbal\lib\Doctrine\DBAL\DBALException.php”,“line”:169,“function”:“convertException”,“class”:“Doctrine\DBAL\Driver\AbstractMySQLDriver”,“type”:"->",“args”:[“An exception occurred while executing ‘CREATE USER ‘oc_cloud_Karl’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘+khrqq5KNhtPcJ8wRFRz7KOJAVQeW2’’:\n\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘BY ‘+khrqq5KNhtPcJ8wRFRz7KOJAVQeW2’’ at line 1”,{“errorInfo”:[“42000”,1064,“You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘BY ‘+khrqq5KNhtPcJ8wRFRz7KOJAVQeW2’’ at line 1”],“class”:“Doctrine\DBAL\Driver\PDOException”}]},{“file”:“C:\xampp\htdocs\nextcloud\3rdparty\doctrine\dbal\lib\Doctrine\DBAL\DBALException.php”,“line”:145,“function”:“wrapException”,“class”:“Doctrine\DBAL\DBALException”,“type”:"::",“args”:[{“class”:“Doctrine\DBAL\Driver\PDOMySql\Driver”},{“errorInfo”:[“42000”,1064,“You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘BY ‘+khrqq5KNhtPcJ8wRFRz7KOJAVQeW2’’ at line 1”],“class”:“Doctrine\DBAL\Driver\PDOException”},“An exception occurred while executing ‘CREATE USER ‘oc_cloud_Karl’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘+khrqq5KNhtPcJ8wRFRz7KOJAVQeW2’’:\n\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘BY ‘+khrqq5KNhtPcJ8wRFRz7KOJAVQeW2’’ at line 1”]},{“file”:“C:\xampp\htdocs\nextcloud\3rdparty\doctrine\dbal\lib\Doctrine\DBAL\Connection.php”,“line”:1063,“function”:“driverExceptionDuringQuery”,“class”:“Doctrine\DBAL\DBALException”,“type”:"::",“args”:[{“class”:“Doctrine\DBAL\Driver\PDOMySql\Driver”},{“errorInfo”:[“42000”,1064,“You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘BY ‘+khrqq5KNhtPcJ8wRFRz7KOJAVQeW2’’ at line 1”],“class”:“Doctrine\DBAL\Driver\PDOException”},“CREATE USER ‘oc_cloud_Karl’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘+khrqq5KNhtPcJ8wRFRz7KOJAVQeW2’”,[]]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\DB\Connection.php”,“line”:220,“function”:“executeUpdate”,“class”:“Doctrine\DBAL\Connection”,“type”:"->",“args”:[“CREATE USER ‘oc_cloud_Karl’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘+khrqq5KNhtPcJ8wRFRz7KOJAVQeW2’”,[],[]]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup\MySQL.php”,“line”:106,“function”:“executeUpdate”,“class”:“OC\DB\Connection”,“type”:"->",“args”:[“CREATE USER ‘oc_cloud_Karl’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘+khrqq5KNhtPcJ8wRFRz7KOJAVQeW2’”]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup\MySQL.php”,“line”:151,“function”:“createDBUser”,“class”:“OC\Setup\MySQL”,“type”:"->",“args”:[{“class”:“OC\DB\Connection”}]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup\MySQL.php”,“line”:52,“function”:“createSpecificUser”,“class”:“OC\Setup\MySQL”,“type”:"->",“args”:[“cloud_Karl”,{“class”:“OC\DB\Connection”}]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup.php”,“line”:358,“function”:“setupDatabase”,“class”:“OC\Setup\MySQL”,“type”:"->",“args”:[“cloud_Karl”]},{“file”:“C:\xampp\htdocs\nextcloud\core\Controller\SetupController.php”,“line”:76,“function”:“install”,“class”:“OC\Setup”,“type”:"->",“args”:["
sensitive parameters replaced "]},{“file”:“C:\xampp\htdocs\nextcloud\lib\base.php”,“line”:946,“function”:“run”,“class”:“OC\Core\Controller\SetupController”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:“C:\xampp\htdocs\nextcloud\index.php”,“line”:38,“function”:“handleRequest”,“class”:“OC”,“type”:"::",“args”:[]}],“File”:“C:\xampp\htdocs\nextcloud\3rdparty\doctrine\dbal\lib\Doctrine\DBAL\Driver\AbstractMySQLDriver.php”,“Line”:79,“Previous”:{“Exception”:“Doctrine\DBAL\Driver\PDOException”,“Message”:“SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘BY ‘+khrqq5KNhtPcJ8wRFRz7KOJAVQeW2’’ at line 1”,“Code”:“42000”,“Trace”:[{“file”:“C:\xampp\htdocs\nextcloud\3rdparty\doctrine\dbal\lib\Doctrine\DBAL\Connection.php”,“line”:1060,“function”:“exec”,“class”:“Doctrine\DBAL\Driver\PDOConnection”,“type”:"->",“args”:[“CREATE USER ‘oc_cloud_Karl’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘+khrqq5KNhtPcJ8wRFRz7KOJAVQeW2’”]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\DB\Connection.php”,“line”:220,“function”:“executeUpdate”,“class”:“Doctrine\DBAL\Connection”,“type”:"->",“args”:[“CREATE USER ‘oc_cloud_Karl’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘+khrqq5KNhtPcJ8wRFRz7KOJAVQeW2’”,[],[]]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup\MySQL.php”,“line”:106,“function”:“executeUpdate”,“class”:“OC\DB\Connection”,“type”:"->",“args”:[“CREATE USER ‘oc_cloud_Karl’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘+khrqq5KNhtPcJ8wRFRz7KOJAVQeW2’”]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup\MySQL.php”,“line”:151,“function”:“createDBUser”,“class”:“OC\Setup\MySQL”,“type”:"->",“args”:[{“class”:“OC\DB\Connection”}]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup\MySQL.php”,“line”:52,“function”:“createSpecificUser”,“class”:“OC\Setup\MySQL”,“type”:"->",“args”:[“cloud_Karl”,{“class”:“OC\DB\Connection”}]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup.php”,“line”:358,“function”:“setupDatabase”,“class”:“OC\Setup\MySQL”,“type”:"->",“args”:[“cloud_Karl”]},{“file”:“C:\xampp\htdocs\nextcloud\core\Controller\SetupController.php”,“line”:76,“function”:“install”,“class”:“OC\Setup”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:“C:\xampp\htdocs\nextcloud\lib\base.php”,“line”:946,“function”:“run”,“class”:“OC\Core\Controller\SetupController”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:“C:\xampp\htdocs\nextcloud\index.php”,“line”:38,“function”:“handleRequest”,“class”:“OC”,“type”:"::",“args”:[]}],“File”:“C:\xampp\htdocs\nextcloud\3rdparty\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php”,“Line”:43,“Previous”:{“Exception”:“PDOException”,“Message”:“SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘BY ‘+khrqq5KNhtPcJ8wRFRz7KOJAVQeW2’’ at line 1”,“Code”:“42000”,“Trace”:[{“file”:“C:\xampp\htdocs\nextcloud\3rdparty\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php”,“line”:41,“function”:“exec”,“class”:“PDO”,“type”:"->",“args”:[“CREATE USER ‘oc_cloud_Karl’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘+khrqq5KNhtPcJ8wRFRz7KOJAVQeW2’”]},{“file”:“C:\xampp\htdocs\nextcloud\3rdparty\doctrine\dbal\lib\Doctrine\DBAL\Connection.php”,“line”:1060,“function”:“exec”,“class”:“Doctrine\DBAL\Driver\PDOConnection”,“type”:"->",“args”:[“CREATE USER ‘oc_cloud_Karl’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘+khrqq5KNhtPcJ8wRFRz7KOJAVQeW2’”]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\DB\Connection.php”,“line”:220,“function”:“executeUpdate”,“class”:“Doctrine\DBAL\Connection”,“type”:"->",“args”:[“CREATE USER ‘oc_cloud_Karl’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘+khrqq5KNhtPcJ8wRFRz7KOJAVQeW2’”,[],[]]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup\MySQL.php”,“line”:106,“function”:“executeUpdate”,“class”:“OC\DB\Connection”,“type”:"->",“args”:[“CREATE USER ‘oc_cloud_Karl’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘+khrqq5KNhtPcJ8wRFRz7KOJAVQeW2’”]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup\MySQL.php”,“line”:151,“function”:“createDBUser”,“class”:“OC\Setup\MySQL”,“type”:"->",“args”:[{“class”:“OC\DB\Connection”}]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup\MySQL.php”,“line”:52,“function”:“createSpecificUser”,“class”:“OC\Setup\MySQL”,“type”:"->",“args”:[“cloud_Karl”,{“class”:“OC\DB\Connection”}]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup.php”,“line”:358,“function”:“setupDatabase”,“class”:“OC\Setup\MySQL”,“type”:"->",“args”:[“cloud_Karl”]},{“file”:“C:\xampp\htdocs\nextcloud\core\Controller\SetupController.php”,“line”:76,“function”:“install”,“class”:“OC\Setup”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:“C:\xampp\htdocs\nextcloud\lib\base.php”,“line”:946,“function”:“run”,“class”:“OC\Core\Controller\SetupController”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:“C:\xampp\htdocs\nextcloud\index.php”,“line”:38,“function”:“handleRequest”,“class”:“OC”,“type”:"::",“args”:[]}],“File”:“C:\xampp\htdocs\nextcloud\3rdparty\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php”,“Line”:41}},“CustomMessage”:“Database user creation failed.”},“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0”,“version”:“18.0.0.10”}
{“reqId”:“ewF790jHF6eUR0CCoiHa”,“level”:3,“time”:“2020-01-23T14:37:43+00:00”,“remoteAddr”:“127.0.0.1”,“user”:"–",“app”:“PHP”,“method”:“POST”,“url”:"/nextcloud/index.php",“message”:“You are using a fallback implementation of the intl extension. Installing the native one is highly recommended instead. at C:\xampp\htdocs\nextcloud\3rdparty\patchwork\utf8\src\Patchwork\Utf8\Bootup\intl.php#18”,“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0”,“version”:“18.0.0.10”}
{“reqId”:“7TW5DOeNOc2GHJDWs0Yk”,“level”:3,“time”:“2020-01-23T14:38:54+00:00”,“remoteAddr”:“127.0.0.1”,“user”:"–",“app”:“PHP”,“method”:“POST”,“url”:"/nextcloud/index.php",“message”:“You are using a fallback implementation of the intl extension. Installing the native one is highly recommended instead. at C:\xampp\htdocs\nextcloud\3rdparty\patchwork\utf8\src\Patchwork\Utf8\Bootup\intl.php#18”,“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0”,“version”:“18.0.0.10”}
{“reqId”:“h9ftNxHQymjESTjMAqSu”,“level”:3,“time”:“2020-01-23T14:39:29+00:00”,“remoteAddr”:“127.0.0.1”,“user”:"–",“app”:“mysql.setup”,“method”:“POST”,“url”:"/nextcloud/index.php",“message”:{“Exception”:“Doctrine\DBAL\Exception\SyntaxErrorException”,“Message”:“An exception occurred while executing ‘CREATE USER ‘oc_Detlef’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘29ZsUzJhEj8C7ZC2lc2HZFjLP8pfKE’’:\n\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘BY ‘29ZsUzJhEj8C7ZC2lc2HZFjLP8pfKE’’ at line 1”,“Code”:0,“Trace”:[{“file”:“C:\xampp\htdocs\nextcloud\3rdparty\doctrine\dbal\lib\Doctrine\DBAL\DBALException.php”,“line”:169,“function”:“convertException”,“class”:“Doctrine\DBAL\Driver\AbstractMySQLDriver”,“type”:"->",“args”:[“An exception occurred while executing ‘CREATE USER ‘oc_Detlef’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘29ZsUzJhEj8C7ZC2lc2HZFjLP8pfKE’’:\n\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘BY ‘29ZsUzJhEj8C7ZC2lc2HZFjLP8pfKE’’ at line 1”,{“errorInfo”:[“42000”,1064,“You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘BY ‘29ZsUzJhEj8C7ZC2lc2HZFjLP8pfKE’’ at line 1”],“class”:“Doctrine\DBAL\Driver\PDOException”}]},{“file”:“C:\xampp\htdocs\nextcloud\3rdparty\doctrine\dbal\lib\Doctrine\DBAL\DBALException.php”,“line”:145,“function”:“wrapException”,“class”:“Doctrine\DBAL\DBALException”,“type”:"::",“args”:[{“class”:“Doctrine\DBAL\Driver\PDOMySql\Driver”},{“errorInfo”:[“42000”,1064,“You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘BY ‘29ZsUzJhEj8C7ZC2lc2HZFjLP8pfKE’’ at line 1”],“class”:“Doctrine\DBAL\Driver\PDOException”},“An exception occurred while executing ‘CREATE USER ‘oc_Detlef’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘29ZsUzJhEj8C7ZC2lc2HZFjLP8pfKE’’:\n\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘BY ‘29ZsUzJhEj8C7ZC2lc2HZFjLP8pfKE’’ at line 1”]},{“file”:“C:\xampp\htdocs\nextcloud\3rdparty\doctrine\dbal\lib\Doctrine\DBAL\Connection.php”,“line”:1063,“function”:“driverExceptionDuringQuery”,“class”:“Doctrine\DBAL\DBALException”,“type”:"::",“args”:[{“class”:“Doctrine\DBAL\Driver\PDOMySql\Driver”},{“errorInfo”:[“42000”,1064,“You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘BY ‘29ZsUzJhEj8C7ZC2lc2HZFjLP8pfKE’’ at line 1”],“class”:“Doctrine\DBAL\Driver\PDOException”},“CREATE USER ‘oc_Detlef’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘29ZsUzJhEj8C7ZC2lc2HZFjLP8pfKE’”,[]]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\DB\Connection.php”,“line”:220,“function”:“executeUpdate”,“class”:“Doctrine\DBAL\Connection”,“type”:"->",“args”:[“CREATE USER ‘oc_Detlef’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘29ZsUzJhEj8C7ZC2lc2HZFjLP8pfKE’”,[],[]]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup\MySQL.php”,“line”:106,“function”:“executeUpdate”,“class”:“OC\DB\Connection”,“type”:"->",“args”:[“CREATE USER ‘oc_Detlef’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘29ZsUzJhEj8C7ZC2lc2HZFjLP8pfKE’”]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup\MySQL.php”,“line”:151,“function”:“createDBUser”,“class”:“OC\Setup\MySQL”,“type”:"->",“args”:[{“class”:“OC\DB\Connection”}]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup\MySQL.php”,“line”:52,“function”:“createSpecificUser”,“class”:“OC\Setup\MySQL”,“type”:"->",“args”:[“Detlef”,{“class”:“OC\DB\Connection”}]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup.php”,“line”:358,“function”:“setupDatabase”,“class”:“OC\Setup\MySQL”,“type”:"->",“args”:[“Detlef”]},{“file”:“C:\xampp\htdocs\nextcloud\core\Controller\SetupController.php”,“line”:76,“function”:“install”,“class”:“OC\Setup”,“type”:"->",“args”:["
sensitive parameters replaced "]},{“file”:“C:\xampp\htdocs\nextcloud\lib\base.php”,“line”:946,“function”:“run”,“class”:“OC\Core\Controller\SetupController”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:“C:\xampp\htdocs\nextcloud\index.php”,“line”:38,“function”:“handleRequest”,“class”:“OC”,“type”:"::",“args”:[]}],“File”:“C:\xampp\htdocs\nextcloud\3rdparty\doctrine\dbal\lib\Doctrine\DBAL\Driver\AbstractMySQLDriver.php”,“Line”:79,“Previous”:{“Exception”:“Doctrine\DBAL\Driver\PDOException”,“Message”:“SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘BY ‘29ZsUzJhEj8C7ZC2lc2HZFjLP8pfKE’’ at line 1”,“Code”:“42000”,“Trace”:[{“file”:“C:\xampp\htdocs\nextcloud\3rdparty\doctrine\dbal\lib\Doctrine\DBAL\Connection.php”,“line”:1060,“function”:“exec”,“class”:“Doctrine\DBAL\Driver\PDOConnection”,“type”:"->",“args”:[“CREATE USER ‘oc_Detlef’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘29ZsUzJhEj8C7ZC2lc2HZFjLP8pfKE’”]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\DB\Connection.php”,“line”:220,“function”:“executeUpdate”,“class”:“Doctrine\DBAL\Connection”,“type”:"->",“args”:[“CREATE USER ‘oc_Detlef’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘29ZsUzJhEj8C7ZC2lc2HZFjLP8pfKE’”,[],[]]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup\MySQL.php”,“line”:106,“function”:“executeUpdate”,“class”:“OC\DB\Connection”,“type”:"->",“args”:[“CREATE USER ‘oc_Detlef’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘29ZsUzJhEj8C7ZC2lc2HZFjLP8pfKE’”]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup\MySQL.php”,“line”:151,“function”:“createDBUser”,“class”:“OC\Setup\MySQL”,“type”:"->",“args”:[{“class”:“OC\DB\Connection”}]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup\MySQL.php”,“line”:52,“function”:“createSpecificUser”,“class”:“OC\Setup\MySQL”,“type”:"->",“args”:[“Detlef”,{“class”:“OC\DB\Connection”}]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup.php”,“line”:358,“function”:“setupDatabase”,“class”:“OC\Setup\MySQL”,“type”:"->",“args”:[“Detlef”]},{“file”:“C:\xampp\htdocs\nextcloud\core\Controller\SetupController.php”,“line”:76,“function”:“install”,“class”:“OC\Setup”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:“C:\xampp\htdocs\nextcloud\lib\base.php”,“line”:946,“function”:“run”,“class”:“OC\Core\Controller\SetupController”,“type”:"->",“args”:[" sensitive parameters replaced ***"]},{“file”:“C:\xampp\htdocs\nextcloud\index.php”,“line”:38,“function”:“handleRequest”,“class”:“OC”,“type”:"::",“args”:[]}],“File”:“C:\xampp\htdocs\nextcloud\3rdparty\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php”,“Line”:43,“Previous”:{“Exception”:“PDOException”,“Message”:“SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘BY ‘29ZsUzJhEj8C7ZC2lc2HZFjLP8pfKE’’ at line 1”,“Code”:“42000”,“Trace”:[{“file”:“C:\xampp\htdocs\nextcloud\3rdparty\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php”,“line”:41,“function”:“exec”,“class”:“PDO”,“type”:"->",“args”:[“CREATE USER ‘oc_Detlef’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘29ZsUzJhEj8C7ZC2lc2HZFjLP8pfKE’”]},{“file”:“C:\xampp\htdocs\nextcloud\3rdparty\doctrine\dbal\lib\Doctrine\DBAL\Connection.php”,“line”:1060,“function”:“exec”,“class”:“Doctrine\DBAL\Driver\PDOConnection”,“type”:"->",“args”:[“CREATE USER ‘oc_Detlef’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘29ZsUzJhEj8C7ZC2lc2HZFjLP8pfKE’”]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\DB\Connection.php”,“line”:220,“function”:“executeUpdate”,“class”:“Doctrine\DBAL\Connection”,“type”:"->",“args”:[“CREATE USER ‘oc_Detlef’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘29ZsUzJhEj8C7ZC2lc2HZFjLP8pfKE’”,[],[]]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup\MySQL.php”,“line”:106,“function”:“executeUpdate”,“class”:“OC\DB\Connection”,“type”:"->",“args”:[“CREATE USER ‘oc_Detlef’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘29ZsUzJhEj8C7ZC2lc2HZFjLP8pfKE’”]},{“file”:“C:\xampp\htdocs\nextcloud\lib\private\Setup\MySQL.php”,“line”:151,“function”:“createDBUser”,“class”:“OC\Setup\MySQL”,“type”:"->",“args”:[{“class”:“OC\DB\Connection”}]},{“file”:"C:\xampp\htdocs\nextcloud\lib\private\Setup

Nach dem letzten Update von MariaDB auf die Version 10.3 bekomme ich die gleiche Fehlermeldung. Mit dem Update wurden automatisch neue Passwortrichtlinien aktiviert. (System ist ein Synology NAS).

Problem ist die Syntax zum Anlegen des neuen Datenbank-Benutzers für die Nextcloud. In phpmyadmin erhalte ich folgende Fehlermeldung, wenn ich den DB-User manuell anlegen möchte (mit den gleichen Parametern wie im Logfile!):

SQL-Befehl: CREATE USER ‘oc_muster’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘XwDvNoVLm971J7wijVj1+W1dKwGlpc’
MySQL meldet: #1064 - Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen bei 'BY ‘XwDvNoVLm971J7wijVj1+W1dKwGlpc’' in Zeile 

Aktuell gelingt die Installation nur nach manueller Bearbeitung einer Datei und ändern von 2 Zeilen vor dem Installationsaufruf:

Datei im Nextcloud-Verzeichnis: nextcloud/lib/private/Setup/MySQL.php

Orginal:

$query = “CREATE USER ‘$name’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘$password’”;

Ändern in:

$query = “CREATE USER ‘$name’@‘localhost’ IDENTIFIED BY ‘$password’”;

Orginal:

$query = “CREATE USER ‘$name’@’%’ IDENTIFIED WITH mysql_native_password BY ‘$password’”;

Ändern in:

$query = “CREATE USER ‘$name’@’%’ IDENTIFIED BY ‘$password’”;

Ohne “WITH mysql_native_password” läuft bei mir die Installation durch. Vielleicht einfach mal ausprobieren.

2 Likes

Hallo,

super, genau der Hinweis hat mich in der gleichen Konstellation (MariaDB 10.3 auf Synology) weiter gebracht!

Danke dafür!!

Wenn ich schon Windows und XMPP lese, braucht man sich nicht mehr wundern.

Eine wirklich gute Anleitung für Debian GNU/Linux ist: