Read SQLBOX from userguide. On Tue, Mar 29, 2011 at 2:06 PM, Kurt Quehenberger <[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 > (=>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 > >
