History of src/alerts.c of 2b96941c4c924e56
Not logged in

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History of file src/alerts.c at check-in 2b96941c4c924e56

2025-12-27
12:21
Spelling fixes in docs/comments. file: [9672703e15] check-in: [33d3bf3edb] user: km branch: trunk, size: 124981
2025-12-23
16:06
Assorted fixes of typos and grammar in code comments. No functional changes. file: [91f6d51748] check-in: [e2bdc10572] user: danield branch: trunk, size: 124984
2025-12-11
13:01
Ensure that the TEMP TRIGGERs that keep the chat FTS index up-to-date exist before inserting new entries into the chat table itself. file: [016c2f9342] check-in: [614b3f7559] user: drh branch: trunk, size: 124982
2025-11-03
20:39
Add a note to the email-listid setting help text and editor entry that this value is required for unsubscribe links to work. In /secaudit0, emit a warning if notifications are enabled but email-listid is empty. This is in response to [forum:1245b69cfa09c26e|forum post 1245b69c]. file: [28f21c449a] check-in: [0151018383] user: stephan branch: trunk, size: 124910
2025-04-23
18:13
Do not include the List-Id in announcement messages to non-subscribers. But do include the List-Id for renewal notices. file: [568618c2e1] check-in: [908612e334] user: drh branch: trunk, size: 124740
2025-04-16
00:48
Automatic retry on an SMTP relay failure. file: [52b3992f0a] check-in: [2b96941c4c] user: drh branch: trunk, size: 124017
2025-04-15
23:34
Attempt to provide improved error message outputs for failures while trying to send notification via relay to an MTA. file: [6fbf289649] check-in: [e6c27d3dab] user: drh branch: trunk, size: 124054
2025-04-08
15:58
Change the user-elevation notification subscription to a user-perms-changed notification, per /chat disucssion. file: [9767237012] check-in: [36f72c0872] user: stephan branch: trunk, size: 123732
12:43
Change the message for the 'user elevation' notification to help clarify that it's not necessarily an elevation. Help/message text changes only - no functional changes. file: [2e3895a6e6] check-in: [eabccae174] user: stephan branch: trunk, size: 123748
2025-04-07
17:08
Show the menu of trouble-shooting options to administrators at the bottom of the /announce page. file: [0f1ebe5088] check-in: [c98eec22c2] user: drh branch: trunk, size: 123738
16:57
Usage hints on email-send-relayhost to suggest using an IP address to avoid name lookup problems from within chroot jails. file: [a314739cc3] check-in: [8266b5b3cf] user: drh branch: trunk, size: 123242
16:42
Improved debugging and diagnostic capabilities for announcement sending, especially when using relay. file: [8563bdffac] check-in: [056c83d120] user: drh branch: trunk, size: 123020
16:03
New debugging option for /announce shows the SMTP transcript when the notification type is "relay". file: [bca7c3d0bb] check-in: [bbfca4cb64] user: drh branch: trunk, size: 122559
15:27
Clean up the interface to internal smtp_session_new() routine. file: [a68a3ccd66] check-in: [3fc9b90587] user: drh branch: trunk, size: 121631
15:14
Add convenient access to the notification setup menu when dealing with email notification pages as an administrator. file: [c915585898] check-in: [4859a911f5] user: drh branch: trunk, size: 121628
05:25
Make the default value for email-send-relayhost be "localhost" file: [fd2a559070] check-in: [6c7066a1c5] user: drh branch: trunk, size: 121466
05:06
On the notification setup page, add a Refresh button to Status. Make Relay the first choice. file: [828485d1f0] check-in: [cad72b796f] user: drh branch: trunk, size: 121451
2025-03-19
11:31
Simplify the command property of "abbreviated-subcommands" to just "abbrv-subcom" and the setting property of "show-only-if-changed" to just "if-chng". file: [b26a747f90] check-in: [3e7c7e2277] user: drh branch: trunk, size: 121295
2025-03-16
22:40
New setting "verify-comments" defaults to on, but can be turned off to prevent checkin comment sanity checking. This setting does not appear in the "fossil settings" list unless it differs from the default, or unless the "--extra" argument is added to "fossil settings". file: [7784922b9d] check-in: [8f4aedcf84] user: drh branch: trunk, size: 121306
2025-03-09
07:12
Cleanups, mostly docs, in the user elevation alerts. Document the currently-known ways which this particular alert differs from others. This needs more sanding-down but am checking this in to go work on the broken user deletion (which pre-dates this branch but was first discovered here (edit: that was a PEBKAC error, not a bug)). file: [c29f4986b3] check-in: [d6c5c7f639] user: stephan branch: useredit-note-elevation, size: 121300
2025-03-08
12:48
Initial alerts infrastructure for user-elevation notifications. Alerts are not yet sent. file: [e37d381510] check-in: [54db7c07a7] user: stephan branch: useredit-note-elevation, size: 120836
2025-03-01
16:02
Improvements to rendering in the "fossil help" command, especially in combination with the -u/--usage and -o/--options command-line options. file: [3c2aa63801] check-in: [62cb8ea785] user: drh branch: trunk, size: 120280
2024-10-12
12:03
Emit only \n, not \r\n, even in places where protocols technically require a full \r\n. Provide a compile-time option -DSEND_CR=1 that includes the CRs when necessary. file: [f73039b250] check-in: [0dcce257b0] user: drh branch: omit-cr, size: 120403
2024-08-23
13:55
Allow for multiple captcha-secret values. The primary is still 'captcha-secret'. Backups are in 'captcha-secret-N' where N is a small integer. The backups are only valid for 6 hours. This allows the captcha-secret to be changed without disrupting anonymous logins and/or captcha dialogs that are in progress when the secret changes. file: [1525ee2c1f] check-in: [8659d84aff] user: drh branch: trunk, size: 120236
2024-07-01
08:09
Typo fix in /alerts help text. file: [72ec947ba1] check-in: [62a7616184] user: stephan branch: fts5-chat-search, size: 120227
2024-02-02
22:18
Remove trailing whitespace from non-external C files. file: [2c2851b6a7] check-in: [7db0a2d910] user: danield branch: fix-overlength-lines, size: 120227
2024-01-21
21:57
Typo fix and EOL whitespace cleanups. No functional changes. file: [3d326f08d5] check-in: [e0576ea919] user: stephan branch: trunk, size: 120230
18:03
Improved support for one-click unsubscribe for notifications. file: [a3ba9fb490] check-in: [bca95cbf9c] user: drh branch: trunk, size: 120262
01:59
Typo fix and EOL whitespace cleanups. No functional changes. file: [e1beb31cbd] check-in: [55151f0024] user: stephan branch: trunk, size: 119442
2024-01-20
22:31
Include the "List-Unsubscribe" headers in all notification emails. file: [1068ac7f8d] check-in: [b76320edee] user: drh branch: trunk, size: 119479
2023-12-13
18:50
Bug fixes in the alert sending backoffice task. Hopefully this will start sending email notifications to people correctly. The bug was likely introduced by [d4361f6a94725aa3]. file: [453cdb3155] check-in: [2917bedada] user: drh branch: trunk, size: 119266
2023-09-29
13:35
merge in fossil-settings-value-only file: [d433a1434f] check-in: [0d4a31a9f5] user: preben branch: trunk, size: 119216
2023-09-18
15:10
More intensive use of the Synchronizer Token Pattern for CSRF defense. file: [408ad09001] check-in: [0a66be2b75] user: drh branch: csrf-defense-enhancement, size: 119210
2023-08-31
12:20
Show the complete CGI environment in the error log on a 418 hack attempt error. file: [080cd3fc09] check-in: [0204f4aab5] user: drh branch: trunk, size: 119180
2023-08-14
21:09
Make sure the EmailEvent object is completely zeroed whenever it is allocated. file: [8a9abe09c4] check-in: [33877fa50b] user: drh branch: trunk, size: 119177
2023-08-05
21:18
Two new notification options: "n" means to be notified for new forum threads only and "r" means to be notified for forum posts that are a reply to a post made by the user. file: [2485a4fd22] check-in: [d4361f6a94] user: drh branch: trunk, size: 119172
16:09
Minor wording changes on the /unsubscribe page. file: [baf3c2172d] check-in: [37f929e3ae] user: drh branch: trunk, size: 116032
2023-05-10
18:40
Removed all of the XML-style " />" tag closing markers on empty tags such as "hr", "br", and "input" to placate modern HTML5 validators. That's the doctype we declare, not XHTML, so we should conform. (Besides which, the XHTML dream is dead.) file: [0d010efd36] check-in: [f5482a0a79] user: wyoung branch: trunk, size: 116027
2023-04-19
00:29
Prototype/proof-of-concept implementation of an admin flag for the forum which tells it to not send email notifications for a given edit or new post. file: [236f042ce6] check-in: [65062c29d4] user: stephan branch: forum-skip-notification, size: 116031
2023-03-02
10:26
An equivalent of the patch proposed in [forum:f183ab47a7beee47|forum post f183ab47a7beee47] to resolve the argument sent to smtp EHLO, reducing it from an email address to the domain part of the address. file: [ba5f237673] check-in: [be4815b17e] user: stephan branch: smtp-ehlo, size: 115419
2023-02-03
07:21
prefill the tktnew page email field with user emailaddr

If the logged-in user has a valid email address in their contact-info, use it to prefill the email field in the /tktnew page when submitting a new ticket. As discussed in /chat, enhance the Fossil builtin find_emailaddr() SQL function--suggested by wyoung@--to parse strings for well-formed email addresses not necessarily wrapped in <...>. Requested by jose i cabrera on the [forum:62838ffe73|forum]. file: [6d3fc33fbe] check-in: [f974583f90] user: mark branch: trunk, size: 115372

2023-01-09
13:06
Further consistency improvements in docs for various commands. file: [af90ba153f] check-in: [2512d2d472] user: km branch: trunk, size: 115302
2022-12-31
12:16
Fix more cases where updates to the SUBSCRIBER table should be allowed to occur even if not a request from the same origin. file: [3b15dbaa2e] check-in: [f33976f7cc] user: drh branch: trunk, size: 115285
2022-12-29
21:09
All writes to the subscriber table to update the last contact time even if the request is not from the same origin. file: [d2f707e0d3] check-in: [db16262817] user: drh branch: trunk, size: 115115
2022-11-13
17:18
Merge trunk into wcag-2.1 for cleaner diff comparison. file: [1333eec70b] check-in: [e1a9fdd768] user: stephan branch: wcag-2.1, size: 115594
16:26
Apply fixes to all web views to pass WCAG 2.1 tests performed by "axe DevTools" browser extension. Most fixes related to screen reader compatibility, like making sure that form elements have labels. Some color changes to improve contrast on Default skin. Made more HTML5 compliant. Minor improvement to select combo boxes for UX. Improved Search form UX. Two minor bug fixes for malformed HTML. Fixed help pages to resolve issues with non-compliant HTML being generated. Mostly documented at https://fossil-scm.org/forum/forumpost/aafb17a981df4166 file: [a99d038653] check-in: [1f231db380] user: ericwikman branch: wcag-2.1, size: 115458
2022-11-11
22:24
A proposed fix for ticket [ad9aa572e7972f57]. Use an UPDATE rather than a REPLACE where possible when redoing EVENT table entries for tickets that are being rebuild, in order to avoid unnecessary notification events. file: [1b6bfaf871] check-in: [1f0f62261c] user: drh branch: ticket-notification-fix, size: 114999
2022-09-15
16:58
Added lmtime value to chat-timeline-user's chat messages, using the server's local time, to fix time display in the /chat message popup. file: [27bcfdfcff] check-in: [e1ad499265] user: stephan branch: trunk, size: 114863
15:51
Improved comments on the new chat-timeline-user feature. file: [d4f8666f8e] check-in: [c3ed2430cc] user: drh branch: trunk, size: 114764
15:35
Improved chat messages for the chat-timeline-robot. file: [efff28191c] check-in: [974cf3667c] user: drh branch: trunk, size: 114584
2022-09-14
19:24
Do not require that the chat-timeline robot username be an actual user in the USER table. If the chat-timeline-user config variable exists, then timeline events are announced in chat, regardless. file: [ceb9d50600] check-in: [1f5474ec31] user: drh branch: trunk, size: 113731
2022-09-13
20:11
Add the ability to designate a timeline robot user. If such a user exists, and if chat is enabled, then notifications of all timeline events appear in chat, from the robot user. file: [aefcdd5ded] check-in: [e9d7cf3e92] user: drh branch: trunk, size: 113920
2022-07-29
19:03
Fix the /alerts page so that access is provided even for users that are not logged in as long as a complete subscription code is provided as the "name" query parameter. file: [8d49b884e4] check-in: [a27c908f5d] user: drh branch: trunk, size: 113105
18:57
The /unsubscribe page now requests comformation. And so email notifications contain only an "Unsubscribe" link, and not a link to subscription management. file: [85e988722f] check-in: [f045c5dd26] user: drh branch: trunk, size: 113201
2022-07-17
23:48
Changed a number of "a" articles followed by vowels in docs and comments to "an", per [forum:/forumpost/3e6e40293f03f089 | a forum post]. file: [b10aaad76d] check-in: [99a319bdbf] user: wyoung branch: trunk, size: 112075
2022-05-25
20:03
Provide the ability to add a List-Id: header on out-bound notification emails. file: [bb9d68812b] check-in: [e50c3629b8] user: drh branch: trunk, size: 112074
2022-05-14
06:37
Typo fix in email-renew-interval setting docs, per forum report. file: [9d86b2c6de] check-in: [7ae1f31994] user: stephan branch: trunk, size: 111383
2022-02-23
17:18
Spelling corrections caught by Debian's automated tools, thanks to Barak A. Pearlmutter. file: [51dec530ce] check-in: [9993c43b5c] user: danshearer branch: trunk, size: 111383
2022-01-27
06:45
Make MSVC build fail any level 2 warnings, and build w/o any. file: [33ad6b1274] check-in: [9c1199d723] user: larrybr branch: msvc-warn2-fatal, size: 111383
2022-01-18
03:59
When renaming a user, rename any matching subscription entry to avoid that the user can no longer subscribe with the new name because the email address is already mapped. Also log user renames to the admin log. This does not work across all login groups because we don't know if each member has the subscriber table. file: [900693a122] check-in: [cdcffc413d] user: stephan branch: trunk, size: 111381
2021-12-20
20:52
Better documentation for the email-url setting. Add a new entry form for the email-url setting on the /setup_config page. file: [ea5abdb63a] check-in: [7e993c709a] user: drh branch: trunk, size: 111377
2021-09-13
21:30
Fix typo. file: [cf05b28253] check-in: [1e5dc324ef] user: mistachkin branch: trunk, size: 111124
2021-07-08
17:43
Enhancement to codecheck1.c to verify that routines like db_set() use a string literal as the setting argument, and are thus impervious to injection attacks. file: [0cadba1078] check-in: [0a5d0e191c] user: drh branch: trunk, size: 111124
2021-06-30
19:14
Initial changes to support HOST: prefixes on the REPOSITORY argument of the "fossil ui" command. file: [7e675791ed] check-in: [cb34f1a8ac] user: drh branch: remote-ui, size: 111107
2021-06-17
02:20
/announce page: add an explicit ACTION value for the form so that a 'to=...' URL parameter does not end up shadowing the 'to' field of the form and causing the announcement to be sent to the URL-provided address even if that form field is edited. file: [2a05b48e57] check-in: [2fa43ef4fb] user: stephan branch: trunk, size: 111228
2021-06-07
15:30
Improvements to the subscription-about-to-expire email message. file: [8b6e2b3c39] check-in: [1508169998] user: drh branch: trunk, size: 110865
01:17
Minor simplification of the "test-alerts" debugging command. file: [a344ed7b58] check-in: [5d28db4da1] user: drh branch: trunk, size: 110853
2021-05-31
18:58
Automatic messages requesting user renewal are now generated, about once every 7 days. This needs more testing before going live. file: [773eab9149] check-in: [01ee25cf58] user: drh branch: time-limited-subscriptions, size: 111132
12:35
Show the last contact time in the administrator view of the subscriber information page. file: [e36f157227] check-in: [11b7c7699f] user: drh branch: time-limited-subscriptions, size: 106541
12:04
Infrastructure added to support expiring subscriptions when there has been no contact with the recipient in some number of days. file: [b0ecdfea63] check-in: [b4bba2ef60] user: drh branch: time-limited-subscriptions, size: 106230
2021-05-28
21:12
More infrastructure for expiring subscriptions for inactive accounts. But the functionality is not complete and does not actually do anything, yet. file: [ad3c59b32f] check-in: [7b8be208bc] user: drh branch: trunk, size: 103388
18:02
Add the subscriber.lastContact field for tracking the last contact time for each subscriber. Keep this field up-to-day. The field is currently used but the plan is to use it to optionally ask inactive subscribers to renew periodically. file: [cc2d7242e2] check-in: [d7e10ce4da] user: drh branch: trunk, size: 101519
15:13
Further reading of RFC-8058 shows that I must also include a List-Unsubscribe-Post header. file: [6cf04dacc9] check-in: [733fcecaca] user: drh branch: trunk, size: 100645
15:01
Add a List-Unsubscribe: header to all notification emails. file: [85eb00286d] check-in: [4a3909afc8] user: drh branch: trunk, size: 100564
2021-03-11
13:22
Numerous help text consistency tweaks based on forum discussion [forum:8c644048f0]. file: [96a2a08aba] check-in: [4cb50c4ef3] user: stephan branch: trunk, size: 100367
2021-02-12
16:42
Email alerts now show the type of wiki operation (add/edit/remove) for wiki edits and no longer render the magic internal timeline comment prefix character in the alert. file: [3ce99fea74] check-in: [7fcfa93321] user: stephan branch: trunk, size: 100367
2021-02-07
13:02
Typo fix in alerts config page. file: [a8d6e1030c] check-in: [391eb1cefb] user: stephan branch: trunk, size: 100094
2021-02-03
14:23
Disable triggers using SQLITE_DBCONFIG_ENABLE_TRIGGERS for defense in depth. SQLite 3.35.0 is required due to Fossil's use of TEMP triggers. Also, use the new RETURNING clause for queries where it makes sense, again requiring SQLite 3.35.0. file: [9b17c81f30] check-in: [8a3dc1a975] user: drh branch: trunk, size: 100094
2021-01-03
23:18
Revamp the trigger used to captures changes to the EVENT table for use in other subsystems. The trigger is now a TEMP trigger rather than a persistent trigger. Rebuild notice: You can upgrade through this change without trouble, as the schema will adjust automatically. However, if you downgrade back through this change you must run rebuild to recreate the persistent triggers. file: [73d98587f2] check-in: [169ba8d4df] user: drh branch: trunk, size: 100248
2020-12-22
12:13
Removed the parameter from style_finish_page() since the resulting content div class is now redundant with respect to the body class. This potentially breaks CSS made against old class names that a prior commit on this branch changed, but such skins would be made against an unreleased version of Fossil, it's unlikely many are using that first version of the feature anyway, and most of the class names did *not* change unless you were targeting a "div" instead of "body" or just a generic class name. None of the shipping skins are affected. file: [d2f3991e3b] check-in: [0e83ca88ce] user: wyoung branch: body-feature-class, size: 100135
11:58
Calling the new style_set_current_feature() function to override the new TH1 variable $current_feature for Fossil UI pages where the page name isn't what we want used as the "body" CSS class. For the most part, this matches the value currently being passed to style_finish_page(), but a few have changed with the benefit of hindsight. Not all calls to style_finish_page() have a corresponding call to the new function since the default value for $current_page now suffices. file: [698abdba97] check-in: [8ac0830bfc] user: wyoung branch: body-feature-class, size: 100247
2020-11-07
13:25
Rename the "style_body_and_footer()" interface to "style_finish_page()" and add a more detailed header comment to the implementation. file: [16778ef413] check-in: [942b2076c6] user: drh branch: default-css-cleanups, size: 99856
2020-11-05
23:15
Added a parameter to style_footer() and renamed it to match its actual function (style_body_and_footer()) so we can add a CSS class to each page that indicates which major Fossil feature served the page, so we can have module-specific CSS. file: [8f436a5500] check-in: [ef5424b683] user: wyoung branch: default-css-cleanups, size: 99912
2020-10-28
16:13
When deleting a subscription, also provide the opportunity to delete the corresponding user. When deleting a user, always also delete subscriptions associated with that user. file: [336a7b2632] check-in: [b6b5a7dc62] user: drh branch: trunk, size: 99678
2020-08-18
01:54
Disable writes the CONFIG and USER tables by default. Permission to write to those tables is turned on as needed. Note - might have missed a few places so expect bugs. file: [82160a85b5] check-in: [ca9156aa0a] user: drh branch: sec2020, size: 99216
2020-08-17
15:11
Identify security-sensitive settings. file: [0ef4ca8756] check-in: [aa4c3afc52] user: drh branch: sec2020-config-protection, size: 99154
2020-07-01
22:15
Fix an error in the way that alerts are counted for use in the backoffice log. file: [9773defbf3] check-in: [77377e6c02] user: drh branch: trunk, size: 99104
20:16
Improved logging of backoffice operations. file: [f353855d5d] check-in: [71b9f35475] user: drh branch: trunk, size: 99095
2020-06-27
17:05
Typos in the help text and the change log. file: [72c574bab3] check-in: [cd061779d2] user: drh branch: trunk, size: 98991
2020-04-24
02:17
Add a new setting to disallow anonymous subscriptions. Anonymous subscriptions are enabled by default. file: [c2a1dbfc80] check-in: [d048d86d0d] user: drh branch: restricted-self-registration, size: 98991
01:47
When there are repeated errors on a subscription or self-registration entry form, do not force the user to reenter the captcha if they have already entered it correctly once. file: [ddafe4067d] check-in: [3d80481216] user: drh branch: restricted-self-registration, size: 98691
00:49
Add the ability to deny capabilities to self-registered accounts until the email verification comes through. file: [4ce9e4b578] check-in: [3b7970e032] user: drh branch: restricted-self-registration, size: 98264
2020-04-23
22:17
Fix bugs in the /subscribe page that could allow an attacker to subscribe and verify without actually having a working email address. file: [54dfce2c07] check-in: [15e15298f8] user: drh branch: trunk, size: 97849
18:49
Bug fix: Allow new subscribers the option to select "Forum Edits", though it still defaults to "off". file: [12ee12c086] check-in: [ea81b30ddf] user: drh branch: trunk, size: 95560
2020-04-22
15:57
For email alerts on forum posts, if the forum post is a reply to a prior post that has been edited two or more times, ensure that the In-Reply-To header on the email message refers to the very first edition of the in-reply-to post. Prior check-in [137cba6f1b81170d] attempt to do the same thing, but only worked for cases where the post was edited just once. file: [34b1f0fb99] check-in: [fb4545ef93] user: drh branch: trunk, size: 95408
2020-04-11
22:35
Merged from trunk file: [d86cf08d69] check-in: [2f24675ab5] user: ashepilko branch: api-cleanup, size: 94986
2020-04-10
19:01
For email alerts on forum posts that are in reply to a prior post that has been edited, make the In-Reply-To point to the Message-Id of the original unedited post. This should help avoid breaking threads in email readers for subscribers who do not receive notification of post edits. bug report. file: [1a5e4160b6] check-in: [137cba6f1b] user: drh branch: trunk, size: 94996
2020-04-05
23:45
Match the COMMAND and WEBPAGE names with _cmd and _page functions; forumpost/045bffda68 file: [a269609b57] check-in: [06afb7022f] user: ashepilko branch: api-cleanup, size: 94899
2020-04-01
00:00
Fix warnings on possible uninitialized variable use. file: [4c82b8ecaa] check-in: [0ba1528fa3] user: ashepilko branch: trunk, size: 94909
2020-03-28
18:21
Add email-url, email-admin, and email-subname to the settings that can be managed by the "fossil alert setting" command. file: [33ab42ee90] check-in: [a0ae0c9ff6] user: drh branch: trunk, size: 94893
2020-03-27
22:25
In the previous check-in, fix the subscriber count after doing a purge. file: [f9cbe9c5bf] check-in: [8ccab68fc6] user: drh branch: trunk, size: 94281
22:23
Add the ability to purge old pending subscriptions from the /subscribers page. file: [a342c2b2d5] check-in: [8c40c38f5e] user: drh branch: trunk, size: 94261
14:30
Use the display name rather than the login for forum posts. file: [6524573629] check-in: [2e71dc25d9] user: drh branch: trunk, size: 93263
2020-03-26
18:54
Add a new subscription option to receive edits to forum posts. If this option is not selected, then alerts are only sent on the initial post, not on edits. Also: Use the "forumObs" class on timeline forum text that has been subsequently edited. file: [1b00ef0e97] check-in: [e5653a4ceb] user: drh branch: trunk, size: 92503
13:53
Validate the email address in the subscription editing form. file: [ce79a8c774] check-in: [32a8d11025] user: drh branch: trunk, size: 91874
13:18
Add the "Send a message to ..." link for administrators on the subscription configuration page. file: [3e24d50061] check-in: [bb05299ee7] user: drh branch: trunk, size: 91194
13:11
Improvements to the "Notification" setup screen. Take steps to ensure that the email address does not get cleared when editing subscriber preferences. file: [ccb4cdcba1] check-in: [60d40d5b58] user: drh branch: trunk, size: 91052
2020-03-25
17:48
Add the email address editing to the subscriber information screen (/alerts). Improved cross-linking between subscriber and user editing screens for administrators. file: [6c5581457f] check-in: [54a6f098ec] user: drh branch: trunk, size: 90943
2020-03-17
12:17
Filter notifications to reduce multiple alerts if forum-posts are edited. file: [c7a17e6e23] check-in: [1c84fa5569] user: graham branch: alert-filter, size: 95189
2020-03-16
19:45
Experimental: Change the X-Fossil-From: header in alert emails to Sender:. This might help with Outlook users. Or it might make things worse. The only think I know to do is try it and see what happens. file: [6398f1bc7c] check-in: [b4dcf8e4ef] user: drh branch: trunk, size: 90359
2020-03-15
21:24
Enhance the /announce page so that it provides an option to send a message to all forum moderators. file: [9f5d41c044] check-in: [84d854c6d1] user: drh branch: trunk, size: 90394
20:43
Fix the /announce/test2 feature so that it works without asserting. file: [331d697b7a] check-in: [ea4ccfdc2d] user: drh branch: trunk, size: 89522
15:43
Introduce a new version of db_multi_exec() that does not do printf-style formatting. file: [69e2c61058] check-in: [0ea56bb239] user: drh branch: trunk, size: 89524
2020-03-14
13:36
Put the "speak the text" buttons for captcha audio closer to the boxes in which the person must enter the text. file: [ab74f101a3] check-in: [a584491ab8] user: drh branch: trunk, size: 89543
12:49
Fix a harmless compiler warning. file: [d90edfc88f] check-in: [11d1233d30] user: drh branch: trunk, size: 89489
12:40
Add "Speak the text" buttons consistently to all captchas. file: [ef99a22318] check-in: [93bbd28aa0] user: drh branch: audio-captcha, size: 89481
03:59
Add "Speak the text" buttons on captchas. file: [ecc7ddea32] check-in: [3b10bdd683] user: drh branch: audio-captcha, size: 89466
2019-12-23
13:17
Ticket alerts reference the actual ticket, not the ticket change artifact. file: [c645bdf3d1] check-in: [1a5dee1ea2] user: drh branch: trunk, size: 89363
2019-09-19
14:14
In the db_get(N,D) function, if N is setting, then always leave D as NULL so that we use the published default value for that setting. file: [0e045c861a] check-in: [eb804dc674] user: drh branch: trunk, size: 89209
2019-08-31
16:42
Merge in latest from trunk. file: [f3a7f543f4] check-in: [aa37639112] user: andybradford branch: db-begin-txn-updates, size: 89215
2019-07-22
19:06
Bail out of the alert_send() routine if the notification system is misconfigured with a blank email-self value. file: [2ea635f210] check-in: [4c73b4afb9] user: drh branch: trunk, size: 89221
16:12
In the alert sending logic, if no "email-self" is specified, then substitute the bogus email address "nobody@invalid". file: [a6f58c4b38] check-in: [488af3639e] user: drh branch: trunk, size: 89198
2019-03-19
14:09
Replace most calls to db_begin_transaction() with db_begin_write() to avoid having a reader locking during a COMMIT. file: [78ead0d160] check-in: [6cc5354821] user: andybradford branch: db-begin-txn-updates, size: 89093
2018-12-10
08:07
Attempt to get the backoffice running on Windows. file: [bcde67007c] check-in: [c52fb5eddb] user: tsbg branch: backoffice-win, size: 89266
2018-12-04
23:08
Fixed a use of fclose() on a handle opened with popen(), noticed by Stephan Beal. file: [9af05613dc] check-in: [1f4b4fcb62] user: wyoung branch: trunk, size: 89099
2018-11-30
21:08
Fix the labels on email alerts for wiki edits and ticket changes, which were reversed. file: [e31f86ca2b] check-in: [a8856c6beb] user: drh branch: trunk, size: 89099
2018-10-04
07:36
Avoided a crash in Fossil > Admin > Notification > Send Announcement triggered when no subscribers are set up, causing it to fail on Submit if you tell it to send the announcement to all subscribers. The check also guards against sending such things before email alerts are set up. In either case, the "Send Announcmeent" page gives an error pointing you to the docs, rather than a form that cannot be successfully submitted. file: [e66cf82704] check-in: [ea646955f1] user: wyoung branch: trunk, size: 89099
2018-10-03
16:52
Remove uncommonly used commands from the set of "common" commands in the "fossil help" listing. file: [6ef3d73e68] check-in: [2931351893] user: drh branch: trunk, size: 88824
2018-09-26
18:39
Setup and Admin users that are in the subscriber table were getting email alerts only if they had explicit moderator capabilities set. Those with bare "s" or "a" weren't getting notified. file: [3b0746077a] check-in: [1d3dd1d917] user: wyoung branch: trunk, size: 88823
2018-08-31
22:03
Login and subscription forms work better on mobile. file: [bbef3993c6] check-in: [27769be9d0] user: drh branch: trunk, size: 88708
21:07
Render captchas in a smaller font that works better on mobile. file: [f5c5e447af] check-in: [75c89def6b] user: drh branch: trunk, size: 88639
10:47
Enhancements to the /sitemap page. New configuration options to add optional entries to the /sitemap page. file: [d18967d34e] check-in: [6898b3e730] user: drh branch: trunk, size: 88591
2018-08-30
21:19
Renamed and modified src/email.c → src/alerts.c. Change the name of the "email.c" source file into "alerts.c". Make corresponding changes to various interfaces. file: [040f312599] check-in: [cfbbc53778] user: drh branch: refactor-alerts, size: 88510
14:43
Attempt to make the /subscribe and /alerts forms less confusing. file: [258c2803ea] check-in: [6d04bab418] user: drh branch: trunk, size: 88454
2018-08-17
01:27
Allow + signs in email addresses. Added a comment to link to a source giving the true limit on legal characters in email addresses, which are currently far less restrictive than our newly-expanded limits. file: [dba99958ae] check-in: [1bfd790352] user: wyoung branch: trunk, size: 87762
2018-08-16
19:51
Do not put "Return-Path:" headers in notification emails to be sent. That is a violation of standards as only the receiving SMTP server should add the Return-Path header. Instead, include a custom X-Fossil-From: header that downstream software can use (if desired) to set the envelope header of the message. file: [5c71511777] check-in: [731836b869] user: drh branch: trunk, size: 87583
18:56
For email notifications abound events from a single user (such as individual forum post notifications) make the From: address be a "noreply" hash based on the users human-readable name or handle. Always include a Return-Path: field in the header that is the email-self setting, to be used by MTUs that need to bounce the message. file: [880f8f0cac] check-in: [475c9d11e9] user: drh branch: trunk, size: 87316
2018-08-14
05:59
Changed all of the "sendmail -t" commands to "sendmail -ti" to make it ignore lines containing only a dot; we use EOF to signal "end of message," so we don't need the second signal. This is separate from the smtp.c fix in [51740ce45f]: that's only used when Fossil speaks directly to an SMTP server, where a leading dot is treated somewhat differently than the lone dot rule for sendmail(1)'s stdin.

This problem with leading dots was diagnosed by gumblex, /forumpost/4290f75ba1. file: [35cb902031] check-in: [8c0ec30bc3] user: wyoung branch: trunk, size: 85423

2018-08-10
23:28
Try to put the human name of the person who posted on the From: line of email notifications for new forum posts. file: [b97f7c62cf] check-in: [ad4193315f] user: drh branch: trunk, size: 85422
20:30
Be sure to send forum event notifications in chronological order. file: [aeec702efe] check-in: [b460250211] user: drh branch: trunk, size: 84753
16:16
Add the find_emailaddr() SQL function. file: [ea489268ed] check-in: [8a20d41fce] user: drh branch: trunk, size: 84745
2018-08-09
15:39
Improvements to formatting in generated emails to make them appear less like spam. Suggestions from "gahr" on the forum. file: [1d0f6f1a13] check-in: [27404ad05f] user: drh branch: trunk, size: 83787
14:15
Take care that a bug in the email alert sender results in missed alerts rather than an endless cascade of duplicate alerts. file: [d80f594b1e] check-in: [164c3d1a6a] user: drh branch: trunk, size: 83382
2018-08-08
20:01
Enhance the /register page so that it also does email subscriptions if that is enabled for self-registered users. file: [03468eb60c] check-in: [2e30828044] user: drh branch: trunk, size: 82495
13:47
Add table sorting to the subscriber list. file: [a3c9775809] check-in: [988cf44ded] user: drh branch: trunk, size: 82259
2018-08-07
00:22
For non-digest subscribers, alerts for new forum posts are now in separate emails with each email having a subject which is the title of the forum thread, and with appropriate Message-Id and In-Reply-To header fields so that email clients can string together the email thread. Digest subscribes still get just the synopsis. file: [0b017cda4d] check-in: [4d6591736e] user: drh branch: forum-v2, size: 82028
2018-08-06
20:39
Bug fix: Do not send non-digest subscribers the daily digest email. file: [a48a7b225a] check-in: [174ab076eb] user: drh branch: failed-fix, size: 78094
19:39
Rearrange some of the subcommands on "fossil alerts" for better UX. Fix a problem in the /webmail display for messages with no subject. Improved comments. file: [febdef738f] check-in: [81c254311e] user: drh branch: failed-fix, size: 78072
19:15
Improvements to email notification. Rename the "email" command to "alerts". Try to avoid sending alerts about unapproved events, except it is ok to send such alerts to moderators. This is a work in progress. file: [56c2208b24] check-in: [efbd6caa7c] user: drh branch: failed-fix, size: 77024
12:51
Merge enhancements from trunk. file: [120423c9f1] check-in: [ce3d571837] user: drh branch: failed-fix, size: 74476
2018-07-31
00:09
Fix harmless compiler warnings. file: [0d77aaf49c] check-in: [ea2e515153] user: mistachkin branch: trunk, size: 73656
2018-07-30
19:34
Fix errors in the permission checking for email notification. file: [48d6dbc180] check-in: [c286157cc9] user: drh branch: forum-v2, size: 74472
19:14
Break out the processing of capability strings into a separate source file. Add new SQL functions: capunion() and fullcap(). Only send email notifications to users who have appropriate capabilities. file: [f31cfef68b] check-in: [8a28a37c87] user: drh branch: forum-v2, size: 74472
2018-07-24
13:30
Revamp the /register page for added security. Require entry of a display name and email address. Validate the email address format and check for duplicate email addresses. file: [7370eaeec9] check-in: [d8b20a555f] user: drh branch: forum-v2, size: 73678
2018-07-19
17:22
The email_auto_exec property is removed. The routine that sends alert emails is renamed to email_backoffice() and it is configured to always auto-run. file: [3e9d921b2b] check-in: [ada7ecde5b] user: drh branch: trunk, size: 73652
2018-07-18
16:43
Add the backoffice module for doing post-processing actions such as sending alerts and/or syncing repositories. file: [b3726dd249] check-in: [86b43a4648] user: drh branch: backoffice, size: 74007
01:40
Add the --logdir option to the "fossil pop3d" command. Fix some issues with POP3 reply formatting. file: [c5bd49b02c] check-in: [38165f3764] user: drh branch: trunk, size: 74419
2018-07-17
18:32
Improved tracing capabilities for email notifications. Add the SelectAll button to the webmail display. file: [b6d4f9ef2d] check-in: [f880aa82aa] user: drh branch: trunk, size: 74766
15:32
Webmail changes compile on linux, mac, and windows now, so merge them to trunk. They are not ready for use, but they should not interfere with the stable parts of the code, and it is easier to test from trunk. file: [c704f92554] check-in: [0f6a5ee117] user: drh branch: trunk, size: 74034
15:07
Show the email notification status at the top of the /setup_notification page. file: [5fdc2b848b] check-in: [308f406546] user: drh branch: webmail, size: 74032
13:54
Add a reference count field to the emailblob table and triggers to keep the reference count current and to drop entries when the reference count reaches zero. file: [8ba5291ac8] check-in: [94da0fb27c] user: drh branch: webmail, size: 73844
2018-07-16
13:33
Initialize variable to quell compiler warning about potentially unitialized variable. file: [5117b93aa3] check-in: [0cb83decdd] user: andybradford branch: trunk, size: 73890
2018-07-14
00:54
Do not allow people to subscribe to notifications for which they do not have read permission. file: [47e5531c0c] check-in: [6e6e3c8b25] user: drh branch: trunk, size: 73888
2018-07-13
16:26
When logging transaction errors on the error log, try to include information about where the transaction started. file: [35444dc424] check-in: [43336f67c3] user: drh branch: trunk, size: 73059
2018-07-12
15:19
For new subscribers, default all alert options to "on". file: [ebec452e80] check-in: [9c38803597] user: drh branch: trunk, size: 72995
14:29
Update the documentation on the email-send-method setting. file: [593d488726] check-in: [83b12c3a78] user: drh branch: trunk, size: 72614
2018-07-11
20:37
Rename the /msgtoadmin page to /contact_admin. Improvements to the setup pages for notifications. file: [f213321b27] check-in: [9830d7cbed] user: drh branch: trunk, size: 72492
19:41
Add a setup menu option for Email-Server. Try to get the build of this branch working (without DNS support) for non-linux systems. file: [a01a3f6526] check-in: [aa80d6941e] user: drh branch: smtp, size: 71991
2018-06-30
18:29
Fixes to the "SMTP relay" alert send method. Add the --smtp-trace option to the "fossil email send" command. Expose and document the "email-send-relayhost" setting. file: [d4768373de] check-in: [006cc81437] user: drh branch: smtp, size: 71963
17:27
Add "SMTP relay" as a new method for sending alert emails. file: [c21d6cb468] check-in: [b96415f047] user: drh branch: smtp, size: 71080
16:06
Merge fixes and improvements from trunk. file: [048ec92015] check-in: [4f30802a88] user: drh branch: smtp, size: 66028
15:40
Fix harmless compiler warnings. file: [2d7963380e] check-in: [50daa540f8] user: drh branch: trunk, size: 65991
15:37
Improve the conformance to rfc2822 for generated email messages. file: [364511bbb3] check-in: [429ae9b736] user: drh branch: trunk, size: 65988
2018-06-29
19:54
The "fossil smtpd" command stores incoming messages in the database and routes them according to the emailroute table. file: [4933af4564] check-in: [e4144ced8d] user: drh branch: smtp, size: 65413
12:56
Attempt to make an error log entry following a segfault. file: [393258fd2c] check-in: [c670925e00] user: drh branch: trunk, size: 65376
2018-06-28
17:22
Fix the wording on the documentation of the /announce web page. file: [e22a4e89eb] check-in: [dfe0cf7ebf] user: drh branch: trunk, size: 65355
2018-06-27
17:02
Fix typo in the manpage for the /announce page. file: [b7770b56b6] check-in: [c1bce3f515] user: drh branch: trunk, size: 65372
2018-06-26
11:54
Fix compiler warnings on windows. Fix the file_directory_size() function so that it works on windows. file: [ccd81059a6] check-in: [6a7d2ad8f1] user: drh branch: trunk, size: 65375
02:26
Fix a critical bug in the new blob_append_char() routine that was added to the previous check-in. This bug causes crashes. Also change the quoted-printable encoding to escape the ':' character so that lines in the body of an email will never be confused with a header line like "From:". file: [debad2e758] check-in: [122905c29b] user: drh branch: trunk, size: 65405
02:01
Change the email transfer encoding to quoted-printable. file: [924ab84f28] check-in: [b6a13c45bd] user: drh branch: trunk, size: 65395
01:24
Initial implementation of the /announce webpage. file: [f32c77cc03] check-in: [65f5754611] user: drh branch: trunk, size: 64445
2018-06-25
20:56
Report on the email notification setup and status in the /stat page for administrators. file: [c63b3d8f86] check-in: [4ef590906d] user: drh branch: trunk, size: 59942
18:13
Change the schema of the subscriber table to make it compatible with the "fossil config sync" mechanism. Upgrading through this check-in requires running "fossil email reset" to rebuild the email notification schema, and losing subscriber information. file: [a59b14d9c7] check-in: [9040de46ec] user: drh branch: trunk, size: 59949
16:19
Fix harmless compiler warnings. Also remove the "ago" text from the "Last Change" column in the subscriber list webpage. file: [bc330ec4be] check-in: [69d332ff96] user: drh branch: trunk, size: 59825
14:45
Enhancements to administrator access to the subscriber list. file: [9144c9d07a] check-in: [b7b877ef49] user: drh branch: trunk, size: 59839
13:32
Make sure emailerShutdown() correctly closes the emailqueue database. file: [44026b34b6] check-in: [b9121b4797] user: drh branch: trunk, size: 58988
2018-06-24
17:44
Extra defenses against running the digest alert generator in a context where the transaction will rollback, thus failing to record the new digest time. Change the "fossil server" and "fossil ui" commands to always log errors to the console if no other error logging is defined. file: [4bce232ff2] check-in: [f87fb02780] user: drh branch: trunk, size: 58987
16:38
Enhance the --sqltrace logic. Using those enhancements, locate and fix and unclosed transaction in the email alert sender logic. file: [04043c7a9a] check-in: [f3de8b6632] user: drh branch: trunk, size: 58876
10:07
Fix an SQL syntax error. file: [9d3989d2a7] check-in: [0398e41aa6] user: drh branch: trunk, size: 58545
2018-06-23
20:11
Fix typos and update documentation. file: [be30097c9b] check-in: [08165ad45e] user: drh branch: trunk, size: 58546
19:55
Do not require Email-Notify permission to operate the /alerts page with a valid subscriberCode. file: [8da0ceef7d] check-in: [1591058951] user: drh branch: trunk, size: 58544
19:51
Fix the use of captchas on the /msgadmin page. file: [06e048043e] check-in: [43532cd1d5] user: drh branch: trunk, size: 58619
19:36
Add the /msgadmin page. file: [89621c1b44] check-in: [0c4d3c128a] user: drh branch: trunk, size: 58591
18:44
Automatically send alert emails after each webpage request. file: [c34e733cf2] check-in: [d4e9df1729] user: drh branch: trunk, size: 55703
17:07
Webpages function (with an sensible error) if the email notification tables are not in the schema. file: [214ab3020a] check-in: [98d2338a43] user: drh branch: trunk, size: 54610
16:44
Improved documentation. No substantive code changes. file: [25970ebeaf] check-in: [9cf915d4af] user: drh branch: trunk, size: 53503
14:24
Rework the internal email sending logic so that it is connection-oriented. This makes it more efficient and makes it easier to add support for an SMTP sending method at a later date. file: [64b92216a5] check-in: [b42189878e] user: drh branch: trunk, size: 52663
01:33
Futher corrections to the email alert trigger. file: [c4b30fd0c3] check-in: [2c3b903043] user: drh branch: trunk, size: 50092
01:26
Fix minor problems with email notification. file: [bb5c6a20a7] check-in: [d7ccfb64a3] user: drh branch: trunk, size: 50127
01:24
Fix minor problems in email notification. file: [c025d1cbf0] check-in: [1cdf6f2049] user: drh branch: trunk, size: 50133
00:49
Fix some minor problems with email notification support file: [2aa795464e] check-in: [c256626026] user: drh branch: email-alerts, size: 49976
2018-06-22
19:48
Improvements to on-line subscription management. file: [dbed54b1e6] check-in: [e649820ba1] user: drh branch: email-alerts, size: 49983
19:03
Add the "fossil email subscribers" and "fossil email unsubscribe" commands. file: [043d6457ab] check-in: [ba60f8744c] user: drh branch: email-alerts, size: 48743
18:23
Alert sending logic compiles but is so far untested. file: [da2335b61e] check-in: [44f9f35597] user: drh branch: email-alerts, size: 46461
17:36
A new way of computing alert text. file: [0de80cf92e] check-in: [6c06b1c896] user: drh branch: email-alerts, size: 43591
15:57
Generate event report in chronological order for an alert text. file: [9f74476c8a] check-in: [e02892522e] user: drh branch: email-alerts, size: 42779
15:34
Add logic to generate the text of email alert messages. file: [2cce7cc1d6] check-in: [bb30d02efd] user: drh branch: email-alerts, size: 42625
12:25
Make sure the content of outbound email messages always ends with a newline. file: [653514056e] check-in: [b700348373] user: drh branch: email-alerts, size: 38247
03:17
Add the /unsubscribe page. file: [e3cc67d6cd] check-in: [f911608824] user: drh branch: email-alerts, size: 38141
01:28
Fix harmless compiler warnings. file: [7e20f79d5a] check-in: [5fde17bbbc] user: drh branch: email-alerts, size: 33219
01:18
Rename the email_pending table to pending_alert. Add triggers to fill in the pending_alert table each time a row is added to the event table. file: [e07c7af421] check-in: [8c4b92ad3e] user: drh branch: email-alerts, size: 33399
2018-06-21
23:01
Add the "fossil email inbound" command, though it currently does not analyze the inbound emails - it just stores the emails in a directory for later human viewing. file: [6d4851641e] check-in: [775e529b32] user: drh branch: email-alerts, size: 32351
22:37
Continuing refinement of the web pages for handling email subscriptions. file: [4243ff5a20] check-in: [84d0d85317] user: drh branch: email-alerts, size: 30309
21:02
Add the /subscribers page. Fix minor issues. All pages still need improvement. file: [9c99a13818] check-in: [e015c10306] user: drh branch: email-alerts, size: 29465
19:51
Further progress toward get email subscription webpages working. file: [4edf72b580] check-in: [adf068faeb] user: drh branch: email-alerts, size: 28448
19:10
The /subscribe page now creates entries in the subscriber table and sends verification emails. file: [bb5c71dd6f] check-in: [31be2e17a4] user: drh branch: email-alerts, size: 27028
15:19
Merge the popen() on windows fix from trunk. file: [0cb04b40b9] check-in: [ef2426dc9e] user: drh branch: email-alerts, size: 22145
15:02
Provide an implementation for popen() and pclose() on Windows to fix the build. file: [5c432ead95] check-in: [565b5ff0c2] user: drh branch: trunk, size: 18101
12:34
Non-working code for the /subscribe and /alerts web pages. This is an incremental check-in. file: [2cc2863825] check-in: [e91143e813] user: drh branch: email-alerts, size: 22024
2018-06-20
22:39
First attempt at a /subscribe page. Non-functional display only. file: [e85da46409] check-in: [fb3934ec53] user: drh branch: trunk, size: 17980
19:56
Added: Manage the email.c file. Accidentally omitted from the previous three check-ins. Bummer. file: [92394276a0] check-in: [fa83e4b3e1] user: drh branch: trunk, size: 16722