Hi,
You have 2 options:
1) Modify sqlbox's source code. Note that you will branch off and need to
merge in all future updates.
2) Use a trigger to update another table when inserting to sent_sms.
PS: SMS are not picked up by bb, they are sent by sqlbox to bb.
BR,
Nikos
----- Original Message -----
From: ha...@aeon.pk
To: Harbhag Singh Sohal
Cc: Nikos Balkanas ; users@kannel.org
Sent: Monday, April 18, 2011 8:45 PM
Subject: Re: bearerbox sqlbox smsbox
Messages would be stored in sent_sms table only in SQLBOX. Any message you
try to put in send_sms would be picked up by bbox for MT delivery. I am not
sure whether there can be customized changes to DB structure.
On Mon, Apr 18, 2011 at 7:23 PM, Harbhag Singh Sohal
<harbhag.so...@gmail.com> wrote:
Thanks Nikos, I have successfully stored the received SMS to database
today. But the messages are getting stored in the sent_sms table being
used by sqlbox. What should I do to store the SMS to some other table
?
2011/4/18 Nikos Balkanas <nbalka...@gmail.com>:
Hi,
You should give the same smsbox-id as sqlbox-id, so that DLRs are
forwarded
to your smsbox correctly.
In group sqlbox you should set as bearerbox-host: 127.0.0.1 (or the
bearerbox ip)
In group smsbox you should set bearerbox-host: 127.0.0.1 (or the sqlbox
ip)
and bearerbox-port: 13007.
BR,
Nikos
----- Original Message ----- From: "Harbhag Singh Sohal"
<harbhag.so...@gmail.com>
To: <users@kannel.org>
Sent: Monday, April 18, 2011 6:13 AM
Subject: bearerbox sqlbox smsbox
How can I achieve the setup below
bearerbox<-->sqlbox<-->smsbox
I want to store to received SMSs to the database.
Below are my current config files
#Sample configuration file for Kannel bearerbox on Debian.
# See the documentation for explanations of fields.
#
# HTTP administration is disabled by default. Make sure you set the
# password if you enable it.
group = core
admin-port = 13015
admin-password = hard2guess
#admin-deny-ip = "*.*.*.*"
admin-allow-ip = "127.0.0.1"
dlr-storage = internal
smsbox-port = 13016
#wdp-interface-name = "*"
log-file = "/var/log/kannel/bearerbox.log"
access-log = "/var/log/kannel/access.log"
#box-deny-ip = "*.*.*.*"
box-allow-ip = "127.0.0.1"
log-level = 0
#group = wapbox
#bearerbox-host = localhost
#log-file = "/var/log/kannel/wapbox.log"
group = smsc
smsc-id = huawei_e220
smsc = at
modemtype = huawei
device= /dev/ttyUSB0
my-number = +91
connect-allow-ip = 127.0.0.1
sim-buffering = true
log-level = 0
# DLR with MySQL support configuration
group = mysql-connection
id = mydlr
host = localhost
username =
password =
database = a
group = dlr-db
id = mydlr
table = dlr
field-smsc = smsc
field-timestamp = ts
field-source=source
field-destination = destination
field-service = service
field-url = url
field-mask = mask
field-status = status
field-boxc-id = boxc
group = modems
id = nokia
name = "Huawei"
detect-string = "huawei"
init-string = "ATZ"
init-string = "AT+CMEE=1"
init-string = "AT Q0 V1 E1 S0=0 &C1 &D2 +FCLASS=0"
init-string = "AT+CNMI=0,1"
message-storage = SM
message-start = 0
#speed = 460800
#message-start = 0
group = smsbox
smsbox-id = mysmsc
bearerbox-host = 2
#bearerbox-port = 13018
sendsms-port = 13018
global-sender = +91
access-log = "/var/log/kannel/smsbox-access.log"
log-file = "/var/log/kannel/smsbox.log"
log-level = 0
mo-recode = true
group = smsbox-route
smsbox-id = mysmsc
smsc-id = huawei_e220
group = sendsms-user
username =
password = hard2guess
concatenation= true
max-messages = 10000
group = sms-service
keyword-regex = .*
catch-all = yes
accepted-smsc = huawei_e220
max-messages = 3
get-url = "http://localhost/~harbhag/test.php?phone=%p&text=%a";
group = sqlbox
id = sqlbox-db
smsbox-id = mysmsc
global-sender = "+91"
bearerbox-host = 202
bearerbox-port = 13016
smsbox-port = 13017
smsbox-port-ssl = false
sql-log-table = sent_sms
sql-insert-table = send_sms
log-file = "/var/log/kannel/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 =
password =
database =
I am using Ubuntu 10.10 64 bit and Kannel version 1.50.
Thanks
--
Harbhag Singh Sohal
www.harbhag.wordpress.com
--
Harbhag Singh Sohal
www.harbhag.wordpress.com
--
Harbhag Singh Sohal
www.harbhag.wordpress.com
