Thanks Renu for information, i got it trigger will not help me. i think i need to mod the sqlbox but for that i need to understand it first. i am bit stuck with one question
Does openSMPP handover message to SQLbox and SQLBox logs and forwards it to bearerbox or OpenSMPP hands over message to bearerbox and SQLBox reads message from it and then logs message in its logtable. Thanks Ali On Wed, Apr 15, 2015 at 11:55 PM, Rene Kluwen <rene.klu...@chimit.nl> wrote: > No, if you connect opensmppbox via sqlbox then it will insert the messages > in sent_sms (as opposed to send_sms). > > However, a trigger won’t 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 > > > > > > >
