CorpTime violates MIME encoding - Calendar(Archived)

The email reminders are not decodable by all email clients due to "corporate time" not complying to RFC822 and RFC2046.
<raw_message>
Return-Path: [...snip...]
X-Sieve: cmu-sieve 2.0
Received: from [...snip...] (8.11.0/8.11.0) with ESMTP id h3EIQri20681;
Mon, 14 Apr 2003 11:26:53 -0700 (PDT)
Received: [...snip...] (8.11.6/8.11.6) with ESMTP id h3EIQra07258;
Mon, 14 Apr 2003 11:26:53 -0700 (PDT)
Received: (from unison#localhost)
by [...snip...] (8.9.3+Sun/8.9.1) id LAA25199;
Mon, 14 Apr 2003 11:26:52 -0700 (PDT)
Message-Id: <200304141826.LAA25199#[...snip...].com>
To: [...snip list of people...]
From: [...snip...]
Date: Mon, 14 Apr 2003 11:26:52 -0700
Reply-To: [...snip...]
Subject: =?ISO-8859-1?B?U2hhcnAgS2l0dHkyIElzc3VlIE1lZXRpbmc=?=
MIME-Version: 1.0
Content-Type: multipart/mixed;
boundary=--Boundaryyy-908723--651209-MIME##00-CST--
 
This message contains MIME formatting. Your mail client does not support it.
 
----Boundaryyy-908723--651209-MIME##00-CST--
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: base64
 
U2Ftc3Vu[... snip rest of encoded stuff, so that I won't get fired ...]QoNCg==
 
----Boundaryyy-908723--651209-MIME##00-CST----
 
</raw_message>
 
Content-Type: multipart/mixed;
boundary=--Boundaryyy-908723--651209-MIME##00-CST-- 
"#" is not an allowed character in Multipart boundaries.
 
Ref RFC 2046 sec. 5.1.1 (http://www.ietf.org/rfc/rfc2046.txt ):
 
boundary := 0*69<bchars> bcharsnospace
 
bchars := bcharsnospace / " "
 
bcharsnospace := DIGIT / ALPHA / "'" / "(" / ")" /
"+" / "_" / "," / "-" / "." /
"/" / ":" / "=" / "?"
Ref RFC 822 sec. 3.3
(http://www.ietf.org/rfc/rfc822.txt ):
ALPHA = <any ASCII alphabetic character>
; (101-132, 65.- 90.)
; (141-172, 97.-122.)
DIGIT = <any ASCII decimal digit> ; ( 60- 71, 48.- 57.)
--
jpa

Bonjour,
Could you please submit this to the Technical Support Team by submitting a TAR at: http://metalink.oracle.com.
Please make sure to specify the version of the Calendar client you are using, as well as the version of the Calendar server and the e-mail client that you are using.
Thank you,
Manon Delisle

Related

HTMLDB_MAIL.SEND  Problems with 1.6 + Patch

I have been having some problems with HTMLDB_MAIL.SEND when trying to send HTML messages. I am using the latest verion of HTMLDB 1.6 along with the recent patch.
Test case
declare
l_buffer varchar2(500);
l_text varchar2(500);
begin
                              
l_text := 'This is some text';                                   
l_buffer := '<html><body>This is a <b>TEST</b>.</body></html>';
htmldb_mail.send( p_to => 'xxxxxxxxxx#gmail.com', p_from => 'xxxxxxxxxx#gmail.com',
     p_body => l_text, p_body_html => l_buffer, p_subj => 'New user request 2' );
     htmldb_mail.push_queue( 'localhost', '25');
     
end;     
I receive the mail message, however, it is not displayed properly. Below is how I see the message in my email client. (all text). Is there a workaround or at least a patch for the wwv_flow_mail package?
--------=1T02D27M75MU981T02D27M75MU98
This message generated by the HTML DB Mail Package.
--------=1T02D27M75MU981T02D27M75MU98
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
This is some text
--------=1T02D27M75MU981T02D27M75MU98
Content-Type: text/html;
<html><body>This is a <b>TEST</b>.</body></html>
--------=1T02D27M75MU981T02D27M75MU98--
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.6.4 - Release Date: 07/03/2005
Thanks,
Scott. 
Scott,
I tried your exact example and viewed with my Outlook client as well as with my gmail account, everything looks hunky dory.
What client are you using?
Joel 
Hi Joel,
That is strange. I was using Outlook express when I sent the message to hotmail. Otherwise I would use the web front end to my gmail account. Neither showed the HTML version of the message.
Can you post the entire message from your gmail account. I will compare it to what my gmail produces. ( under options select show original ) This is what I get.
X-Gmail-Received: 082d14a96264cad4f80173422c3f47086aa651ce
Delivered-To: xxxxxx#gmail.com
Received: by 10.54.46.6 with SMTP id t6cs8227wrt;
Tue, 8 Mar 2005 14:15:08 -0800 (PST)
Received: by 10.38.90.51 with SMTP id n51mr219301rnb;
Tue, 08 Mar 2005 14:15:08 -0800 (PST)
Return-Path: <xxxxxx#gmail.com>
Received: from relais.videotron.ca (relais.videotron.ca [24.201.245.36])
by mx.gmail.com with ESMTP id 74si50026rnb.2005.03.08.14.15.07;
Tue, 08 Mar 2005 14:15:07 -0800 (PST)
Received-SPF: neutral (gmail.com: 24.201.245.36 is neither permitted nor denied by domain of xxxxxx#gmail.com)
Received: from relais.videotron.ca ([24.37.232.35])
by VL-MO-MR011.ip.videotron.ca
(iPlanet Messaging Server 5.2 HotFix 1.21 (built Sep 8 2003))
with ESMTP id <0ID2000UI0FLUU#VL-MO-MR011.ip.videotron.ca> for
xxxxxx#gmail.com; Tue, 08 Mar 2005 17:14:10 -0500 (EST)
Received: from 127.0.0.1 (AVG SMTP 7.0.308 [266.6.4]); Tue,
08 Mar 2005 17:14:46 -0500
Date: Tue, 08 Mar 2005 17:14:09 -0500 (EST)
Date-warning: Date header was inserted by VL-MO-MR011.ip.videotron.ca
From: xxxxxx#gmail.com
Subject: New user request 2
To: xxxxxx#gmail.com
Reply-to: xxxxxx#gmail.com
Message-id: <0ID2000UJ0FLUU#VL-MO-MR011.ip.videotron.ca>
Content-transfer-encoding: 7BIT
-----=1T02D27M75MU981T02D27M75MU98
This message generated by the HTML DB Mail Package.
-----=1T02D27M75MU981T02D27M75MU98
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
This is some tex
-----=1T02D27M75MU981T02D27M75MU98
Content-Type: text/html;
<html><body>This is a <b>TEST</b>.</body></html>
-----=1T02D27M75MU981T02D27M75MU98--
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.6.4 - Release Date: 07/03/2005
Thanks,
Scott.
I found out what was happening.
I am running a virus program call AVG Free Edition. This program appends a banner to each email scanned.
The banner is
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.6.4 - Release Date: 07/03/2005
However when I configure the utility to disable scanning outgoing messages I got my HTML message as expected.
If anyone knows why this banner is causing me problems and what I might try to get around it aside from disabling my email scanner I would appreciate it.
thanks,
Scott.
Hi Scott
i'm also developing an application from which i want to send mail.. but whenever i send a mail from my application the mail is stored in the htmldb mail queue..
how can i configure my installation and overcome this problem
Shijo 
Htmldb always stores the message in a queue. At some point you would call
htmldb_mail.push_queue( 'localhost', '25');
with the address of your smtp server and the port it is listening on. You might want to call this every 10 Minutes or so depending on your application (dbms_job or use the scheduler to run this in the background). I have included this call after my call to htmldb_mail.send so that the mail is sent immediately.
Hope that helps.

iisproxy header question

We're looking at the HTTP traces of connections through the IISProxy and direct and finding a duplicate date header on proxied requests.
Has anyone else noticed this? The problem we are trying to solve is intermittent failures at a client company that uses a transparent proxy/filter device. The only difference in the traces is this extra header field.
Here's an example:
HTTP/1.1 200 OK
Date: Tue, 20 Sep 2005 18:30:55 GMT
Date: Tue, 20 Sep 2005 18:30:56 GMT <----------------
X-Powered-By: ASP.NET
Content-Length: 4839
Content-Type: text/html
Expires: Mon, 01 Jan 1990 05:00:00 GMT
Cache-control: private

Oracle XML DB server charset

Hi, how do I change a Oracle XML DB (embedded gateway) server's charset and make it e.g. UFT-8?
Thanks,
Art
Edited by: ArtS on Apr 21, 2011 11:27 AM 
ArtS wrote:
Hi, how do I change a Oracle XML DB (embedded gateway) server's charset and make it e.g. UFT-8?
Thanks,
Art
Edited by: ArtS on Apr 21, 2011 11:27 AMIsn't it enough to add required meta-data to change the charset?
As I know, APEX already puts the following code to the header of your page:
<meta http-equiv="Content-Type" content="text/html;charset=utf-8" > 
No, it's not. Here is what a google boot sees.
HTTP/1.1 302 Found
Date: Tue, 18 Jan 2011 15:48:40 GMT
Server: Oracle XML DB/Oracle Database
Location: http://xxxxxxxxxxxxxxxxxxxxxx
Vary: Accept-Encoding,User-Agent
Content-Encoding: gzip
Content-Length: 20
Keep-Alive: timeout=2, max=500
Connection: Keep-Alive
Content-Type: text/plain; charset=ISO-8859-2 
ArtS wrote:
No, it's not. Here is what a google boot sees.
HTTP/1.1 302 Found
Date: Tue, 18 Jan 2011 15:48:40 GMT
Server: Oracle XML DB/Oracle Database
Location: http://xxxxxxxxxxxxxxxxxxxxxx
Vary: Accept-Encoding,User-Agent
Content-Encoding: gzip
Content-Length: 20
Keep-Alive: timeout=2, max=500
Connection: Keep-Alive
Content-Type: text/plain; charset=ISO-8859-2As I see it's a 302 page (redirection)
Could you also test a valid apex page? Here's the one from a sample page hosted at apex.oracle.com:
HTTP/1.1 200 OK
Date: Fri, 22 Apr 2011 20:14:22 GMT
Server: Oracle-Application-Server-11g
Connection: close
Content-Type: text/html; charset=UTF-8
Content-Language: en
Set-Cookie: BIGipServerapex-ext_oracle_com_http=XXXXXXXXXXXXXXXXXX; path=/
and here's a forward (302) page on same server:
HTTP/1.1 302 Found
Date: Fri, 22 Apr 2011 20:17:03 GMT
Server: Oracle-Application-Server-11g
Location: f?p=XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Content-Length: 0
Connection: close
Content-Type: text/plain
Content-Language: en
Set-Cookie: BIGipServerapex-ext_oracle_com_http=XXXXXXXXXXXXXXX; path=/
I got this one (one same server and for same page when I tried to trace):
HTTP/1.1 405 Method Not Allowed
Date: Fri, 22 Apr 2011 20:20:55 GMT
Server: Oracle-Application-Server-11g
Allow:
Content-Length: 253
Connection: close
Content-Type: text/html; charset=iso-8859-1
Set-Cookie: BIGipServerapex-ext_oracle_com_http=XXXXXXXXXXXXXXXX; path=/
So as I see, it sends "charset=iso-8859-1" on error pages, "none" on forwarding, "utf-8" for real pages. In fact, APEX 4 already publishes pages in utf-8 charset. Here's nother apex web site:
HTTP/1.1 200 OK
Date: Fri, 22 Apr 2011 18:01:56 GMT
Server: Oracle XML DB/Oracle Database
Content-Type: text/html; charset=UTF-8
Content-Length: 54491
Connection: close
And here's a brief explanation about meta Content-Type:
A known misconception about <meta http-equiv="Content-Type"> is that this attribute of meta element is intended to be interpreted directly by a browser, like an ordinary HTML tag. According to WWW Consortium, it helps the HTTP server to generate corresponding headers when it serves the document. The HTTP/1.1 header specification for a HTML document must label an appropriate encoding in the Content-Type header, missing charset= parameter results in acceptance of ISO-8859-1 (so HTTP/1.1 formally does not offer such option as an unspecified character encoding), and this specification supersedes all HTML (or XHTML) meta element ones. This can pose a problem if the server generates an incorrect header and one does not have the access or the knowledge to change them.
I hope it helps!
Best Regards,
Gokhan
-------------------------------------------------------
If this question is answered, please mark appropriate posts as correct/helpful and the thread as closed. Thanks 
I had to change a charset in the apache config file. 
Yes, it is a redirect because apache is running on port 80. I could not configure apex so my page could be accessed by typing mywebsite.com url in a borwser. I found out a charset was set up in the apache config file. 
ArtS wrote:
I had to change a charset in the apache config file.You should use "AddDefaultCharset UTF-8" parameter to apache charset configuration file:
http://httpd.apache.org/docs/1.3/mod/core.html#adddefaultcharset
Configuration file can be located in different folders according to your linux/unix/windows server.
/etc/httpd/conf/httpd.conf or /etc/apache2/conf.d/charset etc...
Important note from Apache document:
This will not have any effect on the Content-Type and character set for default Apache-generated status pages (such as '404 Not Found', '301 Moved Permanently', '302' etc...) because those have an actual character set (that in which the hard-coded page content is written) and don't need to have a default applied.

BUG APEX_MAIL "Date: " missed

Hi
I'm not sure but probably APEX_MAIL API doesn't create "Date" parameter in message header. If I send mail outside company, many mails are stamped as SPAM (Outlook set null in Send filed) : (. Is it some workarund to this issue ?
Regards 
many mails are stamped as SPAMI don't think apex_mail is the cause. It's usually a combination of the From, Subject and Body fields.
Outlook set null in Send filedHmm, not for me. I can see the Sent field. The message source shows a Date:
Date: 28 Dec 2011 15:28:14 -0400
This message generated by Oracle Application Express. 
Hmm, not for me. I can see the Sent field. The message source shows a Date:
Date: 28 Dec 2011 15:28:14 -0400
This message generated by Oracle Application Express.Hmmmmm my source look:
Return-Path: <xxx#domain.pl>
Delivered-To: xxx#s26-mx.ogicom.net
Received: from localhost (localhost.localdomain [127.0.0.1])
     by s26-mx.ogicom.net (Postfix) with ESMTP id 4AFFF13AEDD3
     for <xxx#domain.pl>; Wed, 28 Dec 2011 17:15:50 +0100 (CET)
X-Virus-Scanned: Debian amavisd-new at s26-mail.ogicom.net
Received: from s26-mx.ogicom.net ([93.157.100.45])
     by localhost (s26-mail.ogicom.net [127.0.0.1]) (amavisd-new, port 10028)
     with ESMTP id TEgITM-plr09 for <xxx#domain.pl>;
     Wed, 28 Dec 2011 17:15:50 +0100 (CET)
Received: from s26-mail.ogicom.net (s26-mail.ogicom.net [93.157.100.44])
     by s26-mx.ogicom.net (Postfix) with ESMTP id 394B313AFA0D
     for <xxx#domain.pl>; Wed, 28 Dec 2011 17:15:50 +0100 (CET)
Received: from s26-mail.ogicom.net (localhost.localdomain [127.0.0.1])
     by s26-mail.ogicom.net (Postfix) with ESMTP id 2D02D13AEDD3
     for <xxx#domain.pl>; Wed, 28 Dec 2011 17:15:50 +0100 (CET)
Received: from 93.157.100.44 (somename.internetdsl.tpnet.pl [83.83.83.83])
     (Authenticated sender: user_name)
     by s26-mail.ogicom.net (Postfix) with ESMTPA id D26D413AFA0D
     for <xxx#domain.pl>; Wed, 28 Dec 2011 17:15:49 +0100 (CET)
To: mail#domain.pl
From: Some name <other_mail#domain.pl>
Subject:
Reply-To:
Content-Type: text/plain; charset=utf-8
X-AVK-Virus-Check: AVA 21.4505;F1206
X-Virus-Scanned: ClamAV using ClamSMTP
X-Antivirus: avast! (VPS 111228-0, 2011-12-28), Inbound message
X-Antivirus-Status: CleanNo "Date:"
I send mail via APEX_MAIL API (APEX 4.1) from my PLSQL package. 
I created my email in 4.0.2. I have no 4.1 to test.
Update: I was able to test it on apex.oracle.com and date was added. I don't know which process adds all the header info. I don't think it's Apex or the underlying utl_smtp package. Maybe the smpt server?
This message was not marked as Spam by gmail, which has a very good spam filter.
Date: Wed, 28 Dec 2011 14:12:35 -0600
Message-Id: <201112282012.pBSKCZVw023271#aapexdb03.us.oracle.com>Edited by: InoL on Dec 28, 2011 3:13 PM 
Thank you for help.
I found problem.
If you use API:
APEX_MAIL.SEND_MAIL next you have to make COMMIT (for example from SQL Developer) and next you can call APEX_MAIL.PUSH_QUEUE
If you forget commit your mail will out without send date.
In my opinion it's low level APEX bug : )

Invalid Header in Response

Hi,
I had upgraded Oracle Web Cache in 2.0.0.4. When I try to access to my site, I have the following error :
03/Jul/2002:15:17:40 +0200 -- Warning: Response Headers creation error: 3-Return status missing
HTTP/1.1 200^M
Server: Microsoft-IIS/5.0^M
Date: Wed, 03 Jul 2002 22:22:32 GMT^M
Connection: keep-alive^M
Date: Wed, 03 Jul 2002 13:19:51 GMT^M
Pragma: no-cache^M
Server: WebLogic WebLogic Server 6.1 SP2 12/18/2001 11:13:46 #154529^M
Content-Length: 4079^M
Content-Type: text/html^M
Expires: Mon, 01 Jan 1990 12:00:00 GMT^M
Set-Cookie: JSESSIONID=9i53zfaByf67h7ucoD1zL3VG7jp0CoACupGWpcbdhy15nTVWawpL!-212520747!-1062704627!7001!7002; path=/^M
Cache-Control: no-cache^M
^M
03/Jul/2002:15:17:40 +0200 -- Warning: Origin Server module got an ABORT; OS Err: 10 - create header fail URI: /wlb/en_GB/userIdent.htm^M
03/Jul/2002:15:17:40 +0200 -- Warning: Header creation error: Invalid Header in Response.^M
What might be going wrong ? What header is invalid ?
Thanks. 
The reason this is happening is that Web Cache expects
the backend to send us a "Reason-Phrase" back.
i.e. something like this:
HTTP/1.1 200 OK
The "OK" is missing in the response you provided, and in the 2.0.0.x release we
say that this is an error.
This bug has already been fixed in release 9.0.2
as bug 2072671. We handle these responses more gracefully now.
Nevertheless, we have created a new bug for 2.0.0.x in order to backport the fix -- 2453945. 
The reason this is happening is that Web Cache expects
the backend to send us a "Reason-Phrase" back.
i.e. something like this:
HTTP/1.1 200 OK
The "OK" is missing in the response you provided, and in the 2.0.0.x release this is treated as an error.
This bug has already been fixed in 9.0.2 release as bug 2072671. Responses like this are handled more gracefully.
That said, we have gone ahead and created a backport request for the 2.0.0.x code line. The new bug for 2.0.0.x is 2453945.
This is a test message. Pls ignore.

Categories

Resources