I have this error and can’t seem to resolve it. Any suggestions?
The MariaDB client program /usr/bin/mysql does not appear to be the correct version. Webmin only supports MariaDB versions 3 and above.
The command /usr/bin/mysql -V returned :
/usr/bin/mysql: unknown variable ‘innodb_buffer_pool_size=16M’
| SYSTEM INFORMATION | |
|---|---|
| OS type and version | Ubuntu Linux 22.04.3 |
| Webmin version | 2.111 |
Try deleting /etc/webmin/mysql/version file.
I did this and now it gives me a new error…
MySQL does not appear to be installed and running on your system, or has not yet been set up properly in Webmin’s If your system does not use MySQL, it should be disabled in Virtualmin’s page.
Also when I go to MySql it says this now.
The MySQL client program /usr/bin/mysql does not appear to be the correct version. Webmin only supports MySQL versions 3 and above.
The command /usr/bin/mysql -V returned :
/usr/bin/mysql: unknown variable ‘innodb_buffer_pool_size=16M’
Where in MariaDB config this option is placed on your server?
You can find a file containing this directive and later check it by running the following command:
grep -Rsi innodb_buffer_pool_size /etc
I am sorry I don’t fully understand your reply.
You have an invalid configuration, which is making other stuff act weird. You need to fix your configuration. Ilia has told you how to find that bogus configuration option so you can fix it.
It is strange because I never had that error for the year plus the server was up. Not sure how it got badly configured when nothing changed.
I guess I am not smart enough to understand what Ilian suggested that I do to fix it. What file am I trying to find? and what do I do with it when I find it?
Just run grep command and report what it shows. Also you say client not server is that the same location. try mysql -V without using a path.
This is what I get when I run the grep command suggested.
root@swebserver:~# grep -Rsi innodb_buffer_pool_size /etc
/etc/mysql/my.cnf:innodb_buffer_pool_size = 16M
/etc/mysql/mariadb.cnf:innodb_buffer_pool_size = 16M
/etc/alternatives/my.cnf:innodb_buffer_pool_size = 16M
root@swebserver:~# mysql -V
mysql: unknown variable ‘innodb_buffer_pool_size=16M’
you need to remove the entries innodb_buffer_pool_size = 16M from
however I would guess that the file to edit would be /etc/mysql/mariadb.cnf as the other 2 files could be symlinks to the first 1. Don’t forget to make backup/copy of the file before you edit it just in case you make a mistake, then try to restart mariadb
Something changed! I’d recommend you figure out what. I would guess this means you’ve changed your database in some dramatic way. Maybe a major version downgrade or a switch to some old MySQL versions? I think that option is available in all Mariadb 10.x versions, but I’m not a Mariadb expert, by any means.
But, you should be real careful about downgrading a database or switching from Mariadb to MySQL.
You need to figure out what’s going on. Use your package manager to verify version, systemctl to confirm you’re loading the binary you think you are, and the config file(s) you think you are, and review your package manager logs to see if there’s been a new Mariadb package installed.
You’ve got something weird going on, but I’m having a hard time guessing what.
Thanks this is all it took to fix the annoying error.
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.