[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: MySQL won't start with external bind-adress in my.cnf
From:       Skip Evans <skip () bigskypenguin ! com>
Date:       2008-07-29 18:58:53
Message-ID: 488F686D.50600 () bigskypenguin ! com
[Download RAW message or body]

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/mysql?unsub=mysql-marcsub@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]