Howdy.
Some of the following is part rant. I know this email is too long, but
I want to be sure to give enough info so you folks have to ask me
for more info. All of it will probably be forwarded to the bugs list,
depending on what solutions I find.
I'm running SuSE 7.0 and I had mysql 3.22 installed from SuSE's
site via rpm, and everything worked just fine. One of our
programmers insisted that I upgrade to 3.23 to take advantage of
that version's new features, which I tried to do last weekend. Below
is a description of what happened.
I removed everything mysql-related from my system via YaST, then
attempted to download and rpm the newer version from mysql.com.
I decided to install mysql-max. From the page on max, I assumed
that simply installing max would give me a mysql server, with the
transactions capability. I was wrong. I had to also grab the regular
3.23 server. Apparently, max layers on top of a regular server
install. This was not clear in the documentation on max.
Ok, so I get everything installed (except for the benchmarks, which
kind of failed). Mysql seems to be running, and I was able to
access the program via the command line, but all I got was errors
when I tried to use php. Here is a snippet from irc:
<mmlj4> ok, I did:
<mmlj4> <?php
<mmlj4> mysql_connect(":/var/lib/mysql/mysql.sock", $user,
$pass);
<mmlj4> ?>
<mmlj4> and I got:
<mmlj4> Warning: MySQL Connection Failed: Can't connect to
local MySQL server through socket '/tmp/mysql.sock' (111) in
/home/jkelly/public_html/socket.php on line 2
Someone told me to execute the following at my shell promt:
mysqladmin variables -u root -p | grep socket
and this came back:
| socket | /var/lib/mysql/mysql.sock
Ok, so we figured that a symlink would make things work, and it
did... until the daemon died:
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
Ok, so yesterday I have no mysql daemon running. I reboot, and it
won't come up. I tried to start it manually, and no go. As a non-root
user (the daemon told me to read the docs before trying to run it as
root), I get an error telling me that I already have an instance
running on /var/lib/mysql/mysql.sock --- the symlink, I figure. The
command "ps aux | grep sql" yields only postgresql, no mysql.
I haven't yet tried removing the symlink to see if it will start, but I'll
probably do that later tonight.
Ok, I'm sure I made a stupid blunder somewhere, but can anyone
tell me what to do?
Thanks :)
+++
Joey Kelly
/Minister of the Gospel | Computer Networking Consultant/
http://nolalinuxcoop.dhs.org/~jkelly/home/
"Experience hath shewn, that even under the best forms [of government] those entrusted
with power have, in time, and by slow op
erations, perverted it into tyranny." - Thomas Jefferson
---------------------------------------------------------------------
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
