[Case 159129] Upgrade to MariaDB MAX_USER_CONNECTIONS problem

[kernow]

Tried to upgrade to mariaDB through WHM but get a warning that

Your server’s MySQL/MariaDB MAX_USER_CONNECTIONS value is larger then 2147483647. You cannot use the MySQL/MariaDB Upgrade feature while your server is in this state.

OK, so I check :

SHOW VARIABLES LIKE 'max_user_connections';
+----------------------+------------+
| Variable_name        | Value      |
+----------------------+------------+
| max_user_connections | 4294967295 |
+----------------------+------------+
1 row in set (0.00 sec)

Wow that seems a lot! so I try to change it:

SET GLOBAL max_user_connections = 2147483647;
Query OK, 0 rows affected (0.00 sec)

Nothing happens. The original figure still shows up and the upgrade through WHM also shows the same high figure;

SHOW VARIABLES LIKE 'max_user_connections';
+----------------------+------------+
| Variable_name        | Value      |
+----------------------+------------+
| max_user_connections | 4294967295 |
+----------------------+------------+
1 row in set (0.00 sec)

Any suggestions please?

 

[cPanelMichael]

Hello

Internal case number 159129 is open to address this issue. In the meantime, try this workaround:

1.) Examine /etc/my.cnf to ensure max_user_connections is within a range of 0 to 2147483647.

2.) In 'mysql' database, 'user' table, ensure entries for user root are within a range of 0 to 2147483647.

mysql -e "SELECT Host,User,max_questions,max_updates,max_connections,max_user_connections FROM mysql.user WHERE User='root' \G"

Manually reset the mysql.user values (if needed):

export MAX_SIGNED_INT=2147483647; mysql -e "UPDATE mysql.user set MAX_USER_CONNECTIONS=$MAX_SIGNED_INT, MAX_UPDATES=$MAX_SIGNED_INT, MAX_CONNECTIONS=$MAX_SIGNED_INT, MAX_QUESTIONS=$MAX_SIGNED_INT where user='root';"

Thank you.

 

[kernow]

Hi,
Thanks but it didn't work. After edit we get:

mysql -e "SELECT Host,User,max_questions,max_updates,max_connections,max_user_connections FROM mysql.user WHERE User='root' \G"
*************************** 1. row ***************************
                Host: localhost
                User: root
       max_questions: 2147483647
         max_updates: 2147483647
     max_connections: 2147483647
max_user_connections: 2147483647

But:

mysql> SHOW VARIABLES LIKE 'max_user_connections';                                                                                                                                         +----------------------+------------+
| Variable_name        | Value      |
+----------------------+------------+
| max_user_connections | 4294967295 |
+----------------------+------------+
1 row in set (0.00 sec)

I think your suggestion only changed roots connection limit which I belive was already fixed?

case 157165: Ensure root's MySQL/MariaDB MAX_USER_CONNECTION is set to a sane value

 

[kernow]

Update
max_user_connections is now showing the adjusted figure and so we can now use the WHM MySQL/MariaDB upgrade tool.
Thank you