StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
18255752
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-08-15T15:11:33.500
FavoriteCount
0
LastActivityDate
2015-01-27T20:02:55.743
LastEditDate
2015-01-27T20:02:55.743
LastEditorUserId
16545
OwnerUserId
230646
ParentId
11046135
PostTypeId
2
Score
23
ViewCount
0
LastEditorDisplayName
text
Body
Unfortunately as I am forced to use a windows server I have been unable to get openssl working in the way the above answer suggests. However I was able to get a similar program called stunnel (which can be downloaded from <a href="http://www.stunnel.org/downloads.html">here</a>) to work. I got the idea from <a href="http://www.tech-and-dev.com/2010/10/sending-email-using-gmail-smtp-server.html">www.tech-and-dev.com</a> but I had to change the instructions slightly. Here is what I did: <ol> <li>Install telnet client on the windows box.</li> <li>Download stunnel. (I downloaded and installed a file called stunnel-4.56-installer.exe).</li> <li>Once installed you then needed to locate the <code>stunnel.conf</code> config file, which in my case I installed to <code>C:\Program Files (x86)\stunnel</code></li> <li>Then, you need to open this file in a text viewer such as notepad. Look for <code>[gmail-smtp]</code> and remove the semicolon on the client line below (in the stunnel.conf file, every line that starts with a semicolon is a comment). You should end up with something like: <pre><code>[gmail-smtp] client = yes accept = 127.0.0.1:25 connect = smtp.gmail.com:465 </code></pre> Once you have done this save the <code>stunnel.conf</code> file and reload the config (to do this use the stunnel GUI program, and click on configuration=>Reload).</li> </ol> Now you should be ready to send email in the windows telnet client! Go to Start=>run=>cmd. Once cmd is open type in the following and press Enter: <pre><code>telnet localhost 25 </code></pre> You should then see something similar to the following: <pre><code>220 mx.google.com ESMTP f14sm1400408wbe.2 </code></pre> You will then need to reply by typing the following and pressing enter: <pre><code>helo google </code></pre> This should give you the following response: <pre><code>250 mx.google.com at your service </code></pre> If you get this you then need to type the following and press enter: <pre><code>ehlo google </code></pre> This should then give you the following response: <pre><code>250-mx.google.com at your service, [212.28.228.49] 250-SIZE 35651584 250-8BITMIME 250-AUTH LOGIN PLAIN XOAUTH 250 ENHANCEDSTATUSCODES </code></pre> Now you should be ready to authenticate with your Gmail details. To do this type the following and press enter: <pre><code>AUTH LOGIN </code></pre> This should then give you the following response: <pre><code>334 VXNlcm5hbWU6 </code></pre> This means that we are ready to authenticate by using our gmail address and password. However since this is an encrypted session, we're going to have to send the email and password encoded in base64. To encode your email and password, you can use a converter program or an online website to encode it (for example <a href="http://www5.rptea.com/base64/">base64</a> or search on google for ’base64 online encoding’). I reccomend you do not touch the cmd/telnet session again until you have done this. For example test@gmail.com would become dGVzdEBnbWFpbC5jb20= and password would become cGFzc3dvcmQ= Once you have done this copy and paste your converted base64 username into the cmd/telnet session and press enter. This should give you following response: <pre><code>334 UGFzc3dvcmQ6 </code></pre> Now copy and paste your converted base64 password into the cmd/telnet session and press enter. This should give you following response if both login credentials are correct: <pre><code>235 2.7.0 Accepted </code></pre> You should now enter the sender email (should be the same as the username) in the following format and press enter: <pre><code>MAIL FROM:<test@gmail.com> </code></pre> This should give you the following response: <pre><code>250 2.1.0 OK x23sm1104292weq.10 </code></pre> You can now enter the recipient email address in a similar format and press enter: <pre><code>RCPT TO:<recipient@gmail.com> </code></pre> This should give you the following response: <pre><code>250 2.1.5 OK x23sm1104292weq.10 </code></pre> Now you will need to type the following and press enter: <pre><code>DATA </code></pre> Which should give you the following response: <pre><code>354 Go ahead x23sm1104292weq.10 </code></pre> Now we can start to compose the message! To do this enter your message in the following format (Tip: do this in notepad and copy the entire message into the cmd/telnet session): <pre><code>From: Test <test@gmail.com> To: Me <recipient@gmail.com> Subject: Testing email from telnet This is the body Adding more lines to the body message. </code></pre> When you have finished the email enter a dot: <pre><code>. </code></pre> This should give you the following response: <pre><code>250 2.0.0 OK 1288307376 x23sm1104292weq.10 </code></pre> And now you need to end your session by typing the following and pressing enter: <pre><code>QUIT </code></pre> This should give you the following response: <pre><code>221 2.0.0 closing connection x23sm1104292weq.10 Connection to host lost. </code></pre> And your email should now be in the recipient’s mailbox!
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to send email using simple SMTP commands via Gmail?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USThoriumBR
UserOwnerUserId
1. USExile
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTApproveEditSuggestion
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.