Hi,

I've already installed everything, I created customers and domains. When I try to create a new database inside a customer it always shows me this message: "SQLSTATE[HY000]: General error: 1819 Your password does not satisfy the current policy requirements", it doesn't matter the size of the password, special characters, numbers, uppercase, etc. I thought that it was a problem in mysql, but with the same password I'm able to create a user in phpmyadmin and terminal. 

Any ideas?

Thanks

mysql -h localhost -u root -p

###Set the new type of validation

SET GLOBAL validate_password_policy=0; //For Low

###Restart mysql
sudo service mysql restart

 

or you can use a password, which has fewer special characters, some programs have problems with it. Best example is there dovecot.

Never mind, I found the problem, in /lib/classes/database/manager/class.DbManagerMySQL.php you have a function called grantPrivilegesTo. 

 
                $stmt = Database::prepare("
                                GRANT ALL PRIVILEGES ON `" . $username . "`.*
                                TO :username@:host IDENTIFIED BY 'password'
                                ");
                Database::pexecute($stmt, array("username" => $username, "host" => $access_host));

Because my mysql server configuration requires strong passwords, using the string "password" doesn't work even when you change it in the next lines.

The code should be something like this:

                $stmt = Database::prepare("
                                GRANT ALL PRIVILEGES ON `" . $username . "`.*
                                TO :username@:host IDENTIFIED BY :password 
                                ");
                Database::pexecute($stmt, array("username" => $username, "host" => $access_host, "password" => $password));

 

Now I have Froxlor working OK.

Hope it helps, 

Juan

On 7/20/2019 at 11:17 PM, Juan said:

Never mind, I found the problem, in /lib/classes/database/manager/class.DbManagerMySQL.php you have a function called grantPrivilegesTo. 

 
                $stmt = Database::prepare("
                                GRANT ALL PRIVILEGES ON `" . $username . "`.*
                                TO :username@:host IDENTIFIED BY 'password'
                                ");
                Database::pexecute($stmt, array("username" => $username, "host" => $access_host));

Because my mysql server configuration requires strong passwords, using the string "password" doesn't work even when you change it in the next lines.

The code should be something like this:

                $stmt = Database::prepare("
                                GRANT ALL PRIVILEGES ON `" . $username . "`.*
                                TO :username@:host IDENTIFIED BY :password 
                                ");
                Database::pexecute($stmt, array("username" => $username, "host" => $access_host, "password" => $password));

 

Now I have Froxlor working OK.

Hope it helps, 

Juan

Sounds legit and makes sense...thanks for the hint