Search Results

Try:
echo "* 7 * * * asterisk -rx 'gsm send sms 1 7666 \"TM ON\"'" >> $CRON_PATH

i was just looking at this again and not seeing the mysql comand output that you showed as an example ... it seems your issue is that your script does not run the mysql command like alister said...

You're getting all those command not found errors because the pipes in the egrep pattern occur outside a quoted string. The shell is interpreting them and searching for the executables that match...

mysql>
mysql>
mysql> select * from sms_key;
+-------------+
| sms_keyword |
+-------------+
| IRC |
| PTM |
| ADM |
| BS |
+-------------+
4 rows in set...

use below code

tr '\n' '#' | sed 's/#/%,/g'

Instead of tr '\n' '%,'

Do not post classroom or homework problems in the main forums. Homework and coursework questions can only be posted in this forum (https://www.unix.com/homework-coursework-questions/) under special...

Dear jazzyzha,

I missed to add IN there. mysql -uroot -pabcde smsd -e "DELETE FROM inbox WHERE senderNumber = '$BLOCKLIST'" should be changed to mysql -uroot -pabcde smsd -e "DELETE FROM inbox...

sed 's:^0:+61:'

Did you notice the double quote in the last statement(...|mailx..) i.e. after $EMAIL_ADDRESS? is it a copy paste error or is there something wrong in the script itself?

--ahamed

EMAIL_ADDRESS="$( mysql -uroot -pgurlia001 smsd -N -s -r -e "SELECT email FROM recipient" | tr '\n' ' ')"


--ahamed

---------- Post updated at 02:17 AM ---------- Previous update was at 02:15...