Missing Archived emails - Hyperkitty - CERT Issue
Looks like "hyperkitty" stopped archiving right after the CERT for the mailman3 website expired, How can I make the missing archives visible on the website? I see there "*pck" files in the/opt/mailman/mm/var/archives/hyperkitty/spool/ directory. The list archive does not show that last posting [of 25 July 2025.
~$ ll -t /opt/mailman/mm/var/archives/hyperkitty/spool/ -rw-rw---- 1 mailman mailman 98215 Jul 25 12:01 1753459289.7901242+f3fd7ee77272862f8c1023394bf88d0d4bbe9053.pck -rw-rw---- 1 mailman mailman 98109 Jul 25 12:01 1753459289.7726512+ee1264c36a194eb0ec1a52089f053e6963f24369.pck -rw-rw---- 1 mailman mailman 88479 Jul 25 12:01 1753459289.7564857+2e27f35a57f757f058dc95e34c56722a76307900.pck
The CERT on the website is now up-to-date
On 7/28/25 7:07 AM, willie.castillo@caemilusa.com wrote:
Looks like "hyperkitty" stopped archiving right after the CERT for the mailman3 website expired, How can I make the missing archives visible on the website? I see there "*pck" files in the/opt/mailman/mm/var/archives/hyperkitty/spool/ directory. The list archive does not show that last posting [of 25 July 2025.
~$ ll -t /opt/mailman/mm/var/archives/hyperkitty/spool/ -rw-rw---- 1 mailman mailman 98215 Jul 25 12:01 1753459289.7901242+f3fd7ee77272862f8c1023394bf88d0d4bbe9053.pck -rw-rw---- 1 mailman mailman 98109 Jul 25 12:01 1753459289.7726512+ee1264c36a194eb0ec1a52089f053e6963f24369.pck -rw-rw---- 1 mailman mailman 88479 Jul 25 12:01 1753459289.7564857+2e27f35a57f757f058dc95e34c56722a76307900.pck
The CERT on the website is now up-to-date
Those queued messages will be reprocessed on the next post.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
Got it. Is there a command that one can manually run to test/expedite the process?
From: Mark Sapiro <mark@msapiro.net> Sent: Monday, July 28, 2025 12:11 PM To: mailman-users@mailman3.org <mailman-users@mailman3.org> Subject: [NON-INTERNAL] [MM3-users] Re: Missing Archived emails - Hyperkitty - CERT Issue
CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
On 7/28/25 7:07 AM, willie.castillo@caemilusa.com wrote:
Looks like "hyperkitty" stopped archiving right after the CERT for the mailman3 website expired, How can I make the missing archives visible on the website? I see there "*pck" files in the/opt/mailman/mm/var/archives/hyperkitty/spool/ directory. The list archive does not show that last posting [of 25 July 2025.
~$ ll -t /opt/mailman/mm/var/archives/hyperkitty/spool/ -rw-rw---- 1 mailman mailman 98215 Jul 25 12:01 1753459289.7901242+f3fd7ee77272862f8c1023394bf88d0d4bbe9053.pck -rw-rw---- 1 mailman mailman 98109 Jul 25 12:01 1753459289.7726512+ee1264c36a194eb0ec1a52089f053e6963f24369.pck -rw-rw---- 1 mailman mailman 88479 Jul 25 12:01 1753459289.7564857+2e27f35a57f757f058dc95e34c56722a76307900.pck
The CERT on the website is now up-to-date
Those queued messages will be reprocessed on the next post.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
Mailman-users mailing list -- mailman-users@mailman3.org To unsubscribe send an email to mailman-users-leave@mailman3.org https://urldefense.us/v3/__https://lists.mailman3.org/mailman3/lists/mailman... Archived at: https://urldefense.us/v3/__https://lists.mailman3.org/archives/list/mailman-...
This message sent to willie.castillo@caemilusa.com
willie.castillo@caemilusa.com writes:
Looks like "hyperkitty" stopped archiving right after the CERT for the mailman3 website expired, How can I make the missing archives visible on the website? I see there "*pck" files in the/opt/mailman/mm/var/archives/hyperkitty/spool/ directory. The list archive does not show that last posting [of 25 July 2025.
It's been a while since I've looked closely at this, but if I'm wrong nothing disastrous will happen, you'll just have to wait a little longer.
The hyperkitty/spool directory is a staging area for the messages to be archived. As usual "spool" implies "work to be done", and HyperKitty (specifically the mailman_hyperkitty IArchiver implementation) considers all .pck files in the spool to be tasks in the queue. The assumption is that most sites will (a) rarely have trouble and (b) will be archiving frequently, so there is no polling done. Rather, when a message is scheduled to be archived, the archiver wakes up and archives everything in that directory.
So the messages should be added to the archive the next time a message arrives. Note that this is not list-specific: if there's a pending message for list A and a message for list B arrives, the archiver will process A and then B.
The easiest way to trigger this is to send a test message.
Steve
-- GNU Mailman consultant (installation, migration, customization) Sirius Open Source https://www.siriusopensource.com/ Software systems consulting in Europe, North America, and Japan
I tried with a new post and still, not showing the messages from July 25th in the Archive. There must be a way to force the archiving of the messages from July 25th.
List metrics
Created at March 25, 2016, 11:15 a.m. Last post at July 25, 2025, 12:01 p.m. Digest last sent at July 25, 2025, 12:01 p.m. Volume 135
From: Stephen J. Turnbull <steve@turnbull.jp> Sent: Monday, July 28, 2025 12:15 PM To: Willie Castillo <Willie.Castillo@caemilusa.com> Cc: mailman-users@mailman3.org <mailman-users@mailman3.org> Subject: [NON-INTERNAL] [MM3-users] Missing Archived emails - Hyperkitty - CERT Issue
CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
willie.castillo@caemilusa.com writes:
Looks like "hyperkitty" stopped archiving right after the CERT for the mailman3 website expired, How can I make the missing archives visible on the website? I see there "*pck" files in the/opt/mailman/mm/var/archives/hyperkitty/spool/ directory. The list archive does not show that last posting [of 25 July 2025.
It's been a while since I've looked closely at this, but if I'm wrong nothing disastrous will happen, you'll just have to wait a little longer.
The hyperkitty/spool directory is a staging area for the messages to be archived. As usual "spool" implies "work to be done", and HyperKitty (specifically the mailman_hyperkitty IArchiver implementation) considers all .pck files in the spool to be tasks in the queue. The assumption is that most sites will (a) rarely have trouble and (b) will be archiving frequently, so there is no polling done. Rather, when a message is scheduled to be archived, the archiver wakes up and archives everything in that directory.
So the messages should be added to the archive the next time a message arrives. Note that this is not list-specific: if there's a pending message for list A and a message for list B arrives, the archiver will process A and then B.
The easiest way to trigger this is to send a test message.
Steve
-- GNU Mailman consultant (installation, migration, customization) Sirius Open Source https://urldefense.us/v3/__https://www.siriusopensource.com/__;!!E8b8mVbrrfW... Software systems consulting in Europe, North America, and Japan
On 7/28/25 13:07, Willie Castillo wrote:
I tried with a new post and still, not showing the messages from July 25th in the Archive. There must be a way to force the archiving of the messages from July 25th.
List metrics
Created at March 25, 2016, 11:15 a.m. Last post at July 25, 2025, 12:01 p.m. Digest last sent at July 25, 2025, 12:01 p.m. Volume 135
Did the new post get archived? If so, why is last post at still July 25, 2025? If no, why not. The post must go to the archiver to cause the queue to be processed.
If the post was archived and the July 25 messages are still queued, what's in Mailman's mailman.log. There should be error messages and tracebacks indicating the issue.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
The issue started right after the site's CERT expired. The CERT expired on 7/8/25. This is what's in the log...
Jul 16 15:19:45 2025 (3777209) Connection to HyperKitty failed: HTTPSConnectionPool(host='XXX.com', port=443): Max retries exceeded with url: /hyperkitty/api/mailman/urls?mlist=jmats-versions%40XXX.com (Caused by SSLError(SSLCertVerificatio nError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1000)')))
The CERT has been updated but the 7/25 message is not archived still.
From: Mark Sapiro <mark@msapiro.net> Sent: Monday, July 28, 2025 8:10 PM To: mailman-users@mailman3.org <mailman-users@mailman3.org> Subject: [NON-INTERNAL] [MM3-users] Re: Missing Archived emails - Hyperkitty - CERT Issue
CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
On 7/28/25 13:07, Willie Castillo wrote:
I tried with a new post and still, not showing the messages from July 25th in the Archive. There must be a way to force the archiving of the messages from July 25th.
List metrics
Created at March 25, 2016, 11:15 a.m. Last post at July 25, 2025, 12:01 p.m. Digest last sent at July 25, 2025, 12:01 p.m. Volume 135
Did the new post get archived? If so, why is last post at still July 25, 2025? If no, why not. The post must go to the archiver to cause the queue to be processed.
If the post was archived and the July 25 messages are still queued, what's in Mailman's mailman.log. There should be error messages and tracebacks indicating the issue.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
Mailman-users mailing list -- mailman-users@mailman3.org To unsubscribe send an email to mailman-users-leave@mailman3.org https://urldefense.us/v3/__https://lists.mailman3.org/mailman3/lists/mailman... Archived at: https://urldefense.us/v3/__https://lists.mailman3.org/archives/list/mailman-...
This message sent to willie.castillo@caemilusa.com
On Tue, Jul 29, 2025 at 2:25 PM Willie Castillo < Willie.Castillo@caemilusa.com> wrote:
The issue started right after the site's CERT expired. The CERT expired on 7/8/25. This is what's in the log...
Jul 16 15:19:45 2025 (3777209) Connection to HyperKitty failed: HTTPSConnectionPool(host='XXX.com', port=443): Max retries exceeded with url: /hyperkitty/api/mailman/urls?mlist=jmats-versions%40XXX.com (Caused by SSLError(SSLCertVerificatio nError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1000)')))
The CERT has been updated but the 7/25 message is not archived still.
While at it, also edit your /etc/mailman3/mailman-hyperkitty.cfg to what is documented so that the issue doesn't recur:
[general]
base_url: http://127.0.0.1:8000/archives/
api_key: Secret_Hyperkitty_API_Key
PS: I haven't seen your responses to @Mark Sapiro <mark@msapiro.net>'s questions quoted below:
Did the new post get archived? If so, why is last post at still July 25,
2025? If no, why not. The post must go to the archiver to cause the
queue to be processed.
If the post was archived and the July 25 messages are still queued,
what's in Mailman's mailman.log. There should be error messages and
tracebacks indicating the issue.
-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 In an Internet failure case, the #1 suspect is a constant: DNS. "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
Odhiambo, long time no hear from you. Hope you are doing well.
The last archived post for that specific list is July 3rd. 2025. We do not see the one for July 25th. Also, I just noticed something else in the logs, apparently the server is still having "SSLCertVerificationError" issues even after updating the DigiCert, CA-Certificate,etc. I must be missing something else.
Based on that, looks like the archiving is failing still due to the "SSLCertVerificationError".
The spool directory now has 8 *.pck files in it. However, I do not see the original ones from 7/25
~# ll -t /opt/mailman/mm/var/archives/hyperkitty/spool/ -rw-rw---- 1 mailman mailman 14725 Jul 29 08:07 1753790859.2498085+320096cb9852779b55a4cbb1e4f9603736ebd78d.pck -rw-rw---- 1 mailman mailman 15122 Jul 29 08:07 1753790859.2437658+7fddf881d592f27be60e32aa5b3c34c7077b9988.pck -rw-rw---- 1 mailman mailman 6399 Jul 29 08:07 1753790859.2370558+ee410eb31691bf2854cca46c64e80e3bf61c3523.pck -rw-rw---- 1 mailman mailman 26619 Jul 29 08:07 1753790859.230345+b2e70f5b65900731895bbee5a3d83401f1500567.pck -rw-rw---- 1 mailman mailman 15676 Jul 29 08:07 1753790859.2225533+82371c8a0202d62eaa046dd3633a23d6837d7a80.pck -rw-rw---- 1 mailman mailman 98273 Jul 29 08:07 1753790859.2136636+8ee9273fbbaf4352d482e69d177e2eb2824078a5.pck -rw-rw---- 1 mailman mailman 98109 Jul 29 08:07 1753790859.2026713+49d82ecd57eda7eaa582ba925449e2343bea5c56.pck -rw-rw---- 1 mailman mailman 88479 Jul 29 08:07 1753790859.191489+162aa89dcac50ca6f5463ce1098c828728af12d1.pck
From: Odhiambo Washington <odhiambo@gmail.com> Sent: Tuesday, July 29, 2025 7:59 AM To: mailman-users@mailman3.org <mailman-users@mailman3.org>; Mark Sapiro <mark@msapiro.net> Cc: Willie Castillo <Willie.Castillo@caemilusa.com> Subject: Re: [MM3-users] Re: [NON-INTERNAL] Re: Missing Archived emails - Hyperkitty - CERT Issue
CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
On Tue, Jul 29, 2025 at 2:25 PM Willie Castillo <Willie.Castillo@caemilusa.com<mailto:Willie.Castillo@caemilusa.com>> wrote: The issue started right after the site's CERT expired. The CERT expired on 7/8/25. This is what's in the log...
Jul 16 15:19:45 2025 (3777209) Connection to HyperKitty failed: HTTPSConnectionPool(host='XXX.com', port=443): Max retries exceeded with url: /hyperkitty/api/mailman/urls?mlist=jmats-versions%40XXX.com (Caused by SSLError(SSLCertVerificatio nError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1000)')))
The CERT has been updated but the 7/25 message is not archived still.
While at it, also edit your /etc/mailman3/mailman-hyperkitty.cfg to what is documented so that the issue doesn't recur:
[general]
base_url: http://127.0.0.1:8000/archives/<https://urldefense.us/v3/__http://127.0.0.1:8000/archives/__;!!E8b8mVbrrfWVcek!glw-g3knxj8jBnaLt92Gfcoe9xRWN9Rdhynf9OTv2LVHY1g7_xbQx2S77JlnnC2sPkf9X868-82ATRdCQNPaTrM$>
api_key: Secret_Hyperkitty_API_Key
PS: I haven't seen your responses to @Mark Sapiro<mailto:mark@msapiro.net>'s questions quoted below:
Did the new post get archived? If so, why is last post at still July 25,
2025? If no, why not. The post must go to the archiver to cause the
queue to be processed.
If the post was archived and the July 25 messages are still queued,
what's in Mailman's mailman.log. There should be error messages and
tracebacks indicating the issue.
-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 In an Internet failure case, the #1 suspect is a constant: DNS. "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html<https://urldefense.us/v3/__http://www.catb.org/*esr/faqs/smart-questions.html__;fg!!E8b8mVbrrfWVcek!glw-g3knxj8jBnaLt92Gfcoe9xRWN9Rdhynf9OTv2LVHY1g7_xbQx2S77JlnnC2sPkf9X868-82ATRdCe5mb8eg$>]
PS: I beg you to put your responses below the last one. Makes the hierarchy look better.
Now, have you edited your /etc/mailman3/mailman-hyperkitty.cfg and restarted MM3?
On Tue, Jul 29, 2025 at 3:18 PM Willie Castillo < Willie.Castillo@caemilusa.com> wrote:
Odhiambo, long time no hear from you. Hope you are doing well.
The last archived post for that specific list is July 3rd. 2025. We do not see the one for July 25th. Also, I just noticed something else in the logs, apparently the server is still having "SSLCertVerificationError" issues even after updating the DigiCert, CA-Certificate,etc. I must be missing something else.
Based on that, looks like the archiving is failing still due to the "SSLCertVerificationError".
The spool directory now has 8 *.pck files in it. However, I do not see the original ones from 7/25
~# ll -t /opt/mailman/mm/var/archives/hyperkitty/spool/ -rw-rw---- 1 mailman mailman 14725 Jul 29 08:07 1753790859.2498085+320096cb9852779b55a4cbb1e4f9603736ebd78d.pck -rw-rw---- 1 mailman mailman 15122 Jul 29 08:07 1753790859.2437658+7fddf881d592f27be60e32aa5b3c34c7077b9988.pck -rw-rw---- 1 mailman mailman 6399 Jul 29 08:07 1753790859.2370558+ee410eb31691bf2854cca46c64e80e3bf61c3523.pck -rw-rw---- 1 mailman mailman 26619 Jul 29 08:07 1753790859.230345+b2e70f5b65900731895bbee5a3d83401f1500567.pck -rw-rw---- 1 mailman mailman 15676 Jul 29 08:07 1753790859.2225533+82371c8a0202d62eaa046dd3633a23d6837d7a80.pck -rw-rw---- 1 mailman mailman 98273 Jul 29 08:07 1753790859.2136636+8ee9273fbbaf4352d482e69d177e2eb2824078a5.pck -rw-rw---- 1 mailman mailman 98109 Jul 29 08:07 1753790859.2026713+49d82ecd57eda7eaa582ba925449e2343bea5c56.pck -rw-rw---- 1 mailman mailman 88479 Jul 29 08:07 1753790859.191489+162aa89dcac50ca6f5463ce1098c828728af12d1.pck
*From:* Odhiambo Washington <odhiambo@gmail.com> *Sent:* Tuesday, July 29, 2025 7:59 AM *To:* mailman-users@mailman3.org <mailman-users@mailman3.org>; Mark Sapiro <mark@msapiro.net> *Cc:* Willie Castillo <Willie.Castillo@caemilusa.com> *Subject:* Re: [MM3-users] Re: [NON-INTERNAL] Re: Missing Archived emails
- Hyperkitty - CERT Issue
CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
On Tue, Jul 29, 2025 at 2:25 PM Willie Castillo < Willie.Castillo@caemilusa.com> wrote:
The issue started right after the site's CERT expired. The CERT expired on 7/8/25. This is what's in the log...
Jul 16 15:19:45 2025 (3777209) Connection to HyperKitty failed: HTTPSConnectionPool(host='XXX.com', port=443): Max retries exceeded with url: /hyperkitty/api/mailman/urls?mlist=jmats-versions%40XXX.com (Caused by SSLError(SSLCertVerificatio nError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1000)')))
The CERT has been updated but the 7/25 message is not archived still.
While at it, also edit your /etc/mailman3/mailman-hyperkitty.cfg to what is documented so that the issue doesn't recur:
[general] base_url: http://127.0.0.1:8000/archives/ <https://urldefense.us/v3/__http://127.0.0.1:8000/archives/__;!!E8b8mVbrrfWVcek!glw-g3knxj8jBnaLt92Gfcoe9xRWN9Rdhynf9OTv2LVHY1g7_xbQx2S77JlnnC2sPkf9X868-82ATRdCQNPaTrM$> api_key: Secret_Hyperkitty_API_KeyPS: I haven't seen your responses to @Mark Sapiro <mark@msapiro.net>'s questions quoted below:
Did the new post get archived? If so, why is last post at still July 25, 2025? If no, why not. The post must go to the archiver to cause the queue to be processed. If the post was archived and the July 25 messages are still queued, what's in Mailman's mailman.log. There should be error messages and tracebacks indicating the issue.-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 In an Internet failure case, the #1 suspect is a constant: DNS. "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html <https://urldefense.us/v3/__http://www.catb.org/*esr/faqs/smart-questions.html__;fg!!E8b8mVbrrfWVcek!glw-g3knxj8jBnaLt92Gfcoe9xRWN9Rdhynf9OTv2LVHY1g7_xbQx2S77JlnnC2sPkf9X868-82ATRdCe5mb8eg$> ]
-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 In an Internet failure case, the #1 suspect is a constant: DNS. "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
Sure. the file was updated and MM3 restarted. Looks like the modification to the /etc/mailman3/mailman-hyperkitty.cfg file did the trick. We are now able to see the July 25th message in the archives.
Thank you Odhiambo and Mark for your assistance.
From: Odhiambo Washington via Mailman-users <mailman-users@mailman3.org> Sent: Tuesday, July 29, 2025 8:54 AM To: mailman-users@mailman3.org <mailman-users@mailman3.org> Subject: [MM3-users] Re: [NON-INTERNAL] Re: Missing Archived emails - Hyperkitty - CERT Issue
CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
PS: I beg you to put your responses below the last one. Makes the hierarchy look better.
Now, have you edited your /etc/mailman3/mailman-hyperkitty.cfg and restarted MM3?
On Tue, Jul 29, 2025 at 3:18 PM Willie Castillo < Willie.Castillo@caemilusa.com> wrote:
Odhiambo, long time no hear from you. Hope you are doing well.
The last archived post for that specific list is July 3rd. 2025. We do not see the one for July 25th. Also, I just noticed something else in the logs, apparently the server is still having "SSLCertVerificationError" issues even after updating the DigiCert, CA-Certificate,etc. I must be missing something else.
Based on that, looks like the archiving is failing still due to the "SSLCertVerificationError".
The spool directory now has 8 *.pck files in it. However, I do not see the original ones from 7/25
~# ll -t /opt/mailman/mm/var/archives/hyperkitty/spool/ -rw-rw---- 1 mailman mailman 14725 Jul 29 08:07 1753790859.2498085+320096cb9852779b55a4cbb1e4f9603736ebd78d.pck -rw-rw---- 1 mailman mailman 15122 Jul 29 08:07 1753790859.2437658+7fddf881d592f27be60e32aa5b3c34c7077b9988.pck -rw-rw---- 1 mailman mailman 6399 Jul 29 08:07 1753790859.2370558+ee410eb31691bf2854cca46c64e80e3bf61c3523.pck -rw-rw---- 1 mailman mailman 26619 Jul 29 08:07 1753790859.230345+b2e70f5b65900731895bbee5a3d83401f1500567.pck -rw-rw---- 1 mailman mailman 15676 Jul 29 08:07 1753790859.2225533+82371c8a0202d62eaa046dd3633a23d6837d7a80.pck -rw-rw---- 1 mailman mailman 98273 Jul 29 08:07 1753790859.2136636+8ee9273fbbaf4352d482e69d177e2eb2824078a5.pck -rw-rw---- 1 mailman mailman 98109 Jul 29 08:07 1753790859.2026713+49d82ecd57eda7eaa582ba925449e2343bea5c56.pck -rw-rw---- 1 mailman mailman 88479 Jul 29 08:07 1753790859.191489+162aa89dcac50ca6f5463ce1098c828728af12d1.pck
*From:* Odhiambo Washington <odhiambo@gmail.com> *Sent:* Tuesday, July 29, 2025 7:59 AM *To:* mailman-users@mailman3.org <mailman-users@mailman3.org>; Mark Sapiro <mark@msapiro.net> *Cc:* Willie Castillo <Willie.Castillo@caemilusa.com> *Subject:* Re: [MM3-users] Re: [NON-INTERNAL] Re: Missing Archived emails
- Hyperkitty - CERT Issue
CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
On Tue, Jul 29, 2025 at 2:25 PM Willie Castillo < Willie.Castillo@caemilusa.com> wrote:
The issue started right after the site's CERT expired. The CERT expired on 7/8/25. This is what's in the log...
Jul 16 15:19:45 2025 (3777209) Connection to HyperKitty failed: HTTPSConnectionPool(host='XXX.com', port=443): Max retries exceeded with url: /hyperkitty/api/mailman/urls?mlist=jmats-versions%40XXX.com (Caused by SSLError(SSLCertVerificatio nError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1000)')))
The CERT has been updated but the 7/25 message is not archived still.
While at it, also edit your /etc/mailman3/mailman-hyperkitty.cfg to what is documented so that the issue doesn't recur:
[general] base_url: https://urldefense.us/v3/__http://127.0.0.1:8000/archives/__;!!E8b8mVbrrfWVcek!ngvkfyoNkipJzHH99SWyPROb8IPdqhSrf84E72McXX6bmSjg3U-eD6gf5eEIsO1bIxSlkCPQ60UFS5yPyeCD2Qjn2rzlRBsBMQ$ <https://urldefense.us/v3/__http://127.0.0.1:8000/archives/__;!!E8b8mVbrrfWVcek!glw-g3knxj8jBnaLt92Gfcoe9xRWN9Rdhynf9OTv2LVHY1g7_xbQx2S77JlnnC2sPkf9X868-82ATRdCQNPaTrM$> api_key: Secret_Hyperkitty_API_KeyPS: I haven't seen your responses to @Mark Sapiro <mark@msapiro.net>'s questions quoted below:
Did the new post get archived? If so, why is last post at still July 25, 2025? If no, why not. The post must go to the archiver to cause the queue to be processed. If the post was archived and the July 25 messages are still queued, what's in Mailman's mailman.log. There should be error messages and tracebacks indicating the issue.-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 In an Internet failure case, the #1 suspect is a constant: DNS. "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: https://urldefense.us/v3/__http://www.catb.org/*esr/faqs/smart-questions.html__;fg!!E8b8mVbrrfWVcek!ngvkfyoNkipJzHH99SWyPROb8IPdqhSrf84E72McXX6bmSjg3U-eD6gf5eEIsO1bIxSlkCPQ60UFS5yPyeCD2Qjn2ryUrvLqSg$ <https://urldefense.us/v3/__http://www.catb.org/*esr/faqs/smart-questions.htm...> ]
-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 In an Internet failure case, the #1 suspect is a constant: DNS. "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: https://urldefense.us/v3/__http://www.catb.org/*esr/faqs/smart-questions.html__;fg!!E8b8mVbrrfWVcek!ngvkfyoNkipJzHH99SWyPROb8IPdqhSrf84E72McXX6bmSjg3U-eD6gf5eEIsO1bIxSlkCPQ60UFS5yPyeCD2Qjn2ryUrvLqSg$ ]
Mailman-users mailing list -- mailman-users@mailman3.org To unsubscribe send an email to mailman-users-leave@mailman3.org https://urldefense.us/v3/__https://lists.mailman3.org/mailman3/lists/mailman... Archived at: https://urldefense.us/v3/__https://lists.mailman3.org/archives/list/mailman-...
This message sent to willie.castillo@caemilusa.com
Willie Castillo writes:
The spool directory now has 8 *.pck files in it. However, I do not see the original ones from 7/25
If you mean you don't see any files from 7/25 in the directory listing, that's right, you won't. Processing a queuefile involves rewriting the metadata in it (the archive handler does not touch the message itself, although other handlers do), so the file's date is always the last time the queue was processed.
To know approximately when the files were first received, I use 'mailman qfile /path/to/archive/spool/<LONGSTRING>.pck | grep Date:' which fishes the date header out of the file.
-- GNU Mailman consultant (installation, migration, customization) Sirius Open Source https://www.siriusopensource.com/ Software systems consulting in Europe, North America, and Japan
participants (5)
-
Mark Sapiro -
Odhiambo Washington -
Stephen J. Turnbull -
Willie Castillo -
willie.castillo＠caemilusa.com