Menu
▾
▴
[Perfparse-users] Re: =?iso-8859-1?Q?R=E9f._:_Re:_[Perfparse-users]_No_data_in_MySQL_database?=
|
From: Yves <yme...@pe...> - 2005-03-29 15:38:45
|
> Nothing is logged in the database =3D> no hosts, no services > > I join the file which is the result of the command : > /usr/local/nagios/bin/perfparsed -c /usr/local/nagios/etc/perfparse.cfg > --show_config and if it can help you to solve my problem. No idea. Things that I wanted to see are there, which is good. What does the log file say ? - nagios log - /usr/local/nagios/var/perfparse.log (with the date because you enabled = rotaton) - /usr/local/nagios/var/storage_modules.status Is "/usr/local/nagios/var/perfdata-service.log" a pipe ? If not, stop nagios, remove/rename that file, run perfparsed and then run= nagios. But I don't think this is the problem : if it is not a pipe, perfparsed w= ill refuse to run. Yves > > > > > > Frank > > fra...@dg... > > > > > "Yves" <yme...@pe...> > Envoy=E9 par : per...@li... > 29/03/2005 15:05 > Veuillez r=E9pondre =E0 ymettier > > > Pour : Fra...@dg... > cc : per...@li... > Objet : Re: [Perfparse-users] No data in MySQL database > > > Hello, > > Could you read this : http://wiki.perfparse.org/tiki-view_faq.php?faqId= =3D7#q12 ? > I think you are just missing that you have to enable the mysql storage > module. > If it not enough, there is also this : > http://wiki.perfparse.org/tiki-view_faq.php?faqId=3D6#q7 ? > http://wiki.perfparse.org/tiki-view_faq.php?faqId=3D5#q8 ? > > And if you need more, ask us again and run "perfparsed <your usual opti= ons > here> > --show_config" that will print something compatible with your config fi= le, > with all the > options. > > I'm interested in your results with nagios-2.02b : are you using the pi= pe > output in > Nagios ? > Yves > >> Hi all, >> >> I've installed Perfparse 0.105.6 with MySQL 4.1.7 and Nagios 2.02b. > Nagios >> is running perfectly, but perfparse don't write data in my MySQL > database. >> I see some data in the perfdata-service.log file and nothing in the >> perfdata-host.log. >> >> Can anyone help me to configure correctly perfparse, please ? >> >> I join my several config files with this message : >> >> perfparse.cfg >> >> # Server managment (perfparsed only) : >> # =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D> Server_Port =3D 1976 >> >> # Parser managment : >> # =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D> # Performance D= ata Log Files ("-" for stdin) : >> #Service_Log =3D "/usr/local/nagios/var/serviceperf.log= " >> Service_Log =3D "|/usr/local/nagios/var/perfdata-service.log" >> Service_Log_Position_Mark_Path =3D "/usr/local/nagios/var" >> Service_Log_Save_Position =3D "yes" >> >> # Error handling : >> Error_Log =3D "/usr/local/nagios/var/perfparse.log" >> Error_Log_Rotate =3D "Yes" >> Error_Log_Keep_N_Days =3D "7" >> Drop_File =3D "/usr/local/nagios/var/perfparse.drop" >> Drop_File_Rotate =3D "Yes" >> Drop_File_Keep_N_Days =3D "7" >> >> # Lock file for only one perfparse running at the same time >> Lock_File =3D "/usr/local/nagios/var/perfparse.lock" >> >> # Reporting options : >> # =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D> >> # Do not display completion status of perfparse: >> Show_Status_Bar =3D "yes" >> >> # Display a report on exit of perfparse: >> Do_Report =3D "yes" >> >> # CGI managment : >> # =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D> # Default user permissio= ns in the CGI. Accepted values are >> (ro|rw|hide) >> Default_user_permissions_Policy =3D "rw" >> Default_user_permissions_Host_groups =3D "rw" >> Default_user_permissions_Summary =3D "rw" >> >> # Output logger : >> # =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D> # set Output_Log_File to= "yes" to enable it >> Output_Log_File =3D "yes" >> Output_Log_Filename =3D "/usr/local/nagios/var/perfparse_output_log" >> Output_Log_Rotate =3D "yes" >> Output_Log_Keep_N_Days =3D "7" >> >> >> # Database managment : >> # =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D> Use_Stora= ge_Mysql =3D "yes" >> No_Raw_Data =3D "yes" >> No_Bin_Data =3D "yes" >> >> # Database Authentication >> DB_User =3D "nagios" >> DB_Name =3D "perfparse_nagios" >> DB_Pass =3D "xxxxxxx" >> DB_Host =3D "localhost" >> >> # misc >> Dummy_Hostname =3D "venus" >> Storage_Modules_Load =3D "mysql" >> >> nagios_perfparse.cfg (loaded with nagios.cfg) >> define command { >> command_name process-service-perfdata >> command_line $USER2$/bin/perfparse_nagios_pipe_command.pl >> $USER2$/var/perfdata-service.log "$TIMET$" "$HOSTNAME$" "$SERVICEDESC$= " >> "$OUTPUT$" "$SERVICESTATE$" "$SERVICEPERFDATA$" >> } >> >> define command { >> command_name process-host-perfdata >> command_line $USER2$/bin/perfparse_nagios_pipe_command.pl >> $USER2$/var/perfdata-host.log "$TIMET$" "$HOSTNAME$" "$SERVICEDESC$" >> "$OUTPUT$" "$SERVICESTATE$" "$HOSTPERFDATA$" >> } >> >> nagios.cfg >> >> cfg_file=3D/usr/local/nagios/etc/nagios_perfparse.cfg >> process_performance_data=3D1 >> host_perfdata_command=3Dprocess-host-perfdata >> service_perfdata_command=3Dprocess-service-perfdata >> >> Thanks in advance for your help !! >> Frank >> >> >> fra...@dg... > > > -- > - Homepage - http://ymettier.free.fr - http://www.logicacmg.com - > - GPG key - http://ymettier.free.fr/gpg.txt - > - Maitretarot - http://www.nongnu.org/maitretarot/ - > - Perfparse - http://www.perfparse.org/ - > > > > ------------------------------------------------------- > SF email is sponsored by - The IT Product Guide > Read honest & candid reviews on hundreds of IT Products from real users= . > Discover which products truly live up to the hype. Start reading now. > http://ads.osdn.com/?ad_ide95&alloc_id=14396&op=3Dclick > _______________________________________________ > Perfparse-users mailing list > Per...@li... > https://lists.sourceforge.net/lists/listinfo/perfparse-users > > > > > --=20 - Homepage - http://ymettier.free.fr - http://www.logicacmg.com - - GPG key - http://ymettier.free.fr/gpg.txt - - Maitretarot - http://www.nongnu.org/maitretarot/ - - Perfparse - http://www.perfparse.org/ - |
