CACTID Problems on Windows

[TheWitness]

Hello,

When attempting to run cactid from windows with cygwin, I receive the following error. I have made changes to cactid.conf but am still getting the errors.

C:\cygwin\usr\local\cactid\bin>cactid
cactid version 0.8.5a starting.
Connecting to MySQL database 'cacti' on 'localhost'...
** Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(2)

Thanks in Advance

[BSOD2600]

I had the same problem until 2 minutes ago. Did you copy over and configure the cactid.conf file? That fixed the problem for me and introduced a new one...

Code: Select all

C:\www\cacti>cactid
cactid version 0.8.5a starting.
Using cactid config file [cactid.conf].
= in cactid.conf directive: °

[BSOD2600]

Ok, yet another update. I deleted all the comments out of cactid.conf and changed localhost to 127.0.0.1 to get rid of my last problem. Now on to new ones...

1) Can't find the MIB's
2) when running the perl script, it removed a directory slash...

Code: Select all

C:\Auntie\cacti>cactid
cactid version 0.8.5a starting.
Using cactid config file [cactid.conf].
Connecting to MySQL database 'cacti' on '127.0.0.1'...
No log handling enabled - turning on stderr logging
IP-MIB: Module not found
IF-MIB: Module not found
TCP-MIB: Module not found
UDP-MIB: Module not found
HOST-RESOURCES-MIB: Module not found
SNMPv2-MIB: Module not found
RFC1213-MIB: Module not found
SNMPv2-SMI: Module not found
NOTIFICATION-LOG-MIB: Module not found
UCD-SNMP-MIB: Module not found
UCD-DEMO-MIB: Module not found
SNMP-TARGET-MIB: Module not found
NET-SNMP-AGENT-MIB: Module not found
SNMP-VIEW-BASED-ACM-MIB: Module not found
SNMP-COMMUNITY-MIB: Module not found
UCD-DLMOD-MIB: Module not found
SNMP-FRAMEWORK-MIB: Module not found
SNMP-MPD-MIB: Module not found
SNMP-USER-BASED-SM-MIB: Module not found
SNMP-NOTIFICATION-MIB: Module not found
SNMPv2-TM: Module not found
Cactid Ready.
Connecting to MySQL database 'cacti' on '127.0.0.1'...
Connecting to MySQL database 'cacti' on '127.0.0.1'...
Connecting to MySQL database 'cacti' on '127.0.0.1'...
Connecting to MySQL database 'cacti' on '127.0.0.1'...
Connecting to MySQL database 'cacti' on '127.0.0.1'...
[2] SNMP v1: 192.168.100.1, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.1, value:2280755668
[2] SNMP v1: 192.168.100.1, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.1, value: 645782009
RRDCMD: update 'c:\auntie\cacti\rra\webstar_dpx2100_cable_modem_traffic_in_18.rrd' --template traffic_in:traffic_out N:2280755668:645782009
Can't open perl script "c:auntiecacti/scripts/mbm2mrtg-ares.pl": No such file or directory
<it continues for a while>

[TheWitness]

Yes,

I figured it out. The cactid.exe did not like blank lines in the file. Now, I am getting error message that the file c:rrdtoolrrdtool.exe not found message and things don't seem to be running. Any clues?

Larry

[TheWitness]

I am wondering if cygwin need them in c:\cygwin\tmp\mibs. I am confused by the removal of the backslash though.

[TheWitness]

Nope. Was USR\MIBS and it still did not find them or any of the other programs for example: c:\php\php.exe. Somehow or another the program is taking out the backslashes "\".

[BSOD2600]

Following another cactid on windows thread here, I'm going to try and edit the two php files he mentioned and see if it fixes the remoavel of the slashes in a little bit.

[BSOD2600]

Well editing the two php files didnt help and breaks cmd.php.

I hard coded in the full path into the Data Input Methods and now at least they run.... albeit broken. Its odd, when cactid runs the perl script it doesn't execute properly (I am manually invoking it running ATM, so I know its not a permission problem). For example cactid executing the perl script:

Code: Select all

[4] MUTLI command: perl c:/auntie/cacti/scripts/mbm2mrtg-gamer2k.pl 22, output: val3:0

ERROR: Field name 'val3' not in field cache!

Me executing the perl script:

Code: Select all

C:\Auntie\cacti>perl c:/auntie/cacti/scripts/mbm2mrtg-gamer2k.pl 22
val1:3.44
val2:3.44
val3:0

Now why the heck would it have only the one line output with cactid?

[BSOD2600]

I modified my perl script to only one line of output, so my last problem is fixed (although it would still be nice to know WHY that is happening). On to a new one...

I noticed now that when running cactid, rrdtool sometimes craps out as if the wrong commands are being fed to it. For example:

Code: Select all

[2] SNMP v1: 192.168.100.1, dsname: snmp_oid4, oid: .1.3.6.1.2.1.10.127.1.2.2.1.3.2,value: 425
RRDCMD: update 'c:\auntie\cacti\rra\webstar_dpx2100_uppower_3.rrd' --template snmp_oid4 N:425
OK
OK
RRDtool 1.0.48  Copyright 1997-2004 by Tobias Oetiker <tobi@oetiker.ch>

Usage: rrdtool [options] command command_options

Valid commands: create, update, graph, dump, restore,
                last, info, fetch, tune, resize, xport

RRDtool is distributed under the Terms of the GNU General
Public License Version 2. (www.gnu.org/copyleft/gpl.html)

For more information read the RRD manpages

OK
OK
OK
OK
OK
Connecting to MySQL database 'cacti' on '127.0.0.1'...

How can I see exactly what raw commands are being fed to RRDTool to see what the problem is ?

[skaminski]

I'm getting this same problem now.....
Connecting to MySQL database 'cacti' on 'localhost'...
Failed: Can't connect to local MySQL server through socket 'tmp/mysql.sock'


What's bizarre is that I've changed the cactid.conf file (and moved it to the location in this post) and is still tries to connect to cacti on 'localhost'.

Any ideas?

[TheWitness]

The cactid.conf file must be in the following directory: c:\cygwin\usr\local\cactid\bin. Make sure it's there. Then you MUST not reference either "localhost" or "127.0.0.1". What is happening is cactid is attempting to access mysql through a file association and not via sockets.

I found that by either specifying the hostname or IP address works best. Also, make sure that the 'cactiuser' has the correct permissions (i.e. the hostname and IP address needs to have the access).

Larry

[skaminski]

UPDATED!!!!! It finally works....

I had to do a couple of things. Here's what I did (or what I think I did).

One problem was that I was trying to run cactid.exe from the root of "c:" Running it from there failed. For some reason, I just double-clicked on the exe from Windows explorer and didn't see the error. Sure enough, I went back to the command prompt but this time I cd'd to the full directory (c:\cygwin\usr\local\cactid\bin) and ran it there. SUCCESS

Before that, in my efforts at fixing this I did several things. Most of those were covered under[/url]http://www.raxnet.net/board/viewtopic.php?t=392

A couple of other pieces that I had to do after following those steps.
1. Copy cygwin1.dll and cygz.dll to c:\windows.

Once I got past that, I was troubled by the unable to connect to database issue earlier in this post. Although I'm not very literate in MySQL, I somehow managed to fumble my way through adding permissions for my Cacti user from my host (specified in cactid.conf). (see step 7 in the above link)I used the syntax from the installation of cacti to add the permissions.

After that, everythin started working.