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 - #2 by j-ed

  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:

https://mariadb.com/kb/en/installing-mariadb-msi-packages-on-windows/

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.

1 Like

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?

2 Likes

@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.

3 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:

Auch bei mir hat das geholfen. Danke dir dafĂŒr. Super Tipp.

MySQL geht mir echt auf den Sack. Aller furz lang Àndern die den Syntax. Findest Threads die teilweise gerade mal nen Monat alt sind und man bekommt dennoch eine Meldung das der Syntax nicht stimmt. Regt mich sowas von auf