I am trying to send an email from the server with an attachment using the system stored procedures xp_startsmtp and xp_sendmail.
This works when Test.txt is under a certain length like this:
This is either 44 characters or 49 characters depending on whether you count the new lines as characters.
Add one character to the above though to make either 45 or 50 respectively like this:
and the message does not go through.
On a single line this works at 54 characters:
but this fails at 55
Using a packet sniffer I can see the SMTP conversation and the server is responding with this:
Response: 451 see http://pobox.com/~djb/docs/smtplf.html
The website basically says that some mailers put LF at the end of lines (specifically mentioning the mailer "sendmail v8" doing this with long lines) instead of CR LF and that causes problems down the line.
The xp_sendmail procedure calls another procedure that calls a .dll, which I assume packages and sends the message with the attachment. Because it uses the .dll I do not think I can adjust the output manually by adding some CR 's somewhere.
So, is this a bug? Should I handle this differently?
Our base64 encoding did not conform exactly to the MIME standard. Most mail servers are flexible enough to accept it anyway, but the mail server Matt is using is very strict about it and will not accept our encoded data.
This is fixed in 10.0.1.4131, 184.108.40.2065, and 220.127.116.1194.
...and let us know if that helped.