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: "Rodrigo Cremaschi" <[EMAIL PROTECTED]> > To: "Luis Valencia" <[EMAIL PROTECTED]> > Subject: Re: dump access.log to a database > Date: Fri, 25 Apr 2008 11:40:20 -0300 > > > I'm a bit minimalist so I prefer to stick to shell scripts, but it's > OK to use a database. Why not? At some point you will have to parse > the log file. Alejandro suggested using Perl's Tail module, which is > fine. You can also use PERL to preprocess and insert the data. > > > On Thu, Apr 24, 2008 at 3:42 PM, Luis Valencia > <[EMAIL PROTECTED]> 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. > > > > -- > > > > This message has been scanned for viruses and > > dangerous content by MailScanner, and is > > believed to be clean. > > > > > > -- > > > > > > This message has been scanned for viruses and > > dangerous content by MailScanner, and is > > believed to be clean. > > > > > -- _______________________________________________ Surf the Web in a faster, safer and easier way: Download Opera 9 at http://www.opera.com Powered by Outblaze
