SQLBox and Kannel not calling the dlr-url specified.

View: New views
9 Messages — Rating Filter:   Alert me  

SQLBox and Kannel not calling the dlr-url specified.

by Sam-190 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,

AM using SQLbox on Kannel. Kannel does not call dlr-url. I am setting dlr-mask to 31 and specify the required url in the field `dlr_url` of the send_sms table.

Please help. My config below.


#######################kannel.conf############################
group = core
admin-port = 13090
admin-password = pass
status-password = pass
log-file = "/var/log/kannel/kannel.log"
log-level = 0
access-log = "/var/log/kannel/access-bearerbox.log"
dlr-storage = mysql
smsbox-port = 13190
box-deny-ip = "----"
box-allow-ip = "----"
store-type = spool
store-location = "/var/spool/kannel"


# SMSC SMPP
group = smsc
smsc = smpp
smsc-id = sand
host = smpp.com
port = 0000
receive-port = port
smsc-username = name
smsc-password = pass
receive-port = port
keepalive = 60
transceiver-mode = 1
system-type =
max-sms-octets = 900


# SMSBOX SETUP

group = smsbox
bearerbox-host = localhost
sendsms-port = 13290
log-file = "/var/log/kannel/kannel.log"
log-level = 0
access-log = "/var/log/kannel/access-smsbox.log"


# SEND-SMS USERS

group = sendsms-user
username = name
password = pass
concatenation=true
max-messages = 6


group = mysql-connection
id = mydlr
username = name
password = pass_db
database = kannel_db
max-connections = 1

group = dlr-db
id = mydlr
table = tbl_Dlr
field-smsc = smsc
field-timestamp = timestamp
field-destination = destination
field-source = source
field-service = service
field-url = url
field-mask = mask
field-status = status
field-boxc-id = boxc
###################################################



########################sqlbox.conf###########################
group = sqlbox
id = sqlbox-db
smsbox-id = sqlbox
bearerbox-host = localhost
bearerbox-port = 13190
smsbox-port-ssl = false
sql-log-table = sent_sms
sql-insert-table = send_sms
log-file = "/var/log/kannel/sqlbox.log"
log-level = 0

group = mysql-connection
id = sqlbox-db
host = localhost
username = name
password = pass_db
database = kannel_db
max-connections = 1
###################################################

Re: SQLBox and Kannel not calling the dlr-url specified.

by seikath :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Well,
first check your logs
do you get any DLR apart of ACK ?
then,
you should have the DLR statuses at the SQLBOX table anyway, according to that I can see in the configuration.

your setup is bearerbox<->sqlbox<->smsbox, so sqlbox handles all the MO/MT/DLR traffic.

Sam wrote:

> Hi,
>
> AM using SQLbox on Kannel. Kannel does not call dlr-url. I am setting
> dlr-mask to 31 and specify the required url in the field `dlr_url` of
> the send_sms table.
>
> Please help. My config below.
>
>
> #######################kannel.conf############################
> group = core
> admin-port = 13090
> admin-password = pass
> status-password = pass
> log-file = "/var/log/kannel/kannel.log"
> log-level = 0
> access-log = "/var/log/kannel/access-bearerbox.log"
> dlr-storage = mysql
> smsbox-port = 13190
> box-deny-ip = "----"
> box-allow-ip = "----"
> store-type = spool
> store-location = "/var/spool/kannel"
>
>
> # SMSC SMPP
> group = smsc
> smsc = smpp
> smsc-id = sand
> host = smpp.com <http://smpp.com>
> port = 0000
> receive-port = port
> smsc-username = name
> smsc-password = pass
> receive-port = port
> keepalive = 60
> transceiver-mode = 1
> system-type =
> max-sms-octets = 900
>
>
> # SMSBOX SETUP
>
> group = smsbox
> bearerbox-host = localhost
> sendsms-port = 13290
> log-file = "/var/log/kannel/kannel.log"
> log-level = 0
> access-log = "/var/log/kannel/access-smsbox.log"
>
>
> # SEND-SMS USERS
>
> group = sendsms-user
> username = name
> password = pass
> concatenation=true
> max-messages = 6
>
>
> group = mysql-connection
> id = mydlr
> host = www.mysite.com <http://www.mysite.com>
> username = name
> password = pass_db
> database = kannel_db
> max-connections = 1
>
> group = dlr-db
> id = mydlr
> table = tbl_Dlr
> field-smsc = smsc
> field-timestamp = timestamp
> field-destination = destination
> field-source = source
> field-service = service
> field-url = url
> field-mask = mask
> field-status = status
> field-boxc-id = boxc
> ###################################################
>
>
>
> ########################sqlbox.conf###########################
> group = sqlbox
> id = sqlbox-db
> smsbox-id = sqlbox
> bearerbox-host = localhost
> bearerbox-port = 13190
> smsbox-port-ssl = false
> sql-log-table = sent_sms
> sql-insert-table = send_sms
> log-file = "/var/log/kannel/sqlbox.log"
> log-level = 0
>
> group = mysql-connection
> id = sqlbox-db
> host = localhost
> username = name
> password = pass_db
> database = kannel_db
> max-connections = 1
> ###################################################


Parent Message unknown Re: SQLBox and Kannel not calling the dlr-url specified.

by seikath :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Change the concept:

bearerbox<->sqlbox<->smsbox

should be

smsbox<->bearerbox<->sqlbox

the sqlbox will act as just another smsbox



Sam wrote:

> Hi,
>
> You are correct, I have DLR in my sent_sms table. However, that os not
> what i want. I really want smsbox to handle the DLR. How can change the
> config to do that?
>
> TIA.
>
> On Sun, Nov 1, 2009 at 5:44 PM, seikath <seikath@...
> <mailto:seikath@...>> wrote:
>
>     Well,
>     first check your logs
>     do you get any DLR apart of ACK ?
>     then,
>     you should have the DLR statuses at the SQLBOX table anyway,
>     according to that I can see in the configuration.
>
>     your setup is bearerbox<->sqlbox<->smsbox, so sqlbox handles all the
>     MO/MT/DLR traffic.
>
>     Sam wrote:
>     > Hi,
>     >
>     > AM using SQLbox on Kannel. Kannel does not call dlr-url. I am setting
>     > dlr-mask to 31 and specify the required url in the field `dlr_url` of
>     > the send_sms table.
>     >
>     > Please help. My config below.
>     >
>     >
>     > #######################kannel.conf############################
>     > group = core
>     > admin-port = 13090
>     > admin-password = pass
>     > status-password = pass
>     > log-file = "/var/log/kannel/kannel.log"
>     > log-level = 0
>     > access-log = "/var/log/kannel/access-bearerbox.log"
>     > dlr-storage = mysql
>     > smsbox-port = 13190
>     > box-deny-ip = "----"
>     > box-allow-ip = "----"
>     > store-type = spool
>     > store-location = "/var/spool/kannel"
>     >
>     >
>     > # SMSC SMPP
>     > group = smsc
>     > smsc = smpp
>     > smsc-id = sand
>     > host = smpp.com <http://smpp.com> <http://smpp.com>
>     > port = 0000
>     > receive-port = port
>     > smsc-username = name
>     > smsc-password = pass
>     > receive-port = port
>     > keepalive = 60
>     > transceiver-mode = 1
>     > system-type =
>     > max-sms-octets = 900
>     >
>     >
>     > # SMSBOX SETUP
>     >
>     > group = smsbox
>     > bearerbox-host = localhost
>     > sendsms-port = 13290
>     > log-file = "/var/log/kannel/kannel.log"
>     > log-level = 0
>     > access-log = "/var/log/kannel/access-smsbox.log"
>     >
>     >
>     > # SEND-SMS USERS
>     >
>     > group = sendsms-user
>     > username = name
>     > password = pass
>     > concatenation=true
>     > max-messages = 6
>     >
>     >
>     > group = mysql-connection
>     > id = mydlr
>     > host = www.mysite.com <http://www.mysite.com> <http://www.mysite.com>
>     > username = name
>     > password = pass_db
>     > database = kannel_db
>     > max-connections = 1
>     >
>     > group = dlr-db
>     > id = mydlr
>     > table = tbl_Dlr
>     > field-smsc = smsc
>     > field-timestamp = timestamp
>     > field-destination = destination
>     > field-source = source
>     > field-service = service
>     > field-url = url
>     > field-mask = mask
>     > field-status = status
>     > field-boxc-id = boxc
>     > ###################################################
>     >
>     >
>     >
>     > ########################sqlbox.conf###########################
>     > group = sqlbox
>     > id = sqlbox-db
>     > smsbox-id = sqlbox
>     > bearerbox-host = localhost
>     > bearerbox-port = 13190
>     > smsbox-port-ssl = false
>     > sql-log-table = sent_sms
>     > sql-insert-table = send_sms
>     > log-file = "/var/log/kannel/sqlbox.log"
>     > log-level = 0
>     >
>     > group = mysql-connection
>     > id = sqlbox-db
>     > host = localhost
>     > username = name
>     > password = pass_db
>     > database = kannel_db
>     > max-connections = 1
>     > ###################################################
>
>


Re: SQLBox and Kannel not calling the dlr-url specified.

by Sam-190 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,

You are correct, I have DLR in my sent_sms table. However, that os not what i want. I really want smsbox to handle the DLR. How can change the config to do that?

TIA.

On Sun, Nov 1, 2009 at 5:44 PM, seikath <seikath@...> wrote:
Well,
first check your logs
do you get any DLR apart of ACK ?
then,
you should have the DLR statuses at the SQLBOX table anyway, according to that I can see in the configuration.

your setup is bearerbox<->sqlbox<->smsbox, so sqlbox handles all the MO/MT/DLR traffic.

Sam wrote:
> Hi,
>
> AM using SQLbox on Kannel. Kannel does not call dlr-url. I am setting
> dlr-mask to 31 and specify the required url in the field `dlr_url` of
> the send_sms table.
>
> Please help. My config below.
>
>
> #######################kannel.conf############################
> group = core
> admin-port = 13090
> admin-password = pass
> status-password = pass
> log-file = "/var/log/kannel/kannel.log"
> log-level = 0
> access-log = "/var/log/kannel/access-bearerbox.log"
> dlr-storage = mysql
> smsbox-port = 13190
> box-deny-ip = "----"
> box-allow-ip = "----"
> store-type = spool
> store-location = "/var/spool/kannel"
>
>
> # SMSC SMPP
> group = smsc
> smsc = smpp
> smsc-id = sand
> host = smpp.com <http://smpp.com>
> port = 0000
> receive-port = port
> smsc-username = name
> smsc-password = pass
> receive-port = port
> keepalive = 60
> transceiver-mode = 1
> system-type =
> max-sms-octets = 900
>
>
> # SMSBOX SETUP
>
> group = smsbox
> bearerbox-host = localhost
> sendsms-port = 13290
> log-file = "/var/log/kannel/kannel.log"
> log-level = 0
> access-log = "/var/log/kannel/access-smsbox.log"
>
>
> # SEND-SMS USERS
>
> group = sendsms-user
> username = name
> password = pass
> concatenation=true
> max-messages = 6
>
>
> group = mysql-connection
> id = mydlr
> host = www.mysite.com <http://www.mysite.com>
> username = name
> password = pass_db
> database = kannel_db
> max-connections = 1
>
> group = dlr-db
> id = mydlr
> table = tbl_Dlr
> field-smsc = smsc
> field-timestamp = timestamp
> field-destination = destination
> field-source = source
> field-service = service
> field-url = url
> field-mask = mask
> field-status = status
> field-boxc-id = boxc
> ###################################################
>
>
>
> ########################sqlbox.conf###########################
> group = sqlbox
> id = sqlbox-db
> smsbox-id = sqlbox
> bearerbox-host = localhost
> bearerbox-port = 13190
> smsbox-port-ssl = false
> sql-log-table = sent_sms
> sql-insert-table = send_sms
> log-file = "/var/log/kannel/sqlbox.log"
> log-level = 0
>
> group = mysql-connection
> id = sqlbox-db
> host = localhost
> username = name
> password = pass_db
> database = kannel_db
> max-connections = 1
> ###################################################



Parent Message unknown Re: SQLBox and Kannel not calling the dlr-url specified.

by seikath :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Change the concept:

bearerbox<->sqlbox<->smsbox

should be

smsbox<->bearerbox<->sqlbox

the sqlbox will act as just another smsbox



Sam wrote:

> Hi,
>
> You are correct, I have DLR in my sent_sms table. However, that os not
> what i want. I really want smsbox to handle the DLR. How can change the
> config to do that?
>
> TIA.
>
> On Sun, Nov 1, 2009 at 5:44 PM, seikath <seikath@...
> <mailto:seikath@...>> wrote:
>
>     Well,
>     first check your logs
>     do you get any DLR apart of ACK ?
>     then,
>     you should have the DLR statuses at the SQLBOX table anyway,
>     according to that I can see in the configuration.
>
>     your setup is bearerbox<->sqlbox<->smsbox, so sqlbox handles all the
>     MO/MT/DLR traffic.
>
>     Sam wrote:
>     > Hi,
>     >
>     > AM using SQLbox on Kannel. Kannel does not call dlr-url. I am setting
>     > dlr-mask to 31 and specify the required url in the field `dlr_url` of
>     > the send_sms table.
>     >
>     > Please help. My config below.
>     >
>     >
>     > #######################kannel.conf############################
>     > group = core
>     > admin-port = 13090
>     > admin-password = pass
>     > status-password = pass
>     > log-file = "/var/log/kannel/kannel.log"
>     > log-level = 0
>     > access-log = "/var/log/kannel/access-bearerbox.log"
>     > dlr-storage = mysql
>     > smsbox-port = 13190
>     > box-deny-ip = "----"
>     > box-allow-ip = "----"
>     > store-type = spool
>     > store-location = "/var/spool/kannel"
>     >
>     >
>     > # SMSC SMPP
>     > group = smsc
>     > smsc = smpp
>     > smsc-id = sand
>     > host = smpp.com <http://smpp.com> <http://smpp.com>
>     > port = 0000
>     > receive-port = port
>     > smsc-username = name
>     > smsc-password = pass
>     > receive-port = port
>     > keepalive = 60
>     > transceiver-mode = 1
>     > system-type =
>     > max-sms-octets = 900
>     >
>     >
>     > # SMSBOX SETUP
>     >
>     > group = smsbox
>     > bearerbox-host = localhost
>     > sendsms-port = 13290
>     > log-file = "/var/log/kannel/kannel.log"
>     > log-level = 0
>     > access-log = "/var/log/kannel/access-smsbox.log"
>     >
>     >
>     > # SEND-SMS USERS
>     >
>     > group = sendsms-user
>     > username = name
>     > password = pass
>     > concatenation=true
>     > max-messages = 6
>     >
>     >
>     > group = mysql-connection
>     > id = mydlr
>     > host = www.mysite.com <http://www.mysite.com> <http://www.mysite.com>
>     > username = name
>     > password = pass_db
>     > database = kannel_db
>     > max-connections = 1
>     >
>     > group = dlr-db
>     > id = mydlr
>     > table = tbl_Dlr
>     > field-smsc = smsc
>     > field-timestamp = timestamp
>     > field-destination = destination
>     > field-source = source
>     > field-service = service
>     > field-url = url
>     > field-mask = mask
>     > field-status = status
>     > field-boxc-id = boxc
>     > ###################################################
>     >
>     >
>     >
>     > ########################sqlbox.conf###########################
>     > group = sqlbox
>     > id = sqlbox-db
>     > smsbox-id = sqlbox
>     > bearerbox-host = localhost
>     > bearerbox-port = 13190
>     > smsbox-port-ssl = false
>     > sql-log-table = sent_sms
>     > sql-insert-table = send_sms
>     > log-file = "/var/log/kannel/sqlbox.log"
>     > log-level = 0
>     >
>     > group = mysql-connection
>     > id = sqlbox-db
>     > host = localhost
>     > username = name
>     > password = pass_db
>     > database = kannel_db
>     > max-connections = 1
>     > ###################################################
>
>



Re: SQLBox and Kannel not calling the dlr-url specified.

by Nikos Balkanas-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Or to make the concept more clear in ASCII art:

slqlbox   -> bearerbox -> SMSc
smsbox ->

This might work with an smsbox-route group:

group = smsbox-route
smsbox-id = <smsbox>
smsc-id = <all your smscs>

BR,
Nikos
----- Original Message -----
From: "seikath" <seikath@...>
To: <users@...>
Sent: Monday, November 02, 2009 12:20 PM
Subject: Re: SQLBox and Kannel not calling the dlr-url specified.


> Change the concept:
>
> bearerbox<->sqlbox<->smsbox
>
> should be
>
> smsbox<->bearerbox<->sqlbox
>
> the sqlbox will act as just another smsbox
>
>
>
> Sam wrote:
>> Hi,
>>
>> You are correct, I have DLR in my sent_sms table. However, that os not
>> what i want. I really want smsbox to handle the DLR. How can change the
>> config to do that?
>>
>> TIA.
>>
>> On Sun, Nov 1, 2009 at 5:44 PM, seikath <seikath@...
>> <mailto:seikath@...>> wrote:
>>
>>     Well,
>>     first check your logs
>>     do you get any DLR apart of ACK ?
>>     then,
>>     you should have the DLR statuses at the SQLBOX table anyway,
>>     according to that I can see in the configuration.
>>
>>     your setup is bearerbox<->sqlbox<->smsbox, so sqlbox handles all the
>>     MO/MT/DLR traffic.
>>
>>     Sam wrote:
>>     > Hi,
>>     >
>>     > AM using SQLbox on Kannel. Kannel does not call dlr-url. I am
>> setting
>>     > dlr-mask to 31 and specify the required url in the field `dlr_url`
>> of
>>     > the send_sms table.
>>     >
>>     > Please help. My config below.
>>     >
>>     >
>>     > #######################kannel.conf############################
>>     > group = core
>>     > admin-port = 13090
>>     > admin-password = pass
>>     > status-password = pass
>>     > log-file = "/var/log/kannel/kannel.log"
>>     > log-level = 0
>>     > access-log = "/var/log/kannel/access-bearerbox.log"
>>     > dlr-storage = mysql
>>     > smsbox-port = 13190
>>     > box-deny-ip = "----"
>>     > box-allow-ip = "----"
>>     > store-type = spool
>>     > store-location = "/var/spool/kannel"
>>     >
>>     >
>>     > # SMSC SMPP
>>     > group = smsc
>>     > smsc = smpp
>>     > smsc-id = sand
>>     > host = smpp.com <http://smpp.com> <http://smpp.com>
>>     > port = 0000
>>     > receive-port = port
>>     > smsc-username = name
>>     > smsc-password = pass
>>     > receive-port = port
>>     > keepalive = 60
>>     > transceiver-mode = 1
>>     > system-type =
>>     > max-sms-octets = 900
>>     >
>>     >
>>     > # SMSBOX SETUP
>>     >
>>     > group = smsbox
>>     > bearerbox-host = localhost
>>     > sendsms-port = 13290
>>     > log-file = "/var/log/kannel/kannel.log"
>>     > log-level = 0
>>     > access-log = "/var/log/kannel/access-smsbox.log"
>>     >
>>     >
>>     > # SEND-SMS USERS
>>     >
>>     > group = sendsms-user
>>     > username = name
>>     > password = pass
>>     > concatenation=true
>>     > max-messages = 6
>>     >
>>     >
>>     > group = mysql-connection
>>     > id = mydlr
>>     > host = www.mysite.com <http://www.mysite.com>
>> <http://www.mysite.com>
>>     > username = name
>>     > password = pass_db
>>     > database = kannel_db
>>     > max-connections = 1
>>     >
>>     > group = dlr-db
>>     > id = mydlr
>>     > table = tbl_Dlr
>>     > field-smsc = smsc
>>     > field-timestamp = timestamp
>>     > field-destination = destination
>>     > field-source = source
>>     > field-service = service
>>     > field-url = url
>>     > field-mask = mask
>>     > field-status = status
>>     > field-boxc-id = boxc
>>     > ###################################################
>>     >
>>     >
>>     >
>>     > ########################sqlbox.conf###########################
>>     > group = sqlbox
>>     > id = sqlbox-db
>>     > smsbox-id = sqlbox
>>     > bearerbox-host = localhost
>>     > bearerbox-port = 13190
>>     > smsbox-port-ssl = false
>>     > sql-log-table = sent_sms
>>     > sql-insert-table = send_sms
>>     > log-file = "/var/log/kannel/sqlbox.log"
>>     > log-level = 0
>>     >
>>     > group = mysql-connection
>>     > id = sqlbox-db
>>     > host = localhost
>>     > username = name
>>     > password = pass_db
>>     > database = kannel_db
>>     > max-connections = 1
>>     > ###################################################
>>
>>
>



Re: SQLBox and Kannel not calling the dlr-url specified.

by seikath :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Thank you Nicos :)



Nikos Balkanas wrote:

> Or to make the concept more clear in ASCII art:
>
> slqlbox   -> bearerbox -> SMSc
> smsbox ->
>
> This might work with an smsbox-route group:
>
> group = smsbox-route
> smsbox-id = <smsbox>
> smsc-id = <all your smscs>
>
> BR,
> Nikos
> ----- Original Message ----- From: "seikath" <seikath@...>
> To: <users@...>
> Sent: Monday, November 02, 2009 12:20 PM
> Subject: Re: SQLBox and Kannel not calling the dlr-url specified.
>
>
>> Change the concept:
>>
>> bearerbox<->sqlbox<->smsbox
>>
>> should be
>>
>> smsbox<->bearerbox<->sqlbox
>>
>> the sqlbox will act as just another smsbox
>>
>>
>>
>> Sam wrote:
>>> Hi,
>>>
>>> You are correct, I have DLR in my sent_sms table. However, that os not
>>> what i want. I really want smsbox to handle the DLR. How can change the
>>> config to do that?
>>>
>>> TIA.
>>>
>>> On Sun, Nov 1, 2009 at 5:44 PM, seikath <seikath@...
>>> <mailto:seikath@...>> wrote:
>>>
>>>     Well,
>>>     first check your logs
>>>     do you get any DLR apart of ACK ?
>>>     then,
>>>     you should have the DLR statuses at the SQLBOX table anyway,
>>>     according to that I can see in the configuration.
>>>
>>>     your setup is bearerbox<->sqlbox<->smsbox, so sqlbox handles all the
>>>     MO/MT/DLR traffic.
>>>
>>>     Sam wrote:
>>>     > Hi,
>>>     >
>>>     > AM using SQLbox on Kannel. Kannel does not call dlr-url. I am
>>> setting
>>>     > dlr-mask to 31 and specify the required url in the field
>>> `dlr_url` of
>>>     > the send_sms table.
>>>     >
>>>     > Please help. My config below.
>>>     >
>>>     >
>>>     > #######################kannel.conf############################
>>>     > group = core
>>>     > admin-port = 13090
>>>     > admin-password = pass
>>>     > status-password = pass
>>>     > log-file = "/var/log/kannel/kannel.log"
>>>     > log-level = 0
>>>     > access-log = "/var/log/kannel/access-bearerbox.log"
>>>     > dlr-storage = mysql
>>>     > smsbox-port = 13190
>>>     > box-deny-ip = "----"
>>>     > box-allow-ip = "----"
>>>     > store-type = spool
>>>     > store-location = "/var/spool/kannel"
>>>     >
>>>     >
>>>     > # SMSC SMPP
>>>     > group = smsc
>>>     > smsc = smpp
>>>     > smsc-id = sand
>>>     > host = smpp.com <http://smpp.com> <http://smpp.com>
>>>     > port = 0000
>>>     > receive-port = port
>>>     > smsc-username = name
>>>     > smsc-password = pass
>>>     > receive-port = port
>>>     > keepalive = 60
>>>     > transceiver-mode = 1
>>>     > system-type =
>>>     > max-sms-octets = 900
>>>     >
>>>     >
>>>     > # SMSBOX SETUP
>>>     >
>>>     > group = smsbox
>>>     > bearerbox-host = localhost
>>>     > sendsms-port = 13290
>>>     > log-file = "/var/log/kannel/kannel.log"
>>>     > log-level = 0
>>>     > access-log = "/var/log/kannel/access-smsbox.log"
>>>     >
>>>     >
>>>     > # SEND-SMS USERS
>>>     >
>>>     > group = sendsms-user
>>>     > username = name
>>>     > password = pass
>>>     > concatenation=true
>>>     > max-messages = 6
>>>     >
>>>     >
>>>     > group = mysql-connection
>>>     > id = mydlr
>>>     > host = www.mysite.com <http://www.mysite.com>
>>> <http://www.mysite.com>
>>>     > username = name
>>>     > password = pass_db
>>>     > database = kannel_db
>>>     > max-connections = 1
>>>     >
>>>     > group = dlr-db
>>>     > id = mydlr
>>>     > table = tbl_Dlr
>>>     > field-smsc = smsc
>>>     > field-timestamp = timestamp
>>>     > field-destination = destination
>>>     > field-source = source
>>>     > field-service = service
>>>     > field-url = url
>>>     > field-mask = mask
>>>     > field-status = status
>>>     > field-boxc-id = boxc
>>>     > ###################################################
>>>     >
>>>     >
>>>     >
>>>     > ########################sqlbox.conf###########################
>>>     > group = sqlbox
>>>     > id = sqlbox-db
>>>     > smsbox-id = sqlbox
>>>     > bearerbox-host = localhost
>>>     > bearerbox-port = 13190
>>>     > smsbox-port-ssl = false
>>>     > sql-log-table = sent_sms
>>>     > sql-insert-table = send_sms
>>>     > log-file = "/var/log/kannel/sqlbox.log"
>>>     > log-level = 0
>>>     >
>>>     > group = mysql-connection
>>>     > id = sqlbox-db
>>>     > host = localhost
>>>     > username = name
>>>     > password = pass_db
>>>     > database = kannel_db
>>>     > max-connections = 1
>>>     > ###################################################
>>>
>>>
>>
>
>
>
>


Re: SQLBox and Kannel not calling the dlr-url specified.

by Sam-190 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,

I have added the smsbox-route and yet the smsbox is not calling the URL yet. Pls advise.

#################

group = smsbox-route
smsbox-id = smsbox
smsc-id = "sand"

#################



2009/11/2 Nikos Balkanas <nbal@...>
Or to make the concept more clear in ASCII art:

slqlbox   -> bearerbox -> SMSc
smsbox ->

This might work with an smsbox-route group:

group = smsbox-route
smsbox-id = <smsbox>
smsc-id = <all your smscs>

BR,
Nikos
----- Original Message ----- From: "seikath" <seikath@...>
To: <users@...>
Sent: Monday, November 02, 2009 12:20 PM
Subject: Re: SQLBox and Kannel not calling the dlr-url specified.



Change the concept:

bearerbox<->sqlbox<->smsbox

should be

smsbox<->bearerbox<->sqlbox

the sqlbox will act as just another smsbox



Sam wrote:
Hi,

You are correct, I have DLR in my sent_sms table. However, that os not
what i want. I really want smsbox to handle the DLR. How can change the
config to do that?

TIA.

On Sun, Nov 1, 2009 at 5:44 PM, seikath <seikath@...
<mailto:seikath@...>> wrote:

   Well,
   first check your logs
   do you get any DLR apart of ACK ?
   then,
   you should have the DLR statuses at the SQLBOX table anyway,
   according to that I can see in the configuration.

   your setup is bearerbox<->sqlbox<->smsbox, so sqlbox handles all the
   MO/MT/DLR traffic.

   Sam wrote:
   > Hi,
   >
   > AM using SQLbox on Kannel. Kannel does not call dlr-url. I am setting
   > dlr-mask to 31 and specify the required url in the field `dlr_url` of
   > the send_sms table.
   >
   > Please help. My config below.
   >
   >
   > #######################kannel.conf############################
   > group = core
   > admin-port = 13090
   > admin-password = pass
   > status-password = pass
   > log-file = "/var/log/kannel/kannel.log"
   > log-level = 0
   > access-log = "/var/log/kannel/access-bearerbox.log"
   > dlr-storage = mysql
   > smsbox-port = 13190
   > box-deny-ip = "----"
   > box-allow-ip = "----"
   > store-type = spool
   > store-location = "/var/spool/kannel"
   >
   >
   > # SMSC SMPP
   > group = smsc
   > smsc = smpp
   > smsc-id = sand
   > host = smpp.com <http://smpp.com> <http://smpp.com>
   > port = 0000
   > receive-port = port
   > smsc-username = name
   > smsc-password = pass
   > receive-port = port
   > keepalive = 60
   > transceiver-mode = 1
   > system-type =
   > max-sms-octets = 900
   >
   >
   > # SMSBOX SETUP
   >
   > group = smsbox
   > bearerbox-host = localhost
   > sendsms-port = 13290
   > log-file = "/var/log/kannel/kannel.log"
   > log-level = 0
   > access-log = "/var/log/kannel/access-smsbox.log"
   >
   >
   > # SEND-SMS USERS
   >
   > group = sendsms-user
   > username = name
   > password = pass
   > concatenation=true
   > max-messages = 6
   >
   >
   > group = mysql-connection
   > id = mydlr
   > host = www.mysite.com <http://www.mysite.com> <http://www.mysite.com>
   > username = name
   > password = pass_db
   > database = kannel_db
   > max-connections = 1
   >
   > group = dlr-db
   > id = mydlr
   > table = tbl_Dlr
   > field-smsc = smsc
   > field-timestamp = timestamp
   > field-destination = destination
   > field-source = source
   > field-service = service
   > field-url = url
   > field-mask = mask
   > field-status = status
   > field-boxc-id = boxc
   > ###################################################
   >
   >
   >
   > ########################sqlbox.conf###########################
   > group = sqlbox
   > id = sqlbox-db
   > smsbox-id = sqlbox
   > bearerbox-host = localhost
   > bearerbox-port = 13190
   > smsbox-port-ssl = false
   > sql-log-table = sent_sms
   > sql-insert-table = send_sms
   > log-file = "/var/log/kannel/sqlbox.log"
   > log-level = 0
   >
   > group = mysql-connection
   > id = sqlbox-db
   > host = localhost
   > username = name
   > password = pass_db
   > database = kannel_db
   > max-connections = 1
   > ###################################################







Re: SQLBox and Kannel not calling the dlr-url specified.

by Nikos Balkanas-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Some parts of this message have been removed. Learn more about Nabble's security policy.
Hi,
 
You have not defined smsbox-id anywhere. Please do and if it still doesn't work please post detailed logs.
 
BR,
Nikos
----- Original Message -----
Sent: Thursday, November 05, 2009 3:29 PM
Subject: Re: SQLBox and Kannel not calling the dlr-url specified.

Hi,

I have added the smsbox-route and yet the smsbox is not calling the URL yet. Pls advise.

#################

group = smsbox-route
smsbox-id = smsbox
smsc-id = "sand"

#################



2009/11/2 Nikos Balkanas <nbal@...>
Or to make the concept more clear in ASCII art:

slqlbox   -> bearerbox -> SMSc
smsbox ->

This might work with an smsbox-route group:

group = smsbox-route
smsbox-id = <smsbox>
smsc-id = <all your smscs>

BR,
Nikos
----- Original Message ----- From: "seikath" <seikath@...>
To: <users@...>
Sent: Monday, November 02, 2009 12:20 PM
Subject: Re: SQLBox and Kannel not calling the dlr-url specified.



Change the concept:

bearerbox<->sqlbox<->smsbox

should be

smsbox<->bearerbox<->sqlbox

the sqlbox will act as just another smsbox



Sam wrote:
Hi,

You are correct, I have DLR in my sent_sms table. However, that os not
what i want. I really want smsbox to handle the DLR. How can change the
config to do that?

TIA.

On Sun, Nov 1, 2009 at 5:44 PM, seikath <seikath@...
<mailto:seikath@...>> wrote:

   Well,
   first check your logs
   do you get any DLR apart of ACK ?
   then,
   you should have the DLR statuses at the SQLBOX table anyway,
   according to that I can see in the configuration.

   your setup is bearerbox<->sqlbox<->smsbox, so sqlbox handles all the
   MO/MT/DLR traffic.

   Sam wrote:
   > Hi,
   >
   > AM using SQLbox on Kannel. Kannel does not call dlr-url. I am setting
   > dlr-mask to 31 and specify the required url in the field `dlr_url` of
   > the send_sms table.
   >
   > Please help. My config below.
   >
   >
   > #######################kannel.conf############################
   > group = core
   > admin-port = 13090
   > admin-password = pass
   > status-password = pass
   > log-file = "/var/log/kannel/kannel.log"
   > log-level = 0
   > access-log = "/var/log/kannel/access-bearerbox.log"
   > dlr-storage = mysql
   > smsbox-port = 13190
   > box-deny-ip = "----"
   > box-allow-ip = "----"
   > store-type = spool
   > store-location = "/var/spool/kannel"
   >
   >
   > # SMSC SMPP
   > group = smsc
   > smsc = smpp
   > smsc-id = sand
   > host = smpp.com <http://smpp.com> <http://smpp.com>
   > port = 0000
   > receive-port = port
   > smsc-username = name
   > smsc-password = pass
   > receive-port = port
   > keepalive = 60
   > transceiver-mode = 1
   > system-type =
   > max-sms-octets = 900
   >
   >
   > # SMSBOX SETUP
   >
   > group = smsbox
   > bearerbox-host = localhost
   > sendsms-port = 13290
   > log-file = "/var/log/kannel/kannel.log"
   > log-level = 0
   > access-log = "/var/log/kannel/access-smsbox.log"
   >
   >
   > # SEND-SMS USERS
   >
   > group = sendsms-user
   > username = name
   > password = pass
   > concatenation=true
   > max-messages = 6
   >
   >
   > group = mysql-connection
   > id = mydlr
   > host = www.mysite.com <http://www.mysite.com> <http://www.mysite.com>
   > username = name
   > password = pass_db
   > database = kannel_db
   > max-connections = 1
   >
   > group = dlr-db
   > id = mydlr
   > table = tbl_Dlr
   > field-smsc = smsc
   > field-timestamp = timestamp
   > field-destination = destination
   > field-source = source
   > field-service = service
   > field-url = url
   > field-mask = mask
   > field-status = status
   > field-boxc-id = boxc
   > ###################################################
   >
   >
   >
   > ########################sqlbox.conf###########################
   > group = sqlbox
   > id = sqlbox-db
   > smsbox-id = sqlbox
   > bearerbox-host = localhost
   > bearerbox-port = 13190
   > smsbox-port-ssl = false
   > sql-log-table = sent_sms
   > sql-insert-table = send_sms
   > log-file = "/var/log/kannel/sqlbox.log"
   > log-level = 0
   >
   > group = mysql-connection
   > id = sqlbox-db
   > host = localhost
   > username = name
   > password = pass_db
   > database = kannel_db
   > max-connections = 1
   > ###################################################