Alvaro --> if you see my above configuration, openSMPP is connecting to sqlbox on 13002 and sqlbox is connecting to kannel on 13001
so it seems like traffic is passing through SQLBox more over i have logs for all sent sms in my sqlbox sent_sms table. so if i agree with you, how messages are being logged in to sqlBox sent_sms table. Thanks Ali On Wed, Apr 15, 2015 at 12:22 AM, Alvaro Cornejo <cornejo.alv...@gmail.com> wrote: > Hi > > As far as I know, openSMPP talks directly to bearerbox in "bearerbox > language". > > Sqlbox read sms from send_sms table, send them to bearerbox and move sms > to sent_sms table. > > Regards > > Alvaro > > > |-----------------------------------------------------------------------------------------------------------------| > Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier > celular y Nextel > en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS > y GPRS online > Visitenos en www.perusms.com > > On Tue, Apr 14, 2015 at 3:17 PM, Ali Kashif <syedalikas...@gmail.com> > wrote: > >> Dear Users, >> >> I am trying to create a black list system using sqlbox. >> >> I have >> >> openSMPP --> SQLBox --> Kannel >> >> ### SMPPbox ### >> group = core >> dlr-storage = internal >> group = opensmppbox >> opensmppbox-id = smppbox1 >> opensmppbox-port = 9999 >> bearerbox-host = 127.0.0.1 >> bearerbox-port = 13002 >> ---------------- >> >> >> ### SQLBOX ### >> >> group = sqlbox >> id = sqlbox-db >> smsbox-id = sqlbox >> bearerbox-host = localhost >> bearerbox-port = 13001 >> smsbox-port = 13002 >> smsbox-port-ssl = false >> sql-log-table = sent_sms >> sql-insert-table = send_sms >> ---------------- >> >> ### kannel ### >> >> group = core >> admin-port = 13000 >> admin-password = xxxx >> smsbox-port = 13001 >> >> group = smsbox >> bearerbox-host = 127.0.0.1 >> sendsms-port = 13131 >> ------------------------------------------ >> >> >> I was under impression that openSMPP send messages to SQLBox and uses >> send_sms table. so i have written some triggers on send_sms table, which >> are working as expected, when i perform any insert on send_sms table; >> >> but apparently openSMPP is not inserting messages in send_sms and doing >> something else. (may be i am wrong, i need correction here). >> >> >> My main question is How openSMPP delivers messages to SQLBOX and how >> SQLBox forwardes that to Kannel. >> >> Does openSMPP inserts messages to send_sms table or it uses some >> different method? >> >> >> Can anyone Please advise. >> >> Thanks >> Ali >> >> >> >