Hi, could you give me a little idea of how to do this, I'll tell you.

I'm doing a bash script in which I make a query to the database and the result goes through it with a cycle

something like that:
but since I remotely connect to another computer by ssh and run a local script.

-------------main script---------------------------------------
mysql -u${username} -p${password} -D${database} -n <<<'SELECT row FROM BD.Tbl' 2>/dev/null |
while IFS='\n' read row; do
if [[ ${row} != "row" ]]; then
echo $row

ssh PCB@ x.x.x.x 'bash -s' < script.sh $row
fi
done
-------------------------------------------
the problem I have is the following within the script.sh I get information that I want to store in a database, how could I insert it into this script
so I don't have to make another connection, since I think I could use the same mysql object I have :

PCA - Server

PCB - I get the information and want to save it on the PCA team as I could do it.

the script.sh has the following structure:

#! /usr/bin/env bash

declare -a StrMo=($(free -m | sed -n 1!p |sed -n 1p | sed s/Mem://g));

strOpen="("
strClose=")"

strTotal="${StrMo[@]:0:1}"

strQuery="$strOpen '$strTotal' strClose"

the strQuery variable I want to store in the database.

I'll keep you posted, thank you.

and when I run the main script it gets me the following message:
ssh: Could not resolve hostname : Name or service not known

(bold added for emphasis only)
Did you not understand the bolded line? It's telling you specifically that it can't resolve that name in DNS, or the IP address can't be reached. And have you looked at the mysql command or read the man pages? The -H option tells you specifically how to connect to a remote host directly, with no need for an SSH-and-script-run.

I think I don't understand is you because I specifically made it clear that I want to connect to several computers on a network and what I want to do is I want the result of you pulling out once you connect the computer by ssh to insert it into a database but I don't want to connect to computer B to insert it into computer A but I want the result of computer B to insert it into the database locally, I said to myself now if I understood?

and the SSH error appears when I try to connect through SSH when I send the IP and the execution of the Local script, the IP has the port enabled and I don't know why the error is thrown to me.

Translated with www.DeepL.com/Translator

Nope, sorry...you aren't clear at all, and your 'solution' is still poor. If you want to insert things into your local DB from a remote DB, you can AGAIN call the remote DB directly, download whatever data you want **WITHOUT SSH SCRIPTS**, then manipulate that data for insertion locally.
Right; again, either you're using a host name that DNS can't resolve, or something is blocking the IP address (bad route, wrong address, whatever). The error is very clear.

@OP: Also the artificial translation (and the lack of [code] and [/code] tags) makes your posts virtually incomprehensible.

1 members found this post helpful.