Announcement

Collapse
No announcement yet.

New mapping module utilizing google maps api

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

  • LuisN
    replied
    Is there any updates on this!?

    Leave a comment:


  • breakintheweb
    replied
    You should be able to maunally run the inserts in sql.

    You can find the sql statements in centreon-gmap/sql/install.php

    Code:
    CREATE TABLE `mod_gmap_options` (
      `id` tinyint(4) NOT NULL auto_increment,
      `lat` float NOT NULL default '0',
      `lng` float NOT NULL default '0',
      `height` smallint(6) NOT NULL default '0',
      `zoomLevel` smallint(3) NOT NULL default '0',
      PRIMARY KEY  (`id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
    
    CREATE TABLE locations (
      l_id int(11) NOT NULL auto_increment,
      h_id int(11) default NULL,
      hg_id int(11) default NULL,
      address varchar(60) default NULL,
      lat varchar(12) default NULL,
      `lng` varchar(12) default NULL,
      PRIMARY KEY  (l_id)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    
    INSERT INTO `mod_gmap_options` (`id`, `lat`, `lng`, `height`, `zoomLevel`) VALUES (1, 47.9016, 1.99951, 500, 5);
    INSERT INTO `css_color_menu` (`id_css_color_menu`, `menu_nb`, `css_name`) VALUES (9, 9, 'green_css.php');
    INSERT INTO `topology_JS` (`id_t_js`, `id_page`, `o`, `PathName_js`, `Init`) VALUES ('', 9, NULL, './include/common/javascript/changetab.js', 'initChangeTab'), ('', 901, NULL, './include/common/javascript/changetab.js', 'initChangeTab');
    INSERT INTO `topology` (`topology_id`, `topology_name`, `topology_icone`, `topology_parent`, `topology_page`, `topology_order`, `topology_group`, `topology_url`, `topology_url_opt`, `topology_popup`, `topology_modules`, `topology_show`, `topology_style_class`, `topology_style_id`, `topology_OnClick`, `readonly`) VALUES
    ('', 'View', './modules/centreon-gmap/img/ico_google.jpg', 7, 704, 100, 1, './modules/centreon-gmap/gmap.php', NULL, '0', '1', '1', NULL, NULL, NULL, '1'),
    ('', 'Host Config', './img/icones/16x16/server_network.gif', 7, 702, 101, 2, './modules/centreon-gmap/gmap_config_host.php', NULL, '0', '1', '1', NULL, NULL, NULL, '1'),
    ('', 'Host Group Config', './img/icones/16x16/clients.gif', 7, 703, 102, 1, './modules/centreon-gmap/gmap_config_hostGroup.php', NULL, '0', '1', '1', NULL, NULL, NULL, '1'),
    ('', 'Gmap Options', NULL, 50101, 5010191, 130, 1, './modules/centreon-gmap/gmap_Opt.php', '&o=w', '0', '0', '1', NULL, NULL, NULL, '1');
    INSERT INTO `topology` (`topology_id`, `topology_name`, `topology_icone`, `topology_parent`, `topology_page`, `topology_order`, `topology_group`, `topology_url`, `topology_url_opt`, `topology_popup`, `topology_modules`, `topology_show`, `topology_style_class`, `topology_style_id`, `topology_OnClick`, `readonly`) VALUES
    ('', 'Google Map', NULL, NULL, 7, 70, 1, NULL, NULL, '0', '0', '1', NULL, NULL, NULL, '1');

    Leave a comment:


  • tosage
    replied
    Nothing on the Centreon 2.1.13, i don't have any information in the topology table on centreon database.
    On the 2.3.4 i have this five line but on the 2.3.4 version of centreon, when i click on, nothing appear lol

    Have you any idea ?

    Thanks ops:

    EDIT : If I double click on the word google map on my DEV (Centreon 2.3.4) it works.
    It is unfortunate that tooltips do not display the status of hosts in the hostgroup and host config, we no longer see the summary of the status of various services while the old version did (CRITICAL, UNKNOWN, OK)
    Last edited by tosage; 27 January 2012, 16:15. Reason: MAJ case Centreon 2.3.4

    Leave a comment:


  • breakintheweb
    replied
    Originally posted by tosage View Post
    I think i have a bug in the install .sql :



    This is in my /usr/local/centreon/log/error-sql-2012-01-27.log
    I have the same error in my logs but the data was inserted. Can you see if the topology entries exist? There should be five of them.

    Code:
    SELECT * FROM `topology` WHERE `topology_name` like '%Google%' or `topology_url` like '%gmap%'

    Leave a comment:


  • tosage
    replied
    I think i have a bug in the install .sql :

    13:51|0|0|DB Error: constraint violation QUERY : INSERT INTO css_color_menu (id_css_color_menu, menu_nb, css_name) VALUES (9, 9, 'green_css.php');
    13:51|0|0|DB Error: constraint violation QUERY : INSERT INTO topology_JS (id_t_js, id_page, o, PathName_js, Init) VALUES ('', 9, NULL, './include/common/javascript/changetab.js', 'initChangeTab'), ('', 901, NULL, './include/common/javascript/changetab.js', 'initChangeTab');
    13:51|0|0|DB Error: no such field QUERY : INSERT INTO topology (topology_id, topology_name, topology_icone, topology_parent, topology_page, topology_order, topology_group, topology_url, topology_url_opt, topology_popup, topology_modules, topology_show, topology_style_class, topology_style_id, topology_OnClick, readonly) VALUES
    ('', 'View', './modules/centreon-gmap/img/ico_google.jpg', 7, 704, 100, 1, './modules/centreon-gmap/gmap.php', NULL, '0', '1', '1', NULL, NULL, NULL, '1'),
    ('', 'Host Config', './img/icones/16x16/server_network.gif', 7, 702, 101, 2, './modules/centreon-gmap/gmap_config_host.php', NULL, '0', '1', '1', NULL, NULL, NULL, '1'),
    ('', 'Host Group Config', './img/icones/16x16/clients.gif', 7, 703, 102, 1, './modules/centreon-gmap/gmap_config_hostGroup.php', NULL, '0', '1', '1', NULL, NULL, NULL, '1'),
    ('', 'Gmap Options', NULL, 50101, 5010191, 130, 1, './modules/centreon-gmap/gmap_Opt.php', '&o=w', '0', '0', '1', NULL, NULL, NULL, '1');
    13:51|0|0|DB Error: no such field QUERY : INSERT INTO topology (topology_id, topology_name, topology_icone, topology_parent, topology_page, topology_order, topology_group, topology_url, topology_url_opt, topology_popup, topology_modules, topology_show, topology_style_class, topology_style_id, topology_OnClick, readonly) VALUES
    ('', 'Google Map', NULL, NULL, 7, 70, 1, NULL, NULL, '0', '0', '1', NULL, NULL, NULL, '1');
    This is in my /usr/local/centreon/log/error-sql-2012-01-27.log

    Leave a comment:


  • breakintheweb
    replied
    Originally posted by tosage View Post
    Nothing better for me :/
    The menu doesn't appear in my 2.1.13 Centreon and on my DEV (now in 2.3.4) i have Loading... when i click on google Map and nothing more.

    Maybe the first installation may have left trace in the topology table ??
    Yes, you need to uninstall then reinstall.

    Leave a comment:


  • tosage
    replied
    Nothing better for me :/
    The menu doesn't appear in my 2.1.13 Centreon and on my DEV (now in 2.3.4) i have Loading... when i click on google Map and nothing more.

    Maybe the first installation may have left trace in the topology table ??

    Leave a comment:


  • breakintheweb
    replied
    There was a mistake in sql/install.php which was causing the topology table to not be built.

    I've replace the old download with a fixed version.

    http://community.centreon.com/attach...n-gmap.tar.bz2

    You will need to copy the files, then uninstall and install. You may need to logout to get the module to appear.



    Originally posted by tosage View Post
    This module, after installation, don't appear on a Centreon 2.1.13.
    On the Centreon 2.2.2 i have the new Google Map Menu after the Administration Menu but when i click on it, i have a forbidden page "You don't have access".

    Maybe compatible only with the 2.3.x ?

    Thanks for your reply

    Leave a comment:


  • tosage
    replied
    This module, after installation, don't appear on a Centreon 2.1.13.
    On the Centreon 2.2.2 i have the new Google Map Menu after the Administration Menu but when i click on it, i have a forbidden page "You don't have access".

    Maybe compatible only with the 2.3.x ?

    Thanks for your reply

    Leave a comment:


  • breakintheweb
    replied
    Originally posted by tosage View Post
    Hello breakintheweb, you have do some modification on the module ?
    Latest version is ready for testing.
    http://community.centreon.com/projec...eon-gmap/files

    Leave a comment:


  • tosage
    replied
    Hello breakintheweb, you have do some modification on the module ?

    Leave a comment:


  • breakintheweb
    replied
    updates

    I know it's been a long time since the code has been active. I'm currently attempting to get the code working in centreon 2.3. The latest code has been submitted to http://svn.modules.centreon.com/centreon-gmap/.

    Note: the current version Dosen't have the install scripts so you won't be able to install. I'll update this once the code is working 100%.

    Leave a comment:


  • tosage
    replied
    Hallo Hellnino18,

    Go to the forge of the project (if you want)
    I can beta test your version of the plugin if you want but i don't have any skills in web development, sorry :/

    Leave a comment:


  • Hellnino18
    replied
    Hi,

    In august 2010 I continued the dev of this plugin and change some issues. Some bug and enhancements are still waiting. If someone wants to help there is no problem, because there are a lot of ideas

    Leave a comment:


  • tosage
    replied
    magicbret
    Hi,

    Thanks for the plugin.

    I've got a problem, as i can not see the HostGroup list, so cannot add a HostGroup

    I modified the DB-func.php file :

    I changed line 98
    Code:
    while ($hostgroup =& $DBRESULT->fetchInto()) {
    to
    Code:
    while ($hostgroup =& $DBRESULT->fetchRow()) {
    So now, i can see the list, but if i choose a hostgroup, then i can't see it on the map, and all my hosts previously added are not seen.

    Any help would be appreciated.

    Thanks
    +1 in my installation with Centreon 2.1.11

    I open a bug on the forge of the project for developper

    Leave a comment:

Working...
X