|
|
| Author |
Message |
mandrk
Joined: 12 May 2005
Posts: 21
Location: Romania
|
 Posted: Wed Jul 02, 2008 5:57 am Post subject: Cacti Version 0.8.7b |
 |
|
In this version i can't monitor trafic from my NIC linux machine.
If i change the version with old one everything is ok.
I use snmp version 2.
In Associated Data Queries (see atachments)
1) SNMP - Interface Statistics (Verbose Query) Uptime Goes Backwards Success [27 Items, 4 Rows] .
but when i want to create a graf for traffic interface.
in Data Query [SNMP - Interface Statistics] This data query returned 0 rows, perhaps there was a problem executing this data query. You can run this data query in debug mode to get more information.
What is new and must be changed
I try with 2 old version of cacti 0.8.6j and 0.8.6h. Is ok i can select my NIC to create grafic.
In this version i don't have a list with interfaces
| Description: |
|
| Filesize: |
34.27 KB |
| Viewed: |
1719 Time(s) |
|
| Description: |
|
| Filesize: |
27.21 KB |
| Viewed: |
1719 Time(s) |
|
|
|
| Back to top |
|
 |
pedro_69
Joined: 06 Apr 2008
Posts: 2
|
| Posted: Tue Aug 05, 2008 8:08 am Post subject: |
|
|
What MySQL version do you have? I've just solved similar problem in one of my Cacti installations, which is using old MySQL (ver. 3.23.58). It turned out that graphs_new.php uses "CAST()" function, which was apparently implemented in some later version of MySQL. This caused syntax error in SQL statment, and 0 rows returned.
So I've simply changed | Code: | | $sql_order = "ORDER BY CAST(snmp_index AS unsigned)"; |
to | Code: | | $sql_order = "ORDER BY snmp_index"; |
in line 716, and problem disappeared.
|
|
| Back to top |
|
|
mandrk
Joined: 12 May 2005
Posts: 21
Location: Romania
|
| Posted: Tue Aug 05, 2008 8:21 am Post subject: |
|
|
Confirm!
Problem solved!
|
|
| Back to top |
|
|
BSOD2600
Cacti Moderator
Joined: 08 May 2004
Posts: 6789
Location: WA, USA
|
| Posted: Tue Aug 05, 2008 5:33 pm Post subject: |
|
|
| These problems are probably moot since the current version is 0.7.8b...
|
|
| Back to top |
|
|
pedro_69
Joined: 06 Apr 2008
Posts: 2
|
| Posted: Wed Aug 06, 2008 7:30 am Post subject: |
|
|
In fact this problem was introduced in 0.8.7a with usage of CAST() function, which is done without checking MySQL version. In Cacti 0.8.6 CAST() is not used, so there is no problem even with old MySQL.
From http://dev.mysql.com/doc/refman/4.1/en/cast-functions.html:
| Quote: | | CAST() and CONVERT() are available as of MySQL 4.0.2. |
Maybe worth some patch, but I don't know much about MySQL, and if CAST() can be simulated in earlier versions.
|
|
| Back to top |
|
|
BSOD2600
Cacti Moderator
Joined: 08 May 2004
Posts: 6789
Location: WA, USA
|
| Posted: Wed Aug 06, 2008 8:52 pm Post subject: |
|
|
| Well I suppose it never hurts to submit a patch, http://www.cacti.net/bugs.php then leave it up to the devs if they want to include it.
|
|
| Back to top |
|
|
gandalf
Developer
Joined: 02 Dec 2004
Posts: 12275
Location: Muenster, Germany
|
| Posted: Mon Aug 11, 2008 1:41 pm Post subject: |
|
|
This defect is known. But we won't fix it, since we do no longer support mysql V3
Reinhard
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Register
Profile
Log in to check your private messages
Log in
