Wednesday, June 2, 2010

Install AWStats on CentOS 5.3

SkyHi @ Wednesday, June 02, 2010

From AWstats website: “AWStats is a free powerful and featureful tool that generates advanced web, streaming, ftp or mail server statistics, graphically. This log analyzer works as a CGI or from command line and shows you all possible information your log contains, in few graphical web pages. It uses a partial information file to be able to process large log files, often and quickly. It can analyze log files from all major server tools like Apache log files (NCSA combined/XLF/ELF log format or common/CLF log format), WebStar, IIS (W3C log format) and a lot of other web, proxy, wap, streaming servers, mail servers and some ftp servers.”


The installation procedure is done on a typical LAMP install on CentOS 5.3 x64_86

Your apache needs the combined log directive for the virtual host you are going to monitor with AWStats, so in your virtualhost you must have something like:

CustomLog logs/example.com-access_log combined

If you use the common log format some statistic features (browsers, os, keywords…) can’t work.


In this tutorial I am using example.com so change it with your own domain and docroot location.


As root install the rpmforge repository:


# wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.3.6-1.el5.rf.x86_64.rpm

# rpm -Uvh rpmforge-release-0.3.6-1.el5.rf.x86_64.rpm


# yum install yum-priorities # if you have other repos you might want to add the priority options in the .repo file so you don’t mess up packages. More info


In case you are using i386 change the .x86_64 with .i386


# yum install awstats


Optional: (To see what countries are visiting your website)


# yum install perl-Geo-IP

# yum install GeoIP-data


Prepare the configuration file:


# cd /etc/awstats

# mv awstats.model.conf awstats.model.bak # Keep a backup of the original

# mv awstats.localhost.localdomain.conf awstats.example.com.conf # Change it to your domain


Edit the configuration file:


# vi /etc/awstats/awstats.example.com.conf


In line 51: change LogFile=”/var/log/httpd/access_log” to the location of the access_log file you want to gather statistics.


Ex: LogFile=”/var/log/httpd/example.com-access_log”


In line 153: change SiteDomain=”localhost.localdomain” to SiteDomain=”example.com


In line 168: change HostAliases=”localhost 127.0.0.1″ to HostAliases=”www.example.com”


In line 203: change DirData=”/var/www/awstats” to your docroot.

Ex: DirData=”/var/www/htdocs/example.com/awstats”


If you installed the Geo-IP plugins you need to enable it:


In line 1305 change #LoadPlugin=”geoip GEOIP_STANDARD /pathto/GeoIP.dat” to LoadPlugin=”geoip GEOIP_STANDARD /var/lib/GeoIP/GeoIP.dat”


Move the awstats directory to your docroot:


//uncessary, check http://shebangme.blogspot.com/2010/06/install-awstats-on-centos-5.html

# mv /var/www/awstats /var/www/htdocs/example.com


Change the permissions to the awstats directory:


# chown -R localuser:apache /var/www/htdocs/example.com/awstats


Edit the awstats.conf to setup the aliases and restrictions:


# vi /etc/httpd/conf.d/awstats.conf


Change the Alias, ScriptAlias and Directory location to where the awstats is in your docroot.


ex:


Alias /awstats/icon/ /var/www/htdocs/example.com/awstats/icon/

ScriptAlias /awstats/ /var/www/htdocs/example.com/awstats/



<Directory /var/www/htdocs/example.com/awstats/>

DirectoryIndex awstats.pl

Options ExecCGI

order deny,allow

deny from all

allow from 192.168.1. 66.80.199.111 # Allow access to awstate from the 192.168.1.0/24 subnet only

</Directory>


#Alias /css/ /var/www/awstats/css/

#Alias /js/ /var/www/awstats/js/


Reload Apache:


# service httpd reload


In case you don’t have the Options FollowSymLinks in httpd.conf, awstats will not work so you need to add it in the /etc/httpd/conf.d/awstats.conf above.

……..

Options ExecCGI

Options FollowSymLinks

……..


Update your statistics:


# cd /var/www/htdocs/example.com/awstats


# perl awstats.pl -config=example.com -update


If you see something like:


Create/Update database for config “/etc/awstats/awstats.example.com.conf” by AWStats version 6.9 (build 1.925)

From data in log file “/var/log/httpd/example.com-access_log”…

Phase 1 : First bypass old records, searching new record…

Direct access after last parsed record (after line 4)

Jumped lines in file: 4

Found 4 already parsed records.

Parsed lines in file: 13

Found 0 dropped records,

Found 0 corrupted records,

Found 0 old records,

Found 13 new qualified records.


Then everything went fine.


If you changed your logs from common to combined it might throw some errors when you update awstats so you need to clean the log file to have only the combined logs:


# cat /dev/null > /var/log/httpd/example.com-access_log


run the update again:


# perl awstats.pl -config=example.com -update

Update for config "/etc/awstats/awstats.example.com.conf"

With data in log file ""

Phase 1:

Seaching new records from beginning of log file

Phase 2:

Found 2389 new qualified records.


Navigate to http://example.com/awstats/awstats.pl


If the update time on the upper left hand corner is the same as the time you run the awstats.pl update and you can see the statistics, then everything works fine.


Setup the cron job (it will run hourly and redirect the output to /dev/null so it’s not going to send an email to root every hour) :


cd /etc/cron.hourly

echo “perl /var/www/htdocs/example.com/awstats/awstats.pl -config=example.com -update > /dev/null 2>&1″ > awstats.sh

chmod 755 awstats.sh


test the script:


./awstats.sh

Refresh your browser and if the update time changes then you are all set.


Enjoy the statistics on your website!


REFERENCES

http://beginlinux.com/blog/2009/04/awstats-graphical-view-of-your-logs/