SQLBOX box sits between Bearerbox and SMSbox like this: Operator SMSC > BEARERBOX > SQLBOX > SMSBOX
With correct config, it is able to relay the whole traffic MO,MT,DLR in both directions and logs everything. Please try to setup SQLBOX. It will solve all your problems. On Mon, Jun 9, 2014 at 11:22 PM, Ali Kashif <syedalikas...@gmail.com> wrote: > I have seen sqlbox my configurations are like this > > SMPP --> SQLBOX --> KANNEL --> SMSC > > so sqlbox do not have information about outgoing SMSC, it do have all > incoming SMS details which i am already using for my client billing. > In sqlbox there are DLRs which do have the outgoing SMSc, but that is not > reliable, as i never receive all DLRs, and some time DLR is not even > requested. > > > i can understand the i can process the log file daily at at certain time > and get all smsc like > > 2014-06-06 12:09:38 Sent SMS [SMSC:XXXX]. > > but still I would like to experiment with moding kannel, and try saving > count at time of sending SMS. (no offline processing, live statics ;) ) > > so any idea where should i be modifing . > > > Thanks > Ali > > > > > > > > On Mon, Jun 9, 2014 at 6:11 PM, Alvaro Cornejo <cornejo.alv...@gmail.com> > wrote: > >> You can also run wc command on your log files >> >> |-----------------------------------------------------------------------------------------------------------------| >> 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 Mon, Jun 9, 2014 at 9:42 AM, spameden <spame...@gmail.com> wrote: >> > >> > >> > >> > 2014-06-09 17:46 GMT+04:00 ha...@aeon.pk <ha...@aeon.pk>: >> > >> >> 'Grep' the date, message status (Sent) and then SMSC id in the >> access.log >> >> file from Linux command prompt. >> >> >> >> Alternatively, you can run MySQL query over sentsms table if you are >> using >> >> sqlbox (which is the best way). >> >> >> >> >> >> On Sun, Jun 1, 2014 at 1:22 PM, Ali Kashif <syedalikas...@gmail.com> >> >> wrote: >> >>> >> >>> Dear Users, >> >>> >> >>> I have multiple SMSCs connected, and Kannel is doing some prefix based >> >>> routing of messages, >> >>> >> >>> At end of month i need to count how many messages has been sent from >> each >> >>> SMSc, >> >>> >> >>> I can see the access.log for kannel and there is >> >>> >> >>> 2014-06-01 08:04:59 Sent SMS [SMSC:nahsms] >> >>> >> >>> i was thinking if i can add a mysql query in place where the above >> log is >> >>> being writen, >> >>> which just update number in mysql table against SMSC, >> >>> >> >>> >> >>> Can anyone me tell me which file i should look and modify. >> >>> >> >>> >> >>> and Will that be a good idea, considering that i am sending 100,000 >> SMS >> >>> per day. >> > >> > >> > Check sqlbox it might suit all your needs if you tweak it a bit. >> > >> >>> >> >>> >> >>> >> >>> Thanks >> >>> Ali >> >> >> >> >> > >> >> >
