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

[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?

[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.

[TheWitness]

Yes it is.

[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]

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]

I disabled the 'wmi' plugin in the global.php file. I can now add devices.

[TheWitness]

GZip the wmi plugin and post it here, or PM it to me.

[TheBigAmbulance]

My file is 6.8 megs, and the forum doesn't allow anything larger than 3.

[TheWitness]

The WMI directory should be much smaller than that. /var/www/html/cacti/plugins/wmi.

[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]#

[TheWitness]

Just remove the wmi binaries from the tar package. Just need the PHP, SQL, and README files.

[TheBigAmbulance]

Here ya go...

[TheWitness]

Thanks. There are definitely differences. Checking...