|
|
| Author |
Message |
toe_cutter
Joined: 12 Sep 2008
Posts: 9
Location: Sweden
|
|
| Back to top |
|
 |
browniebraun
Cacti User
Joined: 13 Jun 2006
Posts: 341
Location: Cologne, Germany
|
 Posted: Thu Nov 13, 2008 9:49 am Post subject: |
 |
|
It's a known bug within the rouding function. Please bear with me ...
I'm just working intensively on 0.7 where this bug no longer exists. Hopefully I can start with Beta testing soon, so that the next major release will be published this year. "Graidle" used for creating the charts also has big issues with negative values. 
A solution will be in 0.7 - without Graidle  .
Best regards
-Andreas-
|
|
| Back to top |
|
|
toe_cutter
Joined: 12 Sep 2008
Posts: 9
Location: Sweden
|
| Posted: Fri Nov 14, 2008 3:46 am Post subject: |
|
|
Aah, ok! Ill stop bugging you then until the beta, a new release is always awesome! 
|
|
| Back to top |
|
|
apperrault
Cacti User
Joined: 16 Feb 2007
Posts: 359
Location: Emeryville, CA
|
| Posted: Mon Nov 17, 2008 4:31 pm Post subject: |
|
|
Maybe i missed something, but i am having problems installing this plugin. I have downloaded it from Sourceforge, expanded it, put it in the plugins directory, and edited the Global.php.
I added the permissions for my user to use the utility, and i am trying to now create a Report Template, but after typing all of the information in (i am trying to generate a Disk Space report, i click save, and it clears the data from the screen, but doesn't create anything. If i go to the Cacti log i see the following:
| Code: | 11/17/2008 01:26:21 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM reportit_templates ORDER BY id ASC LIMIT 0,30"
11/17/2008 01:26:21 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(reportit_templates.id) FROM reportit_templates"
11/17/2008 01:26:18 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT a.*, b.description AS template_description, c.username, b.locked FROM reportit_reports AS a LEFT JOIN reportit_templates AS b ON b.id = a.template_id LEFT JOIN user_auth AS c ON c.id = a.user_id WHERE a.description like '%' ORDER BY id ASC LIMIT 0,30"
11/17/2008 01:26:18 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(a.id) FROM reportit_reports AS a WHERE a.description like '%'"
11/17/2008 01:26:18 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT DISTINCT b.id, b.description FROM reportit_reports AS a INNER JOIN reportit_templates AS b ON b.id = a.template_id"
11/17/2008 01:26:18 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT DISTINCT a.user_id as id, c.username FROM reportit_reports AS a LEFT JOIN reportit_templates AS b ON b.id = a.template_id LEFT JOIN user_auth AS c ON c.id = a.user_id ORDER BY c.username"
11/17/2008 01:26:17 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM reportit_templates WHERE locked = 0"
11/17/2008 01:26:16 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT id, description FROM reportit_templates WHERE locked=0"
11/17/2008 01:26:16 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM reportit_templates WHERE locked = 0"
11/17/2008 01:26:14 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT a.*, b.description AS template_description, c.username, b.locked FROM reportit_reports AS a LEFT JOIN reportit_templates AS b ON b.id = a.template_id LEFT JOIN user_auth AS c ON c.id = a.user_id WHERE a.description like '%' ORDER BY id ASC LIMIT 0,30"
11/17/2008 01:26:14 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(a.id) FROM reportit_reports AS a WHERE a.description like '%'"
11/17/2008 01:26:14 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT DISTINCT b.id, b.description FROM reportit_reports AS a INNER JOIN reportit_templates AS b ON b.id = a.template_id"
11/17/2008 01:26:14 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT DISTINCT a.user_id as id, c.username FROM reportit_reports AS a LEFT JOIN reportit_templates AS b ON b.id = a.template_id LEFT JOIN user_auth AS c ON c.id = a.user_id ORDER BY c.username"
11/17/2008 01:26:14 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM reportit_templates WHERE locked = 0"
11/17/2008 01:26:06 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM reportit_templates ORDER BY id ASC LIMIT 0,30"
11/17/2008 01:26:06 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(reportit_templates.id) FROM reportit_templates" |
I have verified that there are indeed what look to be Reportit tables in the database, but other than that, i dont see anything else.
Any assistance would be greatly appreciated.
app
|
|
| Back to top |
|
|
browniebraun
Cacti User
Joined: 13 Jun 2006
Posts: 341
Location: Cologne, Germany
|
| Posted: Mon Nov 17, 2008 6:23 pm Post subject: |
|
|
ReportIt requires MySQL 5.0.3 or above. If you want to use it with 4.x then you have to download a patch first, which contains all files that have to be replaced.
Best regards
-Andreas-
|
|
| Back to top |
|
|
jmb
Joined: 29 Jul 2008
Posts: 6
|
| Posted: Wed Nov 19, 2008 7:21 am Post subject: data item list truncation (ds_description) |
|
|
I'm trying to produce reports based on a data template with 40-odd data items. The report runs and gives a table with 15 1/2 of the measurand columns (the 1/2 being a truncated data item name and "NA" for value). No error messages are generated.
It looks as though this list is being truncated because the MySQL column ds_description in reportit_reports is only VARCHAR(255). SELECTing from it shows a string like item1|item2|item3|... truncated at the same point in the item name as visible in the report. Perhaps this is not the best model to store this information?
What I'd really like to do is wrap these onto multiple lines - just having my measurands across the page. Perhaps that's just a matter of layout that I could tweak in the generation code.
| Description: |
|
| Filesize: |
29.95 KB |
| Viewed: |
710 Time(s) |
|
| Description: |
|
| Filesize: |
6.79 KB |
| Viewed: |
710 Time(s) |
|
|
|
| Back to top |
|
|
bonbon
Joined: 07 Sep 2006
Posts: 6
Location: Minneapolis, MN
|
| Posted: Wed Dec 03, 2008 6:27 pm Post subject: |
|
|
| browniebraun wrote: |
From my point of view a 'just add ALL of these' - button will invite users to create reports without thinking about what they are doing.
Please note that a single CPU Core will come under stress during the calculation process.
Best regards
-Andreas- |
I second this request by Howie. It would be great to be able to run reports from the web interface based on the data item presets because our interfaces change often and it's very time consuming to keep them up to date by individual data items.
Even better would be able to filter the report by graph tree or by manage plugin sites & groups.
( p.s. kudos on this plugin, its very good )
|
|
| Back to top |
|
|
browniebraun
Cacti User
Joined: 13 Jun 2006
Posts: 341
Location: Cologne, Germany
|
| Posted: Thu Dec 04, 2008 1:48 pm Post subject: Re: data item list truncation (ds_description) |
|
|
| jmb wrote: | I'm trying to produce reports based on a data template with 40-odd data items. The report runs and gives a table with 15 1/2 of the measurand columns (the 1/2 being a truncated data item name and "NA" for value). No error messages are generated.
It looks as though this list is being truncated because the MySQL column ds_description in reportit_reports is only VARCHAR(255). SELECTing from it shows a string like item1|item2|item3|... truncated at the same point in the item name as visible in the report. Perhaps this is not the best model to store this information?
What I'd really like to do is wrap these onto multiple lines - just having my measurands across the page. Perhaps that's just a matter of layout that I could tweak in the generation code. |
Sorry for my late reply, but I was on vacation and spent some time with my family.
You're absolutely right. The string will be truncated and it isn't the best way to save that data. But I never expected a data template with so many data sources.
Currently I'm working on a solution to select the data source items separately within a report template.
Best regards
-Andreas-
|
|
| Back to top |
|
|
browniebraun
Cacti User
Joined: 13 Jun 2006
Posts: 341
Location: Cologne, Germany
|
| Posted: Thu Dec 04, 2008 2:00 pm Post subject: |
|
|
| bonbon wrote: | | browniebraun wrote: |
From my point of view a 'just add ALL of these' - button will invite users to create reports without thinking about what they are doing.
Please note that a single CPU Core will come under stress during the calculation process.
Best regards
-Andreas- |
I second this request by Howie. It would be great to be able to run reports from the web interface based on the data item presets because our interfaces change often and it's very time consuming to keep them up to date by individual data items.
Even better would be able to filter the report by graph tree or by manage plugin sites & groups.
( p.s. kudos on this plugin, its very good ) |
Honestly I wanted to implement all graph policies in v0.6, but I struggled with the option "Graph Permissions (By Graph)", so that I reduced it to "By Device".
I'll check if it's possible to implement the tree permissions without getting headaches.
Best regards
-Andreas-
|
|
| Back to top |
|
|
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Register
Profile
Log in to check your private messages
Log in
) the trend analysis for the f_grd example on a update news post on a page further back.
