Juan
-
Posts
2 -
Joined
-
Last visited
Posts posted by Juan
-
-
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
Problem creating a database
in General Discussion
Posted
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