search

shakedtom / mycheckpoint

Automatically exported from code.google.com/p/mycheckpoint
0 stars 1 forks source link

Graph are not present in reports #36

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1. With crontab each 5 minutes, generate mycheckpoint records from localmachine 
stored to remote database
mycheckpoint_r223.py --host=xxx.xxx.xxx.xxx --port=3306 --user=mycheckpoint 
--password=mycheckpoint --database=mcp_webprod --monitored-host=localhost 
--monitored-socket=/tmp/mysql.sock --verbose --debug
-- mycheckpoint rev 0, build 0. Copyright (c) 2009-2010 by Shlomi Noach
-- database is mcp_webprod
-- monitored host is: localhost
-- monitored host credentials undefined; using write host credentials
-- Global status & variables recorded
-- Master and slave status recorded
-- OS CPU info recorded
-- OS load average info recorded
-- OS mem info recorded
-- OS mountpoints info recorded
-- OS page io activity recorded
-- New entry added: id=252; ts=2012-06-13 11:05:16
-- Collecting custom data
-- 2012-06-13 11:05:16 Entry aggregated into status_variables_aggregated_hour
-- 2012-06-13 11:05:16 Entry aggregated into status_variables_aggregated_day
-- No alert conditions defined
-- Status variables checkpoint complete

2. Check that some datas are recorded in mcp_webprod database as wanted for 
more than 12 hours

3. On remote computer (host of remote database), with crontab each hour 
generate mycheckpoint reports in html manner and store it in apache web server 
space
mysql -umycheckpoint -pmycheckpoint mcp_webprod --execute="SELECT html FROM 
sv_report_html"       --silent --raw > /data/www/mycheckpoint/webprod.html
mysql -umycheckpoint -pmycheckpoint mcp_webprod --execute="SELECT html FROM 
sv_report_html_brief" --silent --raw > /data/www/mycheckpoint/webprod_brief.html
mysql -umycheckpoint -pmycheckpoint mcp_webprod --execute="SELECT *    FROM 
sv_param_change"      --silent --raw > 
/data/www/mycheckpoint/webprod_paramchange.html

4. Check that files are well generated
[dba@frlusv113 mycheckpoint]$ ll
-rwxrwx--- 1 webservd webservd 197682 Jun 13 10:53 webprod.html
-rwxrwx--- 1 webservd webservd 110227 Jun 13 10:53 webprod_brief.html
-rwxrwx--- 1 webservd webservd      0 Jun 13 10:53 webprod_paramchange.html
Note that webprod_paramchange.html file size is zero bytes because no parameter 
chage have occur since mycheckpoint is running ;)

5. Watch with your favorite browser (chrome 19.0 or firefox 13.0 for me) these 
generate html reports
Note that reports are well formatted but there is no graph in it, only empty 
gray boxes - see attached pdfs.

6. Click on [url] link (in my example innodb_buffer_pool_pages graph box)
It open a graph centric web page holding a single graph (from 
chart.apis.google.com). And graph is there  !!

What is the expected output? What do you see instead?
Generated web page full of graphics

What is the output when running with the "--verbose --debug" options?

What version of the mycheckpoint are you using?
r223

What version of the MySQL are you using? (SELECT VERSION())
Monitored database  : mysql> 5.5.16-log
Remote mcp database : mysql> 5.5.16-log

What version of Python are you using? (python --version)
Monitored database  : Python 2.4.3

On what operating system?
Both Linux RedHat 5 Enterprise

What is your sql_mode? (SELECT @@global.sql_mode)
Monitored database  :
mysql> SELECT @@global.sql_mode;
+-------------------+
| @@global.sql_mode |
+-------------------+
|                   |
+-------------------+
1 row in set (0.00 sec)

Remote mcp database :
mysql> SELECT @@global.sql_mode;
+-------------------------------------------------------------------------------
-------------------------------------------+
| @@global.sql_mode                                                             
                                           |
+-------------------------------------------------------------------------------
-------------------------------------------+
| 
NO_AUTO_VALUE_ON_ZERO,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO
_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+-------------------------------------------------------------------------------
-------------------------------------------+
1 row in set (0.00 sec)

Please provide any additional information below.
Please find attached pdfs:
 * mcp_webprod.monitoring_full report.pdf
 * mcp_webprod.monitoring_latest 24 hours report.pdf
 * mcp_webprod.monitoring_full report - innodb_buffer_pool_pages.pdf

Original issue reported on code.google.com by tda...@gmail.com on 13 Jun 2012 at 9:31

Attachments:

GoogleCodeExporter commented 8 years ago 
Please note that I have a second MySql monitored database witch is not so 
configuration different that work well
 * same data capture computer and crontab but monitored database is remote
 * same remote mcp database (just name change - mcp_webtest)
 * same html report generation computer and crontab
 * same mycheckpoint/mysql/python version

but reports are graph filled (except OS information but it's ok)

so why ??

Original comment by tda...@gmail.com on 13 Jun 2012 at 9:36

GoogleCodeExporter commented 8 years ago

Original comment by tda...@gmail.com on 13 Jun 2012 at 9:40

Attachments:

GoogleCodeExporter commented 8 years ago 
Found a difference between html report (mcp_webprod vs mcp_webtest)

ampersand are html substituted in mcp_webprod html report
I mean that, in html code, there is a lot (all in fact) '&' sign replaced by 
'&' htlm code

A simple global replace done with vi make the report usable

Original comment by tda...@gmail.com on 15 Jun 2012 at 9:14

GoogleCodeExporter commented 8 years ago 
Both data gather are triggered from the same crontab:

*/5 * * * * mycheckpoint_r223.py --host=xxx.xxx.xxx.xxx --port=3306 
--user=mycheckpoint --password=mycheckpoint --database=mcp_webprod 
--monitored-host=localhost    --monitored-socket=/tmp/mysql.sock
*/5 * * * * mycheckpoint_r223.py --host=xxx.xxx.xxx.xxx --port=3306 
--user=mycheckpoint --password=mycheckpoint --database=mcp_webtest 
--monitored-host=yyy.yyy.yyy.yyy --monitored-socket=/tmp/mysql.sock

Data are stored on same mysql server, anyone can see a difference between these 
two crontab entry that can justify different beaviour in html report ?

Original comment by tda...@gmail.com on 15 Jun 2012 at 9:17

GoogleCodeExporter commented 8 years ago 
All reports are ok with this :

00 * * * * /opt/mysql/bin/mysql -umycheckpoint -pmycheckpoint mcp_webprod 
--execute="SELECT html FROM sv_report_html"       --silent --raw | sed 
"s/\&/\&/g" > /data/www/dsi_tools/mycheckpoint/webprod.html
01 * * * * /opt/mysql/bin/mysql -umycheckpoint -pmycheckpoint mcp_webprod 
--execute="SELECT html FROM sv_report_html_brief" --silent --raw | sed 
"s/\&/\&/g" > /data/www/dsi_tools/mycheckpoint/webprod_brief.html

Original comment by tda...@gmail.com on 15 Jun 2012 at 9:29