[SOLVED] upgrade to CactiEZ 6.0 (0.8.7.c), can't add devices

Post support questions that directly relate to Linux/Unix operating systems.

Moderators: Developers, Moderators

Post Reply
TheBigAmbulance
Posts: 24
Joined: Mon Sep 29, 2008 8:47 am

[SOLVED] upgrade to CactiEZ 6.0 (0.8.7.c), can't add devices

Post by TheBigAmbulance »

I have completed the upgrade to my cacti server and everything that existed before the upgrade is showing up in the new cacti. When I am going to add a new device, I am getting an error that says 'Error: Save Failed.' I have tried tailing the logs in /var/log (messages, etc...), and there is never an error.

I have set a mysql password. Is there a need to change a Cacti setting to utilize the password? Any logs I can examine?
Last edited by TheBigAmbulance on Tue Oct 18, 2011 3:23 pm, edited 1 time in total.
TheBigAmbulance
Posts: 24
Joined: Mon Sep 29, 2008 8:47 am

Re: After upgrade to CactiEZ 6.0 (0.8.7.c), can't add device

Post by TheBigAmbulance »

Something else I just noticed on the console:

Code: Select all

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Don't know if this is related or not.
User avatar
TheWitness
Developer
Posts: 17007
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: After upgrade to CactiEZ 6.0 (0.8.7.c), can't add device

Post by TheWitness »

Yes it is.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
TheBigAmbulance
Posts: 24
Joined: Mon Sep 29, 2008 8:47 am

Re: After upgrade to CactiEZ 6.0 (0.8.7.c), can't add device

Post by TheBigAmbulance »

So the 'mysql' server is not able to be written to. Is there a setting in Cacti to add a password? I have added a password to access 'mysql>', but I don't know if that is it or not.

Sorry for being vague. But I am not a mysql/cacti expert. That is why I'm asking for help.

I followed the instructions to upgrade from here: http://www.rawiriblundell.com/?p=916

I also found other instructions on this forum concerning the write fail, and then ran the database_upgrade.php script:

Code: Select all

[root@cacti mactrack]# pwd
/var/www/html/plugins/mactrack
[root@cacti mactrack]# php database_upgrade.php
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> snmp_timeout, Ok
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> snmp_retries, Ok
SUCCESS: Add Column,    Table -> mac_track_ports, Column -> dns_hostname, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_temp_ports, Column -> dns_hostname, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_ips, Column -> dns_hostname, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_devices, Column -> snmp_port, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_devices, Column -> macs_active, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_devices, Column -> snmp_sysName, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_devices, Column -> snmp_sysLocation, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_devices, Column -> snmp_sysContact, Already Exists!
SUCCESS: Create Table,  Table -> mac_track_scanning_functions, Already Exists!
SUCCESS: Execute SQL,   Change Primary Key For 'mac_track_devices', Ok
SUCCESS: Add Index,     Table -> mac_track_devices, Index -> device_id, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_sites, Column -> total_oper_ports, Already Exists!
SUCCESS: Execute SQL,   Change Primary Key For 'mac_track_device_types', Ok
SUCCESS: Add Index,     Table -> mac_track_device_types, Index -> device_type_id, Already Exists!
SUCCESS: Modify Column, Table -> mac_track_scanning_functions, Column -> scanning_function, Ok
SUCCESS: Modify Column, Table -> mac_track_scanning_functions, Column -> description, Ok
SUCCESS: Create Table,  Table -> mac_track_scan_dates, Already Exists!
SUCCESS: Execute SQL,   Addition of Scan Dates, Ok
SUCCESS: Add Index,     Table -> mac_track_devices, Index -> snmp_sysDescr, Already Exists!
SUCCESS: Add Index,     Table -> mac_track_devices, Index -> snmp_sysObjectID, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_devices, Column -> device_type_id, Already Exists!
SUCCESS: Add Index,     Table -> mac_track_devices, Index -> device_type_id, Already Exists!
SUCCESS: Add Index,     Table -> mac_track_ports, Index -> port_name, Already Exists!
SUCCESS: Add Index,     Table -> mac_track_ports, Index -> dns_hostname, Already Exists!
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> ips_total, Ok
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> vlans_total, Ok
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> ports_total, Ok
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> ports_active, Ok
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> ports_trunk, Ok
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> macs_active, Ok
SUCCESS: Add Column,    Table -> mac_track_temp_ports, Column -> updated, Already Exists!
SUCCESS: Add Index,     Table -> mac_track_temp_ports, Index -> updated, Already Exists!
SUCCESS: Add Index,     Table -> mac_track_temp_ports, Index -> ip_address, Already Exists!
SUCCESS: Create Table,  Table -> mac_track_ip_ranges, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_ip_ranges, Column -> ips_max_date, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_ip_ranges, Column -> ips_current_date, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_processes, Column -> device_id, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_processes, Column -> process_id, Already Exists!
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> snmp_readstring, Ok
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> snmp_readstrings, Ok
SUCCESS: Execute SQL,   Change mac_track_temp_ports to Memory Table, Ok
SUCCESS: Execute SQL,   Change mac_track_ips to Memory Table, Ok
SUCCESS: Create Table,  Table -> mac_track_approved_macs, Already Exists!
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> ignorePorts, Ok
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> snmp_readstring, Ok
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> snmp_readstrings, Ok
SUCCESS: Create Table,  Table -> mac_track_oui_database, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_ports, Column -> vendor_mac, Already Exists!
SUCCESS: Add Index,     Table -> mac_track_ports, Index -> vendor_mac, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_temp_ports, Column -> vendor_mac, Already Exists!
SUCCESS: Add Index,     Table -> mac_track_temp_ports, Index -> vendor_mac, Already Exists!
SUCCESS: Execute SQL,   Add Vendor Macs To 'mac_track_ports', Ok
SUCCESS: Execute SQL,   Add Vendor Macs To 'mac_track_temp_ports', Ok
SUCCESS: Add Column,    Table -> mac_track_temp_ports, Column -> authorized, Already Exists!
SUCCESS: Add Index,     Table -> mac_track_temp_ports, Index -> authorized, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_ports, Column -> authorized, Already Exists!
SUCCESS: Add Index,     Table -> mac_track_ports, Index -> authorized, Already Exists!
SUCCESS: Create Table,  Table -> mac_track_macwatch, Already Exists!
SUCCESS: Create Table,  Table -> mac_track_macauth, Already Exists!
SUCCESS: Create Table,  Table -> mac_track_vlans, Already Exists!
SUCCESS: Execute SQL,   Add VLANS to VLAN Table, Ok
ERROR: Modify Column, Table -> mac_track_devices, Column -> description, Column Does NOT Exist!
SUCCESS: Add Column,    Table -> mac_track_devices, Column -> device_name, Already Exists!
SUCCESS: Add Index,     Table -> mac_track_devices, Index -> device_name, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_sites, Column -> customer_contact, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_sites, Column -> netops_contact, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_sites, Column -> facilities_contact, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_sites, Column -> site_info, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_device_types, Column -> serial_number_oid, Already Exists!
ERROR: Execute SQL,   Move Device Names from the 'description' field to the 'device_name' field., Failed!
ERROR: Execute SQL,   Blank out the 'description' field as it will now be used for something else, Failed!
SUCCESS: Add Column,    Table -> mac_track_macwatch, Column -> email_addresses, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_macwatch, Column -> mac_id, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_macwatch, Column -> date_last_seen, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_macauth, Column -> mac_id, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_ports, Column -> device_name, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_temp_ports, Column -> device_name, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_devices, Column -> notes, Already Exists!
ERROR: Modify Column, Table -> mac_track_ips, Column -> description, Column Does NOT Exist!
SUCCESS: Delete Column, Table -> mac_track_devices, Column -> serial_number, Column Does NOT Exist!
SUCCESS: Delete Column, Table -> mac_track_devices, Column -> asset_id, Column Does NOT Exist!
SUCCESS: Create Table,  Table -> mac_track_interfaces, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_scanning_functions, Column -> type, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_device_types, Column -> ip_scanning_function, Already Exists!
SUCCESS: Execute SQL,   Update the Scanning Function Type to 'Mac' for undefined types, Ok
SUCCESS: Execute SQL,   Set the IP Scanning function to N/A for Device Type 1, Ok
SUCCESS: Execute SQL,   Set the IP Scanning function to 'get_standard_arp_table' for Routers and L3 Switches, Ok
SUCCESS: Add Column,    Table -> mac_track_interfaces, Column -> vlan_trunk, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_devices, Column -> user_name, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_devices, Column -> user_password, Already Exists!

Updating Device Types in Devices Table.  Please be patient.


Device Types Updated, You have '0' Good Device Type Mapping and '0' Bad Device Type Mapping.
If the Bad Device type mapping is greater than '0', you should inspect your devices for unmapped device types.

Importing the Vendor MAC Address Table from the IEEE

PHP Notice:  Undefined variable: oui_file in /var/www/html/plugins/mactrack/mactrack_import_ouidb.php on line 70

Notice: Undefined variable: oui_file in /var/www/html/plugins/mactrack/mactrack_import_ouidb.php on line 70
Getting OUI Database from the IEEE
OUI Database Download from IEEE Complete
............................................................................................................................................................
There were '15579' Entries Added/Updated in the database.
There were '0' Records Removed from the database.

Database Upgrade Complete
[root@cacti mactrack]#
Still not able to write a new device.

Looking for some fresh ideas.
TheBigAmbulance
Posts: 24
Joined: Mon Sep 29, 2008 8:47 am

Re: After upgrade to CactiEZ 6.0 (0.8.7.c), can't add device

Post by TheBigAmbulance »

Here are the stats on my server.
Cacti Version - 0.8.7c
Plugin Architecture - 2.2
Poller Type - Cactid v
Server Info - Linux 2.6.9-101.plus.c4smp
Web Server - Apache/2.0.63 (CentOS)
PHP - 5.1.6
PHP Extensions - libxml, xml, wddx, tokenizer, sysvshm, sysvsem, sysvmsg, standard, SimpleXML, sockets, SPL, shmop, session, Reflection, pspell, posix, mime_magic, iconv, hash, gmp, gettext, ftp, exif, date, curl, ctype, calendar, bz2, zlib, pcre, openssl, apache2handler, gd, ldap, mysql, mysqli, PDO, pdo_mysql, pdo_sqlite, snmp, eAccelerator
MySQL - 5.0.82sp1
RRDTool - 1.2.23
SNMP - 5.1.2
Plugins
  • Global Plugin Settings (settings - v0.5)
    Large Site Performane Booster for Cacti (boost - v2.2)
    Device Monitoring (monitor - v0.8.2)
    Network Discovery (discovery - v0.8.5)
    Network Tools (tools - v0.3)
    Syslog Monitoring (syslog - v0.5.2)
    Device Tracking (mactrack - v1.1)
    Login Page Mod (loginmod - v1.0)
    Update Checker (update - v0.4)
    FlowView (flowview - v0.6)
    Host Info (hostinfo - v0.2)
    Error Images (errorimage - v0.1)
    PHP Network Weathermap (weathermap - v0.95b)
    docs
    Cacti-ReportIt (reportit - v0.6.1)
    Router Configs (routerconfigs - v0.1)
    WMI Query (wmi - v0.1)
    Realtime for Cacti (realtime - v0.35)
Pretty much a stock install of CactiEZ.
TheBigAmbulance
Posts: 24
Joined: Mon Sep 29, 2008 8:47 am

Re: [SOLVED] upgrade to CactiEZ 6.0 (0.8.7.c), can't add dev

Post by TheBigAmbulance »

I disabled the 'wmi' plugin in the global.php file. I can now add devices.
User avatar
TheWitness
Developer
Posts: 17007
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: [SOLVED] upgrade to CactiEZ 6.0 (0.8.7.c), can't add dev

Post by TheWitness »

GZip the wmi plugin and post it here, or PM it to me.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
TheBigAmbulance
Posts: 24
Joined: Mon Sep 29, 2008 8:47 am

Re: [SOLVED] upgrade to CactiEZ 6.0 (0.8.7.c), can't add dev

Post by TheBigAmbulance »

My file is 6.8 megs, and the forum doesn't allow anything larger than 3.
User avatar
TheWitness
Developer
Posts: 17007
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: [SOLVED] upgrade to CactiEZ 6.0 (0.8.7.c), can't add dev

Post by TheWitness »

The WMI directory should be much smaller than that. /var/www/html/cacti/plugins/wmi.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
TheBigAmbulance
Posts: 24
Joined: Mon Sep 29, 2008 8:47 am

Re: [SOLVED] upgrade to CactiEZ 6.0 (0.8.7.c), can't add dev

Post by TheBigAmbulance »

Code: Select all

[root@cacti plugins]# pwd
/var/www/html/plugins
[root@cacti plugins]# du -hs ./wmi/
25M     ./wmi/
[root@cacti plugins]#

[root@cacti html]# ls -hal ./plugins/wmi
total 25M
drwxr-xr-x   4 apache apache 4.0K Oct 14 16:36 .
drwxr-xr-x  24 apache apache 4.0K Oct 18 15:51 ..
-rw-r--r--   1 apache apache  12K Oct 14 16:36 functions.php
-rw-r--r--   1 apache apache  27K Oct 14 16:36 LICENSE
-rw-r--r--   1 apache apache 5.4K Oct 14 16:36 linux-wmi.php
-rw-r--r--   1 apache apache  971 Oct 14 16:36 README
drwxr-xr-x   2 apache apache 4.0K Oct 14 16:36 script
-rw-r--r--   1 apache apache 5.4K Oct 14 16:36 setup.php
drwxr-xr-x   3 apache apache 4.0K Oct 14 16:36 templates
-rw-r--r--   1 apache apache 4.8M Oct 14 16:36 winexe32
-rw-r--r--   1 apache apache 5.7M Oct 14 16:36 winexe64
-rw-r--r--   1 apache apache  11K Oct 14 16:36 wmi-accounts.php
-rw-r--r--   1 apache apache 5.5M Oct 14 16:36 wmic32
-rw-r--r--   1 apache apache 8.0M Oct 14 16:36 wmic64
-rw-r--r--   1 apache apache  12K Oct 14 16:36 wmi-queries.php
-rw-r--r--   1 apache apache 1.4K Oct 14 16:36 wmi.sql
-rw-r--r--   1 apache apache 4.6K Oct 14 16:36 wmi-tools.php
[root@cacti html]#
User avatar
TheWitness
Developer
Posts: 17007
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: [SOLVED] upgrade to CactiEZ 6.0 (0.8.7.c), can't add dev

Post by TheWitness »

Just remove the wmi binaries from the tar package. Just need the PHP, SQL, and README files.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
TheBigAmbulance
Posts: 24
Joined: Mon Sep 29, 2008 8:47 am

Re: [SOLVED] upgrade to CactiEZ 6.0 (0.8.7.c), can't add dev

Post by TheBigAmbulance »

Here ya go...
Attachments
wmi.zip
(30.51 KiB) Downloaded 98 times
User avatar
TheWitness
Developer
Posts: 17007
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: [SOLVED] upgrade to CactiEZ 6.0 (0.8.7.c), can't add dev

Post by TheWitness »

Thanks. There are definitely differences. Checking...
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests