Sometimes the SQLite driver will randomly spit out uppercase database
types which trips up the health check when it checks the database and
prevents sympa from starting at all. This has been fixed in later
versions but this patch will backport this fix (will no longer be
needed if it is updated to the latest version, of course):
Also I had to install the CGI::Fast perl module to get this to work -
not sure if it used to be installed alongside something else (p5-CGI,
perhaps?) but the patch should make it a dependency so it installs
going forward. Please let me know if I've misunderstood anything about
how pkg_add handles dependencies.
--
Aaron Mason - Programmer, open source addict
I've taken my software vows - for beta or for worse
diff -Nur ports/mail/sympa.orig/Makefile ports/mail/sympa/Makefile
--- ports/mail/sympa.orig/Makefile Sat Feb 15 20:56:48 2025
+++ ports/mail/sympa/Makefile Sat Feb 15 20:57:27 2025
@@ -75,6 +75,7 @@
www/mhonarc \
www/p5-libwww \
www/p5-CGI \
+ www/p5-CGI-Fast \
www/p5-HTML-Format \
www/p5-HTML-StripScripts-Parser \
www/p5-HTML-Tree
diff -Nur ports/mail/sympa.orig/patches/patch_src_lib_sympa_databasedriver_sqlite_pm.patch ports/mail/sympa/patches/patch_src_lib_sympa_databasedriver_sqlite_pm.patch
--- ports/mail/sympa.orig/patches/patch_src_lib_sympa_databasedriver_sqlite_pm.patch Thu Jan 1 10:00:00 1970
+++ ports/mail/sympa/patches/patch_src_lib_sympa_databasedriver_sqlite_pm.patch Sat Feb 15 21:09:06 2025
@@ -0,0 +1,11 @@
+--- src/lib/Sympa/DatabaseDriver/SQLite.pm.orig Sat Feb 15 20:43:10 2025
++++ src/lib/Sympa/DatabaseDriver/SQLite.pm Sat Feb 15 20:43:21 2025
+@@ -195,7 +195,7 @@
+ }
+ while (my $field = $sth->fetchrow_hashref('NAME_lc')) {
+ # http://www.sqlite.org/datatype3.html
+- my $type = $field->{'type'};
++ my $type = lc $field->{'type'};
+ if ($type =~ /int/) {
+ $type = 'integer';
+ } elsif ($type =~ /char|clob|text/) {
