-----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
