If you specify 13009, the messages will be logged by sqlbox.

The routing error was the other thing that I said.

 

From: Ciaran Scolard [mailto:cia...@phonovation.com] 
Sent: dinsdag 28 januari 2014 18:31
To: Rene Kluwen; users@kannel.org
Subject: RE: Routing assistance needed

 

Hi Rene,

 

In terms of routing does that mean I should specify the bearerbox-port in
opensmppbox.conf as 13009 instead of 13001?

 

I'll try the route-to-smsc option as well.

 

Thanks,

Ciaran.

From: Rene Kluwen [mailto:rene.klu...@chimit.nl] 
Sent: 28 January 2014 12:15
To: Ciaran Scolard; users@kannel.org
Subject: RE: Routing assistance needed

 

I can see two things in your setup that might cause your problem.

First, the order should be: opensmppbox -> sqlbox -> bearerbox.

This will make sqlbox log the messages that come from opensmppbox, going to
bearerbox.

 

The error that you give seems to indicate another problem:

 

In opensmppbox.conf, you can set route-to-smsc to a specific smsc that you
have configured in your bearerbox.conf.

See the opensmppbox manual for routing options.

 

== Rene

 

From: users [mailto:users-boun...@kannel.org] On Behalf Of Ciaran Scolard
Sent: dinsdag 28 januari 2014 11:52
To: users@kannel.org
Subject: Routing assistance needed

 

Hi All,

 

We're trying to setup the following.

Legacy SMPP GW ---> OpenSmppBox ---> Bearerbox ---> sqlbox

The idea being that we can take in messages from an old legacy gateway of
ours and process them in SQL.

 

Unfortunately the routing is not working.

I've tried everything I can think of so here's what happens.

 

The message comes in from the legacy gw as a submit_sm and we get the
following errors:

2014-01-28 02:15:00 [19248] [10] WARNING: Cannot find SMSCConn for message
to <353872115934>, rejected.

2014-01-28 02:15:00 [19248] [10] WARNING: Message rejected by bearerbox, no
router!

 

I can see that both sqlbox (as smsbox-id sms-db) and the opensmppbox user
have successfully authenticated (username. password and smsbox-id all
RVF57800) and we have the routes specified correctly to direct the traffic
to SQL. I appear to be missing something but I can't for the life of me
figure out what. What could be going wrong here? 

 

Thanks,

Ciaran.

 

 

# BEARERBOX CONFIG EXTRACT

group = smsbox-route

smsc-id = RVF57800

smsbox-id = sms-db

 

 

# OPENSMPPBOX CONFIG

group = core

dlr-storage = mssql

 

group = opensmppbox

our-system-id = "legacy"

opensmppbox-id = "legacy"

opensmppbox-port = 13010

bearerbox-host = localhost

bearerbox-port = 13001

smpp-logins = /usr/local/kannel/conf/opensmppbox/logins/legacy

log-file = /usr/local/kannel/log/opensmppbox/legacy.log

use-systemid-as-smsboxid = true

 

group = mssql-connection

id = sms-db

server = srvinfmssql07

username = "Kannel_User_00"

password = "Kannel_User_00"

database = "Kannel00"

max-connections = 100

 

group = dlr-db

id = sms-db

table = dlr

field-smsc = smsc

field-timestamp = ts

field-destination = destination

field-source = source

field-service = service

field-url = url

field-mask = mask

field-status = status

field-boxc-id = boxc

 

 

# SQLBOX CONFIG

group = core

dlr-storage = mssql

 

group = sqlbox

id = sms-db

smsbox-id = sms-db

bearerbox-host = localhost

bearerbox-port = 13001

smsbox-port = 13009

sql-log-table = sent_sms

sql-insert-table = send_sms

log-file = "/usr/local/kannel/log/sqlbox.log"

log-level = 0

 

group = mssql-connection

id = sms-db

server = 10.1.136.4

username = "Username"

password = "Password"

database = "Database"

max-connections = 100

 

 

 

Ciaran Scolard Network Manager phonovation limited
phonovation house, 8 clarinda park north, dun laoghaire, co. dublin,
ireland.
tel: + 353 1 284 3011 mobile: + 353 87 2115934 fax: + 353 1 284 3223
 <http://www.phonovation.com/> www.phonovation.com registered in Ireland
number 127108

 

 

Reply via email to