Generate Free SSL Certificate using ZeroSSL

 Hi all,

Today I am going to explain the process of generating free SSL certificate using ZeroSSL

Pre-requisite

1. We should have our own domain
2. We should be able to add/update the DNS settings like A, CNAME, TXT records

Best free SSL providers

As per my research I found the best free SSL (90 days) certificate providers

1. ZeroSSL
2. Let's Encrypt

In this blog, i'll explain ZeroSSL process

ZeroSSL Free SSL Certificate

1. Navigate to https://zerossl.com/
2. Signup with your email by clicking on "FreeSSL"
3. After email verification, login to zerossl site
4. Click on "New Certificate"
5. 
6. Enter your domain name and click on "Next Step"
7. Default validity is 90 days for free SSL
8. 
9. In the CSR section we have couple of options
10. Default is Auto-Generate CSR enabled
11. Disable Auto-Generate CSR - only your zerossl registered email address with default values
12. Enable Paste Existing CSR - If you have already created a CSR then you can use this option
13. 
14. Finalize your order
15. 

Note

ZeroSSL will generate the certificate using signature algorithm SHA-384

In some cases, if SHA-384 based SSL is not valid then we have to mandatory go for alternate "Let's Encrypt". I will explain Let's Encrypt in my next blog.

For every 90 days, we need to renew our certificate in the above mentioned manner.

Download Certificate

1. Navigate to Certificates section
2. Go to Issued tab
3. 
4. Click on "Install"
5. 
6. You can select the Default Format dropdown to select specified server or just leave it default.
7. Download the certificate zip file which will contain 
1. ca_bunder.crt - CA Bundle
2. certificate.crt - Certificate
3. private.key - Private Key

Hope, you will be able to make use of this free SSL feature and encrypt your domain traffic.

Please let me know your feedback and suggestions in comments or mail to psrdotcom@gmail.com

Oracle Create User with custom tablespace and datafile

Hi all,

Through I have explained the procedure to delete/drop the user with tablespace and datafiles. I though of giving information about creating a user with custom tablespace and datafile.

Pre-requisites

1. Oracle database
2. Login as sys as sysdba

Procedure

Create tablespace

Syntax: CREATE TABLESPACE DATAFILE SIZE ;
Example: CREATE TABLESPACE sample_tablespace DATAFILE 'C:\\samplets.dbf' SIZE 100M;
Example: CREATE TABLESPACE sample_tablespace DATAFILE '\usr\local\datafiles\samplets.dbf' SIZE 100M;

User creation

Alter session
ALTER SESSION SET "_ORACLE_SCRIPT"=true;

Create User
Syntax: CREATE USER IDENTIFIED BY DEFAULT TABLESPACE ;
Example: CREATE USER sampleuser IDENTIFIED BY samplepwd DEFAULT TABLESPACE sample_tablespace;

Grant privilieges
Syntax: GRANT ALL PRIVILEGES to ;
Example: GRANT ALL PRIVILEGES to sampleuser;

Commit the commands
commit;

Now, you should be able to create the tablespace and made that as default tablespace for the newly created user.

Hope, this information helps you.

Please send your comments and feedback to psrdotcom@gmail.com

Chennai Old Vs. New Fare Meter Fare Comparision Android App on Google Play

Hi all,

I have designed and developed an app for all the Chennaites, who use auto tranportation.

There has been an hike in prices of autorickshaw fares. Most of the autos didn't get updated to new meter with GPS functionality. Those who are traveling in old autos, either they have to compute the new fare with old (OR) pay whatever auto guy says.

Lets not pay whatever they say, we have developed an app, where you can compute and compare the old and new auto fares.

Lets give a try into looking at our app.

Scan and download app:

https://play.google.com/store/apps/details?id=info.pillisureshraju.chennaiautokaasu&hl=en

Its a complete off-line application, which doesn't require any additional permission from your mobile.

Compute and compare exact amount of old and new Chennai auto-rickshaw fare with day and night time fares.

If your hired auto doesn't have new meter and you have to compute the old and new meter fare then its very easy with our app for your new price calculation.

You can select the traveled distance in exactly using kilometers (Kms.) and meters (Mts.). If any waiting time, select in hours (Hrs.) and minutes (Min.)

Automatically you can find the old auto fare and new auto fare with day and night paying amounts.

I hope you all make use of this.

ICICI Bank ATM Debit Card PIN Changing Procedure with Telephone Codes

Hi friends,
I have mistakenly typed the ATM pin 3 times at ATM. My ICICI card was blocked. This was the second time, it happened to me. I have generated the new PIN by calling customer care.

Then I thought let me write the procedure to activate it through the telephone/mobile.

Please follows these steps to activate your debit card with new ATM pin

1. Turn Back your ICICI card, where your magnetic strip, cvv and grid exists. 
2. On top of the card, you will find the major cities names along with customer care number. 
3. Please call to any one of the customer care number (preferably your region/nearest phone number)
4. 1111
• 1 -> Language Selection (English)
• 1 -> Existing Customer
• 1 -> Banking related queries
• A/c No. (or) Debit Card Number: Full Account Number (or) 16-digit debit card number
• 1 -> Generate PIN
• Card Expiry Date: Enter in the following format Ex: For Mar-2012, Please enter 0312
5. Then the call will be connected to phone banking officer
6. They will ask some security questions regarding your account details, which you have entered in the application form.
7. Once the verification gets over, then the officer will transfer your call, So that you can generate your new PIN
8. System will read the last 4 digits of your debit card
9. You need to enter
• CVV -> Back of your card, 3-digit CVV will be displayed along with your last 4 digits of your card number
• New PIN -> Which you would like to change
• Re-enter PIN -> Same PIN which you have entered as New PIN

Within no time, you can use debit card ATM PIN.

For further assistance:
http://www.icicibank.com/customer-care.html

Apply New, Change/Correct Your Voter Card Details Online in India

Dear all,

Choosing our leader is the gift which we are doing in India through elections. To do that, we need to have an voter card to utilize our vote.

Andhra Pradesh Chief Electrol Officer has come with a website, where we can do the following things.

1) Apply our voter cards online
2) Corrections in the voter card details
3) Know your status of the voter card application
4) Transpose your location (Change in the location)
4) Know your assembly constituency by giving your location
5) Know your electoral rolls (Which poling booth you need to vote)
and lot more.

Please make use of this and vote for your leader.

References:
http://www.ceoandhra.nic.in/ceonew/home.aspx

For any queries, mail to psrdotcom@gmail.com