Hi, This approach is cool.
[SMPP client]<-->[smppbox]<-->[sqlbox]<-->[bearerbox] However, considering the fact that [ sqlbox ] does not "natively" support long messages, would this really work properly when [smpp clients] start sending long messages greater that 160xters ? -- Regards Kenny On Tue, Nov 23, 2010 at 6:12 PM, Adeagbo Tunji <[email protected]> wrote: > GREAT Nikos. > > IT WORKS! > > > 2010/11/23 Nikos Balkanas <[email protected]> > >> Yes. Your problem is that you are connecting smppbox directly to bb, not >> sqlbox. Therefore no traffic goes through sqlbox. To inplement your flow you >> need to change in group openssmppbox: >> >> bearerbox-port = 33009 >> >> >> BR, >> Nikos >> ----- Original Message ----- From: Adeagbo Tunji >> To: Nikos Balkanas >> Cc: [email protected] >> Sent: Tuesday, November 23, 2010 4:29 PM >> Subject: Re: smppbox with sqlbox >> >> >> >> Thanks Nikos >> >> >> Find below the configuration >> >> >> === sqlbox===== >> group = sqlbox >> id = sqlbox-db >> smsbox-id = abu >> #global-sender = "" >> bearerbox-host = localhost >> bearerbox-port = 23005 >> smsbox-port = 33009 >> smsbox-port-ssl = false >> sql-log-table = sent_sms >> sql-insert-table = send_sms >> log-file = "/var/log/nvsmpp/test_smpp/sqlbox.log" >> log-level = 0 >> >> >> group = mysql-connection >> id = sqlbox-db >> host = localhost >> username = root >> password = ][23 >> database = SMPP_Router >> # you can increase this upon a higher load >> max-connections = 1 >> >> >> ==== kannel.conf ======= >> group = core >> admin-port = 13005 >> smsbox-port = 23005 >> admin-password = bar >> status-password = foo >> #admin-deny-ip = "" >> #admin-allow-ip = "" >> log-file = "/var/log/smpp/smsc.log" >> log-level = 0 >> box-deny-ip = "*.*.*.*" >> box-allow-ip = "127.0.0.1" >> #wdp-interface-name = "*" >> #unified-prefix = "+358,00358,0;+,00" >> access-log = "/var/log/smpp/access.log" >> #ssl-server-cert-file = "cert.pem" >> #ssl-server-key-file = "key.pem" >> #ssl-certkey-file = "mycertandprivkeyfile.pem" >> #dlr-storage = mysql >> >> >> >> >> # SMSC CONNECTIONS >> group = smsc >> smsc = smpp >> smsc-id = smpp >> port = >> host = >> receive-port = >> smsc-username = >> smsc-password = >> system-type = "" >> address-range = "" >> interface-version = 0x33 >> enquire-link-interval = 60 >> msg-id-type = 0x01 >> source-addr-ton = 1 >> source-addr-npi = 1 >> dest-addr-ton = 1 >> dest-addr-npi = 1 >> allowed-smsc-id = test_smpp >> #alt-charset = LATIN1 >> #snpi = 1 >> #validityperiod = 360 >> #msg-id-type = "12345678901" >> >> >> >> >> group = smsbox-route >> smsbox-id = abu >> smsc-id = test_smpp >> >> >> # SMSBOX SETUP >> >> >> group = smsbox >> bearerbox-host = localhost >> sendsms-port = 33099 >> #global-sender = >> #my-number = 38000 >> #sendsms-chars = "0123456789 +-" >> log-file = "/var/log/nsg/ware_smpp/smsbox.log" >> log-level = 0 >> access-log = "/var/log/nsg/ware_smpp/sms_access.log" >> >> >> # SERVICES >> # There should be always a 'default' service. This service is used when no >> # other 'sms-service' is applied. >> >> >> group = sms-service >> keyword = default >> text = "No service specified" >> >> >> >> >> ===== smpp.conf ===== >> # sample opensmppbox.conf >> >> >> group = core >> #dlr-storage = mysql >> >> >> # this group defines your opensmppbox >> group = opensmppbox >> # our boxc type >> opensmppbox-id = nvsmpp >> # the port to listen on for smpp connections >> opensmppbox-port = 2348 >> # we connect to the following host as a box >> bearerbox-host = localhost >> bearerbox-port = 23005 >> log-level = 0 >> log-file = "/var/log/smpp/smppbox.log" >> our-system-id = smpp_router >> #use-systemid-as-smsboxid = false >> route-to-smsc = test_smpp >> # see sample smpplogins.txt >> smpp-logins = "/etc/smpp/smpplogin1.txt" >> >> >> ======Startup Flow ===== >> Start bearerbox >> start smppbox >> start sqlbox >> >> >> Thanks >> Tunji >> >> >> 2010/11/23 Nikos Balkanas <[email protected]> >> >> Hi, >> >> This is not much help. If you are going to postconfiguration, please >> include all config files, along with a few detailed startup lox of all >> components. >> >> BR, >> Nikos >> ----- Original Message ----- From: Adeagbo Tunji >> To: [email protected] >> Sent: Tuesday, November 23, 2010 8:31 AM >> Subject: smppbox with sqlbox >> >> >> >> Hi Team >> I had setup opensmppbox to connect to bearerbox and its working fine. But >> I need to introduce sqlbox in between to log MO and MT from >> smppbox. I tried but no entry in send and sent table. kindly help with >> working sqlbox config see below the flow >> [SMPP client]<-->[smppbox]<-->[sqlbox]<-->[bearerbox] >> =====sqlbox.conf======group = sqlbox >> id = sqlbox-dbsmsbox-id = billy >> bearerbox-host = localhostbearerbox-port = 23005 >> >> smsbox-port = 33009smsbox-port-ssl = false >> sql-log-table = sent_smssql-insert-table = Nsend_sms >> >> log-file = "/var/log/nvsmpp/test_smpp/sqlbox.log"log-level = 0 >> > >
