[SMS]

baboo · Senior Member Joined: 04 Sep 2007 Posts: 676

Here is the problem I having:

Msql and igsuite work if I use the server without any changes. When I change the hostname in the following files; /etc/hostss /etc/HOSTNAME, after a reboot it shows the hostname as changed. However, when I try to create the igsuite databse and host option I get an error message that it can not connect to root@localhost.

I did a resolveip server1 and it comes back that it can not resolve ip for server1. If I type hostname it comes back server1.

So, this means there is someplace within the system that needs the ip or host name. Any suggestions where I should look. I've really tried but have not been successful in finding what is missing. I've been playing with sms at home since I have a broken foot. Next week I would like to setup at school and have them testing it, so any suggestions would be greatly appreciated.

thanks

gerasimos_h · Posted: Thu Sep 13, 2007 8:07 pm Post subject:

baboo · Senior Member Joined: 04 Sep 2007 Posts: 676

I did not remove localhost :

/etc/hosts:

127.0.0.0 localhost
192.168.0.60 server1.cliqn.com server1

/etc/HOSTNAME:

server1.cliqn.com

I can ping myself and from any computer on net ping 192.168.0.60.

thanks for the help

gerasimos_h · Posted: Thu Sep 13, 2007 10:48 pm Post subject:

I believe /etc/hosts should be

baboo · Senior Member Joined: 04 Sep 2007 Posts: 676

I edited /etc/hosts and restarted mysql and network. Now I can not connect to mysql. I get access denied for user 'root' @ localhost

gerasimos_h · Posted: Thu Sep 13, 2007 11:23 pm Post subject:

/etc/hosts should be like described above...
server1 is your localhost so you have to give 127.0.0.1.
In your hosts you had 127.0.0.0 I don't know if it was a mistyped, if don't try it.
Try to reboot beside restarting services.
Try to reset root's mysql password.