Sponsored Content
Top Forums Shell Programming and Scripting How to validate Database password in ksh? Post 302594004 by saps19 on Monday 30th of January 2012 07:04:27 AM
Old 01-30-2012
Quote:
Originally Posted by knight_eon
Try this:
I have modified my code as below:
Code:
     1  #! /bin/ksh
     2  #
     3  #########################
     4  # Unix Code Starts here #
     5  #########################
     6  #
     7  LOG_DIR=/app/work/saps/logs
     8  varDate=`date +%d%h%y`
     9  echo 'Please Enter Database Password: '
    10  stty -echo
    11  read db_pass
    12  stty echo
    13  result=`sqlplus -s user/$db_pass@uat3 2>&1 <<ENDOFSQL
    14  ENDOFSQL`
    15
    16  #echo $result
    17
    18  if [ "$result" == "" ]
    19  then
    20      echo '\n\033[32mConnected !\033[0m'
    21  else
    22      echo 'sqlplus failed! Invalid username/password. For more details, check the LOG File in ' $LOG_DIR
    23      echo $result >$LOG_DIR/sql_err_${varDate}.txt
    24  fi
    25  #rm -f /tmp/sql_today.err
    26  find $LOG_DIR -name "sql_err_*.txt" -mtime +0 -type f;
    27

It's working fine now...!

Still you guys can review my code and suggest me if anything needs to be added/modified or deleted [Remembering "the Useless use of cat" Smilie].

Last edited by saps19; 01-30-2012 at 08:05 AM.. Reason: Typo
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Password database

I am trying to locate a password database for use at work. I have looked at several open source packages but all that I have found are for a single user and we need to allow multiple user access with view restrictions. Does anyone know of a program that fits these requirements? Thanks... (2 Replies)
Discussion started by: thumper
2 Replies

2. Programming

userpw.h AIX ( delete entry from the shadow password database )

HI i need to delete an entry in /etc/security/passwd. can't find a way to do it with userpw.h api ( AIX ). the passwd file i delete like this. Write all entrys to passwd file except the one we are removing. can't find any function that works like getspent / getpwent do in AIX userpw api.... (4 Replies)
Discussion started by: nighter
4 Replies

3. Shell Programming and Scripting

Sample ksh script for copy the data from excel to database table ?

Hi All, I need to convert the data from excel to database table in sybase. Please provide some sample script.. thanks, Royal. (1 Reply)
Discussion started by: royal9482
1 Replies

4. Shell Programming and Scripting

passing database password to isql command in shell script

Hi, I need to connect to DB through my shell script. but I dont want to hardcode my db password in the script. Is there a way to do it? Thanks ---------- Post updated at 07:42 PM ---------- Previous update was at 04:54 PM ---------- :(Guys..please help me with this:( (1 Reply)
Discussion started by: agrawal.prachi
1 Replies

5. Shell Programming and Scripting

Database password appearing in script output

Hi there, This is my first post, so as you have probably guessed I am looking for some help. Currently we have close to 1000 ksh scripts operating on HPUX servers that call either isql or bcp to connect to Sybase databases. Problem being that the db passwords are appearing in the job log... (3 Replies)
Discussion started by: kdk_irl
3 Replies

6. Shell Programming and Scripting

Validate xml agaist xsd is ksh

how do i validate xml agaist xsd is ksh? (1 Reply)
Discussion started by: LiorAmitai
1 Replies

7. UNIX for Dummies Questions & Answers

Launch a URL,validate username and password using wget or curl

Hi All, I want to launch "ex: http://gmail.com" from the cmd window and validate the credentials with username and password, is it possible? I have found something like this "wget --http-user=USER' --http-password=PASSWORD http://gmail.com" am new to this and unable to find a solution, i... (0 Replies)
Discussion started by: harsha85
0 Replies

8. Shell Programming and Scripting

Any Sample ksh script to validate all the database objects

Hi, I need a sample script to validate all the database objects like 1. table structure(columns, datatypes,key contraints if any) 2. synonyms 3. grants 4. indexes ....etc thank you! (2 Replies)
Discussion started by: srikanth_sagi
2 Replies

9. UNIX for Beginners Questions & Answers

Setting config database user and password using sed

Hello everybody, I need to modify 200 files using a patern matching, I would like to do it with sed but it's not working with the following syntax: sed -e 's/DATABASE_PASSWORD.*oldpass/DATABASE_PASSWORD__', 'newpass/g' config.php need to find: define("__DATABASE_PASSWORD__", ... (6 Replies)
Discussion started by: dco
6 Replies
dxchpwd(1X)															       dxchpwd(1X)

NAME
dxchpwd - Create or change password program SYNOPSIS
dxchpwd dxchpwd -r | -l dxchpwd [-r | -l] -q dxchpwd [-r | -l] -u username OPTIONS
If dxchpwd is invoked without any options, it is assumed that the current user's password is to be changed. The following options are also accepted: Tells dxchpwd that the password change is to be done for a Local user. This can be combined with the -u and -q options. Tells dxchpwd that the password change is to be done for a NIS user. This can only be done from a NIS master and can be combined with the -u and -q options. Tells dxchpwd to query the user for the user name of the account whose password is to be changed. Tells dxchpwd to change this user's password. DESCRIPTION
The dxchpwd command lets you change your password. When you invoke the dxchpwd command, the program prompts you for the old password and then for the new password. Next, the program asks you for the new password again, to verify that you have typed it correctly. Note that the passwords are not displayed on the screen. Your new password must meet the length requirements specified by the authorization database for the user whose password is being changed. If your system is running with enhanced security, you may have to choose a password from a list of randomly generated passwords or you may be prohibited from changing your password until its minimum lifetime has expired, as specified in the authorization database. EXAMPLES
The following example requests that the password be changed for user smith: dxchpwd -u smith FILES
Password file Protected Password Database dxchpwd executable SEE ALSO
X(1X), xdm(1X), passwd(1) dxchpwd(1X)
All times are GMT -4. The time now is 11:41 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy