List:General Discussion« Previous MessageNext Message »
From:william2 Date:May 13 1999 10:56pm
Subject:Mysql 3.22.22 on HP-UX 10.20 Compiles okay but SQL fails
View as plain text  
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: william
To: mysql@stripped
Subject: Mysql 3.22.22 on HP-UX 10.20 Compiles okay but SQL fails

>Description:
        I have successfully compiled and installed mysql-3.22.21 and
        mysql-3.22.22 on my HP-UX 10.20 system, however when I run
        mysql_install_db it fails to create the mysql database with
        "ERROR: 1064  You have an error in your SQL syntax near ';'
        at line 1 Installation of grant tables failed!".  I then started
        "mysqld --skip-grant --log" and tried to create the database manually
        and received the same SQL error.  In fact, just trying
        "create database mysql;" at the mysql prompt returns this error.
        The only commands I can get to work are "show tables;" and
        "show databases;".  This same distribution works fine under Solaris.
	I believe that I have done a decent job of checking the Docs and 
	archives and I have found nothing closely relevant.

	Here is a snapshot of my manual attempt to create the database:
mysql> create database mysql;
ERROR 1064: You have an error in your SQL syntax near '' at line 1
mysql> explain create database mysql;
ERROR 1064: You have an error in your SQL syntax near 'create database mysql' at line 1
mysql> quit
Bye

	Here is the log information from my manual attempt:
/opt/mysql/libexec/mysqld, Version: 3.22.22-log, started with:
Tcp port: 3306  Unix socket: /tmp/mysql.sock
Time                 Id Command    Argument
990513 15:39:35       1 Connect    root@localhost on 
                      1 Query      show databases
                      1 Query      show tables
990513 15:39:42       1 Query      create database mysql
990513 15:39:49       1 Query      explain create database mysql
990513 15:41:29       1 Quit

Any help is greatly appreciated!

>How-To-Repeat:
        Followed the documentation for compile, install, and post-install exactly.

>Fix:
       

>Submitter-Id:  <submitter ID>
>Originator:    Murray Williams
>Organization:  Open Systems Support
>MySQL support: none
>Synopsis:      MySQL compiles okay, SQL does not work
>Severity:      serious
>Priority:      medium
>Category:      mysql
>Class:         support
>Release:       mysql-3.22.22 (Source distribution)

>Environment:
        <machine, os, target, libraries (multiple lines)>
System: HP-UX oses B.10.20 A 9000/826 1118320342 two-user license
        Hardware:       HP9000/826/E45 (128M RAM 256M Swap)
        O/S:            HP-UX B.10.20
        Compiler:       gcc version egcs-2.91.66 19990314 (egcs-1.1.2 release)
        Utils:          GNU assembler version 2.9.1
                        GNU Make version 3.77
                        HP ld 92453-07 linker linker ld B.10.30 980630
        Config args:    ./configure --prefix=/opt/mysql --with-mysqld-user=mysql
                        --with-low-memory
        Env Vars:       CC=/opt/egcs/bin/gcc
                        CXX=/opt/egcs/bin/c++
                        LD=/opt/gcc/bin/ld (Just runs /usr/bin/ld on this
                                            platform)
                        AR=/opt/egcs/bin/ar
                        AS=/opt/egcs/bin/as
                        NM=/opt/egcs/bin/nm
                        export CC CXX LD AR AS NM
        I have also tried compiling with none of the above env vars specified
	with the same result.

Some paths:  /usr/bin/perl /usr/bin/make /opt/egcs/bin/gcc /usr/bin/cc
GCC: Reading specs from /opt/egcs/lib/gcc-lib/hppa1.1-hp-hpux10.20/egcs-2.91.66/
specs
gcc version egcs-2.91.66 19990314 (egcs-1.1.2 release)
Compilation info: CC='/opt/egcs/bin/gcc'  CFLAGS=''  CXX='/opt/egcs/bin/c++'  CX
XFLAGS=''  LDFLAGS=''
Configure command: ./configure  --prefix=/opt/mysql --with-mysqld-user=mysql --w
ith-low-memory
Perl: This is perl, version 5.005_02 built for PA-RISC1.1
Thread
Mysql 3.22.22 on HP-UX 10.20 Compiles okay but SQL failswilliam214 May