[Pkg-mailman-hackers] Bug#1064029: bookworm-pu: package mailman3/3.3.8-2~deb12u2

[Pierre-Elliott Bécue]

Package: release.debian.org
Severity: normal
Tags: bookworm
User: release.debian.org at packages.debian.org
Usertags: pu
X-Debbugs-Cc: mailman3 at packages.debian.org
Control: affects -1 + src:mailman3

Hi,

Some bugs affecting mailman3 are found in bookworm. I fixed these in
unstable but forgot to do a stable-pu.

[ Reason ]
Bug #1040708 is about a change in the way sqlalchemy reads postgresql
URIs. Historically the prefix in this URI was postgres. Now it's
postgresql. Therefore the default config for mailman3 is broken under
bookworm.
Bug #1038953 is about tracking cron-daemon instead of cron to allow more
flexibility should one wish to use something else than cron. It was
supposed to be done for some time.

[ Impact ]
The first one will force users to fix the config if they wish to work
with postgresql.

[ Tests ]
Installed fixed version works fine.

[ Risks ]
Changes are trivial.

[ Checklist ]
  [x] *all* changes are documented in the d/changelog
  [x] I reviewed all changes and I approve them
  [x] attach debdiff against the package in (old)stable
  [x] the issue is verified as fixed in unstable
-------------- next part --------------
diff -Nru mailman3-3.3.8/debian/changelog mailman3-3.3.8/debian/changelog
--- mailman3-3.3.8/debian/changelog	2023-06-23 01:03:08.000000000 +0200
+++ mailman3-3.3.8/debian/changelog	2024-02-15 23:59:26.000000000 +0100
@@ -1,3 +1,11 @@
+mailman3 (3.3.8-2~deb12u2) bookworm; urgency=medium
+
+  * bookworm-pu of two fixes
+    - s/postgres/postgresql/ in config files
+    - Add replacement dependency on cron to cron-daemon
+
+ -- Pierre-Elliott B?cue <peb at debian.org>  Thu, 15 Feb 2024 23:59:26 +0100
+
 mailman3 (3.3.8-2~deb12u1) bookworm; urgency=medium
 
   * Bookworm-pu of 4 bug fixes
diff -Nru mailman3-3.3.8/debian/contrib/mailman.cfg.sample mailman3-3.3.8/debian/contrib/mailman.cfg.sample
--- mailman3-3.3.8/debian/contrib/mailman.cfg.sample	2023-06-23 01:03:08.000000000 +0200
+++ mailman3-3.3.8/debian/contrib/mailman.cfg.sample	2024-02-15 23:59:26.000000000 +0100
@@ -170,7 +170,7 @@
 # 'configuration' substitutions.
 url: sqlite:///$DATA_DIR/mailman.db
 #url: mysql+pymysql://mailman3:mmpass@localhost/mailman3?charset=utf8&use_unicode=1
-#url: postgres://mailman3:mmpass@localhost/mailman3
+#url: postgresql://mailman3:mmpass@localhost/mailman3
 
 debug: no
 
diff -Nru mailman3-3.3.8/debian/control mailman3-3.3.8/debian/control
--- mailman3-3.3.8/debian/control	2023-06-23 01:03:08.000000000 +0200
+++ mailman3-3.3.8/debian/control	2024-02-15 23:59:26.000000000 +0100
@@ -44,7 +44,7 @@
 Architecture: all
 Depends: dbconfig-sqlite3 | dbconfig-pgsql | dbconfig-mysql | dbconfig-no-thanks,
          logrotate,
-         cron,
+         cron | cron-daemon,
          python3-falcon (>> 1.0.0),
          python3-psycopg2 | python3-pymysql,
          ucf,
diff -Nru mailman3-3.3.8/debian/mailman3.postinst mailman3-3.3.8/debian/mailman3.postinst
--- mailman3-3.3.8/debian/mailman3.postinst	2023-06-23 01:03:08.000000000 +0200
+++ mailman3-3.3.8/debian/mailman3.postinst	2024-02-15 23:59:26.000000000 +0100
@@ -52,7 +52,7 @@
         pgsql)
             sed -i -e 's|^#\?\s*\(class: mailman\.database\.postgresql\.PostgreSQLDatabase\)$|\1|' \
                 $mailmancfg_new
-            sed -i -e "s|^#\?\s*url: postgres://.*$|url: postgres://$dbc_dbuser:$dbc_dbpass@$dbc_dbserver/$dbc_dbname|" \
+            sed -i -e "s|^#\?\s*url: postgresql://.*$|url: postgresql://$dbc_dbuser:$dbc_dbpass@$dbc_dbserver/$dbc_dbname|" \
                 $mailmancfg_new
             ;;
         mysql)