Hello Seems a little bit confusing using Kannel to send some_big_number_of_messages_daily and at the end of day,You still have to use old bash tools to parse Kannel's log file to analyze Your traffic ? :(
Don't know for CIMD,but SMPP and UCP will give You an acknoledge on every message You send via particular SMSC. For example,You're using SMPP ok. You try to send one message by using submit_sm SMPP command,if Your software/client application does not receive submit_sm_resp within let's say 2 seconds,You application should mark that message as failed by remote SMSC or some similar error. Only thing that is left for You is to 'select count (*) from messages_table where status='failed'' or something similar. I mean parsing log files for this amount of traffic seems a little bit ....confusing ? Sincerely Dragan > ----- Original Message ----- > From: "Mihai Zsigmond" <[EMAIL PROTECTED]> > To: [email protected] > Subject: Re: dump access.log to a database > Date: Fri, 25 Apr 2008 08:40:08 +0300 > > Hi Luis, > Look on previous answers on the same topic : inserting the logs in a > database. > The idea is that it can be done, in fact I have written some time ago a > perl script called from crontab to do this. > > You must take into account the following issues: > 1) It is not such real-time as it may seems. Depending on your traffic it > may take up to a few minutes to get the last line. > 2) The system must handle the overhead of the operation. > > In such cases, depending on the information you need I recommend pooling > the status of the Kannel instance you work with (for instance failed > sms). If the status changes, you go down to logs to look for specific > information. > > Hope it helps. > > Regards, > Mihai > > Luis Valencia wrote: > > Thanks Rodrigo, I have try this, but I need to do it at real time so many > times. > > I have to check for Failed sms for every sms that I insert on the table. > And when I put the double piped grep's on a bash script it doesn't work. > > So I thought on insert the access.log to a database on realtime, so I can > run queries any time. > > What do you think? > > Thanks for the help > > -----Original Message----- > From: Rodrigo Cremaschi [ mailto:[EMAIL PROTECTED] ] > Sent: Jueves, 24 de Abril de 2008 07:46 a.m. > To: Luis Valencia > Cc: [email protected] Subject: Re: dump access.log to a database > > It's quite easy to process kannel log files using "cat" and "grep" (or > fgrep) commands. > If you want to know the number of sent SMS for a certain short number, > you may try something like: > > cat access.log | grep "Sent SMS" | grep "\[from: 8888\]" | wc -l > > If your log file is already compressed: > > zcat access.log.gz | ... > > Hope this can help you. > > On Wed, Apr 23, 2008 at 10:08 PM, Luis Valencia > <[EMAIL PROTECTED]> wrote: > > > > > Hi all, > > > > I need to do a lot of searches in the access.log information, but its > > > really > > > nasty to do it on a text plain file. So I want to know if anyone ever > try > to dump the access.log to a Mysql database table so I can run queries on > > > it? > > > > Anyone? Or any other option to do what I want? > > > > Thanks a lot in advance. > > > > Luis GT > > > > > > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > > > > > > -- > Mihai Zsigmond > Telemedia Consult srl > tel: +40 21 316 0577 > mobil: +40 746 091 360 > -- _______________________________________________ Surf the Web in a faster, safer and easier way: Download Opera 9 at http://www.opera.com Powered by Outblaze
