Fossil

History for src/email.c
Login

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

History for src/email.c

2018-08-30
14:43
[258c2803] part of check-in [6d04bab4] Attempt to make the /subscribe and /alerts forms less confusing. (check-in: [6d04bab4] user: drh branch: trunk, size: 88454)
2018-08-17
01:27
[dba99958] part of check-in [1bfd7903] 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. (check-in: [1bfd7903] user: wyoung branch: trunk, size: 87762)
2018-08-16
19:51
[5c715117] part of check-in [731836b8] 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. (check-in: [731836b8] user: drh branch: trunk, size: 87583)
18:56
[880f8f0c] part of check-in [475c9d11] 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. (check-in: [475c9d11] user: drh branch: trunk, size: 87316)
2018-08-14
05:59
[35cb9020] part of check-in [8c0ec30b] 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. (check-in: [8c0ec30b] user: wyoung branch: trunk, size: 85423)

2018-08-10
23:28
[b97f7c62] part of check-in [ad419331] Try to put the human name of the person who posted on the From: line of email notifications for new forum posts. (check-in: [ad419331] user: drh branch: trunk, size: 85422)
20:30
[aeec702e] part of check-in [b4602502] Be sure to send forum event notifications in chronological order. (check-in: [b4602502] user: drh branch: trunk, size: 84753)
16:16
[ea489268] part of check-in [8a20d41f] Add the find_emailaddr() SQL function. (check-in: [8a20d41f] user: drh branch: trunk, size: 84745)
2018-08-09
15:39
[1d0f6f1a] part of check-in [27404ad0] Improvements to formatting in generated emails to make them appear less like spam. Suggestions from "gahr" on the forum. (check-in: [27404ad0] user: drh branch: trunk, size: 83787)
14:15
[d80f594b] part of check-in [164c3d1a] Take care that a bug in the email alert sender results in missed alerts rather than an endless cascade of duplicate alerts. (check-in: [164c3d1a] user: drh branch: trunk, size: 83382)
2018-08-08
20:01
[03468eb6] part of check-in [2e308280] Enhance the /register page so that it also does email subscriptions if that is enabled for self-registered users. (check-in: [2e308280] user: drh branch: trunk, size: 82495)
13:47
[a3c97758] part of check-in [988cf44d] Add table sorting to the subscriber list. (check-in: [988cf44d] user: drh branch: trunk, size: 82259)
2018-08-07
00:22
[0b017cda] part of check-in [4d659173] 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. (check-in: [4d659173] user: drh branch: forum-v2, size: 82028)
2018-08-06
20:39
[a48a7b22] part of check-in [174ab076] Bug fix: Do not send non-digest subscribers the daily digest email. (check-in: [174ab076] user: drh branch: failed-fix, size: 78094)
19:39
[febdef73] part of check-in [81c25431] 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. (check-in: [81c25431] user: drh branch: failed-fix, size: 78072)
19:15
[56c2208b] part of check-in [efbd6caa] 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. (check-in: [efbd6caa] user: drh branch: failed-fix, size: 77024)
12:51
[120423c9] part of check-in [ce3d5718] Merge enhancements from trunk. (check-in: [ce3d5718] user: drh branch: failed-fix, size: 74476)
2018-07-31
00:09
[0d77aaf4] part of check-in [ea2e5151] Fix harmless compiler warnings. (check-in: [ea2e5151] user: mistachkin branch: trunk, size: 73656)
2018-07-30
19:34
[48d6dbc1] part of check-in [c286157c] Fix errors in the permission checking for email notification. (check-in: [c286157c] user: drh branch: forum-v2, size: 74472)
19:14
[f31cfef6] part of check-in [8a28a37c] 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. (check-in: [8a28a37c] user: drh branch: forum-v2, size: 74472)
2018-07-24
13:30
[7370eaee] part of check-in [d8b20a55] 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. (check-in: [d8b20a55] user: drh branch: forum-v2, size: 73678)
2018-07-19
17:22
[3e9d921b] part of check-in [ada7ecde] 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. (check-in: [ada7ecde] user: drh branch: trunk, size: 73652)
2018-07-18
16:43
[b3726dd2] part of check-in [86b43a46] Add the backoffice module for doing post-processing actions such as sending alerts and/or syncing repositories. (check-in: [86b43a46] user: drh branch: backoffice, size: 74007)
01:40
[c5bd49b0] part of check-in [38165f37] Add the --logdir option to the "fossil pop3d" command. Fix some issues with POP3 reply formatting. (check-in: [38165f37] user: drh branch: trunk, size: 74419)
2018-07-17
18:32
[b6d4f9ef] part of check-in [f880aa82] Improved tracing capabilities for email notifications. Add the SelectAll button to the webmail display. (check-in: [f880aa82] user: drh branch: trunk, size: 74766)
15:32
[c704f925] part of check-in [0f6a5ee1] 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. (check-in: [0f6a5ee1] user: drh branch: trunk, size: 74034)
15:07
[5fdc2b84] part of check-in [308f4065] Show the email notification status at the top of the /setup_notification page. (check-in: [308f4065] user: drh branch: webmail, size: 74032)
13:54
[8ba5291a] part of check-in [94da0fb2] 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. (check-in: [94da0fb2] user: drh branch: webmail, size: 73844)
2018-07-16
13:33
[5117b93a] part of check-in [0cb83dec] Initialize variable to quell compiler warning about potentially unitialized variable. (check-in: [0cb83dec] user: andybradford branch: trunk, size: 73890)
2018-07-14
00:54
[47e5531c] part of check-in [6e6e3c8b] Do not allow people to subscribe to notifications for which they do not have read permission. (check-in: [6e6e3c8b] user: drh branch: trunk, size: 73888)
2018-07-13
16:26
[35444dc4] part of check-in [43336f67] When logging transaction errors on the error log, try to include information about where the transaction started. (check-in: [43336f67] user: drh branch: trunk, size: 73059)
2018-07-12
15:19
[ebec452e] part of check-in [9c388035] For new subscribers, default all alert options to "on". (check-in: [9c388035] user: drh branch: trunk, size: 72995)
14:29
[593d4887] part of check-in [83b12c3a] Update the documentation on the email-send-method setting. (check-in: [83b12c3a] user: drh branch: trunk, size: 72614)
2018-07-11
20:37
[f213321b] part of check-in [9830d7cb] Rename the /msgtoadmin page to /contact_admin. Improvements to the setup pages for notifications. (check-in: [9830d7cb] user: drh branch: trunk, size: 72492)
19:41
[a01a3f65] part of check-in [aa80d694] Add a setup menu option for Email-Server. Try to get the build of this branch working (without DNS support) for non-linux systems. (check-in: [aa80d694] user: drh branch: smtp, size: 71991)
2018-06-30
18:29
[d4768373] part of check-in [006cc814] 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. (check-in: [006cc814] user: drh branch: smtp, size: 71963)
17:27
[c21d6cb4] part of check-in [b96415f0] Add "SMTP relay" as a new method for sending alert emails. (check-in: [b96415f0] user: drh branch: smtp, size: 71080)
16:06
[048ec920] part of check-in [4f30802a] Merge fixes and improvements from trunk. (check-in: [4f30802a] user: drh branch: smtp, size: 66028)
15:40
[2d796338] part of check-in [50daa540] Fix harmless compiler warnings. (check-in: [50daa540] user: drh branch: trunk, size: 65991)
15:37
[364511bb] part of check-in [429ae9b7] Improve the conformance to rfc2822 for generated email messages. (check-in: [429ae9b7] user: drh branch: trunk, size: 65988)
2018-06-29
19:54
[4933af45] part of check-in [e4144ced] The "fossil smtpd" command stores incoming messages in the database and routes them according to the emailroute table. (check-in: [e4144ced] user: drh branch: smtp, size: 65413)
12:56
[393258fd] part of check-in [c670925e] Attempt to make an error log entry following a segfault. (check-in: [c670925e] user: drh branch: trunk, size: 65376)
2018-06-28
17:22
[e22a4e89] part of check-in [dfe0cf7e] Fix the wording on the documentation of the /announce web page. (check-in: [dfe0cf7e] user: drh branch: trunk, size: 65355)
2018-06-27
17:02
[b7770b56] part of check-in [c1bce3f5] Fix typo in the manpage for the /announce page. (check-in: [c1bce3f5] user: drh branch: trunk, size: 65372)
2018-06-26
11:54
[ccd81059] part of check-in [6a7d2ad8] Fix compiler warnings on windows. Fix the file_directory_size() function so that it works on windows. (check-in: [6a7d2ad8] user: drh branch: trunk, size: 65375)
02:26
[debad2e7] part of check-in [122905c2] 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:". (check-in: [122905c2] user: drh branch: trunk, size: 65405)
02:01
[924ab84f] part of check-in [b6a13c45] Change the email transfer encoding to quoted-printable. (check-in: [b6a13c45] user: drh branch: trunk, size: 65395)
01:24
[f32c77cc] part of check-in [65f57546] Initial implementation of the /announce webpage. (check-in: [65f57546] user: drh branch: trunk, size: 64445)
2018-06-25
20:56
[c63b3d8f] part of check-in [4ef59090] Report on the email notification setup and status in the /stat page for administrators. (check-in: [4ef59090] user: drh branch: trunk, size: 59942)
18:13
[a59b14d9] part of check-in [9040de46] 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. (check-in: [9040de46] user: drh branch: trunk, size: 59949)
16:19
[bc330ec4] part of check-in [69d332ff] Fix harmless compiler warnings. Also remove the "ago" text from the "Last Change" column in the subscriber list webpage. (check-in: [69d332ff] user: drh branch: trunk, size: 59825)
14:45
[9144c9d0] part of check-in [b7b877ef] Enhancements to administrator access to the subscriber list. (check-in: [b7b877ef] user: drh branch: trunk, size: 59839)
13:32
[44026b34] part of check-in [b9121b47] Make sure emailerShutdown() correctly closes the emailqueue database. (check-in: [b9121b47] user: drh branch: trunk, size: 58988)
2018-06-24
17:44
[4bce232f] part of check-in [f87fb027] 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. (check-in: [f87fb027] user: drh branch: trunk, size: 58987)
16:38
[04043c7a] part of check-in [f3de8b66] Enhance the --sqltrace logic. Using those enhancements, locate and fix and unclosed transaction in the email alert sender logic. (check-in: [f3de8b66] user: drh branch: trunk, size: 58876)
10:07
[9d3989d2] part of check-in [0398e41a] Fix an SQL syntax error. (check-in: [0398e41a] user: drh branch: trunk, size: 58545)
2018-06-23
20:11
[be30097c] part of check-in [08165ad4] Fix typos and update documentation. (check-in: [08165ad4] user: drh branch: trunk, size: 58546)
19:55
[8da0ceef] part of check-in [15910589] Do not require Email-Notify permission to operate the /alerts page with a valid subscriberCode. (check-in: [15910589] user: drh branch: trunk, size: 58544)
19:51
[06e04804] part of check-in [43532cd1] Fix the use of captchas on the /msgadmin page. (check-in: [43532cd1] user: drh branch: trunk, size: 58619)
19:36
[89621c1b] part of check-in [0c4d3c12] Add the /msgadmin page. (check-in: [0c4d3c12] user: drh branch: trunk, size: 58591)
18:44
[c34e733c] part of check-in [d4e9df17] Automatically send alert emails after each webpage request. (check-in: [d4e9df17] user: drh branch: trunk, size: 55703)
17:07
[214ab302] part of check-in [98d2338a] Webpages function (with an sensible error) if the email notification tables are not in the schema. (check-in: [98d2338a] user: drh branch: trunk, size: 54610)
16:44
[25970ebe] part of check-in [9cf915d4] Improved documentation. No substantive code changes. (check-in: [9cf915d4] user: drh branch: trunk, size: 53503)
14:24
[64b92216] part of check-in [b4218987] 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. (check-in: [b4218987] user: drh branch: trunk, size: 52663)
01:33
[c4b30fd0] part of check-in [2c3b9030] Futher corrections to the email alert trigger. (check-in: [2c3b9030] user: drh branch: trunk, size: 50092)
01:26
[bb5c6a20] part of check-in [d7ccfb64] Fix minor problems with email notification. (check-in: [d7ccfb64] user: drh branch: trunk, size: 50127)
01:24
[c025d1cb] part of check-in [1cdf6f20] Fix minor problems in email notification. (check-in: [1cdf6f20] user: drh branch: trunk, size: 50133)
00:49
[2aa79546] part of check-in [c2566260] Fix some minor problems with email notification support (check-in: [c2566260] user: drh branch: email-alerts, size: 49976)
2018-06-22
19:48
[dbed54b1] part of check-in [e649820b] Improvements to on-line subscription management. (check-in: [e649820b] user: drh branch: email-alerts, size: 49983)
19:03
[043d6457] part of check-in [ba60f874] Add the "fossil email subscribers" and "fossil email unsubscribe" commands. (check-in: [ba60f874] user: drh branch: email-alerts, size: 48743)
18:23
[da2335b6] part of check-in [44f9f355] Alert sending logic compiles but is so far untested. (check-in: [44f9f355] user: drh branch: email-alerts, size: 46461)
17:36
[0de80cf9] part of check-in [6c06b1c8] A new way of computing alert text. (check-in: [6c06b1c8] user: drh branch: email-alerts, size: 43591)
15:57
[9f74476c] part of check-in [e0289252] Generate event report in chronological order for an alert text. (check-in: [e0289252] user: drh branch: email-alerts, size: 42779)
15:34
[2cce7cc1] part of check-in [bb30d02e] Add logic to generate the text of email alert messages. (check-in: [bb30d02e] user: drh branch: email-alerts, size: 42625)
12:25
[65351405] part of check-in [b7003483] Make sure the content of outbound email messages always ends with a newline. (check-in: [b7003483] user: drh branch: email-alerts, size: 38247)
03:17
[e3cc67d6] part of check-in [f9116088] Add the /unsubscribe page. (check-in: [f9116088] user: drh branch: email-alerts, size: 38141)
01:28
[7e20f79d] part of check-in [5fde17bb] Fix harmless compiler warnings. (check-in: [5fde17bb] user: drh branch: email-alerts, size: 33219)
01:18
[e07c7af4] part of check-in [8c4b92ad] 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. (check-in: [8c4b92ad] user: drh branch: email-alerts, size: 33399)
2018-06-21
23:01
[6d485164] part of check-in [775e529b] 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. (check-in: [775e529b] user: drh branch: email-alerts, size: 32351)
22:37
[4243ff5a] part of check-in [84d0d853] Continuing refinement of the web pages for handling email subscriptions. (check-in: [84d0d853] user: drh branch: email-alerts, size: 30309)
21:02
[9c99a138] part of check-in [e015c103] Add the /subscribers page. Fix minor issues. All pages still need improvement. (check-in: [e015c103] user: drh branch: email-alerts, size: 29465)
19:51
[4edf72b5] part of check-in [adf068fa] Further progress toward get email subscription webpages working. (check-in: [adf068fa] user: drh branch: email-alerts, size: 28448)
19:10
[bb5c71dd] part of check-in [31be2e17] The /subscribe page now creates entries in the subscriber table and sends verification emails. (check-in: [31be2e17] user: drh branch: email-alerts, size: 27028)
15:19
[0cb04b40] part of check-in [ef2426dc] Merge the popen() on windows fix from trunk. (check-in: [ef2426dc] user: drh branch: email-alerts, size: 22145)
15:02
[5c432ead] part of check-in [565b5ff0] Provide an implementation for popen() and pclose() on Windows to fix the build. (check-in: [565b5ff0] user: drh branch: trunk, size: 18101)
12:34
[2cc28638] part of check-in [e91143e8] Non-working code for the /subscribe and /alerts web pages. This is an incremental check-in. (check-in: [e91143e8] user: drh branch: email-alerts, size: 22024)
2018-06-20
22:39
[e85da464] part of check-in [fb3934ec] First attempt at a /subscribe page. Non-functional display only. (check-in: [fb3934ec] user: drh branch: trunk, size: 17980)
19:56
[92394276] part of check-in [fa83e4b3] Manage the email.c file. Accidentally omitted from the previous three check-ins. Bummer. (check-in: [fa83e4b3] user: drh branch: trunk, size: 16722) Added