[MDEV-9781] apt-get reports "The repository is insufficiently signed by key 199369E5404BD5FC7D2FE43BCBCB082A1BB943DB (weak digest)" on Debian Testing AMD64 Created: 2016-03-23  Updated: 2016-08-11  Due: 2016-05-14  Resolved: 2016-07-04

Status: Closed
Project: MariaDB Server
Component/s: Packaging, Platform Debian
Affects Version/s: 10.1.12
Fix Version/s: 10.0.25, 10.1.14, 10.2.0

Type: Bug Priority: Major
Reporter: Thomas Hackert Assignee: Daniel Bartholomew
Resolution: Fixed Votes: 1
Labels: None
Environment:

Debian Testing AMD64
ii libmariadbclient18 10.1.12+maria-1~jessie amd64 MariaDB database client library
ii libmariadbclient-dev 10.1.12+maria-1~jessie amd64 MariaDB database development files
ii libmariadbd-dev 10.1.12+maria-1~jessie amd64 MariaDB embedded database, development files
ii mariadb-client-10.1 10.1.12+maria-1~jessie amd64 MariaDB database client binaries
ii mariadb-client-core-10.1 10.1.12+maria-1~jessie amd64 MariaDB database core client binaries
ii mariadb-common 10.1.12+maria-1~jessie all MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf)
ii mariadb-server-10.1 10.1.12+maria-1~jessie amd64 MariaDB database server binaries
ii mariadb-server 10.1.12+maria-1~jessie all MariaDB database server (metapackage depending on the latest version)
ii mariadb-server-core-10.1 10.1.12+maria-1~jessie amd64 MariaDB database core server files


Issue Links:
Relates
relates to MDEV-10537 repository configuration tool - for u... Closed

 Description   

Hello @ll,
I hope, I have chosen the right project, component, severity, and the like ... If not, feel free to change

I tried to upgrade my system today as usual with "apt-get update && apt-get upgrade", and got the error message

W: gpgv:/var/lib/apt/lists/ftp.hosteurope.de_mirror_mariadb.org_repo_10.1_debian_dists_jessie_InRelease: The repository is insufficiently signed by key 199369E5404BD5FC7D2FE43BCBCB082A1BB943DB (weak digest)

While searching the web for this message, I stumbled upon https://juliank.wordpress.com/2016/03/15/clarifications-and-updates-on-apt-sha1/, where I found a link to wiki.debian.org/Teams/Apt/Sha1Removal. In this wiki page, it says

Fixing broken repositories

Repository owners should make sure their release files and Packages files contain SHA256 or SHA512 fields. If they have Sources files, those should contain Checksums-Sha256.

. I would like to ask if it would be possible to fix this bug as fast as possible to be able to use MariaDB's own repository to upgrade to newer versions.
Thanks in advance
Thomas.



 Comments   
Comment by Thomas Hackert [ 2016-03-23 ]

sorry for the noise copypasted the wrong line ... Should be
<quote>
W: gpgv:/var/lib/apt/lists/ftp.hosteurope.de_mirror_mariadb.org_repo_10.1_debian_dists_jessie_InRelease: The repository is insufficiently signed by key 199369E5404BD5FC7D2FE43BCBCB082A1BB943DB (weak digest)
</quote>

...

Comment by Daniel Bartholomew [ 2016-04-19 ]

required gpg settings: http://askubuntu.com/questions/750133/how-can-i-fix-w-the-repository-is-insufficiently-signed-by-the-key

...which references this post: https://www.debian-administration.org/users/dkg/weblog/48

Comment by Daniel Bartholomew [ 2016-04-26 ]

This is fixed in 10.2, and will be completely fixed in the next releases of 10.0 and 10.1.

The solution was to create a new SHA2 GPG key, and use that for our Sid and Xenial repositories.

The new key has an ID of: C74CD1D8 and the full fingerprint is:

177F 4010 FE56 CA33 3630 0305 F165 6F24 C74C D1D8

See the 10.2.0 release notes for more information: https://mariadb.com/kb/en/mariadb/mariadb-1020-release-notes/

Comment by Daniel Bartholomew [ 2016-05-11 ]

AFAIK this issue is now resolved. Sid and Xenial repositories for 10.0, 10.1, and 10.2 are all signed with the new key.

Reopen if there are issues that have not been resolved.

Comment by Daniel Black [ 2016-06-16 ]

https://downloads.mariadb.org/mariadb/repositories doesn't list this new key.

Users get an error like follows when installing from the repository:

W: GPG error: http://mirror.netcologne.de/mariadb/repo/10.1/ubuntu xenial InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY F1656F24C74CD1D8 W: The repository 'http://mirror.netcologne.de/mariadb/repo/10.1/ubuntu xenial InRelease' is not signed. N: Data from such a repository can't be authenticated and is therefore potentially dangerous to use.

Please update the instructions.

Comment by Daniel Bartholomew [ 2016-06-17 ]

Somehow some old instructions were being displayed in the repository configuration tool. They have now been fixed.

Comment by Thomas Hackert [ 2016-06-17 ]

Hello Daniel, *,
thanks for your work so far

If I enter the sources.list entry for sid and import the key mentioned in the instruction, it works But, alas, it does not work for stretch. Then I get the same error mentioned in the subject ...

Thanks anyway, now I have one error message less ...
Have a nice day
Thomas.

Comment by Daniel Bartholomew [ 2016-06-17 ]

thackert We currently do not have repositories for Debian Stretch. Are you setting up the Sid repository on Stretch?

Comment by Thomas Hackert [ 2016-06-17 ]

@Daniel: it seems I have not expressed that well, sorry ... I mean, that I tried to follow the instruction for Debian Jessie (8.x), which did not work. If I follow the instructions for sid (with the key mentioned there as well as the sources.list entry) it works. So yes, I set it up and have now installed MariaDB for sid on Stretch.
I hope, this is a little bit clearer now ... If not, feel free to ask
Have a nice evening
Thomas.

Comment by Daniel Bartholomew [ 2016-06-17 ]

thackert: Yes. Using the Jessie instructions on Stretch will not work, you have to use the Sid instructions. Our Jessie repositories still use the old 0xcbcb082a1bb943db GPG key, not the new 0xF1656F24C74CD1D8 key required by Sid and Stretch.

Comment by Thomas Hackert [ 2016-06-17 ]

@dbart: thanks for your explanation Just out of interest: will there be a Stretch repo on a later time as well? And will this use the key for sid or another one?
Have a nice evening
Thomas.

Comment by Daniel Bartholomew [ 2016-06-17 ]

Yes, there will be a Stretch repository eventually. It will use the same key we're now using for Sid.

Generated at Thu Feb 08 07:37:17 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.