The reason is that if 'basedir' is read from 'my.cfg' then 'bindir'
is not set to $basedir/bin but to /compile-time-dir/bin
>How-To-Repeat:
1) Install mysql in a directory other than the one for which it was compiled.
2) Configure /etc/my.cnf to work with this new directory
[mysqld]
basedir=new-base
datadir=new-data-dir
pid-file=new-data-dir/mysql4.pid
[mysqld_safe]
ledir=new-base/libexec
3) run 'mysql.server' and you get this message
Can't execute /compile-time-dir/bin/mysqld_safe from dir new-base
>Fix:
In the file : mysql.server
after the line: parse_arguments `$print_defaults mysqld mysql_server
mysql.server`
add this line : bindir=$basedir/bin
>Submitter-Id: <submitter ID>
>Originator: Jean Fontayne
>Organization: UUNET
>MySQL support: none
>Synopsis: cannot start mysql if installed outside the 'compile time' directory
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-4.0.12 (Source distribution)
>Server: /prod/mysql/bin/mysqladmin Ver 8.40 Distrib 4.0.12, for sun-solaris2.8 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 4.0.12
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 10 min 25 sec
Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0
Queries per second avg: 0.002
>C compiler: 2.95.3
>C++ compiler: 2.95.3
>Environment:
System: SunOS ipmsdsrc1.ams.ops.eu.uu.net 5.8 Generic_108528-15 sun4u sparc
SUNW,UltraAX-i2
Architecture: sun4
Some paths: /usr/bin/perl /usr/ccs/bin/make /usr/local/bin/gmake /usr/local/bin/gcc
/usr/vendor/bin/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.2/specs
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc' CFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs
-Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings
-Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' CXX='gcc'
CXXFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts
-Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual
-Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors
-fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' LDFLAGS=''
ASFLAGS=''
LIBC:
-rw-r--r-- 1 root 2 1764552 Jun 3 2002 /lib/libc.a
lrwxrwxrwx 1 root root 11 Aug 21 2002 /lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root 2 1146204 Jun 3 2002 /lib/libc.so.1
-rw-r--r-- 1 root 2 1764552 Jun 3 2002 /usr/lib/libc.a
lrwxrwxrwx 1 root root 11 Aug 21 2002 /usr/lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root 2 1146204 Jun 3 2002 /usr/lib/libc.so.1
Configure command: ./configure '--prefix=/usr/local/mysql' '--enable-assembler'
'--with-extra-charsets=complex' '--enable-thread-safe-client' '--with-innodb'
'--with-berkeley-db' '--with-embedded-server' '--with-openssl' '--with-vio'
'--enable-local-infile' 'CFLAGS=-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs
-Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings
-Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' 'CXXFLAGS=-Wimplicit
-Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat
-Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wsign-promo
-Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions
-fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' 'CXX=gcc'
Perl: This is perl, version 5.005_03 built for sun4-solaris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
