ipplanv6 find free error

Help
ACDII
2011-03-24
2013-05-09
  • ACDII

    ACDII - 2011-03-24

    When I try to find free space, I get the following error.

    Content Encoding Error

         

         
         
         

         
           
           

             

    The page you are trying to view cannot be shown because it uses an invalid or unsupported form of compression.

           

           
           

        *   Please contact the website owners to inform them of this problem.

    This is in all browsers and different machines.

     
  • ASeques

    ASeques - 2011-03-25

    BETA2 doesn't work very well, I'd suggest you to use BETA3 from the cvs, it's working better with ipv6 and also has better support for newer (5.3) versions of php.

     
  • ACDII

    ACDII - 2011-03-28

    Downloaded and tried to install B3, and it fails to properly create the DB. Missing one part of a table.

    ALTER TABLE ipaddrlnk ADD  INDEX ipaddrlnk_dst  (dstipaddr, dstcustomer);

    Failed to execute above statement against database

    Key column 'dstcustomer' doesn't exist in table

     
  • ACDII

    ACDII - 2011-03-28

    Here is the schema.sql file.  If it helps any.

    <br />
    <b>Notice</b>:  Use of undefined constant E_DEPRECATED - assumed 'E_DEPRECATED' in <b>/var/www/web16/web/ipplanv6/ipplanlib.php</b> on line <b>64</b><br />
    # You may need to remove the comment lines - lines that start with #

    #zlib support compiled into php
    #output to webrowser will be compressed for quicker loading of pages if web browser supports compression

    CREATE TABLE area (
    areaaddr                 VARCHAR(39) NOT NULL DEFAULT '',
    descrip                  VARCHAR(80) NOT NULL DEFAULT '',
    areaindex                BIGINT NOT NULL AUTO_INCREMENT,
    customer                 SMALLINT UNSIGNED NOT NULL DEFAULT 0,
                     PRIMARY KEY (areaindex)
    )TYPE=INNODB;

    ALTER TABLE area ADD  UNIQUE INDEX area_customer  (customer, descrip);

    ALTER TABLE area ADD  UNIQUE INDEX area_areaaddr  (areaaddr, customer);

    CREATE TABLE auditlog (
    userid                   VARCHAR(40) DEFAULT '',
    action                   VARCHAR(254) NOT NULL DEFAULT '',
    dt                       TIMESTAMP NOT NULL
    )TYPE=INNODB;

    ALTER TABLE auditlog ADD  INDEX auditlog_dt  (dt);

    CREATE TABLE base (
    baseaddr                 VARCHAR(39) NOT NULL DEFAULT '',
    subnetsize               SMALLINT UNSIGNED NOT NULL DEFAULT 0,
    descrip                  VARCHAR(80) NOT NULL DEFAULT '',
    baseindex                BIGINT NOT NULL AUTO_INCREMENT,
    admingrp                 VARCHAR(40) NOT NULL DEFAULT '',
    customer                 SMALLINT UNSIGNED NOT NULL DEFAULT 0,
    lastmod                  TIMESTAMP NOT NULL,
    userid                   VARCHAR(40) DEFAULT '',
    baseopt                  INT UNSIGNED DEFAULT 0,
    delegation               VARCHAR(100) DEFAULT '',
    swipmod                  DATETIME,
                     PRIMARY KEY (baseindex)
    )TYPE=INNODB;

    ALTER TABLE base ADD  UNIQUE INDEX base_baseaddr  (baseaddr, customer);

    ALTER TABLE base ADD  INDEX base_customer  (customer);

    ALTER TABLE base ADD  INDEX base_admingrp  (admingrp);

    CREATE TABLE baseadd (
    baseindex                BIGINT NOT NULL DEFAULT 0,
    info                     TEXT,
    infobin                  LONGBLOB DEFAULT '',
    infobinfn                VARCHAR(255) DEFAULT '',
                     PRIMARY KEY (baseindex)
    )TYPE=INNODB;

    CREATE TABLE basedns (
    id                       BIGINT NOT NULL DEFAULT 0,
    hname                    VARCHAR(100) NOT NULL DEFAULT '',
    ttl                      INTEGER DEFAULT 0,
    horder                   TINYINT UNSIGNED NOT NULL DEFAULT 0
    )TYPE=INNODB;

    ALTER TABLE basedns ADD  INDEX basedns_id  (id);

    CREATE TABLE custinfo (
    customer                 SMALLINT UNSIGNED NOT NULL DEFAULT 0,
    org                      VARCHAR(100) DEFAULT '',
    street                   VARCHAR(255) DEFAULT '',
    city                     VARCHAR(80) DEFAULT '',
    state                    VARCHAR(2) DEFAULT '',
    zipcode                  VARCHAR(10) DEFAULT '',
    cntry                    VARCHAR(2) DEFAULT '',
    maint                    VARCHAR(80) DEFAULT '',
    nichandl                 VARCHAR(80) DEFAULT '',
    lname                    VARCHAR(80) DEFAULT '',
    fname                    VARCHAR(80) DEFAULT '',
    mname                    VARCHAR(80) DEFAULT '',
    torg                     VARCHAR(100) DEFAULT '',
    tstreet                  VARCHAR(255) DEFAULT '',
    tcity                    VARCHAR(80) DEFAULT '',
    tstate                   VARCHAR(2) DEFAULT '',
    tzipcode                 VARCHAR(10) DEFAULT '',
    tcntry                   VARCHAR(2) DEFAULT '',
    phne                     VARCHAR(20) DEFAULT '',
    mbox                     VARCHAR(100) DEFAULT '',
                     PRIMARY KEY (customer)
    )TYPE=INNODB;

    CREATE TABLE custadd (
    customer                 SMALLINT UNSIGNED NOT NULL DEFAULT 0,
    info                     TEXT,
    infobinfn                VARCHAR(255) DEFAULT '',
                     PRIMARY KEY (customer)
    )TYPE=INNODB;

    CREATE TABLE customer (
    custdescrip              VARCHAR(80) NOT NULL DEFAULT '',
    customer                 SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
    crm                      VARCHAR(20) DEFAULT '',
    admingrp                 VARCHAR(40) NOT NULL DEFAULT '',
                     PRIMARY KEY (customer)
    )TYPE=INNODB;

    ALTER TABLE customer ADD  UNIQUE INDEX customer_custdescrip  (custdescrip);

    ALTER TABLE customer ADD  INDEX customer_crm  (crm);

    ALTER TABLE customer ADD  INDEX customer_admingrp  (admingrp);

    CREATE TABLE grp (
    grpdescrip               VARCHAR(80) NOT NULL DEFAULT '',
    grp                      VARCHAR(40) NOT NULL DEFAULT '',
    createcust               VARCHAR(1) NOT NULL DEFAULT 'N',
    resaddr                  SMALLINT UNSIGNED DEFAULT 0,
    grpopt                   INT UNSIGNED NOT NULL DEFAULT 0,
                     PRIMARY KEY (grp)
    )TYPE=INNODB;

    ALTER TABLE grp ADD  UNIQUE INDEX grp_grpdescrip  (grpdescrip);

    CREATE TABLE ipaddr (
    ipaddr                   VARCHAR(39) NOT NULL DEFAULT '',
    userinf                  VARCHAR(80) DEFAULT '',
    location                 VARCHAR(80) DEFAULT '',
    telno                    VARCHAR(15) DEFAULT '',
    descrip                  VARCHAR(80) DEFAULT '',
    hname                    VARCHAR(100) DEFAULT '',
    macaddr                  VARCHAR(12) DEFAULT '',
    baseindex                BIGINT NOT NULL DEFAULT 0,
    lastmod                  TIMESTAMP NOT NULL,
    lastpol                  DATETIME,
    ttl                      INTEGER DEFAULT 0,
    recordtype               VARCHAR(5) DEFAULT '',
    userid                   VARCHAR(40) DEFAULT '',
                     PRIMARY KEY (ipaddr, baseindex)
    )TYPE=INNODB;

    ALTER TABLE ipaddr ADD  INDEX ipaddr_baseindex  (baseindex);

    CREATE TABLE ipaddradd (
    ipaddr                   VARCHAR(39) NOT NULL DEFAULT '',
    baseindex                BIGINT NOT NULL DEFAULT 0,
    info                     TEXT,
    infobin                  LONGBLOB DEFAULT '',
    infobinfn                VARCHAR(255) DEFAULT '',
                     PRIMARY KEY (ipaddr, baseindex)
    )TYPE=INNODB;

    ALTER TABLE ipaddradd ADD  INDEX ipaddradd_baseindex  (baseindex);

    CREATE TABLE ipaddrlnk (
    ipaddr                   VARCHAR(39) NOT NULL DEFAULT '',
    baseindex                BIGINT NOT NULL DEFAULT 0,
    customer                 SMALLINT UNSIGNED NOT NULL DEFAULT 0,
    dstipaddr                VARCHAR(39) NOT NULL DEFAULT '',
    dstbaseindex             BIGINT NOT NULL DEFAULT 0
    )TYPE=INNODB;

    ALTER TABLE ipaddrlnk ADD  UNIQUE INDEX ipaddrlnk_uniq  (baseindex, ipaddr, customer, dstipaddr, dstbaseindex);

    ALTER TABLE ipaddrlnk ADD  INDEX ipaddrlnk_dst  (dstipaddr, dstcustomer);

    ALTER TABLE ipaddrlnk ADD  INDEX ipaddrlnk_src  (ipaddr, customer);

    CREATE TABLE requestip (
    requestindex             INTEGER NOT NULL AUTO_INCREMENT,
    customer                 SMALLINT UNSIGNED NOT NULL DEFAULT 0,
    requestdesc              VARCHAR(80) DEFAULT '',
    userinf                  VARCHAR(80) DEFAULT '',
    location                 VARCHAR(80) DEFAULT '',
    telno                    VARCHAR(15) DEFAULT '',
    descrip                  VARCHAR(80) DEFAULT '',
    hname                    VARCHAR(100) DEFAULT '',
    macaddr                  VARCHAR(12) DEFAULT '',
    lastmod                  TIMESTAMP NOT NULL,
    info                     TEXT,
                     PRIMARY KEY (requestindex)
    )TYPE=INNODB;

    ALTER TABLE requestip ADD  UNIQUE INDEX requestip_desc  (customer, requestdesc);

    CREATE TABLE netrange (
    rangeaddr                VARCHAR(39) NOT NULL DEFAULT '',
    rangesize                SMALLINT UNSIGNED NOT NULL DEFAULT 0,
    descrip                  VARCHAR(80) NOT NULL DEFAULT '',
    rangeindex               BIGINT NOT NULL AUTO_INCREMENT,
    areaindex                BIGINT NOT NULL DEFAULT 0,
    customer                 SMALLINT UNSIGNED NOT NULL DEFAULT 0,
                     PRIMARY KEY (rangeindex)
    )TYPE=INNODB;

    ALTER TABLE netrange ADD  INDEX range_rangeaddr  (rangeaddr, customer);

    ALTER TABLE netrange ADD  UNIQUE INDEX range_customer  (customer, descrip);

    ALTER TABLE netrange ADD  INDEX range_areaindex  (areaindex);

    CREATE TABLE revdns (
    customer                 SMALLINT UNSIGNED NOT NULL DEFAULT 0,
    hname                    VARCHAR(100) NOT NULL DEFAULT '',
    ipaddr                   VARCHAR(39) NOT NULL DEFAULT '',
    horder                   TINYINT UNSIGNED NOT NULL DEFAULT 0
    )TYPE=INNODB;

    ALTER TABLE revdns ADD  INDEX revdns_customer  (customer);

    CREATE TABLE version (
    version                  INTEGER NOT NULL DEFAULT 0
    )TYPE=INNODB;

    CREATE TABLE users (
    userid                   VARCHAR(40) NOT NULL DEFAULT '',
    userdescrip              VARCHAR(80) NOT NULL DEFAULT '',
    useremail                VARCHAR(64) DEFAULT '',
    password                 VARCHAR(40) NOT NULL DEFAULT '',
                     PRIMARY KEY (userid)
    )TYPE=INNODB;

    CREATE TABLE usergrp (
    userid                   VARCHAR(40) NOT NULL DEFAULT '',
    grp                      VARCHAR(40) NOT NULL DEFAULT ''
    )TYPE=INNODB;

    ALTER TABLE usergrp ADD  UNIQUE INDEX usergrp_userid  (userid, grp);

    ALTER TABLE usergrp ADD  INDEX usergrp_grp  (grp);

    CREATE TABLE bounds (
    boundsaddr               VARCHAR(39) NOT NULL DEFAULT '',
    boundssize               SMALLINT UNSIGNED NOT NULL DEFAULT 0,
    grp                      VARCHAR(40) NOT NULL DEFAULT ''
    )TYPE=INNODB;

    ALTER TABLE bounds ADD  INDEX bounds_grp  (grp);

    ALTER TABLE bounds ADD  INDEX bounds_boundsaddr  (boundsaddr);

    CREATE TABLE fwdzone (
    data_id                  BIGINT NOT NULL AUTO_INCREMENT,
    domain                   VARCHAR(254) NOT NULL DEFAULT '',
    createmod                DATE DEFAULT null,
    lastmod                  DATETIME DEFAULT null,
    regmod                   DATE DEFAULT null,
    expiremod                DATETIME DEFAULT null,
    engineer                 VARCHAR(254) DEFAULT '',
    error_message            VARCHAR(254) DEFAULT '',
    responsiblemail          VARCHAR(64) DEFAULT '',
    serialdate               VARCHAR(8) NOT NULL DEFAULT '',
    serialnum                INTEGER DEFAULT 0,
    ttl                      INTEGER DEFAULT 0,
    refresh                  INTEGER DEFAULT 0,
    retry                    INTEGER DEFAULT 0,
    expire                   INTEGER DEFAULT 0,
    minimum                  INTEGER DEFAULT 0,
    userid                   VARCHAR(40) DEFAULT '',
    lastexp                  DATETIME DEFAULT null,
    slaveonly                VARCHAR(1) NOT NULL DEFAULT 'N',
    zonefilepath1            VARCHAR(254) DEFAULT '',
    zonefilepath2            VARCHAR(254) DEFAULT '',
    customer                 SMALLINT UNSIGNED NOT NULL DEFAULT 0,
    aliasdataid              BIGINT DEFAULT 0,
    admingrp                 VARCHAR(40) DEFAULT '',
                     PRIMARY KEY (data_id)
    )TYPE=INNODB;

    ALTER TABLE fwdzone ADD  INDEX fwdzone_customer  (customer);

    ALTER TABLE fwdzone ADD  INDEX fwdzone_domain  (domain);

    CREATE TABLE fwdzoneadd (
    customer                 SMALLINT UNSIGNED NOT NULL DEFAULT 0,
    data_id                  BIGINT NOT NULL DEFAULT 0,
    info                     TEXT,
    infobinfn                VARCHAR(255) DEFAULT ''
    )TYPE=INNODB;

    ALTER TABLE fwdzoneadd ADD  UNIQUE INDEX fwdzoneadd_customer  (customer, data_id);

    CREATE TABLE fwdzonerec (
    recidx                   BIGINT NOT NULL AUTO_INCREMENT,
    data_id                  BIGINT NOT NULL DEFAULT 0,
    lastmod                  DATETIME DEFAULT null,
    host                     VARCHAR(254) NOT NULL DEFAULT '',
    ttl                      INTEGER DEFAULT 0,
    recordtype               VARCHAR(5) NOT NULL DEFAULT '',
    ip_hostname              VARCHAR(254) NOT NULL DEFAULT '',
    error_message            VARCHAR(254) DEFAULT '',
    sortorder                INTEGER NOT NULL DEFAULT 0,
    userid                   VARCHAR(40) NOT NULL DEFAULT '',
    customer                 SMALLINT UNSIGNED NOT NULL DEFAULT 0,
                     PRIMARY KEY (recidx)
    )TYPE=INNODB;

    ALTER TABLE fwdzonerec ADD  INDEX fwdzonerec_data_id  (data_id);

    ALTER TABLE fwdzonerec ADD  INDEX fwdzonerec_sortorder  (sortorder);

    ALTER TABLE fwdzonerec ADD  INDEX fwdzonerec_customer  (customer);

    CREATE TABLE fwddns (
    id                       BIGINT NOT NULL DEFAULT 0,
    hname                    VARCHAR(100) NOT NULL DEFAULT '',
    ttl                      INTEGER DEFAULT 0,
    horder                   TINYINT UNSIGNED NOT NULL DEFAULT 0
    )TYPE=INNODB;

    ALTER TABLE fwddns ADD  INDEX fwddns_id  (id);

    CREATE TABLE zones (
    id                       BIGINT NOT NULL AUTO_INCREMENT,
    zoneip                   VARCHAR(39) NOT NULL DEFAULT '',
    zonesize                 SMALLINT UNSIGNED NOT NULL DEFAULT 0,
    zone                     VARCHAR(254) NOT NULL DEFAULT '',
    error_message            VARCHAR(254) DEFAULT '',
    lastmod                  DATETIME DEFAULT null,
    serialdate               VARCHAR(8) NOT NULL DEFAULT '',
    serialnum                INTEGER DEFAULT 0,
    ttl                      INTEGER DEFAULT 0,
    refresh                  INTEGER DEFAULT 0,
    retry                    INTEGER DEFAULT 0,
    expire                   INTEGER DEFAULT 0,
    minimum                  INTEGER DEFAULT 0,
    userid                   VARCHAR(40) DEFAULT '',
    lastexp                  DATETIME DEFAULT null,
    slaveonly                VARCHAR(1) NOT NULL DEFAULT 'N',
    zonefilepath1            VARCHAR(254) DEFAULT '',
    zonefilepath2            VARCHAR(254) DEFAULT '',
    responsiblemail          VARCHAR(64) DEFAULT '',
    customer                 SMALLINT UNSIGNED NOT NULL DEFAULT 0,
                     PRIMARY KEY (id)
    )TYPE=INNODB;

    ALTER TABLE zones ADD  INDEX zones_customer  (customer);

    ALTER TABLE zones ADD  INDEX zones_zoneip  (zoneip);

    CREATE TABLE zonedns (
    id                       BIGINT NOT NULL DEFAULT 0,
    hname                    VARCHAR(100) NOT NULL DEFAULT '',
    ttl                      INTEGER DEFAULT 0,
    horder                   TINYINT UNSIGNED NOT NULL DEFAULT 0
    )TYPE=INNODB;

    ALTER TABLE zonedns ADD  INDEX zonedns_id  (id);

    BEGIN;

    INSERT INTO version (version) VALUES (23);

    COMMIT;

    #The above commands need to be executed by the administrator to create the database schema for IPplan

     
  • Nobody/Anonymous

    I'm seeing that too… Which type does that field need to  be?

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks