Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Sat Jul 21, 2018 2:18 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 13 posts ] 
Author Message
 Post subject: Vbulletin Posts/Threads/Users
PostPosted: Tue Apr 19, 2005 6:13 pm 
Offline
Cacti User

Joined: Thu Mar 31, 2005 4:24 pm
Posts: 124
Location: Sydney, Asutralia
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


Attachments:
File comment: Users
vbulletin_Users.png
vbulletin_Users.png [ 5.66 KiB | Viewed 35562 times ]
File comment: Threads
vbulletin_threads.png
vbulletin_threads.png [ 4.49 KiB | Viewed 35562 times ]
File comment: Posts
vbulletin_Posts.png
vbulletin_Posts.png [ 5.1 KiB | Viewed 35562 times ]
Top
 Profile  
 
 Post subject:
PostPosted: Tue Apr 19, 2005 6:14 pm 
Offline
Cacti User

Joined: Thu Mar 31, 2005 4:24 pm
Posts: 124
Location: Sydney, Asutralia
Here are the actual scripts and templates


Attachments:
File comment: Templates and scripts
Vbulletin.zip [32.3 KiB]
Downloaded 1634 times
Top
 Profile  
 
 Post subject:
PostPosted: Sat Apr 23, 2005 7:51 pm 
Offline

Joined: Sat Apr 23, 2005 7:48 pm
Posts: 12
Thanks for your work and idea !

I've installed it but ge the error:
Code:
ERROR: can't parse '#9FA4EE:registered'

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


Top
 Profile  
 
 Post subject:
PostPosted: Sun Apr 24, 2005 4:29 pm 
Offline
Cacti User

Joined: Thu Mar 31, 2005 4:24 pm
Posts: 124
Location: Sydney, Asutralia
not sure. Which one is causing the problem?

I have attached the templates again. Give them ago.


Attachments:
vb.rar [12.88 KiB]
Downloaded 1384 times
Top
 Profile  
 
 Post subject:
PostPosted: Sun Apr 24, 2005 4:55 pm 
Offline

Joined: Sat Apr 23, 2005 7:48 pm
Posts: 12
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:
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 ;)


Top
 Profile  
 
 Post subject:
PostPosted: Sun Apr 24, 2005 5:00 pm 
Offline

Joined: Sat Apr 23, 2005 7:48 pm
Posts: 12
Sorry, I fixed it !
I forgot to associate the graph item fields with the right data.
thanks for this great addon ;)


Top
 Profile  
 
 Post subject:
PostPosted: Mon Apr 25, 2005 2:44 am 
Offline
Cacti User

Joined: Thu Mar 31, 2005 4:24 pm
Posts: 124
Location: Sydney, Asutralia
np


Top
 Profile  
 
 Post subject:
PostPosted: Tue Apr 26, 2005 5:21 pm 
Offline

Joined: Thu Mar 31, 2005 7:39 pm
Posts: 26
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


Top
 Profile  
 
 Post subject:
PostPosted: Wed Apr 27, 2005 6:04 am 
Offline
Cacti User

Joined: Thu Mar 31, 2005 4:24 pm
Posts: 124
Location: Sydney, Asutralia
Nope its not hard if you know how to do it:).


Top
 Profile  
 
 Post subject: hi
PostPosted: Fri May 20, 2005 11:07 pm 
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


Top
  
 
 Post subject:
PostPosted: Tue Oct 31, 2006 4:28 pm 
Offline

Joined: Tue Oct 31, 2006 4:24 pm
Posts: 3
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!


Top
 Profile  
 
 Post subject: VBulletin Cacti Slow Queries fix
PostPosted: Thu Aug 30, 2007 10:26 pm 
Offline

Joined: Thu Aug 30, 2007 10:13 pm
Posts: 1
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.


Attachments:
File comment: Remove .txt extension
vbulletin_threads.php.txt [2.18 KiB]
Downloaded 1489 times
File comment: Remove .txt extension
vbulletin_posts.php.txt [2.14 KiB]
Downloaded 1381 times
Top
 Profile  
 
 Post subject:
PostPosted: Thu Sep 27, 2007 12:41 am 
Offline
Cacti User

Joined: Thu Mar 31, 2005 4:24 pm
Posts: 124
Location: Sydney, Asutralia
I will make some updates on the scripts and add some new ones this week or next.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 13 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group