mysql startup failure on new server

[dreamgear]

what does this suggest?

090807 21:30:08 mysqld started
090807 21:30:08 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
090807 21:30:08 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
090807 21:30:08 [ERROR] Can't start server: cannot resolve hostname!: Success
090807 21:30:08 mysqld ended

fwiw

[root@goose zimbra]# grep -i domain /opt/zimbra/config.*
AVDOMAIN=goose.intranet.seamanpaper.com
CREATEDOMAIN=goose.intranet.seamanpaper.com
DOCREATEDOMAIN=yes

[zimbra@goose ~]$ hostname
goose.intranet.seamanpaper.com
[zimbra@goose ~]$ dig +short `hostname` a
192.168.10.112
[zimbra@goose ~]$ dig +short `hostname` mx
10 goose.intranet.seamanpaper.com.
[zimbra@goose ~]$ dig +short intranet.seamanpaper.com mx
10 buster.intranet.seamanpaper.com.

[dreamgear]

fwiw

[zimbra@goose ~]$ hostname
goose.intranet.seamanpaper.com
[zimbra@goose ~]$ dig +short `hostname` a
192.168.10.112
[zimbra@goose ~]$ dig +short `hostname` mx
10 goose.intranet.seamanpaper.com.
[zimbra@goose ~]$ dig +short intranet.seamanpaper.com mx
10 buster.intranet.seamanpaper.com.
[zimbra@goose ~]$

[root@goose zimbra]# grep -i domain /opt/zimbra/config.*
AVDOMAIN=goose.intranet.seamanpaper.com
CREATEDOMAIN=goose.intranet.seamanpaper.com
DOCREATEDOMAIN=yes

[dreamgear]

This forum is confusing me. I added a reply but it does't appear.. and then when I try to post it again it tells me it's a duplicate. But the original is still not there several minutes later.

[phoenix]

Originally Posted by dreamgear

This forum is confusing me. I added a reply but it does't appear.. and then when I try to post it again it tells me it's a duplicate. But the original is still not there several minutes later.

It's an anti-spam measure, as you're a new member your post was moderated and needed approving.

[uxbod]

cat /etc/hosts

[dreamgear]

::1 localhost.localdomain localhost

[dreamgear]

BTW zmmtaconfig was looping solidly compute-bound even after I ran the shutdown script, after the installation script fell all over it self and looped for six hours berore I killed it. And what? This was because the *mysql* startup failed because the hostname was wrong ? Huh?

[phoenix]

Originally Posted by dreamgear

::1 localhost.localdomain localhost

You need a valid, and correct, hosts file. I'd suggest you check the Quick Start Installation Guide for the correct format, you'll also need valid DNS A & MX records and you can find details in the Split DNS article or the forums if you search.

[dreamgear]

So in other words it doesn't use the standard APIs to determine hostname. FWIW hostname is set in /etc/sysconfig/network on red hat.

And this has what to do with MySQL?

Assuming this was in fact a stupid error on my part, you should still take note of the fact that the installation script just collapsed and did many wrong things after failing to check that the required configuration was in place.

Thanks for the docs pointer, I hadn't found that before.

[dreamgear]

Ok, I followed all the directions in the installation document, and it's doing exactly the same thing:

Note the date/time:

090810 14:17:43 mysqld started
090810 14:17:43 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
090810 14:17:43 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
090810 14:17:43 [ERROR] Can't start server: cannot resolve hostname!: Success
090810 14:17:43 mysqld ended

Here's some more info:

[root@goose log]# hostname
goose.intranet.seamanpaper.com
[root@goose log]# ifconfig | grep inet
inet addr:192.168.10.112 Bcast:192.168.10.255 Mask:255.255.255.0
inet6 addr: fe80::20c:29ff:fe66:3f93/64 Scope:Link
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
[root@goose log]# dig +short `hostname` a
192.168.10.112
[root@goose log]# dig +short `hostname` mx
10 goose.intranet.seamanpaper.com.
[root@goose log]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
::1 localhost.localdomain localhost
192.168.10.112 goose.intranet.seamanpaper.com goose
[root@goose log]#

What did I miss?