Never enabled LOCAL_INFILE

[kawada]

Description:

2.23.49 can not set local_infile to enable.
We can not use LOAD DATA LOCAL INFILE ... ;

configure script is almost strange '$enablewal'
not '$enableval'.

How-To-Repeat:

Fix:


Submitter-Id:  submitter ID
Originator:Yukihiro KAWADA
Organization:
   FUJI PHOTO FILM Co.,Ltd. Electronic Imaging Products Div.

MySQL support: [none | licence | email support | extended email support ]
Synopsis:

Severity:

Priority:

Category:  mysql
Class: 
Release:   mysql-3.23.49 (Source distribution)
Server: mysqladmin  Ver 8.23 Distrib 3.23.49, for sun-solaris2.7 on sparc
Copyright (C) 2000 MySQL AB  MySQL Finland AB  TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version  3.23.49
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 4 days 16 min 4 sec

Threads: 1  Questions: 3691  Slow queries: 0  Opens: 13  Flush tables: 1  Open tables: 
7 Queries per second avg: 0.011
Environment:

System: SunOS funnel 5.7 Generic_106541-07 sun4u sparc SUNW,Ultra-1
Architecture: sun4

Some paths:  /usr/gnu/bin/perl /usr/gnu/bin/make /usr/gnu/bin/gmake /usr/gnu/bin/gcc 
/usr/ucb/cc
GCC: Reading specs from /usr/gnu/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2/specs
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc'  CFLAGS=''  CXX='gcc'  CXXFLAGS=''  LDFLAGS=''
LIBC: 
-rw-r--r--   1 bin  bin   1693556 Oct 22  1999 /lib/libc.a
lrwxrwxrwx   1 root root   11 Oct 25  1999 /lib/libc.so - ./libc.so.1
-rwxr-xr-x   1 bin  bin   1115304 Oct 22  1999 /lib/libc.so.1
-rw-r--r--   1 bin  bin   1693556 Oct 22  1999 /usr/lib/libc.a
lrwxrwxrwx   1 root root   11 Oct 25  1999 /usr/lib/libc.so - ./libc.so.1
-rwxr-xr-x   1 bin  bin   1115304 Oct 22  1999 /usr/lib/libc.so.1
Configure command: ./configure  --with-unix-socket-path=/var/tmp/mysql.sock 
--with-low-memory --with-mit-threads=yes --without-perl --enable-thread-safe-client 
--with-berkeley-db --enable-local-infile --with-innodb
Perl: This is perl, version 5.005_03 built for sun4-solaris

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Never enabled LOCAL_INFILE

[Sinisa Milivojevic]

[EMAIL PROTECTED] writes:
 Description:
 
 2.23.49 can not set local_infile to enable.
 We can not use LOAD DATA LOCAL INFILE ... ;
 
 configure script is almost strange '$enablewal'
 not '$enableval'.
 
 How-To-Repeat:
   

Hi!

Thank you for your report. We have fixed a bug and fix will come in
3.23.50. 

The problem is that in configure.in we forgot to add:

AC_SUBST(ENABLE_LOCAL_INFILE)

We have now fixed this in the MySQL 3.23 source tree..

The fix is to add

[client]
local-infile=1

to /etc/my.cnf.

If it is not secret, what are you using MySQL for at Fuji Film ??

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   ___/   www.mysql.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php