How does one go about adding LDAP functionality for authentication to
dbmail.
I saw some posts that mentioned it, but I am not really clear on how to
do this.
Also, am interested in more info re plans to add Exchange functionality
to dbmail.
Are the plans to write an RPC server that acts the same as exchange, or
a mapi service
provider.
regards
Jason Bateman
-----Original Message-----
From: [EMAIL PROTECTED]
Sent: Thu 30/01/2003 10:00 PM
To: [email protected]
Cc:
Subject: Dbmail digest, Vol 1 #473 - 3 msgs
Send Dbmail mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://mailman.fastxs.nl/mailman/listinfo/dbmail
or, via email, send a message with subject or body 'help' to
[EMAIL PROTECTED]
You can reach the person managing the list at
[EMAIL PROTECTED]
When replying, please edit your Subject line so it is more
specific
than "Re: Contents of Dbmail digest..."
Today's Topics:
1. New db_insert_message with auto-mailbox creation (Aaron
Stone)
2. Fwd: Mulberry Support Request (Eelco van Beek - IC&S)
3. Re: Mulberry Support Request (Joel M. Baldwin)
--__--__--
Message: 1
Date: Wed, 29 Jan 2003 10:44:34 -0800 (PST)
From: Aaron Stone <[EMAIL PROTECTED]>
To: [email protected]
Subject: [Dbmail] New db_insert_message with auto-mailbox
creation
Reply-To: [email protected]
Because users authenticated with an external auth mechanism are
not very
likely to have an INBOX created for them... and because INBOX,
as a
hard-coded feature of the IMAP specification, must exist, here's
a new
db_insert_message function which calls db_createmailbox if
needed:
Aaron
/*
* inserts into inbox !
*/
u64_t db_insert_message (u64_t useridnr, const char
*deliver_to_mailbox,
const char *uniqueid)
{
char timestr[30];
time_t td;
struct tm tm;
u64_t mailboxid;
time(&td); /* get time */
tm = *localtime(&td); /* get components */
strftime(timestr, sizeof(timestr), "%G-%m-%d %H:%M:%S", &tm);
/* if there isn't a mailbox specified, default to INBOX */
mailboxid = db_get_mailboxid( useridnr, ( deliver_to_mailbox ?
deliver_to_mailbox : "INBOX" ) );
/* check to see if the desired mailbox exists */
if( mailboxid == 0 )
{
/* see if we're configured to automatically create
mailboxes */
if( 1 )
{
trace( TRACE_DEBUG, "db_insert_message(): creating
mailbox as it does not exist" );
if( db_createmailbox( ( deliver_to_mailbox ?
deliver_to_mailbox : "INBOX" ), useridnr ) != 0 )
{
return -1;
}
else
{
/* if only db_create_mailbox returned the
mailboxid... */
mailboxid = db_get_mailboxid( useridnr, (
deliver_to_mailbox ? deliver_to_mailbox : "INBOX" ) );
}
}
else
{
trace( TRACE_ERROR, "db_insert_message(): mailbox does
not exist, failing" );
return -1;
}
}
snprintf (query, DEF_QUERYSIZE,"INSERT INTO
messages(mailbox_idnr,messagesize,unique_id,"
"internal_date,recent_flag,status)"
" VALUES (%llu, 0, \"%s\", \"%s\", 1, '005')",
mailboxid, uniqueid ? uniqueid : "", timestr);
if (db_query (query)==-1)
{
trace(TRACE_STOP,"db_insert_message(): dbquery failed");
}
return db_insert_result("");
}
--__--__--
Message: 2
Date: Wed, 29 Jan 2003 23:12:10 +0100
Cc: [email protected]
To: Roel Rozendaal <[EMAIL PROTECTED]>
From: Eelco van Beek - IC&S <[EMAIL PROTECTED]>
Subject: [Dbmail] Fwd: Mulberry Support Request
Reply-To: [email protected]
Something to fix :)
Begin forwarded message:
> From: Mulberry Support <[EMAIL PROTECTED]>
> Date: woe jan 29, 2003 21:24:19 Europe/Amsterdam
> To: "Joel M. Baldwin" <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED], [email protected]
> Subject: Re: Mulberry Support Request
>
> Hi Joel,
>
> --On Tuesday, January 28, 2003 07:04:09 PM -0800 "Joel M.
Baldwin"
> <[EMAIL PROTECTED]> wrote:
>
> | Mulberry is closing the mailbox because of something that it
> | doesn't like when a FETCH command is issued. I don't know
if
> | this is a problem with dbmail ( likely ), or Mulberry.
>
> This is a dbmail bug and its a fairly common bug we see in new
IMAP
> servers. From the log:
>
> * 79 FETCH (FLAGS (\Recent) RFC822.SIZE 11427 UID 87074
INTERNALDATE
> "28-Jan-2003 10:34:36" ENVELOPE ("28 Jan 2003 18:34:05 -0000"
> "*****SPAM***** Your credit application has been approved.
113078154"
> ((NIL NIL ""CreditDept."" "mtsbp540.email-deliveries.net"))
((NIL NIL
>
>
> Note that 'CreditDept.' appears inside of a double set of
> double-quotes! That is wrong. If double-quotes are part of the
phrase
> in the email address, then they should appear 'escaped' in the
IMAP
> response:
>
> "\"CreditDept.\""
>
> The server authors need to verify that double-quotes in string
data
> sent by the server are always being 'escaped' in this fashion
as
> required by IMAP. Those can occur in lots of places: examples
include
> email addresses (both the phrase component and the actual
email
> address itself), the subject, MIME parameters etc.
>
> --
> Cyrus Daboo
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Mulberry Support
<mailto:[EMAIL PROTECTED]>
> Cyrusoft International, Inc.
<http://www.cyrusoft.com>
> Voice: +1 412 605 0499 Fax: +1 412
605 0705
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Proud Purveyors of Mulberry: Internet Mail from the Ground
Up
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
_________________________
E.J.A. van Beek
ICT Manager
IC&S
T: +31 30 2322878
F: +31 30 2322305
PGP-key:
www.ic-s.nl/keys/eelco.txt
--__--__--
Message: 3
Date: Thu, 30 Jan 2003 01:26:20 -0800
From: "Joel M. Baldwin" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED], [email protected]
Subject: [Dbmail] Re: Mulberry Support Request
Reply-To: [email protected]
--On Wednesday, January 29, 2003 3:24 PM -0500 Mulberry Support
<[EMAIL PROTECTED]> wrote:
> Hi Joel,
>
> --On Tuesday, January 28, 2003 07:04:09 PM -0800 "Joel M.
Baldwin"
> <[EMAIL PROTECTED]> wrote:
>
>| Mulberry is closing the mailbox because of something that it
>| doesn't like when a FETCH command is issued. I don't know if
>| this is a problem with dbmail ( likely ), or Mulberry.
>
> This is a dbmail bug and its a fairly common bug we see in new
IMAP
> servers. From the log:
>
> * 79 FETCH (FLAGS (\Recent) RFC822.SIZE 11427 UID 87074
INTERNALDATE
> "28-Jan-2003 10:34:36" ENVELOPE ("28 Jan 2003 18:34:05 -0000"
> "*****SPAM***** Your credit application has been approved.
113078154"
> ((NIL NIL ""CreditDept."" "mtsbp540.email-deliveries.net"))
((NIL NIL
>
>
> Note that 'CreditDept.' appears inside of a double set of
> double-quotes! That is wrong. If double-quotes are part of the
phrase
> in the email address, then they should appear 'escaped' in the
IMAP
> response:
Thank you for the prompt response. I've found and fixed this
double-quote problem. ( solution at end of email for those
interested )
However the previous email included 2 examples, and this solves
only
one of them. How about this one?
----------------------------------------------------------------
Mulberry IMAP protocol log
----------
* 99 FETCH (FLAGS (\Seen) RFC822.SIZE 11362 UID 15744
INTERNALDATE
"24-Jan-2003 08:41:49" ENVELOPE ("Fri, 26 Feb 1999 01:27:50
-0600"
"[yosemite] Hi!" (({15}
"David Laville"
NIL "dlaville" "worldnet.att.net")) (({15}
"David Laville"
NIL "dlaville" "worldnet.att.net")) ((NIL NIL "yosemite"
"egroups.com")) ((NIL NIL "yosemite" "egroups.com")) NIL NIL NIL
"<[EMAIL PROTECTED]>") BODYSTRUCTURE (("text"
"plain" ("charset" "iso-8859-1") NIL NIL "quoted-printable" 3877
77 NIL
NIL NIL)("text" "html" ("charset" "iso-8859-1") NIL NIL
"quoted-printable" 5462 171 NIL NIL NIL) "alternative"
("boundary"
"----=_NextPart_000_0015_01BE6127.3986B1A0") NIL NIL))
* 100 FETCH (FLAGS (\Seen) RFC822.SIZE 1624 UID 15745
INTERNALDATE
"24-Jan-2003 08:41:50" ENVELOPE ("Sat, 24 Apr 1999 23:21:52
-0600"
"[Yosemite] Does any one know of any good pet travel sites?"
(({16}
"Mike Edmondton"
NIL "netdir" "ibm.net")) (({16}
"Mike Edmondton"
NIL "netdir" "ibm.net")) ((NIL NIL "Yosemite" "onelist.com"))
(({15}
"New Recipient"
NIL "Yosemite" "onelist.com")) NIL NIL NIL
"<[EMAIL PROTECTED]>") BODYSTRUCTURE ("text"
"plain"
("charset" "US-ASCII") NIL NIL "7bit" 443 12 NIL NIL NIL))
* 101 FETCH (FLAGS (\Seen) RFC822.SIZE 76069 UID 15746
INTERNALDATE
"24-Jan-2003 08:41:52" ENVELOPE ("Sun, 25 Apr 1999 00:02:28
-0700"
"[Yosemite] [Fwd: [NaturePhotoTrips] Endangered Bighorn Sheep]"
(("tdhieger" NIL "tdhieger" "sierra.psnw.com")) (("tdhieger" NIL
"tdhieger" "sierra.psnw.com")) ((NIL NIL "Yosemite"
"onelist.com"))
((NIL NIL "Yosemite" "onelist.com")) NIL NIL NIL
"<[EMAIL PROTECTED]>") BODYSTRUCTURE ("message"
"rfc822" NIL
NIL NIL "7bit" 74682 NIL ("inline" NIL) NIL))
----------
hand typed commands to the dbmail IMAP server
( to see the server response that is causing the trouble )
( is it message 100 or message 101? )
----------
su-2.05b# telnet 0 144
Trying 0.0.0.0...
Connected to 0.
Escape character is '^]'.
* OK dbmail imap (protocol version 4r1) server 0.9 ready to run
a01 login qumqats xxxxxx
a01 OK LOGIN completed
a02 select Yosemite
* 568 EXISTS
* 1 RECENT
* FLAGS (\Seen \Answered \Deleted \Flagged \Draft \Recent )
* OK [PERMANENTFLAGS (\Seen \Answered \Deleted \Flagged \Draft
\Recent
)]
* OK [UIDVALIDITY 14] UID value
* OK [UNSEEN 0] first unseen message
a02 OK [READ-WRITE] SELECT completed
a03 fetch 99:101 ( flags rfc822.size uid internaldate envelope
bodystructure )
* 99 FETCH (FLAGS (\Seen) RFC822.SIZE 11362 UID 15744
INTERNALDATE
"24-Jan-2003 08:41:49" ENVELOPE ("Fri, 26 Feb 1999 01:27:50
-0600"
"[yosemite] Hi!" (({15}
"David Laville" NIL "dlaville" "worldnet.att.net")) (({15}
"David Laville" NIL "dlaville" "worldnet.att.net")) ((NIL NIL
"yosemite" "egroups.com")) ((NIL NIL "yosemite" "egroups.com"))
NIL NIL
NIL "<[EMAIL PROTECTED]>") BODYSTRUCTURE
(("text"
"plain" ("charset" "iso-8859-1") NIL NIL "quoted-printable" 3877
77 NIL
NIL NIL)("text" "html" ("charset" "iso-8859-1") NIL NIL
"quoted-printable" 5462 171 NIL NIL NIL) "alternative"
("boundary"
"----=_NextPart_000_0015_01BE6127.3986B1A0") NIL NIL))
* 100 FETCH (FLAGS (\Seen) RFC822.SIZE 1624 UID 15745
INTERNALDATE
"24-Jan-2003 08:41:50" ENVELOPE ("Sat, 24 Apr 1999 23:21:52
-0600"
"[Yosemite] Does any one know of any good pet travel sites?"
(({16}
"Mike Edmondton" NIL "netdir" "ibm.net")) (({16}
"Mike Edmondton" NIL "netdir" "ibm.net")) ((NIL NIL "Yosemite"
"onelist.com")) (({15}
"New Recipient" NIL "Yosemite" "onelist.com")) NIL NIL NIL
"<[EMAIL PROTECTED]>") BODYSTRUCTURE ("text"
"plain"
("charset" "US-ASCII") NIL NIL "7bit" 443 12 NIL NIL NIL))
* 101 FETCH (FLAGS (\Seen) RFC822.SIZE 76069 UID 15746
INTERNALDATE
"24-Jan-2003 08:41:52" ENVELOPE ("Sun, 25 Apr 1999 00:02:28
-0700"
"[Yosemite] [Fwd: [NaturePhotoTrips] Endangered Bighorn Sheep]"
(("tdhieger" NIL "tdhieger" "sierra.psnw.com")) (("tdhieger" NIL
"tdhieger" "sierra.psnw.com")) ((NIL NIL "Yosemite"
"onelist.com"))
((NIL NIL "Yosemite" "onelist.com")) NIL NIL NIL
"<[EMAIL PROTECTED]>") BODYSTRUCTURE ("message"
"rfc822" NIL
NIL NIL "7bit" 74682 NIL ("inline" NIL) NIL))
a03 OK FETCH completed
a04 logout
* BYE dbmail imap server kisses you goodbye
a04 OK completed
Connection closed by foreign host.
su-2.05b#
----------------------------------------------------------------
> "\"CreditDept.\""
>
> The server authors need to verify that double-quotes in string
data
> sent by the server are always being 'escaped' in this fashion
as
> required by IMAP. Those can occur in lots of places: examples
include
> email addresses (both the phrase component and the actual
email
> address itself), the subject, MIME parameters etc.
>
> --
> Cyrus Daboo
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ~~ Mulberry Support
> <mailto:[EMAIL PROTECTED]> Cyrusoft International, Inc.
> <http://www.cyrusoft.com> Voice: +1 412 605 0499
> Fax: +1 412 605 0705
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ~~ Proud Purveyors of Mulberry: Internet Mail from the
Ground Up
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ~~
>
*** ../dbmail.orig/imaputil.c Mon Dec 9 01:53:09 2002
--- imaputil.c Wed Jan 29 23:46:21 2003
***************
*** 461,467 ****
has_split = 1;
}
else
! fprintf(outstream,"%c",mr->value[i]);
}
if (!has_split)
--- 461,471 ----
has_split = 1;
}
else
! {
! if ( mr->value[i] == '"' )
! fprintf( outstream, "\\" );
! fprintf(outstream,"%c",mr->value[i]);
! }
}
if (!has_split)
--__--__--
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
End of Dbmail Digest
