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

[karias]

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

We're actually migrating to this new server from our current production one due to number of devices and datasources. So we were just following upgrade instructions as related to db import. Please advise if incorrect.

[karias]

Current prod cacti server info 32 bit OS-

Cacti Version - 0.8.6g
Poller Type - Cactid v0.8.6f
Server Info - Linux 2.6.9-5.ELsmp
Web Server - Apache/2.0.52 (Red Hat)
PHP - 4.3.9
PHP Extensions - yp, xml, wddx, tokenizer, sysvshm, sysvsem, standard, sockets, shmop, session, pspell, posix, pcre, overload, mime_magic, iconv, gmp, gettext, ftp, exif, dio, dbx, dba, curl, ctype, calendar, bz2, bcmath, zlib, openssl, apache2handler, ldap, mysql
MySQL - 4.1.7
RRDTool - 1.2.11
SNMP - 5.1.2
Plugins

• Host Info (hostinfo - v0.1)
  monitor - v0.5
  reports - v0.1b
  thold - v0.2.6
  RRD Cleaner - v1.2
  Uptime (uptime - v0.3)
  Update Checker (update - v0.2)

Migrating to new Cacti server 64 bit OS-

Cacti Version - 0.8.7
Plugin Architecture - 1.3
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, mysqli, mysql, PDO, pdo_mysql, pdo_sqlite, snmp
MySQL - 5.0.22
RRDTool - 1.2.23
SNMP - 5.3.1
Plugins

• Documents (docs - v0.1)
  Host Info (hostinfo - v0.2)
  Global Plugin Settings (settings - v0.3)
  SSL Redirector (ssl - v0.1)
  Thresholds (thold - v0.3.6)
  Network Tools (tools - v0.2)
  Update Checker (update - v0.4)

[ejensen]

I just did a fresh replace of my cacti to the 8.7 version and after adding the monitor plugin I had the same problems with "Save Failed" errors.

I fixed it by going into user administration and making sure that the admin user had access to the monitor plugin. this solved my problem with this particular error.

hope that helps anyone else!

[gandalf]

Did you already verify to use the latest version of that plugin?
Reinhard

[karias]

Did you already verify to use the latest version of that plugin?
Reinhard

Yep, grabbed it from http://cactiusers.org/downloads/

[gandalf]

Are you able to reproduce, when deactivating "monitor"
Reinhard

[karias]

Are you able to reproduce, when deactivating "monitor"
Reinhard

We just commented monitor out from global.php and the error no longer exists. Hopefully that is what you're asking?

[gandalf]

From you host information, your monitor is at 05b, where 0.81 is current
Reinhard

[karias]

From you host information, your monitor is at 05b, where 0.81 is current
Reinhard

Current prod, we have no issues. The issue is on the new 64 bit OS we're going to, where its disabled, so host info plugin won't show it.

[karias]

I just did a fresh replace of my cacti to the 8.7 version and after adding the monitor plugin I had the same problems with "Save Failed" errors.

I fixed it by going into user administration and making sure that the admin user had access to the monitor plugin. this solved my problem with this particular error.

hope that helps anyone else!

Didn't work for me. Please see attachment. I've included current host info screen shot and admin realm screen shot.

[gandalf]

Are you able to reproduce, when deactivating "monitor"
Reinhard

We just commented monitor out from global.php and the error no longer exists. Hopefully that is what you're asking?

So monitor 0.81 on 64bit OS is breaking it, correct? In this case, please contact cigamit and/or post to the monitor thread in the Plugins forum
Reinhard

[cigamit]

Yep, its not allowing you to update the table. Run this query and see if it fixes it.
ALTER TABLE host ADD monitor_text text default '' not null AFTER monitor

[karias]

Cigamit, you are the man! That command worked, I can save devices now.

[karias]

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

We're actually migrating to this new server from our current production one due to number of devices and datasources. So we were just following upgrade instructions as related to db import. Please advise if incorrect.

Should I open up a new thread for this? Much thx and appreciation to all you guys! This is an awesome tool, keep up the good work!