[Case 159129] Upgrade to MariaDB MAX_USER_CONNECTIONS problem

kernow

• February 04, 2015 09:30

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

  • February 04, 2015 15:55

  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.

  0
• 

  kernow

  • February 04, 2015 16:26

  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
  

  0
• 

  kernow

  • February 05, 2015 12:25

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

  0

Please sign in to leave a comment.