Myujth

everyone!

I have a trouble with executing .sh script from browser.
echo command works well. But when I store the value in variable and pass it to another script as an argument it does not work.
Appreciate any help.

Example:

Here I pass $XX to another script

if [ -z "$QUERY_STRING" ]; then
 exit 0

else

 XX=`echo "$QUERY_STRING" | sed -n 's/^.*val_x=([^&]*).*$/1/p' | sed "s/%20/ /g"`
 if [ -z "$XX" ]; then
 echo "X is empty"
 else

 echo "Processing..."
 /sas/oljas_scripts/find_usage_of_tables.sh $XX
 echo "Done"
 fi

 YY=`echo "$QUERY_STRING" | sed -n 's/^.*val_y=([^&]*).*$/1/p' | sed "s/%20/ /g"`
 ZZ=`echo "$QUERY_STRING" | sed -n 's/^.*val_z=([^&]*).*$/1/p' | sed "s/%20/ /g"`
 echo "val_x: " $XX
 echo '<br>'
 echo "val_y: " $YY
 echo '<br>'
 echo "val_z: " $ZZ

fi

The file you are trying to execute, /sas/oljas_scripts/find_usage_of_tables.sh, is not executable for the web server. Currently, it is:

-rwxrw-r-- 1 sas sas 1540 Nov 12 12:58 find_usage_of_tables.sh

Which means sas user can do everything, sas group can read and write but not execute, and everyone else can just read. Notably, the web server needs to be able to both read and execute the file, and it is failing to do so.

Either set the file to be readable and executable to all (not recommended):

chmod 755 /sas/oljas_scripts/find_usage_of_tables.sh

or set the group of the file to be a group the web server is in, and set the group permissions of the file accordingly:

chmod 754 /sas/oljas_scripts/find_usage_of_tables.sh
chgrp www-data /sas/oljas_scripts/find_usage_of_tables.sh

You may need sudo for the latter. Also, the web server's group name might not be www-data - inspect your web server configuration, or read it off of process list like this answer suggests.