No, if you connect opensmppbox via sqlbox then it will insert the messages in sent_sms (as opposed to send_sms).
However, a trigger wont help here Even if you remove those messages, they will still be forwarded to bearerbox. == Rene From: users [mailto:users-boun...@kannel.org] On Behalf Of Alvaro Cornejo Sent: dinsdag 14 april 2015 23:22 To: Ali Kashif Cc: users@kannel.org Subject: Re: sqlbox send_sms and openSMPP 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