diff options
author | Rainer Hurling <rhurlin@FreeBSD.org> | 2021-02-08 09:25:18 +0000 |
---|---|---|
committer | Rainer Hurling <rhurlin@FreeBSD.org> | 2021-02-08 09:25:18 +0000 |
commit | d4f08da488ccc72e19f096d15ddbd9408cbaca00 (patch) | |
tree | 98b943121906f22c58b69eb63697c337c062d825 /net | |
parent | 6f3e70604e27b272821937a505704435b5b503e9 (diff) | |
download | ports-d4f08da488ccc72e19f096d15ddbd9408cbaca00.tar.gz ports-d4f08da488ccc72e19f096d15ddbd9408cbaca00.zip |
net/rtg: Update to 0.7.5
* Updated to latest cgilib (0.7)
* Removed old GD/PNG/ZLIB bundled libraries for ease of upgrading
* Added -b (background/daemonise) flag to rtgpoll
* Added -p <file> (PID file) flag to rtgpoll
* Added graph titles and legends to rtgplot
* Updated PHP scripts from ancient mysql to newer mysqli library
* Fixed many potential SQL injection and other vulnerabilities
* Updated MySQL support to compile against MySQL 8.0+
* Updated MySQL support to use mysql_config to pull in
CFLAGS/LDFLAGS required depending on MySQL build
* Updated MySQL table schemas to support clustered MySQL setups
* Updated MySQL table schemas to improve speed (indexes)
* Added MySQL option to auto-reconnect if MySQL server goes away
* Changed default SNMP version to 2
* Removed deprecated SNMP library options
* Added 'Update_desc' option to rtg.con to auto-update interface
descriptions
* Fixed all compilation warnings, even when compiling with
-pedantic -Wall -Werror
* Push config into sysconfdir and web utils into htmldir
* Added -u <user> -g <group> options for rtgpoll to run as user
instead of root
* Added -r <path> chroot option
No changelog, only NEWS file
PR: 253311
Submitted by: Daniel Austin <freebsd-ports@dan.me.uk> (maintainer)
Approved by: arrowd (mentor)
Differential Revision: https://reviews.freebsd.org/D28523
Notes
Notes:
svn path=/head/; revision=564684
Diffstat (limited to 'net')
26 files changed, 39 insertions, 1811 deletions
diff --git a/net/rtg/Makefile b/net/rtg/Makefile index e919cb861e9b..a33acdd8c95b 100644 --- a/net/rtg/Makefile +++ b/net/rtg/Makefile @@ -2,18 +2,17 @@ # $FreeBSD$ PORTNAME= rtg -PORTVERSION= 0.7.4 -PORTREVISION= 21 +PORTVERSION= 0.7.5 CATEGORIES= net -MASTER_SITES= SF \ - ftp://ftpmirror.uk/freebsd-ports/rtg/ +MASTER_SITES= ftp://ftpmirror.uk/freebsd-ports/rtg/ MAINTAINER= freebsd-ports@dan.me.uk COMMENT= Flexible, high-performance SNMP statistics monitoring system LICENSE= GPLv2 -LIB_DEPENDS= libnetsnmp.so:net-mgmt/net-snmp +LIB_DEPENDS= libnetsnmp.so:net-mgmt/net-snmp \ + libgd.so:graphics/gd RUN_DEPENDS= p5-DBI>=0:databases/p5-DBI \ p5-DBD-mysql>=0:databases/p5-DBD-mysql @@ -21,31 +20,30 @@ USES= mysql:client perl5 shebangfix ssl USE_RC_SUBR= rtgpoll SHEBANG_FILES= etc/95.pl etc/report.pl etc/rtgtargmkr.pl.in -SUB_FILES= pkg-message GNU_CONFIGURE= yes CONFIGURE_ARGS+= --sysconfdir=${PREFIX}/etc/${PORTNAME} \ + --htmldir=${PREFIX}/www/data \ --with-mysql=${LOCALBASE} \ + --with-gd=${LOCALBASE} \ --with-snmp=${LOCALBASE} +CFLAGS+= -fstack-protector +LDFLAGS+= -fstack-protector + USERS= rtg GROUPS= rtg OPTIONS_DEFINE= WEB MYSQL -OPTIONS_DEFAULT=WEB MYSQL_DESC= Pull MySQL server in as a dependancy for local setups WEB_DESC= Include PHP-based web client interface pre-requisites MYSQL_USES= mysql:server -WEB_USES= php -WEB_USE= PHP=mysqli,spl - -CFLAGS+= -fstack-protector -LDFLAGS+= -fstack-protector +WEB_USES= php +WEB_USE= PHP=mysqli,spl +WEB_SUB_FILES= pkg-message post-patch: - @${MV} ${WRKSRC}/etc/rtg.conf ${WRKSRC}/etc/rtg.conf.sample - @${MV} ${WRKSRC}/etc/routers ${WRKSRC}/etc/routers.sample @${REINPLACE_CMD} -e "s|%%PREFIX%%|${PREFIX}|g" ${WRKSRC}/etc/95.pl @${REINPLACE_CMD} -e "s|%%PREFIX%%|${PREFIX}|g" ${WRKSRC}/etc/report.pl @${REINPLACE_CMD} -e "s|%%PREFIX%%|${PREFIX}|g" ${WRKSRC}/etc/common.php.in diff --git a/net/rtg/distinfo b/net/rtg/distinfo index a5f84f5e3834..5db519ab12ca 100644 --- a/net/rtg/distinfo +++ b/net/rtg/distinfo @@ -1,2 +1,3 @@ -SHA256 (rtg-0.7.4.tar.gz) = db0dfefe335d551aaaa3e60876a1431916e7db55c980902413711512dd2132a0 -SIZE (rtg-0.7.4.tar.gz) = 710621 +TIMESTAMP = 1612622708 +SHA256 (rtg-0.7.5.tar.gz) = c0f4632e26423689037634ed59194dbfb017af57079b9039e33381d3698d6fe8 +SIZE (rtg-0.7.5.tar.gz) = 269657 diff --git a/net/rtg/files/patch-cgilib-0.4_cgi.c b/net/rtg/files/patch-cgilib-0.4_cgi.c deleted file mode 100644 index 7d55f8780b06..000000000000 --- a/net/rtg/files/patch-cgilib-0.4_cgi.c +++ /dev/null @@ -1,15 +0,0 @@ ---- cgilib-0.4/cgi.c.orig 2003-09-25 15:21:06 UTC -+++ cgilib-0.4/cgi.c -@@ -33,9 +33,12 @@ - #ifdef HAVE_CTYPE_H - # include <ctype.h> - #endif -+/* Unnecessary on FreeBSD; malloc.h included in stdlib.h */ -+/* - #ifdef HAVE_MALLOC_H - # include <malloc.h> - #endif -+*/ - - #include <cgi.h> - diff --git a/net/rtg/files/patch-config_config.h.in b/net/rtg/files/patch-config_config.h.in deleted file mode 100644 index 3c624c4c1b14..000000000000 --- a/net/rtg/files/patch-config_config.h.in +++ /dev/null @@ -1,27 +0,0 @@ ---- config/config.h.in.orig 2003-09-25 15:21:14 UTC -+++ config/config.h.in -@@ -91,19 +91,19 @@ - #undef PACKAGE - - /* Define to the address where bug reports for this package should be sent. */ --#undef PACKAGE_BUGREPORT -+#undef RTG_PACKAGE_BUGREPORT - - /* Define to the full name of this package. */ --#undef PACKAGE_NAME -+#undef RTG_PACKAGE_NAME - - /* Define to the full name and version of this package. */ --#undef PACKAGE_STRING -+#undef RTG_PACKAGE_STRING - - /* Define to the one symbol short name of this package. */ --#undef PACKAGE_TARNAME -+#undef RTG_PACKAGE_TARNAME - - /* Define to the version of this package. */ --#undef PACKAGE_VERSION -+#undef RTG_PACKAGE_VERSION - - /* Define as the return type of signal handlers (`int' or `void'). */ - #undef RETSIGTYPE diff --git a/net/rtg/files/patch-configure b/net/rtg/files/patch-configure deleted file mode 100644 index 7739ecc6ad12..000000000000 --- a/net/rtg/files/patch-configure +++ /dev/null @@ -1,43 +0,0 @@ ---- configure.orig 2003-10-02 15:59:33 UTC -+++ configure -@@ -328,6 +328,8 @@ sbindir='${exec_prefix}/sbin' - libexecdir='${exec_prefix}/libexec' - datadir='${prefix}/share' - sysconfdir='${prefix}/etc' -+etcdir='${prefix}/etc/rtg' -+webdir='${prefix}/www/data' - sharedstatedir='${prefix}/com' - localstatedir='${prefix}/var' - libdir='${exec_prefix}/lib' -@@ -558,6 +560,12 @@ do - | --syscon=* | --sysco=* | --sysc=* | --sys=* | --sy=*) - sysconfdir=$ac_optarg ;; - -+ -etcdir=* | --etcdir=* ) -+ etcdir=$ac_optarg ;; -+ -+ -webdir=* | --webdir=* ) -+ webdir=$ac_optarg ;; -+ - -target | --target | --targe | --targ | --tar | --ta | --t) - ac_prev=target_alias ;; - -target=* | --target=* | --targe=* | --targ=* | --tar=* | --ta=* | --t=*) -@@ -654,7 +662,8 @@ done - - # Be sure to have absolute paths. - for ac_var in bindir sbindir libexecdir datadir sysconfdir sharedstatedir \ -- localstatedir libdir includedir oldincludedir infodir mandir -+ localstatedir libdir includedir oldincludedir infodir mandir \ -+ etcdir webdir - do - eval ac_val=$`echo $ac_var` - case $ac_val in -@@ -5310,6 +5319,8 @@ s,@sbindir@,$sbindir,;t t - s,@libexecdir@,$libexecdir,;t t - s,@datadir@,$datadir,;t t - s,@sysconfdir@,$sysconfdir,;t t -+s,@etcdir@,$etcdir,;t t -+s,@webdir@,$webdir,;t t - s,@sharedstatedir@,$sharedstatedir,;t t - s,@localstatedir@,$localstatedir,;t t - s,@libdir@,$libdir,;t t diff --git a/net/rtg/files/patch-etc_95.php b/net/rtg/files/patch-etc_95.php deleted file mode 100644 index 7e870b7d2d27..000000000000 --- a/net/rtg/files/patch-etc_95.php +++ /dev/null @@ -1,288 +0,0 @@ ---- etc/95.php.orig 2003-09-24 20:40:57 UTC -+++ etc/95.php -@@ -1,41 +1,37 @@ - <?php - include('./common.php'); - -- print "<HTML>\n<!-- RTG Version $VERSION -->\n<HEAD>\n"; -+ print "<html>\n<!-- RTG Version $VERSION -->\n<head>\n"; - - /* Connect to RTG MySQL Database */ -- $dbc=@mysql_connect ($host, $user, $pass) or -- $dbc=@mysql_connect ("$host:/var/lib/mysql/mysql.sock", $user, $pass) or -+ $dbc=@mysqli_connect ($host, $user, $pass, $db) or - die ("MySQL Connection Failed, Check Configuration."); -- mysql_select_db($db,$dbc); - -- if ($PHP_SELF == "") { -+ if (!isset($PHP_SELF) || ($PHP_SELF == "")) { - $PHP_SELF = "95.php"; -- $customer = $_GET['customer']; -- $syear = $_GET['syear']; -- $eyear = $_GET['eyear']; -- $smonth = $_GET['smonth']; -- $emonth = $_GET['emonth']; -- $sday = $_GET['sday']; -- $eday = $_GET['eday']; -- $shour = $_GET['shour']; -- $ehour = $_GET['ehour']; -- $smin = $_GET['smin']; -- $emin = $_GET['emin']; -- $debug = $_GET['debug']; -+ $customer = isset($_GET['customer'])?$_GET['customer']:""; -+ $syear = isset($_GET['syear'])?$_GET['syear']:""; -+ $eyear = isset($_GET['eyear'])?$_GET['eyear']:""; -+ $smonth = isset($_GET['smonth'])?$_GET['smonth']:""; -+ $emonth = isset($_GET['emonth'])?$_GET['emonth']:""; -+ $sday = isset($_GET['sday'])?$_GET['sday']:""; -+ $eday = isset($_GET['eday'])?$_GET['eday']:""; -+ $shour = isset($_GET['shour'])?$_GET['shour']:""; -+ $ehour = isset($_GET['ehour'])?$_GET['ehour']:""; -+ $smin = isset($_GET['smin'])?$_GET['smin']:""; -+ $emin = isset($_GET['emin'])?$_GET['emin']:""; -+ $debug = isset($_GET['debug'])?$_GET['debug']:""; - } - -- print "<TITLE>RTG: "; -- if ($customer) print "$customer\n"; -+ print "<title>RTG: "; -+ if ($customer != "") print "$customer\n"; - ?> - --</TITLE> --</HEAD> --<BODY BGCOLOR="ffffff"> --<A HREF="http://rtg.sourceforge.net" ALT="[RTG Home Page]"> --<IMG SRC="rtg.png" BORDER="0"> --</A> --<P> -+</title> -+</head> -+<body bgcolor="ffffff"> -+<a href="http://rtg.sourceforge.net"><img src="rtg.png" border="0" alt="[RTG Home Page]" /></a> -+<p> - - <?php - function cmp($c1, $c2) { -@@ -50,8 +46,8 @@ function int_stats($statement, $dbc) { - $max = $avg = $nintyfifth = 0; - $rate = array(); - -- $selectResult=mysql_query($statement, $dbc); -- while ($selectRow=mysql_fetch_object($selectResult)){ -+ $selectResult=mysqli_query($dbc, $statement); -+ while ($selectRow=mysqli_fetch_object($selectResult)){ - $counter = $selectRow->counter; - $sample_secs = $selectRow->unixtime; - $total += $counter; -@@ -83,132 +79,136 @@ function int_stats($statement, $dbc) { - } - ?> - --<HR> --Report: 95th percentile<BR> -+<hr /> -+Report: 95th percentile<br /> - - <?php -- echo "<FORM ACTION=\"$PHP_SELF\" METHOD=\"GET\">\n"; -- if (($bt || $smonth)) { -- $dbc=@mysql_connect ($host, $user, $pass) or -- $dbc=@mysql_connect ("$host:/var/lib/mysql/mysql.sock", $user, $pass) or die ("MySQL Connection Failed, Check Configuration."); -- mysql_select_db($db,$dbc); -+ echo "<form action=\"$PHP_SELF\" method=\"get\">\n"; -+ if (($bt != "") || ($smonth != "")) { -+ $dbc=@mysqli_connect ($host, $user, $pass, $db) or -+ die ("MySQL Connection Failed, Check Configuration."); - /* Format into GNU date syntax */ - if ($bt == "") { - $bt = strtotime("$syear-$smonth-$sday $shour:$smin:00"); - $et = strtotime("$eyear-$emonth-$eday $ehour:$emin:59"); - } -- echo "Customer: $customer <BR>\n"; -+ echo "Customer: $customer <br />\n"; - print strftime("Period: %m/%d/%Y %H:%M - ", $bt); - print strftime("%m/%d/%Y %H:%M<P>\n", $et); - -- $range="dtime>FROM_UNIXTIME($bt) AND dtime<=FROM_UNIXTIME($et)"; -+ $range="`dtime`>FROM_UNIXTIME(" . mysqli_real_escape_string($dbc, $bt) . -+ ") AND `dtime`<=FROM_UNIXTIME(" . mysqli_real_escape_string($dbc, $et) . ")"; - -- $selectQuery="SELECT id, name, description, rid FROM interface WHERE description LIKE \"%$customer%\""; -- $selectResult=mysql_query($selectQuery, $dbc); -- if (mysql_num_rows($selectResult) <= 0) -- print "<BR>No Such Customer Found.<BR>\n"; -+ $selectQuery="SELECT `id`, `name`, `description`, `rid` FROM `interface` WHERE " . -+ "`description` LIKE \"%" . mysqli_real_escape_string($dbc, $customer) . "%\""; -+ $selectResult=mysqli_query($dbc, $selectQuery); -+ if (mysqli_num_rows($selectResult) <= 0) -+ print "<br />No Such Customer Found.<br />\n"; - else { -- while ($selectRow=mysql_fetch_object($selectResult)){ -+ while ($selectRow=mysqli_fetch_object($selectResult)){ - $ids[$selectRow->id] = $selectRow->name; - $rids[$selectRow->id] = $selectRow->rid; - $desc[$selectRow->id] = $selectRow->description; - } -- echo "<TABLE BORDER=\"1\">\n"; -- echo "<TR BGCOLOR=\"#E0E0E0\">\n"; -- echo "<TH COLSPAN=\"3\">Interface<TH COLSPAN=\"2\">Current Rate<TH COLSPAN=\"2\">Max Rate<TH COLSPAN=\"2\">95th %\n"; -+ echo "<table border=\"1\">\n"; -+ echo "<tr bgcolor=\"#E0E0E0\">\n"; -+ echo "<th colspan=\"3\">Interface</th><th colspan=\"2\">Current Rate</th><th colspan=\"2\">Max Rate</th><th colspan=\"2\">95th %</th>\n"; - if ($debug) -- echo "<TH COLSPAN=\"2\">Samples<TH COLSPAN=\"2\">Ignore Top\n"; -- echo "<TR BGCOLOR=\"#E0E0E0\">\n"; -- echo "<TH>Name<TH>Description<TH>Router<TH>In (Mbps)<TH>Out (Mbps)<TH>In<TH>Out<TH>In<TH>Out\n"; -+ echo "<th colspan=\"2\">Samples</th><th colspan=\"2\">Ignore Top</th>\n"; -+ echo "</tr>\n"; -+ echo "<tr bgcolor=\"#E0E0E0\">\n"; -+ echo "<th>Name</th><th>Description</th><th>Router</th><th>In (Mbps)</th><th>Out (Mbps)</th><th>In</th><th>Out</th><th>In</th><th>Out</th>\n"; - if ($debug) -- echo "<TH>In<TH>Out<TH>In<TH>Out\n"; -- echo "<TR BGCOLOR=\"#ffffcc\">\n"; -+ echo "<th>In</th><th>Out</th><th>In</th><th>Out</th>\n"; -+ echo "</tr>\n"; -+ echo "<tr bgcolor=\"#ffffcc\">\n"; - $yellow = 1; - foreach($ids as $iid=>$name) { - -- $selectQuery="SELECT name FROM router WHERE rid=$rids[$iid]"; -- $selectResult=mysql_query($selectQuery, $dbc); -- $selectRow=mysql_fetch_object($selectResult); -+ $selectQuery="SELECT `name` FROM `router` WHERE `rid`=$rids[$iid]"; -+ $selectResult=mysqli_query($dbc, $selectQuery); -+ $selectRow=mysqli_fetch_object($selectResult); - $router = $selectRow->name; - - if ($yellow) $yellow = 0; - else $yellow = 1; - -- echo "<TD>$name<TD>$desc[$iid]<TD>$router"; -+ echo "<td>$name</td><td>$desc[$iid]</td><td>$router</td>"; - -- $selectQuery="SELECT counter, UNIX_TIMESTAMP(dtime) as unixtime, dtime from ifInOctets_$rids[$iid] WHERE $range AND id=$iid ORDER BY dtime"; -+ $selectQuery="SELECT `counter`, UNIX_TIMESTAMP(`dtime`) AS `unixtime`, `dtime` FROM `ifInOctets_$rids[$iid]` WHERE $range AND `id`=$iid ORDER BY `dtime`"; - list ($intbytes_in, $maxin, $avgin, $nfin,$insamples,$inignore) = int_stats($selectQuery, $dbc); - $bytesin = round($intbytes_in/1000000); - -- $selectQuery="SELECT counter, UNIX_TIMESTAMP(dtime) as unixtime, dtime from ifOutOctets_$rids[$iid] WHERE $range AND id=$iid ORDER BY dtime"; -+ $selectQuery="SELECT `counter`, UNIX_TIMESTAMP(`dtime`) AS `unixtime`, `dtime` FROM `ifOutOctets_$rids[$iid]` WHERE $range AND `id`=$iid ORDER BY `dtime`"; - list ($intbytes_out, $maxout, $avgout, $nfout,$outsamples,$outignore) = int_stats($selectQuery, $dbc); - $bytesout = round($intbytes_in/1000000); - -- printf("<TD ALIGN=\"right\">%2.2f", $avgin/1000000); -- printf("<TD ALIGN=\"right\">%2.2f", $avgout/1000000); -- printf("<TD ALIGN=\"right\">%2.2f", $maxin/1000000); -- printf("<TD ALIGN=\"right\">%2.2f", $maxout/1000000); -- printf("<TD ALIGN=\"right\">%2.2f", $nfin/1000000); -- printf("<TD ALIGN=\"right\">%2.2f", $nfout/1000000); -+ printf("<td align=\"right\">%2.2f</td>", $avgin/1000000); -+ printf("<td align=\"right\">%2.2f</td>", $avgout/1000000); -+ printf("<td align=\"right\">%2.2f</td>", $maxin/1000000); -+ printf("<td align=\"right\">%2.2f</td>", $maxout/1000000); -+ printf("<td align=\"right\">%2.2f</td>", $nfin/1000000); -+ printf("<td align=\"right\">%2.2f</td>", $nfout/1000000); - if ($debug) { -- echo "<TD ALIGN=\"right\">$insamples<TD ALIGN=\"right\">$outsamples<TD ALIGN=\"right\">$inignore<TD ALIGN=\"right\">$outignore"; -+ echo "<td align=\"right\">$insamples</td><td align=\"right\">$outsamples</td><td align=\"right\">$inignore</td><td align=\"right\">$outignore</td>"; - } -- if ($yellow) echo "<TR BGCOLOR=\"#ffffcc\">\n"; -- else echo "<TR BGCOLOR=\"#94D6E7\">\n"; -+ echo "</tr>\n"; -+ if ($yellow) echo "<tr bgcolor=\"#ffffcc\">\n"; -+ else echo "<tr bgcolor=\"#94D6E7\">\n"; - } -- echo "</TABLE>\n"; -+ echo "</table>\n"; - } - } else { -- echo "Customer Name: <INPUT TYPE=\"text\" NAME=\"customer\"><BR>\n"; -- echo "<P><TABLE>\n"; -- echo "<TD>From: \n"; -- echo "<TD><INPUT TYPE=TEXT NAME=\"smonth\" SIZE=3 MAXLENGTH=2 VALUE=\""; -+ echo "Customer Name: <input type=\"text\" name=\"customer\" /><br />\n"; -+ echo "<p><table>\n"; -+ echo "<tr><td>From: </td>\n"; -+ echo "<td><input type=\"text\" name=\"smonth\" size=\"3\" maxlength=\"2\" value=\""; - print (date("m")); -- echo "\"> / \n"; -- echo "<INPUT TYPE=TEXT NAME=\"sday\" SIZE=3 MAXLENGTH=2 VALUE=\""; -+ echo "\" /> / \n"; -+ echo "<input type=\"text\" name=\"sday\" size=\"3\" maxlength=\"2\" value=\""; - printf("%02d", (date("d") - 1)); -- echo "\"> / \n"; -- echo "<INPUT TYPE=TEXT NAME=\"syear\" SIZE=5 MAXLENGTH=4 VALUE=\""; -+ echo "\" /> / \n"; -+ echo "<input type=\"text\" name=\"syear\" size=\"5\" maxlength=\"4\" value=\""; - print (date("Y")); -- echo "\">\n"; -- echo "<TD><INPUT TYPE=TEXT NAME=\"shour\" SIZE=3 MAXLENGTH=2 VALUE=\""; -+ echo "\" /></td>\n"; -+ echo "<td><input type=\"text\" name=\"shour\" size=\"3\" maxlength=\"2\" value=\""; - print (date("H")); -- echo "\">:\n"; -- echo "<INPUT TYPE=TEXT NAME=\"smin\" SIZE=3 MAXLENGTH=2 VALUE=\""; -+ echo "\" />:\n"; -+ echo "<input type=\"text\" name=\"smin\" size=\"3\" maxlength=\"2\" value=\""; - print (date("i")); -- echo "\">\n"; -+ echo "\" /></td></tr>\n"; - -- echo "<TR><TD>To: \n"; -- echo "<TD><INPUT TYPE=TEXT NAME=\"emonth\" SIZE=3 MAXLENGTH=2 VALUE=\""; -+ echo "<tr><td>To: </td>\n"; -+ echo "<td><input type=\"text\" name=\"emonth\" size=\"3\" maxlength=\"2\" value=\""; - print (date("m")); -- echo "\"> / \n"; -- echo "<INPUT TYPE=TEXT NAME=\"eday\" SIZE=3 MAXLENGTH=2 VALUE=\""; -+ echo "\" /> / \n"; -+ echo "<input type=\"text\" name=\"eday\" size=\"3\" maxlength=\"2\" value=\""; - print (date("d")); -- echo "\"> / \n"; -- echo "<INPUT TYPE=TEXT NAME=\"eyear\" SIZE=5 MAXLENGTH=4 VALUE=\""; -+ echo "\" /> / \n"; -+ echo "<input type=\"text\" name=\"eyear\" size=\"5\" maxlength=\"4\" value=\""; - print (date("Y")); -- echo "\">\n"; -- echo "<TD><INPUT TYPE=TEXT NAME=\"ehour\" SIZE=3 MAXLENGTH=2 VALUE=\""; -+ echo "\" /></td>\n"; -+ echo "<td><input type=\"text\" name=\"ehour\" size=\"3\" maxlength=\"2\" value=\""; - print (date("H")); -- echo "\">:\n"; -- echo "<INPUT TYPE=TEXT NAME=\"emin\" SIZE=3 MAXLENGTH=2 VALUE=\""; -+ echo "\" />:\n"; -+ echo "<input type=\"text\" name=\"emin\" size=\"3\" maxlength=\"2\" value=\""; - print (date("i")); -- echo "\">\n"; -- echo "<TR><TD>Debug: \n"; -- echo "<TD><INPUT TYPE=CHECKBOX NAME=\"debug\">\n"; -- echo "</TABLE>\n"; -+ echo "\" /></td></tr>\n"; -+ echo "<tr><td>Debug: </td>\n"; -+ echo "<td><input type=\"checkbox\" name=\"debug\" /></td></tr>\n"; -+ echo "</table>\n"; - -- echo "<P><INPUT TYPE=\"SUBMIT\" VALUE=\"Ok\">"; -+ echo "<p><input type=\"submit\" VALUE=\"Ok\" />"; - } - -- if ($dbc) mysql_close($dbc); -- echo "</FORM>\n"; -+ if ($dbc) mysqli_close($dbc); -+ echo "</form>\n"; - ?> --<BR> --<HR> --<FONT FACE="Arial" SIZE="2"> -+<br /> -+<hr /> -+<font face="Arial" size="2"> - <?php -- print "<A HREF=\"http://rtg.sourceforge.net\">RTG</A> Version $VERSION</FONT>"; -+ print "<a href=\"http://rtg.sourceforge.net\">RTG</a> Version $VERSION</font>"; - ?> --</BODY> --</HTML> -+</body> -+</html> diff --git a/net/rtg/files/patch-etc_95.pl b/net/rtg/files/patch-etc_95.pl index 68240e611394..64ffd2f4d95b 100644 --- a/net/rtg/files/patch-etc_95.pl +++ b/net/rtg/files/patch-etc_95.pl @@ -1,4 +1,4 @@ ---- etc/95.pl.orig 2018-04-02 20:14:41 UTC +--- etc/95.pl.orig 2020-09-23 14:55:01 UTC +++ etc/95.pl @@ -31,7 +31,7 @@ $pass="rtgdefault"; $onedaysec=60*60*24; @@ -9,52 +9,3 @@ foreach $conf (@configs) { if (open CONF, "<$conf") { print "Reading [$conf].\n" if $DEBUG; -@@ -207,13 +207,13 @@ print "Period: [", format_dt($startdate) - write; - ($name,$router, $ratein, $rateout, $maxratein, $maxrateout, $nfratein, $nfrateout) = ("Connection", "", "Mbps", "Mbps", "Mbps", "Mbps", "Mbps", "Mbps"); - write; --print "--------------------------------------------------------------------------------\n"; -+print "----------------------------------------------------------------------------------------------------\n"; - - $dbh= DBI->connect("DBI:mysql:$db:host=$host", $user, $pass); - $dbh2= DBI->connect("DBI:mysql:$db:host=$host", $user, $pass); --$range="dtime>$startdate and dtime<=$enddate"; -+$range="`dtime`>$startdate AND `dtime`<=$enddate"; - --$statement="SELECT id FROM interface WHERE description LIKE \"%$cust%\""; -+$statement="SELECT `id` FROM `interface` WHERE `description` LIKE \"%$cust%\""; - $sth = $dbh->prepare($statement) - or die "Can't prepare $statement: $dbh->errstr\n"; - $rv = $sth->execute -@@ -223,19 +223,19 @@ while (@row = $sth->fetchrow_array ()) { - } - - foreach $interface (@interfaces) { -- $statement="SELECT rid, name, speed FROM interface WHERE id=$interface"; -+ $statement="SELECT `rid`, `name`, `speed` FROM `interface` WHERE `id`=$interface"; - &run_query($statement); - ($rid, $name, $speed) = @row; - -- $statement="SELECT rid, name FROM router WHERE rid=$rid"; -+ $statement="SELECT `rid`, `name` FROM `router` WHERE `rid`=$rid"; - &run_query($statement); - ($rid, $router) = @row; - -- $statement="SELECT counter, UNIX_TIMESTAMP(dtime), dtime FROM ifInOctets_".$rid." WHERE $range AND id=$interface ORDER BY dtime"; -+ $statement="SELECT `counter`, UNIX_TIMESTAMP(`dtime`), `dtime` FROM `ifInOctets_".$rid."` WHERE $range AND `id`=$interface ORDER BY `dtime`"; - ($intbytes_in, $maxin, $avgin, $nfin) = &interface_stats($statement); - $bytesin = int($intbytes_in/1000000 + .5); - -- $statement="SELECT counter, UNIX_TIMESTAMP(dtime), dtime FROM ifOutOctets_".$rid." WHERE $range AND id=$interface ORDER BY dtime"; -+ $statement="SELECT `counter`, UNIX_TIMESTAMP(`dtime`), `dtime` FROM `ifOutOctets_".$rid."` WHERE $range AND `id`=$interface ORDER BY `dtime`"; - ($intbytes_out, $maxout, $avgout, $nfout) = &interface_stats($statement); - $bytesout = int($intbytes_out/1000000 + .5); - -@@ -279,6 +279,6 @@ $rc = $dbh->disconnect; - exit; - - format STDOUT = --@<<<<<<<<<<< @<<<<<<<<<<< @>>>>>>> @>>>>>>> @>>>>>> @>>>>>> @>>>>>> @>>>>>> -+@<<<<<<<<<<<<<<<<<<<<< @<<<<<<<<<<<<<<<<<<<<< @>>>>>>> @>>>>>>> @>>>>>> @>>>>>> @>>>>>> @>>>>>> - $name,$router, $ratein, $rateout, $maxratein, $maxrateout, $nfratein, $nfrateout - . diff --git a/net/rtg/files/patch-etc_Makefile.in b/net/rtg/files/patch-etc_Makefile.in deleted file mode 100644 index b7e64a203715..000000000000 --- a/net/rtg/files/patch-etc_Makefile.in +++ /dev/null @@ -1,49 +0,0 @@ ---- etc/Makefile.in.orig 2003-10-02 15:59:32 UTC -+++ etc/Makefile.in -@@ -84,19 +84,19 @@ am__quote = @am__quote@ - install_sh = @install_sh@ - - top_builddir = .. --etcdir = /etc --webdir = /web --reportsdir = /bin -+etcdir = @etcdir@ -+webdir = @webdir@ -+reportsdir = @bindir@ - --ETC = rtg.conf rtgtargmkr.pl routers createdb BER.pm \ -+ETC = rtg.conf.sample rtgtargmkr.pl routers.sample createdb BER.pm \ - SNMP_Session.pm SNMP_util.pm - - WEB = rtg.php 95.php view.php common.php rtg.png rtgback.png - REPORTS = report.pl 95.pl - - EXTRA_DIST = rtgtargmkr.pl.in report.pl 95.pl createdb.in \ -- BER.pm SNMP_Session.pm SNMP_util.pm rtg.conf \ -- routers rtg.php 95.php view.php common.php.in rtg.png rtgback.png -+ BER.pm SNMP_Session.pm SNMP_util.pm rtg.conf.sample \ -+ routers.sample rtg.php 95.php view.php common.php.in rtg.png rtgback.png - - subdir = etc - mkinstalldirs = $(SHELL) $(top_srcdir)/config/mkinstalldirs -@@ -220,14 +220,14 @@ uninstall-am: uninstall-info-am - all: - - install: installdirs -- @for i in $(ETC) ; do $(INSTALL) $(srcdir)/$$i $(prefix)$(etcdir) ; echo "install: installed $$i in $(prefix)$(etcdir)" ; done -- @for i in $(WEB) ; do $(INSTALL) $(srcdir)/$$i $(prefix)$(webdir) ; echo "install: installed $$i in $(prefix)$(webdir)" ; done -- @for i in $(REPORTS) ; do $(INSTALL) $(srcdir)/$$i $(prefix)$(reportsdir) ; echo "install: installed $$i in $(prefix)$(reportsdir)" ; done -+ @for i in $(ETC) ; do $(INSTALL) $(srcdir)/$$i $(DESTDIR)$(etcdir) ; echo "install: installed $$i in $(DESTDIR)$(etcdir)" ; done -+ @for i in $(WEB) ; do $(INSTALL) $(srcdir)/$$i $(DESTDIR)$(webdir) ; echo "install: installed $$i in $(DESTDIR)$(webdir)" ; done -+ @for i in $(REPORTS) ; do $(INSTALL) $(srcdir)/$$i $(DESTDIR)$(reportsdir) ; echo "install: installed $$i in $(DESTDIR)$(reportsdir)" ; done - - installdirs: -- $(mkinstalldirs) $(prefix)$(etcdir) -- $(mkinstalldirs) $(prefix)$(webdir) -- $(mkinstalldirs) $(prefix)$(reportsdir) -+ $(mkinstalldirs) $(DESTDIR)$(etcdir) -+ $(mkinstalldirs) $(DESTDIR)$(webdir) -+ $(mkinstalldirs) $(DESTDIR)$(reportsdir) - # Tell versions [3.59,3.63) of GNU make to not export all variables. - # Otherwise a system limit (for SysV at least) may be exceeded. - .NOEXPORT: diff --git a/net/rtg/files/patch-etc_SNMP__util.pm b/net/rtg/files/patch-etc_SNMP__util.pm deleted file mode 100644 index 09c703fc7f84..000000000000 --- a/net/rtg/files/patch-etc_SNMP__util.pm +++ /dev/null @@ -1,22 +0,0 @@ ---- etc/SNMP_util.pm.orig 2018-04-02 22:51:02 UTC -+++ etc/SNMP_util.pm -@@ -1129,16 +1129,16 @@ sub snmpMIB_to_OID ($) { - $buf =~ s/OBJECT-GROUP/OBJECT IDENTIFIER/; - $buf =~ s/MODULE-IDENTITY/OBJECT IDENTIFIER/; - $buf =~ s/ IMPORTS .*\;//; -- $buf =~ s/ SEQUENCE {.*}//; -+ $buf =~ s/ SEQUENCE \{.*}//; - $buf =~ s/ SYNTAX .*//; - $buf =~ s/ [\w-]+ ::= OBJECT IDENTIFIER//; -- $buf =~ s/ OBJECT IDENTIFIER .* ::= {/ OBJECT IDENTIFIER ::= {/; -+ $buf =~ s/ OBJECT IDENTIFIER .* ::= \{/ OBJECT IDENTIFIER ::= {/; - $buf =~ s/".*"//; - if ($buf =~ /"/) { - $quote = 1; - } - -- if ($buf =~ / ([\w\-]+) OBJECT IDENTIFIER ::= {([^}]+)}/) { -+ if ($buf =~ / ([\w\-]+) OBJECT IDENTIFIER ::= \{([^}]+)}/) { - $var = $1; - $buf = $2; - undef $val; diff --git a/net/rtg/files/patch-etc_common.php.in b/net/rtg/files/patch-etc_common.php.in index b06f25c12d10..55343652d231 100644 --- a/net/rtg/files/patch-etc_common.php.in +++ b/net/rtg/files/patch-etc_common.php.in @@ -1,22 +1,10 @@ ---- etc/common.php.in.orig 2003-09-26 15:52:29 UTC +--- etc/common.php.in.orig 2020-09-22 19:52:22 UTC +++ etc/common.php.in -@@ -1,4 +1,4 @@ --<? -+<?php - /* Begin with reasonable defaults */ - $VERSION = "@VERSION@"; - $host="localhost"; -@@ -6,10 +6,13 @@ - $pass="rtgdefault"; - $db="rtg"; - $refresh=300; -+ -+ date_default_timezone_set ( 'UTC' ); - - /* Default locations to find RTG configuration file */ - $configs[] = 'rtg.conf'; - $configs[] = '@RTG_HOME@/etc/rtg.conf'; -+ $configs[] = '%%PREFIX%%/etc/rtg/rtg.conf'; - $configs[] = '/usr/local/rtg/etc/rtg.conf'; - $configs[] = '/etc/rtg.conf'; +@@ -12,6 +12,7 @@ date_default_timezone_set('UTC'); + /* Default locations to find RTG configuration file */ + $configs[] = 'rtg.conf'; + $configs[] = '@RTG_HOME@/etc/rtg.conf'; ++$configs[] = '%%PREFIX%%/etc/rtg/rtg.conf'; + $configs[] = '/usr/local/rtg/etc/rtg.conf'; + $configs[] = '/etc/rtg.conf'; diff --git a/net/rtg/files/patch-etc_createdb.in b/net/rtg/files/patch-etc_createdb.in deleted file mode 100644 index ae06e2bf8b9e..000000000000 --- a/net/rtg/files/patch-etc_createdb.in +++ /dev/null @@ -1,160 +0,0 @@ ---- etc/createdb.in.orig 2003-01-22 19:07:02 UTC -+++ etc/createdb.in -@@ -15,6 +15,8 @@ - RTGPASS="rtgdefault" - DATABASE="rtg" - USER="snmp" -+MYSQL_FILE=`mktemp -q /tmp/mysql.XXXXXX` -+RTG_FILE=`mktemp -q /tmp/rtg.XXXXXX` - - echo "" - echo "$0 setting up MySQL database for RTG." -@@ -22,103 +24,98 @@ - echo "" - - # Create the necessary SQL in two /tmp files --cat <<EOT >/tmp/mysql.sql --INSERT INTO user (Host, User, Password) VALUES ('$HOST','$USER',PASSWORD("$RTGPASS")); --INSERT INTO db (Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv, --Create_priv, Drop_priv, Grant_priv, References_priv, Index_priv, Alter_priv) --VALUES ('$HOST','$DATABASE','$USER','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); --FLUSH PRIVILEGES; -+cat <<EOT >$MYSQL_FILE -+CREATE USER '$USER'@'$HOST' IDENTIFIED BY '$RTG_PASS'; -+GRANT ALL ON '$DATABASE'.* TO '$USER'@'$HOST'; - EOT - --cat <<EOT >/tmp/rtg.sql -+cat <<EOT >$RTG_FILE - # - # Table structure for table 'router' - # - --CREATE TABLE router ( -- rid int(11) unsigned NOT NULL auto_increment, -- name char(120) NOT NULL default '', -- pop char(10) NOT NULL default '', -- popid tinyint(3) unsigned NOT NULL default '0', -- PRIMARY KEY (rid) -+CREATE TABLE `router` ( -+ `rid` int(11) unsigned NOT NULL auto_increment, -+ `name` char(120) NOT NULL default '', -+ `pop` char(10) NOT NULL default '', -+ `popid` tinyint(3) unsigned NOT NULL default '0', -+ PRIMARY KEY (`rid`) - ); - - # - # Table structure for table 'interface' - # - --CREATE TABLE interface ( -- id int(11) unsigned NOT NULL auto_increment, -- name char(255) NOT NULL default '', -- rid int(11) NOT NULL default '0', -- speed bigint(11) default NULL, -- description char(255) default NULL, -- status enum('active','inactive') default 'active', -- PRIMARY KEY (id) -+CREATE TABLE `interface` ( -+ `id` int(11) unsigned NOT NULL auto_increment, -+ `name` char(255) NOT NULL default '', -+ `rid` int(11) NOT NULL default '0', -+ `speed` bigint(11) default NULL, -+ `description` char(255) default NULL, -+ `status` enum('active','inactive') default 'active', -+ PRIMARY KEY (`id`) - ); - - # - # Table structure for table 'ifInOctets' - # - --CREATE TABLE ifInOctets ( -- id int(11) NOT NULL default '0', -- dtime datetime NOT NULL default '0000-00-00 00:00:00', -- counter bigint(20) NOT NULL default '0', -- KEY ifInOctets_idx (dtime) -+CREATE TABLE `ifInOctets` ( -+ `id` int(11) NOT NULL default '0', -+ `dtime` datetime NOT NULL default '0000-00-00 00:00:00', -+ `counter` bigint(20) NOT NULL default '0', -+ KEY `ifInOctets_idx` (`dtime`) - ); - - # - # Table structure for table 'ifOutOctets' - # - --CREATE TABLE ifOutOctets ( -- id int(11) NOT NULL default '0', -- dtime datetime NOT NULL default '0000-00-00 00:00:00', -- counter bigint(20) NOT NULL default '0', -- KEY ifOutOctets_idx (dtime) -+CREATE TABLE `ifOutOctets` ( -+ `id` int(11) NOT NULL default '0', -+ `dtime` datetime NOT NULL default '0000-00-00 00:00:00', -+ `counter` bigint(20) NOT NULL default '0', -+ KEY `ifOutOctets_idx` (`dtime`) - ); - - # - # Table structure for table 'ifInUcastPkts' - # - --CREATE TABLE ifInUcastPkts ( -- id int(11) NOT NULL default '0', -- dtime datetime NOT NULL default '0000-00-00 00:00:00', -- counter bigint(20) NOT NULL default '0', -- KEY ifInUcastPkts_idx (dtime) -+CREATE TABLE `ifInUcastPkts` ( -+ `id` int(11) NOT NULL default '0', -+ `dtime` datetime NOT NULL default '0000-00-00 00:00:00', -+ `counter` bigint(20) NOT NULL default '0', -+ KEY `ifInUcastPkts_idx` (`dtime`) - ); - - # - # Table structure for table 'ifOutUcastPkts' - # - --CREATE TABLE ifOutUcastPkts ( -- id int(11) NOT NULL default '0', -- dtime datetime NOT NULL default '0000-00-00 00:00:00', -- counter bigint(20) NOT NULL default '0', -- KEY ifOutUcastPkts_idx (dtime) -+CREATE TABLE `ifOutUcastPkts` ( -+ `id` int(11) NOT NULL default '0', -+ `dtime` datetime NOT NULL default '0000-00-00 00:00:00', -+ `counter` bigint(20) NOT NULL default '0', -+ KEY `ifOutUcastPkts_idx` (`dtime`) - ); - - # - # Table structure for table 'ifInErrors' - # - --CREATE TABLE ifInErrors ( -- id int(11) NOT NULL default '0', -- dtime datetime NOT NULL default '0000-00-00 00:00:00', -- counter bigint(20) NOT NULL default '0', -- KEY ifInErrors_idx (dtime) -+CREATE TABLE `ifInErrors` ( -+ `id` int(11) NOT NULL default '0', -+ `dtime` datetime NOT NULL default '0000-00-00 00:00:00', -+ `counter` bigint(20) NOT NULL default '0', -+ KEY `ifInErrors_idx` (`dtime`) - ); - EOT - - echo "Adding user \"$USER\" to MySQL database..." --cat /tmp/mysql.sql | $MYSQLBIN/mysql -u root -p$ROOTPASS mysql -+cat $MYSQL_FILE | $MYSQLBIN/mysql -u root -p$ROOTPASS mysql - echo "Creating RTG database \"$DATABASE\"..." - $MYSQLBIN/mysqladmin -u root -p$ROOTPASS create $DATABASE --echo "Reloading MySQL privileges..." --$MYSQLBIN/mysqladmin -u root -p$ROOTPASS flush-privileges - echo "Creating RTG tables..." --cat /tmp/rtg.sql | $MYSQLBIN/mysql -u $USER -p$RTGPASS $DATABASE -+cat $RTG_FILE | $MYSQLBIN/mysql -u $USER -p$RTGPASS $DATABASE - echo "Done." diff --git a/net/rtg/files/patch-etc_report.pl b/net/rtg/files/patch-etc_report.pl index 2256ca9b620a..849747fe06b0 100644 --- a/net/rtg/files/patch-etc_report.pl +++ b/net/rtg/files/patch-etc_report.pl @@ -1,4 +1,4 @@ ---- etc/report.pl.orig 2018-04-02 20:14:41 UTC +--- etc/report.pl.orig 2020-09-23 14:55:01 UTC +++ etc/report.pl @@ -30,7 +30,7 @@ $pass="rtgdefault"; $onedaysec=60*60*24; @@ -9,52 +9,3 @@ foreach $conf (@configs) { if (open CONF, "<$conf") { print "Reading [$conf].\n" if $DEBUG; -@@ -192,13 +192,13 @@ print "Period: [", format_dt($startdate) - write; - ($router,$name,$bytesin, $bytesout, $ratein, $rateout, $utilin, $utilout, $maxratein, $maxrateout, $maxutilin, $maxutilout) = ("","Connection", "MBytes", "MBytes", "Mbps", "Mbps", "In %", "Out%", "Mbps", "Mbps", "In%", "Out%"); - write; --print "----------------------------------------------------------------------------------------------------------\n"; -+print "------------------------------------------------------------------------------------------------------------------------------\n"; - - $dbh= DBI->connect("DBI:mysql:$db:host=$host", $user, $pass); - $dbh2= DBI->connect("DBI:mysql:$db:host=$host", $user, $pass); --$range="dtime>$startdate and dtime<=$enddate"; -+$range="`dtime`>$startdate and `dtime`<=$enddate"; - --$statement="SELECT id FROM interface WHERE description LIKE \"%$cust%\""; -+$statement="SELECT `id` FROM `interface` WHERE `description` LIKE \"%$cust%\""; - $sth = $dbh->prepare($statement) - or die "Can't prepare $statement: $dbh->errstr\n"; - $rv = $sth->execute -@@ -209,19 +209,19 @@ while (@row = $sth->fetchrow_array ()) - } - - foreach $interface (@interfaces) { -- $statement="SELECT rid, name, speed FROM interface WHERE id=$interface"; -+ $statement="SELECT `rid`, `name`, `speed` FROM `interface` WHERE `id`=$interface"; - &run_query($statement); - ($rid, $name, $speed) = @row; - -- $statement="SELECT rid, name FROM router WHERE rid=$rid"; -+ $statement="SELECT `rid`, `name` FROM `router` WHERE `rid`=$rid"; - &run_query($statement); - ($rid, $router) = @row; - -- $statement="SELECT counter, UNIX_TIMESTAMP(dtime), dtime FROM ifInOctets_".$rid." WHERE $range AND id=$interface ORDER BY dtime"; -+ $statement="SELECT `counter`, UNIX_TIMESTAMP(`dtime`), `dtime` FROM `ifInOctets_".$rid."` WHERE $range AND `id`=$interface ORDER BY `dtime`"; - ($intbytes_in, $maxin, $avgin) = &interface_stats($statement); - $bytesin = int($intbytes_in/1000000 + .5); - -- $statement="SELECT counter, UNIX_TIMESTAMP(dtime), dtime FROM ifOutOctets_".$rid." WHERE $range AND id=$interface ORDER BY dtime"; -+ $statement="SELECT `counter`, UNIX_TIMESTAMP(`dtime`), `dtime` FROM `ifOutOctets_".$rid."` WHERE $range AND `id`=$interface ORDER BY `dtime`"; - ($intbytes_out, $maxout, $avgout) = &interface_stats($statement); - $bytesout = int($intbytes_out/1000000 + .5); - -@@ -267,6 +267,6 @@ $rc = $dbh->disconnect; - exit; - - format STDOUT = --@<<<<<<<<<<< @<<<<<<<<<<< @>>>>>>> @>>>>>>> @>>>>>> @>>>>>> @>>>>> @>>>>> @>>>>>> @>>>>>> @>>>>> @>>>>> -+@<<<<<<<<<<<<<<<<<<<<< @<<<<<<<<<<<<<<<<<<<<< @>>>>>>> @>>>>>>> @>>>>>> @>>>>>> @>>>>> @>>>>> @>>>>>> @>>>>>> @>>>>> @>>>>> - $name,$router,&commify($bytesin), &commify($bytesout), $ratein, $rateout, $utilin, $utilout, $maxratein, $maxrateout, $maxutilin, $maxutilout - . diff --git a/net/rtg/files/patch-etc_rtg.conf b/net/rtg/files/patch-etc_rtg.conf deleted file mode 100644 index 5cb1317f249a..000000000000 --- a/net/rtg/files/patch-etc_rtg.conf +++ /dev/null @@ -1,10 +0,0 @@ ---- etc/rtg.conf.orig 2018-04-02 23:07:32 UTC -+++ etc/rtg.conf -@@ -12,3 +12,7 @@ DB_Database rtg - DB_User snmp - DB_Pass rtgdefault - Threads 5 -+# Set Update_desc to 1 to cause rtgtargmkr.pl to auto-update descriptions from -+# SNMP port data -+Update_desc 0 -+ diff --git a/net/rtg/files/patch-etc_rtg.php b/net/rtg/files/patch-etc_rtg.php deleted file mode 100644 index ee6843c44de7..000000000000 --- a/net/rtg/files/patch-etc_rtg.php +++ /dev/null @@ -1,389 +0,0 @@ ---- etc/rtg.php.orig 2003-09-24 20:42:03 UTC -+++ etc/rtg.php -@@ -1,146 +1,152 @@ - <?php - include('./common.php'); - -- print "<HTML>\n<!-- RTG Version $VERSION -->\n<HEAD>\n"; -+ print "<html>\n<!-- RTG Version $VERSION -->\n<head>\n"; - - /* Connect to RTG MySQL Database */ -- $dbc=@mysql_connect ($host, $user, $pass) or -- $dbc=@mysql_connect ("$host:/var/lib/mysql/mysql.sock", $user, $pass) or -+ $dbc=@mysqli_connect ($host, $user, $pass, $db) or - die ("MySQL Connection Failed, Check Configuration."); -- mysql_select_db($db,$dbc); - -- if ($PHP_SELF == "") { -+ if (!isset($PHP_SELF) || $PHP_SELF == "") { - $PHP_SELF = "rtg.php"; -- $errors = $_GET['errors']; -- $scalex = $_GET['scalex']; -- $scaley = $_GET['scaley']; -- $aggr = $_GET['aggr']; -- $percentile = $_GET['percentile']; -- $nth = $_GET['nth']; -- $xplot = $_GET['xplot']; -- $yplot = $_GET['yplot']; -- $borderb = $_GET['borderb']; -- $iid = $_GET['iid']; -- $rid = $_GET['rid']; -- $syear = $_GET['syear']; -- $eyear = $_GET['eyear']; -- $smonth = $_GET['smonth']; -- $emonth = $_GET['emonth']; -- $sday = $_GET['sday']; -- $eday = $_GET['eday']; -- $shour = $_GET['shour']; -- $ehour = $_GET['ehour']; -- $smin = $_GET['smin']; -- $emin = $_GET['emin']; -+ $errors = isset($_GET['errors'])?$_GET['errors']:""; -+ $scalex = isset($_GET['scalex'])?$_GET['scalex']:""; -+ $scaley = isset($_GET['scaley'])?$_GET['scaley']:""; -+ $aggr = isset($_GET['aggr'])?$_GET['aggr']:""; -+ $percentile = isset($_GET['percentile'])?$_GET['percentile']:""; -+ $nth = isset($_GET['nth'])?$_GET['nth']:""; -+ $xplot = isset($_GET['xplot'])?$_GET['xplot']:""; -+ $yplot = isset($_GET['yplot'])?$_GET['yplot']:""; -+ $borderb = isset($_GET['borderb'])?$_GET['borderb']:""; -+ $iid = isset($_GET['iid'])?$_GET['iid']:""; -+ $rid = isset($_GET['rid'])?$_GET['rid']:""; -+ $syear = isset($_GET['syear'])?$_GET['syear']:""; -+ $eyear = isset($_GET['eyear'])?$_GET['eyear']:""; -+ $smonth = isset($_GET['smonth'])?$_GET['smonth']:""; -+ $emonth = isset($_GET['emonth'])?$_GET['emonth']:""; -+ $sday = isset($_GET['sday'])?$_GET['sday']:""; -+ $eday = isset($_GET['eday'])?$_GET['eday']:""; -+ $shour = isset($_GET['shour'])?$_GET['shour']:""; -+ $ehour = isset($_GET['ehour'])?$_GET['ehour']:""; -+ $smin = isset($_GET['smin'])?$_GET['smin']:""; -+ $emin = isset($_GET['emin'])?$_GET['emin']:""; - } - - # Determine router, interface names as necessary -- if ($rid && $iid) { -- $selectQuery="SELECT a.name, a.description, a.speed, b.name AS router FROM interface a, router b WHERE a.rid=b.rid AND a.rid=$rid AND a.id=$iid[0]"; -- $selectResult=mysql_query($selectQuery, $dbc); -- $selectRow=mysql_fetch_object($selectResult); -- $interfaces = mysql_num_rows($selectResult); -+ if (($rid != "") && ($iid != "")) { -+ $selectQuery="SELECT `a`.`name`, `a`.`description`, `a`.`speed`, `b`.`name` " . -+ "AS `router` FROM `interface` `a`, `router` `b` WHERE `a`.`rid`=`b`.`rid` " . -+ "AND `a`.`rid`=" . mysqli_real_escape_string($dbc, $rid) . " AND `a`.`id`=" . -+ mysqli_real_escape_string($dbc, $iid[0]); -+ $selectResult=mysqli_query($dbc, $selectQuery); -+ $selectRow=mysqli_fetch_object($selectResult); -+ $interfaces = mysqli_num_rows($selectResult); - $name = $selectRow->name; - $description = $selectRow->description; - $speed = ($selectRow->speed)/1000000; - $router = $selectRow->router; -- } else if ($rid && !$iid) { -- $selectQuery="SELECT name AS router from router where rid=$rid"; -- $selectResult=mysql_query($selectQuery, $dbc); -- $selectRow=mysql_fetch_object($selectResult); -+ } else if (($rid != "") && ($iid == "")) { -+ $selectQuery="SELECT `name` AS `router` FROM `router` WHERE `rid`=" . -+ mysqli_real_escape_string($dbc, $rid); -+ $selectResult=mysqli_query($dbc, $selectQuery); -+ $selectRow=mysqli_fetch_object($selectResult); - $router = $selectRow->router; - } - - # Generate Title -- echo "<TITLE>RTG: "; -- if ($rid && $iid) echo "$router: $name"; -- else if ($rid && !$iid) echo "$router"; -- echo "</TITLE>\n"; -+ echo "<title>RTG: "; -+ if (($rid != "") && ($iid != "")) echo "$router: $name"; -+ else if (($rid != "") && ($iid == "")) echo "$router"; -+ echo "</title>\n"; - ?> - --</HEAD> --<BODY BACKGROUND="rtgback.png" BGCOLOR="ffffff"> --<A HREF="http://rtg.sourceforge.net" ALT="[RTG Home Page]"> --<IMG SRC="rtg.png" BORDER="0"> --</A> --<P> -+</head> -+<body background="rtgback.png" bgcolor="ffffff"> -+<a href="http://rtg.sourceforge.net" alt="[RTG Home Page]"><img src="rtg.png" border="0" /></a> -+<p> - - <?php --echo "<FORM ACTION=\"$PHP_SELF\" METHOD=\"get\">\n"; -+echo "<form action=\"$PHP_SELF\" method=\"get\">\n"; - --if (!$rid && !$iid) { -- echo "<SELECT NAME=\"rid\" SIZE=10>\n"; -- $selectQuery="SELECT DISTINCT name, rid FROM router ORDER BY name"; -- $selectResult=mysql_query($selectQuery, $dbc); -- while ($selectRow=mysql_fetch_object($selectResult)){ -- echo "<OPTION VALUE=\"$selectRow->rid\">$selectRow->name\n"; -+if (($rid == "") && ($iid == "")) { -+ echo "<select name=\"rid\" size=\"10\">\n"; -+ $selectQuery="SELECT DISTINCT `name`, `rid` FROM `router` ORDER BY `name`"; -+ $selectResult=mysqli_query($dbc, $selectQuery); -+ while ($selectRow=mysqli_fetch_object($selectResult)){ -+ echo "<option value=\"$selectRow->rid\">$selectRow->name</option>\n"; - } -- echo "</SELECT>\n"; -+ echo "</select>\n"; - } - --if ($smonth != "" && $iid == "") { -- echo "<BLOCKQUOTE><FONT SIZE=+1><STRONG>\n"; -+if (($smonth != "") && ($iid == "")) { -+ echo "<blockquote><font size=\"+1\"><b>\n"; - echo "Please select an interface!\n"; -- echo "</FONT></STRONG></BLOCKQUOTE>\n"; -+ echo "</b></font></blockquote>\n"; - } - --if ($rid && !$iid) { -- echo "<SELECT NAME=\"rid\" SIZE=10>\n"; -- echo "<OPTION SELECTED VALUE=\"$rid\">$router\n"; -- echo "</SELECT>\n"; -+if (($rid != "") && ($iid == "")) { -+ echo "<select name=\"rid\" size=\"10\">\n"; -+ echo "<option selected value=\"$rid\">$router</option>\n"; -+ echo "</select>\n"; - -- echo "<SELECT MULTIPLE NAME=\"iid[]\" SIZE=10>\n"; -- $selectQuery="SELECT id, name, description FROM interface WHERE rid=$rid ORDER BY name"; -- $selectResult=mysql_query($selectQuery, $dbc); -- while ($selectRow=mysql_fetch_object($selectResult)){ -- echo "<OPTION VALUE=\"$selectRow->id\">$selectRow->name ($selectRow->description)\n"; -+ echo "<select multiple name=\"iid[]\" size=\"10\">\n"; -+ $selectQuery="SELECT `id`, `name`, `description` FROM `interface` WHERE " . -+ "`rid`=" . mysqli_real_escape_string($dbc, $rid) . " ORDER BY `name`"; -+ $selectResult=mysqli_query($dbc, $selectQuery); -+ while ($selectRow=mysqli_fetch_object($selectResult)){ -+ echo "<option value=\"$selectRow->id\">$selectRow->name ($selectRow->description)</option>\n"; - } -- echo "</SELECT>\n"; -+ echo "</select>\n"; - -- echo "<P><TABLE>\n"; -- echo "<TD>From: \n"; -- echo "<TD><INPUT TYPE=TEXT NAME=\"smonth\" SIZE=3 MAXLENGTH=2 VALUE=\""; -+ echo "<p><table>\n"; -+ echo "<tr><td>From: </td>\n"; -+ echo "<td><input type=\"text\" name=\"smonth\" size=\"3\" maxlength=\"2\" value=\""; - print (date("m")); -- echo "\"> / \n"; -- echo "<INPUT TYPE=TEXT NAME=\"sday\" SIZE=3 MAXLENGTH=2 VALUE=\""; -+ echo "\" /> / \n"; -+ echo "<input type=\"text\" name=\"sday\" size=\"3\" maxlength=\"2\" value=\""; - print (date("d")); -- echo "\"> / \n"; -- echo "<INPUT TYPE=TEXT NAME=\"syear\" SIZE=5 MAXLENGTH=4 VALUE=\""; -+ echo "\" /> / \n"; -+ echo "<input type=\"text\" name=\"syear\" size=\"5\" maxlength=\"4\" value=\""; - print (date("Y")); -- echo "\">\n"; -- echo "<TD><INPUT TYPE=TEXT NAME=\"shour\" SIZE=3 MAXLENGTH=2 VALUE=\"00\">:\n"; -- echo "<INPUT TYPE=TEXT NAME=\"smin\" SIZE=3 MAXLENGTH=2 VALUE=\"00\">\n"; -+ echo "\" />\n"; -+ echo "</td>"; -+ echo "<td><input type=\"text\" name=\"shour\" size=\"3\" maxlength=\"2\" value=\"00\" />:\n"; -+ echo "<input type=\"text\" name=\"smin\" size=\"3\" maxlength=\"2\" value=\"00\" />\n"; -+ echo "</td></tr>\n"; - -- echo "<TR><TD>To: \n"; -- echo "<TD><INPUT TYPE=TEXT NAME=\"emonth\" SIZE=3 MAXLENGTH=2 VALUE=\""; -+ echo "<tr><td>To: </td>\n"; -+ echo "<td><input type=\"text\" name=\"emonth\" size=\"3\" maxlength=\"2\" value=\""; - print (date("m")); -- echo "\"> / \n"; -- echo "<INPUT TYPE=TEXT NAME=\"eday\" SIZE=3 MAXLENGTH=2 VALUE=\""; -+ echo "\" /> / \n"; -+ echo "<input type=\"text\" name=\"eday\" size=\"3\" maxlength=\"2\" value=\""; - print (date("d")); -- echo "\"> / \n"; -- echo "<INPUT TYPE=TEXT NAME=\"eyear\" SIZE=5 MAXLENGTH=4 VALUE=\""; -+ echo "\" /> / \n"; -+ echo "<input type=\"text\" name=\"eyear\" size=\"5\" maxlength=\"4\" value=\""; - print (date("Y")); -- echo "\">\n"; -- echo "<TD><INPUT TYPE=TEXT NAME=\"ehour\" SIZE=3 MAXLENGTH=2 VALUE=\"23\">:\n"; -- echo "<INPUT TYPE=TEXT NAME=\"emin\" SIZE=3 MAXLENGTH=2 VALUE=\"59\">\n"; -- echo "<TR><TD>Aggregate Interfaces: \n"; -- echo "<TD><INPUT TYPE=CHECKBOX NAME=\"aggr\">\n"; -- echo "<TR><TD><INPUT TYPE=TEXT NAME=\"nth\" SIZE=2 MAXLENGTH=2 VALUE=\"95\">th Percentile: \n"; -- echo "<TD><INPUT TYPE=CHECKBOX NAME=\"percentile\">\n"; -- echo "<TR><TD>Fit to Data: \n"; -- echo "<TD><INPUT TYPE=CHECKBOX NAME=\"scalex\">\n"; -- echo "<TR><TD>Fit to Speed: \n"; -- echo "<TD><INPUT TYPE=CHECKBOX NAME=\"scaley\">\n"; -- echo "<TR><TD>X Size: \n"; -- echo "<TD><INPUT TYPE=TEXT NAME=\"xplot\" SIZE=3 VALUE=\"500\">\n"; -- echo "<TR><TD>Y Size: \n"; -- echo "<TD><INPUT TYPE=TEXT NAME=\"yplot\" SIZE=3 VALUE=\"150\">\n"; -- echo "<TR><TD>BorderB: \n"; -- echo "<TD><INPUT TYPE=TEXT NAME=\"borderb\" SIZE=3 VALUE=\"70\">\n"; -- echo "</TABLE>\n"; -+ echo "\" />\n"; -+ echo "</td>"; -+ echo "<td><input type=\"text\" name=\"ehour\" size=\"3\" maxlength=\"2\" value=\"23\" />:\n"; -+ echo "<input type=\"text\" name=\"emin\" size=\"3\" maxlength=\"2\" value=\"59\" />\n"; -+ echo "</td></tr>\n"; -+ -+ echo "<tr><td>Aggregate Interfaces: </td>\n"; -+ echo "<td><input type=\"checkbox\" name=\"aggr\" /></td></tr>\n"; -+ echo "<tr><td><input type=\"text\" name=\"nth\" size=\"2\" maxlength=\"2\" value=\"95\" />th Percentile: </td>\n"; -+ echo "<td><input type=\"checkbox\" name=\"percentile\" /></td></tr>\n"; -+ echo "<tr><td>Fit to Data: </td>\n"; -+ echo "<td><input type=\"checkbox\" name=\"scalex\" /></td></tr>\n"; -+ echo "<tr><td>Fit to Speed: </td>\n"; -+ echo "<td><input type=\"checkbox\" name=\"scaley\" /></td></tr>\n"; -+ echo "<tr><td>X Size: </td>\n"; -+ echo "<td><input type=\"text\" name=\"xplot\" size=\"3\" value=\"500\" /></td></tr>\n"; -+ echo "<tr><td>Y Size: </td>\n"; -+ echo "<td><input type=\"text\" name=\"yplot\" size=\"3\" value=\"150\" /></td></tr>\n"; -+ echo "<tr><td>BorderB: </td>\n"; -+ echo "<td><input type=\"text\" name=\"borderb\" size=\"3\" value=\"70\" /></td></tr>\n"; -+ echo "</table>\n"; - } - --if (($bt || $smonth) && $iid) { -+if (($bt != "" || $smonth != "") && ($iid != "")) { - - /* Format into GNU date syntax */ - if ($bt == "") { -@@ -148,67 +154,84 @@ if (($bt || $smonth) && $iid) { - $et = strtotime("$eyear-$emonth-$eday $ehour:$emin:59"); - } - -- $range="dtime>FROM_UNIXTIME($bt) AND dtime<=FROM_UNIXTIME($et)"; -- $range="$range AND id=$iid[0]"; -+ $range="`dtime`>FROM_UNIXTIME(" . mysqli_real_escape_string($dbc, $bt) . ") AND " . -+ "`dtime`<=FROM_UNIXTIME(" . mysqli_real_escape_string($dbc, $et) . ") " . -+ "AND `id`=" . mysqli_real_escape_string($dbc, $iid[0]); - -- $selectQuery="SELECT description, name, speed FROM interface WHERE rid=$rid AND id=$iid[0]"; -- $selectResult=mysql_query($selectQuery, $dbc); -- $selectRow=mysql_fetch_object($selectResult); -- echo "<TABLE BORDER=0>\n"; -- echo "<TD><I>Device</I>:</TD><TD>$router ($rid)</TD><TR>\n"; -- echo "<TD><I>Interface</I>:</TD><TD>$selectRow->name ($iid[0])</TD><TR>\n"; -- printf ("<TD><I>Speed</I>:</TD><TD>%2.3f Mbps</TD><TR>\n", $selectRow->speed / 1000000); -- echo "<TD><I>Description</I>:</TD><TD>$selectRow->description</TD><TR>\n"; -- print strftime("<TD><I>Period</I>:</TD><TD>%m/%d/%Y %H:%M - ", $bt); -- print strftime("%m/%d/%Y %H:%M</TD>\n", $et); -- echo "</TABLE>\n"; -- echo "<P>\n"; -+ $selectQuery="SELECT `description`, `name`, `speed` FROM `interface` WHERE " . -+ "`rid`=" . mysqli_real_escape_string($dbc, $rid) . " AND `id`=" . -+ mysqli_real_escape_string($dbc, $iid[0]); -+ $selectResult=mysqli_query($dbc, $selectQuery); -+ $selectRow=mysqli_fetch_object($selectResult); -+ echo "<table border=\"0\">\n"; -+ echo "<tr><td><i>Device</i>:</td><td>$router ($rid)</td></tr>\n"; -+ echo "<tr><td><i>Interface</i>:</td><td>$selectRow->name ($iid[0])</td></tr>\n"; -+ printf ("<tr><td><i>Speed</i>:</td><td>%2.3f Mbps</td></tr>\n", $selectRow->speed / 1000000); -+ echo "<tr><td><i>Description</i>:</td><td>$selectRow->description</td></tr>\n"; -+ print strftime("<tr><td><i>Period</i>:</td><td>%m/%d/%Y %H:%M - ", $bt); -+ print strftime("%m/%d/%Y %H:%M</td>\n", $et); -+ echo "</tr>\n"; -+ echo "</table>\n"; -+ echo "<p>\n"; - - #$selectQuery="SELECT DISTINCT id FROM ifInOctets_$rid WHERE $range"; -- #$selectResult=mysql_query($selectQuery, $dbc); -- #if (mysql_num_rows($selectResult) <= 0) { -+ #$selectResult=mysqli_query($dbc, $selectQuery); -+ #if (mysqli_num_rows($selectResult) <= 0) { - # print "<BR>No Data Found on Interface for Given Range.<BR>\n"; - #} - #else { -- $args = "t1=ifInOctets_$rid&t2=ifOutOctets_$rid&begin=$bt&end=$et&units=bits/s&factor=8"; -+ $args = "t1=ifInOctets_$rid&t2=ifOutOctets_$rid&begin=$bt&"; -+ $args .= "end=$et&units=bits/s&factor=8"; -+ $args .= "&title=" . urlencode($selectRow->description); -+ $args .= "&t1_name=" . urlencode("Input Octets"); -+ $args .= "&t2_name=" . urlencode("Output Octets"); - foreach ($iid as $value) { -- $args="$args&iid=$value"; -+ $args="$args&iid=" . urlencode($value); - } -- if ($scalex) $args = "$args&scalex=yes"; -- if ($scaley) $args = "$args&scaley=yes"; -- if ($xplot) $args = "$args&xplot=$xplot"; -- if ($yplot) $args = "$args&yplot=$yplot"; -- if ($borderb) $args = "$args&borderb=$borderb"; -- if ($aggr) $args = "$args&aggr=yes"; -- if ($percentile) $args = "$args&percentile=$nth"; -- print "<IMG SRC=rtgplot.cgi?$args><BR>\n"; -- $args = "t1=ifInUcastPkts_$rid&t2=ifOutUcastPkts_$rid&begin=$bt&end=$et&units=pkts/s"; -+ if ($scalex != "") $args = "$args&scalex=yes"; -+ if ($scaley != "") $args = "$args&scaley=yes"; -+ if ($xplot != "") $args = "$args&xplot=$xplot"; -+ if ($yplot != "") $args = "$args&yplot=$yplot"; -+ if ($borderb != "") $args = "$args&borderb=$borderb"; -+ if ($aggr != "") $args = "$args&aggr=yes"; -+ if ($percentile != "") $args = "$args&percentile=$nth"; -+ print "<img src=\"/cgi-bin/rtgplot.cgi?$args\" alt=\"graph\" /><br />\n"; -+ $args = "t1=ifInUcastPkts_$rid&t2=ifOutUcastPkts_$rid&begin=$bt&"; -+ $args .= "end=$et&units=pkts/s"; -+ $args .= "&title=" . urlencode($selectRow->description); -+ $args .= "&t1_name=" . urlencode("Input Packets"); -+ $args .= "&t2_name=" . urlencode("Output Packets"); - foreach ($iid as $value) { -- $args="$args&iid=$value"; -+ $args="$args&iid=" . urlencode($value); -+ } -+ if ($scalex != "") $args = "$args&scalex=yes"; -+ if ($xplot != "") $args = "$args&xplot=$xplot"; -+ if ($yplot != "") $args = "$args&yplot=$yplot"; -+ if ($borderb != "") $args = "$args&borderb=$borderb"; -+ if ($aggr != "") $args = "$args&aggr=yes"; -+ if ($percentile != "") $args = "$args&percentile=$nth"; -+ print "<img src=\"/cgi-bin/rtgplot.cgi?$args\" alt=\"graph\" /><br />\n"; -+ if ($errors != "") -+ { -+ print "<img src=\"/cgi-bin/rtgplot.cgi?t1=ifInErrors_$rid&begin=$bt"; -+ print "&end=$et&units=errors&impulses=yes"; -+ print "&title=" . urlencode($selectRow->description); -+ print "&t1_name=" . urlencode("Errors") . "\" alt=\"graph\" />\n"; - } -- if ($scalex) $args = "$args&scalex=yes"; -- if ($xplot) $args = "$args&xplot=$xplot"; -- if ($yplot) $args = "$args&yplot=$yplot"; -- if ($borderb) $args = "$args&borderb=$borderb"; -- if ($aggr) $args = "$args&aggr=yes"; -- if ($percentile) $args = "$args&percentile=$nth"; -- print "<IMG SRC=rtgplot.cgi?$args><BR>\n"; -- if ($errors) -- print "<IMG SRC=rtgplot.cgi?t1=ifInErrors_$rid&begin=$bt&end=$et&units=errors&impulses=yes>\n"; - # } - } - --mysql_close($dbc); -+mysqli_close($dbc); - ?> - --<P> --<INPUT TYPE="SUBMIT" VALUE="Ok"> --</FORM> --<BR> --<HR> --<FONT FACE="Arial" SIZE="2"> -+<p> -+<input type="submit" value="Ok" /> -+</form> -+<br /> -+<hr /> -+<font face="Arial" size="2"> - <?php -- print "<A HREF=\"http://rtg.sourceforge.net\">RTG</A> Version $VERSION</FONT>"; --?> --</BODY> --</HTML> -+ print "<a href=\"http://rtg.sourceforge.net\">RTG</a> Version $VERSION</font>"; -+?></p> -+</body> -+</html> diff --git a/net/rtg/files/patch-etc_rtgtargmkr.pl.in b/net/rtg/files/patch-etc_rtgtargmkr.pl.in index 0b38986d80f6..9d9c6ed0a7eb 100644 --- a/net/rtg/files/patch-etc_rtgtargmkr.pl.in +++ b/net/rtg/files/patch-etc_rtgtargmkr.pl.in @@ -1,110 +1,11 @@ ---- etc/rtgtargmkr.pl.in.orig 2018-04-02 20:14:41 UTC +--- etc/rtgtargmkr.pl.in.orig 2020-09-23 11:57:31 UTC +++ etc/rtgtargmkr.pl.in -@@ -10,10 +10,11 @@ - # Local customization - - $community = "public"; # Default SNMP community --$defbits = 32; # Default OID bits: 32/64 -+$defbits = 64; # Default OID bits: 32/64 - $output = "targets.cfg"; # Output target file name - $router_file = "routers"; # Input list of devices to poll - $conf_file = "rtg.conf"; # RTGpoll and RTGplot configurations -+$update_desc = 0; # Update interface descriptions - $INFO = 1; # Print informational messages - $DEBUG = 0; # Print debug messages - $DBOFF = 0; # Turn database queries off (debug) -@@ -77,7 +78,7 @@ $catalyst = [ +@@ -78,7 +78,7 @@ $catalyst = [ ); # Default locations to find RTG configuration file -@configs = ("rtg.conf", "/usr/local/rtg/etc/rtg.conf", "/etc/rtg.conf"); -+@configs = ("rtg.conf", "@RTG_HOME@/etc/rtg.conf", "/usr/local/rtg/etc/rtg.conf", "/etc/rtg.conf"); ++@configs = ("rtg.conf", "%%PREFIX%%/etc/rtg/rtg.conf", "/usr/local/rtg/etc/rtg.conf", "/etc/rtg.conf"); foreach $conf (@configs) { if (open CONF, "<$conf") { print "Reading [$conf].\n" if $DEBUG; -@@ -93,7 +94,9 @@ foreach $conf (@configs) { - $db_db=$cVals[1]; - } elsif ($cVals[0] =~ /Interval/) { - $interval=$cVals[1]; -- } -+ } elsif ($cVals[0] =~ /Update_desc/) { -+ $update_desc=$cVals[1]; -+ } - } - last; - } -@@ -113,7 +116,7 @@ sub sql_insert { - # exist, create a new entry and corresponding tables. - sub find_router_id { - ($router) = @_; -- $sql = "SELECT DISTINCT rid FROM router WHERE name=\"$router\""; -+ $sql = "SELECT DISTINCT `rid` FROM `router` WHERE `name`=\"$router\""; - print "SQL: $sql\n" if $DEBUG; - my $sth = $dbh->prepare($sql) - or die "Can't prepare $sql: $dbh->errstr\n"; -@@ -121,12 +124,12 @@ sub find_router_id { - or die "can't execute the query: $sth->errstr\n"; - if ( $sth->rows == 0 ) { - print "No router id found for $router..."; -- $sql = "INSERT INTO router (name) VALUES(\"$router\")"; -+ $sql = "INSERT INTO `router` (`name`) VALUES(\"$router\")"; - print "adding.\n"; - &sql_insert($sql); - $rid = &find_router_id($router); - foreach $mib ( keys %mibs_of_interest ) { -- $sql = "CREATE TABLE $mib"."_$rid (id INT NOT NULL, dtime DATETIME NOT NULL, counter BIGINT NOT NULL, KEY $mib"."_$rid". "_idx (dtime))"; -+ $sql = "CREATE TABLE `$mib"."_$rid` (`id` INT NOT NULL, `dtime` DATETIME NOT NULL, `counter` BIGINT NOT NULL, KEY `$mib"."_$rid". "_idx` (`dtime`), KEY `id_dtime_idx` (`id`,`dtime`))"; - &sql_insert($sql); - } - } -@@ -143,7 +146,7 @@ sub find_router_id { - sub find_interface_id { - ( $rid, $int, $desc, $speed ) = @_; - $desc =~ s/ +$//g; #remove trailing whitespace -- $sql = "SELECT id, description FROM interface WHERE rid=$rid AND name=\"$int\""; -+ $sql = "SELECT `id`, `description` FROM `interface` WHERE `rid`=$rid AND `name`=\"$int\""; - print "SQL: $sql\n" if $DEBUG; - my $sth = $dbh->prepare($sql) - or die "Can't prepare $sql: $dbh->errstr\n"; -@@ -152,7 +155,7 @@ sub find_interface_id { - if ( $sth->rows == 0 ) { - print "No id found for $int on device $rid..."; - $desc =~ s/\"/\\\"/g; # Fix " in desc -- $sql = "INSERT INTO interface (name, rid, speed, description) VALUES(\"$int\", $rid, $speed, \"$desc\")"; -+ $sql = "INSERT INTO `interface` (`name`, `rid`, `speed`, `description`) VALUES(\"$int\", $rid, $speed, \"$desc\")"; - print "adding.\n"; - &sql_insert($sql); - $iid = &find_interface_id( $rid, $int, $desc, $speed ); -@@ -164,7 +167,13 @@ sub find_interface_id { - print "Interface description changed.\n"; - print "Was: \"$row[1]\"\n"; - print "Now: \"$desc\"\n"; -- print "Suggest: UPDATE interface SET description='$desc' WHERE id=$iid\n"; -+ if ( $update_desc == 1 ) { -+ $sql = "UPDATE `interface` SET `description`='$desc' WHERE `id`=$iid"; -+ &sql_insert($sql); -+ print "Updated.\n"; -+ } else { -+ print "Suggest: UPDATE `interface` SET `description`='$desc' WHERE `id`=$iid\n"; -+ } - } - } - $sth->finish; -@@ -289,7 +298,7 @@ sub main { - $year + 1900, $hour, $min; - print CFG "# Host\tOID\tBits\tCommunity\tTable\tID\tDescription\n"; - -- foreach $router (@routers) { -+ POKE: foreach $router (@routers) { - $bits = $counterBits{$router}; - # Sanity check bits - $bits = $defbits if ( ( $bits != 32 ) && ( $bits != 64 ) ); -@@ -304,7 +313,7 @@ sub main { - $system = join ( ' ', @result ); - print "System: $system\n" if $DEBUG; - $session = SNMP_Session->open( $router, $communities{$router}, 161 ) -- || die "Error opening SNMP session to $router"; -+ || ( print "Error opening SNMP session to $router" and next POKE ); - if ( $system =~ /.*Cisco.*WS-.*/ ) { - $system = "Catalyst"; - $session->map_table( $catalyst, \&process ); diff --git a/net/rtg/files/patch-etc_view.php b/net/rtg/files/patch-etc_view.php deleted file mode 100644 index 31afc067ffe7..000000000000 --- a/net/rtg/files/patch-etc_view.php +++ /dev/null @@ -1,258 +0,0 @@ ---- etc/view.php.orig 2003-09-26 15:58:34 UTC -+++ etc/view.php -@@ -8,154 +8,163 @@ - header("Cache-Control: no-cache, must-revalidate"); - header("Pragma: no-cache"); - -- print "<HTML>\n<!-- RTG Version $VERSION -->\n<HEAD>\n"; -+ print "<html>\n<!-- RTG Version $VERSION -->\n<head>\n"; - - /* Connect to RTG MySQL Database */ -- $dbc=@mysql_connect ($host, $user, $pass) or -- $dbc=@mysql_connect ("$host:/var/lib/mysql/mysql.sock", $user, $pass) or -+ $dbc=@mysqli_connect ($host, $user, $pass, $db) or - die ("MySQL Connection Failed, Check Configuration."); -- mysql_select_db($db,$dbc); - - # Global variables off by default in newer versions of PHP -- if (!$PHP_SELF) { -+ if (!isset($PHP_SELF) || ($PHP_SELF == "")) { - $PHP_SELF = "view.php"; -- $rid = $_GET['rid']; -- $iid = $_GET['iid']; -+ $rid = isset($_GET['rid'])?$_GET['rid']:""; -+ $iid = isset($_GET['iid'])?$_GET['iid']:""; - } - - # Determine router, interface names as necessary -- if ($rid && $iid) { -- $selectQuery="SELECT a.name, a.description, a.speed, b.name AS router FROM interface a, router b WHERE a.rid=b.rid AND a.rid=$rid AND a.id=$iid"; -- $selectResult=mysql_query($selectQuery, $dbc); -- $selectRow=mysql_fetch_object($selectResult); -- $interfaces = mysql_num_rows($selectResult); -+ if (($rid != "") && ($iid != "")) { -+ $selectQuery="SELECT `a`.`name`, `a`.`description`, `a`.`speed`, `b`.`name` " . -+ "AS `router` FROM `interface` `a`, `router` `b` WHERE `a`.`rid`=`b`.`rid` " . -+ "AND `a`.`rid`=" . mysqli_real_escape_string($dbc, $rid) . " AND `a`.`id`=" . -+ mysqli_real_escape_string($dbc, $iid); -+ $selectResult=mysqli_query($dbc, $selectQuery); -+ $selectRow=mysqli_fetch_object($selectResult); -+ $interfaces = mysqli_num_rows($selectResult); - $name = $selectRow->name; - $description = $selectRow->description; - $speed = ($selectRow->speed)/1000000; - $router = $selectRow->router; -- } else if ($rid && !$iid) { -- $selectQuery="SELECT name AS router from router where rid=$rid"; -- $selectResult=mysql_query($selectQuery, $dbc); -- $selectRow=mysql_fetch_object($selectResult); -+ } else if (($rid != "")&& ($iid == "")) { -+ $selectQuery="SELECT `name` AS `router` FROM `router` WHERE `rid`=" . -+ mysqli_real_escape_string($dbc, $rid); -+ $selectResult=mysqli_query($dbc, $selectQuery); -+ $selectRow=mysqli_fetch_object($selectResult); - $router = $selectRow->router; - } - - # Generate Title -- echo "<TITLE>RTG: "; -- if ($rid && $iid) echo "$router: $name"; -- else if ($rid && !$iid) echo "$router"; -- echo "</TITLE>\n"; -+ echo "<title>RTG: "; -+ if (($rid != "") && ($iid != "")) echo "$router: $name"; -+ else if (($rid != "")&& ($iid == "")) echo "$router"; -+ echo "</title>\n"; - -- print "<meta HTTP-EQUIV=\"Refresh\" CONTENT=\"300\">\n"; -- print "<meta HTTP-EQUIV=\"Pragma\" CONTENT=\"no-cache\">\n"; -- print "<meta HTTP-EQUIV=\"Cache-Control\" CONTENT=\"no-cache\">\n"; -- print "<meta HTTP-EQUIV=\"Expires\" CONTENT=\"".gmdate('D, d M Y H:i:s \G\M\T', time() + 300)."\">\n"; -- print "<meta HTTP-EQUIV=\"Generator\" CONTENT=\"RTG $VERSION\">\n"; -- print "<meta HTTP-EQUIV=\"Date\" CONTENT=\"".gmdate('D, d M Y H:i:s \G\M\T', time())."\">\n"; -- print "<meta HTTP-EQUIV=\"Content-Type\" CONTENT=\"text/html; charset=iso-8859-1\">\n"; -+ print "<meta http-equiv=\"Refresh\" content=\"300\" />\n"; -+ print "<meta http-equiv=\"Pragma\" content=\"no-cache\" />\n"; -+ print "<meta http-equiv=\"Cache-Control\" content=\"no-cache\" />\n"; -+ print "<meta http-equiv=\"Expires\" content=\"".gmdate('D, d M Y H:i:s \G\M\T', time() + 300)."\" />\n"; -+ print "<meta http-equiv=\"Generator\" content=\"RTG $VERSION\" />\n"; -+ print "<meta http-equiv=\"Date\" content=\"".gmdate('D, d M Y H:i:s \G\M\T', time())."\" />\n"; -+ print "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\" />\n"; - ?> - --</HEAD> --<BODY BGCOLOR="ffffff"> --<A HREF="http://rtg.sourceforge.net" ALT="[RTG Home Page]"> --<IMG SRC="rtg.png" BORDER="0"></A><P><HR> -+</head> -+<body bgcolor="ffffff"> -+<a href="http://rtg.sourceforge.net"<img src="rtg.png" border="0" alt="[RTG Home Page]" /></a><p><hr /> - - <?php -- echo "<FORM ACTION=\"$PHP_SELF\" METHOD=\"GET\">\n"; -+ echo "<form action=\"$PHP_SELF\" method=\"get\">\n"; - - $et = time(); - -- if (!$rid) { -+ if ($rid == "") { - print "Monitored Devices: <P>\n"; -- $selectQuery="SELECT rid, name FROM router"; -- $selectResult=mysql_query($selectQuery, $dbc); -- if (mysql_num_rows($selectResult) <= 0) -- print "<BR>No Routers Found.<BR>\n"; -+ $selectQuery="SELECT `rid`, `name` FROM `router`"; -+ $selectResult=mysqli_query($dbc, $selectQuery); -+ if (mysqli_num_rows($selectResult) <= 0) -+ print "<br />No Routers Found.<br />\n"; - else { -- print "<UL>\n"; -- while ($selectRow=mysql_fetch_object($selectResult)){ -- print "<LI><A HREF=\"$PHP_SELF?rid=$selectRow->rid\">"; -- print "$selectRow->name</A><BR>\n"; -+ print "<ul>\n"; -+ while ($selectRow=mysqli_fetch_object($selectResult)){ -+ print "<li><a href=\"$PHP_SELF?rid=$selectRow->rid\">"; -+ print "$selectRow->name</a></li><br />\n"; - } -- print "</UL>\n"; -+ print "</ul>\n"; - } - } - -- if ($rid && $iid) { -+ if (($rid != "") && ($iid != "")) { - if ($interfaces <= 0) -- print "<BR>Interface $iid Not Found for Router $router (ID: $rid).<BR>\n"; -+ print "<br />Interface $iid Not Found for Router $router (ID: $rid).<br />\n"; - else { -- print "<TABLE>\n"; -- print "<TD>System:<TD>$router\n"; -- print "<TR><TD>Interface:<TD>$name\n"; -- print "<TR><TD>Description:<TD>$description\n"; -- print "<TR><TD>Speed:<TD>$speed Mbps\n"; -- print "<TR><TD>Page Generated:<TD>".gmdate('D, d M Y H:i:s \G\M\T', time())."\n"; -- print "</TABLE><HR>\n"; -+ print "<table>\n"; -+ print "<tr><td>System:</td><td>$router</td></tr>\n"; -+ print "<tr><td>Interface:</td><td>$name</td></tr>\n"; -+ print "<tr><td>Description:</td><td>$description</td></tr>\n"; -+ print "<tr><td>Speed:</td><td>$speed Mbps</td></tr>\n"; -+ print "<tr><td>Page Generated:</td><td>".gmdate('D, d M Y H:i:s \G\M\T', time())."</td></tr>\n"; -+ print "</table><hr />\n"; - - $bt = $et - (60*60*24); -- print "<B>Day View:</B><BR>\n"; -- print "<IMG SRC=\"rtgplot.cgi?t1=ifInOctets_".$rid."&t2=ifOutOctets_".$rid."&iid=$iid&begin=$bt&end=$et&units=bits/s&factor=8&filled=yes\">\n"; -- print "<BR><B>$router: $name ($description)</B>\n"; -- print "<BR><HR>\n"; -+ print "<b>Day View:</b><br />\n"; -+ print "<img src=\"/cgi-bin/rtgplot.cgi?t1=ifInOctets_".$rid."&t2=ifOutOctets_".$rid."&iid=$iid&begin=$bt&end=$et&units=bits/s&factor=8&filled=yes"; -+ print "&title=" . urlencode("$router: $name ($description)") . "&t1_name=" . urlencode("Input Octets") . "&t2_name=" . urlencode("Output Octets") . "\" />\n"; -+ print "<br /><b>$router: $name ($description)</b>\n"; -+ print "<br /><hr />\n"; - - $bt = $et - (60*60*24*7); -- print "<B>Week View:</B><BR>\n"; -- print "<IMG SRC=\"rtgplot.cgi?t1=ifInOctets_".$rid."&t2=ifOutOctets_".$rid."&iid=$iid&begin=$bt&end=$et&units=bits/s&factor=8&filled=yes\">\n"; -- print "<BR><B>$router: $name ($description)</B>\n"; -- print "<BR><HR>\n"; -+ print "<b>Week View:</b><br />\n"; -+ print "<img src=\"/cgi-bin/rtgplot.cgi?t1=ifInOctets_".$rid."&t2=ifOutOctets_".$rid."&iid=$iid&begin=$bt&end=$et&units=bits/s&factor=8&filled=yes"; -+ print "&title=" . urlencode("$router: $name ($description)") . "&t1_name=" . urlencode("Input Octets") . "&t2_name=" . urlencode("Output Octets") . "\" />\n"; -+ print "<br /><b>$router: $name ($description)</b>\n"; -+ print "<br /><hr />\n"; - - $bt = $et - (60*60*24*30); -- print "<B>Month View:</B><BR>\n"; -- print "<IMG SRC=\"rtgplot.cgi?t1=ifInOctets_".$rid."&t2=ifOutOctets_".$rid."&iid=$iid&begin=$bt&end=$et&units=bits/s&factor=8&filled=yes\">\n"; -- print "<BR><B>$router: $name ($description)</B>\n"; -- print "<BR><BR>\n"; -+ print "<b>Month View:</b><br />\n"; -+ print "<img src=\"/cgi-bin/rtgplot.cgi?t1=ifInOctets_".$rid."&t2=ifOutOctets_".$rid."&iid=$iid&begin=$bt&end=$et&units=bits/s&factor=8&filled=yes"; -+ print "&title=" . urlencode("$router: $name ($description)") . "&t1_name=" . urlencode("Input Octets") . "&t2_name=" . urlencode("Output Octets") . "\" />\n"; -+ print "<br /><b>$router: $name ($description)</b>\n"; -+ print "<br /><br />\n"; - } -- print "<INPUT TYPE=\"SUBMIT\" VALUE=\"Back to Main\">\n"; -+ print "<input type=\"submit\" value=\"Back to Main\" />\n"; - } - -- if ($rid && !$iid) { -- $selectQuery="SELECT id, name, description FROM interface WHERE rid=$rid"; -- $selectResult=mysql_query($selectQuery, $dbc); -- $interfaces = mysql_num_rows($selectResult); -+ if (($rid != "") && ($iid == "")) { -+ $selectQuery="SELECT `id`, `name`, `description` FROM `interface` WHERE " . -+ "`rid`=" . mysqli_real_escape_string($dbc, $rid); -+ $selectResult=mysqli_query($dbc, $selectQuery); -+ $interfaces = mysqli_num_rows($selectResult); - if ($interfaces <= 0) -- print "<BR>No Interfaces Found for Router $router (ID: $rid).<BR>\n"; -+ print "<br />No Interfaces Found for Router $router (ID: $rid).<br />\n"; - else { - $bt = $et - (60*60*12); -- print "<TABLE>\n"; -- print "<TD>System:<TD>$router\n"; -- print "<TR><TD>Interfaces:<TD>$interfaces\n"; -- print "<TR><TD>Page Generated:<TD>"; -- print gmdate('D, d M Y H:i:s \G\M\T', time())."\n"; -- print "</TABLE><HR>\n"; -- print "<TABLE BORDER=\"0\" CELLPADDING=\"0\" CELLSPACING=\"10\">\n"; -- while ($selectRow=mysql_fetch_object($selectResult)){ -+ print "<table>\n"; -+ print "<tr><td>System:</td><td>$router</td></tr>\n"; -+ print "<tr><td>Interfaces:</td><td>$interfaces</td></tr>\n"; -+ print "<tr><td>Page Generated:</td><td>"; -+ print gmdate('D, d M Y H:i:s \G\M\T', time())."</td></tr>\n"; -+ print "</table><hr />\n"; -+ print "<table border=\"0\" cellpadding=\"0\" cellspacing=\"10\">\n"; -+ print "<tr>\n"; -+ while ($selectRow=mysqli_fetch_object($selectResult)){ - $ids[$selectRow->id] = $selectRow->name; - $desc[$selectRow->id] = $selectRow->description; - $iid = $selectRow->id; -- print "<TD><A HREF=\"$PHP_SELF?rid=$rid&iid=$iid\">\n"; -- print "<IMG HEIGHT=\"135\" WIDTH=\"500\" SRC=\"rtgplot.cgi?t1=ifInOctets_".$rid."&t2=ifOutOctets_".$rid."&iid=$iid&begin=$bt&end=$et&units=bits/s&factor=8&filled=yes\" BORDER=\"0\">\n"; -- print "</A><BR>\n"; -- print "<B>$selectRow->name ($selectRow->description)</B>\n"; -- if ($even) { -+ print "<td><a href=\"$PHP_SELF?rid=$rid&iid=$iid\">\n"; -+ print "<img height=\"135\" width=\"500\" src=\"/cgi-bin/rtgplot.cgi?t1=ifInOctets_".$rid."&t2=ifOutOctets_".$rid; -+ print "&title=" . urlencode("$router: " . $selectRow->name . " (" . $selectRow->description . ")"); -+ print "&t1_name=" . urlencode("Input Octets") . "&t2_name=" . urlencode("Output Octets"); -+ print "&iid=$iid&begin=$bt&end=$et&units=bits/s&factor=8&filled=yes\" border=\"0\" />\n"; -+ print "</a><br />\n"; -+ print "<b>$selectRow->name ($selectRow->description)</b>\n"; -+ if ($even == 1) { - $even = 0; -- print "<TR>\n"; -+ print "</tr><tr>\n"; - } - else $even = 1; - } -- print "</TABLE>\n"; -+ print "</tr></table>\n"; - } -- print "<INPUT TYPE=\"SUBMIT\" VALUE=\"Back to Main\">\n"; -+ print "<input type=\"submit\" value=\"Back to Main\" />\n"; - } - -- if ($dbc) mysql_close($dbc); -- echo "</FORM>\n"; -+ if ($dbc) mysqli_close($dbc); -+ echo "</form>\n"; - ?> - --<HR> --<FONT FACE="Arial" SIZE="2"> -+<hr /> -+<font face="Arial" size="2"> - <?php -- print "<A HREF=\"http://rtg.sourceforge.net\">RTG</A> Version $VERSION</FONT>"; -+ print "<a href=\"http://rtg.sourceforge.net\">RTG</a> Version $VERSION</font>"; - ?> --</BODY> --</HTML> -+</body> -+</html> diff --git a/net/rtg/files/patch-man_rtgplot.1 b/net/rtg/files/patch-man_rtgplot.1 deleted file mode 100644 index 6ccca28ba90f..000000000000 --- a/net/rtg/files/patch-man_rtgplot.1 +++ /dev/null @@ -1,43 +0,0 @@ ---- man/rtgplot.1.orig 2003-09-25 04:10:36 UTC -+++ man/rtgplot.1 -@@ -10,7 +10,8 @@ - -t tablename(s) -i interface(s) [options] begin end - .br - .B rtgplot.cgi --?t1=tablename &t2=tablename &iid=interface &begin=unixtime &end=unixtime &[options] -+?t1=tablename &t`_name=descname &t2=tablename &t2_name=descname &iid=interface -+&begin=unixtime &end=unixtime &[options] - .SH DESCRIPTION - .I rtgplot - generates traffic plots of RTG data in PNG format. It operates in -@@ -82,14 +83,19 @@ pixels. - Set plot bottom border to - .RI <size> - pixels. -+.TP -+.IR "title=<title>" -+Set graph title to -+.RI <title> - .PP - .SH "EXAMPLES" - .PP - .br - Example HTML IMG TAG: - .PP --<IMG SRC="rtgplot.cgi? t1=ifInOctets_2& t2=ifOutOctets_2& iid=4& --begin=1046754000& end=1046840399& units=bits/s& factor=8& scalex=yes"> -+<IMG SRC="rtgplot.cgi? t1=ifInOctets_2& t1_name=Input& t2=ifOutOctets_2& -+t2_name=Output& iid=4& begin=1046754000& end=1046840399& units=bits/s& -+factor=8& scalex=yes& title=Bandwidth+Graph"> - .PP - will plot two lines from the MySQL tables ifInOctets_2 and ifOutOctets_2 - corresponding to interface 4 on router 2 for the time span 1046754000 to -@@ -97,6 +103,8 @@ corresponding to interface 4 on router 2 - second; the units argument is displayed as the Y-axis label on the plot. - The scalex argument auto-adjusts the X time axis according to the available - data samples rather than according to the actual time span given. -+It will have a graph title of "Bandwidth Graph" and legend tags of "Input" -+and "Output" for t1 and t2 respectively. - .PP - Draw a 95th percentile line: - .PP diff --git a/net/rtg/files/patch-man_rtgpoll.1 b/net/rtg/files/patch-man_rtgpoll.1 deleted file mode 100644 index 1c15b64d830c..000000000000 --- a/net/rtg/files/patch-man_rtgpoll.1 +++ /dev/null @@ -1,12 +0,0 @@ ---- man/rtgpoll.1.orig 2003-09-24 17:26:57 UTC -+++ man/rtgpoll.1 -@@ -31,6 +31,9 @@ Disable database inserts. - .IR "\-m" - Skip checking for multiple instances. - .TP -+.IR "\-p file" -+PID file. Process ID file. -+.TP - .IR "\-z" - Force database insertion of zero deltas. - .TP diff --git a/net/rtg/files/patch-src_rtg.h b/net/rtg/files/patch-src_rtg.h deleted file mode 100644 index 967eb9e85b33..000000000000 --- a/net/rtg/files/patch-src_rtg.h +++ /dev/null @@ -1,33 +0,0 @@ ---- src/rtg.h.orig 2003-09-25 15:56:04 UTC -+++ src/rtg.h -@@ -40,12 +40,10 @@ - #define DEFAULT_DB_DB "rtg" - #define DEFAULT_DB_USER "snmp" - #define DEFAULT_DB_PASS "rtgdefault" --#define DEFAULT_SNMP_VER 1 -+#define DEFAULT_SNMP_VER 2 - #define DEFAULT_SNMP_PORT 161 -+#define DEFAULT_PIDFILE "/tmp/rtgpoll.pid" - --/* PID File */ --#define PIDFILE "/tmp/rtgpoll.pid" -- - #define STAT_DESCRIP_ERROR 99 - #define HASHSIZE 5000 - -@@ -175,10 +173,10 @@ int add_hash_entry(target_t *); - int hash_target_file(char *); - - /* Globals */ --config_t set; --int lock; --int waiting; --char config_paths[CONFIG_PATHS][BUFSIZE]; --hash_t hash; -+extern config_t set; -+extern int lock; -+extern int waiting; -+extern char config_paths[CONFIG_PATHS][BUFSIZE]; -+extern hash_t hash; - - #endif /* not _RTG_H_ */ diff --git a/net/rtg/files/patch-src_rtgplot.c b/net/rtg/files/patch-src_rtgplot.c deleted file mode 100644 index 458bedb7bb71..000000000000 --- a/net/rtg/files/patch-src_rtgplot.c +++ /dev/null @@ -1,84 +0,0 @@ ---- src/rtgplot.c.orig 2003-10-02 15:27:52 UTC -+++ src/rtgplot.c -@@ -54,6 +54,9 @@ - #include "rtgplot.h" - #include "cgi.h" - -+config_t set; -+char config_paths[CONFIG_PATHS][BUFSIZE]; -+ - /* dfp is a debug file pointer. Points to stderr unless debug=level is set */ - FILE *dfp = NULL; - -@@ -221,7 +224,10 @@ int main(int argc, char **argv) { - plot_line(data[i][j], &img, &graph, colors->shade, TRUE); - else - plot_line(data[i][j], &img, &graph, colors->shade, FALSE); -- snprintf(intname, sizeof(intname), "%s%d", arguments.table[i], arguments.iid[j]); -+ if (arguments.tablename[i]) -+ snprintf(intname, sizeof(intname), "%s", arguments.tablename[i]); -+ else -+ snprintf(intname, sizeof(intname), "%s%d", arguments.table[i], arguments.iid[j]); - plot_legend(&img, rate[i][j], &graph, colors->shade, intname, offset); - offset++; - } -@@ -629,15 +635,15 @@ void plot_legend(gdImagePtr * img, rate_t rate, graph_ - if (set.verbose >= HIGH) - fprintf(dfp, "Plotting legend (%s).\n", __FUNCTION__); - -- gdImageFilledRectangle(*img, BORDER_L, -+ gdImageFilledRectangle(*img, BORDER_L - 10, - BORDER_T + graph->image.yplot_area + 37 + 10 * offset, -- BORDER_L + 7, BORDER_T + graph->image.yplot_area + 44 + 10 * offset, color); -- gdImageRectangle(*img, BORDER_L, BORDER_T + graph->image.yplot_area + 37 + 10 * offset, -- BORDER_L + 7, BORDER_T + graph->image.yplot_area + 44 + 10 * offset, -+ BORDER_L - 3, BORDER_T + graph->image.yplot_area + 44 + 10 * offset, color); -+ gdImageRectangle(*img, BORDER_L - 10, BORDER_T + graph->image.yplot_area + 37 + 10 * offset, -+ BORDER_L - 3, BORDER_T + graph->image.yplot_area + 44 + 10 * offset, - std_colors[black]); - -- if (strlen(interface) > 17) { -- interface[17] = '\0'; -+ if (strlen(interface) > 15) { -+ interface[15] = '\0'; - } - snprintf(string, sizeof(string), "%s", interface); - for (i = 0; i < (17 - strlen(interface)); i++) { -@@ -662,7 +668,7 @@ void plot_legend(gdImagePtr * img, rate_t rate, graph_ - units(rate.cur, cur), graph->units, - units((float)rate.total, total)); - } -- gdImageString(*img, gdFontSmall, BORDER_L + 10, -+ gdImageString(*img, gdFontSmall, BORDER_L, - BORDER_T + graph->image.yplot_area + 33 + (10 * offset), string, std_colors[black]); - } - -@@ -866,6 +872,13 @@ void plot_labels(gdImagePtr * img, graph_t * graph) { - title_offset = 1 - (0.01 * (strlen(VERSION) + strlen(COPYRIGHT) + 2)); - snprintf(string, sizeof(string), "%s %s", COPYRIGHT, VERSION); - gdImageString(*img, gdFontSmall, BORDER_L + (graph->image.xplot_area * title_offset), BORDER_T - 15, string, std_colors[black]); -+ -+ /* title */ -+ if (graph->titlestr) -+ { -+ snprintf(string, sizeof(string), "%s", graph->titlestr); -+ gdImageString(*img, gdFontMediumBold, BORDER_L + 5, BORDER_T - 16, string, std_colors[black]); -+ } - } - - -@@ -1342,10 +1355,14 @@ void parseWeb(arguments_t *arguments, graph_t *graph) - } - } - /* XXX REB - Warning: Deprecated, tN argument will go away in RTG 0.8 XXX */ -+ snprintf(var, sizeof(var), "title"); -+ graph->titlestr = cgiGetValue(cgiArg, var); - for (i = 0; i < MAXTABLES; i++) { - snprintf(var, sizeof(var), "t%d", i + 1); - if ((arguments->table[i] = cgiGetValue(cgiArg, var))) - arguments->tables_to_plot++; -+ snprintf(var, sizeof(var), "t%d_name", i + 1); -+ arguments->tablename[i] = cgiGetValue(cgiArg, var); - } - if ((graph->units = cgiGetValue(cgiArg, "units")) == NULL) { - graph->units = malloc(sizeof(DEFAULT_UNITS)); diff --git a/net/rtg/files/patch-src_rtgplot.h b/net/rtg/files/patch-src_rtgplot.h deleted file mode 100644 index dc027aae2a2e..000000000000 --- a/net/rtg/files/patch-src_rtgplot.h +++ /dev/null @@ -1,26 +0,0 @@ ---- src/rtgplot.h.orig 2003-09-24 14:43:39 UTC -+++ src/rtgplot.h -@@ -11,6 +11,7 @@ - - #include <gd.h> - #include <gdfonts.h> -+#include <gdfontmb.h> - #include <strings.h> - - #define XPLOT_AREA 500 -@@ -95,6 +96,7 @@ typedef struct graph_struct { - int scaley; - range_t range; - image_t image; -+ char *titlestr; - } graph_t; - - /* A linked list of colors that we iterate through each line */ -@@ -106,6 +108,7 @@ typedef struct color_struct { - - typedef struct arguments_struct { - char *table[MAXTABLES]; -+ char *tablename[MAXTABLES]; - int iid[MAXIIDS]; - int tables_to_plot; - int iids_to_plot; diff --git a/net/rtg/files/patch-src_rtgpoll.c b/net/rtg/files/patch-src_rtgpoll.c deleted file mode 100644 index 9ba66741d6f6..000000000000 --- a/net/rtg/files/patch-src_rtgpoll.c +++ /dev/null @@ -1,71 +0,0 @@ ---- src/rtgpoll.c.orig 2003-09-25 15:56:04 UTC -+++ src/rtgpoll.c -@@ -9,10 +9,13 @@ - #include "common.h" - #include "rtg.h" - -+char config_paths[CONFIG_PATHS][BUFSIZE]; -+ - /* Yes. Globals. */ - stats_t stats = - {PTHREAD_MUTEX_INITIALIZER, 0, 0, 0, 0, 0, 0, 0, 0, 0.0}; - char *target_file = NULL; -+char *pidfile = NULL; - target_t *current = NULL; - MYSQL mysql; - int entries = 0; -@@ -41,7 +44,7 @@ int main(int argc, char *argv[]) { - config_defaults(&set); - - /* Parse the command-line. */ -- while ((ch = getopt(argc, argv, "c:dhmt:vz")) != EOF) -+ while ((ch = getopt(argc, argv, "c:dhmp:t:vz")) != EOF) - switch ((char) ch) { - case 'c': - conf_file = optarg; -@@ -55,6 +58,9 @@ int main(int argc, char *argv[]) { - case 'm': - set.multiple++; - break; -+ case 'p': -+ pidfile = optarg; -+ break; - case 't': - target_file = optarg; - break; -@@ -66,6 +72,9 @@ int main(int argc, char *argv[]) { - break; - } - -+ if (!pidfile) -+ pidfile = DEFAULT_PIDFILE; -+ - if (set.verbose >= LOW) - printf("RTG version %s starting.\n", VERSION); - -@@ -78,7 +87,7 @@ int main(int argc, char *argv[]) { - sigaddset(&signal_set, SIGINT); - sigaddset(&signal_set, SIGQUIT); - if (!set.multiple) -- checkPID(PIDFILE); -+ checkPID(pidfile); - - if (pthread_sigmask(SIG_BLOCK, &signal_set, NULL) != 0) - printf("pthread_sigmask error\n"); -@@ -244,7 +253,7 @@ void *sig_handler(void *arg) - if (set.verbose >= LOW) - printf("Quiting: received signal %d.\n", sig_number); - rtg_dbdisconnect(&mysql); -- unlink(PIDFILE); -+ unlink(pidfile); - exit(1); - break; - } -@@ -259,6 +268,7 @@ void usage(char *prog) - printf("\nOptions:\n"); - printf(" -c <file> Specify configuration file\n"); - printf(" -d Disable database inserts\n"); -+ printf(" -p <file> Specify pid file (defaults to /tmp/rtgpoll.pid)\n"); - printf(" -t <file> Specify target file\n"); - printf(" -v Increase verbosity\n"); - printf(" -m Allow multiple instances\n"); diff --git a/net/rtg/files/patch-src_rtgsnmp.c b/net/rtg/files/patch-src_rtgsnmp.c deleted file mode 100644 index 46b28831e57a..000000000000 --- a/net/rtg/files/patch-src_rtgsnmp.c +++ /dev/null @@ -1,14 +0,0 @@ ---- src/rtgsnmp.c.orig 2003-09-25 18:23:35 UTC -+++ src/rtgsnmp.c -@@ -8,6 +8,11 @@ - #include "common.h" - #include "rtg.h" - -+config_t set; -+int lock; -+int waiting; -+hash_t hash; -+ - #ifdef OLD_UCD_SNMP - #include "asn1.h" - #include "snmp_api.h" diff --git a/net/rtg/files/patch-src_rtgutil.c b/net/rtg/files/patch-src_rtgutil.c deleted file mode 100644 index a430502355a8..000000000000 --- a/net/rtg/files/patch-src_rtgutil.c +++ /dev/null @@ -1,10 +0,0 @@ ---- src/rtgutil.c.orig 2018-04-02 23:03:54 UTC -+++ src/rtgutil.c -@@ -37,6 +37,7 @@ int read_rtg_config(char *file, config_t - else if (!strcasecmp(p1, "DB_Database")) strncpy(set->dbdb, p2, sizeof(set->dbdb)); - else if (!strcasecmp(p1, "DB_User")) strncpy(set->dbuser, p2, sizeof(set->dbuser)); - else if (!strcasecmp(p1, "DB_Pass")) strncpy(set->dbpass, p2, sizeof(set->dbpass)); -+ else if (!strcasecmp(p1, "Update_desc")) ; // no-op - - /* Long longs not ANSI C. If OS doesn't support atoll() use default. */ - else if (!strcasecmp(p1, "OutOfRange")) diff --git a/net/rtg/files/rtgpoll.in b/net/rtg/files/rtgpoll.in index 73c1d482ac57..0f695b5d85e2 100644 --- a/net/rtg/files/rtgpoll.in +++ b/net/rtg/files/rtgpoll.in @@ -21,10 +21,10 @@ name="rtgpoll" rcvar=rtgpoll_enable -cmd=%%PREFIX%%/bin/${name} -command="/usr/sbin/daemon" +start_precmd="${name}_prestart" +command="%%PREFIX%%/bin/${name}" -load_rc_config $name +load_rc_config ${name} : ${rtgpoll_enable="NO"} : ${rtgpoll_config="%%PREFIX%%/etc/rtg/rtg.conf"} @@ -33,19 +33,11 @@ load_rc_config $name : ${rtgpoll_user="rtg"} : ${rtgpoll_group="rtg"} -required_files="$rtgpoll_targets" +required_files="${rtgpoll_targets}" +command_args="-b -p ${rtgpoll_pidfile} -c ${rtgpoll_config} -t ${rtgpoll_targets}" -command_args="-f -p $rtgpoll_pidfile $cmd -c $rtgpoll_config -t $rtgpoll_targets" - -start_precmd="rtgpoll_prestart" - -rtgpoll_prestart() { - if [ ! -e "${rtgpoll_pidfile}" ]; then - touch $rtgpoll_pidfile - fi - - chown "${rtgpoll_user}:${rtgpoll_group}" "$rtgpoll_pidfile" - chmod 640 "$rtgpoll_pidfile" +rtgpoll_prestart() +{ chown -R "${rtgpoll_user}:${rtgpoll_group}" "%%PREFIX%%/etc/rtg" chmod -R u+rwX,g+rX "%%PREFIX%%/etc/rtg" } diff --git a/net/rtg/pkg-plist b/net/rtg/pkg-plist index a11f68c26ac3..0e82a2325258 100644 --- a/net/rtg/pkg-plist +++ b/net/rtg/pkg-plist @@ -4,13 +4,13 @@ bin/rtgplot bin/rtgpoll contrib/README contrib/rtgtargmkr-with-modules-0.2.tar.gz -%%ETCDIR%%/rtg.conf.sample -%%ETCDIR%%/rtgtargmkr.pl -%%ETCDIR%%/routers.sample -%%ETCDIR%%/createdb %%ETCDIR%%/BER.pm %%ETCDIR%%/SNMP_Session.pm %%ETCDIR%%/SNMP_util.pm +%%ETCDIR%%/createdb +@sample %%ETCDIR%%/routers.sample +@sample %%ETCDIR%%/rtg.conf.sample +%%ETCDIR%%/rtgtargmkr.pl include/common.h include/rtg.h include/rtgplot.h |