view release on metacpan or  search on metacpan

lib/ASNMTAP/Asnmtap/Applications.pod  view on Meta::CPAN

  Use_Storage_Mysql =              "yes"

  No_Raw_Data =                    "no"
  No_Bin_Data =                    "no"

  # Database Authentication
  DB_User =                    "asnmtap"
  DB_Name =                    "perfparse_asnmtap"
  DB_Pass =                    "passwd"
  DB_Host =                    "localhost"

=item Configuration of Perfparse v20 for ASNMTAP

 cp /opt/asnmtap/perfparse/etc/perfparse20.cfg.example /opt/asnmtap/perfparse/etc/perfparse20.cfg

 First you should edit '/opt/asnmtap/perfparse/etc/perfparse20.cfg', adding the correct database settings (if using something other than 'nagios' as DB name, username, and password). The options are :

 Use_Storage_Mysql (only in perfparsed; considered as enabled in perfparse-log2mysql)

 vi /opt/asnmtap/perfparse/etc/perfparse20.cfg
   ...
   Service_Log "-"
   ...
   # Error handling :
   Error_Log =                 "/opt/asnmtap/log/perfparse-asnmtap-all"
   Drop_File =                 "/opt/asnmtap/log/perfparse-asnmtap-drop"
   ...

  # Database managment :
  # ====================
  Storage_Modules_Load =       "mysql"
  Use_Storage_Mysql    =       "yes"

  No_Raw_Data =                "no"
  No_Bin_Data =                "no"

  # Database Authentication
  DB_User     =                "asnmtap"
  DB_Name     =                "perfparse_asnmtap_v20"
  DB_Pass     =                "passwd"
  DB_Host     =                "localhost"
	DB_Socket   =                "/tmp/mysql.sock"

	# PHPGui
	PHP_Lang    = "en"
	PHP_Style   = "" # "flo"
	http_image_path = "/asnmtap/perfparse20/img/"

=item Testing configuration

 http://asnmtap.citap.be/asnmtap/cgi-bin/perfparse.cgi
 > An error occured with the SQL:
 >   "Could not connect to MySQL using:  Database  = 'asnmtap',  Host  = '127.0.0.1',  Username =  'asnmtap', Password  = 'asnmtap'"
 >
 > Failure Message:
 >   "Access denied for user: 'asnmtap@localhost.localdomain' (Using password: YES)"

 You need to verify your access right for the database

 Host & Service string from Nagios:
   "$TIMET$"\t"$HOSTNAME$"\t"$SERVICEDESC$"\t"$OUTPUT$"\t"$SERVICESTATE$"\t"$PERFDATA$"\n

   $TIMET$		$HOSTNAME$		 	    $SERVICEDESC$		$OUTPUT$											$SERVICESTATE$	$PERFDATA$
   1107692805	chablis.dvkhosting.com	process ColdFusion	OK - 40 processes running with command name cfusion	OK				label=1;2;3;4;5

   Test ASNMTAP Perfparse integration:
   /usr/bin/printf "%b" "1107692900\tDUMMY-T1\tDUMMY-T1\tCRITICAL - Check Dummy: +DUMMY-T2+\tCRITICAL\ttperfdata=1;1;;;\n" | /opt/asnmtap/perfparse/bin/perfparse-log2mysql -c /opt/asnmtap/perfparse/etc/perfparse.cfg

   Look for results into the database and the logfile located at /opt/asnmtap/log/perfparse-asnmtap-all.yyyymmdd.log

   more /opt/asnmtap/log/perfparse-asmtap-all.yyyymmdd.log 
   yyyy/mm/dd hh:mmss1 [   storage.c:95    nnnn  ] storage_mysql module successfully loaded

=item Database Maintenance

Deletion policies are defined at various places with default and user-defined policies available. A policy defines the time at which data is permanently deleted from the DB. The data is deleted by running the provided program 'perfparse-db-purge'. It...

 To purge the Database daily using 'perfparse-db-purge' from crontab, you might use something like this:

 # Purge PerfParse Database daily at 3 AM.
 0 3 * * * /opt/asnmtap/perfparse/bin/perfparse-db-purge > /dev/null

=back

=item SNMPTT integration

 ... TODO ... NO PART OF NORMAL SETUP ...

=over 4

=item Install SNMPTT

Install net-snmp 5.4.x

 ... TODO ... NO PART OF NORMAL SETUP ...

 MySQL 5.0.x

  SQLyog -> Db -> Import from SQL Statements ... -> \opt\asnmtap-3.001.xxx\plugins\templates\snmptt\snmptt-3.002.003-v5.0.x.sql
  SQLyog -> Db -> Import from SQL Statements ... -> \opt\asnmtap-3.001.xxx\plugins\templates\snmptt\create_weblogic_configuration_database_with_SNMP-3.002.003_mysql-v5.0.x.SQL
  or
  mysql -u root -p  < /opt/asnmtap/plugins/templates/snmptt/snmptt-3.002.003-v5.0.x.sql
  mysql -u root -p  < /opt/asnmtap/plugins/templates/snmptt/create_weblogic_configuration_database_with_SNMP-3.002.003_mysql-v5.0.x.SQL

 ... TODO ... NO PART OF NORMAL SETUP ...

=item Configuration of SNMPTT for ASNMTAP

 ... TODO ... NO PART OF NORMAL SETUP ...

=over 4

=item 1

 plugins/templates/snmptt/snmptt-bea-weblogic.conf

 ... TODO ... NO PART OF NORMAL SETUP ...

 plugins/templates/snmptt/snmptt-oracle.conf

 ... TODO ... NO PART OF NORMAL SETUP ...

 plugins/templates/snmptt/snmptt.ini