Fast Class Based Weighted Fair Queuing (CBWFQ) QoS Poller

Templates, scripts for templates, scripts and requests for templates.

Moderators: Developers, Moderators

bbosch
Posts: 2
Joined: Fri Jun 29, 2007 8:21 am
Location: Port Elizabeth, South Africa

Post by bbosch »

Hi

I'm think I've done everything correctly to get this app working, but when I add the "Get CBWFQ Information" data query to my device, my explorer simply hangs. Have to close Explorer and login to Cacti again to get back into Cacti. No items and rows displayed.

The VB scripts work 100% from the command line.

Other scripts/data queries don't cause this issue.

Please help.
Thanks
Brenden
:cry: :cry: :cry: :cry:
Snowboarding360
Posts: 11
Joined: Wed Jun 15, 2005 7:47 am

New Version 1.2

Post by Snowboarding360 »

Hi, I've uploaded a new version that can now handle spaces in the interface name (v1.2). The only change in this version is that if it is sent a get command, it assumes that everything past the 4th paramater is the index value instead of assuming that the spaces are delimeters for additional command line arguments.

Thanks very much to smilerza for testing this out ahead of time for me and bringing it to my attention!
Snowboarding360
Posts: 11
Joined: Wed Jun 15, 2005 7:47 am

Post by Snowboarding360 »

Brenden, are you still having issues with the program? This could be a lot of things, including permissions. I would start be looking at the log file to see if it is actually executing, and if so, what the problem might be. I also uploaded a new version that can handle spaces in the interface name recently in case you need that.
GrahamC
Posts: 3
Joined: Tue Jan 08, 2008 4:00 pm

Post by GrahamC »

Hi,

We have just started using Cacti so we are still learning.

We have tried to implement this script as described but aren't getting any graphs. We have used the templates method, and have also manually tried to create all the necessary items by duplicating what actions the templates do.

After installation and when attempting to create a graph the device interfaces are shown as expected. Therefore Cacti has correctly used the program to interrogate the device to get the interfaces.

We have even created 'data input method' to poll & graph a single parameter from one interface, again proving that the system is working.

Everything seems to be setup correctly but we aren't getting any graphs created, and no RRD files. There are no errors messages logged that seem to relate to this.

We are using Version 0.8.7a as shown below. Is there any differences in setting up this system for this version.

Thanks,
Graham

---------------------------------------
Technical Support

General Information
Date Wed, 09 Jan 2008 07:55:11 +1100
Cacti Version 0.8.7a
Cacti OS win32
SNMP Version net-snmp
RRDTool Version RRDTool 1.2.x
Hosts 4
Graphs 10
Data Sources Script/Command: 3
SNMP: 2
SNMP Query: 4
Script Query: 1
Total: 10
Poller Information
Interval 300
Type cmd.php
Items Action[0]: 10
Action[1]: 3
Total: 13
Concurrent Processes 1
Max Threads 1
PHP Servers 1
Script Timeout 25
Max OID 10
Last Run Statistics Time:16.3121 Method:cmd.php Processes:1 Threads:N/A Hosts:5 HostsPerProcess:5 DataSources:13 RRDsProcessed:9
PHP Information
PHP Version 5.2.5
PHP OS WINNT
PHP uname Windows NT TSVCACTI 5.2 build 3790
PHP SNMP Installed
max_execution_time 30
memory_limit 128M
-----------------------------------------------------------
GrahamC
Posts: 3
Joined: Tue Jan 08, 2008 4:00 pm

Post by GrahamC »

Hi,

Following on form my last post.

Is anyone using these templates on Version 0.8.7a?

Thanks,
Graham
rjblanch
Posts: 8
Joined: Mon Feb 18, 2008 3:33 pm

Post by rjblanch »

Hi All,

I have completed all of the steps and it all seems to be going well, but when I get to create the Graphs, I have a lot of options for only 4 classes...

I get 1 line with the interface name and the class name and then a line with "outbound" in the index field.

The index delimeter in the inf file is not used in the names of the interfaces, which I have already checked..

Any ideas greatly appreciated.
dswinford
Posts: 10
Joined: Fri Nov 09, 2007 3:54 pm

error on query index

Post by dswinford »

I am having trouble with this script. When I run the query index from a cmd prompt, I recieve Terminating with Error: ExtractInterfaceInfo():Subscript out of range. I am running this against a Cisco 7609 with 3000-4000 aubinterfaces with several hundred of them having QoS service policies applied.
Snowboarding360
Posts: 11
Joined: Wed Jun 15, 2005 7:47 am

Post by Snowboarding360 »

Hi all, did you try setting FileLogLevel to 7, and can you post what the log file shows? Also, if you're having problems with polling, check and post the relevant portions of your cacti log file too.

Graham, did you check that the poller account has execute read/write/execute access to the directory it's in?
GrahamC
Posts: 3
Joined: Tue Jan 08, 2008 4:00 pm

Post by GrahamC »

Hi,

Yes the poller account has permissions to the directory it runs in. This account has permissions from the web site root directory down.
But still no graphs are created.
Any clues.

Thanks,
Graham
pvarthur
Posts: 5
Joined: Thu Mar 20, 2008 12:15 pm

Post by pvarthur »

I am having the exact issue Graham is having as well. Everything seems to work great, I can test the index function, etc, but I just don't get graphs created. I have double checked permissions and the poller service account has write/read/execute access to the scripts folder. I hope someone has an idea as to what is missing.

Thanks
pvarthur
Posts: 5
Joined: Thu Mar 20, 2008 12:15 pm

Post by pvarthur »

Is it possible the actual script is not being ran at the 5 minute intervals? I adjusted my logging level to "debug" and I don't see any reference to the poller running the cbwfq_vb file. Would it be in the debug if it was running it? The cbwfq_vb log file is empty even though I have the logging level turned up on it as well. It almost seems like it just is not running at the 5 minute intervals for some reason.
pvarthur
Posts: 5
Joined: Thu Mar 20, 2008 12:15 pm

Post by pvarthur »

Ok, so I have the polling process working now, but I am receiving the same error where the "interface_class" argument has an invalid format. I have downloaded the latest version from the website and it still seems to give me a problem. Here is the log output:

4/11/2008 3:55:06 PM [PID:4896]: Starting Main
4/11/2008 3:55:06 PM [PID:4896]: OpenConn(): Opening database connection
4/11/2008 3:55:06 PM 192.168.1.99 [PID:4896]: Application Started: Got Arg #0: 192.168.1.99
4/11/2008 3:55:06 PM 192.168.1.99 [PID:4896]: Application Started: Got Arg #1: hidden
4/11/2008 3:55:06 PM 192.168.1.99 [PID:4896]: Application Started: Got Arg #2: get
4/11/2008 3:55:06 PM 192.168.1.99 [PID:4896]: Application Started: Got Arg #3: DropByte
4/11/2008 3:55:06 PM 192.168.1.99 [PID:4896]: Application Started: Got Arg #4: GigabitEthernet0/2.35CLASS-HIGH-INTERACTIVE-APPOutbound
4/11/2008 3:55:06 PM 192.168.1.99 [PID:4896]: Terminating with ERROR: ReturnGet():Invalid format for <interface_class>

In fact if I type ANYTHING for the index value I get the same error.

Any chance there is a fix for this? I would really love to get this working.

Thanks
Snowboarding360
Posts: 11
Joined: Wed Jun 15, 2005 7:47 am

Post by Snowboarding360 »

Hi,you need to have a delimiter in the index. It should look like GigabitEthernet0/2.35_CLASS-HIGH-INTERACTIVE-APP_Outbound if you are using an _ as a delimiter.

Graham, what does your cacti.log file show when you search for cbwfq_vb?
jay
Cacti User
Posts: 390
Joined: Wed Aug 31, 2005 8:55 am
Location: Bristol, England

Post by jay »

Hi

I'm having some issues just getting this to run from the command line. I haven't tried to run the templates via cacti yet. I thought its best to get it running from the command line first.

Has anyone seen this error message before?? If so do you know how to resolve this?

C:\Apache2\htdocs\cacti\scripts>cbwfq_vb.exe 1.1.1.1 public query index
Terminating with ERROR: OpenConn():[Microsoft][ODBC Driver Manager] Data source
name not found and no default driver specified




Here is the Log file (set to 7)
19/05/2008 14:39:45 [PID:956]: Starting Main
19/05/2008 14:39:45 [PID:956]: OpenConn(): Opening database connection
19/05/2008 14:39:46 [PID:956]: Terminating with ERROR: OpenConn():[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified


Here is my .ini configuration file.

[CBWFQ_VB]
LogFile=RunningDirectory
ScreenLogLevel=1
FileLogLevel=1
SNMPTimeout=700
SNMPRetries=2
Logging=1
IndexDelimiator=~
CacheAgeMinutes=10080
DB_User=cactiuser
DB_Pass=password
DB_Host=127.0.0.1
DB_Port=3306
DB_Name=cacti



here are the runtime files I downloaded and installed. I'm not sure whether this has registered succesfully or not.

VB6.0-KB290887-X86

vbrun60sp6

C:\Program Files\MySQL\Connector ODBC 5.1



If i go to control panel - admin tools - data sources (odbc) - drivers tab, I can see the driver has been installed.


If I run a trace, using the above tool, and try to run the application I get the following. I set the dll file as myodbc5.dll (C:\Program Files\MySQL\Connector ODBC 5.1\myodbc5.dll)
This doesn't mean anything to me but it may do to someone else.


cbwfq_vb.exe 17 12c8-1224 ENTER SQLAllocEnv
HENV * 4BFEF838

cbwfq_vb.exe 17 12c8-1224 EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x4BFEF838 ( 0x016d1540)

cbwfq_vb.exe 17 12c8-1224 ENTER SQLGetEnvAttr
SQLHENV 016D1540
SQLINTEGER 201 <unknown>
SQLPOINTER [Unknown attribute 201]
SQLINTEGER 4
SQLINTEGER * 0x0012EA3C

cbwfq_vb.exe 17 12c8-1224 EXIT SQLGetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 016D1540
SQLINTEGER 201 <unknown>
SQLPOINTER [Unknown attribute 201]
SQLINTEGER 4
SQLINTEGER * 0x0012EA3C (1495028)

cbwfq_vb.exe 17 12c8-1224 ENTER SQLAllocEnv
HENV * 4BFEF83C

cbwfq_vb.exe 17 12c8-1224 EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x4BFEF83C ( 0x016d15e8)

cbwfq_vb.exe 17 12c8-1224 ENTER SQLSetEnvAttr
SQLHENV 016D15E8
SQLINTEGER 201 <unknown>
SQLPOINTER [Unknown attribute 201]
SQLINTEGER -6

cbwfq_vb.exe 17 12c8-1224 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 016D15E8
SQLINTEGER 201 <unknown>
SQLPOINTER [Unknown attribute 201]
SQLINTEGER -6

cbwfq_vb.exe 17 12c8-1224 ENTER SQLAllocConnect
HENV 016D15E8
HDBC * 0012F658

cbwfq_vb.exe 17 12c8-1224 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 016D15E8
HDBC * 0x0012F658 ( 0x016d1690)

cbwfq_vb.exe 17 12c8-1224 ENTER SQLGetInfoW
HDBC 016D1690
UWORD 10 <SQL_ODBC_VER>
PTR 0x0012F624
SWORD 22
SWORD * 0x00000000

cbwfq_vb.exe 17 12c8-1224 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 016D1690
UWORD 10 <SQL_ODBC_VER>
PTR 0x0012F624
SWORD 22
SWORD * 0x00000000

cbwfq_vb.exe 17 12c8-1224 ENTER SQLSetConnectAttrW
SQLHDBC 016D1690
SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>
SQLPOINTER 0x00000004
SQLINTEGER -6

cbwfq_vb.exe 17 12c8-1224 EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 016D1690
SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>
SQLPOINTER 0x00000004 (BADMEM)
SQLINTEGER -6

cbwfq_vb.exe 17 12c8-1224 ENTER SQLDriverConnectW
HDBC 016D1690
HWND 00000000
WCHAR * 0x48897CF4 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x48897CF4
SWORD 2
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>

cbwfq_vb.exe 17 12c8-1224 EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 016D1690
HWND 00000000
WCHAR * 0x48897CF4 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x48897CF4
SWORD 2
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>

DIAG [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0)

cbwfq_vb.exe 17 12c8-1224 ENTER SQLGetDiagRecW
SQLSMALLINT 2
SQLHANDLE 016D1690
SQLSMALLINT 1
SQLWCHAR * 0x0012F5B8 (NYI)
SQLINTEGER * 0x0012F19C
SQLWCHAR * 0x0012F1B8 (NYI)
SQLSMALLINT 512
SQLSMALLINT * 0x0012F1A0

cbwfq_vb.exe 17 12c8-1224 EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2
SQLHANDLE 016D1690
SQLSMALLINT 1
SQLWCHAR * 0x0012F5B8 (NYI)
SQLINTEGER * 0x0012F19C (0)
SQLWCHAR * 0x0012F1B8 (NYI)
SQLSMALLINT 512
SQLSMALLINT * 0x0012F1A0 (91)

cbwfq_vb.exe 17 12c8-1224 ENTER SQLGetDiagRecW
SQLSMALLINT 2
SQLHANDLE 016D1690
SQLSMALLINT 2
SQLWCHAR * 0x0012F5B8 (NYI)
SQLINTEGER * 0x0012F19C
SQLWCHAR * 0x0012F1B8 (NYI)
SQLSMALLINT 512
SQLSMALLINT * 0x0012F1A0

cbwfq_vb.exe 17 12c8-1224 EXIT SQLGetDiagRecW with return code 100 (SQL_NO_DATA_FOUND)
SQLSMALLINT 2
SQLHANDLE 016D1690
SQLSMALLINT 2
SQLWCHAR * 0x0012F5B8 (NYI)
SQLINTEGER * 0x0012F19C
SQLWCHAR * 0x0012F1B8 (NYI)
SQLSMALLINT 512
SQLSMALLINT * 0x0012F1A0

cbwfq_vb.exe 17 12c8-1224 ENTER SQLFreeConnect
HDBC 016D1690

cbwfq_vb.exe 17 12c8-1224 EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS)
HDBC 016D1690


Oh and I can confirm that the request isn't hitting the router so its something local on my server. Just don't know what at this time.

Kind regards

Jay
Cacti Version 0.8.7e, Spine 0.8.7e, Apache 2.2.15, Mysql 5.0.88, PHP 5.2.13, RRDTool 1.2.30, NET-SNMP 5.5
Quad Core AMD Opteron Processor 2384, 2.70Ghz, 2GB RAM , 1 CPU used
Windows Server 2003 (X64), VMWARE ESX
Plugins: Aggregate 0.75

SYSTEM STATS: Time:12.5140 Method:spine Processes:2 Threads:15 Hosts:400 HostsPerProcess:200 DataSources:2909 RRDsProcessed:1384
jay
Cacti User
Posts: 390
Joined: Wed Aug 31, 2005 8:55 am
Location: Bristol, England

Post by jay »

Hi

Some more information.

I installed the odbc drivers using the installer and I also tried just using the zip file and running the install batch file. I see the myodbc5.dll in both the folder I created and also the sysytem32 folder. Could this cause an issue?

When I run the MDAC component checker I do get a lot of mismatches. Not sure if this is causing an issue.

I have run process monitor to include cbwfq_vb.exe to see if I get any denied messages but I don't. So this doesn't look like a permissions problem. I get some name not found messages in the file though.

Any ideas???

Jay
Cacti Version 0.8.7e, Spine 0.8.7e, Apache 2.2.15, Mysql 5.0.88, PHP 5.2.13, RRDTool 1.2.30, NET-SNMP 5.5
Quad Core AMD Opteron Processor 2384, 2.70Ghz, 2GB RAM , 1 CPU used
Windows Server 2003 (X64), VMWARE ESX
Plugins: Aggregate 0.75

SYSTEM STATS: Time:12.5140 Method:spine Processes:2 Threads:15 Hosts:400 HostsPerProcess:200 DataSources:2909 RRDsProcessed:1384
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests