Never mind, I figured it out. I misread your post the first time. Thank you for the information. Everything is working now.
Thanks, Joe From: [email protected] [mailto:[email protected]] On Behalf Of Joe Goldberg Sent: Monday, March 29, 2010 12:18 PM To: Opsview Users Subject: Re: [opsview-users] issue with scheduled reports I'm not sure I am understanding your fix. When I create a monthly report I have only one selection option on the pull down, it is "Production". I can't find a reference to that anywhere else. I suspect this is the root of my issue but I am unsure how to resolve it. Thanks, Joe From: [email protected] [mailto:[email protected]] On Behalf Of Raffaello Poltronieri - Eutelia SpA Sent: Monday, March 29, 2010 11:42 AM To: [email protected] Subject: Re: [opsview-users] issue with scheduled reports Solved - at least for me: to have a scheduled report, you must define a selection. When you select a group, typing on the right side of the template, the application displays the possibilities: choose one of them instead of writing the whole group by hand. Raffaello Il 29/03/2010 17.34, Raffaello Poltronieri - Eutelia SpA ha scritto: Same for me: weekly - OK, monthly -not. Maybe misunderstanding on hostgroups name? Seems like keywords are working, but not hostgroups name... Thanks Raffaello Il 29/03/2010 17.29, Joe Goldberg ha scritto: I am seeing a similar thing. My canned weekly report for keyword Opsview is working flawlessly but the monthly report has no data in it. Any insight would be appreciated. Thanks, Joe -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Monday, March 29, 2010 2:13 AM To: [email protected] Subject: Re: [opsview-users] issue with scheduled reports Thanks for a fast response to this issue! Now openJDK seems to work! Kind of.... When running monthly report (./run_opsview_report -N 6 -S 2010-02 -f /tmp/miau.pdf -t generic_availability), the script starts looping and never ends... 2441 [main] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource 2441 [main] DEBUG org.springframework.jdbc.datasource.DriverManagerDataSource - Creating new JDBC Connection to [jdbc:mysql://localhost/odw] 2457 [main] DEBUG org.springframework.jdbc.core.StatementCreatorUtils - Setting SQL statement parameter value: column index 1, parameter value [Mon Feb 01 00:00:00 CET 2010], value class [java.util.Date], SQL type unknown 2497 [main] DEBUG org.springframework.jdbc.core.StatementCreatorUtils - Setting SQL statement parameter value: column index 2, parameter value [Sun Feb 28 22:59:59 CET 2010], value class [java.util.Date], SQL type unknown 2497 [main] DEBUG org.springframework.jdbc.core.StatementCreatorUtils - Setting SQL statement parameter value: column index 3, parameter value [00:00:00], value class [java.lang.String], SQL type unknown 2497 [main] DEBUG org.springframework.jdbc.core.StatementCreatorUtils - Setting SQL statement parameter value: column index 4, parameter value [23:59:59], value class [java.lang.String], SQL type unknown 36610 [main] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource 36612 [main] DEBUG org.springframework.jdbc.core.JdbcTemplate - Executing prepared SQL query 36612 [main] DEBUG org.springframework.jdbc.core.JdbcTemplate - Executing prepared SQL statement [SELECT hostgroup FROM reports.reports, reports.selectionhostgroups WHERE reports.reports.selection = reports.selectionhostgroups.selection and reports.reports.id = ?] 36612 [main] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource 36612 [main] DEBUG org.springframework.jdbc.datasource.DriverManagerDataSource - Creating new JDBC Connection to [jdbc:mysql://localhost/reports] 36625 [main] DEBUG org.springframework.jdbc.core.StatementCreatorUtils - Setting SQL statement parameter value: column index 1, parameter value [6], value class [java.lang.Integer], SQL type unknown 36626 [main] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource 36629 [main] DEBUG org.springframework.jdbc.core.JdbcTemplate - Executing prepared SQL query 36629 [main] DEBUG org.springframework.jdbc.core.JdbcTemplate - Executing prepared SQL statement [SELECT date(CONVERT_TZ(start_datetime,'+00:00','SYSTEM')) Date, sum(seconds_ok)/sum(seconds_ok+seconds_not_ok)*100 availability FROM service_availability_hourly_summary, servicechecks, hosts WHERE CONVERT_TZ(start_datetime,'+00:00','SYSTEM') BETWEEN ? and ? and service_availability_hourly_summary.servicecheck = servicechecks.id and hosts.id = servicechecks.host and time(CONVERT_TZ(start_datetime,'+00:00','SYSTEM')) BETWEEN ? and ? and hosts.hostgroup IN (' UNIX hosts ')GROUP BY Date ORDER BY Date] 36630 [main] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource 36630 [main] DEBUG org.springframework.jdbc.datasource.DriverManagerDataSource - Creating new JDBC Connection to [jdbc:mysql://localhost/odw] 36641 [main] DEBUG org.springframework.jdbc.core.StatementCreatorUtils - Setting SQL statement parameter value: column index 1, parameter value [2009-11-01 00:00:00], value class [java.lang.String], SQL type unknown 36641 [main] DEBUG org.springframework.jdbc.core.StatementCreatorUtils - Setting SQL statement parameter value: column index 2, parameter value [2010-02-28 23:59:59], value class [java.lang.String], SQL type unknown 36641 [main] DEBUG org.springframework.jdbc.core.StatementCreatorUtils - Setting SQL statement parameter value: column index 3, parameter value [00:00:00], value class [java.lang.String], SQL type unknown 36641 [main] DEBUG org.springframework.jdbc.core.StatementCreatorUtils - Setting SQL statement parameter value: column index 4, parameter value [23:59:59], value class [java.lang.String], SQL type unknown However, with weekly reports (./run_opsview_report -N 7 -S 2010-02-01 -f /tmp/miau.pdf -t generic_availability) it succeeds but no data exists in PDF report: No summary data found for report period. No data found for module 'Weekly Availability Summary' No data found for module 'Weekly Availability Summary Table' Etc... This is the same for SUN and openJDK. It was like that even before Opsview-reports upgrade on sunJDK. ODW seems to be fine, data is in there. Please let me know if you have any ideas... Regards, Rimvydas Sneideris -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Ton Voon Sent: Thursday, March 25, 2010 6:56 PM To: Opsview Users Subject: Re: [opsview-users] issue with scheduled reports On 24 Mar 2010, at 17:53, Ton Voon wrote: On 23 Mar 2010, at 18:52, Ton Voon wrote: We'll look into why openjdk doesn't work. After a lot of debugging, we've found the root cause of the problem for openjdk. One of the dependency libraries, FOP, raises an error because the colour profile was called "sRGB" but in openjdk it is called "sRGB built-in" and the code does not handle this difference. We've made a patch to this library and we're currently testing it. We expect to release a newer version of opsview-reports tomorrow morning (UK time) and will let you know when it is available. We've published a new version of opsview-reports now (2.2.3.255) for centos, rhel5, etch, lenny and hardy. This will fix the issue when run with openjdk. (Solaris is not updated as that uses sun's jre). Ton _______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users _______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users _______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users _______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
_______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
