Announcement

Collapse
No announcement yet.

Graphs ... Graphs ... Graphs - help

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • stinkybob
    replied
    I'm the same way. I have data in the database, but graphs are empty.

    Leave a comment:


  • mdemsar
    replied
    Re:

    My problem exactly. It worked in the begining, but then it stopped.

    Leave a comment:


  • DonKiShoot
    replied
    Ok now you are at the same point as me.

    Perfparse results go in database but some difficulty to obtain a good graph with Oreon.

    Maybe in RC2

    PS: On the first test i have had good graph but after a while, no more graph

    Leave a comment:


  • mdemsar
    replied
    Re:

    This documentation is very good:
    http://perfparse.sourceforge.net/docs.php
    It is for Nagios 1.X.

    By the way: my Perfparse is working OK and logging all events, but in Oreon I get no graphs. Everything empty. I am also using Oreon plugins, but no effect. RRDs are in a directory (/usr/local/oreon/rrd), there are also some rrd's in /usr/local/oreon/filesGeneration/graphs/simpleRenderer/rrdDB, but nothing. Perfparse draws graphs, but Oreon only gives me this for every service I want to graph:
    Attached Files

    Leave a comment:


  • DonKiShoot
    replied
    perfparse is missconfigured, try to resolve this first ! :wink:

    Leave a comment:


  • BZ
    replied
    I have serius problens =(
    i using oreon 1.3 rc1 and nagios 1.x

    Everthing ok, but my database dont growup.

    and when i click on the "minigraph" icon at monitoring screen, i get the graph generation screen, but host/service and metaservice fields are empty.

    The "dropdown" box, dont have anyting.. ( i tink it is becouse the database are empty, just the fields and tables, no data)

    when i try access the http://MYHOST/nagios/cgi-bin/perfparse.cgi the main screen of perfparse appear, but no hosts /servcies etc etc, empty too


    any hints?

    Leave a comment:


  • mdemsar
    replied
    Re:

    Your data is correct. Oreon's user is web server user (I think) so in your case "apache". Maybe one of the developers of application will come by this forum. If I get idea I will post here.
    In the meantime you can maybe try granting all rights to "logos" folder to user nagios, group nagios:
    "chmod 777 /usr/local/nagios/share/images/logos"
    Try then and if it doesn't work, there could be a problem with your installation. If it does work, user rights were not granted properly during install.

    Leave a comment:


  • abc
    replied
    Ok... Thanks… the first one is solved now, my mail on /bin/mail..

    But it still shows the second message:
    Images Directory: /usr/local/nagios/share/images/logo/ ((Can't write directory))

    My http user:
    # more /etc/httpd/conf/httpd.conf
    User apache

    & the Nagios user:
    # cat /etc/goup
    nagios:x:500:apache

    So it should has permission or not???!!
    How can l know my Oreon user??!!.... :roll:

    Leave a comment:


  • mdemsar
    replied
    Re:

    One possibility, but small one is that you don't have mail software installed. Maybe your web user user doesn't have rights to /usr/bin/ . Oreon uses a wwwrun user and you should su to wwwrun (or your respective user-I use SLES and here is wwwrun) and try executing mail. You can also su to web user and running "which mail". Then you type this path to Oreon config.

    The second directory has permissions for user nagios, group nagios and maybe your oreon user (wwwrun etc.) is not a member of your nagios group.
    Execute "cat /etc/group" and look for members of web server group. My file looks like this:
    nagios:!:19047:wwwrun

    Leave a comment:


  • abc
    replied
    I have the same problem... I can’t see the graph....

    When I tried to enable using the PerfParse I got the following errors:

    Directory + Mailer Binary: /usr/bin/mail ((* Can't execute binary))

    Images Directory: /usr/local/nagios/share/images/logo/ ((Can't write directory))


    What do this mean??!!!...

    The second directory exists & has the following permission:
    # ls -ld /usr/local/nagios/share/images/logos/
    drwxrwxr-x 2 nagios nagios 4096 Jun 19 08:38 /usr/local/nagios/share/images/logos/

    But I can’t see the first one (/usr/bin/mail/) do I have to it as an empty directory or what??!!!
    Attached Files

    Leave a comment:


  • abc
    replied
    I have the same problem... I can’t see the graph....

    When I tried to enable using the PerfParse I got the following errors:

    Directory + Mailer Binary: /usr/bin/mail ((* Can't execute binary))

    Images Directory: /usr/local/nagios/share/images/logo/ ((Can't write directory))


    What do this mean??!!!...

    The second directory exists & has the following permission:
    # ls -ld /usr/local/nagios/share/images/logos/
    drwxrwxr-x 2 nagios nagios 4096 Jun 19 08:38 /usr/local/nagios/share/images/logos/

    But I can’t see the first one (/usr/bin/mail/) do I have to it as an empty directory or what??!!!
    Attached Files

    Leave a comment:


  • mdemsar
    replied
    Re:

    Hello!

    Do you have any data in your PerfParse database? If not, you should check your Perfparse config and if you think, that everything is OK but still not working, you should check your variables. In Nagios 2.X some variables have changed and PerfParse does not have this in documentation. If you need, I can send you required info. For example, this is my Nagios 2.x perfparse command:
    /usr/bin/printf "%b" "$TIMET$\t$HOSTNAME$\t$SERVICEDESC$\t$SERVICEOUTPU T$\t$SERVICESTATE$\t$SERVICEPERFDATA$\n" | /usr/local/nagios/bin/perfparse-log2mysql -c /usr/local/nagios/etc/perfparse.cfg

    If you compare this to you process-perfparse-perfdata command you should see the changed macros.
    By the way, graphs in Oreon still don't work and I gave up fixing it for now. I use perfparse.

    Leave a comment:


  • BZ
    replied
    I have the same problem!!
    any news?

    Leave a comment:


  • mdemsar
    replied
    My table structure

    This is my table structure. I think that yesterday something must have been wrong with my setup. I repeated it and it seems OK now.

    Sorry for not attaching a file, but it doesn't work from my location.

    -- phpMyAdmin SQL Dump
    -- version 2.8.0.3
    -- http://www.phpmyadmin.net
    --
    -- Host: kikimora.local.lj-mlek.si
    -- Generation Time: Jun 13, 2006 at 09:20 AM
    -- Server version: 4.1.20
    -- PHP Version: 4.3.4
    --
    -- Database: `oreondb`
    --

    -- --------------------------------------------------------

    --
    -- Table structure for table `cfg_nagios`
    --

    CREATE TABLE `cfg_nagios` (
    `nagios_id` int(11) NOT NULL auto_increment,
    `nagios_name` varchar(255) default NULL,
    `log_file` varchar(255) default NULL,
    `cfg_dir` varchar(255) default NULL,
    `object_cache_file` varchar(255) default NULL,
    `temp_file` varchar(255) default NULL,
    `status_file` varchar(255) default NULL,
    `p1_file` varchar(255) default NULL,
    `aggregate_status_updates` enum('0','1','2') default NULL,
    `status_update_interval` int(11) default NULL,
    `nagios_user` varchar(255) default NULL,
    `nagios_group` varchar(255) default NULL,
    `enable_notifications` enum('0','1','2') default NULL,
    `execute_service_checks` enum('0','1','2') default NULL,
    `accept_passive_service_checks` enum('0','1','2') default NULL,
    `execute_host_checks` enum('0','1','2') default NULL,
    `accept_passive_host_checks` enum('0','1','2') default NULL,
    `enable_event_handlers` enum('0','1','2') default NULL,
    `log_rotation_method` varchar(255) default NULL,
    `log_archive_path` varchar(255) default NULL,
    `check_external_commands` enum('0','1','2') default NULL,
    `command_check_interval` varchar(255) default NULL,
    `command_file` varchar(255) default NULL,
    `downtime_file` varchar(255) default NULL,
    `comment_file` varchar(255) default NULL,
    `lock_file` varchar(255) default NULL,
    `retain_state_information` enum('0','1','2') default NULL,
    `state_retention_file` varchar(255) default NULL,
    `retention_update_interval` int(11) default NULL,
    `use_retained_program_state` enum('0','1','2') default NULL,
    `use_retained_scheduling_info` enum('0','1','2') default NULL,
    `use_syslog` enum('0','1','2') default NULL,
    `log_notifications` enum('0','1','2') default NULL,
    `log_service_retries` enum('0','1','2') default NULL,
    `log_host_retries` enum('0','1','2') default NULL,
    `log_event_handlers` enum('0','1','2') default NULL,
    `log_initial_states` enum('0','1','2') default NULL,
    `log_external_commands` enum('0','1','2') default NULL,
    `log_passive_service_checks` enum('0','1','2') default NULL,
    `log_passive_checks` enum('0','1','2') default NULL,
    `global_host_event_handler` int(11) default NULL,
    `global_service_event_handler` int(11) default NULL,
    `sleep_time` int(11) default NULL,
    `inter_check_delay_method` varchar(255) default NULL,
    `service_inter_check_delay_method` varchar(255) default NULL,
    `host_inter_check_delay_method` varchar(255) default NULL,
    `service_interleave_factor` varchar(255) default NULL,
    `max_concurrent_checks` int(11) default NULL,
    `max_service_check_spread` int(11) default NULL,
    `max_host_check_spread` int(11) default NULL,
    `service_reaper_frequency` int(11) default NULL,
    `interval_length` int(11) default NULL,
    `auto_reschedule_checks` enum('0','1','2') default NULL,
    `auto_rescheduling_interval` int(11) default NULL,
    `auto_rescheduling_window` int(11) default NULL,
    `use_agressive_host_checking` enum('0','1','2') default NULL,
    `enable_flap_detection` enum('0','1','2') default NULL,
    `low_service_flap_threshold` varchar(255) default NULL,
    `high_service_flap_threshold` varchar(255) default NULL,
    `low_host_flap_threshold` varchar(255) default NULL,
    `high_host_flap_threshold` varchar(255) default NULL,
    `soft_state_dependencies` enum('0','1','2') default NULL,
    `service_check_timeout` int(11) default NULL,
    `host_check_timeout` int(11) default NULL,
    `event_handler_timeout` int(11) default NULL,
    `notification_timeout` int(11) default NULL,
    `ocsp_timeout` int(11) default NULL,
    `ochp_timeout` int(11) default NULL,
    `perfdata_timeout` int(11) default NULL,
    `obsess_over_services` enum('0','1','2') default NULL,
    `ocsp_command` int(11) default NULL,
    `obsess_over_hosts` enum('0','1','2') default NULL,
    `ochp_command` int(11) default NULL,
    `process_performance_data` enum('0','1','2') default NULL,
    `host_perfdata_command` int(11) default NULL,
    `service_perfdata_command` int(11) default NULL,
    `host_perfdata_file` varchar(255) default NULL,
    `service_perfdata_file` varchar(255) default NULL,
    `host_perfdata_file_template` text,
    `service_perfdata_file_template` text,
    `host_perfdata_file_mode` enum('a','w','2') default NULL,
    `service_perfdata_file_mode` enum('a','w','2') default NULL,
    `host_perfdata_file_processing_interval` int(11) default NULL,
    `service_perfdata_file_processing_interval` int(11) default NULL,
    `host_perfdata_file_processing_command` int(11) default NULL,
    `service_perfdata_file_processing_command` int(11) default NULL,
    `check_for_orphaned_services` enum('0','1','2') default NULL,
    `check_service_freshness` enum('0','1','2') default NULL,
    `service_freshness_check_interval` int(11) default NULL,
    `freshness_check_interval` int(11) default NULL,
    `check_host_freshness` enum('0','1','2') default NULL,
    `host_freshness_check_interval` int(11) default NULL,
    `date_format` varchar(255) default NULL,
    `illegal_object_name_chars` varchar(255) default NULL,
    `illegal_macro_output_chars` varchar(255) default NULL,
    `use_regexp_matching` enum('0','1','2') default NULL,
    `use_true_regexp_matching` enum('0','1','2') default NULL,
    `admin_email` varchar(255) default NULL,
    `admin_pager` varchar(255) default NULL,
    `nagios_comment` text,
    `nagios_activate` enum('0','1') default NULL,
    PRIMARY KEY (`nagios_id`),
    KEY `cmd1_index` (`global_host_event_handler`),
    KEY `cmd2_index` (`global_service_event_handler`),
    KEY `cmd3_index` (`ocsp_command`),
    KEY `cmd4_index` (`ochp_command`),
    KEY `cmd5_index` (`host_perfdata_command`),
    KEY `cmd6_index` (`service_perfdata_command`),
    KEY `cmd7_index` (`host_perfdata_file_processing_command`),
    KEY `cmd8_index` (`service_perfdata_file_processing_command`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

    --
    -- Constraints for dumped tables
    --

    --
    -- Constraints for table `cfg_nagios`
    --
    ALTER TABLE `cfg_nagios`
    ADD CONSTRAINT `cfg_nagios_ibfk_1` FOREIGN KEY (`global_host_event_handler`) REFERENCES `command` (`command_id`) ON DELETE SET NULL,
    ADD CONSTRAINT `cfg_nagios_ibfk_2` FOREIGN KEY (`global_service_event_handler`) REFERENCES `command` (`command_id`) ON DELETE SET NULL,
    ADD CONSTRAINT `cfg_nagios_ibfk_3` FOREIGN KEY (`ocsp_command`) REFERENCES `command` (`command_id`) ON DELETE SET NULL,
    ADD CONSTRAINT `cfg_nagios_ibfk_4` FOREIGN KEY (`ochp_command`) REFERENCES `command` (`command_id`) ON DELETE SET NULL,
    ADD CONSTRAINT `cfg_nagios_ibfk_5` FOREIGN KEY (`host_perfdata_command`) REFERENCES `command` (`command_id`) ON DELETE SET NULL,
    ADD CONSTRAINT `cfg_nagios_ibfk_6` FOREIGN KEY (`service_perfdata_command`) REFERENCES `command` (`command_id`) ON DELETE SET NULL,
    ADD CONSTRAINT `cfg_nagios_ibfk_7` FOREIGN KEY (`service_perfdata_command`) REFERENCES `command` (`command_id`) ON DELETE SET NULL,
    ADD CONSTRAINT `cfg_nagios_ibfk_8` FOREIGN KEY (`host_perfdata_file_processing_command`) REFERENCES `command` (`command_id`) ON DELETE SET NULL,
    ADD CONSTRAINT `cfg_nagios_ibfk_9` FOREIGN KEY (`service_perfdata_file_processing_command`) REFERENCES `command` (`command_id`) ON DELETE SET NULL;

    Leave a comment:


  • julio
    replied
    hooo strange... can you give us a db structure of your cfg_nagios table ?

    Thanks..

    Leave a comment:

Working...
X