Aw: Re: Re: SQLBOX doesnt store SMS in database

[hans joachim]

 

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 <spame...@gmail.com>
An: "hans joachim" <cosmos...@web.de>
Cc: "Ali Kashif" <syedalikas...@gmail.com>, "users@kannel.org" <users@kannel.org>, "Florian Klein" <fl.kl...@googlemail.com>
Betreff: Re: Re: SQLBOX doesnt store SMS in database

 

 

2013/5/22 hans joachim <cosmos...@web.de>

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" <syedalikas...@gmail.com>
An: "Florian Klein" <fl.kl...@googlemail.com>
Cc: "users@kannel.org" <users@kannel.org>
Betreff: Re: SQLBOX doesnt store SMS in database

Please always CC to users.

 

On Wed, May 22, 2013 at 8:30 AM, Florian Klein <fl.kl...@googlemail.com> 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 <syedalikas...@gmail.com>

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 <cosmos...@web.de> 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 = "" href="http://xx.xx.xx.xx/api.php?s_id=user&s_pw=password&service=fast&mobilenr=%p&text=%b" target="_blank">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