Re: mysql not working behind linksys router

[John Bateman]

Hi

Verify that connections from other hosts are allowed in your GRANTS Table(s). You need info in the Host, DB and User table the corresponding to the person connecting from the outside.

As for it crashing. I can't tell you what's causing that.



Bruce Lewis wrote:

You may want to check the advanced features of your Linksys router.  There
may be an IP imposed limit for the MYSQL server to the outside world.

It is part of a configuration that you can alter.  Check the IP filtering
area.

Bruce Lewis



----- Original Message -----
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 02, 2002 11:04 AM
Subject: re: mysql not working behind linksys router

Mir,
Sunday, December 01, 2002, 5:24:41 AM, you wrote:

MSI> Hi, apologies upfront since this is not directly a mysql question. I
MSI> have a mysql host sitting behind a linksys router/wireless ap. The

mysql

MSI> host is configured as a DMZ host in the router. All web/ftp other
MSI> connections are working fine, however mysql connection from outside

the

MSI> network is not working. Not only that if there is any inbound

connection

MSI> mysql crashes hard and does not accept any connection or process

anymore

MSI> queries.

MSI> Any idea what could be the possible cause?

What OS? What is the MySQL version? Have you  installed MySQL from binary
or source distribution?

MSI> Does mysql need other ports ope besides 3306 ?

Nope, if MySQL server is running on 3306.

MSI> Other DB (postgres) and services work fine. Although
MSI> I had to do some tricky stuff for the same host before I could get
MSI> proFTPD working for passive ftp.




--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
  __  ___     ___ ____  __
 /  |/  /_ __/ __/ __ \/ /    Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
      <___/   www.mysql.com




---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail

<[EMAIL PROTECTED]>

Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

--
John Bateman <[EMAIL PROTECTED]>
Senior Technical Architect
(450) 979-5766
Station InfiniWeb inc.
http://www.infiniweb.ca
/* Hébergement Web - Programmation Web - Sites Web - Nom de domaine  */
/* Web Hosting - Web Programming - Instant Websites - Domain name    */


---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php