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 t

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=8843 mtu 1500 options=1a inet6 fe80::230:48ff:fe88:2b8a%bge0 prefixlen 64 scopeid 0x1 inet 192.168.1.100 netmask 0xff00 broadcast 192.168.1.255 bge1: flags

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 http://bigskypengu

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=8843 mtu 1500 options=1a inet6 fe80::230:48ff:fe88:2b8a%bge0 prefixlen 64 scopeid 0x1 inet 192.168.1.100 netmask 0xff00 broadcast 192.168.1.255 ether 00:30:48:88

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

2008-07-29 Thread Mary Bahrami
ull 2>&1 & -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 c

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 deve

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? ca

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 s

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

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 = /tmp/mysql