Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: passing database password to isql command in shell script
Top Forums Shell Programming and Scripting passing database password to isql command in shell script Post 302427092 by curleb on Thursday 3rd of June 2010 09:16:41 PM
Old 06-03-2010
very unlikely, although you'd probably be able to obfuscate it somewhat...

One option I've seen used is to provide a secondary script that is sourced into use, which actually provides the password. It serves to abstract the password from general population (that would be accessing your primary SQL file), but as with any command line parameter, it's still visible from any ps listing. Sort of like moving the password from the script, but putting it within easy reach of anyone with command line access.

You could also look into maybe setting up an ssh Tunnel that would effectively broker the call for you, but I've not done it myself either, so that's pretty much conjecture.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

passing password in shell script

Hi, Anybody help to write a shell script as below requirement. script stops some costomized application services. 1. first it will stop apache as root 2. then it will switch to my application user and stop app service. Note: passing password is required to stop app service as app... (1 Reply)
Discussion started by: manojbarot1
1 Replies

2. Shell Programming and Scripting

Passing parameters to Shell script for GREP command

I am using grep to capture date from a file . Since i need to use the shell script for different dates ,is it possible to pass the date parameter to the shell script the Script is as below grep -E "08 Aug 2008|2008-08-08"* somefile.txt>test.txt The above script file greps the... (1 Reply)
Discussion started by: sud.tech
1 Replies

3. Shell Programming and Scripting

Passing Shell Variables in ISQL

Hi.. I am passing a variable in my shell function. I need to access it for an isql comand in the shell script. However the isql o/p gives no results if i pass a variable in the command. The isql command works perfectly fine if i hardcore the table name. My script is : ... (0 Replies)
Discussion started by: dikki
0 Replies

4. Shell Programming and Scripting

ssh - passing password in shell script

I have a requirement, I need to run a command at remote system using a ssh. Is there any way we can pass the username and password in shell script to the ssh command as we did it in one of the shell script for FTP. ftp -n $i <<!EOF >> user Username $PASSWD cd /home/scripts ... (5 Replies)
Discussion started by: Muktesh
5 Replies

5. UNIX for Dummies Questions & Answers

Passing command output as an argument to a shell script

Hi, I have a very small requirement where i need to pass command output as an argument while invoking the shell script.. I need to call like this sh testscript.sh ' ls -t Appl*and*abc* | head -n 1' This will list one file name as ana argument.. I will be using "$1" in the shell... (2 Replies)
Discussion started by: pssandeep
2 Replies

6. Shell Programming and Scripting

passing password to a command

Hi all, I have the expect binaries in our boxes.. I want to pass a passwd to a command automatically without manual intervention using "/<path_of_expect>/expect/<version>/bin/autopasswd" The below command will ask passwd in my script cleartool rmtag -all <vob_tag> #Some... (4 Replies)
Discussion started by: raghu.iv85
4 Replies

7. Shell Programming and Scripting

Passing arguments from a bash shell script to a command

I'm pretty new to bash scripting and I've found myself writing things like this (and the same with even more nesting): if $CATEGORIES; then if $LABEL_SLOTS; then $pyth "$wd/texify_grammar.py" "$input" "$texfile" "--label-slots" "--categories" "$CATEGORY_LIST" ... (9 Replies)
Discussion started by: burbly
9 Replies

8. Shell Programming and Scripting

Passing password with SSH command

Hi Experts, I have specific requirement where I want to pass the password with the ssh username@hostname command . I dont want to use RSA public and private keys also. Because that will be on production server and no one wants to give access like that. Second thing it is production... (14 Replies)
Discussion started by: sharsour
14 Replies

9. UNIX for Dummies Questions & Answers

Passing shell script parameter value to awk command in side the script

I have a shell script (.sh) and I want to pass a parameter value to the awk command but I am getting exception, please assist. diff=$1$2.diff id=$2 new=new_$diff echo "My id is $1" echo "I want to sync for user account $id" ##awk command I am using is as below cat $diff |... (1 Reply)
Discussion started by: Sarita Behera
1 Replies

10. Shell Programming and Scripting

Passing Username & password through shell script to java code

Hi, I have a shell script (script.sh) in which we are calling java code which asks for Username: Password: for authentication purpose currently we are passing the credential manually and run the script. but I am trying echo -e "user_id\npassword" | script.sh but its not... (1 Reply)
Discussion started by: rakeshtomar82
1 Replies

LEARN ABOUT DEBIAN

osql

osql(1) 							 FreeTDS Utilities							   osql(1)

NAME

       osql - utility to test FreeTDS connections and queries

SYNOPSIS

       osql  -S dsn -U username -P password [-I ini_dir]

DESCRIPTION

       osql  is a diagnostic tool provided as part of FreeTDS. It is a Bourne shell script that checks and reports on your configuration files. If
       everything checks out OK, it invokes isql.

       osql works only with the isql that comes with unixODBC.

OPTIONS

       -S dsn the Data Source Name to which to connect, as known to odbc.ini.

       -U username
	      database login name.

       -P password
	      database password.

       -I ini_dir
	      override odbc.ini file location.

EXAMPLE

       If you have an odbc.ini with a section like this:

	       [myDSN]
		       servername = myserver
		       TDS_Version = 5.0

       You would invoke osql as:

	       osql -S myDSN [...]

NOTES

       If you can connect with "osql -S servername -U user -P passwd", your FreeTDS ODBC installation is working.

       osql guesses where unixODBC might look for its odbc.ini by examining the binary. This is not always an effective approach.  If  it  doesn't
       work, you'll receive a report of candidate strings. Kindly pass along the output to help improve the guessing.

       If  osql  cannot intuit your odbc.ini directory, you can force the issue with the -I option. However, you're instructing osql what to test,
       not where unixODBC will eventually look. Your override is therefore only as good as you are. Look carefully  at	the  error  output  before
       overriding.

       If you have suggestions for ways to make osql more useful as a diagnostic tool, please post them to the FreeTDS mailing list.

HISTORY

       osql first appeared in FreeTDS 0.65.

AUTHORS

       The osql utility was written by James K. Lowden

doc								 13 November 2011							   osql(1)
All times are GMT -4. The time now is 05:22 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy