cat file over ssh and put it into log file

sinister1 · 04-23-2009, 10:24 AM

Hai,

I want to open a few files on different server and collect them local to one server:

The server where i want to collect the files are in a database. From this database i'm getting the ipaddress trough a commandline mysql command.

the $1 is the Unique ID of the server where i want to collect.

Code:

USERID=root
PASSWD=
QUERY="SELECT ip FROM servers WHERE id=\"$1\";"

IP=`mysql -u "$USERID" -p"$PASSWD" DATABASE_1 -e "$QUERY" -s`

echo "$IP"
tunnel1=`ssh root@"$IP" "cat /root/file"`
echo "$tunnel1" > test.list

When i execute the script from the commandline everything works fine but when i want to call my script from a website(php) the $tunnel1 remains empty.

Does anyone have a idea?

thanks

rriggs · 04-23-2009, 11:29 AM

That's a dangerous thing to be doing from a web app -- running with root privileges on another box. The problem is quite likely that the user that your web server is running as cannot log in as root on the remote machine.

sinister1 · 04-24-2009, 12:54 AM

So the best thing to do is to ssh trough the webuser (www-data)?