Boost Plugin v1.6 Released

Post by **TheWitness** » Fri Jan 26, 2007 8:55 pm

The PHP Socket module is required for this plugin as it is for Cacti itself.

TheWitness

kanada · Post by **kanada** » Sat Jan 27, 2007 11:38 am

I think now is all ok. Graphs not missing middle interval time.
I think there was problem with that socket in php.. Boost server not work like a daemon, and poller start it every 10 min.
Wired, couse startup script not determine a missing php module, he show start boost server without problems. Maybe in future a good idea will be to add some detect line to this script?

btw. Gandalf && TheWitness thsnks for your help and patience.. now i will implement Boost module to head cacti, resoults i will paste to forum.

Alex.

knobdy · Post by **knobdy** » Thu Feb 01, 2007 12:48 pm

Anyone else run into the following error when trying to import that database:

Code: Select all

ERROR 1163 (42000) at line 2: The used table type doesn't support BLOB/TEXT columns

knobdy · Post by **knobdy** » Thu Feb 01, 2007 3:01 pm

Beyond the sql error, once someone helps me past it are there any issues with copying the files in the "modified" directory after you've upgraded to the new plugin architecture?

Post by **TheWitness** » Thu Feb 01, 2007 7:16 pm

Boost requires MySQL 5.x.

TheWitness

Post by **TheWitness** » Thu Feb 01, 2007 8:59 pm

All,

I have released version 1.1 of the Plugin for your enjoyment. Please make sure you alway's test before installing in "production".

The major issue addressed in this version is for the Multiprocess RRDupdates.

TheWitness

Post by **gandalf** » Sat Feb 03, 2007 1:10 pm

Hi, Larry,

I re-created my plugin development environment. Now it's at level 0.8.6j with patches and plugin-arch V1.1. I installed the boost (there are only files in the main directory, now).
From "System Utilities", I tried the "View Boost Status" and nothing seems to happen. No error_log, no cacti.log entry (even with DEBUG level).

BTB: graph caching seems to be ok; this was the first function I've tested

Reinhard

dimitarnc · Post by **dimitarnc** » Tue Feb 20, 2007 5:27 am

Do I need to copy the files in 'modified' directory from the old version of Boost Plugin 1.0 if I have cacti 0.8.6j + PluginArch 1.1 + Boost 1.1 ?

Post by **TheWitness** » Tue Feb 20, 2007 6:15 am

Definately not. Once you have 0.8.6j + PIA 1.1, you only need to use the base files.

TheWitness

dimitarnc · Post by **dimitarnc** » Fri Feb 23, 2007 5:09 am

I want to ask one more thing: you talk about converting 'poller_output' table to memory - thats OK, but is there any benefit converting the remaining tables from myisam to innodb storage? Any recommendations for optimizing MySQL in any way when used with Boost plugin?

Post by **TheWitness** » Fri Feb 23, 2007 6:53 am

There is no need, I think, to change from MyISAM to INNODB. When using Memory tables, you have to insure that the Max Heap Table Size variable is large enough to handle all the outputs. Also, if you have long results (over 255 characters) you MUST be using MySQL 5.x in order to have a VarChar(512) output field.

TheWitness

N3NCY · Post by **N3NCY** » Fri Mar 09, 2007 8:11 pm

Boost v1.1 is kicking butt!

03/09/2007 08:00:34 PM - SYSTEM STATS: Time:33.7861 Method:cactid Processes:1 Threads:20 Hosts:289 HostsPerProcess:289 DataSources:46384 RRDsProcessed:0
03/09/2007 07:59:06 PM - SYSTEM BOOST STATS: Time:806.7390 RRDUpdates:601808

There is NO WAY on Earth I could graph all the devices on my network without Boost!

wriley · Post by **wriley** » Mon Mar 12, 2007 9:47 am

knobdy wrote:Anyone else run into the following error when trying to import that database:
Code: Select all
ERROR 1163 (42000) at line 2: The used table type doesn't support BLOB/TEXT columns

I ran into that error when I mistakenly tried to run boost_sql_memory.sql on mysql 4.1. The memory option only works on mysql 5 I believe.

twe2002 · Post by **twe2002** » Mon Mar 12, 2007 10:01 am

Hi,

I think I got it all working, I see graphs and stats working. I use version 1.1 of the boost plugin and cacti 0.8.6j.

When I start the boost server all is working fine. However, after a while when I want to look at the graphs I get no images (instead I get the picture with the red cross in it) and it takes a while. When I do a refresh after that the pictures are there and all looks correct.

In the log of the boost server I see the following:

Code: Select all

03/12/2007 07:59:14 AM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
03/12/2007 07:59:14 AM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
2007:03:12 07:59:14 - Host Connected '127.0.0.1'
2007:03:12 07:59:14 - Host Validated '127.0.0.1'
2007:03:12 07:59:14 - RRD Command 'update /usr/local/share/cacti/rra/bd10k_phono2_traffic_in_74.rrd --template traffic_in:traffic_out 1173701401:1175161449:13632277279 1173701700:1175171102:13632327544 1173702000:1175182815:13632383039 1173702301:1175191274:13632429326 1173702600:1175200150:13632484029 1173702901:1175212122:13632542520 1173703201:1175261068:13632634800 1173703500:1175324232:13632735929 1173703801:1175343710:13632800581 1173704100:1175352424:13632870862'
2007:03:12 07:59:14 - Host Connected '127.0.0.1'
2007:03:12 07:59:14 - Host Validated '127.0.0.1'
2007:03:12 07:59:14 - RRD Command 'update /usr/local/share/cacti/rra/bd10k_phono2_traffic_in_75.rrd --template traffic_in:traffic_out 1173701401:94939509264:182455194424 1173701700:94954453025:182490905328 1173702000:94970529801:182528455945 1173702301:94986205434:182555517097 1173702600:95041315263:182599231907 1173702901:95077832003:182675697014 1173703201:95128926996:182734877568 1173703500:95153020424:182764035417 1173703801:95167330263:182791112656 1173704100:95182839959:182821514514'
03/12/2007 07:59:16 AM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
03/12/2007 07:59:16 AM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
2007:03:12 07:59:17 - Host Connected '127.0.0.1'
2007:03:12 07:59:17 - Host Validated '127.0.0.1'
2007:03:12 07:59:17 - RRD Command 'update /usr/local/share/cacti/rra/bd10k_phono2_traffic_in_77.rrd --template traffic_in:traffic_out 1173701401:47740528:12984230715 1173701700:47753760:12984280265 1173702000:47758918:12984332827 1173702301:47764010:12984376025 1173702600:47769264:12984429043 1173702901:47774321:12984483861 1173703201:47779413:12984536501 1173703500:47836404:12984633938 1173703801:47841626:12984693762 1173704100:47856133:12984762335'
2007:03:12 07:59:17 - Host Connected '127.0.0.1'
2007:03:12 07:59:17 - Host Validated '127.0.0.1'
2007:03:12 07:59:17 - RRD Command 'update /usr/local/share/cacti/rra/bd10k_phono2_traffic_in_76.rrd --template traffic_in:traffic_out 1173701401:40430715531:748706698206 1173701700:40442362148:748728387422 1173702000:40445422886:748773446802 1173702301:40449593727:748834000225 1173702600:40453860804:748903564334 1173702901:40457436582:748934506783 1173703201:40461989975:748991020997 1173703500:40466177839:749013753466 1173703801:40469974120:749048246732 1173704100:40474302118:749081654480'
03/12/2007 07:59:19 AM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
03/12/2007 07:59:19 AM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
2007:03:12 07:59:19 - Host Connected '127.0.0.1'
2007:03:12 07:59:19 - Host Validated '127.0.0.1'
2007:03:12 07:59:19 - RRD Command 'update /usr/local/share/cacti/rra/bd10k_phono2_traffic_in_78.rrd --template traffic_in:traffic_out 1173701401:50246719195:39112625398 1173701700:50252680966:39116310896 1173702000:50259063080:39118872011 1173702301:50265548375:39128801992 1173702600:50276953842:39132402771 1173702901:50288819024:39135772387 1173703201:50300729558:39140240484 1173703500:50313428565:39149726054 1173703801:50326471244:39154338372 1173704100:50339068897:39159409061'
2007:03:12 07:59:19 - Host Connected '127.0.0.1'
2007:03:12 07:59:19 - Host Validated '127.0.0.1'
2007:03:12 07:59:19 - RRD Command 'update /usr/local/share/cacti/rra/bd10k_phono2_traffic_in_79.rrd --template traffic_in:traffic_out 1173701401:6263958286:21018687737 1173701700:6264255005:21019136994 1173702000:6265783231:21019800898 1173702301:6266757167:21020503094 1173702600:6273172718:21022479715 1173702901:6274387762:21023135971 1173703201:6275564949:21023876912 1173703500:6276109145:21024500725 1173703801:6276803950:21025287787 1173704100:6277445106:21025986544'
03/12/2007 07:59:21 AM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
03/12/2007 07:59:21 AM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
2007:03:12 07:59:22 - Host Connected '127.0.0.1'
2007:03:12 07:59:22 - Host Validated '127.0.0.1'
2007:03:12 07:59:22 - Host Connected '127.0.0.1'
2007:03:12 07:59:22 - Host Validated '127.0.0.1'
2007:03:12 07:59:22 - RRD Command 'update /usr/local/share/cacti/rra/bd10k_phono2_traffic_in_80.rrd --template traffic_in:traffic_out 1173701401:12642871795:10133248 1173701700:12643233489:10135456 1173702000:12643604033:10137296 1173702301:12643965266:10139136 1173702600:12644334132:10140976 1173702901:12644708031:10142816 1173703201:12645075965:10144656 1173703500:12645450409:10146496 1173703801:12645828460:10148336 1173704100:12646211403:10150176'
2007:03:12 07:59:22 - RRD Command 'update /usr/local/share/cacti/rra/bd10k_phono2_traffic_in_81.rrd --template traffic_in:traffic_out 1173701401:429320165533:731220252619 1173701700:429791650536:731257572236 1173702000:430302256179:731319922971 1173702301:430788301303:731399741883 1173702600:431268223826:731534823601 1173702901:431787650185:731672313490 1173703201:432323339244:731758078147 1173703500:432824121246:731825578073 1173703801:433319329706:731879714381 1173704100:433812749944:731948171967'
03/12/2007 07:59:24 AM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
03/12/2007 07:59:24 AM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'

What does it mean that the connection is broken ?

Thanks,
TWE2002

twe2002 · Post by **twe2002** » Mon Mar 12, 2007 3:02 pm

About to give up....argh

I seem to either not understand the boost plugin or I am wrong elsewhere.

I have three servers. One runs MySQL 5 (Server A), one runs Apache (Server B), one runs the cactid poller and the boost server (Server C).

I was hoping I could use Server B as the frontend and do the heavy work on my cactid poller/ boost server (Server C), or am I wrong here?

I installed cactid, boost plugin 1.1, Pluging Architecture as well as apache on Server B. My database is on Server A, no problems there.

Once all was working (I see graphs with boost_server enabled) I copied the folder structure 1:1 over to Server C. I updated the IP address of the boost server in my settings, updated the IP address of who is allowed to connect to the boost server, etc. I then deleted all the rra's on Server B, delete all datasources and started fresh. Created a new device and some data sources.

When I first hit "Graphs", I see the boost server creating the rrd's on Server C, so far so good. It doesn't show a graph yet, I was thinking that it is the first run, so it won't show anything....

But when I hit Graphs 10 minutes later again, I still don't get a graph to see and guess what, in the boost_server output I see it is creating the datasource again?

Also, on Server B in the http-error log I see that cacti still tries to get the graphs from my local server. I thought it would try to get it via the boost server...!?

I was under the assumption that all the rra files would reside on server C and the boost_server.php will allow me to graph them via Server B.

Can somebody shed some light into my confusion.

Thanks,
TWE2002

Cacti

Boost Plugin v1.6 Released

cacti 0.8.6j + PluginArch 1.1

Help with Boost Server - Boost 1.1 plugin

Boost Server plugin - how is it suppose to work?

Who is online