You're absolutely right, Ahmed!
There's no information about sqlbox in the kannel userguide.
But I found that there's a documentation included in the source code, or
just try the following link:
http://www.blogalex.com/archives/46
Best regards,
Kurt
Am 2011-03-29 12:47, schrieb Ahmed Shabana:
Can not find any SQLBOX guide at user guide ,
Please could u provide us with any sqlbox guide
___________________________________
___ _ _ __ ___ __ _ _ __
/ __)( )( ) ( ) ( ,) ( ) ( \( ) ( )
\__ \ )__( /__\ ) ,\ /__\ ) ( /__\
(___/(_)(_)(_)(_)(___/(_)(_)(_)\_)(_)(_)
Have fun. Don't forget to bookmark this website :)
*From:*[email protected] [mailto:[email protected]] *On
Behalf Of *[email protected]
*Sent:* Tuesday, March 29, 2011 11:34 AM
*To:* [email protected]
*Cc:* [email protected]
*Subject:* Re: Kannel access-log / sent SMS insert to MySQL?
Read SQLBOX from userguide.
On Tue, Mar 29, 2011 at 2:06 PM, Kurt Quehenberger
<[email protected] <mailto:[email protected]>> wrote:
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
<http://hostname/cgi-bin/smsrxdb.cgi?time=%25t&rx_phonenr=%25p&tx_phonenr=%25P&sendsms_user=%25n&text=%25a>
(=>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
