MySQL won't start with external bind-adress in my.cnf

2008-07-29 Thread Skip Evans
Hey all, I'm trying to get my MySQL server configured so outside connections can access it with OpenOffice.org 2.4. My server is running on FreeBSD 6.0 and the my.cnf file looks like this currently. [mysqld] user = mysql pid-file = /usr/local/mysql/bigskypenguin.com.pid socket =

Re: MySQL won't start with external bind-adress in my.cnf

2008-07-29 Thread Skip Evans
Hey Chaim, I'm sorry, I don't know what you mean by default route. I am only familiar with the current contents of my.cnf, and mods were made according to instructions I found via Google. I don't see this noted in MySQL anywhere. Is this a network-wide configuration? Skip Chaim Rieger

Re: MySQL won't start with external bind-adress in my.cnf

2008-07-29 Thread Gerald L. Clark
Skip Evans wrote: Hey all, I'm trying to get my MySQL server configured so outside connections can access it with OpenOffice.org 2.4. My server is running on FreeBSD 6.0 and the my.cnf file looks like this currently. [mysqld] user = mysql pid-file = /usr/local/mysql/bigskypenguin.com.pid

Re: MySQL won't start with external bind-adress in my.cnf

2008-07-29 Thread Chaim Rieger
Skip Evans wrote: Hey Chaim, I'm sorry, I don't know what you mean by default route. I am only familiar with the current contents of my.cnf, and mods were made according to instructions I found via Google. I don't see this noted in MySQL anywhere. Is this a network-wide configuration? can

Re: MySQL won't start with external bind-adress in my.cnf

2008-07-29 Thread Skip Evans
Gerald L. Clark wrote: Does that IP address resolve to your hostname? Yes, it does. -- 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

RE: MySQL won't start with external bind-adress in my.cnf

2008-07-29 Thread Mary Bahrami
-Original Message- From: Skip Evans [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2008 10:38 AM To: mysql@lists.mysql.com Subject: MySQL won't start with external bind-adress in my.cnf Hey all, I'm trying to get my MySQL server configured so outside connections can access

Re: MySQL won't start with external bind-adress in my.cnf

2008-07-29 Thread Skip Evans
Chaim Rieger wrote: Skip Evans wrote: can you post the output of ifconfig please bge0: flags=8843UP,BROADCAST,RUNNING,SIMPLEX,MULTICAST mtu 1500 options=1aTXCSUM,VLAN_MTU,VLAN_HWTAGGING inet6 fe80::230:48ff:fe88:2b8a%bge0 prefixlen 64 scopeid 0x1 inet 192.168.1.100

Re: MySQL won't start with external bind-adress in my.cnf

2008-07-29 Thread Skip Evans
Chaim Rieger wrote: can you post the output of ifconfig please I should have noted that 192.168.1.250 on bge1 is configured for port forwarding to the public IP address of the server. -- Skip Evans Big Sky Penguin, LLC 503 S Baldwin St, #1 Madison, WI 53703 608-250-2720

Re: MySQL won't start with external bind-adress in my.cnf

2008-07-29 Thread Chaim Rieger
Skip Evans wrote: Chaim Rieger wrote: Skip Evans wrote: can you post the output of ifconfig please bge0: flags=8843UP,BROADCAST,RUNNING,SIMPLEX,MULTICAST mtu 1500 options=1aTXCSUM,VLAN_MTU,VLAN_HWTAGGING inet6 fe80::230:48ff:fe88:2b8a%bge0 prefixlen 64 scopeid 0x1 inet

Re: MySQL won't start with external bind-adress in my.cnf

2008-07-29 Thread Skip Evans
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