RTG is a flexible, scalable, high-performance SNMP statistics monitoring
system. It is designed for enterprises and service providers who need to
collect time-series SNMP data from a large number of targets quickly. All
collected data is inserted into a relational database that provides a common
interface for applications to generate complex queries and reports. RTG
includes utilities that generate configuration and target files, traffic
reports, 95th percentile reports and graphical data plots. These utilities may
be used to produce a web-based interface to the data.
The unique features of RTG are:
* Runs as a daemon, incurring no cron or kernel startup overhead
* Written entirely in C for speed, incurring no interpreter overhead
* Multi-threaded for asynchronous polling and database insertion
* Inserts data into a relational database where complex queries and reports
may be generated
* Performs no data averaging in order to support billing, etc.
* Can poll at sub-one-minute intervals
===> The following configuration options are available for rtg-0.7.5_2:
MYSQL=off: Pull MySQL server in as a dependency for local setups
WEB=off: Include PHP-based web client interface pre-requisites
===> Use 'make config' to modify these settings
databases/p5-DBD-mysql: Fix for MariaDB users
Add a new variable DBD_MYSQL, use that in *_DEPENDS and add mysql to USES
where required. DBD_MYSQL will automatically set the correct DBD dependency.
In cd16748194e2 databases/p5-DBD-mysql was updated to 5.x, in 5.x the
support for MariaDB was removed and only MySQL >= 8.0 is supported.
In the 4.x releases MariaDB is still supported, according to upstream 4.x
will still be supported for a while [1], so use that for now when we detect
that MYSQL_FLAVOUR is set to mariadb. databases/p5-DBD-mysql4 was added in
d95f49cb3b54.
DBD:MariaDB would be another alternative, but migrating to it might need
more analysis than just staying with the 4.x releases of p5-DBD-mysql. This
(Only the first 15 lines of the commit message are shown above )
*/*: Update WWW to use HTTPS for sourceforge.net projects
Homepage link is permanent redirected to its HTTPS counterpart
Issue reported by repology : https://repology.org/repository/freebsd/problems
Approved by: portmgr (blanket)
PR: 274888
*/*: Remove merged or non-existent USE_PHP directives
- Remove USE_PHP=hash which is available in default php installation of
all versions of php
* security/pear-Horde_Crypt_Blowfish: Remove OPTION MHASH
- Remove USE_PHP=json which is available in default php installation of
all versions of php
* devel/pear-PHPTAL: Remove OPTION JSON
* www/ilias: Remove OPTION SCORM2004
- Remove USE_PHP=mssql which is no longer available in php from php80
and later and has been replaced with sqlsrv module which is Windows
only
* www/codeigniter: Remove OPTION MSSQL
* www/moodle311: Remove OPTION MSSQL
* www/moodle39: Remove OPTION MSSQL
(Only the first 15 lines of the commit message are shown above )
Remove WWW entries moved into port Makefiles
Commit b7f05445c00f has added WWW entries to port Makefiles based on
WWW: lines in pkg-descr files.
This commit removes the WWW: lines of moved-over URLs from these
pkg-descr files.
Approved by: portmgr (tcberner)
Add WWW entries to port Makefiles
It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.
Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.
There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.
(Only the first 15 lines of the commit message are shown above )
net: remove 'Created by' lines
A big Thank You to the original contributors of these ports:
* <ports@c0decafe.net>
* Aaron Dalton <aaron@FreeBSD.org>
* Aaron Straup Cope <ascope@cpan.org>
* Aaron Zauner <az_mail@gmx.at>
* Adam Jette <jettea46@yahoo.com>
* Adam Weinberger <adamw@FreeBSD.org>
* Alan Eldridge <alane@geeksrus.net>
* Alex Bakhtin <Alex.Bakhtin@gmail.com>
* Alex Deiter <Alex.Deiter@Gmail.COM>
* Alex Dupre <ale@FreeBSD.org>
* Alex Dupre <sysadmin@alexdupre.com>
(Only the first 15 lines of the commit message are shown above )
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
(Only the first 15 lines of the commit message are shown above )
Patch createdb script to avoid race condition / file tampering
During the initialization net/rtg uses the /tmp/mysql.sql
and /tmp/rtg.sql to store the SQL commands executed in the
database with special user privileges.
Using well known files can lead to a race condition between
two process who uses the same file names and allow file
tampering by a malicious user.
This fix uses mktemp command to create temporary files
in a safe way
PR: 238262
Submitted by: rodrigo
Approved by: freebsd-ports@dan.me.uk (maintainer timeout)
MFH: 2019Q3
Fix net/rtg with modern perl and php
* Fix runtime PHP errors if short_opentag is disabled (default)
* Remove most PHP warnings/notices that go to error_log
* Fix HTML output to be valid
* Fix quoting of SQL objects
* Fix escaping of user-provided SQL data (potential sql injection)
* Widen fields in 95.php and 95.pl for interface and router names
* Fix warnings in perl modules in newer perl versions
* Fix createdb script to use CREATE USER/GRANT not manipulate user db directly
* Add "Update_desc" config entry to auto-update port descriptions from snmp
* Update default SNMP version to 2
PR: 227376
Submitted by: <freebsd-ports@dan.me.uk> (maintainer)
* Fix runtime PHP errors that stop the code working if short_opentag is disabled
(default!)
* Remove most PHP warnings/notices that go to error_log
* Convert patches to new format where needed
* Fix HTML output to be valid
* Fix quoting of SQL objects
* Fix escaping of user-provided SQL data (potential sql injection)
* Widen fields in 95.php and 95.pl for interface and router names
* Fix warnings in perl modules in newer perl versions
* Fix createdb script to use CREATE USER/GRANT not manipulate user db directly
* Add "Update_desc" config entry to auto-update port descriptions from snmp
* Update default SNMP version to 2
* Although this doesn't reference any CVE's, it does contain fixes for potential
security issues
PR: 227376
Submitted by: freebsd-ports@dan.me.uk (maintainer)
Reported by: freebsd-ports@dan.me.uk (maintainer)
Reviewed by: mfechner
Approved by: mentors (timeout), portmgr (timeout)
MFC after: 2 days
Differential Revision: https://reviews.freebsd.org/D17637
Patch based off of revision 434135
Fix configuration paths in CGIs and reports to include /usr/local/etc/rtg.
Affects common.php, reports.pl, and 95.pl. This will fix the CGIs to almost
work out of the box.
Improve rtgtargmkr.pl to skip unresponsive routers rather than dying.
Add USES=ssl
PR: 217108
Submitted by: andrew.fengler@scaleengine.com
Approved by: maintainer timeout (15 days)
Improve RTG port
Summary:
Add 'rtg' user and group in UIDs/GIDs.
Use daemon(8) to daemonize rtgpoll.
Add prestart commands to set correct permissions for RTG's files.
Reviewers: swills, allanjude, xmj, andrew.fengler_scaleengine.com,
#contributor_reviewers_ports, matthew
Reviewed By: #contributor_reviewers_ports, matthew
Subscribers: matthew, mat
Differential Revision: https://reviews.freebsd.org/D7486
Remove OSVERSION checks that do not make sense any more.
For example (${OSVERSION} >= 900000 && ${OSVERSION} < 900021) is always true,
as is (${OSVERSION} > 900002 || ${OSVERSION} < 900000 && ${OSVERSION} > 800107).
Regarding patches, when an EXTRA_PATCHES is no longer needed, I remove it, when
it is always needed, I renamed it, in one case, I merged two patches.
Differential Revision: https://reviews.freebsd.org/D2209
net category: Remove $PTHREAD_LIBS
openafs did not pass check-plist (pre-existing) so fixed and bumped.
Also, pkg-plist was sorted. mediatomb and spread also fail plist-checks
but they weren't fixed.
approved by: PTHREAD blanket
Remove indefinite articles and trailing periods from COMMENT, plus minor
COMMENT typos and surrounding whitespace fixes. A few Makefiles where not
included as they contain Latin-1 characters that break the Phabricator
workflow. Category N.
CR: D307
Approved by: portmgr (bapt)
- Update to use PHP mysqli extensions (as mysql extension is deprecated
these days)
- Fix runtime dependencies to pull in perl's DBI and DBD::mysql modules for
target maker.
- Add some options to pull in dependencies for mysql server and php web
modules if needed.
PR: 191276
Submitted by: Daniel Austin <freebsd-ports@dan.me.uk> (maintainer)
In the rc.d scripts, change assignments to rcvar to use the
literal name_enable wherever possible, and ${name}_enable
when it's not, to prepare for the demise of set_rcvar().
In cases where I had to hand-edit unusual instances also
modify formatting slightly to be more uniform (and in
some cases, correct). This includes adding some $FreeBSD$
tags, and most importantly moving rcvar= to right after
name= so it's clear that one is derived from the other.
- Use .sample for sample config so that upgrades dont overwrite
user-modified config files
- Added note to explain where/how to use rtgplot
- Added graph titles and friendly legend tags
- Modified rc script to load after mysql
PR: ports/148363
Submitted by: Daniel Austin MBCS <freebsd-ports AT dan.me.uk> (maintainer)
- Add rc.d script.
- Optimise db table creation with indexes.
- Add PID file option.
- Fix a few warnings in the Makefile.
- Assign maintainership to submitter.
PR: 145924
Submitted by: Daniel Austin <freebsd-ports@dan.me.uk>
Feature safe: yes
- Fix custom LOCALBASE build
- USE_MYSQL macro unless there is a reason to depend specifically on mysql41
- Use SF MASTER_SITES abbreviation
PR: 136678
Submitted by: Sahil Tandon <sahil@tandon.net>
Feature safe: yes
Say hello to the new "net-mgmt" category. There are probably more
ports that belong here than the ones I have identified and moved in
this, first, pass.
Approved in principle by: marcus
