Vbulletin Posts/Threads/Users

[africanw]

Hi,

Have created three graphs for Vbulletin. Based on what this thread was on about (http://forums.cacti.net/viewtopic.php?t ... =vbulletin).

This has been tested and works with Cacti (0.86c) running on Fedora Core 3.

Colours are abit horrible but thats a easy thing you can change.

AW

[africanw]

Here are the actual scripts and templates

[Onkel_Tom]

Thanks for your work and idea !

I've installed it but ge the error:

Code: Select all

ERROR: can't parse '#9FA4EE:registered'

from RRD debug mode.
any idea how to fix it ?

[africanw]

not sure. Which one is causing the problem?

I have attached the templates again. Give them ago.

[Onkel_Tom]

It doesn't matter which template. All Templates get the same error.
I tried you new templates and while adding the vBulletin users template to the graph management I get this error:

Code: Select all

ERROR: can't parse '#9FA4EE:Registered'

I'm a beginner with cacti so I can't fix the problem on my own at the moment

[Onkel_Tom]

Sorry, I fixed it !
I forgot to associate the graph item fields with the right data.
thanks for this great addon

[africanw]

np

[sdetroch]

It's not that difficult to include vbulletin stats in cacti.
For instance, create a php script with the following content for the users online:

#!/usr/bin/php
<?
$numberusers = 0;

$hostname = "domainname_server_vbulletin";
$username = "database_username";
$password = "database_password";
$dbname = "name_database_vbulletin";

$connection = mysql_connect($hostname,$username,$password) or die ("Cannot connect to server.");
$db = mysql_select_db($dbname,$connection) or die ("Could not select database.");

$sql = "SELECT COUNT(DISTINCT userid) AS username FROM user";
$totalusers = mysql_result(mysql_query($sql, $connection),0,"username");

mysql_close($connection);

print "$totalusers";
?>



for the amount of postings you can i.e. use:

$sql = "SELECT COUNT(DISTINCT postid ) AS postid FROM post";
$postid = mysql_result(mysql_query($sql, $connection),0,"postid");


and so on ... have a look in the database of vbulletin to see which query you need for which counter.

regards,
Sven

[africanw]

Nope its not hard if you know how to do it:).

[aboyz]

hi,

can someone tell me what to do with this graph file.
data template
graph template

I unzip them and i got 4 .xml file

do I just import them? anyone know how this is done. please can someone post a step by step on how to get this going . i'm lost

thanks

[offlinetn]

I am new at cacti and I installed this and it works great! Would it be hard to add some more statistics like # of newly registering users?

Thanks!

[ChrisHasenpflug]

Hi all,

Apologies for the bump of this old thread, however this is still the top google result for "cacti vbulletin" and where the scripts originated from, so it only seemed appropriate to post this here.

We've been trying to track down the cause of some table locks on our server, and in doing so have been closely monitoring our slow query log. In doing so, the queries done by these scripts caught our eye.

The initial release of these scripts does math on the dateline column. This creates a performance issue because MySQL can not use indexes and has to do a full table scan which is highly inefficient for any decently sized vB board.

Simply moving the math to the other side of the where clause reduces the time for these queries significantly. And given that the scripts run every 5 minutes, it has helped eliminate problems with table locking resulting in a more responsive server.

I will attach the modified files and hope they can be included in the initial download for the greatest distribution.

[africanw]

I will make some updates on the scripts and add some new ones this week or next.