nah, hosts.allow and hosts.deny are clean like I said, I think there is some mysql trick that fixes this it just seems like this would be a common problem have you run a similar setup and done this?? On Tue, 2003-01-28 at 18:50, Jay Crews wrote: > Dave Robbins writes.... > > > > damned, don't make me use that security tool again > > lost all connection to the web! > > yikes, that sucked > > seems to be back to normal now > > > > my understanding is that if I want a user foo to be able to connect from > > a remote client, I need to > > > > grant all on *.* to foo@localhost identfied as bar > > grant all on *.* to foo@192.168.10.% identidied as bar > > Yeah....looks right. > > WOW....still looks like a firewall problem. > the server IS running, cause you can connect to it. > > You haven't done anything to /etc/hosts.deny and /etc/hosts.allow > have you? Think by default they are empty, which should be okay. > > > > > > for use/passwd foo/bar > > that syntax might not be perfect but you get the point > > > > from the local machine I can connect as foo with no problem > > > > I really don't think it's a permission issue because of the way telnet > > acts from the remote client, it exits immediately > > Agreed. > Telnet is ultimately going to disconnect, but you should get a connection > initially anyhow. > > > I think I had this prob a long time ago on a diferent machine and the > > solution was some command to mysql > > I think it;s just not answering on that port > > > > Dave > > > > On Tue, 2003-01-28 at 18:24, Jay Crews wrote: > > > Dave Robbins writes.... > > > > > > > > > > > > I'm pretty sure when I installed I picked no firewall > > > > I'm behind the router and I figured it did the job > > > > I went to the security GUI tool thingy and it said security is set on > > > > high. I'm running apache/postfix and can use ftp, ssh > > > > I set the security level to none and clicked "make it so" > > > > I re-entered the GUI tool and the level was still set to high > > > > somethin ain't right > > > > stay tuned for the next installment > > > > > > Yeah....that's something that > > > has been pointed out a few times here. > > > The tool doesn't read the current setting. It just > > > defaults to high when you start the tool. > > > But if you set it to none, that should be okay....I guess. > > > > > > But I think you can simply turn off/on iptables with the > > > 'service' command too, without changing any of the specific > > > filters. When I do, "chkconfig --list | grep ^ip" I get, > > > > > > ==> ip6tables 0:off 1:off 2:on 3:on 4:on 5:on 6:off > > > ==> ipchains 0:off 1:off 2:on 3:on 4:on 5:on 6:off > > > ==> iptables 0:off 1:off 2:on 3:on 4:on 5:on 6:off > > > > > > I think you can just toggle these on or off with, > > > "service iptables off" without messing with the actual rules. > > > If after turning it off, it works, then you'll have to figure out > > > the specific rules. > > > > > > > > > But lets assume the firewall is ok (since that is your thought.) > > > You did do the MySQL GRANTS correctly for the USER/HOST that you are trying > > > to come in on. You realize there is a "pairing" thing going on there, right? > > > > > > Another question........are you able to connect as a user, other than root > > > or the default MySQL login, to the database? > > > ie Create a MySQL user, give him a passwd, and login from the localhost. > > > (Be sure to do it from localhost so we can narrow that part down.) > > > > > > How are you trying to login? > > > >From another Linux box on the LAN with something like, > > > mysql -ujoe_user -h192.168.1.10 -p > > > > > > -- Jay Crews > > > jpc@jaycrews.com > > > > > > > > > > > > -- > > > Psyche-list mailing list > > > Psyche-list@redhat.com > > > https://listman.redhat.com/mailman/listinfo/psyche-list > > > > > > > > > > -- > > Psyche-list mailing list > > Psyche-list@redhat.com > > https://listman.redhat.com/mailman/listinfo/psyche-list > > > > > -- Jay Crews > jpc@jaycrews.com > > > > -- > Psyche-list mailing list > Psyche-list@redhat.com > https://listman.redhat.com/mailman/listinfo/psyche-list -- Psyche-list mailing list Psyche-list@redhat.com https://listman.redhat.com/mailman/listinfo/psyche-list
