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 > >> > >> > > > >