Setting up a SSL Cert from Comodo

Purchase the cert

Prior to purchasing a cert, you need to generate a private key, and a CSR file (Certificate Signing Request). You'll be asked for the content of the CSR file when ordering the certificate.

openssl req -new -newkey rsa:2048 -nodes -keyout example_com.key -out example_com.csr

This gives you two files:

• example_com.key -- your Private key. You'll need this later to configure ngxinx.
• example_com.csr -- Your CSR file.

Now, purchase the certificate [1], follow the steps on their site, and you should soon get an email with your PositiveSSL Certificate. It contains a zip file with the following:

• Root CA Certificate - AddTrustExternalCARoot.crt
• Intermediate CA Certificate - COMODORSAAddTrustCA.crt
• Intermediate CA Certificate - COMODORSADomainValidationSecureServerCA.crt
• Your PositiveSSL Certificate - www_example_com.crt (or the subdomain you gave them)

Install the Commodo SSL cert

Combine everything for nginx [2]:

1. Combine the above crt files into a bundle (the order matters, here):
   

   cat www_example_com.crt COMODORSADomainValidationSecureServerCA.crt  COMODORSAAddTrustCA.crt AddTrustExternalCARoot.crt > ssl-bundle.crt
   

2. Store the bundle wherever nginx expects to find it:
   

   mkdir -p /etc/nginx/ssl/example_com/
   mv ssl-bundle.crt /etc/nginx/ssl/example_com/
   

3. Ensure your private key is somewhere nginx can read it, as well.:
   

   mv example_com.key /etc/nginx/ssl/example_com/
   

4. Make sure your nginx config points to the right cert file and to the private key you generated earlier:
   

   server {
       listen 443;
   
       ssl on;
       ssl_certificate /etc/nginx/ssl/example_com/ssl-bundle.crt;
       ssl_certificate_key /etc/nginx/ssl/example_com/example_com.key;
   
       # side note: only use TLS since SSLv2 and SSLv3 have had recent vulnerabilities
       ssl_protocols TLSv1 TLSv1.1 TLSv1.2;
   
       # ...
   
   }
   

6. Restart nginx.

Send SMS Using GSM Modem With C#

Dear reader, today we will discuss a very important topic, sending SMS alerts to a mobile phone that is a common demand of most clients. I have experience developing donation collection software. In that software we used a GSM Modem to send a SMS thanks to the donor. So we developed a small application that runs on the server and sends a SMS whenever a new record is inserted into the database from any client.
In this application we will use the following:

• GSM Modem (I have used Vodafone; you can use any)
• SIM Card.
  

Step 1

Create the table in SQL Server.

CREATE TABLE [dbo].[Donor_Profile](

      [Don_Date] [datetime] NULL,

      [Don_Donor_ID] [varchar](20) NOT NULL,

      [Don_Donor_Name] [varchar](50) NULL,

[Don_Mobile_Phone] [varchar](50) NULL,

      [Don_Member] [varchar](10) NULL,

      [Don_SMS1] [varchar](10) NULL,

      [Don_SMS2] [varchar](10) NULL,

      [Don_Logo] [image] NULL,

      [Don_Donor_Type] [int] NULL,

 CONSTRAINT [PK_Donor_Profile] PRIMARY KEY CLUSTERED

(

      [Don_Donor_ID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Step 2

Now you can insert any record in the table but please make sure to insert:

[Don_Donor_ID]= CF-00001-12 and leave the [Don_SMS1], [Don_SMS2] field NULL, [Don_Mobile_Phone] please enter valid phone number where you want to recive the sms.

Step 3

Create the new Desktop application.



Step 4

Design the form as shown in the picture.



Step 5

Dear Reader, please read this carefully in thais step we need to include the following DLL files in the bin\ Debug folder:

• GSMCommServer.dll
• GSMCommShared.dll
• GSMCommunication.dll
• PDUConverter.dll

Step 6

Now we need to add the reference to the project as shown in the picture.

 

Step 7

Now we have added one more reference.



Step 8

Now we need to move to the code behind window and use these references in the code.



Step 9

Now we need to add few textboxes and private variables that we will use in our code.



Step 10

Now we will add the two classes Operation and Main as in the following and add two methods in it GetDBConnection, ipconfig and Execute.





Step 11

Now add the following code in the form load event.




Step 12
Now add the following code in the connect button click event.



Step 13

Now add the following code in the send button click event.



Note: Dear reader please doesn't worry, I have attached the source file for your reference. No need to type in the entire code. But you need to change the SQL Server setting correspondingly for your own system.
For example:

1. SQL Server instance na
   
   me.(.\\CRMIS)
    
2. SQL Server user name and password.(user id sa password.###Reno123)
3. Initial Catalog=PSH (database name)

Add the public static class in the Main.cs as in the following:
public static SqlConnection GetDBConnection()
{
  SqlConnection conn = new SqlConnection(
 "Data Source=.\\CRMIS;Initial Catalog=PSH;User ID=sa;Password=###Ren0321");
 return conn;
}

Step 14

Now we need to attach the modem to the system. It will install its own application but keep this point in your mind, you need to close the application after the installation is complete because that software captures the port that we will use in our code.

Picture 1



Picture 2 (let this application to be installed and close it when it is finished).



Step 15

Now run the application; press F5.



First we need to select the port name from the drop down menu then press the connect button; if port is not valid then it will show the error message.



Now I will select port COM4; it will connect successfully. Dear reader, you need to check your port one by one; Windows XP normally uses port COM3 or COM4.



Step 16

Now press the "Send SMS button"; you will then get a SMS on your mobile phone as in the following:



NOTE: Dear reader, the code works 100%; please contact me if you have any query regrarding this article.

Download File: GSMModem.zip