Convert PEM to PFX/PKCS12(.p12) using OpenSSL

 Hi folks,

To keep it simple with a single command to convert the .PEM format file to .p12/.pfx we can use the below information.

$ openssl pkcs12 -export -in domain.pem -out domain.p12

It will ask you to enter the export password (twice for confirmation).

It's up to you to choose to enter the password or keep it empty (just press enter) based on the use case what you have.

Hope this helps you to convert the certificate format and use in your application or server.

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

Connect to public hosted Ubuntu server MySQL Docker Image from local MySQL Workbench

Hi folks,

Today I am going to explain the procedure to test the public cloud hosted MySQL docker in Ubuntu Server to your local MySQL WorkBench.

We configured a Ubuntu Server on public cloud and installed docker.
Ping the public IP address to make sure, it is reachable to your pc/laptop.

Configure System

Install MySQL Docker Image

# docker pull mysql/mysql-server:latest

Check the images

#docker images

You should be able to view the downloaded mysql server image

Start the MySQL Server

# docker run --name=mysql1 -p 33061:3306 -d mysql/mysql-server
-d : Run in daemon mode
-p host_port:container_port
--name: container name

The mapped public ubuntu server port is 33061, which is mapped to the mysql server port 3306.

Check the containers

# docker ps

You should be able to view your mysql docker containers with container id and ports information

Get the MySQL root user password

MySQL generates a one-time password for docker container and writes to the log.

• To view the log, execute the following command

# docker logs mysql1

• To get the generate one-time password, filter the log with keyworkd "GENERATED"

# docker logs mysql1 2>&1 | grep GENERATED

• You should be able to get the line like below

GENERATED ROOT PASSWORD: Axegh3kAJyDLaRuBemecis&EShOs

• Copy the one-time password. In the next step, we will use this to login.

Reset MySQL root user password

• Connect to MySQL server

# docker exec -it mysql1 -uroot -p

• Paste the generated root password
• Change the password

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'yourpwd';
mysql> FLUSH PRIVILEGES;

• Though you have the root user credentials, you won't be able to connect.

Root cause: root user belongs to localhost, not for the public host usage
Solution: create another user with all privileges

mysql> CREATE USER 'username'@'%' IDENTIFIED BY 'youpwd';
mysql> GRANT ALL PRIVILEGES on *.* TO USER 'username'@'%' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;

• Exit the mysql

mysql> exit;

• Restart the docker

# docker restart mysql1

Connect from MySQL Workbench

1. Open MySQL Workbench
2. Click on add new connection icon
3. Enter the "Connection name"
4. Enter host name "public IP address" or "URL"
5. Enter username as "dev" (Above created user)
6. Click on Password "Store in vault" button and enter the "dev" user password
7. Click on "Test Connection" button
8. You should be able to view the "Successfully made the SQL Connection" pop-up

Hope this tutorial helps you to get connected with your public hosted mysql docker instance to your local mysql workbench.

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

E Aadhaar password for mail copy PDF received from aadhaar@uidai.gov.in

Hi friends,

I have updated my Aadhaar details from Aadhaar update center.
It is mentioned that within 72 hours, my details will be updated.

Before 72 hours of my updated application, I had received an email from aadhaar@uidai.gov.in with an attachment which is password protected.

As I was unable to find the password to open the file in the sent mail, I have googled to find the answer. I have found mulitple options. You can try the following procedure to open the file with your password.

Procedure to open the document

1. Download the file
2. Rename the file by adding .pdf extension, if missing
3. Try the following passwords
• Password length is 8 characters
• First 4 characters of your name as mentioned in Aadhaar card (All small letters)
• Next 4 characters are your year of birth which is mentioned in Aadhaar card
• Password length is 6 characters
• Pin code of your address as per Aadhaar records
• Pin code of your enrolled area where you have applied the Aadhaar card
4. For me, 8 character password (first 4 characters of my name as mentioned in Aadhaar card + year of birth) worked.

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

Forgot your Windows password; Login without password using Kon-Boot Utility

Hi friends,

I am in a confusion whether to put this information in my blog or not. Because it can be used for both good and bad cause.

Promise me that, you will use it for good cause.

Backup files:

Whenever you forgot the admin password in Windows [XP, Vista, 7] any version, you can take backup of your files by using any of the Live CD/DVDs [Ex: Ubuntu Live CD, Which I always prefer to use].

Bypass Authentication:

Without using the Live CD/DVD and if you wants to login to your computer there is a possibility but for limited Operating Systems by using Kon-Boot.

As per Kon-boot free version, it will support only 32-bit edition operating systems (Windows XP,  Vista, Server 2003/08).

The free version doesn't support 64-bit versions and Windows 7 (32bit/64bit).

Procedure:

1. Download the free version of Kon-Boot utility from here http://www.piotrbania.com/all/kon-boot/index2.html#free
2. Direct Link: http://www.mediafire.com/?e51u3rce5a5c0mn
3. Extract the zip file with the password kon-boot
4. Extract the CD-konboot-v1.1-2in1 zip file
5. Open the CD-konboot-v1.1-2in1 folder
6. You will find the CD-konboot-v1.1-2in1.iso
7. Make your Pendrive as bootable with this iso (or) burn the iso to a CD
8. To make your pendrive as a bootable disk, please follow any one of the methods
9. You can use the utilities unetbootin or any bootable utility for pendrive
10. Follow this link for more details http://www.irongeek.com/i.php?page=security/kon-boot-from-usb
11. Boot to your pendrive by adjusting the BIOS boot order settings or One time boot menu at the boot time
12. It will show you the Kon-Boot screen
13. Press any key to get out of the starting screen of Kon-Boot
14. Now it will show you the Kryptos Logic Screen
15. It will automatically bypasses the existing operating system
16. In my system, it automatically booted to the harddisk partition
17. If not, you please select the desired partition to boot for the next time
18. Thats it, now you without entering the password you can login into your system

Note: Kon-Boot will not erases the password of your operating system. It just bypasses the OS authentication.

For further details, please comment here or mail to psrdotcom@gmail.com