Truecrypt Mount and Unmount in Windows

Hi friends,

I would like to share the information of mounting and unmounting truecrypt in windows

Please find the batch file here

https://gist.github.com/psrdotcom/8350f1469a7a396a886e86b3f29ef38a#file-truecryptmountunmount-bat

With the above batch file, you should be able to do following functionalities

1. Mount a folder as drive
2. Unmount the drive

Hope, this information is useful to you.

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

Ubuntu and Windows system level utilities

Hi friends,

Please find the below links to customize or maintain your OS.

Recover data in Ubuntu
http://www.howtogeek.com/howto/15761/recover-data-like-a-forensics-expert-using-an-ubuntu-live-cd/

Ubuntu LiveCD Customization from scratch
https://help.ubuntu.com/community/LiveCDCustomizationFromScratch

Boot windows7 from USB
http://www.intowindows.com/how-to-install-windows-7vista-from-usb-drive-detailed-100-working-guide/
http://kmwoley.com/blog/?p=345

Windows OS Updates(SP?)
http://www.bootdisk.com/

Partition and Back utilities

Backup
http://www.todo-backup.com/products/home/free-backup-software.htm

partition
http://www.partition-tool.com/personal.htm

disk to disk copy
http://www.easeus.com/disk-copy/

Data Recovery
http://www.easeus.com/datarecoverywizard/free-data-recovery-software.htm

Hope the above tools will be useful for you.

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

Docker postgres db to local volume/drive for persistent storage permanently

Hi all,

Today, I would be explaining the way to maintain the DB with data persistent when connecting to docker.

System Status

Postgresql DB container is in Docker
Windows 10 PC
Linux containers

Issue

Whenever I restart docker/PC the database wiped off due to container is stopped.

Solution

Create a docker volume

Syntax: docker volume create <>
Example: docker volume create pgdata

Start the container with volume option

Syntax: docker run --rm --name <> -e POSTGRES_PASSWORD=<> -d -p 5432:5432 -v <>:/var/lib/postgresql/data <>
Example: docker run --rm --name pgcontainer -e POSTGRES_PASSWORD=MyPassword -d -p 5432:5432 -v pgdata:/var/lib/postgresql/data postgres

Now, you can run all your database commands

Upon restart also, your data should be safe.

Thanks for reading the blog post.

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

node server address in use error resolution for Windows and Linux machines

Hi friends,

Today, I have come across a situation, where my node server existed unproperly and address has been blocked. Because of which, I am unable to run the node server on the same port.

System configuration

Running my node server on port 3000.

Resolution

Windows Machine

We will first try to find whether the port has been still in listening mode.
> netstat -ano | find "LISTENING" | find "3000"
When the above command returns result then take the last number (Process ID)
We will kill the process with the following command.
> taskkill /f /pid

Linux Machine

> netstat -nlp | grep :3000
> kill -9

Now, you will be able to run the node server on the same port which has been blocked.

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

bash: C:/Program: No such file or directory error solution in git bash with windows directory path having spaces

Hi friends,

Today, I have come across a situation where I have to execute the gitbash on windows with linux commands.

The escape character doesn't alone solve the problem

Problem

Setting up an alias for bash where the path includes space

$ alias DOCKER_HOME=C:/Program Files/Docker/Docker

Error

bash: C:/Program: No such file or directory

Solution

$ alias DOCKER_HOME=C:/"Program\ Files"/Docker/Docker

Hope my solution helps you in resolving the issue.

Please send your feedback and comments 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

Oracle Drop/Delete User with All tables and files

Hi All,

Today I am going to explain the procedure to delete/drop a user in Oracle database along with tables and mapped files for that user tablespace.

Pre-requisites

Oracle database with the following

1. User
2. Tablespace of the user
3. Datafile of the tablespace

Procedure

Drop the user

Syntax: DROP USER CASCADE;
Example: DROP USER sampleuser CASCADE;

Make the tablespace offline

Syntax: ALTER TABLESPACE OFFLINE;
Example: ALTER TABLESPACE sampletablespace OFFLINE;

Drop the tablespace with mapped datafile[s]

Syntax: DROP TABLESPACE INCLUDING CONTENTS AND DATAFILES
Example: DROP TABLESPACE sampletablespace INCLUDING CONTENTS AND DATAFILES

With the above 3 commands, you can make sure that, user and user related data has been completed removed from database.

Hope, it will help to resolve your issue.

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