Graph are not present in reports #36
Description
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:
- [mcp_webprod.monitoring_full report.pdf](https://storage.googleapis.com/google-code-attachments/mycheckpoint/issue-36/comment-0/mcp_webprod.monitoring_full report.pdf)
- [mcp_webprod.monitoring_full report - innodb_buffer_pool_pages.pdf](https://storage.googleapis.com/google-code-attachments/mycheckpoint/issue-36/comment-0/mcp_webprod.monitoring_full report - innodb_buffer_pool_pages.pdf)
- [mcp_webprod.monitoring_latest 24 hours report.pdf](https://storage.googleapis.com/google-code-attachments/mycheckpoint/issue-36/comment-0/mcp_webprod.monitoring_latest 24 hours report.pdf)