Fanfurlio
-
Posts
3 -
Joined
-
Last visited
Posts posted by Fanfurlio
-
-
You're spot on, if I try to execute the same query from the command line client, I get the same error:
MariaDB [(none)]> CREATE USER 'froxlor'@'localhost' IDENTIFIED WITH mysql_native_password BY 'random_garbage'; ERROR 1064 (42000): 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 'random_garbage'' at line 1
The only way I can create an user on the CentOS standard MariaDB installation using old mysql SHA1 passwords is
MariaDB [(none)]> CREATE USER 'froxlor'@'localhost' IDENTIFIED VIA mysql_native_password USING PASSWORD('random_garbage'); Query OK, 0 rows affected (0.003 sec)
From here, what should I change in my configuration to allow Froxlor to create its user?
I tried setting old_passwords (both ways, also the default is 0), but that does not change anything.
EDIT: Just out of curiosity, is there a specific reason behind forcing mysql_native_passwords instead of using the DB server's default?
-
On an already existing server, CentOS 7 with PHP-FPM 8.0.16 and MariaDB 10.5.15
Downloaded latest Froxlor stable, following the documentation, and set up a virtualhost for it.
I start the setup process, all requirements check are green, then I insert a DB user and password for the "new" froxlor user, then I my (almost plaintext, no strange characters) MariaDB root password, and when clicking the continue button, I receive a blank page, and in the PHP-FPM log I have:
PHP Fatal error: Uncaught PDOException: 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 '[MY_FROXLOR_DBUSER_PASSWORD]'' at line 1 in /var/www/froxlor/install/lib/class.FroxlorInstall.php:744
Is it a problem with the MariaDB version or something else?
I also tried to manually create the user, but there's no way to tell the installer that it already exists.
CentOS 7 - PHP 8.0 - MariaDB 10.5 - SQL syntax error during first setup
in General Discussion
Posted
Yes, I can login from the command line client using those credentials.