Installation will nicht gelingen

nc-detlef · January 18, 2020, 6:21pm

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:

Installation von XAMP, Apache und MySql gestartet
Per phpmyadmin eine neue Datenbank erzeugt: cloud
Per phpmyadmin einen neuen Benutzer angelegt: cloud-Karl, Rechte alle
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’] = ‘’;
Check ob cloud_Karl sich anmelden kann: OK
Check ob cloud_Karl Benutzerkonten anlegen kann: OK
Check ob cloud_Karl Tabellen anlegen kann: OK
Ordner nc unter htdocs angelegt und alle Dateien hineingeschoben
Browser: 127.0.0.1/nc aufgerufen
Daten für adminaccount eingetragen
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

j-ed · January 18, 2020, 4:06pm

Diese Annahme ist korrekt.

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

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"
```
Teste, ob Du von der Konsole auf die Datenbank zugreifen kannst.
```
# mysql -v
   oder
# mysql -v -S <socker-pfad>/mysql.sock
```
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
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.

nc-detlef · January 18, 2020, 4:38pm

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

Reiner_Nippes · January 18, 2020, 4:50pm

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

nc-detlef · January 18, 2020, 5:10pm

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.

j-ed · January 18, 2020, 5:31pm

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?

j-ed · January 18, 2020, 5:33pm

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

Reiner_Nippes · January 18, 2020, 5:55pm

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?

Reiner_Nippes · January 18, 2020, 6:19pm

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

github.com

ReinerNippes/nextcloud/blob/ac5dead0ca92d5e20a7c38766bdce34060a502a3/roles/mariadb/tasks/main.yml#L43


    host_all: yes
    state: absent
    login_unix_socket: "{{ mariadb_socket[ansible_distribution] }}"


- name: remove test db
  mysql_db:
    name: test
    state: absent
    login_unix_socket: "{{ mariadb_socket[ansible_distribution] }}"
  
- name: create nextcloud db
  mysql_db:
    name: "{{ nextcloud_db }}"
    collation: utf8mb4_general_ci
    encoding: utf8mb4
    login_unix_socket: "{{ mariadb_socket[ansible_distribution] }}"


- name: generate db passwd if nextcloud_db_passwd is empty
  set_fact: 
    nextcloud_db_passwd: "{{ lookup('password', '{{ credential_store }}/database_secret chars=ascii_letters,digits length=32') }}"
  when: nextcloud_db_passwd == ''

und mit occ maintenance:install nextcloud initiert.

github.com

ReinerNippes/nextcloud/blob/nextcloud-reloaded/roles/nextcloud/tasks/configure/nextcloud.yml#L34


- name: generate admin passwd if nextcloud_passwd is empty
  set_fact:
    nextcloud_passwd: "{{ lookup('password', '{{ credential_store }}/nextcloud_admin_secret chars=ascii_letters,digits length=32') }}"
  when: nextcloud_passwd == ''


- name: first setup nextcloud
  become_user: "{{ web_user[nextcloud_webserver_type][ansible_os_family] }}"
  become_flags: "{{ ansible_become_flags | default(omit) }}"
  become: yes
  shell: >
    php occ  maintenance:install 
    --database {{ nextcloud_db_type }} 
    --database-host "{{ nextcloud_db_host }}" 
    --database-name {{ nextcloud_db }} 
    --database-table-prefix {{ nextcloud_db_prefix }} 
    --database-user {{ nextcloud_db_user }} 
    --database-pass {{ lookup('password', '{{ credential_store }}/database_secret chars=ascii_letters,digits length=32') }} 
    --admin-user {{ nextcloud_admin }} 
    --admin-pass {{ nextcloud_passwd }} 
    --data-dir {{ nextcloud_data_dir }}
  args:

und das funktioniert seit zwei jahren so.

j-ed · January 18, 2020, 6:29pm

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

Reiner_Nippes · January 18, 2020, 8:02pm

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

nc-detlef · January 19, 2020, 12:11pm

@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

j-ed · January 19, 2020, 12:50pm

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,

nc-detlef · January 19, 2020, 1:02pm

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

nc-detlef · January 23, 2020, 3:21pm

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

lux007 · January 24, 2020, 8:02pm

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.

FloLo · March 20, 2020, 9:16am

Hallo,

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

Danke dafür!!

devnull · March 20, 2020, 9:22am

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

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

Assassins88 · October 6, 2020, 12:45am

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…