[Nightly] DB User without password
using the following config: ISPconfig 3.2dev20200930 Ubuntu 20.04.1 LTS MariaDB 10.3
i did the following added a db user "isptestdb" added a new db and assigned the user to it
i could not connect to the db, so i checked in phpmyadmin it has no password:
after that i did the same thing with debug log:
30.09.2020-08:12 - DEBUG - Calling function 'db_insert' from plugin 'mysql_clientdb_plugin' raised by event 'database_insert'.
30.09.2020-08:12 - DEBUG - Created MySQL database: isptestdb
30.09.2020-08:12 - DEBUG - Calling GRANT for isptestdb with access rw and hosts localhost
30.09.2020-08:12 - DEBUG - GRANT for user isptestdb at host localhost
30.09.2020-08:12 - DEBUG - CREATE USER 'isptestdb'@'localhost'
30.09.2020-08:12 - DEBUG - GRANT ALL PRIVILEGES ON `isptestdb`.* TO 'isptestdb'@'localhost' success? no
30.09.2020-08:12 - DEBUG - Processed datalog_id 1326
30.09.2020-08:12 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
30.09.2020-08:13 - DEBUG - You must install incron in order to use this plugin
30.09.2020-08:13 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
30.09.2020-08:13 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
30.09.2020-08:14 - DEBUG - You must install incron in order to use this plugin
30.09.2020-08:14 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
30.09.2020-08:14 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
after that i tried to set a new password, and the db user got a new password. after that i added remote access and the entry for "hostname %" had no password. settting a new password solved that problem.
i have seen #5748 (closed) which is similar but the problem still exists in latest nightly.
i also run a test with mariadb 10.4 and 10.5. the same problem happens.