Repeat mysql needs update emails

Hi,

I have virtualmin (gpl) set to to do security updates as the occur and to email me about other updates each day. I'm now getting daily emails which say

An update to mysql-server from 5.5.38-0ubuntu0.14.04.1 to 5.5.40-0ubuntu0.14.04.1 is available.
An update to mysql-server-5.5 from 5.5.38-0ubuntu0.14.04.1 to 5.5.40-0ubuntu0.14.04.1 is available.
An update to mysql-server-core-5.5 from 5.5.38-0ubuntu0.14.04.1 to 5.5.40-0ubuntu0.14.04.1 is available.
An update to mysql-client from 5.5.38-0ubuntu0.14.04.1 to 5.5.40-0ubuntu0.14.04.1 is available.
An update to mysql-client-5.5 from 5.5.38-0ubuntu0.14.04.1 to 5.5.40-0ubuntu0.14.04.1 is available.
An update to mysql-client-core-5.5 from 5.5.38-0ubuntu0.14.04.1 to 5.5.40-0ubuntu0.14.04.1 is available.
An update to mysql-common from 5.5.38-0ubuntu0.14.04.1 to 5.5.40-0ubuntu0.14.04.1 is available.

But when I look in MySQL Server->MySQL System Variables the version variable is 5.5.40-0ubuntu0.14.04.1

I've also, from the command line, tried apt-get update, upgrade, dist-upgrade but all these say nothing to upgrade. I'm guessing that it really is up to date but for some reason the routine that checks this doesn't think so.

I'll try a reboot just in case that fixes it and update this tomorrow. BTW software package update, and virtualmin update also do not should any pending updates.

Status: 
Active

Comments

Howdy -- hmm, what is the output of this command:

dpkg -l 'mysql*'

Also, rather than reboot, you could always try restarting Webmin, which you can do with this command:

/etc/init.d/webmin restart

root@hub:~# dpkg -l 'mysql*'
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name           Version      Architecture Description
+++-==============-============-============-=================================
ii  mysql-client   5.5.40-0ubun all          MySQL database client (metapackag
un  mysql-client-5 <none>       <none>       (no description available)
un  mysql-client-5 <none>       <none>       (no description available)
ii  mysql-client-5 5.5.40-0ubun i386         MySQL database client binaries
un  mysql-client-c <none>       <none>       (no description available)
ii  mysql-client-c 5.5.40-0ubun i386         MySQL database core client binari
ii  mysql-common   5.5.40-0ubun all          MySQL database common files, e.g.
ii  mysql-server   5.5.40-0ubun all          MySQL database server (metapackag
un  mysql-server-5 <none>       <none>       (no description available)
un  mysql-server-5 <none>       <none>       (no description available)
ii  mysql-server-5 5.5.40-0ubun i386         MySQL database server binaries an
un  mysql-server-c <none>       <none>       (no description available)
un  mysql-server-c <none>       <none>       (no description available)
un  mysql-server-c <none>       <none>       (no description available)
ii  mysql-server-c 5.5.40-0ubun i386         MySQL database server binaries

Hi,

Having rebooted I don't now get the mysql report. But I'm still get email about upgrades but when I go to do that it is already at the latest version. However, I do unattended-upgrades installed and I wonder if Virtualmin uses/sets up this or instead does it all itself. In which case maybe I have virtualmin reporting upgrades need where as meanwhile unattended-upgrades is doing this.

I can't remember what, if anything I configured unattended-upgrades for so maybe it is doing stable and security where as virtualmin is set to report and just do security upgrades.

Virtualmin doesn't enable un-attended upgrades by default, but you can set this up at Webmin -> System -> Virtualmin Package Updates.

Hi,

Just to check we are on the page page here. There is a package called unattended-upgrades. I've installed this (or it was already installed, I forget) as well as installing Virtualmin. Does virtualmin use the package unattended-upgrades or does it do its own checking for upgrades?

I have set up virtualmin to do security updates automatically and to email me when upgrades are needed. This is at Webmin -> System -> Virtualmin Package Updates as you say.

I get emails for security updates, which end with a link saying go here ....:10000/security-updates/ and also emails for normal updates for which the link is ....:10000/package-updates/. But for either when I log in there are no updates to do. Hence I'm thinking that somehow the updates are being done automatically.

I think that webmin/virtualmin is doing its own updates using /etc/webmin/security-updates and /etc/webmin/package-updates/. And then I also have unattended-upgrades also running using /etc/apt/apt.conf.d/ which I guess might have defaulted to doing all security and stable (although I get seem to get that logic from the scripts). Hence when I come to do the updates I've been told about they have already been done. Or maybe you have a but where setting just do security actually does both.

Webmin doesn't use that unattended-upgrades package at all - instead it does its own checking for new versions. So you should probably only enable one or the other.

Thanks. I've set unattended-upgrades to do security ones only but, I think report all. And webmin/virtualmin is set to report all. All I have to do now is wait for the next lot of updates and see what happens.