Bug#1064029: bookworm-pu: package mailman3/3.3.8-2~deb12u2

2024-02-20 Thread Jonathan Wiltshire
Control: tag -1 confirmed

On Fri, Feb 16, 2024 at 12:21:32AM +0100, Pierre-Elliott Bécue wrote:
> [ 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.

Please go ahead.

Thanks,

-- 
Jonathan Wiltshire  j...@debian.org
Debian Developer http://people.debian.org/~jmw

4096R: 0xD3524C51 / 0A55 B7C5 1223 3942 86EC  74C3 5394 479D D352 4C51
ed25519/0x196418AAEB74C8A1: CA619D65A72A7BADFC96D280196418AAEB74C8A1



Bug#1064029: bookworm-pu: package mailman3/3.3.8-2~deb12u2

2024-02-15 Thread Pierre-Elliott Bécue
Package: release.debian.org
Severity: normal
Tags: bookworm
User: release.debian@packages.debian.org
Usertags: pu
X-Debbugs-Cc: mailm...@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
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.0 +0200
+++ mailman3-3.3.8/debian/changelog 2024-02-15 23:59:26.0 +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   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.sample2023-06-23 
01:03:08.0 +0200
+++ mailman3-3.3.8/debian/contrib/mailman.cfg.sample2024-02-15 
23:59:26.0 +0100
@@ -170,7 +170,7 @@
 # 'configuration' substitutions.
 url: sqlite:///$DATA_DIR/mailman.db
 #url: 
mysql+pymysql://mailman3:mmpass@localhost/mailman3?charset=utf8_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.0 +0200
+++ mailman3-3.3.8/debian/control   2024-02-15 23:59:26.0 +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.0 
+0200
+++ mailman3-3.3.8/debian/mailman3.postinst 2024-02-15 23:59:26.0 
+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)