[Solved] Create MySQL users stop working after update from MySQL 5.5 to MySQL 5.6

Discussion in 'General' started by ajgomezlopez, Jan 12, 2018.

  1. ajgomezlopez

    ajgomezlopez New Member

    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
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Did you change the root password as well? If yes, set the new password in /usr/local/ispconfig/server/lib/mysql_clientdb.conf
     
  3. ajgomezlopez

    ajgomezlopez New Member

    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.
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  5. ajgomezlopez

    ajgomezlopez New Member

    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
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    Google 'debug ispconfig' and click on the first search result ;)
     
  7. ajgomezlopez

    ajgomezlopez New Member

    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.
     
  8. till

    till Super Moderator Staff Member ISPConfig Developer

    Then the only option to debug this might be to enable query logging in mysql and then check which of the issued queries fails.
     
  9. ajgomezlopez

    ajgomezlopez New Member

    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.
     
  10. till

    till Super Moderator Staff Member ISPConfig Developer

    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?
     
  11. ajgomezlopez

    ajgomezlopez New Member

    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 :(
     
  12. till

    till Super Moderator Staff Member ISPConfig Developer

    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
     
  13. ajgomezlopez

    ajgomezlopez New Member

    Great. This do the trick.
    mysql_upgrade --force -uroot -p

    More people like you in the world.
    THANKS YOU VERY MUCH
     
    till likes this.

Share This Page