Encrypt Ogg users

-- Use default build key Methods  

encrypt password oracle,ENCRYPTKEY default     ##  stay ggsci Generate the encrypted password on the command line  

GGSCI (redhat762100 as [email protected]) 3> encrypt password oracle,ENCRYPTKEY default
Using Blowfish encryption with DEFAULT key.
Encrypted password:  AACAAAAAAAAAAAGAIFAAUDVHCFUGFIYF
Algorithm used:  BLOWFISH


GGSCI (redhat762100 as [email protected]) 4>

dblogin userid ogg,password AACAAAAAAAAAAAGAIFAAUDVHCFUGFIYF,ENCRYPTKEY default   ##  Use the encrypted password , stay GGSCI Log in to the database on the command line 

GGSCI (redhat762100) 5> dblogin userid ogg,password AACAAAAAAAAAAAGAIFAAUDVHCFUGFIYF,ENCRYPTKEY default
Successfully logged into database.

GGSCI (redhat762100 as [email protected]) 6>

userid ogg,password AACAAAAAAAAAAAGAIFAAUDVHCFUGFIYF,ENCRYPTKEY default     ##  In the parameter file of the process , Add these , Replace userid ogg,password oracle 

-- Use key Method for encryption  

### 256 Bit encryption  
cd /u01/ogg19c 
./keygen 256 1   -- 256 Bit encryption , Generate 1 A code       success , Be careful , When logging in , Specify the encryption method AES256 

[[email protected] ogg19c]$ ./keygen 256 1
0x608EB330DCDD3E6197500E707D70467C4BBCBE2A11780A2F3C78DE4F0BD2ED05 

[[email protected] ogg19c]$

edit ENCKEYS file , Encrypt the generated above key fill , The way is as follows ：

vi ENCKEYS
## KEY NAME      KEY VALUE
ogg_key  0x608EB330DCDD3E6197500E707D70467C4BBCBE2A11780A2F3C78DE4F0BD2ED05

ENCRYPT PASSWORD oracle AES256  ENCRYPTKEY ogg_key      ##   stay GGSCI Generate an encrypted password on the command line , The specified encryption method is AES256 

GGSCI (redhat762100) 1> ENCRYPT PASSWORD oracle AES256  ENCRYPTKEY ogg_key
Encrypted password:  AADAAAAAAAAAAAGABDCEKCYIGFOAIFJAAJQBHCBHBAREKCGAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
Algorithm used:  AES256


GGSCI (redhat762100) 2>

Log in with the generated encrypted password , Specify the encryption method as AES256 , encryption key yes ogg_key , Login successful

dblogin userid ogg,password AADAAAAAAAAAAAGABDCEKCYIGFOAIFJAAJQBHCBHBAREKCGAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA  AES256,encryptkey ogg_key

GGSCI (redhat762100) 2> dblogin userid ogg,password AADAAAAAAAAAAAGABDCEKCYIGFOAIFJAAJQBHCBHBAREKCGAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA  AES256,encryptkey ogg_key
Successfully logged into database.

GGSCI (redhat762100 as [email protected]) 3>

-- During the test , Used AES156 encryption , But when you log in , Is not specified AES256, Cause error , The above specifies AES156 , Login successful , Don't specify , The default is AES128 encryption  

GGSCI (redhat762100) 2> dblogin userid ogg,password AADAAAAAAAAAAAGABDCEKCYIGFOAIFJAAJQBHCBHBAREKCGAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA                           AA,encryptkey ogg_key
ERROR: Error (-12) Error (-11) retrieving key for OGG_KEY in file ENCKEYS: The length of the key specified in KEYNAME does not match the encryption method. AES256  

#### 128 Bit encryption

./keygen 128 1   -- 128 Bit encryption , The default is 128 position , Generate 1 A code 

[[email protected] ogg19c]$ ./keygen 128 1          ##  Generate 128 Bit encryption key 
0x174C852123CCC100699D4A4BB0703412

[[email protected] ogg19c]$

 Write the generated password in ENCKEYS In file , The format is as follows 
[[email protected] ogg19c]$ cat ENCKEYS
ogg_key 0x174C852123CCC100699D4A4BB0703412
[[email protected] ogg19c]$

stay GGSCI Generate encrypted password on , No encryption method specified , Use default 128 position

ENCRYPT PASSWORD oracle ENCRYPTKEY ogg_key     


GGSCI (redhat762100) 1> ENCRYPT PASSWORD oracle ENCRYPTKEY ogg_key
Encrypted password:  AADAAAAAAAAAAAGAZIUEICADYHPHXIMHBEDHNIXGTFMFZHAHAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
Algorithm used:  AES128


GGSCI (redhat762100) 2>

Log on to the test , Login successful

dblogin userid ogg,password AADAAAAAAAAAAAGAZIUEICADYHPHXIMHBEDHNIXGTFMFZHAHAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA,encryptkey ogg_key

GGSCI (redhat762100) 4> dblogin userid ogg,password AADAAAAAAAAAAAGAZIUEICADYHPHXIMHBEDHNIXGTFMFZHAHAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA,encryptkey ogg_key
Successfully logged into database.

GGSCI (redhat762100 as [email protected]) 5>

hinder tail file ,tcpip encryption , Have time to retest .

END