SNMPc OnLine Version 12.10.8 June 11, 2018 Castle Rock Computing Saratoga, USA ============================================================================== CONTENTS This is the release notice for SNMPc OnLine, a web based network reporting engine for SNMPc Enterprise. 1. System/Software Requirements 2. Installation 3. Features 4. Components 5. Netflow 6. Syslog 7. Database Administration 8. Troubleshooting/Support 9. Configuration Options 10. Updates ============================================================================== 1. System/Software Requirements * Requires SNMPc 9.0 Enterprise Edition. * Requires Windows 2008R2 Server sp1, Windows 7 sp1, Windows 8, or 2012 Server (will not install on 95/98/ME/NT/2000/XP/2003/Vista). * Recommended to run on a 2Ghz+ dual core computer with at least 8GB memory, 100GB disk space, and XGA (1024x768) display. * Creating custom maps requires Microsoft Visio 2003 or newer. * Internet Explorer 9 browser recommended. Other browsers require SNMPc OnLine to use the SVGView.exe plug-in to display SNMPc map and Visio graphics. ============================================================================== 2. Installation The setup script will search the computer for your current SNMPc directory and will install the files in the same directory by default. It will install SNMPc OnLine export components, Apache web server (or integrate with an existing Apache or IIS installation) PHP web scripting engine, and Microsoft SQL Server 2012 Express Edition (SQL Express). Important: Please note that the Apache server is installed as a service. The Windows account you use to install SNMPc OnLine must have Administrator access in order to do this. The Apache server runs on TCP port 8080 by default. If you already have SQL server installed, we prefer using SQL user authentication to prevent permissions problems. ============================================================================== 3. Features The SNMPc OnLine system provides a dynamic web interface to your SNMPc databases and trend reports. Data is exported from SNMPc into the Microsoft SQL Server 2012 Express Edition (runtime version of SQL Server). SNMPc OnLine is compatible with IIS and Apache Web Servers. If no web server is present, Apache will be installed on port 8080 and configured for you. To access SNMPc OnLine, use the SNMPc OnLine menu item in the Tools menu in the SNMPc console, or the SNMPc Windows Start menu. A web browser will open and you will be prompted with a login screen. Your login is the same as your SNMPc Enterprise login. If you did not create a login, then the username is Administrator and no password is required. Note that after the initial installation, it may take several minutes for the export process to complete. You will not be able to log in until the user database has been exported. Report data will not be visible until after the first polling cycle. Once you log in, the first thing you should do is to click on the Help option at the top of the page. Browse through all the help topics to become familiar with the operation of SNMPc OnLine. We would also recommend that you read the "Getting Started" guide via the link on the login or help pages of SNMPc OnLine. You can view any table saved by SNMPc with this package, but special support has been added for some popular tables. These are Availability, Interface BPS, Interface Utilization, Cisco, Server CPU, and Server Disk Six. When creating a new Trend Report, these tables are listed at the top of the pull down "MIB Table" list. We recommend that you use these pre-defined reports as default. The custom dashboard display is one of the most powerful features of SNMPc OnLine. This allows you to group multiple report graphs, tables, log queries, and node queries on the same page. You can start creating these custom views by clicking on the "" link in each trend group. The Help topic sections on Custom View and Design provide more information. Other new features include the ability to do detailed node and log queries. SNMPc OnLine 12 introduces netflow capability. You must configure any devices to send flows to the SNMPc server. By default SNMPc OnLine listens on port 2055 for flow information. You can view total statistics for each host, or for each conversation matrix. ============================================================================== 4. Components This software consists of the following components: DBEX ---- DBEX.EXE is the SNMPc component that exports data from SNMPc Enterprise to the SQL server database. It is added to the SNMPc startup list and controlled the same manner as the rest of the SNMPc server tasks. If you don't see DBEX.EXE in the startup config list, you can add it manually with the following settings: Description: OnLine Export Service Window Name: SNMPc OnLine Export Service Program Name: dbex.exe Program Args: The web front end includes a calendar selection tool from the YUI development kit, Copyright © 2011 Yahoo! Inc. All rights reserved. MAPDRAW ------- MapDraw is a graphics tool for creating Map View Drawings that are associated with an SNMPc OnLine Map View. It allows you to create and maintain graphic Map Drawings representing your network devices. You use MapDraw to associate SNMPc Nodes to graphic shapes. You can then view dynamic status information from your network devices in the associated SNMPc OnLine Map View. In order to use MapDraw you must separately purchase Microsoft Visio 2003 or 2007 from a Microsoft application vendor. If using Visio 2003 please make sure you download and install the Visio2003SP2-KB887622-FullFile-ENU.exe update from www.microsoft.com to enhance visio performance. There are some command line options for using MapDraw with HTTPS servers. You can use the "-s" option to make a secure HTTPS connnection. If you are using a locally signed certificate, use "-sx" to ignore the certificate authority warnings. If you need a web server name instad of a numeric address to match the certificate, add "-aWWW.WEBSERVER.COM" to specify the web server name. Apache2 (Optional) ------------------ By default, this will be installed in the SNMPcOnLine\Apache2 directory. The installation will try to install Apache2 as a service with automatic start up. If you do not see it listed in the service manager, you can try running "Apache2\bin\apache.exe -k install" on the command line to install the service. Make sure you are logged into Windows as an administrator user. Once running, you should see "Apache.exe" in the windows task list. It runs on TCP port 8080. Please see the license.txt file in the Apache2 directory for more information. PHP --- The PHP web scripting system is installed under the SNMPcOnLine\PHP directory. It is only used by the web server to view the script files and you should not need to perform any manual configuration. Please see the license.txt file in the PHP directory for more information. SVGViewer --------- SNMPc OnLine uses the Adobe SVG graphics format to display SNMPc maps and Visio map graphics. SVG is fully implemented in Internet Explorer v9 and above. On earlier Internet Explorer versions or other browsers SNMPc OnLine must use the Adobe SVGViewer plugin to display SVG format graphics. The SVGViewer plugin is normally downloaded from Adobe's website. If you are using a browser that requires SVGViewer on an intranet with no internet access, you can choose to host the viewer locally. To do this, you will first need to fill out the distribution license at Adobe (http://www.adobe.com/svg/svgdistribute.html) which allows for distribution on an intranet network (section 2.1.1(a)). Once you have agreed to this license, edit the \Windows\PHP.INI file and add the line "SNMPc.SVGURL=/SNMPcOnLine/SVGVIEW.EXE" to the [SNMPc] section. The embedded object in the SNMPc OnLine Visio maps will refer to this url to download the plugin. SQL Express 2012 ---------------- SQL Express is a runtime version of Microsoft's SQL Server. It is installed as a service under the "SQL Server(SNMPCONLINE)" name. If you already have other SQL server instances installed, they will remain separate. You can download the SQL Server Management Studio Express version from Microsoft to manage your SNMPc OnLine, and other SQL Express databases: http://www.microsoft.com/downloads/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&displayLang=en If that link is no longer active, you can do a search for "Microsoft SQL Server 2012 Management Studio Express" on the Microsoft web site. NTOP ---- Ntop is an open source Netflow collector. It is automatically started and stopped by the SNMPc OnLine export service. All data is saved to the same SQL Database server. With the SQL Express server, the netflow data is saved to a separate ATR_NETFLOW database (can be changed with the SNMPc.dbnetflow value in the PHP.INI file). If you install with a true SQL server, the netflow tables are saved in the main SNMPCONLINE database. SYSLOG -------- SNMPc OnLine includes a Syslog agent service that receives Syslog messages and logs them to the SNMPc OnLine database, optionally forwarding some messages to the SNMPc Server as SNMP traps. See the Syslog section below for more information. ============================================================================== 5. Netflow SNMPc OnLine version includes support for netflow v5, v9, and IPFIX based on a version of NTOP modified to save data to an SQL database. Ntop is an open source Netflow collector. Since NTOP is licensed under the GNU General Public License, the modified source code is included in the install in the SNMPcOnLine\NtopSrc directory. For more information on NTOP, see the documentation in the NtopSrc directory, or visit http://www.ntop.org/. The NTOP project itself includes many other open source libraries. These include: * GD is an open source code library for the dynamic creation of images by programmers. GD is written in C, and "wrappers" are available for Perl, PHP and other languages. GD creates PNG, JPEG and GIF images, among other formats. GD is commonly used to generate charts, graphics, thumbnails, and most anything else, on the fly. For more information see the NtopSrc\legacy\gd directory or visit http://www.libgd.org/. * GeoIP from MaxMind provides a free IP to coutry database map for device location services. For more information, see the NtopSrc\legacy\GeoIP directory or visit http://www.maxmind.com/app/c * LibPNG creates dynamic PNG images. It supports almost all PNG features, is extensible, and has been extensively tested for over 15 years. The home site for development versions is http://libpng.sourceforge.net/, or see the NtopSrc\legacy\libpng directory. * Zlib is designed to be a free, general-purpose, legally unencumbered -- that is, not covered by any patents -- lossless data-compression library for use on virtually any computer hardware and operating system. The zlib data format is itself portable across platforms. Zlib was written by Jean-loup Gailly (compression) and Mark Adler (decompression). See http://www.zlib.net/ or the NtopSrc\legacy\Zlib directory for more information. You can define a default protocol list that will be used the first time the program starts. To do this, add a "DefProtocol=" line to the [ATR] section of the SNMPC.INI file. The OnLine export service needs to be restarted after making this change. The value of this setting is in the format: AppName=Port[|][|-][,AppName=...][...] For example, the list for FTP, HTTP, and NetBios would look like: FTP=20-21,HTTP=80|443,NetBios=137-139|445 ============================================================================== 6. Syslog Support SNMPc OnLine includes a Syslog receiver agent program that sends syslog messages directly to the SNMPc OnLine SQL database. These messages can be viewed under the Syslog subtree in the SNMPc OnLine selection area. As these messages are received they can also be transmitted to the SNMPc server as SNMPc traps so that you can also view them in the SNMPc event log and perform actions using SNMPc event filters. SNMPc OnLine will forward any syslog messages as traps if there is an associated SNMPc event filter that would match that message. By default only messages above and including Syslog "Warning" level are sent to SNMPc. Note that Syslog sources are capable of generating a very large amount of traffic that could overwhelm the snmpc event log. Therefore we recommend that you do not add any event filters in SNMPc to intercept Syslog levels less than "Warning". ============================================================================== 7. SNMPc OnLine Database Administration SNMPc OnLine uses Microsoft's SQL Server 2012 Express for its database storage needs. Express is a scaled down version of Microsoft's SQL Server with limited database size and processing ability. Each Express database can only grow up to 10GB. SNMPc OnLine creates multiple databases, one for general data named "SNMPcOnLine2012", and one for each report being saved. This is to provide extended storage space for the reports over the Express version. If Express' 10GB per database limit is too small, or running on a single CPU is causing too high a processor load, SNMPc OnLine can be used with a separate Microsoft SQL Server (2000 or above). This must be done at install time, and is a selection option. We recommend using SQL user authentication rather than Windows Authentication to prevent permissions problems with the SNMPc OnLine export service and web server. If you chose to install SNMPc OnLine over an existing SQL server, SNMPc OnLine stores all data tables in the same database to make maintenance easier. At some point, you may wish to migrate an SNMPc OnLine installation with the default SQL Express database to a true SQL server. The steps involved are: 1) Do a backup in SNMPc OnLine where it is currently installed. Copy all the *.BKP files to a directory on the new SQL server. 2) Stop the SNMPc OnLine export service. 3) Edit the \Windows\PHP.INI file on the SNMPc computer and set the "SNMPc.dbserver", "SNMPc.dbpassword", and "SNMPc.dbuser" values to the server and login credentials on the new server. There won't be a "SNMPc.dbpassword" entry in the INI file already since the plaintext password is encrypted into dbpasswordenc when it is read out of the file. The same will happen with the new value you set when you start up the export service again. If you are using windows authentication, you will need to use the dbuser and dbpassword settings blank, and change the account the SNMPc OnLine export service runs under to an account with db access on the SQL server. Otherwise, use the SQL account and password to use on a mixed mode authentication setup. The user must have database creation permissions. 4) Start up the OnLine Export service. It will create new databases on the new server. 5) Log into OnLine, go to the Config page, type in the directory where you copied the files in #1 (drive directory name is local to the SQL server), and click restore. If you don't have a lot of data saved, and don't want to go through the trouble of copying the data, uninstalling and reinstalling OnLine would be easier. At install time, you can choose to use an external SQL server. It will also make DB administration easier as this install method stores all report data in the single SNMPCONLINE database (the default is to save each report in a separate database to give more storage on an Express server). There is no way to migrate a multiple database install into a single database configuration. ============================================================================== 8. Troubleshooting In addition to SNMPc Enterprise, three components must be running in order for SNMPc OnLine to be operational. These components are the SNMPc OnLine Export Service (DBEX.EXE), SQL Server (SNMPCONLINE instance), and your web server. If you cannot view the web page, you must first determine if it is a problem with the web server or a problem with the scripting mechanism. There are two test documents in the SNMPc OnLine folder, TEST.HTM and TEST.PHP4. First try viewing "http://127.0.0.1/SNMPcOnLine/test.htm" from the same computer that SNMPc OnLine is running on. If you installed SNMPc OnLine with Apache web server, you will need to include port ":8080" in the address. If you cannot view this test page, check to make sure the IIS "World Wide Web Publishing" or "Apache2" service exists and is running. If you are running firewall software on the computer, make sure port 80 (or 8080 for Apache) is open. If you can view the TEST.HTM document, but TEST.PHP4 prints the message "PHP is not properly integrated into your web server", then as the message says, your web server is not processing the document using PHP. If you are using IIS, bring up the IIS management console, find the SNMPc OnLine virtual directory, right click on it, and bring up the properties. Click on the "Configuration..." button to view the application mappings. There should be an entry in here for the ".php4" extension. If you are using Apache, edit the HTTPD.CONF file and look for an "AddType" entry that maps the .php4 extension to the "application/x-httpd-php". There should also be an "AddHandler" line that runs PHP.EXE for any "application/x-httpd-php" document. You may also receive a "Database Error" when trying to log into SNMPc OnLine. Usually this is a permissions problem. By default SNMPc Online installs SQL Express using an SA account. If you've changed SNMPc OnLine to point to an external SQL server, note that the account use by the web server (IIS anonymous access user or the user the Apache2 service runs under) must have access to the database. Also make sure that the network protocols are enabled. With SQL Express, go to the Windows start menu, and under SQL Server 2012->Configuration Tools, run the sever configuration manager. Click on "Protocols for SNMPCONLINE", and make sure the Shared Memory and Named Pipes protocols are enabled. If you are connecting to a remote server via TCP, make sure the TCP/IP service is enabled and that it is listening to TCP port 1433 on all addresses. The "Database Error" screen can also appear if the SQL Server MSSQL$SNMPCONLINE service is not started. Open the Windows service manager and make sure the service is started and set to automatic startup. See the section above on database adminsitration for more information on what could go wrong. If you see the login prompt in your browser, but you cannot log in with your SNMPc credentials, that means that the data (including the user database) is not being transferred from the SNMPc server into the SNMPc OnLine database. The program that does this is the SNMPc OnLine Export Service (DBEX.EXE). Check the windows task manager or SNMPc startup configuration screen to make sure this program is running. If it is not, try restarting it. If it does not start and you don't see any error messages explaining why, you need to make sure the App Paths setting in the registry is not pointing to the wrong place. Open up the registry editor and go to: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths If there is a DBEX.EXE entry in this key, you need to either delete it, or edit the path value to point to the directory where DBEX.EXE is installed (usually the SNMPc Network Manager directory). If the entry is already missing, then this is not the problem. Note that the MapDraw program included in SNMPc OnLine requires Microsoft's Visio application. If you are using Visio 2003 and notice poor performance, go to Microsoft's website and download the Visio2003SP2-KB887622-FullFile-ENU.exe patch. If you are having problems viewing the Visio maps in SVG format in your browser, read about the SVG plugin in the SVGViewer section of this document. Note that the SVG implementations in Opera and Firefox are not complete. We recommend configuring them to use the Adobe plug-in rather than native SVG support. If you have followed all the suggestions here and the system is still not working, please contact our support department at support@castlerock.com. Include a description of the problem you are experiencing, and the steps you have already taken. ============================================================================== 9. Configuration Options There are several configuration options that can change the way the OnLine Export Service works, but are not accessible through the GUI. Changing any of these requires a restart of the service to pick up the new settings. Some that are used only by the OnLine Export service are kept in the SNMPC.INI file in the SNMPc directory, wheras others that are shared by the export service and the web scripts are kept in the PHP.INI file, usually in the \Windows directory. ---------------------------------------------- \Program Files\SNMPc Network Manager\SNMPC.INI ---------------------------------------------- [ATR] ImportOffset= ; Number of seconds to delay requested data to handle ; time differences on remote pollers, and bursts of ; data writen by the polling agent. For example, if ; a remote poller's clock was 2 minutes behind the ; server and the export service is requesting data every ; 5 minutes and had no offset, the last two minutes of ; data would not have been saved yet and would be ; skipped for each 5 minute interval. The default is ; 60 seconds. DbexHist32Timeout= ; Number of seconds given to the history poller service ; to send each batch of data. Data is requested by the ; server in 5 minute intervals. Defaults to 300 ; seconds. Setting this longer in a situation where the ; poller is not able to send the data quick enough on a ; regular basis will cause the export service to get ; behind, then start dropping data again. Only set this ; when the data load is bursty, i.e. lots of hourly ; reports that will only take longer occasionally. [FlowExport] MaxBufSize=102400 ; Maximum bytes to send in each chunk MaxDelay=60 ; Maximum amount of time in seconds ; to wait between chunks BusyTimeout=10 ; Maximum amount of time in seconds to ; wait for data to be sent RollUp=300 ; Wait to combine similar flows to reduce ; the amount of data forwarded, zero ; disables roll-up and sends raw packets ---------------------------------------------- \Windows\PHP.INI ---------------------------------------------- [SNMPc] SNMPc.dbtimeout= ; SQL server database timeout seconds. Defaults to 300. SNMPc.SVGURL= ; The URL for the SVGViewer plugin. See the SVGViewer ; information in the Components section of this file for ; details SNMPc.bcp= ; The path of the BCP batch SQL import tool. The OnLine ; export tool will try to locate this autmatically on ; startup when the value is blank. If BCP.EXE is not ; found in the Windows path environment variable, you ; can set this value manually. If you want to force ; individual SQL inserts instead of using the batch ; tool, set this value to "no". SNMPc.localtime= ; Set this value to "yes" to format time information in ; SQL operations to use the local date format configured ; in Windows. Otherwise OnLine uses a universal ; "YYYY-MM-DD HH:MM:SS" format (ISO 8601). SNMPc.dbnetflow= ; Database name to use for Netflow data. Defaults to ; ATR_NETFLOW ============================================================================== The MapDraw program has command line options that can be used. You can supply an IP address by adding "-a1.2.3.4", but note that it still saves the Visio files locally so this should only be used if the loopback address is not working for some reason. If your web server connection requires a secure connection, add "-s" on the command line to use SSL (HTTPS). If you are using a self signed certificate, it would normally be rejected, but you can use "-sx" instead to ignore certificate problems. 10. Updates Version 12.10.8, Jun 11, 2018 ============================================================================== Problems Fixed in Version 12.10.7 --------------------------------- * Geographical map licensing update * Some entries missing from log control * Map view incompatible with some older versions of browsers * Printed/emailed reports not rendering correctly * Problems exporting more than 512 reports Version 12.10.7, Feb 28, 2018 ============================================================================== Problems Fixed in Version 12.10.7 --------------------------------- * Geographical map licensing update * Potential long delay while synchronizing log at startup Version 12.10.6, Jan 8, 2018 ============================================================================== New Features in Version 12.10.6 ------------------------------- * PHP and Apache updated to 5.6.33 and 2.2.34 Problems Fixed in Version 12.10.6 --------------------------------- * Syslog empty message causing display problem * Restricted user log view display problem * Updated map tile caching routine Version 12.10.5, Aug 11, 2017 ============================================================================== Problems Fixed in Version 12.10.5 --------------------------------- * Maps in OnLine don't render the same as SNMPc * Log display page slow with large database * Charset support for new map and log controls * Syslog service doesn't remove itself on uninstall Version 12.10.4, May 10, 2017 ============================================================================== Problems Fixed in Version 12.10.4 --------------------------------- * Syslog events not shown for devices not in SNMPc map * Bus network lables drawn in wrong location in map views * Export service hanging while sending scheduled emails * Update install issues * Documentation changes Version 12.10.3, Apr 28, 2017 ============================================================================== Problems Fixed in Version 12.10.3 --------------------------------- * Install missing prerequisites Version 12.10.2, Apr 21, 2017 ============================================================================== Problems Fixed in Version 12.10.2 --------------------------------- * Install missing files Version 12.10.1, Apr 14, 2017 ============================================================================== Problems Fixed in Version 12.10.1 --------------------------------- * Automatic time zone calculation causes selected times to be wrong Version 12.10.0, Feb 15, 2017 ============================================================================== New Features in Version 12.10.0 -------------------------------- * New map control includes support for geographical map server data * New log control for instant browsing through log * Display stretches to width of browser, dashboards can stretch to full height * Console view dashboard contains map and log like SNMPc windows console * Updated to PHP 5.4.45 and SQL 2012 Express with 10GB limit (for new installs) Problems Fixed in Version 12.10.0 --------------------------------- * Time zone problem affects log display, emailed data, and custom date selection * Automatic page refresh can change map subnet selection * Support for TLS in email * Cisco PIX events crashing syslog server * 15 character limit on SQL server passwords * Rounding error in graph display for small maximum values * Syslog server showing maintenance messages as errors * Custom date selection doesn't look the same as other calendar selections * Missing bitmaps from custom calendar tool * Duplicate data columns in CSV export of OnLine tabluar data * Tab separated XLS export change to more compatible CSV comma separation * Increased reliability of OnLine export service * User map restrictions to non top level subnets not working * Visio 2013 not supported * Log summary view not sorted * Added submit button to custom date selection * Syslog error about MIB filters when SNMPc server recompiles MIB Version 12.1.9, Jan 21, 2016 ============================================================================== Problems Fixed in Version 12.1.9 ---------------------------------- * Missing prerequisites added to install Version 12.1.8, Nov 20, 2015 ============================================================================== Problems Fixed in Version 12.1.8 ---------------------------------- * Compatibility with Visio 2013 * Updated to Apache 2.2.29 and PHP 5.4.35 * Automatic emails not sent with "Default" time selection * Transaction log growing too large in Syslog database * Data not showing up in sorted report tables Version 12.1.7, Sep 24, 2014 ============================================================================== Problems Fixed in Version 12.1.7 ---------------------------------- * OnLine export SQL connection timing out during long backup or restore * Syslog display pagination not working correctly * Summary page doesn't show old availability statistics Version 12.1.6, Aug 11, 2014 ============================================================================== Problems Fixed in Version 12.1.6 ---------------------------------- * OnLine adds too many example nodes to the OnLine demo node group * Links on summary page not clicking through to correct location * Node group based views not working * Old syslog*.log files not removed when syslog service stopped * Multicast selection shown for regular interface table * Forced retention of netflow data ("keep at least") not working Version 12.1.5, May 15, 2014 ============================================================================== Problems Fixed in Version 12.1.5 ---------------------------------- * Syslog events not displayed for SQL express installs * Some log view queries were taking twice as long as necessary * Map text list not sorting correctly and not using number of lines selected * SQL Express database size check doesn't know about 10GB limit for 2008R2+ * Optimized trend data sorting and export routine * Syslog service generates license errors Version 12.1.4, April 4, 2014 ============================================================================== Problems Fixed in Version 12.1.4 ---------------------------------- * SNMPc OnLine export daily events not executed Version 12.1.3, Mar 11, 2014 ============================================================================== Problems Fixed in Version 12.1.3 ---------------------------------- * Shows shortcut icons in netflow probe list * Custom date selection not working * Ampersands in text objects cause SVG map errors * User map restrictions not applied to netflow probe list and syslog views * Syslog data not shown for single (external) database installs Version 12.1.2, Jan 27, 2014 ============================================================================== Problems Fixed in Version 12.1.2 ---------------------------------- * Visio map objects don't click through to node summary * Update not checking correct SNMPc version Version 12.1.1, Jan 14, 2014 ============================================================================== Problems Fixed in Version 12.1.1 ---------------------------------- * Memory leaks in Netflow NTOP collector * Old netflow condensed data not deleted * Problem with initial server log scan on DBEX startup * Trusted_Connection required in syslog ODBC DSN * Erroneous SQL connection & alarm thread error messages from syslog * Added memory trace to NTOP to find memory usage problems * Syslog alarm thread error messages * Error when Syslog can't open event filters before SNMPc server starts * Syslog won't connect to SQL when using Windows authentication Version 12.1.0, Nov 11, 2013 ============================================================================== New Features in Version 12.1.0 -------------------------------- * SNMPc OnLine included with SNMPc Network Manager * Syslog message monitoring * Search for user attributes in map filter * Multicast reports Problems Fixed in Version 12.1.0 ---------------------------------- * Can't set default page for Administrator user * Graphical map display now works with all SVG compatible browsers, doesn't require Adobe plug-in for IE9 and above * Backup directory not saved * Apache and PHP versions updated (2.2.25 and 5.3.27) * Custom calendar selection not working for different date formats * OnLine export SQL server connection going dead Version 12.0.6, Oct 31, 2013 ============================================================================== New Features in Version 12.0.6 ------------------------------- * Fixed Licensing Issue Version 12.0.5, Mar 20, 2013 ============================================================================== New Features in Version 12.0.5 ------------------------------- * Windows 8 support Problems Fixed in Version 12.0.5 -------------------------------- * Last packet check in Netflow config page too slow * NTOP crash when deleting a large number of interfaces * Interface report display problem * Long variable names show no data in generic report view * NetFlow collector crash with too many interfaces * Reindex flow table for performance * Application list not showing * Blank probe interface names displayed * Javascript error in NetFlow config page * Upate install not removing old php_mssql extension * Null probes added to list and old interfaces not deleted Version 12.0.4, Oct 1, 2012 ============================================================================== New Features in Version 12.0.4 ------------------------------- * Fixed pre-requisite install for PHP * Observer user level restriction ignored for node information * Did not save data for addition NetFlow/sFlow listening ports * Emailed dashboard generates error Version 12.0.3, Sep 17, 2012 ============================================================================== New Features in Version 12.0.3 ------------------------------- * Flow Export service compresses flow information for a given time interval. Set "Rollup=300" in the [FlowExport] section of the SNMPC.INI file to define the interval to use. The value is in seconds, with a default of 300. Version 12.0.2, Aug 4, 2012 ============================================================================== New Features in Version 12.0.2 ------------------------------- * Updated PHP to version 5.3.15 * Custom multicast trend report pages * Ntop can forward flow traffic from domain slaves to master (requires SNMPc versions 8.0.7 or above) Problems Fixed in Version 12.0.2 -------------------------------- * Email authentication with login account not working * Email for NetFlow pages not working * Shows temporary SQL autostart condition as error * sFlow interfaces not showing up * Crash on NTOP startup Version 12.0.1, June 27, 2012 ============================================================================== New Features in Version 12.0.1 ------------------------------- * Added interface total counters * Collapsible sections in the netflow summary page Problems Fixed in Version 12.0.1 -------------------------------- * Wasn't deleting old data on schedule * Email function didn't use AuthLogin setting * Interface number wrong for v5 flows v2012 Version 12.0.0 beta5, June 7, 2012 ============================================================================== New Features in Version 12.0.0 beta5 ------------------------------------ * No more global probe profiles; probes and interfaces are added to list as they are discovered * Support for up to 500 interfaces * NetFlow data saved to SQL server with batch BCP data transfer * Errors in NetFlow are shown in SNMPc log file * Pre-define (only read on first execution) NetFlow protocol list with SNMPc.DefProtocols in [SNMPc] section of PHP.INI. * Selection to save number of days of data rather than size * Custom date range selection in calendar Problems Fixed in Version 12.0.0 beta5 -------------------------------------- * Database restore changed from LOAD to RESTORE for SQL 2012 compatibility * Check to verify NTOP is executing with heartbeat * Time for condensed NetFlow packets not accurate * Closed NetFlow service listening port * Web can't use SQL passwords over 20 chararacters, install checks length * SQL server selection in InstallSheild doesn't work over Windows 2008, changed to static version which doesn't allow browsing * Changed custom calendar selection to use scripts locally * Changing dashboard options would generate internal server error (500) * Dashboard doesn't show graph data with "Current" calendar selection * Problem with user subnet restriction check * Fix for retrieving data with SNMPc 8.0.5+ pollers * Batch export not working with database name other than SNMPCONLINE * Auto-creation of OnLine reports not done after restore or map reset v2012 Version 12.0.0 beta4, Mar 7, 2012 ============================================================================== New Features in Version 12.0.0 beta4 ------------------------------------ * NetFlow statistics reported on a per interface basis v2012 Version 12.0.0 beta2, Jul 25, 2011 ============================================================================== New Features in Version 12.0.0 beta2 ------------------------------------ * Netflow & Sflow data collection Problems Fixed in Version 12.0.0 beta2 -------------------------------------- * Can't send bandwidth detail or generic report pages in email * Support for Visio 2010 * DBEX crash for when receiving data after connection timed out * DBEX schedule timer stopping * Current values for gauge variables not shoing up in table list * View restrictions not filtering out subnets in log filter * Confusion with .0 instances treated as number 0 * Sorting with two criterea in dashboard frame * Missing variables in mixed tables with expressions and raw variables v2009 Version 9.0.8, October 30, 2010 ============================================================================== Problems Fixed in Version 9.0.8 ------------------------------- * Regional date format problems in SQL * Problems with remote pollers timing out while sending data * Automatic daily backups not working * Shortcuts moving back time selection * Added "-s" command line option to mapdraw to accept locally signed certificates * Performance for generic report graph too slow for report group/all node reports * Excel exports truncated at 1000 lines v2009 Version 9.0.7, June 14, 2010 ============================================================================== New Features in Version 9.0.7 ------------------------------- * Support for text objects in map view Problems Fixed in Version 9.0.7 ------------------------------- * Scheduled emails sometimes sent twice * Prints garbage attributes in node summary (network link info) * Wrong MFC80 redistributable for x64 install v2009 Version 9.0.6, June 2, 2010 ============================================================================== Problems Fixed in Version 9.0.6 ------------------------------- * Updated Visual Studio redistributable package in install v2009 Version 9.0.5, May 28, 2010 ============================================================================== New Features in Version 9.0.5 ----------------------------- * SNMPc OnLine can save daily backups along with SNMPc. You can turn on this feature in the SNMPc OnLine Config page. You must be running with an SQL server on the same computer as SNMPc, and it must have permission to write to the SNMPc backup directory. Only the backups are done automatically. If you do a restore, you will need to manually restore the files in OnLine. * Goto node types exported to OnLine * Ability to associate network objects with MapDraw Visio objects Problems Fixed in Version 9.0.5 ------------------------------- * Character set problems in SNMPc graphic maps * Problems with 64 bit interface tables * Divide by zero in interface error reporting * System uptime wrong in node summary * Email images don't show up when sent through Exchange server * Old values were not remove from current value table * Problem calculating first day of calendar after daylight savings change * Instances with duplicate numeric values (e.g. .1 and .10) ignored * CSV values exported from graph slightly lower than actual values * It was possible to see nodes outside of restricted subnet from report view v2009 Version 9.0.4, Nov 5, 2009 ============================================================================== New Features in Version 9.0.4 ----------------------------- * PHP script engine updated to 5.2.11 * Will display 64 bit interface table CRIfEntry64 reports from SNMPc 7.2.1. This is useful for interfaces that wrap the standard 32 bit counter faster than the poll interval of the report (around 500mbit/s for 1 minute reports, 100mbs/s for 5 minute reports, etc). The STANDARD.MIB file in 7.2.1 and up of SNMPc includes a table named CRIfEntry64. You can add it to the list of selectable reports in SNMPc by editing the SNMPC.INI file and adding the following line in the [ReportProfiles] section: RPT##=OnLine BPS 64bit Interface,CRATR64-MIB|CRIfEntry64 Replace ## with the next sequential number of the entries in the section. There are some limitations to the use of this table: - You must be polling the node with SNMPv2c or SNMPv3, 64 bit counters are not supported in the v1 protocol - Cisco devices do not report 64bit counter information for interfaces slower than 100mb - Since the 32 and 64 bit versions use the same variable names, you cannot save reports for both tables for the same device. Problems Fixed in Version 9.0.4 ------------------------------- * Install problem getting existing PHP version in "Program Files" directory * Install problem configuring PHP with existing SQL server * Data conversion fails if SNMPc sever parameters altered, dbex crashes * Current type displayed in log views * Memory leak with ping nodes in disk/interface group reports * 64 bit program files directory with (x86) causes PHP.INI parse problems * Crash in online export service with nodes with blank names * Drive instance names not saved * Reduced database access to keep transaction logs smaller * External SQL server installs wouldn't allow license entry * System uptime values reported incorrectly * Added user level restriction for configuring emails * Log times displayed incorrectly * Online Export service crashes occasionally when done receiving data v2009 Version 9.0.3, Aug 26, 2009 ============================================================================== New Features in Version 9.0.3 ----------------------------- * Added IIS7 support Problems Fixed in Version 9.0.3 ------------------------------- * Data not displayed for variable names with dashes in them * Didn't preserve transparancy for 32 bit color icons * Reports sorted by node or instance name did not display * Clicking dials went to wrong graph if page width was changed * Memory leak in OnLine export service * Mapdraw didn't work for stand alone install of Visio 2007 * Problems with x64 install * Improved flow control of data processing v2009 Version 9.0.2, July 27, 2009 ============================================================================== New Features in Version 9.0.2 ----------------------------- * Included ONLBACK.EXE command line database backup utility Problems Fixed in Version 9.0.2 ------------------------------- * Fixed CSV export for node and log views * OnLine doesn't note node group name changes * Availability reports showing < 100% response, but no failed polls * Clicking on subnets in Visio map would not go to subnet view * Subnet restricted users able to view root subnet map graphic * Crash in online export service if node group 127 in use * Ignores date format specified in SNMPc * Immediate emails can be sent multiple times, scheduled emails can fail v2009 Version 9.0.1, May 15, 2009 ============================================================================== New Features in Version 9.0.1 ----------------------------- * Added free Express Edition that is enabled when the evaluation period expires. Express Edition has the following restrictions: - 2000 report objects per snmp table - SQL Express only (10GB per report) - No visio support - No technical support * Automatic maps generated for SNMPc subnet views * Scheduled Email of reports * A subnet or map view visio graphic can be displayed on summary page * Dynamic pan/zoom controls added to graphic map views * Support for SNMPc "Node Group" and "All Devices" reports with optimized data retrieval * Paging controls added to top level reports to improve handling of reports with a large number of nodes and/or instances. * BCP used for batch trend data imports if available; if BCP is not importing data correctly, set "SNMPc.bcp=no" in the \Windows\PHP.INI file. * Old log events archived * New Interface report with selectable Bandwidth/Utilization/Error views. * Added Min/Max columns to CPU report * Change Map View display style to Default/List/Graphic selection. * PHP script engine updated to 5.2.9 * Apache updated to 2.2.11 * Dashboard dials exclude the node name from the title if all dials in a group are for the same node. * Changed SQL configuration to use Simple Recovery method to improve performance and for smaller transaction log files. Also shrinks SQL log files once a day. Problems Fixed in Version 9.0.1 ------------------------------- * Optimized hourly and daily average rollup routines * SNMPc trend group sort order not maintained in OnLine * SQL Install directory length not enforced * Node report view doesn't always show all reports * Data not saved for tables with long variable names * Log current status not updated * Event log sometimes not synchronized with SNMPc * Averages incorrectly calculated for missing data points * Changed version numbering scheme for use with InstallShield 2009 * CRATR.MIB sometimes lost during SNMPc File/Restore. Moved to SNMPc standard.mib as of 7.1.7. * SNMPc "Tools/SNMPc OnLine" menu doesn't work in remote consoles * Vertical legend text clipped with large index values * Eval serial number message displayed every time on default login page refresh * Group Summary is empty if it doesn't have any built-in reports. Should show an error message instead. * Dashboard tables don't show all selected instances * An empty graph is displayed after selecting the Response Dial in a node summary and then using the Format/Edit button. * Can't use commas in Dashboard widget names * In some cases a custom instance name set in the SNMPc Trend Report properties is not displayed in the OnLine report * Availability report sometimes shows < 100% uptime with no poll failures * Link summary should have a web link back to the associated node summary * SNMPc custom mib tables sometimes do not import data to OnLine * Exported tables (csv/tsv format) sometimes show all data on the first line for top level reports (graphs/summaries worked ok) * Graph Y-axis name sometimes clipped * Install should shutdown running SNMPc tasks (after asking) * MapDraw doesn't work with some foreign language and other special characters * Goto icons are imported to OnLine when they are changed in SNMPc but not on system startup. They should never be exported. * Uninstall not removing Apache web server * Install gets stuck after copmplaining about an SQL password that isn't "strong enough" * Missed polls causing incorrect displayed values for variables related expressions (utilization, etc.). * Installed SQL Express doesn't work with 64 bit Windows * Dashboard settings are lost when trend reports are re-ordered in SNMPc * OnLine reports not listed in same order as SNMPc console * Current event shows history events in some cases * Reports fail with SNMP tables that include very long variable names v2007 Build 37, Jul 1, 2008 ============================================================================== New Features in Build 37 ------------------------- * PHP script engine updated to 5.2.6 Problems Fixed in Build 37 --------------------------- * Selected map view not correct in dashboard frame * Could not change order for custom views * Upgrades from 2005 version would lose license number * Selecting subnet in node view would not reset page count v2007 Build 36b, Apr 21, 2008 ============================================================================== Problems Fixed in Build 36b --------------------------- * Clicking on table based dashboard frame would go to an invalid page * Adding multiple instances from same dashboard selection clears dashboard * Backup directory created on remote SQL server 2005 and above * Install detects Windows Authenticated IIS server and offers integration option * SVG Viewer served locally if no internet access to viewer plugin found * SNMPc subnet maps enabled by default * Status colors not updated in Visio map when saved on server with Authentication v2007 Build 36, Feb 2, 2008 ============================================================================== Problems Fixed in Build 36 --------------------------- * Online user settings lost when export service restarted * Update installs not changing PHP include path, causes mapdraw to fail * Update installs not changing SNMPc OnLine Tool menu name * OnLine unable to connect to some pre-installed SQL servers * Punctuation characters rejected for SNMPc and SQL user passwords * Default summary options not saved * Map view component subnet levels reversed * Install doesn't detect MFC8.0 library install New Features in Build 36 -------------------------------------------- * Install allows selection of existing SQL server * Changing display width shows more characters in table columns * Mouse hover over truncated text shows entire text v2007 Build 35, Sep 19, 2007 ============================================================================== Problems Fixed in Build 35 --------------------------- * Problem doing data lookups with different nationality date formats * Integrate with new SNMPc QOS availability stats * Problem adding Visio demo image * Component directories not created automatically v2007 Build 34, July 23, 2007 ============================================================================== Problems Fixed in Build 34 --------------------------- * Install overwrites PHP.INI in update * SQL databases set to autoclose * User map restrictions ignored in dashboard * Missing report data in dashboard * Mapdraw crashing when Visio stencils not present v2007 Build 33, April 20, 2007 ============================================================================== New Features in Build 33 (New Installs only) -------------------------------------------- * Replaced MSDE with SQL Server 2005 Express Edition * Changed database authentication to use SQL authentication mode for improved security. * Changed IIS user from Administrator to IIS_ for improved security. Problems Fixed in Build 33 --------------------------- * Colors don't print correctly. * MapDraw.exe doesn't prompt to save an imported Visio file that has been modified. * Backup/Restore does not save/restore Visio graphics (.SVG/.VSD) files. * Backup command does not erase old backed up data when same backup name used. * MapDraw.exe login should show web server authentication first, then snmpc login. * Visio graphics status colors don't work when using web server authentication. * Logarithmic table export shows 0 values as 1's. * Display problems when user is assigned a Default View in the User Profiles form. v2007 Build 32, February 12, 2007 ============================================================================== New Features in Build 32 ------------------------- * Added visio demo map view Problems Fixed in Build 32 --------------------------- * Login authentication problems with IIS * Problem creating Map View custom dashboards. * Problem with installs under Windows 2000 and 2003 when not using the actual "Administrator" user. * Doesn't work when Apache web server is used. * Visio SVG/VSD files not removed during uninstall. * MapDraw crashes when an expired Visio trial edition is used. * MapDraw icon on desktop not needed. * Event view should be * MapDraw "File/New Map View" and "File/Properties" not needed. Use regular web interface for these functions. * License checking sometimes fails after uninstall/reinstall/update. * Uninstall did not remove export service from Windows service list * Extra extensions incorrectly added to top of PHP.INI during update * trend group folders close randomly * some text not available to international translation mechanism * extra Instances shown in reports * Does not create databases with SQL Server 2005 or SQL Express * Instances in Availability graph are mislabeled * Percent error packet calculation ignores error frames * Memory leak in trend agent connections * Users with trend group restrictions see nodes/subnets outside of their scope * Changes made to custom tables are not propagated to snmpc online database * Variables with long names are missing from reports * Data points sometimes duplicated * Not picking up instance names from snmpc trend reports * Node summary dials always report zero values * Report ordering does not match SNMPc v2007 BETA, Build 31, Nov 17, 2006: ============================================================================== * Merged with SNMPc OnLine 2005 Build 25c changes. As of Build 32, product will be released as "SNMPc OnLine 2007". SNMPc OnLine 2005 will be deprecated. * Change so Only Supervisor level users can access MapDraw. * MapDraw menu pulldown View/Zoom/Zoom has been removed. * MapDraw Reflects "Empty..." in the Map View name field reflecting no Map Views. * MapDraw menu pulldown Shapes/Unlink is implemented. * MapDraw writes the name of the Map View within the associated SVG file. * SNMPcOnLine does not allow duplicate named maps/records to be created in the DB. * Added MapDraw capabilities to the Dashboard. * MapDraw Help System has been enabled. * Update capabilities on installation have been enabled. * SNMPcOnLine buttons changed from "Show Node List" to "Show List" and "Show Map View" to "Show Drawing". * MapViewMaker is renamed as MapDraw. * MapviewMaker opens the SNMPcOnline Browser front end on File/New and File/Property. * Icons within MapViewMaker Cannot be dragged to a drawing surface that has not been created. * No Formatting errors occur for Maps that don't have associated images. * Installation now reflects SNMPcOnLIne and MapviewMaker under a seperate Start Menu "pull-aside" within SNMPc Network Manager. * Configuration/User Dialog now operates successfully with the "Show Navigation" checkbox. * Map View will no longer accept an empty (blank) name for save or save as. * Event View will no longer accept an empty (blank) name for save or save as. * "Map View Maker" option is provided as a choice under Tools within the SNMPC Enterprise Console menu pulldown. * SNMPcOnline MapView indicates for view creation. * MapViewMaker File->New starts the same as SNMPcOnLine . * MapViewMaker does not require special key sequence to associate dragged Nodes. * MapViewMaker login screen capability to choose server is disabled. * Installer now installs vcredist_x86.exe to support C++ binaries for DOTNET. * MapviewMaker now verifies if Visio is installed before executing. * MapviewMaker now creates the maps directory as needed instead of the installer. * Provided performance enhancements for MapViewmaker with Visio2003SP2-KB887622-FullFile-ENU.exe. * Eliminated web service interactions for file transfers between MapViewMaker and SNMPcOnline. * Enabled MapViewMaker to work within a closed network by use of a locally provided svg10.dtd. * Problem resolved when MapViewMakertries to open non-existing map. * Installed MS DLLs now placed in the System32 folder. * Created maps directory by Installation. * MSDE Install occurs at the correct directory level. v2006 Alpha, Mar 28, 2006: ============================================================================== * Added MapViewMaker application and Microsoft Visio Support v2005, Build 28, Dec 11, 2006: ============================================================================== * Changed license number routines * Uninstall did not remove export service from Windows service list * Fixed extra extensions added to top of PHP.INI in update v2005, Build 27, Nov 20, 2006: ============================================================================== * Fixed trend group folders closing randomly * Fixed OEM translation issues v2005, Build 26, May 1, 2006: ============================================================================== * Fixed international translation problems * Fixed extra Instances shown in reports * Will now create databases with SQL Server 2005 and Express * All instances shown in same Availability graph * Fixed percent error packet calculation * Fixed memory leak in trend agent connections * Fixed user trendgroup restriction bug * Fixed problems with changes made to custom tables * Fixed operation with long variable names * Improved duplicate point checking for long data retrieval times * Fixed drive letter names in disk space reports * Fixed dial displays in node summary * Fixed report ordering to match SNMPc v2005, Build 25c, Mar1, 2006: ============================================================================== * Fixed problem where some instances were missing from report views. v2005, Build 25b, Feb 13, 2006: ============================================================================== * Fixed a bug which was causing the URL to be to long which effectively disabled the main SNMPc OnLine page. v2005, Build 25a, Feb 9, 2006: ============================================================================== * Fixed issues preventing SNMPc OnLine from working with SQL Server 2005 * Fixed an issue preventing traps with more than 20 variable bindings from being imported into SNMPc OnLine. * Reports now recognize the order that they are in from SNMPc and are displayed appropriately. * A bug was fixed which was causing the demo reports to be copied when reordering them. * A bug was fixed which prevented URLs from working when using the latest version of Internet Explorer on Windows 2003 server. v2005, Build 25, Jan 16, 2006: ============================================================================== * Generic graphs were not displaying the proper values in the summary table below the graph. * Exporting the summary information from a generic graph was not working. * Fixed 3 incorrect object definitions within the CRATR.MIB; Volume, DropPercent, and TotalUtil. * Fixed numerous internationalization issues. * Added a configuration variable name "SNMPc.navBarWidth" that, when set, will set the width of the Navigation Bar (tree and calendar) on the left the specified width. If this value is less than 200 it will be set to 200. This value can be set in the PHP.INI file under the SNMPc section. v2005, Build 24a, Dec 13, 2005: ============================================================================== * Fixed a problem causing new report to not be visible when upgrading from earlier versions of the product. v2005, Build 24, Dec 12, 2005: ============================================================================== * Fixed a bug where all instances were being displayed in custom report tables instead of the selected instances * Fixed a bug that would cause loss of data when creating or modifying a custom report * Improved internationalization support * Custom instance names that were set for a report were not always being used v2005, Build 23, Oct 12, 2005: ============================================================================== * Fixed a bug where instances were being displayed in some reports where they didn't belong * Improved integration with existing Apache and PHP installations * Improved installation on Windows 2003 Server machines * Improved internationalization support v2005, Build 22, May 27, 2005: ============================================================================== * Optimized summary page to speed up load times * Improved integration with existing Apache and PHP installations * DBEX would not reconnect to SQL database if disconnected * IE could not handle long URLs needed for dashboard creation ==============================================================================