Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: trenskow on September 03, 2004, 12:49:22 AM

Title: does my howto work as intended
Post by: trenskow on September 03, 2004, 12:49:22 AM

Hi there.
I wanted to monitor my mail stats with awstats, and i couldnt find anything for is, sp i set out to find out myself, and in the process ended up making this howto.

Could someone try to follow it, to see if it works as intended.

http://www.trenskow.dk/sme/awstats_mail.html

Title: does my howto work as intended
Post by: mbachmann on September 03, 2004, 10:31:22 AM

Nice, although i did not follow it. There is an email monitoring contrib called isoqlog, search saco-mitel-isoqlog-0.1-09.noarch.rpm.

Title: does my howto work as intended
Post by: Knuddi on September 03, 2004, 10:33:02 AM

Hi Rasmus,

Seem to work fine. I have a one little correction though:

LevelForBrowsersDetection=0=0 (properly only one Zero)

I think that I will make this a part of my script sometime in the future :-)

Rgds,
Jesper Knudsen

Title: does my howto work as intended
Post by: Knuddi on September 03, 2004, 10:41:45 AM

Another little one:

DirCgi="/awstats/cgi-bin"
DirIcons="/awstats/icon"

/jesper

Title: does my howto work as intended
Post by: trenskow on September 03, 2004, 11:20:30 AM

thanks for the feeback  :-)
i will make the corrections when i come home.

i have found something myself, i get this error from Cron Deamon

/etc/cron.hourly/awstats:

Update for config "./awstats.mail.trenskow.dk.conf"
With data in log file "tai64nlocal < /var/log/qmail/current | /home/e-smith/files/ibays/awstats/cgi-bin/maillogconvert.pl standard |"...
sh: tai64nlocal: command not found

it doesnt recognize tai64nlocal from cron, but if i run the update manually, it works fine.
Someone know why that is?

Title: does my howto work as intended
Post by: Knuddi on September 03, 2004, 11:30:00 AM

In cron you need a complete path for all items.

The .conf file needs this:

LogFile="/usr/local/bin/tai64nlocal < /var/log/qmail/current | /home/e-smith/files/ibays/awstats/cgi-bin/maillogconvert.pl standard |"

Title: does my howto work as intended
Post by: trenskow on September 03, 2004, 08:35:40 PM

all the changes written here, have been made.

I will add it to the how-to tomorow if there are found no more faults

Title: does my howto work as intended
Post by: trenskow on September 03, 2004, 08:39:12 PM

Quote from: "Knuddi"

Hi Rasmus,

I think that I will make this a part of my script sometime in the future :-)

Rgds,
Jesper Knudsen

You are very welcome.  8-)

Title: does my howto work as intended
Post by: trenskow on September 04, 2004, 11:07:40 PM

hmm... cannot add the howto, whenever i try, i get this error here

Contribs.org Error

Error Code: 0013


ERROR: Could not query the database.
Error:

Title: Email Web statistics
Post by: cosy on October 05, 2004, 01:52:04 PM

Hi,

  can you make a how to's for  email the web site statistics to each customer

Title: Re: Email Web statistics
Post by: trenskow on October 06, 2004, 01:21:35 AM

Quote from: "cosy"

Hi,

  can you make a how to's for  email the web site statistics to each customer

Do you mean multiple domains?
ie www.mydomain.com, www.mydomain1.org, www.whatever.ru?

Or do you mean, that you want an email sent to the customer, with the stats of the website?

Title: does my howto work as intended
Post by: cosy on October 07, 2004, 06:46:23 AM

Hi ,

 I already got 5 virtual domain so i need to email staticstics to customer. thanks.

Title: can you help pls
Post by: cosy on October 29, 2004, 08:41:12 AM

Or do you mean, that you want an email sent to the customer, with the stats of the website?

Yes i need to email stats.

Title: Re: does my howto work as intended
Post by: arnoldob on January 28, 2005, 11:29:37 PM

Quote from: "trenskow"

Hi there.
I wanted to monitor my mail stats with awstats, and i couldnt find anything for is, sp i set out to find out myself, and in the process ended up making this howto.

Could someone try to follow it, to see if it works as intended.

http://www.trenskow.dk/sme/awstats_mail.html

When I followed the howto I got an hourly cron job e-mail in my admin account. I fixed this by making a change to:

/etc/cron.hourly/awstats

Code: [Select]

#!/bin/bash
cd /home/e-smith/files/ibays/awstats/cgi-bin
perl awstats.pl -config=mail.yourdomain.com -update

I changed it to this:

Code: [Select]

#!/bin/bash
cd /home/e-smith/files/ibays/awstats/cgi-bin
perl awstats.pl -config=mail.yourdomain.com -update >/tmp/null

You might want to make that change to your how-to webpage. I got tired of deleting 24 cron job e-mails everyday :)
Thank you for your work!

Title: does my howto work as intended
Post by: Mael on February 10, 2005, 01:08:52 PM

Hi All,

I've played with Awstats for mail logging on my side as well and I was not so happy with logging just from /var/log/qmail/current.

The problem I saw was that Awstats is updated every hour from current.
And multilog rotates current based on size and not time.

So each time current is rotated, you will loose all the information logged in current between the last Awstats update and the rotation from multilog.

I've solved this in /etc/cron.hourly/awstats,
I've added a line to check for any file in /var/log/qmail
whose name is starting with @ and not older than 60 minutes.
If such file(s) exists I process it(them) with maillogconvert.pl like for current and then I process current.

Hope this helps

Mael

Title: does my howto work as intended
Post by: arnoldob on February 10, 2005, 02:17:36 PM

Can you post the code you added to the hourly cron job?

Thanks

Title: does my howto work as intended
Post by: Mael on February 10, 2005, 03:15:10 PM

Edit:

So I use a temporay file called mailtemp to store  the intermediate processes

This is my qmail part of /etc/cron.hourly/awstats

Code: [Select]

find /var/log/qmail/ -mmin -60 -name "\@*" | xargs cat | /usr/local/bin/tai64nlocal > /var/log/qmail/mailtmp
cat /var/log/qmail/current |/usr/local/bin/tai64nlocal >> /var/log/qmail/mailtmp
perl awstats.pl -config=qmail -update >/tmp/null

and this is the part of my awstats.qmail.conf

Code: [Select]

LogFile="perl /home/e-smith/files/ibays/awstats/cgi-bin/maillogconvert.pl standard < /var/log/qmail/mailtmp |"

Feel free to comment and improve


Mael