From e6ae58c81071cdc2f926b437d3f0ab1ac143ae83 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Mon, 4 Jul 2022 19:29:16 +0200 Subject: lib/mysql-functions: mysql_sanity_check(): check for signature in db, too --- lib/mysql-functions | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'lib/mysql-functions') diff --git a/lib/mysql-functions b/lib/mysql-functions index af2c3ba..c27babc 100755 --- a/lib/mysql-functions +++ b/lib/mysql-functions @@ -702,6 +702,16 @@ mysql_sanity_check() { mysql_join_binary_packages_in_repositories_repositories printf ' WHERE `repositories`.`is_on_master_mirror`' printf ' AND `binary_packages`.`sha512sum` IS NULL;\n' + printf 'SELECT DISTINCT CONCAT("non-virtual binary-package without signature: ",' + mysql_package_name_query + printf ') FROM `binary_packages`' + mysql_join_binary_packages_architectures + printf ' LEFT' + mysql_join_binary_packages_compressions + mysql_join_binary_packages_binary_packages_in_repositories + mysql_join_binary_packages_in_repositories_repositories + printf ' WHERE `repositories`.`is_on_master_mirror`' + printf ' AND `binary_packages`.`signing_key` IS NULL;\n' } | \ mysql_run_query | \ sed ' -- cgit v1.2.3-70-g09d2