| 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 |
|
|
|
Other Things Gentoo
