OpenNetAdmin

Track. Automate. Configure.

Home About Features Community Develop
Download this project as a tar.gz file

Database is created, but table creation fails

justinrpurdy

18-07-2012 17:26:33

I get to this point in the installation:

  1. Connected to 'localhost' as 'root'.
    Dropped existing instance of 'ona_default'.
    Created new database 'ona_default'.
    Selected existing DB: 'ona_default'.
    There was an error processing tables.
    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 DEFAULT CHARSET=utf8 DEFAULT COLLATE=utf8_general_ci' at line 8
    There was a fatal error. Install may be incomplete. Fix the issue and try again.[/list:u:tw0j5pkv]

    Nothing in the mysqld.log since the service started.

    Here's what I'm seeing in my Apache error_log:

    PHP Notice: Undefined index: APACHE_RUN_USER in /opt/ona/install/install.php on line 48, referer: http://10.10.0.180/ona/
    PHP Notice: Undefined index: APACHE_RUN_USER in /opt/ona/install/install.php on line 48, referer: http://10.10.0.180/ona/
    PHP Notice: Undefined variable: ona_contexts in /opt/ona/install/install.php on line 61, referer: http://10.10.0.180/ona/
    PHP Notice: Undefined variable: db_context in /opt/ona/install/install.php on line 61, referer: http://10.10.0.180/ona/
    PHP Notice: Undefined variable: mainstyle in /opt/ona/install/install.php on line 157, referer: http://10.10.0.180/ona/
    PHP Notice: Undefined variable: upgrade in /opt/ona/install/install.php on line 214, referer: http://10.10.0.180/ona/
    PHP Notice: Undefined index: context_name in /opt/ona/www/include/functions_general.inc.php on line 146, referer: http://10.10.0.180/ona/
    PHP Notice: Undefined index: log_to_db in /opt/ona/www/include/functions_general.inc.php on line 62, referer: http://10.10.0.180/ona/
    PHP Notice: Undefined index: context_name in /opt/ona/www/include/functions_general.inc.php on line 146, referer: http://10.10.0.180/ona/
    PHP Notice: Undefined index: log_to_db in /opt/ona/www/include/functions_general.inc.php on line 62, referer: http://10.10.0.180/ona/
    PHP Notice: Undefined index: context_name in /opt/ona/www/include/functions_general.inc.php on line 146, referer: http://10.10.0.180/ona/
    PHP Notice: Undefined index: log_to_db in /opt/ona/www/include/functions_general.inc.php on line 62, referer: http://10.10.0.180/ona/


    From what I can see in phpMyAdmin, the database has been created, but there are no tables.

    Prerequisite checks are all passed.

    OpenSUSE 12.1, MySQL 5.5.16-log, latest version of ONA (11.02.10) downloaded from the site today.

Matt

27-07-2012 12:13:33

I think the issue are running into is the TYPE vs ENGINE syntax. There is a note on the install page (http://opennetadmin.com/docs/installation) that gives some instructions on how to fix that file and run the install. The new code is fixed for this but I dont yet have a tarball release. You can however get the latest code from the github.com/opennetadmin/ona repository which should work fine for you. I hope to release a new tarball soon.

justinrpurdy

31-07-2012 17:44:00

Beautiful, that fixed it. Don't know how I didn't see that. Thanks!