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.
--
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]
