HowTo get the latest Data?

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
kjh
Posts: 14
Joined: Wed Jan 18, 2006 2:50 am

HowTo get the latest Data?

Post by kjh »

Dear all,

is there a way to get the current data of a specific Host and Graph? In the Cacti MySQL Database I can not find any Data. Can anyone tell me the way to get these data, please?

Thank you in advance!

kjh
tgk
Posts: 28
Joined: Sat Mar 11, 2006 10:46 pm

Post by tgk »

The data is not kept in the database, but in RRD files (those in the /rra folder). To grab data directly from the rrd files, try rrdfetch:
http://people.ee.ethz.ch/~oetiker/webto ... ch.en.html
kjh
Posts: 14
Joined: Wed Jan 18, 2006 2:50 am

Post by kjh »

Thank you for your answer!

I get the Error: "ERROR: can't handle RRD file version 0003"

My RRD Too Version is 1.0.46. Any idea?
User avatar
fmangeant
Cacti Guru User
Posts: 2345
Joined: Fri Sep 19, 2003 8:36 am
Location: Sophia-Antipolis, France
Contact:

Post by fmangeant »

Hi

it seems you created some files with RRDtool 1.2 (RRD version 3), and that you try to read them with RRDtool 1.0 (RRD version 1) ?
[size=84]
[color=green]HOWTOs[/color] :
[list][*][url=http://forums.cacti.net/viewtopic.php?t=15353]Install and configure the Net-SNMP agent for Unix[/url]
[*][url=http://forums.cacti.net/viewtopic.php?t=26151]Install and configure the Net-SNMP agent for Windows[/url]
[*][url=http://forums.cacti.net/viewtopic.php?t=28175]Graph multiple servers using an SNMP proxy[/url][/list]
[color=green]Templates[/color] :
[list][*][url=http://forums.cacti.net/viewtopic.php?t=15412]Multiple CPU usage for Linux[/url]
[*][url=http://forums.cacti.net/viewtopic.php?p=125152]Memory & swap usage for Unix[/url][/list][/size]
kjh
Posts: 14
Joined: Wed Jan 18, 2006 2:50 am

Post by kjh »

yes right.

I configured in Cacti that I have RRDtool 1.2 installed and in Cacti self anything looks fine. But when I use the RRDtool on the command line, this failure appears. Do you think there are any problems with the allready saved graphdata, when I update the RRDtool now?

Thank you for your help!!!
User avatar
fmangeant
Cacti Guru User
Posts: 2345
Joined: Fri Sep 19, 2003 8:36 am
Location: Sophia-Antipolis, France
Contact:

Post by fmangeant »

It seems you have 2 versions of RRDtool installed.

How did you install it ?
[size=84]
[color=green]HOWTOs[/color] :
[list][*][url=http://forums.cacti.net/viewtopic.php?t=15353]Install and configure the Net-SNMP agent for Unix[/url]
[*][url=http://forums.cacti.net/viewtopic.php?t=26151]Install and configure the Net-SNMP agent for Windows[/url]
[*][url=http://forums.cacti.net/viewtopic.php?t=28175]Graph multiple servers using an SNMP proxy[/url][/list]
[color=green]Templates[/color] :
[list][*][url=http://forums.cacti.net/viewtopic.php?t=15412]Multiple CPU usage for Linux[/url]
[*][url=http://forums.cacti.net/viewtopic.php?p=125152]Memory & swap usage for Unix[/url][/list][/size]
kjh
Posts: 14
Joined: Wed Jan 18, 2006 2:50 am

Post by kjh »

The RRDtool was preinstalled by Sles9.

Edit: Now I looked in the Cactisettings. Cacti referred to /bin/rrdtool (V 1.2).
It looks like, that the shel use the rrdtool in /usr/bin/rrdtool. I think thats the problem. Do you know, how i can use the /bin/rrdtool on the shell?
User avatar
fmangeant
Cacti Guru User
Posts: 2345
Joined: Fri Sep 19, 2003 8:36 am
Location: Sophia-Antipolis, France
Contact:

Post by fmangeant »

Try to change your PATH environnement variable (in your .bash_profile, for example).

What gives this command :

Code: Select all

$ whereis rrdtool
[size=84]
[color=green]HOWTOs[/color] :
[list][*][url=http://forums.cacti.net/viewtopic.php?t=15353]Install and configure the Net-SNMP agent for Unix[/url]
[*][url=http://forums.cacti.net/viewtopic.php?t=26151]Install and configure the Net-SNMP agent for Windows[/url]
[*][url=http://forums.cacti.net/viewtopic.php?t=28175]Graph multiple servers using an SNMP proxy[/url][/list]
[color=green]Templates[/color] :
[list][*][url=http://forums.cacti.net/viewtopic.php?t=15412]Multiple CPU usage for Linux[/url]
[*][url=http://forums.cacti.net/viewtopic.php?p=125152]Memory & swap usage for Unix[/url][/list][/size]
melchandra
Cacti User
Posts: 311
Joined: Tue Jun 29, 2004 12:52 pm
Location: Indiana

Post by melchandra »

linux searches the path variable for directories in which to locate a command you type.

So if your path is set to "/usr/bin,/usr/local/bin/", and you type "rrdtool" at the command line, linux is going to try first /usr/bin/rrdtool, and then /usr/local/bin/rrdtool.

So, you can either change your path variable, or just use the full path with the command. So instead of typing "rrdtool", you would type "/usr/bin/rrdtool".

You can view your path variable with the command "echo $PATH"
You can temporarly set your path variable with the command "export PATH=<path>" although be careful, if you mess up your path this way you may have to log out and log back in to get it back.

To permanantly change your path you can add the export command to your .bashrc file, or change the PATH creation in your .bash_profile, both of which should be in your home directory.

Remember if you mess up your path, you can still execute commands, you will just have to use the full pathname.
Dave
kjh
Posts: 14
Joined: Wed Jan 18, 2006 2:50 am

Post by kjh »

Thank you very much, both!!!

But I have no Idea who installed the second one. Whatever, now it works! :D
kjh
Posts: 14
Joined: Wed Jan 18, 2006 2:50 am

Post by kjh »

Another problem that I got with this now: When I ask about the last entery I get for example a Load of 7.6462666667e-01. What kind of number is that? Cacti displays 0.00

Thank for your Help!!!
User avatar
fmangeant
Cacti Guru User
Posts: 2345
Joined: Fri Sep 19, 2003 8:36 am
Location: Sophia-Antipolis, France
Contact:

Post by fmangeant »

7.6462666667e-01 should be 0.7646
[size=84]
[color=green]HOWTOs[/color] :
[list][*][url=http://forums.cacti.net/viewtopic.php?t=15353]Install and configure the Net-SNMP agent for Unix[/url]
[*][url=http://forums.cacti.net/viewtopic.php?t=26151]Install and configure the Net-SNMP agent for Windows[/url]
[*][url=http://forums.cacti.net/viewtopic.php?t=28175]Graph multiple servers using an SNMP proxy[/url][/list]
[color=green]Templates[/color] :
[list][*][url=http://forums.cacti.net/viewtopic.php?t=15412]Multiple CPU usage for Linux[/url]
[*][url=http://forums.cacti.net/viewtopic.php?p=125152]Memory & swap usage for Unix[/url][/list][/size]
melchandra
Cacti User
Posts: 311
Joined: Tue Jun 29, 2004 12:52 pm
Location: Indiana

Post by melchandra »

kjh wrote:7.6462666667e-01.
This is known as "scientific notation". Google it if you want.

Basically take the number after the "e" and move the decimal point that many places. Since the number is negative, you move the decimal point to the lefft. So this really means 0.76462666667.
Dave
kjh
Posts: 14
Joined: Wed Jan 18, 2006 2:50 am

Post by kjh »

I see and would like say another time thank you all for your excellent help!

kjh
Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests