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: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of ha...@aeon.pk Sent: Tuesday, March 29, 2011 11:34 AM To: kurt.quehenber...@gmx.at Cc: users@kannel.org 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 <kurt.quehenber...@gmx.at<mailto:kurt.quehenber...@gmx.at>> 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
