MySQL on FreeBSD

CiscoKid · Post by **CiscoKid** » Tue Mar 11, 2003 7:02 pm

Been trying to get MySQl running for a couple days now, msot problems are fixed, The only problem's that left is that when I try to start the server, I get this error...

ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)

Does anyone know how I can fix this and get MySQl up and running?

cyberskye · Post by **cyberskye** » Tue Mar 11, 2003 7:49 pm

Post the command you use to start it.

BTW - did you build from source or is this a binary install?

CiscoKid · Post by **CiscoKid** » Tue Mar 11, 2003 8:01 pm

Originally posted by cyberskye
Post the command you use to start it.

BTW - did you build from source or is this a binary install?

It's a binary install, I've tried "./safe_mysqld" and "./mysqld"

both give me the same error

CiscoKid · Post by **CiscoKid** » Tue Mar 25, 2003 10:18 pm

UGH...still can't get it working, when I try to run it, it says:

Sorry, the host 'equalizer' could not be looked up.
Please configure the 'hostname' command to return a correct hostname.
If you want to solve this at a later stage, restart this script with
the --force option

cyberskye · Post by **cyberskye** » Tue Mar 25, 2003 11:00 pm

Is mysqld running? Check with ps -eaf | grep mysqld now and again after you run the ./safe...startup.

Edit - I just re-read your latest error. What do you get when you type the hostname command?

CiscoKid · Post by **CiscoKid** » Tue Mar 25, 2003 11:07 pm

is there any reason why this name wouldn't work?

testbocks# hostname
testbocks

Stef · Post by **Stef** » Wed Mar 26, 2003 12:42 am

In UNIX there's these things that they call man pages, once you read them you gain this thing called knowledge

Stef

cyberskye · Post by **cyberskye** » Wed Mar 26, 2003 12:45 am

Hmm. Does the name equalizer mean anything to you?

The error you received (ERROR 2002) is often caused by the hostname not resolving/existing or mysqld (did you verify that it is running?) not running (often for the aforementioned reason).

With MYSQL it's often easier to reinstall. I would remove the mysql user and group (assuming you followed the INSTALL doc), remove the slink to mysql, yadayada - follow the install in reverse to clean up.

I have to admit, there's a part of me that always wants to figure out why it doesn't work. When the install for MySQL goes bad it goes bad. You save a lot of time (and hair) starting over.

Skye

EDIT: Read through the INSTALL doc completely. Understand why you are taking each step (the detailed section gets deep enough).

Second EDIT: What version and which build are you running? I assumed 3.23

CiscoKid · Post by **CiscoKid** » Wed Mar 26, 2003 12:58 am

Stef, I've tried the documentation.

cyberskye, trying to run 4.0.12.

cyberskye · Post by **cyberskye** » Wed Mar 26, 2003 1:03 am

K. That's a devleopment build still. If you are building a next-generation app, that's cool. Otherwise, I'd go stable. Same way I'd suggest apache 1.3.27 over 2.x. Let them mature a bit.

Not that the version is the problem. It should still work. One more time, tho -

1. is mysqld running?
2. was a host named equalizer ever involved?

CiscoKid · Post by **CiscoKid** » Wed Mar 26, 2003 2:06 am

Originally posted by cyberskye
K. That's a devleopment build still. If you are building a next-generation app, that's cool. Otherwise, I'd go stable. Same way I'd suggest apache 1.3.27 over 2.x. Let them mature a bit.

Not that the version is the problem. It should still work. One more time, tho -

1. is mysqld running?
2. was a host named equalizer ever involved?

equalizer was the original host name, it's since been changed.

I've never been able to get mysqld running.

SavageHrt · Post by **SavageHrt** » Wed Mar 26, 2003 7:35 am

Is <IP Address> testbocks.<domain name> testbocks added to your /etc/hosts file? From what I can see and understand in the posts your hostname doesn't resolve. Look at the hosts file, read 'man hosts' to learn how to add the info you need to it.

Sav

cyberskye · Post by **cyberskye** » Wed Mar 26, 2003 9:11 am

...or you could replace equalizer with testbocks in the /etc/hosts file. mysqld is trying to run on a host named "equalizer".

How did you change the hostname to testbocks? What specific steps?

CiscoKid · Post by **CiscoKid** » Wed Mar 26, 2003 10:30 am

Originally posted by cyberskye
...or you could replace equalizer with testbocks in the /etc/hosts file. mysqld is trying to run on a host named "equalizer".

How did you change the hostname to testbocks? What specific steps?

Host name was changed after the drive failed....

cyberskye · Post by **cyberskye** » Wed Mar 26, 2003 12:30 pm

I've never been able to get mysqld running.

Did you check by looking for the mysqld process via ps? My point was that it may have been running, just not servicing requests or in an otherwise unstable state. This simple step would rule that out.

Host name was changed after the drive failed....

Sorry, the host 'equalizer' could not be looked up.

I asked what steps you took to change the hostname. There are a couple of ways that you can change the hostname - some more effective than others. The hostname command calls GetHostName() or setHostName() system calls, you can also modify system files like /etc/hosts, or through a reinstall/sysinstall...

I don't mean to be short, but getting the info from you required to help is fairly difficult. Your answers are vague when they need to be kinda specific. mysql is referencing the old hostname, but you say you changed it - again, HOW?!

I would again suggest you start over. It would take more time tracking down the system-wide configuration errors on your box that could affect this than to roll-back and start over.

Here's a good arctile on issues with the FreeBSD>MySQL combo. http://jeremy.zawodny.com/blog/archives/000203.html It explains how to over-ride the hostname look up that mysql performs. You can manually run the ./mysqld command with the options described in this link. I would be worried about future issues.

CiscoKid · Post by **CiscoKid** » Wed Mar 26, 2003 1:55 pm

Originally posted by cyberskye
I asked what steps you took to change the hostname. There are a couple of ways that you can change the hostname - some more effective than others. The hostname command calls GetHostName() or setHostName() system calls, you can also modify system files like /etc/hosts, or through a reinstall/sysinstall...

I don't mean to be short, but getting the info from you required to help is fairly difficult. Your answers are vague when they need to be kinda specific. mysql is referencing the old hostname, but you say you changed it - again, HOW?!

I would again suggest you start over. It would take more time tracking down the system-wide configuration errors on your box that could affect this than to roll-back and start over.

I had to reinstall on a new drive because the first drive failed.

cyberskye · Post by **cyberskye** » Wed Mar 26, 2003 2:45 pm

That is odd. Did you format or just reinstall overtop? Seems that something iis left over or maybe you backed-up data then changed the hostname when restoring...

in your hostfile the line that contains
127.0.0.1 localhost xxx xxx xxx

What are the other names (the xxx's) in order?

Do you have any other entries for a specific ip address - don't need the ip addresses themselves, just verify that the aliases are valid.

In that link I posted above the guys tells you how to force mysql to use whatever name you wish. safe_mysql is a wraper that tries to understand the best variables to use - it clearly isn't working in your case. You might want to give it a try.

cyberskye · Post by **cyberskye** » Wed Mar 26, 2003 7:10 pm

A quote from that link
"
Based on our testing, the only truly safe way to operate is to use the --skip-name-resolve flag for starting mysqld AND specifying the IP address of the master instead of the hostname. That virtually eliminates the need for MySQL to call gethostbyname().
"

Skye

CiscoKid · Post by **CiscoKid** » Wed Mar 26, 2003 9:09 pm

guys...you can all beat me now...I had a security setting wrong on the mysql directory...

cyberskye · Post by **cyberskye** » Thu Mar 27, 2003 10:34 am

30 lashes!

CiscoKid · Post by **CiscoKid** » Thu Mar 27, 2003 5:18 pm

I had been playing with ownership settings for the directory the binary distribution was originaly extracted to.