What mysql 5.0 binary relase use for CentOS 4.4 Pentium?

Hi.



What binary relase use for CentOS 4.4:



* Linux (x86, glibc-2.2, "standard" is static, gcc):
mysql-standard-5.0.24a-linux-i686.tar.gz
* Linux (x86): mysql-standard-5.0.24a-linux-i686-glibc23.tar.gz



In http://dev.mysql.com/doc/refman/5.0/...tes-linux.html says that
it is possible that mysql couldn't resolves ips for hostnames.



First I install mysql-standard-5.0.24a-linux-i686-glibc23.tar.gz and
executing mysql_install_db it says:



Sorry, the host 'xxxx' could not be looked up



Then I install mysql-standard-5.0.24a-linux-i686.tar.gz and says the same
when I execute mysql_install_db.



Sorry, the host 'xxxx' could not be looked up



Aside from not could use hostnames what from these releases is best for me?



Iago.

informatica@esanluis.com wrote:
> Hi.
>
>
>
> What binary relase use for CentOS 4.4:
>
>
>
> * Linux (x86, glibc-2.2, "standard" is static, gcc):
> mysql-standard-5.0.24a-linux-i686.tar.gz
> * Linux (x86): mysql-standard-5.0.24a-linux-i686-glibc23.tar.gz
>
>
>
> In http://dev.mysql.com/doc/refman/5.0/...tes-linux.html says that
> it is possible that mysql couldn't resolves ips for hostnames.
>
>
>
> First I install mysql-standard-5.0.24a-linux-i686-glibc23.tar.gz and
> executing mysql_install_db it says:
>
>
>
> Sorry, the host 'xxxx' could not be looked up

If you read that page:

You can deal with this by executing mysql_install_db --force, which does
not execute the resolveip test in mysql_install_db. The downside is that
you cannot use hostnames in the grant tables: except for localhost, you
must use IP numbers instead. If you are using an old version of MySQL
that does not support --force, you must manually remove the resolveip
test in mysql_install using a text editor.

Basically your DNS is stuffed and mysql can't look up hostnames.


Why aren't you using the rpms? They are much easier to deal with when it
comes time to upgrade.

Hi,

If you get

" Sorry, the host 'xxxx' could not be looked up " error message when you run mysql_install_db, or if you get the
" getpwnam: No such file or directory " error message while running mysqld with --user option,

Then try any of these solutions:

a.. Get a MySQL source distribution either an RPM or the tar.gz distribution and install this instead.
b.. Execute mysql_install_db --force; This will not execute the resolveip test in mysql_install_db. The downside is that you can't use host names in the grant tables; you must use IP numbers instead of host names except for localhost. If you are using an old MySQL release that doesn't support --force, you have to remove the resolveip test in mysql_install with an editor.
c.. Start mysqld with su instead of using --user.


Thanks
ViSolve DB Team.

----- Original Message -----
From: <informatica@esanluis.com>
To: "MySql Mail List" <mysql@lists.mysql.com>
Sent: Thursday, September 21, 2006 9:27 PM
Subject: What mysql 5.0 binary relase use for CentOS 4.4 Pentium?


> Hi.
>
>
>
> What binary relase use for CentOS 4.4:
>
>
>
> * Linux (x86, glibc-2.2, "standard" is static, gcc):
> mysql-standard-5.0.24a-linux-i686.tar.gz
> * Linux (x86): mysql-standard-5.0.24a-linux-i686-glibc23.tar.gz
>
>
>
> In http://dev.mysql.com/doc/refman/5.0/...tes-linux.html says that
> it is possible that mysql couldn't resolves ips for hostnames.
>
>
>
> First I install mysql-standard-5.0.24a-linux-i686-glibc23.tar.gz and
> executing mysql_install_db it says:
>
>
>
> Sorry, the host 'xxxx' could not be looked up
>
>
>
> Then I install mysql-standard-5.0.24a-linux-i686.tar.gz and says the same
> when I execute mysql_install_db.
>
>
>
> Sorry, the host 'xxxx' could not be looked up
>
>
>
> Aside from not could use hostnames what from these releases is best for me?
>
>
>
> Iago.
>
>

Finally I have an erroneous /etc/hosts file.

But aside from that what of the realeses is best suited for a CentOS 4.4
Double Pentium III 1.0 Ghz?

* Linux (x86, glibc-2.2, "standard" is static, gcc):
mysql-standard-5.0.24a-linux-i686.tar.gz
* Linux (x86): mysql-standard-5.0.24a-linux-i686-glibc23.tar.gz

The first is compiled statically with glibc-2.2 and the second is compiled
dinamically against glibc-2.3. CentOS 4.4 uses glibc-2.3. Then which is the
best suited?

For update is more easier using rpm relases but If I want to downgrade to
the previous version I only have to change the symbolic link mysql in
/usr/local/mysql to the directory of the previous version if I use binary
instead of rpm releases. That works because I use another director for data
thant /usr/local/mysql/data. Could I do these with rpm?


-----Mensaje original-----
De: Chris [mailto:dmagick@gmail.com]
Enviado el: viernes, 22 de septiembre de 2006 2:19
Para: informatica@esanluis.com
CC: MySql Mail List
Asunto: Re: What mysql 5.0 binary relase use for CentOS 4.4 Pentium?

informatica@esanluis.com wrote:
> Hi.
>
>
>
> What binary relase use for CentOS 4.4:
>
>
>
> * Linux (x86, glibc-2.2, "standard" is static, gcc):
> mysql-standard-5.0.24a-linux-i686.tar.gz
> * Linux (x86): mysql-standard-5.0.24a-linux-i686-glibc23.tar.gz
>
>
>
> In http://dev.mysql.com/doc/refman/5.0/...tes-linux.html says
that
> it is possible that mysql couldn't resolves ips for hostnames.
>
>
>
> First I install mysql-standard-5.0.24a-linux-i686-glibc23.tar.gz and
> executing mysql_install_db it says:
>
>
>
> Sorry, the host 'xxxx' could not be looked up

If you read that page:

You can deal with this by executing mysql_install_db --force, which does
not execute the resolveip test in mysql_install_db. The downside is that
you cannot use hostnames in the grant tables: except for localhost, you
must use IP numbers instead. If you are using an old version of MySQL
that does not support --force, you must manually remove the resolveip
test in mysql_install using a text editor.

Basically your DNS is stuffed and mysql can't look up hostnames.


Why aren't you using the rpms? They are much easier to deal with when it
comes time to upgrade.