Larry Adams | 1 Oct 2008 01:25
Picon
Gravatar

Re: dual cacti servers with db replication

In your case, I agree with Tony, dual pollers all the way. IMHO.

Larry

Tony Roman wrote:
> Well....
>
> There are many options to have a fully redundant Cacti environment.  I 
> personally have setup a few.
>
> If you are in an HA environment with a shared disk for the RRD's and 
> database, then a simple failover script to startup the database and 
> start polling is your best bet.
>
> But, if you can't afford or don't have the knowledge to configure a HA 
> environment, there are alternatives.
>
> It's actually pretty simple to setup replication of the Cacti database 
> in mySQL.  It's important to note that on larger installations, copying 
> or rsyncing the RRD files can be very costly and running dual pollers is 
> a suggested alternative.  But, if you are going to dual pollers, it's 
> important to exclude certain poller related tables from replication.
>
> When setting up replication, it's important to exclude the following 
> tables, so that the pollers can function independently of each other.
>
>    poller_output
>    poller_command
>    poller_reindex
>
(Continue reading)

andys | 1 Oct 2008 12:59
Favicon

Re: dual cacti servers with db replication

Hi all, 

  thanks for all the comments. 

For me also the dual poller is a much better solution than HA as its simpler 
and requires no changes in the even of a failure of one or other system, and 
neither any expesive hardware. 

So in order to exclude the tables as advised by Tony I will put the 
following into the my.cnf on my slave mysql server: 

replicate-ignore-table=cacti.poller_output
replicate-ignore-table=cacti.poller_command
replicate-ignore-table=cacti.poller_reindex 

and make the slave db read-write and after that I believe it should work 
based on the info from you guys?? 

sound ok?? 

cheers Andy.

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
Patrick Topping | 2 Oct 2008 19:19

Issues with poller running

I have just installed cacti 0.8.7b.  When I run the poller I get the
following error:

10/02/2008 10:15:14 AM - POLLER: Poller[0] NOTE: Poller Int: '300', Cron
Int: '300', Time Since Last: '13', Max Runtime '298', Poller Runs: '1'
10/02/2008 10:15:14 AM - POLLER: Poller[0] NOTE: Cron is configured to
run too often!  The Poller Interval is '300' seconds, with a minimum
Cron period of '300' seconds, but only 13 seconds have passed since the
poller last ran.

I have checked the settings under the poller and both the polling
interval and the cron interval are both set to 5 minutes.  Below is what
my crontab looks like:

*/5 * * * * php /var/www/cacti/poller.php > /dev/null 2>&1

This is being run as the cactiuser.  Any help would be greatly
appreciated.  Thanks in advance.

-Patrick

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
Dutton, Larry | 2 Oct 2008 20:10
Picon

Re: Issues with poller running

Hello,

All I can offer is that I also saw this issue in the past - turn logging up and check out how long a complete poll
takes - my problem was some script issue that made the poller over-run - could be that your poll is taking 313
seconds, it shouldn't and is supposed to timeout at 298 but the problem with mine seemed to be caused by
something outside of the poller (if that makes sense)

IIRC I resolved mine by firstly finding out which script was causing the delays (it was the localhost
monitoring for me), so disabled various hosts until a significant increase in polling occurred and
pointed to the problem

HTH

Larry 

**********************************************************************
Did You Know? Redstone provides the latest mobile voice, data and Blackberry solutions tailored to suit
your needs and budget. 

Save money now - Send us your current mobile bill and see how much we can save you. 

Alternatively try our USB Mobile Broadband  <at>  only ?22.50 per month with unlimited UK data access including
7.2Mbps Dongle. (subject to fair usage policy) 

Call Redstone Mobile now on 0800 015 7626

**********************************************************************

DISCLAIMER:
This correspondence may contain information which is confidential or proprietary or both.  Any
(Continue reading)

Larry Adams | 3 Oct 2008 17:38
Picon
Gravatar

Re: Issues with poller running

You can also disable polling one Data Template at a time.  If you edit 
the script based Data Templates, there is an "Enable" flag.  Uncheck it 
and save the Data Template and the Polling will be stoped on that one.

WARNING WARNING!!!!!

Do not do this to Data Query based Data Templates with Cacti < 0.8.7c, 
our you risk breaking ALL your Data Query graphs.  There is a MAJOR bug 
in Cacti from back to the 0.8.6 bugs that was recently resolved!!!!!

WARNING WARNING!!!!!

Dutton, Larry wrote:
> Hello,
>
> All I can offer is that I also saw this issue in the past - turn logging up and check out how long a complete poll
takes - my problem was some script issue that made the poller over-run - could be that your poll is taking 313
seconds, it shouldn't and is supposed to timeout at 298 but the problem with mine seemed to be caused by
something outside of the poller (if that makes sense)
>
> IIRC I resolved mine by firstly finding out which script was causing the delays (it was the localhost
monitoring for me), so disabled various hosts until a significant increase in polling occurred and
pointed to the problem
>
> HTH
>
> Larry 
>  
> **********************************************************************
> Did You Know? Redstone provides the latest mobile voice, data and Blackberry solutions tailored to suit
(Continue reading)

Ceylan, Hasan | 3 Oct 2008 22:12
Picon
Favicon

Re: Spine version 0.8.7c-beta1

Did new version of Spine come out yet?

-----Original Message-----
From: Larry Adams [mailto:larryjadams <at> comcast.net] 
Sent: Thursday, September 25, 2008 8:57 PM
To: Support requests/questions about cacti
Subject: Re: [cacti-user] Spine version 0.8.7c-beta1

Which OS are you interested in?

Ceylan, Hasan wrote:
> Where can I get the binary version of 0.8.7c-beta1?
>
>
------------------------------------------------------------------------
-
> This SF.Net email is sponsored by the Moblin Your Move Developer's
challenge
> Build the coolest Linux based applications with Moblin SDK & win great
prizes
> Grand prize is a trip for two to an Open Source event anywhere in the
world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> cacti-user mailing list
> cacti-user <at> lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/cacti-user
>
>   

(Continue reading)

Reinhard Scheck | 4 Oct 2008 21:15
Picon

Re: auto creation of databases for custom data sources

Currently, there is no such function available.
But there are a lot of cli scripts, e.g. to generate a graph (including all
required data sources); so you may do so on your own

Reinhard

Rob Shepherd wrote:
> Dear Cacti users,
> 
> I'm evaluating cacti for use in a data centre environment.
> 
> I have a device with some custom monitoring software, essentially like 
> measuring interface traffic but for throughput queues.
> 
> Each time a new queue is made, a new entity for 
> monitoring/logging/graphing is presented.
> 
> I imagine I can write a custom collector (pardon the cricket 
> terminology) for this type of data, nevertheless is there a hook/script 
> in cacti which means the new
> data sources can be introduced?
> 
> so the device may start with 5 queues and then I might add others and 
> unspecified times in the future,
> I would like cacti to automagically witness the additions somehow and 
> create relevant resources.
> 
> I've seen the discover script, but this looks for extra devices.  I only 
> have one device, but the things to be measured on it will increase over 
> time.
(Continue reading)

Melanie Pfefer | 3 Oct 2008 12:18
Picon
Favicon

query cactidb

How to add a new user that can login to mysql and query cactidb database?

Thank you

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
Larry Adams | 4 Oct 2008 02:01
Picon
Gravatar

Re: Spine version 0.8.7c-beta1

No.  We have a slight delay...  Well more than slight.  Kicking the cat 
real soon.  Spine's all ready to go though.

TheWitness

Ceylan, Hasan wrote:
> Did new version of Spine come out yet?
>
> -----Original Message-----
> From: Larry Adams [mailto:larryjadams <at> comcast.net] 
> Sent: Thursday, September 25, 2008 8:57 PM
> To: Support requests/questions about cacti
> Subject: Re: [cacti-user] Spine version 0.8.7c-beta1
>
> Which OS are you interested in?
>
> Ceylan, Hasan wrote:
>   
>> Where can I get the binary version of 0.8.7c-beta1?
>>
>>
>>     
> ------------------------------------------------------------------------
> -
>   
>> This SF.Net email is sponsored by the Moblin Your Move Developer's
>>     
> challenge
>   
>> Build the coolest Linux based applications with Moblin SDK & win great
(Continue reading)

Melanie Pfefer | 4 Oct 2008 06:21
Picon
Favicon

mysql and cacti

Hello,

Is it possible to query cactidb database from mysql directly instead of seeing the graphs?

thank you,

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

Gmane