We are using a spring wireless connection card on one of our laptops,
and we have a dynamic ip assignment service (ODS.org, DynDNS.org) to
update a domain name with the new ip each time we connect with the
card. The DNS assignment works fine, internet browsing works fine, and
so does VNC-in into the laptop from a remote client.

We are trying to setup database replication between a remote webserver
far away, and this laptop. We can successfully make the laptop a slave
of the remote webserver's db, and replication works fine in that one
way. But if we try to make the webserver a slave of the laptop as
well, heck, even try to remotely connect to the laptop's MySQL from
any computer, the connection fails.

The laptop can connect out remotely, but nothing can connect in. We
have tracked it down to the Sprint card as being the culprit, since
placing the laptop on any other connection (hardline) makes it work
fine both ways.

The card is using a PPP connection to connect, and is assigned a
certain phone number.

I grant the webserver access using:

GRANT REPLICATION CLIENT, REPLICATION SLAVE ON DBTEST.* TO
'replicant'@'webserver.com' identified by 'password';

This works fine on any connection besides the spring card.

When trying to connect to the laptop from any computer, we get a
"server not found" style error:

c:\Program Files\MySQL>mysql -u replicant -p -h laptopHostName.com
Enter password: ********
ERROR 2003 (HY000): Can't connect to MySQL server on
'laptopHostName.com' (10060)

Once again, it only exhibits this problem when using the sprint card
as the internet connection device for the laptop.

Any suggestions?

On Sat, 29 Dec 2007 17:00:29 -0800 (PST), Adam Grant
<adam.jgrant@gmail.com> wrote:

>We are using a spring wireless connection card on one of our laptops,
>and we have a dynamic ip assignment service (ODS.org, DynDNS.org) to
>update a domain name with the new ip each time we connect with the
>card. The DNS assignment works fine, internet browsing works fine, and
>so does VNC-in into the laptop from a remote client.
>
>We are trying to setup database replication between a remote webserver
>far away, and this laptop. We can successfully make the laptop a slave
>of the remote webserver's db, and replication works fine in that one
>way. But if we try to make the webserver a slave of the laptop as
>well, heck, even try to remotely connect to the laptop's MySQL from
>any computer, the connection fails.
>
>The laptop can connect out remotely, but nothing can connect in. We
>have tracked it down to the Sprint card as being the culprit, since
>placing the laptop on any other connection (hardline) makes it work
>fine both ways.
>
>The card is using a PPP connection to connect, and is assigned a
>certain phone number.
>
>I grant the webserver access using:
>
>GRANT REPLICATION CLIENT, REPLICATION SLAVE ON DBTEST.* TO
>'replicant'@'webserver.com' identified by 'password';
>
>This works fine on any connection besides the spring card.
>
>When trying to connect to the laptop from any computer, we get a
>"server not found" style error:
>
>c:\Program Files\MySQL>mysql -u replicant -p -h laptopHostName.com
>Enter password: ********
>ERROR 2003 (HY000): Can't connect to MySQL server on
>'laptopHostName.com' (10060)
>
>Once again, it only exhibits this problem when using the sprint card
>as the internet connection device for the laptop.
>
>Any suggestions?

Sounds like a firewall / NAT problem.
Perhaps Sprint doesn't allow you to run a server or
worries about security and blocks incoming connections.

I guess 99.9% of wireless connection cards is only used as
a client, for things like web browsing, chatting and
transferring mail (all outgoing connections).

Anyway, you will have to ask Sprint about this.
--
( Kees
)
c[_] You hear someone break into your home. You pull out your
chainsaw and crank it up. It makes its very distinctive
chainsaw noise; he hears it. What criminal is going to
stay in a house with someone that crazy?
(Home defence with Franklin Hummel r.a.sf.w) (#247)

>We are using a spring wireless connection card on one of our laptops,
>and we have a dynamic ip assignment service (ODS.org, DynDNS.org) to
>update a domain name with the new ip each time we connect with the
>card. The DNS assignment works fine, internet browsing works fine, and
>so does VNC-in into the laptop from a remote client.
>
>We are trying to setup database replication between a remote webserver
>far away, and this laptop. We can successfully make the laptop a slave
>of the remote webserver's db, and replication works fine in that one
>way. But if we try to make the webserver a slave of the laptop as
>well, heck, even try to remotely connect to the laptop's MySQL from
>any computer, the connection fails.

Are you sure you have the correct IP address for the laptop? DNS
tends cache stuff, and even if you change the IP address associated
with the domain name immediately, it may take a while to actually
show the new IP address in queries. With stuff held at registrars,
two days is not that uncommon. With stuff at a dynamic-IP service,
you still might have problems for 10 minutes. What's the TTL on
the DNS record for the laptop?

Your laptop's ISP may not permit incoming connections. It might
be behind a NAT gateway or simply a firewall that won't let port
3306 through. You could try using a different port. But if this
is the problem, it may be "game over" if you can't change ISPs or
their policies.

>The laptop can connect out remotely, but nothing can connect in. We
>have tracked it down to the Sprint card as being the culprit, since
>placing the laptop on any other connection (hardline) makes it work
>fine both ways.

Try telnetting from the web server to the laptop on port 3305.
Assuming you've got nothing running on port 3305 on the laptop, you
should get an immediate failure. If it waits a minute or so and
then gives a timeout, chances are is a firewall blocking it.

>The card is using a PPP connection to connect, and is assigned a
>certain phone number.
>
>I grant the webserver access using:
>
>GRANT REPLICATION CLIENT, REPLICATION SLAVE ON DBTEST.* TO
>'replicant'@'webserver.com' identified by 'password';
>
>This works fine on any connection besides the spring card.
>
>When trying to connect to the laptop from any computer, we get a
>"server not found" style error:
>
>c:\Program Files\MySQL>mysql -u replicant -p -h laptopHostName.com
>Enter password: ********
>ERROR 2003 (HY000): Can't connect to MySQL server on
>'laptopHostName.com' (10060)

How long did this take to fail? Over a minute suggests a firewall
dropping incoming connection packets.

>Once again, it only exhibits this problem when using the sprint card
>as the internet connection device for the laptop.
>
>Any suggestions?

New ISP and wireless card?