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.

Mariadb or cPanel bug

Discussion in 'Database Discussions' started by musioc, Oct 15, 2014.

  1. musioc

    musioc Well-Known Member

    Joined:
    Aug 4, 2011
    Messages:
    105
    Likes Received:
    0
    Trophy Points:
    16
    Hello
    I was opened a topic about max_user_connections problem

    After sometimes I found that it is related to Mariadb, I tried to install mariadb (via cloudlinux db_governor)
    After that, I found that I can not use transfer tools! I saw this error :
    Please note that there is no problem until I fill Transfer tools input boxes and click Fetch account lists
    So it seams it is related to Transfer tool!
     
  2. musioc

    musioc Well-Known Member

    Joined:
    Aug 4, 2011
    Messages:
    105
    Likes Received:
    0
    Trophy Points:
    16
    Restore a Full Backup/cpmove File:
    Beginning restore for “username” …
    Unable to create a session object.
    Cpanel::DBI::Mysql connect('','root',...) failed: User 'root' has exceeded the 'max_user_connections' resource (current value: -1) at /usr/local/cpanel/Cpanel/MysqlUtils/Connect.pm line 136
     
  3. musioc

    musioc Well-Known Member

    Joined:
    Aug 4, 2011
    Messages:
    105
    Likes Received:
    0
    Trophy Points:
    16
    Does anyone use MariaDb without this problem?!
     
  4. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider
    Please note that MariaDB is not supported on cPanel 11.44 or 11.46

    MariaDB uses a signed value to store this value. MySQL uses an unsigned value. (see: https://en.wikipedia.org/wiki/Signedness) The value overflows on MariaDB and causes lock out. In 11.48 we are planning to support MariaDB and we have adjusted the value to account for the smaller storage size on MariaDB.

    I've opened up case 126129 to request back porting the code to account for the Signedness change.
     
  5. eva2000

    eva2000 Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    322
    Likes Received:
    10
    Trophy Points:
    18
    Location:
    Brisbane, Australia
    cPanel Access Level:
    Root Administrator
    Twitter:
    can't you just remove the max_user_connections limit at the global level for mysql my.cnf ?
     
  6. magj

    magj Member

    Joined:
    Dec 20, 2013
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi

    Isn't there any other way rather than waiting for 11.48?
    I have replaced mysql with mariadb and I'm stuck! Nothing works, phpmyadmin , even executing mysql grants this error:
    root@server11 [~]# mysql
    ERROR 1226 (42000): User 'root' has exceeded the 'max_user_connections' resource (current value: -1)
    !!!

    So isn't there any way to change this simple value in mariadb??? isn't that a shame?! (changing/inserting max_user_connections=0 or 1000 etc. in my.cnf simply doesn't work)

    /https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/#incompatibilities-between-mariadb-53-and-mysql-51-and-mariadb-52

    There are many similar threads in the internet which they have no answers.
    /http://forum.synology.com/enu/viewtopic.php?f=20&t=90331
    Synology Forum - Root connection problem while migrating to MariaDB

    Any help would be greatly appreciated
    Thanks
    Regards
     
  7. sahostking

    sahostking Well-Known Member

    Joined:
    May 15, 2012
    Messages:
    300
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Cape Town, South Africa
    cPanel Access Level:
    Root Administrator
    ok just posted now on forum with respect to migrating to mariadb. Rather not I guess. Going to wait it out a few months till I'm confident my users won't have issues. :)
     
Loading...

Share This Page