Few days ago i update to mysql 5.6 from mysql 5.5 Now, I can't create any database user (don't matters the role) Any suggestion? Thanks in advance. P.S. Sorry for my english
Did you change the root password as well? If yes, set the new password in /usr/local/ispconfig/server/lib/mysql_clientdb.conf
No, all remain the same. No problem creating databases, only users. I disabled system() and exec() in php configuration. I don't now if those functions are involved in the process.
That's a really bad idea and ISPConfig will not work when you do that in the php.ini file used for commandline scripts. Disabling them in the php.ini for php-fpm, fcgi and mod_php is fin though.
Yes, that's what i did, There are no limits in commandline executions. I also reinstalled ISPConfig3 with the update.php script Still failing when creating database users. Any way to debug this problem? Thx in advance
Call is made, but nothing happends. 12.01.2018-20:11 - DEBUG - Found 1 changes, starting update process. 12.01.2018-20:11 - DEBUG - Calling function 'db_user_insert' from plugin 'mysql_clientdb_plugin' raised by event 'database_user_insert'. 12.01.2018-20:11 - DEBUG - Processed datalog_id 753 12.01.2018-20:11 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock If i query for mysql.user is not in the table.
Then the only option to debug this might be to enable query logging in mysql and then check which of the issued queries fails.
function db_user_insert($event_name, $data) { global $app, $conf; // we have nothing to do here, stale user accounts are useless } I can't understand anything, this is the function. Does nothing.
Db users are added when the DB is added, so this function has to be empty of course. Or did you miss to add the database for the user?
Created MySQL database: c5demo_demo 12.01.2018-21:52 - DEBUG - Calling GRANT for c5demo_demo with access rw and hosts localhost 12.01.2018-21:52 - DEBUG - GRANT for user c5demo_demo at host localhost 12.01.2018-21:52 - DEBUG - GRANT ALL PRIVILEGES ON `c5demo_demo`.* TO 'c5demo_demo'@'localhost' IDENTIFIED BY PASSWORD '*XXXXXXXXXXXXXXXXXXXXXXXXXXXX' success? no 12.01.2018-21:52 - DEBUG - Processed datalog_id 755 No success, no idea why
Check if the root user in MySQL has the grant privilege. Or maybe something has gone wrong with your mysql upgrade so that one of the tables in the 'mysql' database is not ok (e.g. a column is missing that is required by the new mysql version). see also: https://dev.mysql.com/doc/refman/5.6/en/mysql-upgrade.html
Great. This do the trick. mysql_upgrade --force -uroot -p More people like you in the world. THANKS YOU VERY MUCH
For me the problem was the following: The MariaDB server is running with the --strict-password-validation option so it cannot execute this statement After I run in the mysql console: uninstall plugin cracklib_password_check
