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 >>>> >>>> >>>> >>>> >>>> >>>
