This will log into a server with ssh and run a script file from your computer with the BASH shell. You can substitute whatever shell you want as long as the server has it.
This will of course still ask for a password. If you want to login with no password, you can use a pre-shared key.
i want to connect to a remote server through ssh.
i have to also provide password within that script.
after connecting to the remote server i want to do some operations like grep,cd etc
can u pls help me to wite a script.
Thanks (1 Reply)
Hello,
Can you help me to write a shell script for rsync a folder from my server to remote server ?
i do this in ssh by this command :
rsync -avz -e ssh /copy/me/ login@serverip:/where/to
i want have a shell script that do this command.
and you know that this command ask remote... (0 Replies)
Hi Unix Gurus,
I have a doubt reg file transfer. I have used the below script to connect to another server and find files having modified for the last 24 hours and have to move the file to another server.
While i tried i am getting authentication failed, destination path not found issue.
... (2 Replies)
Hi all,
I need to connect to SQL server from shell script. Then need to execute queries from shell script. Kindly let me know on how to do this
Thanks,
Ananthi.U (1 Reply)
Hi all,
I need to connect to SQL server from shell script. Then need to execute queries from shell script as below
1. To compare values of an array with SQL table's entry.
Kindly let me know on how to do this
Thanks,
Double post. Continue here (0 Replies)
Hi all,
I need to connect to SQL server from shell script. Then need to execute queries from shell script as below
1. To compare values of an array with SQL table's entry.
I am using solaris-5.1 to run shell script and want to connect to SQL-5.1 which is installed on SantOS.
Kindly let... (3 Replies)
I am trying to connect to Windows server via Linux server through a script and run two commands " cd and ls " But its giving me error saying " could not start the program" followed by the command name i specify e g : "cd"
i am trying in this manner "
ssh username@servername "cd... (5 Replies)
Dear Experts,
I am new to the shell scripting.
I am looking for a shell script to connect to one Unix/Linux server1 to other Unix/Linux server2 and trigger a SAP Event in that server2 (Which will trigger a job in SAP).
Is this possible to connect from one server to the other server securely... (7 Replies)
Hi all,
I have a code to create folder in application server through shell script and i want to create if conditional based folder
folder=$HOME/test/sample/whatever
if ; then
echo "$folder already exists, not created."
else
mkdir -p "$folder" > /dev/null 2>&1
... (7 Replies)
Hi,
I am facing an issue in connecting to database from Linux shell script. Here is my code
export ORACLE_BASE=xxx
export ORACLE_SID=xxx
export ORACLE_HOME=xxxx
DB_PATH=xxx/'yyy@yy'
UserId=`sqlplus -s $DB_PATH <<EOF
set head off feedback off
select max(USER_ID)+1 from USERS;... (6 Replies)
Discussion started by: yuvi
6 Replies
LEARN ABOUT OSX
dbd::gofer::transport::stream
DBD::Gofer::Transport::stream(3) User Contributed Perl Documentation DBD::Gofer::Transport::stream(3)NAME
DBD::Gofer::Transport::stream - DBD::Gofer transport for stdio streaming
SYNOPSIS
DBI->connect('dbi:Gofer:transport=stream;url=ssh:username@host.example.com;dsn=dbi:...',...)
or, enable by setting the DBI_AUTOPROXY environment variable:
export DBI_AUTOPROXY='dbi:Gofer:transport=stream;url=ssh:username@host.example.com'
DESCRIPTION
Without the "url=" parameter it launches a subprocess as
perl -MDBI::Gofer::Transport::stream -e run_stdio_hex
and feeds requests into it and reads responses from it. But that's not very useful.
With a "url=ssh:username@host.example.com" parameter it uses ssh to launch the subprocess on a remote system. That's much more useful!
It gives you secure remote access to DBI databases on any system you can login to. Using ssh also gives you optional compression and many
other features (see the ssh manual for how to configure that and many other options via ~/.ssh/config file).
The actual command invoked is something like:
ssh -xq ssh:username@host.example.com bash -c $setup $run
where $run is the command shown above, and $command is
. .bash_profile 2>/dev/null || . .bash_login 2>/dev/null || . .profile 2>/dev/null; exec "$@"
which is trying (in a limited and fairly unportable way) to setup the environment (PATH, PERL5LIB etc) as it would be if you had logged in
to that system.
The ""perl"" used in the command will default to the value of $^X when not using ssh. On most systems that's the full path to the perl
that's currently executing.
PERSISTENCE
Currently gofer stream connections persist (remain connected) after all database handles have been disconnected. This makes later
connections in the same process very fast.
Currently up to 5 different gofer stream connections (based on url) can persist. If more than 5 are in the cache when a new connection is
made then the cache is cleared before adding the new connection. Simple but effective.
TO DO
Document go_perl attribute
Automatically reconnect (within reason) if there's a transport error.
Decide on default for persistent connection - on or off? limits? ttl?
AUTHOR
Tim Bunce, <http://www.tim.bunce.name>
LICENCE AND COPYRIGHT
Copyright (c) 2007, Tim Bunce, Ireland. All rights reserved.
This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. See perlartistic.
SEE ALSO
DBD::Gofer::Transport::Base
DBD::Gofer
perl v5.16.2 2010-12-21 DBD::Gofer::Transport::stream(3)