On Mon, August 13, 2007 8:27 am, Gus Wirth wrote: > Lan Barnes wrote: >> Added both to the my.cnf in the FE/BE server, not the FE clients (I >> figured the "restart" instruction indicated that). >> >> Results interleaved >> >> On Sun, August 12, 2007 7:43 am, David Campbell wrote: >>> Lan Barnes wrote: >>>> stuff >>> add >>> >>> port = 3306 to /etc/my.cnf under [mysqld] >>> >>> restart mysql >>> >> >> Restarted but failed. This on the client: >> >> [EMAIL PROTECTED] ~]$ mysql -h xena -u mythtv -p mythconverg >> Enter password: >> ERROR 1045 (28000): Access denied for user 'mythtv'@'gypsy' (using >> password: YES) >> >> So the client (gypsy) is still looking for a local connection even >> though >> the "-h xena" flag is in the command and xena is in /etc/hosts (my home >> network is too small to justify DNS -- is that a problem here?). > [snip] > > Why do you think this? The message clearly tells you that the connection > is being rejected for the user mythtv with the client running on gypsy. > I see no indication that says it is trying to connect to gypsy. The > question is, WHICH machine is rejecting the connection? So how do you > know that the message is coming from gypsy trying to make a connection > to localhost instead of the connection trying to be made to xena and > being rejected there? > > A quick check would be to disconnect xena from the network and try the > test again from gypsy and see if you get the same error message. > > A better test would be to run a packet sniffer (Wireshark, previously > known as Ethereal) on gypsy to see what is going on in the network. > > > Gus > >
Excellent point. If I hadn't worked the whole thing out, I'd do your test. Certainly I'll add this trick to any future diagnosis. Thanks for making me smarter. -- Lan Barnes SCM Analyst Linux Guy Tcl/Tk Enthusiast Biodiesel Brewer -- KPLUG-List@kernel-panic.org http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
