mjhjmtu

Here is my command with IP's commented out with semanticIP's

ssh -p 2022 -L 9389:localRDPIP:3389 user@publicIP 
su -c "export HISTCONTROL=ignorespace; 
iptables -t nat -A PREROUTING -p tcp --dport 3389 -j DNAT --to-destination localRDP_IP:3389; 
iptables -t nat -A POSTROUTING -p tcp -d localRDP_IP --dport 3389 -j SNAT --to-source jumpIP";

basically, I'm trying to run some remote routing, which is not the question. The question is how do I run such a command?

The best test I've been able to do is:

ssh -p 2022 -L 9389:localRDPIP:3389 user@publicIP -t "su -c nano; nano"

but I don't know how to do the spaces. If I have spaces in my commands in the -c "quoted area" other than a single command, I get an error.

Note: I realize that with ssh port forwarding, iptables commands may be unnecessary.

As shown in the man page for su (man su) the -c option takes a single shell command, passed to your current shell for execution by its -c command:

-c, --command COMMAND Specify a command that will be invoked by the shell using its -c.

And then from bash:

If the -c option is present, then commands are read from the first non-option argument _command_string_. If there are arguments after the _command_string_, the first argument is assigned to $0 and any remaining arguments are assigned to the positional parameters.

The upshot of this is that you cannot use -c with multiple commands.

However, there is nothing stopping you providing a shell as the command to be run by -c and using that to handle the multiple commands:

ssh -p 2022 -L 9389:localRDPIP:3389 user@publicIP su -c bash -c '
 export HISTCONTROL=ignorespace;
 iptables -t nat -A PREROUTING -p tcp --dport 3389 -j DNAT --to-destination localRDP_IP:3389;
 iptables -t nat -A POSTROUTING -p tcp -d localRDP_IP --dport 3389 -j SNAT --to-source jumpIP
'

I'm not entirely sure what you want to achieve with your second command, though. At the moment it's set up to run nano as the root user, and then to run it again as your own account. Is this what you wanted? Or did you want to run nano twice as the root user, like this:

ssh -p 2022 -L 9389:localRDPIP:3389 user@publicIP -t su -c bash -c 'nano; nano'

psql (and by extension mysql) had a similar limitation. While reading documentation on psql, I came across this

-c command
--command=command
Specifies that psql is to execute one command string, command, and then exit. This is useful in shell scripts. Start-up files (psqlrc and ~/.psqlrc) are ignored with this option.

command must be either a command string that is completely parsable by the server (i.e., it contains no psql-specific features), or a single backslash command. Thus you cannot mix SQL and psql meta-commands with this option. To achieve that, you could pipe the string into psql, for example: echo 'x SELECT * FROM foo;' | psql. ( is the separator meta-command.)

If the command string contains multiple SQL commands, they are processed in a single transaction, unless there are explicit BEGIN/COMMIT commands included in the string to divide it into multiple transactions. This is different from the behavior when the same string is fed to psql's standard input. Also, only the result of the last SQL command is returned.

Because of these legacy behaviors, putting more than one command in the -c string often has unexpected results. It's better to feed multiple commands to psql's standard input, either using echo as illustrated above, or via a shell here-document, for example:

psql <<EOF
x
SELECT * FROM foo;
EOF

for my case, I merely modified my echo statement

echo drop database if exists somedb; create database somedb;drop table if exists ur_table; CREATE TABLE ur_table (timestamp date, open real, high real,low real,close real,adjusted_close real,volume real,dividend_amount real,split_coefficient real,CONSTRAINT timestamp_pkey PRIMARY KEY (timestamp)); COPY ur_table(timestamp,open,high,low,close,adjusted_close,volume,dividend_amount,split_coefficient) FROM 'c:testtemp.csv' DELIMITER ',' CSV HEADER;| psql -U postgres