[Atif_Khan]

Dear All,

I need a script which can parse qpopper logs file and extract the date, username and password from qpopper logs into flat file.

The format of the log is below

Aug 27 03:56:32 sktmail popper[12994]: (v4.0.Cool POP login by user "assad" PASS=assad 192.168.2.1 192.168.1.1 [pop_log.c:247]
Aug 27 03:59:33 sktmail popper[13020]: (v4.0.Cool POP login by user "tariq" PASS=tariq 192.168.2.1 192.168.1.1 [pop_log.c:247]
Aug 27 04:50:33 sktmail popper[13020]: (v4.0.Cool POP login by user "james" PASS=james 192.168.2.1 192.168.1.1 [pop_log.c:247]

Now the script will do following
1: Separate the date , username and password.
2: Check the username in existing database/plain file.
3: if user not found in database/plain file add it in database/plain file with username and password.
4: if user found in database/plain file then update the password in database/plain file.

Waiting for replies.

[Boraan]

eew. Flat files are nasty for content management. I'll charge you to build the whole application, but I'll use a database instead of a flatfile, and you'll have a nice admin area to view any stats that you need. I can also add a print view where you can select what information you need as well.