10/27/02
Your [EMAIL PROTECTED] spit me out in a very nasty manner,
eventhough I DID follow your guidelines to the best of my ability and
this error is about the mysql daemon not starting.
I'm not exactly encouraged by this and I'm wondering how much good it is
going to do me that I spent a lot of time documenting all of this for
you. It is true that what I'm hoping to get is my situation fixed, but
I've gone to a lot of trouble here, and judging by what's on the
internet, I'm not the only one with these types of problems unresolved.
I can't figure out what an unemployed student with a home network is
supposed to do about this - do you have an "unemployed student" tech
support sliding scale fee for a one time installation problem?
The ironic thing about this is that I never had ANY trouble with mysql
on Windows 2000!!!!!
Original email below:
I'm on Red Hat Linux 7.3 with Kernel 2.4.18.3 (BTW, I couldn't get the
mysql bug reporting mechanism to work so this is my recourse).
Background here, specific repeatable steps lower down:
After several headaches trying to install MySQL 3.23 from rpm, from
binaries, using root as installer, using mysql as installer, I gave up
and deleted and am now trying MySQL 4.0.4 where the errors are more
understandable but equally frustrating. I've lost 5 days of my life and
installed and deleted (yes keeping track, and deleting my.cnf too &
associated files & then experimenting with not deleting all the files -
I've done it every way I can imagine - most recently first creating a
user mysql WITH a linux login password -as well as the group - before
installing mysql) and reinstalled.... etc.
With mysql 3.23 I kept getting errors about mysql.sock. Plus lots of
other errors, I wound up creating a lot of files manually, changing
ownership on files & making them more permissive, making links, all to
no avail.
Specifics:
On 4.0.4 After installing, reinstalling, and reinstalling. When I
attempt to start mysqld, I keep (ahhhh, consistency) getting the error
message (from hostname.err)
"Can't find messagefile
"mysql-long-name-4.0.4/share/mysql/english/errmsg.sys"
When I checked, yes the file did indeed exist in that directory:
rw_r__r__ mysql users errmsg.sys
so I moved it because it wasn't reading it anyway
mv errmsg.sys errmsg_old.sys
Got a new error message
/usr/local/mysql/libexec/mysqld doesn't exist or isn't executable.
Well, at least that is understandable. And the mysqld file really
didn't exist at that location. Oh, I tried to start mysql in safe mode
so it would look for the most reasonable path & probably switched paths
because of it. I know more about this than I ever wanted to. I've
spent hours on mysql.com and even more hours on Google looking up error
messages.
I created a symbolic link from one of the places that mysqld resides
ln -s /usr/libexec/mysqld /usr/local/mysql/libexec/mysqld
Trying to start the daemon after doing this gave me:
"Can't find messagefile
"/usr/local/mysql-long-name-4.0.4/share/mysql/english/errmsg.sys
Aborting mysqld ended
I like this better because at least it is an absolute path so I know the
process is pointing to the same place I'm looking.
Now I moved errmsg_old.sys back to errmsg.sys which I hoped would fix
the problem. It didn't. Same error message.
So I re gunzipped and untarred the original .tar.gz file and ran
mysql_install_db for the 110th time.
The bug repeats itself exactly.
I also tried this with making the symbolic link from
/mysql-long-name-4.0.4/bin/mysqld to /mysql-long-name-4.0.4/libexec/mysqld
(instead of from /usr/libexec/mysqld)
with the same results.
Attempting to run mysql-test-run gave me errors:
"Can't find messagefile
"/usr/local/mysql-long-name-4.0.4/share/mysql/english/errmsg.sys
Aborting
Error executing mysqld --bootstrap
Error: could not install master test DBs
I really NEED to install MySQL and have it running properly from my
Linux Red Hat box. Oh yeah, other error messages I got (from 3.2.3
which had a wide variety of error messages including missing my.hosts
file and unable to use mysql.sock) included stuff about ELF and gcc
(which of course RedHat7.3 does not have, the C++ compiler is egcs)
I would appreciate any help you can give me with this. I am fairly new
at Administering Linux so maybe there is something that everyone knows
that is so basic that I'm missing and not finding in any documentation.
If that is the case, since similar errors seem to be sprinkled all
over the internet in lots of usegroups, maybe they SHOULD be documented
- I haven't found any answers out there.
BTW, I am unable to execute mysqladmin so mysqladmin version is out of
the question. I am running the most recent beta, downloaded Friday.
mysql-4.0.4-beta-pc-gnu-i686 I ftped from Virginia last, I think.
If you have more specific questions for me or want me to run perl or
shell scripts on my environment to give you more information I'm willing
to do so.
--
Meryll Larkin
(206) 782-9203
Perl Programmer – Web Developer - Linux Apache Admin
Seattle, WA, USA
---------------------------------------------------------------------
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
