Fossil

File History
Login

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

History of src/email.c

2018-08-30
14:43
Attempt to make the /subscribe and /alerts forms less confusing. file: [258c2803] check-in: [6d04bab4] 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: [dba99958] check-in: [1bfd7903] 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: [5c715117] check-in: [731836b8] 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: [880f8f0c] check-in: [475c9d11] 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: [35cb9020] check-in: [8c0ec30b] 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: [b97f7c62] check-in: [ad419331] user: drh branch: trunk, size: 85422
20:30
Be sure to send forum event notifications in chronological order. file: [aeec702e] check-in: [b4602502] user: drh branch: trunk, size: 84753
16:16
Add the find_emailaddr() SQL function. file: [ea489268] check-in: [8a20d41f] 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: [1d0f6f1a] check-in: [27404ad0] 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: [d80f594b] check-in: [164c3d1a] 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: [03468eb6] check-in: [2e308280] user: drh branch: trunk, size: 82495
13:47
Add table sorting to the subscriber list. file: [a3c97758] check-in: [988cf44d] 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: [0b017cda] check-in: [4d659173] 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: [a48a7b22] check-in: [174ab076] 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: [febdef73] check-in: [81c25431] 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: [56c2208b] check-in: [efbd6caa] user: drh branch: failed-fix, size: 77024
12:51
Merge enhancements from trunk. file: [120423c9] check-in: [ce3d5718] user: drh branch: failed-fix, size: 74476
2018-07-31
00:09
Fix harmless compiler warnings. file: [0d77aaf4] check-in: [ea2e5151] user: mistachkin branch: trunk, size: 73656
2018-07-30
19:34
Fix errors in the permission checking for email notification. file: [48d6dbc1] check-in: [c286157c] 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: [f31cfef6] check-in: [8a28a37c] 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: [7370eaee] check-in: [d8b20a55] 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: [3e9d921b] check-in: [ada7ecde] 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: [b3726dd2] check-in: [86b43a46] 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: [c5bd49b0] check-in: [38165f37] 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: [b6d4f9ef] check-in: [f880aa82] 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: [c704f925] check-in: [0f6a5ee1] user: drh branch: trunk, size: 74034
15:07
Show the email notification status at the top of the /setup_notification page. file: [5fdc2b84] check-in: [308f4065] 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: [8ba5291a] check-in: [94da0fb2] user: drh branch: webmail, size: 73844
2018-07-16
13:33
Initialize variable to quell compiler warning about potentially unitialized variable. file: [5117b93a] check-in: [0cb83dec] 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: [47e5531c] check-in: [6e6e3c8b] 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: [35444dc4] check-in: [43336f67] user: drh branch: trunk, size: 73059
2018-07-12
15:19
For new subscribers, default all alert options to "on". file: [ebec452e] check-in: [9c388035] user: drh branch: trunk, size: 72995
14:29
Update the documentation on the email-send-method setting. file: [593d4887] check-in: [83b12c3a] 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: [f213321b] check-in: [9830d7cb] 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: [a01a3f65] check-in: [aa80d694] 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: [d4768373] check-in: [006cc814] user: drh branch: smtp, size: 71963
17:27
Add "SMTP relay" as a new method for sending alert emails. file: [c21d6cb4] check-in: [b96415f0] user: drh branch: smtp, size: 71080
16:06
Merge fixes and improvements from trunk. file: [048ec920] check-in: [4f30802a] user: drh branch: smtp, size: 66028
15:40
Fix harmless compiler warnings. file: [2d796338] check-in: [50daa540] user: drh branch: trunk, size: 65991
15:37
Improve the conformance to rfc2822 for generated email messages. file: [364511bb] check-in: [429ae9b7] 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: [4933af45] check-in: [e4144ced] user: drh branch: smtp, size: 65413
12:56
Attempt to make an error log entry following a segfault. file: [393258fd] check-in: [c670925e] user: drh branch: trunk, size: 65376
2018-06-28
17:22
Fix the wording on the documentation of the /announce web page. file: [e22a4e89] check-in: [dfe0cf7e] user: drh branch: trunk, size: 65355
2018-06-27
17:02
Fix typo in the manpage for the /announce page. file: [b7770b56] check-in: [c1bce3f5] 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: [ccd81059] check-in: [6a7d2ad8] 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: [debad2e7] check-in: [122905c2] user: drh branch: trunk, size: 65405
02:01
Change the email transfer encoding to quoted-printable. file: [924ab84f] check-in: [b6a13c45] user: drh branch: trunk, size: 65395
01:24
Initial implementation of the /announce webpage. file: [f32c77cc] check-in: [65f57546] 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: [c63b3d8f] check-in: [4ef59090] 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: [a59b14d9] check-in: [9040de46] 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: [bc330ec4] check-in: [69d332ff] user: drh branch: trunk, size: 59825
14:45
Enhancements to administrator access to the subscriber list. file: [9144c9d0] check-in: [b7b877ef] user: drh branch: trunk, size: 59839
13:32
Make sure emailerShutdown() correctly closes the emailqueue database. file: [44026b34] check-in: [b9121b47] 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: [4bce232f] check-in: [f87fb027] 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: [04043c7a] check-in: [f3de8b66] user: drh branch: trunk, size: 58876
10:07
Fix an SQL syntax error. file: [9d3989d2] check-in: [0398e41a] user: drh branch: trunk, size: 58545
2018-06-23
20:11
Fix typos and update documentation. file: [be30097c] check-in: [08165ad4] user: drh branch: trunk, size: 58546
19:55
Do not require Email-Notify permission to operate the /alerts page with a valid subscriberCode. file: [8da0ceef] check-in: [15910589] user: drh branch: trunk, size: 58544
19:51
Fix the use of captchas on the /msgadmin page. file: [06e04804] check-in: [43532cd1] user: drh branch: trunk, size: 58619
19:36
Add the /msgadmin page. file: [89621c1b] check-in: [0c4d3c12] user: drh branch: trunk, size: 58591
18:44
Automatically send alert emails after each webpage request. file: [c34e733c] check-in: [d4e9df17] 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: [214ab302] check-in: [98d2338a] user: drh branch: trunk, size: 54610
16:44
Improved documentation. No substantive code changes. file: [25970ebe] check-in: [9cf915d4] 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: [64b92216] check-in: [b4218987] user: drh branch: trunk, size: 52663
01:33
Futher corrections to the email alert trigger. file: [c4b30fd0] check-in: [2c3b9030] user: drh branch: trunk, size: 50092
01:26
Fix minor problems with email notification. file: [bb5c6a20] check-in: [d7ccfb64] user: drh branch: trunk, size: 50127
01:24
Fix minor problems in email notification. file: [c025d1cb] check-in: [1cdf6f20] user: drh branch: trunk, size: 50133
00:49
Fix some minor problems with email notification support file: [2aa79546] check-in: [c2566260] user: drh branch: email-alerts, size: 49976
2018-06-22
19:48
Improvements to on-line subscription management. file: [dbed54b1] check-in: [e649820b] user: drh branch: email-alerts, size: 49983
19:03
Add the "fossil email subscribers" and "fossil email unsubscribe" commands. file: [043d6457] check-in: [ba60f874] user: drh branch: email-alerts, size: 48743
18:23
Alert sending logic compiles but is so far untested. file: [da2335b6] check-in: [44f9f355] user: drh branch: email-alerts, size: 46461
17:36
A new way of computing alert text. file: [0de80cf9] check-in: [6c06b1c8] user: drh branch: email-alerts, size: 43591
15:57
Generate event report in chronological order for an alert text. file: [9f74476c] check-in: [e0289252] user: drh branch: email-alerts, size: 42779
15:34
Add logic to generate the text of email alert messages. file: [2cce7cc1] check-in: [bb30d02e] user: drh branch: email-alerts, size: 42625
12:25
Make sure the content of outbound email messages always ends with a newline. file: [65351405] check-in: [b7003483] user: drh branch: email-alerts, size: 38247
03:17
Add the /unsubscribe page. file: [e3cc67d6] check-in: [f9116088] user: drh branch: email-alerts, size: 38141
01:28
Fix harmless compiler warnings. file: [7e20f79d] check-in: [5fde17bb] 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: [e07c7af4] check-in: [8c4b92ad] 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: [6d485164] check-in: [775e529b] user: drh branch: email-alerts, size: 32351
22:37
Continuing refinement of the web pages for handling email subscriptions. file: [4243ff5a] check-in: [84d0d853] user: drh branch: email-alerts, size: 30309
21:02
Add the /subscribers page. Fix minor issues. All pages still need improvement. file: [9c99a138] check-in: [e015c103] user: drh branch: email-alerts, size: 29465
19:51
Further progress toward get email subscription webpages working. file: [4edf72b5] check-in: [adf068fa] user: drh branch: email-alerts, size: 28448
19:10
The /subscribe page now creates entries in the subscriber table and sends verification emails. file: [bb5c71dd] check-in: [31be2e17] user: drh branch: email-alerts, size: 27028
15:19
Merge the popen() on windows fix from trunk. file: [0cb04b40] check-in: [ef2426dc] user: drh branch: email-alerts, size: 22145
15:02
Provide an implementation for popen() and pclose() on Windows to fix the build. file: [5c432ead] check-in: [565b5ff0] 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: [2cc28638] check-in: [e91143e8] user: drh branch: email-alerts, size: 22024
2018-06-20
22:39
First attempt at a /subscribe page. Non-functional display only. file: [e85da464] check-in: [fb3934ec] user: drh branch: trunk, size: 17980
19:56
Manage the email.c file. Accidentally omitted from the previous three check-ins. Bummer. file: [92394276] check-in: [fa83e4b3] user: drh branch: trunk, size: 16722 Added