How to encrypt data on an external hard drive?

Question

I have installed DB2 Express-C V9.7, unixODBC php5-odbc and iSerie-5.4.0-1.6 Drivers for Linux but when i try to connect to the DB2 server php return me this message :

[unixODBC][IBM][iSeries Access ODBC Driver]Communication link failure. comm rc=10061  -
CWBCO1049 - The iSeries server application is not started, SQL state 08004 in SQLConnect

I noticed with tcpdump that php try to connect on port 8741 instead of 50000.

netstat -anp tell me DB2 listen port 50000

This is my configuration file

/etc/odbcinst.ini :

[DB2]
Description     = ODBC for DB2
Driver          = /opt/ibm/iSeriesAccess/lib/libcwbodbc.so
Setup           = /opt/ibm/iSeriesAccess/lib/libcwbodbcs.so
FileUsage               = 1
Threading               = 2
DontDLClose             = 1
UsageCount              = 1

/etc/odbc.ini

[local_db2]
Driver = DB2
System = localhost
User = db2inst1
Password = MySecretPassword
Port = 50000
Database = dbname
Option = 1 

And my PHP Script :

$dsn = "local_db2";
$user = "db2inst1";
$passwd = "MySecretPassword";
$conn = odbc_connect($dsn,$user,$passwd );

echo "votre id de connexion est : $conn";

if ($conn <= 0) { 
 echo "\nErreur\n"; 
} 
  else { echo "\nSuccès\n"; 
}

odbc_close($conn);

---

Now i can connect to DB2 server. I have changed port of db2inst1 in /etc/services but server don't respond me.

My error message is (after a while): [unixODBC][IBM][System i Access ODBC Driver]Communication link failure. comm rc=8405 - CWBCO1047 - The IBM i server application disconnected the connection, SQL state 08S01 in SQLConnect

Conclusion :

The first problem was the drivers for iSeries that was not the proper drivers for my configuration so i have installed the DB2 ODBC CLI driver which include drivers for linux.

The second problem was the odbc configuration.

My working /etc/odbc.ini configuration :

[DBNAME]
Driver=DB2

My working /etc/odbcinst.ini configuration :

[ODBC]
Trace       = yes
Tracefile       = /tmp/odbc.log

[DB2]
Description     = DB2 Driver
Driver      = /opt/ibm/db2/V9.7/lib32/libdb2.so
FileUsage       = 1
DontDLClose     = 1

You can get more details about your odbc connection in /tmp/odbc.log. I used too the isql program who test odbc connection. This program was in unixodbc linux package.

Thanks for your informations

Nicolas.

Solution 1

Have you looked into TrueCrypt? From the website:

Main Features:

• Creates a virtual encrypted disk within a file and mounts it as a real disk.

• Encrypts an entire partition or storage device such as USB flash drive or hard drive.

• Encrypts a partition or drive where Windows is installed (pre-boot authentication).

• Encryption is automatic, real-time (on-the-fly) and transparent.

• Parallelization and pipelining allow data to be read and written as fast as if the drive was not encrypted.

• Provides plausible deniability, in case an adversary forces you to reveal the password:

• Hidden volume (steganography) and hidden operating system.

• Encryption algorithms: AES-256, Serpent, and Twofish. Mode of operation: XTS.

Solution 2

TrueCrypt should do the job.

http://www.howtogeek.com/howto/6169/use-truecrypt-to-secure-your-data/

Solution 3

TrueCrypt doesn't work if you're planing to use backup programs such as Windows Vista/7 backup, as it does not see the drive mounted. I tried both options with no success. The solution is to look for backup drives that come with encrypting option.

Solution 4

You didn't mention, what system you are using to back up your data. Anyways, the free software Veracrypt or TrueCrypt (without diving into the discussion which is better/more trusty) could do the job.

If you trust Microsoft, BitLocker is also available - but it is closed source.

For Linux-systems, Veracrypt is being offered as a GUI and CLI implementation as well. Furthermore, you can use cryptsetup or related software to encrypt your hard drive. I personally like to use hardware with linux unified key setup (LUKS)-encryption, since it is fairly well documented, e.g. in the fedora wiki or the arch wiki.

View more solutions

Comments

[Noumenon]

Since TrueCrypt went out of service, this question could use new answers.

[Nicolas Blaudez]

i'm a newby with DB2, but i don't have wrkactjob and strhostsvr utilities on my system. I thinks it's OS/400 commands but i run DB2 on my ubuntu Linux

[James Allman]

If you are running DB2 on Linux why are you using the iSeries Access DB2 driver? You should be using a standard DB2 driver such as DB2 ODBC CLI driver. The iSeries driver is only for connection to DB2/400.

[Thorbjørn Ravn Andersen]

Please update your question with what was the actual problem, and how you fixed it.