Thanks Chaim,
You just clued me in.
First, when you said to post output of ifconfig, I
realized my LAN is configured not directly to the
public address, but to
192.168.1.250
which is then tied to the public IP through port
forwarding. I'm not completely up on why this was
done, but when the AT&T tech helped me configure
my LAN and public IPs through the Netopia DSL
modem, we ended up doing that to make it work
properly. I think it has something to do with a
requirement in the Netopia modem.
So next I changed the bind-address in my.cnf to
the 192.168.1.250 mysql came up fine and all is
well with internal access.
Next I set up my latop to connect via ODBC through
the public address, and with MySQL is bound to the
192.168.1.250 on the server side makes the proper
connection.
So, in short I have:
1) External connections to public address
2) MySQL on the server binding to 192.168.1.250
3) 192.168.1.250 port forwarding to public addres
4) External OpenOffice.org successfully connecting
to the database.
Thanks! You guys got me pointing the right
direction and all is good now.
Chaim Rieger wrote:
Skip Evans wrote:
Chaim Rieger wrote:
Skip Evans wrote:
can you post the output of ifconfig please
bge0: flags=8843<UP,BROADCAST,RUNNING,SIMPLEX,MULTICAST> mtu 1500
options=1a<TXCSUM,VLAN_MTU,VLAN_HWTAGGING>
inet6 fe80::230:48ff:fe88:2b8a%bge0 prefixlen 64 scopeid 0x1
inet 192.168.1.100 netmask 0xffffff00 broadcast 192.168.1.255
bge1: flags=8843<UP,BROADCAST,RUNNING,SIMPLEX,MULTICAST> mtu 1500
options=1a<TXCSUM,VLAN_MTU,VLAN_HWTAGGING>
inet6 fe80::230:48ff:fe88:2b8b%bge1 prefixlen 64 scopeid 0x2
inet
netmask 0xffffff00 broadcast 192.168.1.255
ok
where do you come up with the public addy then ?
i only see private ips listed
i would change it to allow networking on all interfaces.
--
Skip Evans
Big Sky Penguin, LLC
503 S Baldwin St, #1
Madison, WI 53703
608-250-2720
http://bigskypenguin.com
=-=-=-=-=-=-=-=-=-=
Check out PHPenguin, a lightweight and versatile
PHP/MySQL, AJAX & DHTML development framework.
http://phpenguin.bigskypenguin.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
