-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
thanks for reporting this. I assume, you used the MySQL package from
mysql.com?
On Thu, 6 Mar 2003, Perry Arnold wrote:
I installed the MySQL binary (4.0.11-gamma package) on my Mac OS X
machine (version 10.2.4) and I couldn't get it to start up. When I run
bin/mysqld_safe, I kept getting the error Fatal error: Can't open
privilege tables: Table 'mysql.host' doesn't exist [note: I later
figured out that I *think* I'm getting this error because my machine
does not have a recognizable hostname (i.e. you can't look it up via
normal DNS)].
Hmm, this case is currently not properly handled, indeed. Thanks for the
hint! mysql_install_db simply aborts, if the host name cannot be resolved,
but the error does not get fed back to the installer itself...
After mucking around for quite a while without much success, I decided
to start over and reinstall from scratch. So, I deleted my mysql
directory and reinstalled from the Package. Now, when I try to run
bin/mysqld_safe, I get the following error: InnoDB: Operating system
error number 13 in a file operation. It looks like when you reinstall
from the package, it skips the step where it changes file permissions of
the data directory and its subdirectories.
How-To-Repeat:
On a fresh MacOS X 10.2.4 system, (1) install the 4.0.11-gamma package,
(2) delete the mysql directories (the /usr/local/mysql link and
/usr/local/mysql-standard-4.0.11-gamma-apple-darwin6.4-powerpc
directory), (3) install the 4.0.11 package again, (4) run
bin/mysqld_safe.
Fix:
Change the file permissions of the data directory and its
subdirectories. Ideally, this would be fixed within the Package
installer, but a release note or something would work as well.
This is interesting. Are you sure you removed all mysql directories in
/usr/local? The installation package includes a postinstall script, that
does the following:
[SNIP]
if cd /usr/local/mysql ; then
if [ ! -f data/mysql/db.frm ] ; then
./scripts/mysql_install_db
fi
if [ -d data ] ; then
chown -R mysql data
fi
else
exit $?
fi
[SNIP]
/usr/local/mysql is a symlink, pointing to the real installation directory
and is included in the package itself. So if you really removed all files,
the ownerships should have been set up correctly. Unfortunately it's very
hard to debug this problem, since the Package Installer does not offer any
logging functionality...
After looking through your mail again, I wonder how you tried to start
MySQL. Did you use sudo mysqld_safe, as described in the docs? If you
try it as a normal user (omitting sudo, the directory permissions and
ownerships indeed will give you a permission denied error message. This
is intentional!
Bye,
LenZ
- --
For technical support contracts, visit https://order.mysql.com/?ref=mlgr
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer
/_/ /_/\_, /___/\___\_\___/ Hamburg, Germany
___/ www.mysql.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux)
Comment: For info see http://quantumlab.net/pine_privacy_guard/
iD8DBQE+eJjQSVDhKrJykfIRAu9eAJ9AWiSgVNOB9e3LMMxzllQ2VTNESQCfa/mg
/FXb3eaPfsHvOtK0zfPXqsg=
=glQe
-END PGP SIGNATURE-
-
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
