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 >
