Apache 2.0 logfile setup

[renewest]

How do I setup the Apache 2.0 so that, if possible at all, I get information in the logfile that shows where visitors came from?

[tgo]

I dont think apache holds referers in logs except for on some errors. But here is a php script I wrote that count unique hits that you can use.

<?php
// get name of current page
$script = $_SERVER['PHP_SELF'];

// break the array in directories and the script name
$all = explode('/',$script);

//get name of page
$spot = count($all) -1;
$script = $all[$spot];
$ip = $_SERVER['REMOTE_ADDR'];

// query to check for whether the page is in the table or not
$link = "SELECT * FROM hits WHERE script='$script'";
$res = mysql_query($link) or die(mysql_error());
$total = mysql_num_rows($res);
$row = mysql_fetch_assoc($res);

// if its not then add it with one hit
if ($total == 0)
{
	$add = "INSERT INTO hits VALUES('$script','1','$ip')";
	$addit = mysql_query($add) or die(mysql_error());
}
else
{
        // if it is and its not from an ip thats already hit it then add it	
	$ips = $row['ips'];
	if (!strstr($ips,$ip))
	{
		$newtotal = $row['total'] + 1;
		$ips .= $ip;
		$update = mysql_query("UPDATE hits SET total='$newtotal',ips='$ips' WHERE script='$script'") or die(mysql_error());
	}
}
?>

And the code to make the table:

<?php
 $stats = "CREATE TABLE `hits` (
    `script` TEXT NOT NULL,
    `total` INT ( 11 ),
    `ips` TEXT NOT NULL );";
    $table = mysql_query($stats) or die(mysql_error());
?>

To use it just create the table and name the file stats.php. Then whatever pages you want tracked add

<?php include("stats.php"); ?>

[LoneWolf071]

or you could just look in the /var/log/apache or apache2 dir where all the log files are kept.

[tgo]

Originally Posted by LoneWolf071

or you could just look in the /var/log/apache or apache2 dir where all the log files are kept.

Only error_log holds the referer so thats not very useful.

[LoneWolf071]

no, apache also writes access.log which tells where they came from...

192.168.1.1 - - [08/Nov/2005:20:02:49 -0600] "GET /testphp.php HTTP/1.1" 200 171 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1...

that's quite helpful in locating where there from and what their doing...

[Squashman]

Why not just use Awstats.
http://awstats.sourceforge.net/

[renewest]

Hi,
I am using Awstats and it works great except that some info is missing i.e. :
browser type
OS
referer
search criteria


My question is how can I configure APache 2.0 in such a way that it does log these data.

Rene

[LoneWolf071]

again, the apache access log file tells you all that info...

192.168.1.1 - - [08/Nov/2005:20:02:49 -0600] "GET /testphp.php HTTP/1.1" 200 171 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1... -- That's Telling You What OS, What Browser, It Tells You what they access and what criteria they enter. it's very good at what it does... /var/log/apache/access.log or /var/log/apache2/access.log

[Squashman]

Originally Posted by renewest

Hi,
I am using Awstats and it works great except that some info is missing i.e. :
browser type
OS
referer
search criteria

I just went to the Awstats Demo and it shows all that stuff. What am I not understanding.