Help Required - facing error when trying to connect to a mysql by ssh to another server
Hi
i am new to unix shell scripting i have the below requirement
connect to server B and then connect to mysql in the server B and query for a particular record and capture that value
but when i perform this i am facing an error
can u guys help me on this
Code:
$(ssh user@serverB<< EOF1
getCycleID=$(mysql -uehpoll -pqanra5 -s -N<< EOF
use EdgeHealth;
/* Query to get the last cycle_id that is in ready to collect state for cmts cycle type*/
select max(cycle_id) from polling_cycles where cycle_type="cmts" and collection_status="ready_to_collect"
EOF
)
EOF1
)
echo $getCycleID
when executing the above script facing the below error
Error
Code:
./Collector_Poller.sh: line 2: /[: Permission denied
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
./Collector_Poller.sh: line 4: user@ServerB: command not found
Hi,
I am trying to run the below command in perl but when the perl script is executed it prompts a error message saying " ssh: <username>: Name or service not known ". Not able to understand this as this command runs perfectly on the server prompt.
` ssh <username>@pus4026dev df -k >>... (2 Replies)
hi,
i have script that connects to a unix server. however, i want to add condition that if it cannot connects in 10 attemps, it will send email to me.
while -a ${COUNT} -lt 10]
./connect to server.
if status <> 0 then
email to me.
fi
Thanks a lot. (0 Replies)
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)
Hi everyone,
I have an urgent requirement to get some table data from Linux-MYSQL server from HP-UX with oracle database.Is there any way we can get
connected through Shell script from HP-UX and issue select on mysql to get some table data?
Please help me out. (7 Replies)
I have a task requiring that USER_A run a script, which connects to HOST_B as USER_B and does not ask for a password.
If I am logged in on HOST_A as USER_B, I can connect to HOST_B without a password, no problem. However, if I try running ssh with the command line "ssh USER_B@HOST_B" while... (3 Replies)
Hi ,
I am trying to install mysql but getting below error
$# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
can anyone provide me this file 'mysql.sock'
Thanks (6 Replies)
I am able to connect a RHEL server from my Windows machine using Putty (via ssh). My question is what is the advantage of using Xming instead of Putty? Is it that Xming would enable a graphical connect from the Windows machine to RHEL server?
I hope my question is clear that what is the... (9 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)
Discussion started by: sunil seelam
5 Replies
LEARN ABOUT SUNOS
ssh-socks5-proxy-connect
ssh-socks5-proxy-connect(1) User Commands ssh-socks5-proxy-connect(1)NAME
ssh-socks5-proxy-connect - Secure Shell proxy for SOCKS5
SYNOPSIS
/usr/lib/ssh/ssh-socks5-proxy-connect [-h socks5_proxy_host] [-p socks5_proxy_port] connect_host connect_port
DESCRIPTION
A proxy command for ssh(1) that uses SOCKS5 (RFC 1928). Typical use is where connections external to a network are only allowed via a socks
gateway server.
This proxy command does not provide any of the SOCKS5 authentication mechanisms defined in RFC 1928. Only anonymous connections are possi-
ble.
OPTIONS
The following options are supported:
-h socks5_proxy_host Specifies the proxy web server through which to connect. Overrides the SOCKS5_SERVER environment variable.
-p socks5_proxy_port Specifies the port on which the proxy web server runs. If not specified, port 80 is assumed. Overrides the
SOCKS5_PORT environment variable.
OPERANDS
The following operands are supported:
socks5_proxy_host The host name or IP address (IPv4 or IPv6) of the proxy.
socks5_proxy_port The numeric port number to connect to on socks5_proxy_host.
connect_host The name of the remote host to which the socks gateway is to connect you.
connect_port The numeric port number of the socks gateway to connect you to on connect_host.
EXAMPLES
The recommended way to use a proxy connection command is to configure the ProxyCommand in ssh_config(4) (see Example 1 and Example 2).
Example 3 shows how the proxy command can be specified on the command line when running ssh(1).
Example 1: Setting the proxy from the environment
The following example uses ssh-socks5-proxy-connect in ssh_config(4) when the proxy is set from the environment:
Host playtime.foo.com
ProxyCommand /usr/lib/ssh/ssh-socks5-proxy-connect
playtime.foo.com 22
Example 2: Overriding proxy environment variables
The following example uses ssh-socks5-proxy-connect in ssh_config(4) to override (or if not set) proxy environment variables:
Host playtime.foo.com
ProxyCommand /usr/lib/ssh/ssh-socks5-proxy-connect -h socks-gw
-p 1080 playtime.foo.com 22
Example 3: Using the command line
The following example uses ssh-socks5-proxy-connect from the ssh(1) command line:
example$ ssh -o'ProxyCommand=/usr/lib/ssh/ssh-socks5-proxy-connect
-h socks-gw -p 1080 playtime.foo.com 22' playtime.foo.com
ENVIRONMENT VARIABLES
SOCKS5_SERVER Takes socks5_proxy_host operand to specify the default proxy host.
SOCKS5_PORT Takes socks5_proxy_port operand to specify the default proxy port.
EXIT STATUS
The following exit values are returned:
0 Successful completion.
1 An error occurred.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWsshu |
+-----------------------------+-----------------------------+
|Interface Stability |Stable |
+-----------------------------+-----------------------------+
SEE ALSO ssh(1), ssh-http-proxy-connect(1), ssh_config(4), attributes(5)SunOS 5.10 30 Oct 2002 ssh-socks5-proxy-connect(1)
11-19-2014
Help Required - facing error when trying to connect to a mysql by ssh to another server
