You need to use INSERT statement and directly insert into send_sms table or alternatively you can put sqlbox between smsbox and bearerbox, this way message sent through smsbox (HTTP call) should be logged into sqlbox.
2013/5/22 hans joachim <[email protected]> > > Hello, > > I know what the different fields in sent_sms table mean. > But there is no data in the fields when I send a message via HTTP-Call. > > The database table is not filled. That is the problem. > > > *Gesendet:* Mittwoch, 22. Mai 2013 um 12:08 Uhr > *Von:* spameden <[email protected]> > *An:* "hans joachim" <[email protected]> > *Cc:* "Ali Kashif" <[email protected]>, "[email protected]" < > [email protected]>, "Florian Klein" <[email protected]> > *Betreff:* Re: Re: SQLBOX doesnt store SMS in database > > > 2013/5/22 hans joachim <[email protected]> >> >> Hello Ali, >> >> I am aware of the feature of bulk message sending with SQL Injection of >> SQLBOX. >> >> But that is not the feature I want. I only need the storing of >> information about outgoing messages for accounting purposees. >> That means I want the following information in the database (Just like >> the information in the access.log): >> >> - Date >> > time field in sent_sms table > >> - Recipient >> > receiver > > >> - SMSC >> > smsc_id > > >> - Message >> > msgdata (url-encoded) > >> >> I don't know how to accomplish this goal. If SQLBOX is not the right way, >> what can i do ? >> DLR's are depending of the provider I think.... >> >> Bye >> >> *Gesendet:* Mittwoch, 22. Mai 2013 um 11:28 Uhr >> *Von:* "Ali Kashif" <[email protected]> >> *An:* "Florian Klein" <[email protected]> >> *Cc:* "[email protected]" <[email protected]> >> *Betreff:* Re: SQLBOX doesnt store SMS in database >> Please always CC to users. >> >> On Wed, May 22, 2013 at 8:30 AM, Florian Klein >> <[email protected]>wrote: >>> >>> Hello Ali, >>> >>> I am aware of the feature of bulk message sending with SQL Injection of >>> SQLBOX. >>> >>> But that is not the feature I want. I need the storing of information >>> about outgoing messages only for accounting purposees. >>> That means I want the following information in the database: >>> >>> - Date >>> - Recipient >>> - SMSC >>> - Message >>> >>> I don't know how to accomplish this goal. If SQLBOX is not the right >>> way, what can i do ? >>> DLR's are depending of the provider I think.... >>> >>> Bye >>> >>> 2013/5/21 Ali Kashif <[email protected]> >>>> >>>> you need to insert data to in sqlbox `send_sms` table. and it will >>>> send the message through kannel and then copy the message to 'sent_sms'. >>>> >>>> >>>> sqlbox is just link any other smsbox connected to kannel. >>>> >>>> >>>> >>>> On Tue, May 21, 2013 at 4:03 PM, hans joachim <[email protected]>wrote: >>>>> >>>>> Hello, >>>>> >>>>> I want SQLBOX to store information about every outgoing sms in the >>>>> database. I send my SMS via HTTP-Call like >>>>> "http://xxx.xxx.xxx.xx:xxxxx/cgi-bin/sendsms?username=user&password=pass&from=1234566&to=123456789&text=test"; >>>>> but >>>>> no information is stored in my database. >>>>> >>>>> SQLBOX connects and created the tables (send_sms & sent_sms). I see >>>>> the SQLBOX in the Kannel-Webinterface too. >>>>> >>>>> Can you please help me to find the error ? >>>>> >>>>> KANNEL.CONF >>>>> >>>>> # MAIN CONFIG >>>>> group = core >>>>> admin-port = 13000 >>>>> smsbox-port = 13001 >>>>> admin-password = 123 >>>>> access-log = "/var/log/kannel/sms-trace.log" >>>>> access-log-clean = true >>>>> access-log-format= "SMS ID="%F" TS="%t" TYPE="%l" SMSC="%i" FROM="%p" >>>>> TO="%P" ENCODING="%c" TEXT="%b" UDH="%u"" >>>>> log-file = "/var/log/kannel/bearerbox.log" >>>>> log-level = 0 >>>>> >>>>> #Fake SMSC for Testing >>>>> #group = smsc >>>>> #smsc = fake >>>>> #smsc-id = Fake smsc >>>>> #port = 13009 >>>>> #connect-allow-ip = 127.0.0.1 >>>>> >>>>> # GSM-MODEM 1 >>>>> group = smsc >>>>> smsc = at >>>>> smsc-id = GSM1 >>>>> modemtype = auto >>>>> device = /dev/ttyS0 >>>>> sim-buffering = true >>>>> log-file= "/var/log/kannel/smsc.log" >>>>> log-level=0 >>>>> >>>>> # HEX HTTP-API >>>>> group = smsc >>>>> smsc = http >>>>> smsc-id = HEX >>>>> system-type = generic >>>>> port = 13004 >>>>> send-url = " >>>>> http://xx.xx.xx.xx/api.php?s_id=user&s_pw=password&service=fast&mobilenr=%p&text=%b >>>>> " >>>>> status-success-regex = "ok" >>>>> log-file = "/var/log/kannel/hex.log" >>>>> >>>>> group = modems >>>>> id = SIEMENS MC35i >>>>> name = "Siemens MC35i" >>>>> detect-string = "SIEMENS" >>>>> detect-string2 = "MC35i" >>>>> init-string = "AT+CPMS="SM"" >>>>> speed = 19200 >>>>> group = smsbox >>>>> >>>>> smsbox-id = smsbox1 >>>>> bearerbox-host = localhost >>>>> sendsms-port = 13003 >>>>> log-file= "/var/log/kannel/smsbox.log" >>>>> >>>>> group = sendsms-user >>>>> username = user1 >>>>> password = pass1 >>>>> >>>>> >>>>> SQLBOX.CONF: >>>>> >>>>> group = sqlbox >>>>> id = sqlbox-db >>>>> smsbox-id = sqlbox1 >>>>> #global-sender = "" >>>>> bearerbox-host = localhost >>>>> bearerbox-port = 13001 >>>>> smsbox-port = 13010 >>>>> #smsbox-port-ssl = false >>>>> sql-log-table = sent_sms >>>>> sql-insert-table = send_sms >>>>> log-file = "/var/log/kannel/sqlbox.log" >>>>> log-level = 0 >>>>> #ssl-client-certkey-file = "" >>>>> #ssl-server-cert-file = "" >>>>> #ssl-server-key-file = "" >>>>> #ssl-trusted-ca-file = "" >>>>> >>>>> # Database connection examples. Please uncomment as needed >>>>> # Example MYSQL Connection >>>>> group = mysql-connection >>>>> id = sqlbox-db >>>>> host = localhost >>>>> username = user >>>>> password = pass >>>>> database = kannel >>>>> >>>>> >>>>> >>>>> >>>>> >>>>
