(no subject)

Help
Kamal
2014-07-17
2014-07-17
  • Kamal

    Kamal - 2014-07-17

    TITLE - Installation Errors

    Good Morning Team,

    After following all the instructions on OpenManiak, when I try to install, I come across the follwoing errors. I would appreciate any and all kinds of help as obvoius as they might seem.

    If you see this message, submit a detailed bug report on Sourceforge including the message below, the database platform used and the steps to perform to recreate the problem.

    PHP 5.5.9-1ubuntu4.2 (Linux)
    Unknown error type: [8192] Function set_magic_quotes_runtime() is deprecated Line: 68 File: /var/www/ipplanv6/ipplanlib.php

    snmp support not compiled into php

    importing from routing tables and direct query of device will not work

    zlib support compiled into php

    output to webrowser will be compressed for quicker loading of pages if web browser supports compression

    File uploads to ip records may not work - unable to create file in /var/spool/ipplanuploads - check permissions

    DNS zone file exports do not work - unable to create file in /tmp/dns/ - check permissions

    DHCP exports do not work - unable to create file in /tmp/dhcp/ - check permissions

    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;

    Failed to execute above statement against database

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=INNODB' at line 7

    Especially the last one with the creating of tables. I have googled extensively and I know I am supposed to modify some script but I do not have access to the var/lib/mysql directory

    How do I fix this error?

     
    Last edit: Kamal 2014-07-17
  • Kamal

    Kamal - 2014-07-17

    Problem Solved - Albeit more than a few hair hairs were lost in this process

    For everyone that had a problem, This is the solution - Credits to Tuany

    For me I had to edit ipplanlib.php under this directory var/www/ipplanv6/, uncommenting 2 lines (67 and 69)
    if (phpversion()<"5.3") {
    set_magic_quotes_runtime(0);
    }

    Then go to var/www/ipplan/admin/schemacreate.php, on line 46 change:

    $taboptarray = array('mysql' => 'TYPE=INNODB');
    To:
    $taboptarray = array('mysql' => 'ENGINE=INNODB');

     

Log in to post a comment.