gsethi: Operating system name and version: windows xp
Version of smsd: 3.1.14
Smsd installed from: sources :http://smstools3.kekekasvi.com
Name and model of a modem / phone: HUAWEI E353
Interface: USB mapped as com 15
The event handler is not able to execute the linked file.
gives the following error: Fatal error: execv( /bin/sh ) returned: 13, Permission denied
2012-02-06 23:13:58,6, GSM3: Trying to get stored message 1
2012-02-06 23:13:58,7, GSM3: -> AT+CMGR=1
2012-02-06 23:13:58,7, GSM3: Command is sent, waiting for the answer
2012-02-06 23:13:59,7, GSM3: <- +CMGR: 0,,43 0791198951509171240C911989277855990000212060322162221B0D4543212D9FC372F2BCA13886EBF2B01D342DD3D1E98602 OK
2012-02-06 23:13:59,5, GSM3: SMS received, From: 919872875599
2012-02-06 23:13:59,6, GSM3: Wrote an incoming message file: /var/spool/sms/incoming/GSM3.2i8dmP
2012-02-06 23:13:59,7, GSM3: Running eventhandler: /usr/local/bin/sql.sh RECEIVED /var/spool/sms/incoming/GSM3.2i8dmP
2012-02-06 23:13:59,2, GSM3: Fatal error: execv( /bin/sh ) returned: 13, Permission denied
2012-02-06 23:13:59,3, GSM3: Done: eventhandler, execution time 0 sec., status: 3328 (13)
2012-02-06 23:13:59,6, GSM3: ALERT (continues, 2): problem with eventhandler, result 13
2012-02-06 23:13:59,6, GSM3: Deleting message 1
2012-02-06 23:13:59,7, GSM3: -> AT+CMGD=1
2012-02-06 23:13:59,7, GSM3: Command is sent, waiting for the answer
2012-02-06 23:13:59,7, GSM3: <- OK
The Config file is :
# Example smsd.conf. Read the manual for a description
devices = GSM3
executable_check = no
logfile = /var/log/smsd.log
loglevel = 10
sent = /var/spool/sms/sent
failed = /var/spool/sms/failed
report = /var/spool/sms/report
stats = /var/spool/sms/stats
suspend = /var/spool/sms/suspend.txt
eventhandler = /usr/local/bin/sql.sh
[GSM3]
#device = /dev/ttyUSB1
device = /dev/com15
#init2 = AT^CURC=0
init = AT+CNMI=2,1,2,2,0
incoming = yes
report_device_details = yes
report = yes
pin = 0000
baudrate = 115200
memory_start = 0
check_memory_method = 2
#smsc = +919417099997
And the event handler has to run the following file
#!/bin/bash
number=1
date >> RightNow.txt
#
#Define the database parameters
SQL_HOST=localhost
SQL_USER=root
SQL_PASSWORD=
SQL_DATABASE=gauravsethi
SQL_TABLE=user
FROM=god
TEXT="with love"
#run this script only when a message was received.
#if [ "$1" != "RECEIVED" ]; then exit; fi;
#
#Set some SQL parameters
if [ "$SQL_PASSWORD" != "" ]; then
SQL_ARGS="-p $SQL_PASSWORD";
else
SQL_ARGS="";
fi
#echo $SQL_ARGS
SQL_ARGS="-h $SQL_HOST -u $SQL_USER $SQL_ARGS -D $SQL_DATABASE -s -e"
#echo $SQL_ARGS
#
#Do the SQL Query
#echo $FROM
#echo $TEXT
AMOUNT=`mysql $SQL_ARGS "SELECT id FROM inbox WHERE msgid = \"3101646\" ;"`
#echo $AMOUNT
#
#Create an answer with the amount
FILENAME=`mktemp /var/spool/sms/outgoing/answerXXXXXX.txt`
echo "To: $FROM" >$FILENAME
echo "" >> $FILENAME
echo "Your amount is $AMOUNT from $FROM text $TEXT one $1 two $2 three $3 four $4 five $5 six $6 seven $7 eight $8 nine $9 ten $10 eleven $11 " >>$FILENAME
exit
|
