Hi All, The same i tryed but finally messages is not going through sqlbox the communication happening as fallows
[SMPP client]<-->[opensmppbox]<---->[bearerbox] On Tue, Jan 4, 2011 at 2:15 PM, Kenny <[email protected]> wrote: > 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 >>> >> >> >
