UNIX for Dummies Questions & Answers

Hi,


I got following problem I want to use encrypted password and login for my script for oracle DB.

Code:

  #This was created with  echo "login" | openssl enc -base64  and  echo "password" | openssl enc -base64
  login= bG9naW4K
  passwd= cGFzc3dvcmQK

Im using following syntax :

Code:

  login= bG9naW4K
  passwd= cGFzc3dvcmQK

Code:

  login_d=`echo $login| openssl enc –base64 -d`
  passwd_d=`echo $passwd | openssl enc –base64 -d`

when I perform following commnads :

Code:

  echo -n $ login_d 
  echo –n $passwd_d

it seems to be identical but when I launch

Code:

  con_string=“${login_d}/${passwd_d}@${mydb}“
  select =${/my_select.sql}
   
  sqlplus –s ${con_string} @${select}

it returns: invalid username/password; logon denied

any idea where might be a problem ? maybe there are some invisible chars or something or any idea how to fix it ?

The idea is to not have password and login in text form but encrypted with openssl.

Moderator's Comments:

edit by bakunin: with 33 posts and membership lasting 5 years you should know better than not to use CODE-tags.

Code:

“${login_d}/${passwd_d}@${mydb}“

Somewhere along the line your code got pasted into MS Word or some other word processor which has changed your ordinary double quotes into nasty "smart" quotes which the shell takes to be literal characters.

The quotes are ok maybe I made mistake when I copied it from unix to windows but I have with other scripts there is no problem

any idea ??

Post your actual code, then.

hm I just figure out that there might another problem

I just launched in the shell:

Code:

sqlplus login/password@db

and I got :
ERROR:
ORA-01017: invalid username/password; logon denied

but when I use the credentials in sql developer its working so the problem is somewhere else ...