Need some assistance with 8.7 - can't save/create any device

[karias]

See below.

Cacti Version - 0.8.7
Plugin Architecture - 1.2
Poller Type - Cactid v
Server Info - Linux 2.6.18-8.el5
Web Server - Apache/2.2.3 (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, ldap, mysql, mysqli, PDO, pdo_mysql, pdo_sqlite, snmp
MySQL - 5.0.22
RRDTool - 1.2.23
SNMP - 5.3.1
Plugins

• Network Discovery (discovery - v0.
  Documents (docs - v0.1)
  Host Info (hostinfo - v0.2)
  Device Monitoring (monitor - v0.
  NTop Viewer (ntop - v0.1)
  Global Plugin Settings (settings - v0.3)
  SSL Redirector (ssl - v0.1)
  Syslog Monitoring (syslog - v0.5)
  Thresholds (thold - v0.3.6)
  Network Tools (tools - v0.2)
  Update Checker (update - v0.4)

[karias]

Here's more output from the log, I've disabled all 1000+ devices except localhost now. I don't see any rrd processes kicking off.....need help.

[karias]

Now, we've just dropped that database and are with a fresh install. The error we're getting is adding any device(s) other than local host. Get error, "Save Failed." Anyone out there experiencing this or have any advice on how to correct this?

[karias]

It looks like I can't even update localhost

[gandalf]

Please post "System Utilities -> Technical Support"
Reinhard

[karias]

As requested.

[karias]

It seems when I try to import my current prod sql db with 1k devices into the new sql db, I can't save.

current prod rpm
php-mysql-4.3.9-3.1
libdbi-dbd-mysql-0.6.5-10.RHEL4.1
mysql-4.1.7-4.RHEL4.1
perl-DBD-MySQL-2.9004-3.1
mysql-devel-4.1.7-4.RHEL4.1
mysql-server-4.1.7-4.RHEL4.1
mysqlclient10-3.23.58-4.RHEL4.1
MySQL-python-1.0.0-1.RHEL4.1

new sql rpm
python-sqlite-1.1.7-1.2.1
postgresql-libs-8.1.4-1.1
MySQL-python-1.2.1-1
mysql-devel-5.0.22-2.1
hsqldb-1.8.0.4-3jpp.4
sqlite-3.3.6-2
mysql-server-5.0.22-2.1
mysql-connector-odbc-3.51.12-2.2
sqlite-devel-3.3.6-2
mysql-5.0.22-2.1
mysql-5.0.22-2.1
perl-DBD-MySQL-3.0007-1.fc6
php-mysql-5.1.6-5.el5
sqlite-3.3.6-2
postgresql-libs-8.1.4-1.1
libdbi-dbd-mysql-0.8.1a-1.2.2

Is there any modifications I need to make...?

[rony]

Ok,

Have you tried this with out the Plugin Architecture?

Are you running the latest PIA? 1.3?

[karias]

Hey rony, just installed the new version of PIA 1.3. We have identified that it is the monitor plugin that is causing the "Save Failure." We have left his commented out of the global.php. Thx!

[rony]

While it sucks that the plugin was causing the problems, I'm glad you found the issue.

[cigamit]

I can not reproduce this with the Monitor plugin in both my test environment and my production systems. Does your DB user have access to alter tables? As the monitor plugin requires a few new columns in the host table and will automatically add it for you if they are not found.

[karias]

Our db user, cactiuser, has full access.

[cigamit]

Can you post the output of this command?

SHOW COLUMNS FROM host

[TheWitness]

If you dumped your old database and then imported it using mysqldump and mysql < *.sql, you effectively hosed your configuration. That is not how you upgrade.

Please confirm what process you used to "import your devices". If my assumption is correct, you can recover, it's just a bit of a pain with 0.8.7.

TheWitness

[karias]

As requested cigamit -

mysql> show columns from host;
+----------------------+-----------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+-----------------------+------+-----+---------------------+----------------+
| id | mediumint(8) unsigned | NO | PRI | NULL | auto_increment |
| host_template_id | mediumint(8) unsigned | NO | | 0 | |
| description | varchar(150) | NO | | NULL | |
| hostname | varchar(250) | YES | | NULL | |
| notes | text | YES | | NULL | |
| snmp_community | varchar(100) | YES | | NULL | |
| snmp_version | tinyint(1) unsigned | NO | | 1 | |
| snmp_username | varchar(50) | YES | | NULL | |
| snmp_password | varchar(50) | YES | | NULL | |
| snmp_auth_protocol | char(5) | YES | | NULL | |
| snmp_priv_passphrase | varchar(200) | YES | | NULL | |
| snmp_priv_protocol | char(6) | YES | | NULL | |
| snmp_context | varchar(64) | YES | | NULL | |
| snmp_port | mediumint(5) unsigned | NO | | 161 | |
| snmp_timeout | mediumint(8) unsigned | NO | | 500 | |
| availability_method | smallint(5) unsigned | NO | | 2 | |
| ping_method | smallint(5) unsigned | YES | | 0 | |
| ping_port | int(12) unsigned | YES | | 0 | |
| ping_timeout | int(12) unsigned | YES | | 500 | |
| ping_retries | int(12) unsigned | YES | | 2 | |
| max_oids | int(12) unsigned | YES | | 10 | |
| disabled | char(2) | YES | MUL | NULL | |
| uptime | char(3) | NO | | on | |
| monitor | char(3) | NO | | on | |
| status | tinyint(2) | NO | | 0 | |
| status_event_count | mediumint(8) unsigned | NO | | 0 | |
| status_fail_date | datetime | NO | | 0000-00-00 00:00:00 | |
| status_rec_date | datetime | NO | | 0000-00-00 00:00:00 | |
| status_last_error | varchar(255) | YES | | NULL | |
| min_time | decimal(10,5) | YES | | 9.99999 | |
| max_time | decimal(10,5) | YES | | 0.00000 | |
| cur_time | decimal(10,5) | YES | | 0.00000 | |
| avg_time | decimal(10,5) | YES | | 0.00000 | |
| total_polls | int(12) unsigned | YES | | 0 | |
| failed_polls | int(12) unsigned | YES | | 0 | |
| availability | decimal(7,5) | NO | | 99.99999 | |
+----------------------+-----------------------+------+-----+---------------------+----------------+
36 rows in set (0.00 sec)