I have a problem with smstools
when i send a sms to a modem, sms modem can not get into the database (sms_log) overall. sms_log does not show sender, recipient, message content, time sent and time received, but only show MSGID and the status of send / receive
this my sms.conf
_________________________________________________
devices = GSM1
outgoing = /var/spool/sms/outgoing
checked = /var/spool/sms/checked
failed = /var/spool/sms/failed
incoming = /var/spool/sms/incoming
sent = /var/spool/sms/sent
mypath = /usr/local/bin
logfile = /var/log/smsd.log
loglevel = 7
alarmlevel = 4
delaytime = 5
errorsleeptime = 5
blocktime = 3600
receive_before_send = no
# autosplit 0=no 1=yes 2=with text numbers 3=concatenated
autosplit = 3
[GSM1]
init = ATE0+CPMS="SM"
device = /dev/ttyUSB1
incoming = yes
mode = new
smsc = 6281100000
baudrate = 115200
rtscts = yes
cs_convert = yes
report = no
memory_start = 1
eventhandler = /usr/local/bin/smsbmsf
________________________________________________________
this is my smsbmf
________________________________________________________
#!/bin/sh
SQL_HOST=localhost
SQL_USER=adirusito
SQL_PASSWORD='adirusito123!'
SQL_DATABASE='sms'
SQL_TABLE=sms_log
SQL_TABLE_OUT=sms_out
DATE=`date +"%Y-%m-%d %H:%M:%S"`
FROM=`formail -zx From: < $2 | sed 's/"//g'`
TO=`formail -zx To: < $2`
SUBJECT=`formail -zx Subject: < $2`
SENT=`formail -zx Sent: < $2`
TEXT=`formail -I "" <$2`
LOGFILE="$(basename $2)"
if [ "$SQL_PASSWORD" != "" ]; then
SQL_ARGS="-p$SQL_PASSWORD";
else
SQL_ARGS="";
fi
SQL_ARGS="-h $SQL_HOST -u $SQL_USER $SQL_ARGS -D $SQL_DATABASE -s -e"
if [ "$1" = "FAILED" ] || [ "$1" = "SENT" ]; then
mysql $SQL_ARGS "insert into $SQL_TABLE (type,sent,sender,receiver,msgid,messages) values (\"$1\",\"$DATE\",\"$FROM\",\"$TO\",\"$LOGFILE\",TRIM(\"$TEXT\"));";
mysql $SQL_ARGS "UPDATE sms_out SET sent=\"$DATE\",type=\"$1\",stat='1' WHERE msgid=\"$LOGFILE\" AND tono=\"$TO\";";
elif [ "$1" = "RECEIVED" ]; then
mysql $SQL_ARGS "insert into $SQL_TABLE (type,sent,received,sender,receiver,msgid,messages) values (\"RECEIVED\",\"$SENT\",\"$DATE\",\"$FROM\",\"$SUBJECT\",\"$LOGFILE\",TRIM(\"$TEXT\"));";
elif [ "$1" = "REPORT" ]; then
DISCHARGE=`sed -e 1,7d < $2 | formail -zx Discharge_timestamp:`
MSGID=`sed -e 1,7d < $2 | formail -zx Message_id:`
STATUS=`sed -e 1,7d < $2 | formail -zx Status: | cut -f1 -d,`
ID=`mysql $SQL_ARGS "select id from $SQL_TABLE where receiver=\"$FROM\" and type=\"SENT\" and msgid=\"$MSGID\" order by id desc limit 1;"`
mysql $SQL_ARGS "update $SQL_TABLE set received=\"$DISCHARGE\",status=\"$STATUS\" where id=\"$ID\";"
fi
____________________________________________________________________________
I need your Help
thank
