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