Receiving Email Notification of Messages
PSQL does not include email notification of event messages because products from other vendors that provide such functionality are readily available. This section identifies some of those products. Also discussed is the event log content to monitor for events pertaining to PSQL licensing and product keys.
Products That Provide Email Notification of Monitored Events
The following table is a partial list of products that can provide email notification of events in the operating system event log. The products are listed alphabetically. Actian Corporation does not endorse one product over another. Since the products listed are from other vendors, the products and the discussion about them may vary from what is presented here.
Note that such products typically require either an agent to be installed or a remote access mechanism like Windows Management Instrumentation (WMI) or secure shell (SSH) to be enabled.
Table 59
Products That Provide Email Notification of Monitored Events
Product
Cost
Platform
Discussion
Hyperic
www.hyperic.com
Contact Hyperic
Windows
Requires installing an agent on the monitored machine and opening a firewall port for the agent.
Linux and OS X
Requires enabling SSH on the monitored machine and opening a firewall port for SSH.
Nagios
www.nagios.org/
Free
Windows and Linux
Requires installing an agent on the monitored machine and opening a firewall port for the agent.
Spiceworks
www.spiceworks.com
Free
Windows
Requires enabling remote WMI on the monitored machine and opening a firewall port for remote WMI.
Linux
Requires enabling SSH on the monitored machine and opening a firewall port for SSH.
System Center Configuration Manager (SCCM)
www.microsoft.com
Contact Microsoft
Windows
Requires either an agent or enabling remote WMI on the monitored machine. The firewall is automatically adjusted when WMI is enabled. If an agent is used, also requires opening a firewall port for the agent. This product is available only for Windows operating systems.
ZenOSS
www.zenoss.com
Contact ZenOSS
Windows
Requires installing an agent on the monitored machine and opening a firewall port for the agent.
Linux and OS X
Requires enabling SSH on the monitored machine and opening a firewall port for SSH.
Event Log Content to Monitor for License Event Messages
All of the products in Table 59 have the ability to identify content in the operating system event log. The identification methods differ between Windows platforms and Linux and OS X distributions. The intent of this section is not to discuss the specific monitoring methods of each product. Refer to the vendor documentation for product details.
Windows Platforms
The following table identifies the properties in the operating system event log specific to PSQL licensing. Configure your monitoring product to send email notifications based on the values of those properties.
Operating System Event Log Property
Value to Monitor
Source
Pervasive SQL
Category
Product Keys
Type
Warning, Error
Examples
Suppose that you want to receive email notifications for all PSQL licensing event messages that are warnings or errors. Configure your product to monitor the following conditions.
•
Source=“Pervasive SQL”
•
Category=“Product Keys”
•
Type=“Warning” | Type= “Error”
Linux and OS X Distributions
The Linux and OS X syslog does not contain the same properties as the Windows operating system event log. You must configure the notification product to identify events and strings in the syslog. Based on events and string comparisons, the product can then initiate the desired action, such as send an email notification.
Note that all messages – whether licensing related or not – written to the syslog by the PSQL database engine contain the string mkded. The following list identifies some of the strings in the syslog specific to PSQL licensing. One way to monitor the syslog is to configure a string comparison based on content that contains mkded and one of the following strings:
•
disabled
•
failed validation
•
for key
•
validation of key
•
capacity for session count
•
capacity for data in use
•
user count