Hi DeocirI have a (not very elegant) but working implementation of this, below is a description that you may be able to use as a rough example to construct your own, and attached is the scripts I use:
The system is composed of a number of components 1. Google API Frontend (NAGIOS-monitored sites over a map display): ----------------------------------------------------------------------------------------------The GoogleMaps frontend scripts are based on examples provided in the API tutorial, and modified to display sites stored in a mysql database table. The scripts draw individual sites with markers coloured blue or red depending on whether the site is up or down, and also links (representing WAN links) between sites defined by two GPS end-points.
2. Node and Link Editing Interface (so users can edit WAN links and site markers)
-----------------------------------------------------------------------------------------------------------PHP scripts provide an interface to define single nodes on a map, which represent sites monitored by NAGIOS, and also WAN links between two sites that have been defined. Basically, the scripts allow you to enter site details and GPS coordinates into a database table, which the Google API
code will read and represent on the GoogleMap. 3. Database Backend (to hold site GPS coordinates and site status info): ---------------------------------------------------------------------------------------------Mysql database tables hold information defining a "site" on the map, i.e GPS coordinates, colour of the marker, name of the site and a short textual description of the site which will pop up on the map "on mouse-over ".
The GoogleMap frontend code reads these tables in order to draw links and individual sites. The tables are edited through a simple HTML/PHP frontend in order to define sites and links.
4. Site Marker update script (to update the status of site markers on the map according to NAGIOS alerts)
------------------------------------------------------------------------------------------------------------------------------------------NAGIOS sends alerts via email to an email alias on the web server, the alias is to a perl script which parses the email and updates the status of the site in the database table. Depending on the status of a site (UP/DOWN) the colour of the marker for a given site is changed between Blue and Red, and this will show up on the GoogleMap frontend.
Attached are the scripts that comprise the system, below is a description of how they're arranged in the file hierarchy on my web server:
Web front-end scripts: ----- trai...@sparklight:/var/www/maps/# ls -l -rw-r--r-- 1 root root 3921 2009-06-19 13:40 index.html -rw-r--r-- 1 root root 4950 2009-06-19 13:40 mapedit.php -rwxr-xr-x 1 root root 90 2009-06-19 13:40 phpsqlajax_dbinfo.php -rwxr-xr-x 1 root root 1277 2009-06-19 13:40 phpsqlajax_genxml_lines.php -rwxr-xr-x 1 root root 1238 2009-06-19 13:40 phpsqlajax_genxml.php -rwxr-xr-x 1 root root 1965 2009-06-19 13:40 store_link.php ---- Perl code and files to update the status of sites in the database ---- trai...@sparklight:/var/local/google_mapping# ls -la * -rw-rw-rw- 1 root staff 98222 2009-06-03 19:36 msg.log -rw-r--r-- 1 root staff 230 2009-02-09 15:33 sample.dat -rw-rw-rw- 1 root staff 773 2009-06-03 19:36 site_status.dat bin: total 12 drwxr-sr-x 2 root staff 4096 2009-02-09 15:38 . drwxrwsrwx 3 root staff 4096 2009-06-19 13:45 .. -rwxr-xr-x 1 root staff 2279 2009-02-09 15:38 update_marker_status.pl ---- Database schema and sample data: --- tables in the google mapping database ---- mysql> show tables; +--------------------------+ | Tables_in_google_mapping | +--------------------------+ | map_items | | map_links | | map_node_relations | | map_nodes | | markers | +--------------------------+ 5 rows in set (0.00 sec) --- map_items ----The map_items table holds items for a drop down list so the user can select the colour of a link when defining it through the interface:
mysql> describe map_items; +-------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | link_colour | varchar(255) | NO | | #FF0000 | | | link_width | int(16) | NO | | 3 | | +-------------+--------------+------+-----+---------+----------------+ 3 rows in set (0.00 sec) mysql> select * from map_items; +----+-------------+------------+ | id | link_colour | link_width | +----+-------------+------------+ | 1 | #FFFFFF | 1 | | 2 | #FFF200 | 2 | | 3 | #00FF00 | 3 | | 4 | #FF5F00 | 4 | +----+-------------+------------+ 4 rows in set (0.00 sec) --- map_links ----The map_links table holds the coordinate information required for the GoogleMap API to draw a link. The coords are taken from sites that have already been defined in the "markers" table.
mysql> describe map_links; +--------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | link_id | varchar(255) | NO | | UNKNOWN | | | link_parent | int(16) | NO | | 0 | | | parent_coord | varchar(255) | NO | | UNKNOWN | | | link_child | int(16) | NO | | 0 | | | child_coord | varchar(255) | NO | | UNKNOWN | | | link_state | varchar(255) | NO | | UP | | | link_desc | varchar(255) | NO | | UNKNOWN | | | link_colour | varchar(255) | NO | | #002A97 | | | link_width | int(16) | NO | | 3 | | +--------------+--------------+------+-----+---------+----------------+ 10 rows in set (0.00 sec) mysql> select * from map_links limit 1; +----+---------+-------------+----------------------+------------+----------------------+------------+------------------+-------------+------------+| id | link_id | link_parent | parent_coord | link_child | child_coord | link_state | link_desc | link_colour | link_width |
+----+---------+-------------+----------------------+------------+----------------------+------------+------------------+-------------+------------+| 7 | 85-44 | 85 | -29.134351,23.044633 | 44 | -24.193867,24.055133 | UP | SITE85-SITE44 Link | #002A97 | 3 |
+----+---------+-------------+----------------------+------------+----------------------+------------+------------------+-------------+------------+ 1 row in set (0.00 sec) --- markers ---The markers table holds details of each monitored site that will be required for the Googlemap API scripts to place site markers on the map. The details
are added via a simple PHP web form the users fill in: mysql> describe markers; +---------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------+-------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | name | varchar(60) | NO | | | | | address | varchar(80) | NO | | | | | lat | float(10,6) | NO | | | | | lng | float(10,6) | NO | | | | | type | varchar(30) | NO | | | | +---------+-------------+------+-----+---------+----------------+ 6 rows in set (0.01 sec) An example of a defined site (marker) in the table: mysql> select * from markers limit 1; +----+-------+----------------------------------------------------------------------------------+------------+-----------+------+ | id | name | address | lat | lng | type | +----+-------+----------------------------------------------------------------------------------+------------+-----------+------+| 1 | NUMC | University of Lalaland, Primary PABX Room | -24.887315 | 45.985916| UP |
+----+-------+----------------------------------------------------------------------------------+------------+-----------+------+ 1 row in set (0.00 sec) Deocir Ribeiro Luz wrote:
Hi all, I'm new in this list, so I don't know if this was discussed here. I'm studing the API Google Maps with the objective of the integrate of the statusmaps of nagios with the Google Maps. I need do this, are there some person that did this here that can help me? Thanks Deocir Ribeiro Luz ------------------------------------------------------------------------------ Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimitedroyalty-free distribution of the report engine for externally facing server and web deployment.http://p.sf.net/sfu/businessobjects _______________________________________________ Nagios-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/nagios-users::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
google-mapping-documentation.tar.gz
Description: application/gzip
------------------------------------------------------------------------------ Are you an open source citizen? Join us for the Open Source Bridge conference! Portland, OR, June 17-19. Two days of sessions, one day of unconference: $250. Need another reason to go? 24-hour hacker lounge. Register today! http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebridge.org
_______________________________________________ Nagios-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
