02-28-2017
Beware that any process to encrypt/decrypt is open to abuse if someone can read the script and work out where the password/key is stored and can read that. There are various ways to encrypt data, but the tough part is having a decryption process that is not decipherable.
For example, you could make a file difficult to read by compressing it and using a non-obvious file name, however anyone reading your decryption process would spot it is a simple decompression and be able to read your data.
If ETL stands for Extract, Transform, Load as three database functions, you need to say what tools you are using in each of the stages and where the data will be stored at each point. Are you transferring data from one server to another perhaps?
Robin
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
how do i encrypt and decrypt a password (2 Replies)
Discussion started by: sanwish
2 Replies
2. Solaris
Help..
I need to decrypt a file that was encrypted using DES 56 Bit.
I have the encryption key and the block size used but no idea what utility to use..
I then need to encrypt the file using pgp and another key I have.. againt I dont know what utility to use.
I am running solaris 9 ....
... (0 Replies)
Discussion started by: frustrated1
0 Replies
3. Shell Programming and Scripting
Dear Experts,
I am using one script name :volume.sh and its written in bash shell script.
I just want to encrypt the script so that any one else cannot see it.
please tell me the commands how to encrypt the script as well as to decrypt it.
Regards,
SHARY (9 Replies)
Discussion started by: shary
9 Replies
4. Shell Programming and Scripting
How to encrypt and decrypt a file using unix Command?
Can any one help me? (2 Replies)
Discussion started by: laknar
2 Replies
5. Shell Programming and Scripting
Hi, I want to encrypt and decrypt a string(database password) which will be used in my scripts.
encrypt the string while storing in a file and while using it in other scripts
it should decrypt.
i tried below method. As it can decrypt easily, it is not recommended.
encrypt=`perl -e 'print unpack... (5 Replies)
Discussion started by: rohan10k
5 Replies
6. Shell Programming and Scripting
I have script for all oracle prod db. I have hard coded the username / password. I need a mechanism to encode and decode the username / password in a shell script.
Another challenge is I use the username and password in a Select command for oracle DB. How can call the decrypted... (2 Replies)
Discussion started by: ilugopal
2 Replies
7. Shell Programming and Scripting
Hi All,
I have stored Oracle database passwords in a hidden file - .pass_file.
My shell script reads the hidden file, gets the password and then logs in to the Oracle database and runs some SQL script.
My requirement is:
I need to provide the shell script to be executed by someone else. So,... (1 Reply)
Discussion started by: sunpraveen
1 Replies
8. Shell Programming and Scripting
Hi All,
very good morning all.
I am trying to connect to informatica repository by using shell script.
I have written pmrep connect command in the script file. But i need to provide repository, domain ,username and password to connect. Username and password are hard coded in the script... (8 Replies)
Discussion started by: SekhaReddy
8 Replies
9. Programming
Hi All,
Can I use MCRYPT - (RIJNDAEL-128) / CBC mode to encrypt and decrypt a file?
I am trying to find some sample C program on internet, which will encrypt and decrypt a file. But was not able to find any thing.
Can some help me with the programming.
Thanks. (1 Reply)
Discussion started by: Shre
1 Replies
10. Shell Programming and Scripting
Hello,
I have the following UNIX shell script which connects to the teradata database and executes the SQL Queries. For this, I am passing database name, username and password. I don't want to reveal my password to anyone. So, is there any way that I can encrypt my password and read the... (2 Replies)
Discussion started by: ronitreddy
2 Replies
LEARN ABOUT DEBIAN
proxytunnel
PROXYTUNNEL(1) General Commands Manual PROXYTUNNEL(1)
NAME
proxytunnel - program to tunnel a connection throught an standard HTTPS proxy.
SYNOPSIS
proxytunnel [options]
DESCRIPTION
This manual page documents the proxytunnel command.
proxytunnel is a program that open a tunnel through a HTTPS proxy.
OPTIONS
This program follow the usual GNU command line syntax, with long options starting with two dashes (`-').
-h, --help
Print help and exit.
-V, --version
Print the version of the program and exit.
-i, --inetd
Run from inetd. Default is off.
-a PORT, --standalone=PORT
Run as standalone daemon on specified port.
-p host:port, --proxy=host:port
The local HTTPS proxy host:port combo to connect to.
-r host:port, --remproxy=host:port
The second-level (remote) proxy host:port to connect to when using two proxies.
-d host:port, --dest=host:port
The destination host:port to built the tunnel to.
-e, --encrypt
Encrypt the data between the local proxy and the destination using SSL.
-E, --encrypt-proxy
Encrypt the data between the client and the local proxy using SSL.
-B, --buggy-encrypt-proxy
Encrypt the data between the client and the local proxy using SSL, but stop using SSL immediately after the CONNECT exchange to
workaround server bugs. (Might not work on all setups; see /usr/share/doc/proxytunnel/README.Debian.gz for more details.)
-X, --encrypt-remproxy
Encrypt the data between the local proxy and the second-level proxy using SSL.
-F STRING, --passfile=STRING
The file containing Username & Password to send to HTTPS proxy for authentification. This file uses the same format as .wgetrc, and
so can use the credentials in common with wget. This option can be used to at least hide the password from anyone clever enough to
use the `ps' command.
-P user:pass, --proxyauth=user:pass
The credentials to use for local HTTP(S) proxy authentication.
-R user:pass, --remproxyauth=user:pass
The credentials to use for remote HTTP(S) proxy authentication.
-N, --ntlm
Use NTLM-based authentication.
-t DOMAIN, --domain=DOMAIN
The NTLM domain to use, default is to autodetect.
-H STRING, --header=STRING
Additional HTTP headers to send to the proxy.
-x STRING, --proctitle=STRING
Use a different process title.
-v, --verbose
Turn on verbosity. Default is off.
-q, --quiet
Suppress messages. Default is off.
NOTES
To use this program with OpenSSH to connect to a host somewhere, create a $HOME/.ssh/config file with the following content:
Host foobar
ProtocolKeepAlives 30
ProxyCommand /usr/bin/proxytunnel -p proxy.customer.com:8080
-P user:password -d mybox.athome.nl:443
If your proxy doesn't require the username and password for using it, you can skip these options.
If you want to run proxytunnel from inetd add the '--inetd' option.
Most HTTPS proxies do not allow access to ports other than 443 (HTTPS) and 563 (SNEWS), so some hacking is necessary to start the SSH dae-
mon on the required port. (On the server side add an extra Port statement in the sshd_config file)
AUTHOR
This manual page was written by Loic Le Guyader <loic.leguyader@laposte.net> and updated by Julian Gilbey <jdg@debian.org> for the Debian
GNU/Linux system (but may be used by others).
August 30, 2009 PROXYTUNNEL(1)