Sponsored Content
Top Forums Shell Programming and Scripting How to validate Database password in ksh? Post 302592433 by Chubler_XL on Monday 23rd of January 2012 11:16:07 PM
Old 01-24-2012
You could try examining the return code from sqlplus:

Code:
sqlplus -s user/$db_pass@prd3 2> /tmp/sql.err <<ENDOFSQL
...
ENDOFSQL
 
return_code=$?
 
if [ $return_code -ne 0 ]
then
    echo "sqlplus failed: error code $return_code"
    echo "Error string is:"
    cat /tmp/sql.err
fi
rm -f /tmp/sql.err

Use an invalid username/password and see what you get back.

If the return code isn't unique for incorrect password (some programs just return 1 for any error found). Try a search for a unique error string in the sql.err file relating to username/password.
 

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
MojoMojo::Controller::User(3pm) 			User Contributed Perl Documentation			   MojoMojo::Controller::User(3pm)

NAME
MojoMojo::Controller::User - Login/User Management Controller DESCRIPTION
This controller performs user management: registration, login, logout, password recovery and profile editing. ACTIONS
login (/.login) Log in through the authentication system. logout ( /.logout ) Log out the user. users ( /.users ) Show a list of the active users with links to the pages they edited. page_user Show a user's preferences prefs ( .prefs ) Main user preferences screen. password ( .prefs/password ) Change password action. template: user/password.tt recover_pass Email a user a new password register ( /.register ) Show new user registration form. template: "user/register.tt" is_account_taken Test to see if a login or email is already in use. do_register ( /.register ) New user registration processing. templates: "user/password.tt", "user/validate.tt" validate ( /.validate ) Validation of user email. Will accept a md5_hex mailed to the user earlier. Non-validated users will only be able to log out. reconfirm Send the confirmation mail again to another address. profile ( .profile ) Show user profile. editprofile Form to edit a person's profile do_editprofile Apply the edits to a person's profile AUTHOR
David Naughton <naughton@cpan.org>, Marcus Ramberg <mramberg@cpan.org> LICENSE
This library is free software. You can redistribute it and/or modify it under the same terms as Perl itself. perl v5.14.2 2011-09-02 MojoMojo::Controller::User(3pm)
All times are GMT -4. The time now is 04:19 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy