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
socket = /tmp/mysql.sock
port = 3306
basedir = /usr
datadir = /usr/local/mysql
tmpdir = /tmp
language = /usr/local/share/mysql/english/
bind-address = 192.168.xxx.xxx
log = /var/log/mysql.log
# skip-networking
My server has two nics, one for internal access at the 192.168.xxx.xxx
address, and another for external access at 76.343.xxx.xxx
It is this second IP, the external one, I would like to implement so
that the database server is accessible externally to people through
OpenOffice.org 2.4. To accomplish this I changed the file to:
[mysqld]
user = mysql
pid-file = /usr/local/mysql/bigskypenguin.com.pid
socket = /tmp/mysql.sock
port = 3306
basedir = /usr
datadir = /usr/local/mysql
tmpdir = /tmp
language = /usr/local/share/mysql/english/
bind-address = 76.343.xxx.xxx
log = /var/log/mysql.log
# skip-networking
But configured in this way, the MySQL server will not restart.
I attempt a
/usr/local/etc/rc.d/mysql-server.sh restart
But the server does not start until I change the address back to the LAN
address.
Any help would be appreciated. I have not found via Google anyone else
having this issue.
Does that IP address resolve to your hostname?
--
Gerald L. Clark
Sr. V.P. Development
Supplier Systems Corporation
Unix since 1982
Linux since 1992
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]