Error locating host.frm

2001-06-13 Thread Furmaniuk, Michael


  I've installed the Solaris 2.7 binary and am trying to connect to the
database after doing the setup, when I attempt to start the database I get a
message that mysql ended and there is no process started.  I use the
following (all things should be run with sudo on our server) -

 sudo ./bin/safe_mysqld --user=mysql 
[1] 23388
 Starting mysqld daemon with databases from /usr/local/mysql/data
010613 10:26:06  mysqld ended
[1]Done  sudo ./bin/safe_mysqld --user=mysql

  Nothing is started and I find in the error log:

010613 10:26:06  mysqld started
010613 10:26:06  /usr/local/mysql/bin/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
010613 10:26:06  /usr/local/mysql/bin/mysqld: Normal shutdown

010613 10:26:06  /usr/local/mysql/bin/mysqld: Shutdown Complete

010613 10:26:06  mysqld ended

  I can see that host.frm exists, but I am not sure what is calling it, and
from where since its listing the path name as relevant to mysql/bin but I
can see it in:

 sudo find / -name host.frm
/usr/local/mysql/data/mysql/host.frm

  My info from mysqlbug is as follows:

Release:   mysql-3.23.38 (Official MySQL binary)

Environment:
machine, os, target, libraries (multiple lines)
System: SunOS relpbld03 5.7 Generic_106541-10 sun4u sparc
SUNW,UltraSPARC-IIi-cEngine
Architecture: sun4

Some paths:  /bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/ucb/cc
GCC: Reading specs from
/usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2/specs
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc'  CFLAGS='-O3 -fno-omit-frame-pointer'  CXX='gcc'
CXXFLAGS='-O3 -fno-omit-frame-pointer -felid
e-constructors -fno-exceptions -fno-rtti'  LDFLAGS=''
LIBC:
-rw-r--r--   1 bin  bin  1696732 May 10  2000 /lib/libc.a
lrwxrwxrwx   1 root root  11 Jun 14  2000 /lib/libc.so -
./libc.so.1
-rwxr-xr-x   1 bin  bin  1115336 May 10  2000 /lib/libc.so.1
-rw-r--r--   1 bin  bin  1696732 May 10  2000 /usr/lib/libc.a
lrwxrwxrwx   1 root root  11 Jun 14  2000 /usr/lib/libc.so -
./libc.so.1
-rwxr-xr-x   1 bin  bin  1115336 May 10  2000 /usr/lib/libc.so.1
Configure command: ./configure  --prefix=/usr/local/mysql
'--with-comment=Official MySQL binary' --with-extra-charsets=co
mplex --with-server-suffix= --enable-assembler --disable-shared
Perl: This is perl, version 5.005_03 built for sun4-solaris

  Am I missing something else or should I try to compile this from source?

  Thanks,

  Michael

-
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: Error locating host.frm

2001-06-13 Thread Gerald Clark

Make sure that mysql owns its files and directories.

Furmaniuk, Michael wrote:

   I've installed the Solaris 2.7 binary and am trying to connect to the
 database after doing the setup, when I attempt to start the database I get a
 message that mysql ended and there is no process started.  I use the
 following (all things should be run with sudo on our server) -
 
 
 sudo ./bin/safe_mysqld --user=mysql 
 
 [1] 23388
 
 Starting mysqld daemon with databases from /usr/local/mysql/data
 
 010613 10:26:06  mysqld ended
 [1]Done  sudo ./bin/safe_mysqld --user=mysql
 
   Nothing is started and I find in the error log:
 
 010613 10:26:06  mysqld started
 010613 10:26:06  /usr/local/mysql/bin/mysqld: Can't find file:
 './mysql/host.frm' (errno: 13)
 010613 10:26:06  /usr/local/mysql/bin/mysqld: Normal shutdown
 
 010613 10:26:06  /usr/local/mysql/bin/mysqld: Shutdown Complete
 
 010613 10:26:06  mysqld ended
 
   I can see that host.frm exists, but I am not sure what is calling it, and
 from where since its listing the path name as relevant to mysql/bin but I
 can see it in:
 
 
 sudo find / -name host.frm
 
 /usr/local/mysql/data/mysql/host.frm
 
   My info from mysqlbug is as follows:
 
 
 Release:   mysql-3.23.38 (Official MySQL binary)
 
 
 Environment:
 
 machine, os, target, libraries (multiple lines)
 System: SunOS relpbld03 5.7 Generic_106541-10 sun4u sparc
 SUNW,UltraSPARC-IIi-cEngine
 Architecture: sun4
 
 Some paths:  /bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/ucb/cc
 GCC: Reading specs from
 /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2/specs
 gcc version 2.95.2 19991024 (release)
 Compilation info: CC='gcc'  CFLAGS='-O3 -fno-omit-frame-pointer'  CXX='gcc'
 CXXFLAGS='-O3 -fno-omit-frame-pointer -felid
 e-constructors -fno-exceptions -fno-rtti'  LDFLAGS=''
 LIBC:
 -rw-r--r--   1 bin  bin  1696732 May 10  2000 /lib/libc.a
 lrwxrwxrwx   1 root root  11 Jun 14  2000 /lib/libc.so -
 ../libc.so.1
 -rwxr-xr-x   1 bin  bin  1115336 May 10  2000 /lib/libc.so.1
 -rw-r--r--   1 bin  bin  1696732 May 10  2000 /usr/lib/libc.a
 lrwxrwxrwx   1 root root  11 Jun 14  2000 /usr/lib/libc.so -
 ../libc.so.1
 -rwxr-xr-x   1 bin  bin  1115336 May 10  2000 /usr/lib/libc.so.1
 Configure command: ./configure  --prefix=/usr/local/mysql
 '--with-comment=Official MySQL binary' --with-extra-charsets=co
 mplex --with-server-suffix= --enable-assembler --disable-shared
 Perl: This is perl, version 5.005_03 built for sun4-solaris
 
   Am I missing something else or should I try to compile this from source?
 
   Thanks,
 
   Michael
 
 -
 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


-- 
Gerald L. Clark
[EMAIL PROTECTED]


-
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