Ubuntu
mysql-dfsg package

Aptitude still looking for an old package after update.

Asked by XAP-Bob

Hi,

I'm trying to install CalmAV onto my server (remote) to integrate with postfix. There are obvious dependencies around, one of which is mysql - this is giving me a little problem.

I have 'aptitude update'd, 'apt-get update'd, updated from inside aptitude, all of which report that they work fine.

However when attempting to install I get the following failures:
The following NEW packages will be installed:
  libmysqlclient15off mysql-common postfix-policyd
0 packages upgraded, 3 newly installed, 0 to remove and 0 not upgraded.
Need to get 1461kB/1512kB of archives. After unpacking 3428kB will be used.
Do you want to continue? [Y/n/?] y
Err http://security.ubuntu.com dapper-security/main mysql-common 5.0.22-0ubuntu6.06.2
  404 Not Found
Err http://security.ubuntu.com dapper-security/main libmysqlclient15off 5.0.22-0ubuntu6.06.2
  404 Not Found

I've taken a tcpdump to check what is being requested and it's looking in http://security.ubuntu.com/ubuntu/pool/main/m/mysql-dfsg-5.0/ for:
mysql-common_5.0.22-0ubuntu6.06.2_all.deb
libmysqlclient15off_5.0.22-0ubuntu6.06.2_amd_64.deb

Now those don't exist but these do:
mysql-common_5.0.22-0ubuntu6.06.3_all.deb
libmysqlclient15off_5.0.22-0ubuntu6.06.3_amd64.deb

I'm therefore under the impression that the update has failed to pick up the version change from 6.06.2 to 6.06.3

And am now officially stuck!

Where do I look next?

Cheers

Bob

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu mysql-dfsg Edit question
Assignee:
No assignee Edit question
Solved by:
Cesare Tirabassi
Solved:
Last query:
Last reply:
Revision history for this message
Cesare Tirabassi (norsetto) said : 		#1

You can force the version using these commands from a terminal:

sudo apt-get install mysql-common=5.0.22-0ubuntu6.06.3
sudo apt-get install libmysqlclient15off=5.0.22-0ubuntu6.06.3

Revision history for this message
XAP-Bob (ubuntu-dawnlink) said : 		#2

Aptitude ignores paramters passed in that way (which is fine, it's entitled to - you suggested apt-get)
apt-get thinks those don't exist - I'm just about to run a tcpdump to see what it's looking for...

Revision history for this message
XAP-Bob (ubuntu-dawnlink) said : 		#3

Ah - It's not even going out to the world, it's just whinging without bothering to check, because it's not in it's dB I presume.

Any more thoughts?

Revision history for this message
Cesare Tirabassi (norsetto) said : 		#4

Do you have the dapper repository enabled?
Apparently your apt is looking in the dapper-backports repository only (which doesn't contain indeed these files).

Revision history for this message
XAP-Bob (ubuntu-dawnlink) said : 		#5

Well, my /etc/apt/sources.list file contains the following two lines:

deb ftp://ftp.uni-erlangen.de/mirrors/ubuntu/ dapper main restricted
deb-src ftp://ftp.uni-erlangen.de/mirrors/ubuntu/ dapper main restricted

So I think it does...

Revision history for this message
XAP-Bob (ubuntu-dawnlink) said : 		#6

Actually let's just post the whole file shall we...:
deb ftp://ftp.uni-erlangen.de/mirrors/ubuntu/ dapper main restricted
deb-src ftp://ftp.uni-erlangen.de/mirrors/ubuntu/ dapper main restricted

deb ftp://ftp.uni-erlangen.de/mirrors/ubuntu/ dapper-updates main restricted
deb-src ftp://ftp.uni-erlangen.de/mirrors/ubuntu/ dapper-updates main restricted

deb http://security.ubuntu.com/ubuntu dapper-security main restricted
deb-src http://security.ubuntu.com/ubuntu dapper-security main restricted

# We want Multiverse and Universe repositories, please

deb http://archive.ubuntu.com/ubuntu dapper universe multiverse
deb-src http://archive.ubuntu.com/ubuntu dapper universe multiverse

Revision history for this message
Cesare Tirabassi (norsetto) said : 		#7

Well, apparently you are not using a good mirror.
I checked in the packages list at ftp://ftp.uni-erlangen.de/mirrors/ubuntu/ and libmysqlclient15off wasn't there.
Indeed, I could not find this mirror archive listed in https://launchpad.net/ubuntu/+archivemirrors.
I suggest you change it to an up-to-date mirror.

Revision history for this message
XAP-Bob (ubuntu-dawnlink) said : 		#8

Ah - sorry, it's looking in dapper-security, not dapper. I've shifted to some more local repos though (given as how my ISP provides a set and all)

Bob,

PS - Many thnaks for your help so far...

Revision history for this message
Cesare Tirabassi (norsetto) said : 		#9

We can solve your problem by installing directly the .deb packages from the Ubuntu archive site.
You can download them following these link and install them with sudo dpkg -i:

http://archive.ubuntu.com/ubuntu/pool/main/m/mysql-dfsg-5.0/mysql-client_5.0.22-0ubuntu6.06.3_all.deb
http://archive.ubuntu.com/ubuntu/pool/main/m/mysql-dfsg-5.0/libmysqlclient15off_5.0.22-0ubuntu6.06.3_amd64.deb

This will however not solve your general problem, why is apt looking only in dapper-security.

Revision history for this message
Best Cesare Tirabassi (norsetto) said : 		#10

We can solve your problem in a couple of ways:

1) by installing directly the .deb packages from the Ubuntu archive site.

You can download them following these links and install them with sudo dpkg -i:

http://archive.ubuntu.com/ubuntu/pool/main/m/mysql-dfsg-5.0/mysql-client_5.0.22-0ubuntu6.06.3_all.deb
http://archive.ubuntu.com/ubuntu/pool/main/m/mysql-dfsg-5.0/libmysqlclient15off_5.0.22-0ubuntu6.06.3_amd64.deb

2) perhaps also by disabling the dapper-backport entries in your sources.list file.

I still do not understand why apt is looking only in dapper-security, and why is looking for un outdated version.
I was thinking about an outdated archive, in which case changing to an official mirror and syncing with apt-get update should have solved the problem.

Revision history for this message
XAP-Bob (ubuntu-dawnlink) said : 		#11

I didn't want to bypass the apt process, so I disabled the dapper-security entries in sources.list and apt managed quite happily - I've reenabled it and it's not complaining about anything.

Thank you very much for your patience.

Revision history for this message
XAP-Bob (ubuntu-dawnlink) said : 		#12

Thanks Cesare Tirabassi, that solved my question.