>Description:
We had an NFS incident and used CHMOD and CHOWN to repair it.
Shortly there after, we noticed that our MySql under WebRT did not work.
We presume that we corrupted the ownership and permissions of files and
programs within MySQL.
>How-To-Repeat:
use command CHOWN and CHMOD in a global way
>Fix:
We expected to find a script that would repair this sort of thing.
Alternatively, we expected "make fix_perms" or similar. Either would read
the current environment and ferret out all of the files and folders,
settings ownership and permissions appropriately. They could also report
what they found in a way that instructs the operator about how things
ought to be configured.
We expected to find something about this in the 500+ page PDF
manual but we did not.
>Submitter-Id: Foresight-Austin
>Originator: Dan St.Andre'
>Organization:
Foresight Systems, Inc.
8217 Shoal Creek Blvd. Suite 100
Austin TX 78757
>MySQL support: none
>Synopsis: CHMOD & CHOWN break MySQL
>Severity: critical
>Priority: high
>Category: mysql
>Class: support
>Release: mysql-3.22.32 (Official MySQL RPM)
>Server: /usr/bin/mysqladmin Ver 8.0 Distrib 3.22.32, for pc-linux-gnu on i686
TCX Datakonsult AB, by Monty
Server version 3.22.32
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 20 hours 34 min 8 sec
Threads: 1 Questions: 77 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 2
>Environment:
PII-266, RH linux 6.1, x86
System: Linux gator.fsaustin.lan 2.2.12-20 #1 Mon Sep 27 10:25:54 EDT 1999 i686 unknown
Architecture: i686
Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='egcs' CFLAGS='-O6 -fomit-frame-pointer -mpentium' CXX='egcs'
CXXFLAGS='-O6 -fomit-frame-pointer -felide-constructors
-fno-exceptions -fno-rtti -mpentium' LDFLAGS=''
Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --enable-assembler --with-mysqld-user=mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --exec-prefix=/usr
--libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share
--localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include
--mandir=/usr/man '--with-comment=Official MySQL RPM'
[end]
---------------------------------------------------------------------
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
