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 >
