Good day. Faced a problem with MariaDB. Poke your nose where you made a mistake, did everything according to the instructions.
But as a result, an error occurs on the setup completion screen (when creating the admin user): Error while trying to create admin user: Failed to connect to the database: An exception occurred in driver: SQLSTATE [HY000] [2002] Connection refused! %D0%A1%D0%BD%D0%B8%D0%BC%D0%BE%D0%BA|200x500
on DSM 1, MariaDB user is root. The service is up and running, through phpMyAdmin I go in and can create a database. I can’t understand why Nextcloud doesn’t connect
login as: advkosse advkosse@192.168.1.121’s password:
Could not chdir to home directory /var/services/homes/advkosse: No such file or directory
advkosse@Advkosse_DS:/$ MariaDB [(none)]> select user,host from mysql.user;
-sh: syntax error near unexpected token (' advkosse@Advkosse_DS:/$ MariaDB [(none)]> select user,host,db from mysql.db; -sh: syntax error near unexpected token (’
advkosse@Advkosse_DS:/$
Commands for DSM is not also default linux, and I cannot find all commands for DSM
Would it be possible that you’ve tried to enter “MariaDB [(none)]> select user,host,db from mysql.db;” on the console? If yes, it seems that you haven’t got much database knowledge, have you?
The described commands are sql commands which can only be executing when you’ve already established a successful database connection. You first have to execute the “mysql” command on the console. Once you’ve executed it, you should see the database prompt “MariaDB [(none)]>”. At this prompt you need to enter the sql command, e.g. “select user,host,db from mysql.db;”.