Virtualmin cannot update msodbcsql17

After hundreds of updates I have encountered an update which cannot be performed:
‘ERROR: The EULA was not accepted. Installation aborted.’

My system is fully updated otherwise.
Maybe you can help?

Package name msodbcsql17
Update system APT
Package description amd64 ODBC Driver for Microsoft® SQL Server®
Current state New version
Installed version
Available version
Installation source Bionic

This is what I get when I click the update button in Virtualmin:

Now updating msodbcsql17 …
Installing package(s) with command apt-get -y install msodbcsql17 …
Reading package lists…
Building dependency tree…
Reading state information…
The following packages will be upgraded:
Preconfiguring packages …
1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
Need to get 0 B/743 kB of archives.
After this operation, 0 B of additional disk space will be used.
(Reading database …
(Reading database … 5%
(Reading database … 10%
(Reading database … 15%
(Reading database … 20%
(Reading database … 25%
(Reading database … 30%
(Reading database … 35%
(Reading database … 40%
(Reading database … 45%
(Reading database … 50%
(Reading database … 55%
(Reading database … 60%
(Reading database … 65%
(Reading database … 70%
(Reading database … 75%
(Reading database … 80%
(Reading database … 85%
(Reading database … 90%
(Reading database … 95%
(Reading database … 100%
(Reading database … 228165 files and directories currently installed.)
Preparing to unpack …/msodbcsql17_17.6.1.1-1_amd64.deb …
ERROR: The EULA was not accepted. Installation aborted.
dpkg: error processing archive /var/cache/apt/archives/msodbcsql17_17.6.1.1-1_amd64.deb (–unpack):
new msodbcsql17 package pre-installation script subprocess returned error exit status 1
Errors were encountered while processing:
[ Rootkit Hunter version 1.4.6 ]
File updated: searched for 181 files, found 149
E: Sub-process /usr/bin/dpkg returned an error code (1)
… install failed!

I guess thats your problem. After that line, you see the notice about pre-installation. And the EULA is a part of the pre-installation.
Try to update it through direct SSH.

Is there some setting in Virtualmin that I can change to accept EULA automatically?

I am not sure, but maybe @Ilia or @Joe might know that.
You can always simply SSH in and do it manually.

Yes of course, that’s how I installed it to begin with.
Just wondering if Virtualmin can do it automatically for me every time a new update comes out.

WTF?!? They put a EULA prompt in a deb package? The monsters. The absolute bastards.

That’s a packaging bug. A packaging disaster. An offense against the gods of computing.



What distro and version is this?

Virtualmin doesn’t update anything but package manager does. What Webmin and Virtualmin versions do you have installed? How Virtualmin was installed on the system?

There is no package I can find called msodbcsql17 in Debian/Ubuntu systems.

He already said it’s Bionic. (Ubuntu.)

Doesn’t matter. This is a broken third party package. We’re not gonna try to accommodate bad (really bad) packages.

Yeah, as there is no such package for me in default repos.

I wonder, should we run and update with a param (if there is one) passed to package manager to automatically accept that?

No. We can’t safely accommodate every random bit of nonsense packagers put in the pre/post scripts. It’s an upstream packaging bug.

1 Like

This is on a Ubuntu 18.04

They mention this in the above link:

You can substitute setting the environment variable ‘ACCEPT_EULA’ with setting the debconf variable ‘msodbcsql/ACCEPT_EULA’ instead: echo msodbcsql17 msodbcsql/ACCEPT_EULA boolean true | sudo debconf-set-selections

This is the guide I followed to install on multiple php versions:

This topic was automatically closed 4 days after the last reply. New replies are no longer allowed.