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