View previous topic :: View next topic |
Author |
Message |
wonker n00b
Joined: 24 Jun 2005 Posts: 19 Location: Glasgow
|
Posted: Fri Jul 22, 2005 8:30 am Post subject: issues with mysql |
|
|
Hey,
Ive installed Apache and PHP, but i seem to be having issues with MySQL . Ive had a search on the forum and im not the only person who has had this prob, however, the fixes that seem to have worked for others, have done nothing for me
ive been following gentoo-wiki.com to the letter, and when it comes to entering
Quote: | /usr/bin/mysql_install_db |
i get this
Quote: | Neither host 'tman1' nor 'localhost' could not be looked up with
/usr/bin/resolveip
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
|
All of the other posts seem to tell ppl to sort out their /etc/hosts file, but ive done this ( see below for my /etc/hosts file )
Quote: |
127.0.0.1 localhost tman1
192.168.1.64 tman1
|
when i use Quote: | /usr/bin/mysql_install_db --force | as sugested, and then try to set the root password, it gives me this
Quote: |
/usr/bin/mysqladmin: connect to server at 'tman1' failed
error: 'Unknown MySQL Server Host 'tman1' (1)'
Check that mysqld is running on tman1 and that the port is 3306.
You can check this by doing 'telnet tman1 3306' |
Ive also noticed that i cant ping my host ( tman1 ).
Any help would be much appreciated thanks
TC _________________ If its not on fire, its a software issue |
|
Back to top |
|
|
keyson l33t
Joined: 10 Jun 2003 Posts: 830 Location: Sweden
|
Posted: Fri Jul 22, 2005 8:46 am Post subject: |
|
|
Hi.
Fix your /etc/hosts
Quote: |
127.0.0.1 localhost tman1
192.168.1.64 tman1
|
it's giving the same name to both ip's. And if you try to connect by name
it have trouble to know the ip.
Should look like this.
Code: |
127.0.0.1 localhost
192.168.1.64 tman1
|
|
|
Back to top |
|
|
wonker n00b
Joined: 24 Jun 2005 Posts: 19 Location: Glasgow
|
Posted: Fri Jul 22, 2005 5:22 pm Post subject: |
|
|
Hi,
Ive changed my /etc/hosts file and im still getting the same issues _________________ If its not on fire, its a software issue |
|
Back to top |
|
|
keyson l33t
Joined: 10 Jun 2003 Posts: 830 Location: Sweden
|
Posted: Fri Jul 22, 2005 5:36 pm Post subject: |
|
|
Hi
Can you ping the tman1 now?
I think there is a issue to set the password with host other than localhost.
The secuerty setting in my.cnf is set to bind only to 127.0.0.1. |
|
Back to top |
|
|
wonker n00b
Joined: 24 Jun 2005 Posts: 19 Location: Glasgow
|
Posted: Fri Jul 22, 2005 6:28 pm Post subject: |
|
|
No joy im afraid tman1 is pingless
in the my.cnf file, there is this:
Quote: |
# keep secure by default!
bind-address = 127.0.0.1
port = 3306
|
I am well and truely stumped _________________ If its not on fire, its a software issue |
|
Back to top |
|
|
keyson l33t
Joined: 10 Jun 2003 Posts: 830 Location: Sweden
|
Posted: Fri Jul 22, 2005 9:20 pm Post subject: |
|
|
Sorry for the delay.
It may be an issue with the resolv on your machine.
Have you set any domainname (/etc/conf.d/domainname in the new baselayout)
(or /etc/dnsdomainname in the old (i think))
And are you starting the domainname in any runlevel?
Code: |
rc-update show |grep domainname |
and you se if it say boot or default after.
In that way you may have to set the fqdn in the /etc/hosts
For examle you set domainname to 'foo.bar' then you should have
a /etc/hosts like this.
Code: |
127.0.0.1 localhost
192.168.1.64 tman1.foo.bar tman1
|
or
Code: |
127.0.0.1 localhost.localdomain localhost
192.168.1.64 tman1.foo.bar tman1
|
And the ip on eth0 must match that in hosts
Have hade some problem on some other systems with this
Regards
Kjell |
|
Back to top |
|
|
wonker n00b
Joined: 24 Jun 2005 Posts: 19 Location: Glasgow
|
Posted: Sat Jul 23, 2005 2:09 pm Post subject: |
|
|
still no joy
ive checked the /etc/conf.d/hostname file, and this looks like
the /etc/hosts file now looks like this
Quote: | 127.0.0.1 localhost.localdomain localhost
192.168.1.64 tman1.tc1.hopto.org tman1 |
It seems that the soloutions that have worked for other people have no effect on the issues im having whats the samaritans phone number? _________________ If its not on fire, its a software issue |
|
Back to top |
|
|
keyson l33t
Joined: 10 Jun 2003 Posts: 830 Location: Sweden
|
Posted: Sat Jul 23, 2005 2:13 pm Post subject: |
|
|
Hi
Have no clue as everything seems ok.
Hopfully someone else have something to say about it. |
|
Back to top |
|
|
wonker n00b
Joined: 24 Jun 2005 Posts: 19 Location: Glasgow
|
Posted: Sat Jul 23, 2005 2:20 pm Post subject: |
|
|
Thanks for you help anyways much appreciated _________________ If its not on fire, its a software issue |
|
Back to top |
|
|
|