Dear all!
Has anybody an advice how to insert *sent* SMS from the KANNEL
"bearerbox" into an MySQL Database?
For a simple test I defined the tag "access-log" in the core group:
group = core
...
access-log = "var/log/kannel/access.log"
The access.log file collects all sent/received SMS and looks like below:
2011-03-29 09:32:44 Log begins
2011-03-29 09:33:39 Receive SMS [SMSC:smsc-x] [SVC:] [ACT:] [BINF:]
[FID:] [from:+43xxx] [to:+43yyy] [flags:-1:0:-1:0:-1] [msg:8:A Incoming]
[udh:0:]
2011-03-29 09:33:41 Sent SMS [SMSC:smsc-x] [SVC:^[ ]*(a)[ ]*] [ACT:]
[BINF:] [FID:] [from:+43yyyy] [to:+43xxx] [flags:-1:0:-1:-1:-1]
[msg:31:Outgoing] [udh:0:]
2011-03-29 09:37:27 Log ends
But I need something similar to my received SMS Script:
---
That was an quite easy task, I did it via an cgi Script in the "group =
sms-service":
group = sms-service
keyword = A
get-url =
http://hostname/cgi-bin/smsrxdb.cgi?time=%t&rx_phonenr=%p&tx_phonenr=%P&sendsms_user=%n&text=%a
(=>The script connects to a MySQL Database and inserts all the values
into a "sentsms" table)
---
Thanks very much in advance for your help!!!
Kind regards,
Kurt
