Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-1540

Template import or add fails with "ipmi_ip" can't be null message

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Major
    • Resolution: Cannot Reproduce
    • 1.8
    • None
    • Frontend (F)
    • None
    • Solaris 10, PHP 5.3.1

    Description

      I get this when I try to either add a template or import one.
      SQL error [ORA-01400: cannot insert NULL into ("ZABBIX_DBUSER"."HOSTS"."IPMI_IP")] in [INSERT INTO hosts (hostid,proxy_hostid,host,port,status,useip,dns,ip,disable_until,available,useipmi,ipmi_port,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,ipmi_ip) VALUES (10165,0,'SMP_7404',10050,3,0,'','0.0.0.0',0,0,0,623,0,0,'','','')]

      Clearly the dbpatch has implications here:

      alter table hosts add ipmi_ip nvarchar2(64) DEFAULT '127.0.0.1' NOT NULL;
      alter table hosts modify ipmi_ip nvarchar2(64) DEFAULT '127.0.0.1';

      Should this allow for NULL since we have a default?

      Attachments

        Activity

          People

            alexei Alexei Vladishev
            untergeek Aaron Mildenstein
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: