Super Cacti script - Does everything!

[stgarner]

Hello everyone,

I have a script that my company used to add devices to Cacti. I have no idea who made it. It did everything from adding the devices, adding them to the tree, and creating the graphs. It was super easy to add devices from a text file where the IP was listed first and then the hostname separated by a space.

The script doesnt work in the new version and I am not a PHP programmer or a Cacti expert. I believe anyone with good Cacti knowledge and PHP skills should be able to correct/fix them.

I think it has value, you tell me. Sure made things easy!

There are 3 files attached:
super_cacti_config.php (the configuration file)
super_cacti.php (the script that does all the work)
myloadfile.txt (an example load file)

The steps I used to add devices were as follows:
1) Create the import file (text file) with the IP and the hostname separated by a space, tab, or comma. One device per line, IP address must be first.

2) Run the command:
php super_cacti.php

This gave the listing of the trees and tree number association. You need the tree number to append it to the command when you import. See the example below where the end of the command has a number. This is the tree number.

3) Run the command:
php super_cacti.php myloadfile.txt 2

Sit back and wait. It runs pretty fast.

4) Verify the graphs were created and populated.

So I have about 1200 devices that need to be added to my new 0.8.7a server. The old server corrupted. I believe the old server was running 0.8.6.

Any help would be appreciated. Maybe the script can be used by others or brought into the product itself.

Steve

[apperrault]

I am no expert, but after have a brief look at super_cacti_config.php, there do not appear to be any references to global.php. the first thing i would do to try and fix this would be to add the following line

Code: Select all

include_once($cacti_base_dir."/include/global.php");

right below

Code: Select all

include_once($cacti_base_dir."/include/config.php");

Try that and see if you get any farther.

app

[stgarner]

Doesnt the config script reference this?

Database authentication info gathered from cacti config:
/usr/share/cacti/include/config.php

Forgive my ignorance. Like I said, Im not a developer.

Steve

[apperrault]

It is my understanding that config.php only has the database connection information, but global.php includes the bulk of the other cacti reference information. I have had some scripts that used to work, and didn't after the upgrade, but changing the scripts to include global.php corrected the problems.

app

[stgarner]

Ok. So I added that line. This is the output from trying to add a device.. x's in place of some information. It adds a blank item to the tree. There is no name associated with it.

[root@xxxxxxxxxxx Bulk_Load_Tool]# php super_cacti.php xxxxxxxxxx.txt 2
host (xxx.xxx.xxx.xxx) is visible and new to cacti, proceeding with discovery
Adding xxxxxx.xxxxxx.COM (xxx.xxx.xxx.xxx) as "Windows" using SNMP v1 with community "xxxxxxx" to Org ID: 2
PHP Notice: Undefined variable: availability_method in /root/Bulk_Load_Tool/super_cacti.php on line 141

Notice: Undefined variable: availability_method in /root/Bulk_Load_Tool/super_cacti.php on line 141
PHP Notice: Undefined variable: ping_method in /root/Bulk_Load_Tool/super_cacti.php on line 141

Notice: Undefined variable: ping_method in /root/Bulk_Load_Tool/super_cacti.php on line 141
PHP Notice: Undefined variable: ping_port in /root/Bulk_Load_Tool/super_cacti.php on line 141

Notice: Undefined variable: ping_port in /root/Bulk_Load_Tool/super_cacti.php on line 141
PHP Notice: Undefined variable: ping_timeout in /root/Bulk_Load_Tool/super_cacti.php on line 141

Notice: Undefined variable: ping_timeout in /root/Bulk_Load_Tool/super_cacti.php on line 141
PHP Notice: Undefined variable: ping_retries in /root/Bulk_Load_Tool/super_cacti.php on line 141

Notice: Undefined variable: ping_retries in /root/Bulk_Load_Tool/super_cacti.php on line 141
PHP Notice: Undefined variable: notes in /root/Bulk_Load_Tool/super_cacti.php on line 142

Notice: Undefined variable: notes in /root/Bulk_Load_Tool/super_cacti.php on line 142
PHP Notice: Undefined variable: snmp_auth_protocol in /root/Bulk_Load_Tool/super_cacti.php on line 142

Notice: Undefined variable: snmp_auth_protocol in /root/Bulk_Load_Tool/super_cacti.php on line 142
PHP Notice: Undefined variable: snmp_priv_passphrase in /root/Bulk_Load_Tool/super_cacti.php on line 142

Notice: Undefined variable: snmp_priv_passphrase in /root/Bulk_Load_Tool/super_cacti.php on line 142
PHP Notice: Undefined variable: snmp_priv_protocol in /root/Bulk_Load_Tool/super_cacti.php on line 142

Notice: Undefined variable: snmp_priv_protocol in /root/Bulk_Load_Tool/super_cacti.php on line 142
PHP Notice: Undefined variable: snmp_context in /root/Bulk_Load_Tool/super_cacti.php on line 142

Notice: Undefined variable: snmp_context in /root/Bulk_Load_Tool/super_cacti.php on line 142
PHP Notice: Undefined variable: max_oids in /root/Bulk_Load_Tool/super_cacti.php on line 142

Notice: Undefined variable: max_oids in /root/Bulk_Load_Tool/super_cacti.php on line 142
Host ID: 0
PHP Notice: Undefined variable: index in /root/Bulk_Load_Tool/super_cacti.php on line 163

Notice: Undefined variable: index in /root/Bulk_Load_Tool/super_cacti.php on line 163
Non-Cisco Device, please configure other counters via the cacti web interface
PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /root/Bulk_Load_Tool/super_cacti.php on line 243

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /root/Bulk_Load_Tool/super_cacti.php on line 243
PHP Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /root/Bulk_Load_Tool/super_cacti.php on line 244

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /root/Bulk_Load_Tool/super_cacti.php on line 244

[apperrault]

And this is where i get off the train!!!

I had a feeling that something like this was going to happen. More than likely, the files that your script points to have moved, or their names have changed. I am not a big programmer, so i am going to step out of the way and see if someone that knows more about this stuff that I take over. I will probably keep looking into it to see if i can figure it out, but i can't be sure much will come of it.

app

[stgarner]

Cool. Lets see if the community or developers can help resolve this. I hav faith!

[timi]

why not using the scripts from cli/ ? have a look at http://forums.cacti.net/viewtopic.php?t=7683

[stgarner]

I did see those but I didnt see one that added the graphs. I see one to add the devices but the one I used to use added the devices, created the graphs and added them to the proper tree.

Are you telling me that you can do all that from the CLI scripts?
Is each one a separate script?

Steve

[BSOD2600]

Are you telling me that you can do all that from the CLI scripts?Is each one a separate script?

Most likely. Take a read http://docs.cacti.net/node/529

If you implemented a feature that the current scripts do not, feel free to submit it http://www.cacti.net/bugs.php

[kuma3]

Maybe you can take a look at "Super Add" at my signature. It tries to solve the same problem except it uses cacti UI to do the work. But it doesn't automatically add data query graph and only works with 0.87+

[rony]

This script is not compliant with 0.8.7x, I suggest you don't use it.

[gsaray101]

is there a script that bulk inserts devices to cacti - that works for version. 0.8.7?

Thanks,

mike

[gandalf]

Sure. See cli/add_devices.php
Early versions were very slow on a decent installation. Use latest code from SVN branch 0.8.7, then
Reinhard

[hurgh]

I dont seem to have a "cli" directory in my cacti Install.

Does it come with it standard??

Thanks

-Hurgh-