Thanks for that rene. I tried it and it worked exactly as you explained it would.
We're trying to do something slighltly different however. I suspect kannel may not be capable of it. We're not trying to route the messages. We're trying to take the messages in so that they can be dumped into SQL. Any ideas on that one? From: Ciaran Scolard Sent: 28 January 2014 17: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<mailto: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<mailto: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 www.phonovation.com<http://www.phonovation.com/> registered in Ireland number 127108