The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Cannot assign privileges to MYSQL databases

Discussion in 'Database Discussions' started by huzie, Mar 12, 2011.

  1. huzie

    huzie Member

    Joined:
    Mar 8, 2011
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Hi All,

    Since upgrading to mySQL 5.1 I cant seem to assign rights for a user to a database.. I click "all Priviliges" and then make changes but the changes to do not occur

    any ideas?
     
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Is there any error showing up in /usr/local/cpanel/logs/error_log or in /var/lib/mysql/hostname.err log (where hostname is the full hostname of the machine) when you try to assign these privileges?
     
  3. huzie

    huzie Member

    Joined:
    Mar 8, 2011
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    In error_log I get the following

    [2011-03-16 21:03:34 +0000] warn [mysqladmin] Error while connecting to MySQL. Failover enacted. at /usr/local/cpanel/Cpanel/Mysql.pm line 44
    Cpanel::Mysql::new('Cpanel::Mysql') called at /usr/local/cpanel/bin/mysqladmin line 65
    [2011-03-16 21:03:34 +0000] warn [mysqladmin] install_driver(mysql) failed: Can't load '/usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/libmysqlclient.so.14: version `libmysqlclient_14' not found (required by /usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so) at /usr/lib/perl5/5.8.8/i686-linux/XSLoader.pm line 70.
    at /usr/lib/perl5/site_perl/5.8.8/i686-linux/DBD/mysql.pm line 14
    Compilation failed in require at (eval 13) line 3.
    Perhaps a required shared library or dll isn't installed where expected
    at /usr/local/cpanel/Cpanel/Mysql.pm line 39
    at /usr/local/cpanel/Cpanel/Mysql.pm line 45
    Cpanel::Mysql::new('Cpanel::Mysql') called at /usr/local/cpanel/bin/mysqladmin line 65
    [2011-03-16 21:03:35 +0000] warn [mysqladmin] Error while connecting to MySQL. Failover enacted. at /usr/local/cpanel/Cpanel/Mysql.pm line 44
    Cpanel::Mysql::new('Cpanel::Mysql') called at /usr/local/cpanel/bin/mysqladmin line 65
    [2011-03-16 21:03:35 +0000] warn [mysqladmin] install_driver(mysql) failed: Can't load '/usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/libmysqlclient.so.14: version `libmysqlclient_14' not found (required by /usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so) at /usr/lib/perl5/5.8.8/i686-linux/XSLoader.pm line 70.
    at /usr/lib/perl5/site_perl/5.8.8/i686-linux/DBD/mysql.pm line 14
    Compilation failed in require at (eval 13) line 3.
    Perhaps a required shared library or dll isn't installed where expected
    at /usr/local/cpanel/Cpanel/Mysql.pm line 39
    at /usr/local/cpanel/Cpanel/Mysql.pm line 45
    Cpanel::Mysql::new('Cpanel::Mysql') called at /usr/local/cpanel/bin/mysqladmin line 65
    [2011-03-16 21:03:41 +0000] warn [mysqladmin] Error while connecting to MySQL. Failover enacted. at /usr/local/cpanel/Cpanel/Mysql.pm line 44
    Cpanel::Mysql::new('Cpanel::Mysql') called at /usr/local/cpanel/bin/mysqladmin line 65
    [2011-03-16 21:03:41 +0000] warn [mysqladmin] install_driver(mysql) failed: Can't load '/usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/libmysqlclient.so.14: version `libmysqlclient_14' not found (required by /usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so) at /usr/lib/perl5/5.8.8/i686-linux/XSLoader.pm line 70.
    at /usr/lib/perl5/site_perl/5.8.8/i686-linux/DBD/mysql.pm line 14
    Compilation failed in require at (eval 13) line 3.
    Perhaps a required shared library or dll isn't installed where expected
    at /usr/local/cpanel/Cpanel/Mysql.pm line 39
    at /usr/local/cpanel/Cpanel/Mysql.pm line 45
    Cpanel::Mysql::new('Cpanel::Mysql') called at /usr/local/cpanel/bin/mysqladmin line 65
    [2011-03-16 21:03:42 +0000] warn [mysqladmin] Error while connecting to MySQL. Failover enacted. at /usr/local/cpanel/Cpanel/Mysql.pm line 44
    Cpanel::Mysql::new('Cpanel::Mysql') called at /usr/local/cpanel/bin/mysqladmin line 65
    [2011-03-16 21:03:42 +0000] warn [mysqladmin] install_driver(mysql) failed: Can't load '/usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/libmysqlclient.so.14: version `libmysqlclient_14' not found (required by /usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so) at /usr/lib/perl5/5.8.8/i686-linux/XSLoader.pm line 70.
    at /usr/lib/perl5/site_perl/5.8.8/i686-linux/DBD/mysql.pm line 14
    Compilation failed in require at (eval 13) line 3.
    Perhaps a required shared library or dll isn't installed where expected
    at /usr/local/cpanel/Cpanel/Mysql.pm line 39
    at /usr/local/cpanel/Cpanel/Mysql.pm line 45
    Cpanel::Mysql::new('Cpanel::Mysql') called at /usr/local/cpanel/bin/mysqladmin line 65
    [2011-03-16 21:03:49 +0000] warn [mysqladmin] Error while connecting to MySQL. Failover enacted. at /usr/local/cpanel/Cpanel/Mysql.pm line 44
    Cpanel::Mysql::new('Cpanel::Mysql') called at /usr/local/cpanel/bin/mysqladmin line 65
    [2011-03-16 21:03:49 +0000] warn [mysqladmin] install_driver(mysql) failed: Can't load '/usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/libmysqlclient.so.14: version `libmysqlclient_14' not found (required by /usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so) at /usr/lib/perl5/5.8.8/i686-linux/XSLoader.pm line 70.
    at /usr/lib/perl5/site_perl/5.8.8/i686-linux/DBD/mysql.pm line 14
    Compilation failed in require at (eval 13) line 3.
    Perhaps a required shared library or dll isn't installed where expected
    at /usr/local/cpanel/Cpanel/Mysql.pm line 39
    at /usr/local/cpanel/Cpanel/Mysql.pm line 45
    Cpanel::Mysql::new('Cpanel::Mysql') called at /usr/local/cpanel/bin/mysqladmin line 65
    [2011-03-16 21:03:50 +0000] warn [mysqladmin] Error while connecting to MySQL. Failover enacted. at /usr/local/cpanel/Cpanel/Mysql.pm line 44
    Cpanel::Mysql::new('Cpanel::Mysql') called at /usr/local/cpanel/bin/mysqladmin line 65
    [2011-03-16 21:03:50 +0000] warn [mysqladmin] install_driver(mysql) failed: Can't load '/usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/libmysqlclient.so.14: version `libmysqlclient_14' not found (required by /usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so) at /usr/lib/perl5/5.8.8/i686-linux/XSLoader.pm line 70.
    at /usr/lib/perl5/site_perl/5.8.8/i686-linux/DBD/mysql.pm line 14
    Compilation failed in require at (eval 13) line 3.
    Perhaps a required shared library or dll isn't installed where expected
    at /usr/local/cpanel/Cpanel/Mysql.pm line 39
    at /usr/local/cpanel/Cpanel/Mysql.pm line 45
    Cpanel::Mysql::new('Cpanel::Mysql') called at /usr/local/cpanel/bin/mysqladmin line 65
    [2011-03-16 21:03:53 +0000] warn [mysqladmin] Error while connecting to MySQL. Failover enacted. at /usr/local/cpanel/Cpanel/Mysql.pm line 44
    Cpanel::Mysql::new('Cpanel::Mysql') called at /usr/local/cpanel/bin/mysqladmin line 65
    [2011-03-16 21:03:53 +0000] warn [mysqladmin] install_driver(mysql) failed: Can't load '/usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/libmysqlclient.so.14: version `libmysqlclient_14' not found (required by /usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so) at /usr/lib/perl5/5.8.8/i686-linux/XSLoader.pm line 70.
    at /usr/lib/perl5/site_perl/5.8.8/i686-linux/DBD/mysql.pm line 14
    Compilation failed in require at (eval 13) line 3.
    Perhaps a required shared library or dll isn't installed where expected
    at /usr/local/cpanel/Cpanel/Mysql.pm line 39
    at /usr/local/cpanel/Cpanel/Mysql.pm line 45
    Cpanel::Mysql::new('Cpanel::Mysql') called at /usr/local/cpanel/bin/mysqladmin line 65
    [2011-03-16 21:03:56 +0000] warn [mysqladmin] Error while connecting to MySQL. Failover enacted. at /usr/local/cpanel/Cpanel/Mysql.pm line 44
    Cpanel::Mysql::new('Cpanel::Mysql') called at /usr/local/cpanel/bin/mysqladmin line 65
    [2011-03-16 21:03:56 +0000] warn [mysqladmin] install_driver(mysql) failed: Can't load '/usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/libmysqlclient.so.14: version `libmysqlclient_14' not found (required by /usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so) at /usr/lib/perl5/5.8.8/i686-linux/XSLoader.pm line 70.
    at /usr/lib/perl5/site_perl/5.8.8/i686-linux/DBD/mysql.pm line 14
    Compilation failed in require at (eval 13) line 3.
    Perhaps a required shared library or dll isn't installed where expected
    at /usr/local/cpanel/Cpanel/Mysql.pm line 39
    at /usr/local/cpanel/Cpanel/Mysql.pm line 45
    Cpanel::Mysql::new('Cpanel::Mysql') called at /usr/local/cpanel/bin/mysqladmin line 65
    [2011-03-16 21:03:57 +0000] warn [mysqladmin] Error while connecting to MySQL. Failover enacted. at /usr/local/cpanel/Cpanel/Mysql.pm line 44
    Cpanel::Mysql::new('Cpanel::Mysql') called at /usr/local/cpanel/bin/mysqladmin line 65
    [2011-03-16 21:03:57 +0000] warn [mysqladmin] install_driver(mysql) failed: Can't load '/usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/libmysqlclient.so.14: version `libmysqlclient_14' not found (required by /usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so) at /usr/lib/perl5/5.8.8/i686-linux/XSLoader.pm line 70.
    at /usr/lib/perl5/site_perl/5.8.8/i686-linux/DBD/mysql.pm line 14
    Compilation failed in require at (eval 13) line 3.
    Perhaps a required shared library or dll isn't installed where expected
    at /usr/local/cpanel/Cpanel/Mysql.pm line 39
    at /usr/local/cpanel/Cpanel/Mysql.pm line 45
    Cpanel::Mysql::new('Cpanel::Mysql') called at /usr/local/cpanel/bin/mysqladmin line 65
    [2011-03-16 21:04:00 +0000] warn [mysqladmin] Error while connecting to MySQL. Failover enacted. at /usr/local/cpanel/Cpanel/Mysql.pm line 44
    Cpanel::Mysql::new('Cpanel::Mysql') called at /usr/local/cpanel/bin/mysqladmin line 65
    [2011-03-16 21:04:00 +0000] warn [mysqladmin] install_driver(mysql) failed: Can't load '/usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/libmysqlclient.so.14: version `libmysqlclient_14' not found (required by /usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so) at /usr/lib/perl5/5.8.8/i686-linux/XSLoader.pm line 70.
    at /usr/lib/perl5/site_perl/5.8.8/i686-linux/DBD/mysql.pm line 14
    Compilation failed in require at (eval 13) line 3.
    Perhaps a required shared library or dll isn't installed where expected
    at /usr/local/cpanel/Cpanel/Mysql.pm line 39
    at /usr/local/cpanel/Cpanel/Mysql.pm line 45
    Cpanel::Mysql::new('Cpanel::Mysql') called at /usr/local/cpanel/bin/mysqladmin line 65
    [2011-03-16 21:04:00 +0000] warn [mysqladmin] Error while connecting to MySQL. Failover enacted. at /usr/local/cpanel/Cpanel/Mysql.pm line 44
    Cpanel::Mysql::new('Cpanel::Mysql') called at /usr/local/cpanel/bin/mysqladmin line 65
    [2011-03-16 21:04:00 +0000] warn [mysqladmin] install_driver(mysql) failed: Can't load '/usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/libmysqlclient.so.14: version `libmysqlclient_14' not found (required by /usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so) at /usr/lib/perl5/5.8.8/i686-linux/XSLoader.pm line 70.
    at /usr/lib/perl5/site_perl/5.8.8/i686-linux/DBD/mysql.pm line 14
    Compilation failed in require at (eval 13) line 3.
    Perhaps a required shared library or dll isn't installed where expected
    at /usr/local/cpanel/Cpanel/Mysql.pm line 39
    at /usr/local/cpanel/Cpanel/Mysql.pm line 45
    Cpanel::Mysql::new('Cpanel::Mysql') called at /usr/local/cpanel/bin/mysqladmin line 65
    [2011-03-16 21:04:14 +0000] warn [dbstoregrants] Error while connecting to MySQL. Failover enacted. at /usr/local/cpanel/Cpanel/Mysql.pm line 44
    Cpanel::Mysql::new('Cpanel::Mysql') called at /usr/local/cpanel/bin/dbstoregrants line 74
    main::dump_mysql_sql() called at /usr/local/cpanel/bin/dbstoregrants line 48
    [2011-03-16 21:04:14 +0000] warn [dbstoregrants] install_driver(mysql) failed: Can't load '/usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/libmysqlclient.so.14: version `libmysqlclient_14' not found (required by /usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so) at /usr/lib/perl5/5.8.8/i686-linux/XSLoader.pm line 70.
    at /usr/lib/perl5/site_perl/5.8.8/i686-linux/DBD/mysql.pm line 14
    Compilation failed in require at (eval 14) line 3.
    Perhaps a required shared library or dll isn't installed where expected
    at /usr/local/cpanel/Cpanel/Mysql.pm line 39
    at /usr/local/cpanel/Cpanel/Mysql.pm line 45
    Cpanel::Mysql::new('Cpanel::Mysql') called at /usr/local/cpanel/bin/dbstoregrants line 74
    main::dump_mysql_sql() called at /usr/local/cpanel/bin/dbstoregrants line 48
     
  4. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Did you run EasyApache after updating MySQL to 5.1? If you did not, then that's why this is happening. Please use WHM > EasyApache (Apache Update) or /scripts/easyapache as PHP needs the MySQL driver rebuilt to the right version.
     
  5. huzie

    huzie Member

    Joined:
    Mar 8, 2011
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    tried to rebuild apache but we are still getting this problem with the same messages in the error_log file

    any thoughts much appreciated.
     
  6. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    I'd suggest opening up a ticket due to the priority of the situation. WHM > Support Center > Contact cPanel or using the link in my signature.
     
  7. huzie

    huzie Member

    Joined:
    Mar 8, 2011
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Opened a ticket and they suggested rebuilding perl as this was built and linked against old SQL using this command

    /scripts/checkperlmodules --force

    now all working!
     
Loading...

Share This Page