MySQL Squid Access Report, mysar for short, is a reporting system

for user web traffic activity, as logged from a squid proxy.

MySAR consists of two parts:

    * Command line utilities which import a squid log file in a
      MySQL database and maintain the databas.
    * A web interface for accessing the reports.

WWW: http://giannis.stoilis.gr/software/mysar/index.php?id=16
Author: Giannis Stoilis <giannis@stoilis.gr>

8 files changed, 210 insertions, 0 deletions

diff --git a/www/mysar/Makefile b/www/mysar/Makefile
new file mode 100644
index 000000000000..a0fdd1697815
--- /dev/null
+++ b/www/mysar/Makefile
@@ -0,0 +1,50 @@
+#
+# ports collection makefile for:	mysar
+# Whom:					Edwin Groothuis <edwin@mavetju.org>
+# Date created:				2006-01-10
+#
+# $FreeBSD$
+#
+
+PORTNAME=	mySAR
+PORTVERSION=	2.0.7
+CATEGORIES=	www
+MASTER_SITES=	${MASTER_SITE_SOURCEFORGE}
+MASTER_SITE_SUBDIR=	mysar
+DISTNAME=	${PORTNAME:L}-${PORTVERSION}
+
+MAINTAINER=	edwin@mavetju.org
+COMMENT=	MySQL Squid Access Report
+
+WRKSRC=		${WRKDIR}/${PORTNAME:L}
+USE_MYSQL=	yes
+USE_PHP=	mysql
+USE_REINPLACE=	yes
+NO_BUILD=	yes
+
+MYSARPREFIX=	mysar
+MYSARDIR?=	${PREFIX}/${MYSARPREFIX}
+PLIST_SUB=	MYSAR=${MYSARPREFIX}
+
+SUB_FILES=	pkg-message
+SUB_LIST=	MYSARDIR=${MYSARDIR}
+PKGMESSAGE=	${WRKDIR}/pkg-message
+
+post-patch:
+	${REINPLACE_CMD} -e 's,%%MYSARDIR%%,${MYSARDIR},g' \
+		${WRKSRC}/etc/*
+	${REINPLACE_CMD} -e 's,%%PHP%%,${LOCALBASE}/bin/php,g' \
+		${WRKSRC}/bin/*
+
+	${FIND} ${WRKSRC} -name *.orig -delete
+	${FIND} ${WRKSRC} -name *.bak -delete
+
+do-install:
+	${MKDIR} ${MYSARDIR}
+	${CP} -R ${WRKSRC}/* ${MYSARDIR}
+	${CHOWN} -R ${WWWOWN} ${MYSARDIR}/www-templates
+	${CHOWN} -R ${WWWOWN} ${MYSARDIR}/smarty-tmp
+
+post-install:
+	${CAT} ${PKGMESSAGE}
+.include <bsd.port.mk>
diff --git a/www/mysar/distinfo b/www/mysar/distinfo
new file mode 100644
index 000000000000..0d3df3da6032
--- /dev/null
+++ b/www/mysar/distinfo
@@ -0,0 +1,3 @@
+MD5 (mysar-2.0.7.tar.gz) = 3d8d95889a295c9c9c3a31f22d9544b2
+SHA256 (mysar-2.0.7.tar.gz) = fce85db8d41141c609bc3cf713b74b41516926abf19f35edcac0494cc4df03a2
+SIZE (mysar-2.0.7.tar.gz) = 120682
diff --git a/www/mysar/files/patch-bin_mysar-importer.php b/www/mysar/files/patch-bin_mysar-importer.php
new file mode 100644
index 000000000000..9511ecfb1c45
--- /dev/null
+++ b/www/mysar/files/patch-bin_mysar-importer.php
@@ -0,0 +1,11 @@
+--- bin/mysar-importer.php.orig	Wed Jan 11 15:03:03 2006
++++ bin/mysar-importer.php	Wed Jan 11 15:03:26 2006
+@@ -123,7 +123,7 @@
+ 	$dbRecord['resultCode']=$record[3];

+ 	$dbRecord['bytes']=$record[4];

+ 	$dbRecord['url']=addslashes($record[6]);

+-	$dbRecord['authuser']=$record[7];

++	$dbRecord['authuser']=substr($record[7],0,20);

+ 

+ 	$resultCodeArray=explode('/',$dbRecord['resultCode']);

+ 	if(in_array($resultCodeArray[0],$inCacheCodes)) {

diff --git a/www/mysar/files/patch-etc_mysar.apache b/www/mysar/files/patch-etc_mysar.apache
new file mode 100644
index 000000000000..0268a26173ad
--- /dev/null
+++ b/www/mysar/files/patch-etc_mysar.apache
@@ -0,0 +1,5 @@
+--- etc/mysar.apache.orig	Tue Jan 10 10:33:30 2006
++++ etc/mysar.apache	Tue Jan 10 10:33:38 2006
+@@ -1 +1 @@
+-Alias /mysar /usr/local/mysar/www
++Alias /mysar %%LOCALBASE%%/mysar/www
diff --git a/www/mysar/files/patch-etc_mysar.cron b/www/mysar/files/patch-etc_mysar.cron
new file mode 100644
index 000000000000..ea40d96a9cd4
--- /dev/null
+++ b/www/mysar/files/patch-etc_mysar.cron
@@ -0,0 +1,9 @@
+--- etc/mysar.cron.orig	Tue Jan 10 10:33:43 2006
++++ etc/mysar.cron	Tue Jan 10 10:34:26 2006
+@@ -1,3 +1,3 @@
+-* * * * *	root	/usr/local/mysar/bin/mysar-importer.php > /usr/local/mysar/log/mysar-importer.log 2>&1
+-* * * * *	root	/usr/local/mysar/bin/mysar-resolver.php > /usr/local/mysar/log/mysar-resolver.log 2>&1
+-0 0 * * *	root	/usr/local/mysar/bin/mysar-maintenance.php /usr/local/mysar/log/mysar-maintenance.log 2>&1
++* * * * *	root	%%MYSARDIR%%/bin/mysar-importer.php > %%MYSARDIR%%/log/mysar-importer.log 2>&1
++* * * * *	root	%%MYSARDIR%%/bin/mysar-resolver.php > %%MYSARDIR%%/log/mysar-resolver.log 2>&1
++0 0 * * *	root	%%MYSARDIR%%/bin/mysar-maintenance.php %%MYSARDIR%%/log/mysar-maintenance.log 2>&1
diff --git a/www/mysar/files/pkg-message.in b/www/mysar/files/pkg-message.in
new file mode 100644
index 000000000000..8c32969e86d0
--- /dev/null
+++ b/www/mysar/files/pkg-message.in
@@ -0,0 +1,8 @@
+Add the following statement to your Apache configuration:
+	Alias /mysar %%MYSARDIR%%/www
+
+Add the following contents to %%MYSARDIR%%/etc/config.ini
+	dbUser = mysar
+	dbPass = mysar
+	dbHost = localhost
+	dbName = mysar
diff --git a/www/mysar/pkg-descr b/www/mysar/pkg-descr
new file mode 100644
index 000000000000..aa8ece3d4d91
--- /dev/null
+++ b/www/mysar/pkg-descr
@@ -0,0 +1,11 @@
+MySQL Squid Access Report, mysar for short, is a reporting system
+for user web traffic activity, as logged from a squid proxy.
+
+MySAR consists of two parts:
+
+    * Command line utilities which import a squid log file in a
+      MySQL database and maintain the databas.
+    * A web interface for accessing the reports. 
+
+WWW: http://giannis.stoilis.gr/software/mysar/index.php?id=16
+Author: Giannis Stoilis <giannis@stoilis.gr>
diff --git a/www/mysar/pkg-plist b/www/mysar/pkg-plist
new file mode 100644
index 000000000000..9f4085654f16
--- /dev/null
+++ b/www/mysar/pkg-plist
@@ -0,0 +1,113 @@
+%%MYSAR%%/COPYING
+%%MYSAR%%/INSTALL
+%%MYSAR%%/README
+%%MYSAR%%/TODO
+%%MYSAR%%/UPGRADE
+%%MYSAR%%/bin/mysar-importer.php
+%%MYSAR%%/bin/mysar-maintenance.php
+%%MYSAR%%/bin/mysar-resolver.php
+%%MYSAR%%/etc/mysar.apache
+%%MYSAR%%/etc/mysar.cron
+%%MYSAR%%/inc/common.inc.php
+%%MYSAR%%/inc/functions.inc.php
+%%MYSAR%%/inc/smarty/Config_File.class.php
+%%MYSAR%%/inc/smarty/Smarty.class.php
+%%MYSAR%%/inc/smarty/Smarty_Compiler.class.php
+%%MYSAR%%/inc/smarty/debug.tpl
+%%MYSAR%%/inc/smarty/internals/core.assemble_plugin_filepath.php
+%%MYSAR%%/inc/smarty/internals/core.assign_smarty_interface.php
+%%MYSAR%%/inc/smarty/internals/core.create_dir_structure.php
+%%MYSAR%%/inc/smarty/internals/core.display_debug_console.php
+%%MYSAR%%/inc/smarty/internals/core.get_include_path.php
+%%MYSAR%%/inc/smarty/internals/core.get_microtime.php
+%%MYSAR%%/inc/smarty/internals/core.get_php_resource.php
+%%MYSAR%%/inc/smarty/internals/core.is_secure.php
+%%MYSAR%%/inc/smarty/internals/core.is_trusted.php
+%%MYSAR%%/inc/smarty/internals/core.load_plugins.php
+%%MYSAR%%/inc/smarty/internals/core.load_resource_plugin.php
+%%MYSAR%%/inc/smarty/internals/core.process_cached_inserts.php
+%%MYSAR%%/inc/smarty/internals/core.process_compiled_include.php
+%%MYSAR%%/inc/smarty/internals/core.read_cache_file.php
+%%MYSAR%%/inc/smarty/internals/core.rm_auto.php
+%%MYSAR%%/inc/smarty/internals/core.rmdir.php
+%%MYSAR%%/inc/smarty/internals/core.run_insert_handler.php
+%%MYSAR%%/inc/smarty/internals/core.smarty_include_php.php
+%%MYSAR%%/inc/smarty/internals/core.write_cache_file.php
+%%MYSAR%%/inc/smarty/internals/core.write_compiled_include.php
+%%MYSAR%%/inc/smarty/internals/core.write_compiled_resource.php
+%%MYSAR%%/inc/smarty/internals/core.write_file.php
+%%MYSAR%%/inc/smarty/plugins/block.textformat.php
+%%MYSAR%%/inc/smarty/plugins/compiler.assign.php
+%%MYSAR%%/inc/smarty/plugins/function.assign_debug_info.php
+%%MYSAR%%/inc/smarty/plugins/function.config_load.php
+%%MYSAR%%/inc/smarty/plugins/function.counter.php
+%%MYSAR%%/inc/smarty/plugins/function.cycle.php
+%%MYSAR%%/inc/smarty/plugins/function.debug.php
+%%MYSAR%%/inc/smarty/plugins/function.eval.php
+%%MYSAR%%/inc/smarty/plugins/function.fetch.php
+%%MYSAR%%/inc/smarty/plugins/function.html_checkboxes.php
+%%MYSAR%%/inc/smarty/plugins/function.html_image.php
+%%MYSAR%%/inc/smarty/plugins/function.html_options.php
+%%MYSAR%%/inc/smarty/plugins/function.html_radios.php
+%%MYSAR%%/inc/smarty/plugins/function.html_select_date.php
+%%MYSAR%%/inc/smarty/plugins/function.html_select_time.php
+%%MYSAR%%/inc/smarty/plugins/function.html_table.php
+%%MYSAR%%/inc/smarty/plugins/function.mailto.php
+%%MYSAR%%/inc/smarty/plugins/function.math.php
+%%MYSAR%%/inc/smarty/plugins/function.popup.php
+%%MYSAR%%/inc/smarty/plugins/function.popup_init.php
+%%MYSAR%%/inc/smarty/plugins/modifier.capitalize.php
+%%MYSAR%%/inc/smarty/plugins/modifier.cat.php
+%%MYSAR%%/inc/smarty/plugins/modifier.count_characters.php
+%%MYSAR%%/inc/smarty/plugins/modifier.count_paragraphs.php
+%%MYSAR%%/inc/smarty/plugins/modifier.count_sentences.php
+%%MYSAR%%/inc/smarty/plugins/modifier.count_words.php
+%%MYSAR%%/inc/smarty/plugins/modifier.date_format.php
+%%MYSAR%%/inc/smarty/plugins/modifier.debug_print_var.php
+%%MYSAR%%/inc/smarty/plugins/modifier.default.php
+%%MYSAR%%/inc/smarty/plugins/modifier.escape.php
+%%MYSAR%%/inc/smarty/plugins/modifier.indent.php
+%%MYSAR%%/inc/smarty/plugins/modifier.lower.php
+%%MYSAR%%/inc/smarty/plugins/modifier.nl2br.php
+%%MYSAR%%/inc/smarty/plugins/modifier.regex_replace.php
+%%MYSAR%%/inc/smarty/plugins/modifier.replace.php
+%%MYSAR%%/inc/smarty/plugins/modifier.spacify.php
+%%MYSAR%%/inc/smarty/plugins/modifier.string_format.php
+%%MYSAR%%/inc/smarty/plugins/modifier.strip.php
+%%MYSAR%%/inc/smarty/plugins/modifier.strip_tags.php
+%%MYSAR%%/inc/smarty/plugins/modifier.truncate.php
+%%MYSAR%%/inc/smarty/plugins/modifier.upper.php
+%%MYSAR%%/inc/smarty/plugins/modifier.wordwrap.php
+%%MYSAR%%/inc/smarty/plugins/outputfilter.trimwhitespace.php
+%%MYSAR%%/inc/smarty/plugins/shared.escape_special_chars.php
+%%MYSAR%%/inc/smarty/plugins/shared.make_timestamp.php
+%%MYSAR%%/log/.keep
+%%MYSAR%%/smarty-tmp
+%%MYSAR%%/www-templates/IPSitesSummary.tpl
+%%MYSAR%%/www-templates/IPSummary.tpl
+%%MYSAR%%/www-templates/administration.tpl
+%%MYSAR%%/www-templates/allsites.tpl
+%%MYSAR%%/www-templates/details.tpl
+%%MYSAR%%/www-templates/footer.tpl
+%%MYSAR%%/www-templates/header.tpl
+%%MYSAR%%/www-templates/index.tpl
+%%MYSAR%%/www-templates/siteusers.tpl
+%%MYSAR%%/www/dfl.css
+%%MYSAR%%/www/images/down-arrow.gif
+%%MYSAR%%/www/images/splash_main.gif
+%%MYSAR%%/www/images/up-arrow.gif
+%%MYSAR%%/www/index.php
+%%MYSAR%%/www/install/index.php
+@dirrm %%MYSAR%%/bin
+@dirrm %%MYSAR%%/etc
+@dirrm %%MYSAR%%/inc/smarty/internals
+@dirrm %%MYSAR%%/inc/smarty/plugins
+@dirrm %%MYSAR%%/inc/smarty
+@dirrm %%MYSAR%%/inc
+@dirrm %%MYSAR%%/smarty-tmp
+@dirrm %%MYSAR%%/log
+@dirrm %%MYSAR%%/www-templates
+@dirrm %%MYSAR%%/www/images
+@dirrm %%MYSAR%%/www/install
+@dirrm %%MYSAR%%/www
+@dirrm %%MYSAR%%