![]() New, TLSv1/SSLv3, Cipher is DHE-RSA-AES256-SHA SSL handshake has read 4922 bytes and written 351 bytes Issuer=/C=US/O=Thawte, Inc./CN=Thawte SSL CA Subject=/C=AT/ST=Ober\xC3\xB6sterreich/L=Linz/O=A1 Telekom Austria AG/OU=ISP/CN= MIID5jCCAs6gAwIBAgIQHXSLMb2opHvNrSgbp2UMOzANBgkqhkiG9w0BAQUFADA8 MQswCQYDVQQGEwJVUzEVMBMGA1UEChMMVGhhd3RlLCBJbmMuMRYwFAYDVQQDEw1U aGF3dGUgU1NMIENBMB4XDTEyMDQyNjAwMDAwMFoXDTE0MDUyNjIzNTk1OVowfzEL MAkGA1UEBhMCQVQxGDAWBgNVBAgMD09iZXLDtnN0ZXJyZWljaDENMAsGA1UEBwwE TGluejEeMBwGA1UECgwVQTEgVGVsZWtvbSBBdXN0cmlhIEFHMQwwCgYDVQQLDANJ U1AxGTAXBgNVBAMMEGJzbXRwLnRlbGVrb20uYXQwggEiMA0GCSqGSIb3DQEBAQUA A4IBDwAwggEKAoIBAQDfygYXq0RXDfZQ67im/wpDz8VJU8F7lHc9HBvs0keG2XS5 BlWAdGu5fePG8dMh4 dwbEnHgcZBgPtnk2jXUjDnl egU7mvde1XMD0K0mgIBvSY wdn1b2NelYPpi 7EDw ffsAccfAQ0gbxUntaJzDYGH Z2YbvRXLg/dizzq/Aj6cp af圎neVQ2K/0N8圜doF0SPgMUIyjtTGbJUvjbspWvuTdCTrb8iBjdO圆vxj2Mu6E 1moU3kYFpTLrE267dvnGK1TirWVasOmdPhr2Qn7e9y6xLByJPjqclzvrk19SB/i5 GkaWTIsjaKgPEi3H67bgpUGUcZjpwLFDyiAHsJVTAgMBAAGjgaAwgZ0wDAYDVR0T AQH/BAIwADA6BgNVHR8EMzAxMC gLaArhilodHRwOi8vc3ZyLW92LWNybC50aGF3 dGUuY29tL1RoYXd0ZU9WLmNybDAdBgNVHSUEFjAUBggrBgEFBQcDAQYIKwYBBQUH AwIwMgYIKwYBBQUHAQEEJjAkMCIGCCsGAQUFBzABhhZodHRwOi8vb2NzcC50aGF3 dGUuY29tMA0GCSqGSIb3DQEBBQUAA4IBAQAFh5lsfUnEePCnN27OHbZZK6mQ7WVw v6zNw31BcHcJ8COusjhKB6MVwO4圜H9f7txz7JSxtE47IOdDqh/ZTp0GJhkFYOLQ cBCW7yyORXL9dlNzeNw44XukMNatfxWaiFhbegTEbkHnwgWhhA/Iea v1iUTGhm9 0olCv72MNykOLEd9dmHeOZ TalTV0csZ/jjoE7vAgBoPgo3DhRXGTfg8AkqsOxh7 cJWa1N1pDwG8NB7/vHAjqPOuTqWk7qCioYi3vIWStSQf0v2ocUu6ILXvOgfrgys2 zaT3uK2kLYY1KVpXfdyHRHaNEbDHZHPEBouwK21LrMjEMdaLAF9gZFWW For authorized use only/CN=thawte Primary Root CA i:/C=ZA/ST=Western Cape/L=Cape Town/O=Thawte Consulting cc/OU=Certification Services Division/CN=Thawte Premium Server 3 s:/C=ZA/ST=Western Cape/L=Cape Town/O=Thawte Consulting cc/OU=Certification Services Division/CN=Thawte Premium Server i:/C=ZA/ST=Western Cape/L=Cape Town/O=Thawte Consulting cc/OU=Certification Services Division/CN=Thawte Premium Server certificate For authorized use only/CN=thawte Primary Root CA 2 s:/C=US/O=thawte, Inc./OU=Certification Services Division/OU=(c) 2006 thawte, Inc. For authorized use only/CN=thawte Primary Root CAĭepth=1 /C=US/O=Thawte, Inc./CN=Thawte SSL CAĭepth=0 /C=AT/ST=Ober\xC3\xB6sterreich/L=Linz/O=A1 Telekom Austria AG/OU=ISP/CN=Ġ s:/C=AT/ST=Ober\xC3\xB6sterreich/L=Linz/O=A1 Telekom Austria AG/OU=ISP/CN= i:/C=US/O=Thawte, Inc./CN=Thawte SSL CA 1 s:/C=US/O=Thawte, Inc./CN=Thawte SSL CA i:/C=US/O=thawte, Inc./OU=Certification Services Division/OU=(c) 2006 thawte, Inc. ![]() Here is the output of the openssl session: ~]$ openssl s_client -connect :587 -starttls smtpĭepth=3 /C=ZA/ST=Western Cape/L=Cape Town/O=Thawte Consulting cc/OU=Certification Services Division/CN=Thawte Premium Server return:1ĭepth=2 /C=US/O=thawte, Inc./OU=Certification Services Division/OU=(c) 2006 thawte, Inc. Basic telnet does not support SSL or TLS, so I had to use openssl or stunnel to verify it. I had also to find out which SSL certificates this SMTP server uses and thereafter to import them into Oracle Wallet on the database server. UTL_ENCODE.base64_encode (UTL_RAW.cast_to_raw ('dummy123'))) as password ![]() UTL_ENCODE.base64_encode (UTL_RAW.cast_to_raw as username, ![]() The simplest solution is: select UTL_RAW.cast_to_varchar2 ( To use a secure SMTP, the credential (login and password) have to be encoded in a base64 encoding. Password: dummy123 (this is a real password! ? )Īfter I got details about SMTP server, I tried to verify if the login is working and if SSL is enabled/supported. Login: (real e-mail address changed for this article) Oracle database version should be at least 11.2.0.2, because UTL_SMTP got STARTTLS and AUTH procedures first in that version.Additionally it should be also possible to send attachments larger than 32k! After I spent a couple of days to develop it and lost many hours to troubleshoot some errors, I would like to share some details – hope it will help someone. Last year I got an interesting task to do – “ Sending secure E-Mails out of the database“. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |