Hi all,

Still trying to get everything up and running on Leopard. Resolved at least 1 strange issue which I'll report on after I make sure everything works.

I am continuing to have a problem with tools like dspam and sqlgrey connecting to mysql. With a lot of retrying and searching, the one thing I've come across that seems strange is that when I enter mysql_config, it tells me the following:


--cflags [-I/usr/local/mysql/include/mysql -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DIGNORE_SIGHUP_SIGQUIT]
--include [-I/usr/local/mysql/include/mysql]
--libs [-L/usr/local/mysql/lib/mysql -lmysqlclient -lz -lm]
--libs_r [-L/usr/local/mysql/lib/mysql -lmysqlclient_r -lz -lm]
--socket [/tmp/mysql.sock]
--port [0]
--version [5.0.67]
--libmysqld-libs [-L/usr/local/mysql/lib/mysql -lmysqld -lz -lm]


What's strange is that the port is listed as 0, although in my.cnf the port is declared as 3306.

I'll keep googling, but if anyone has an idea, please let me know.

Dave

If you did follow the security guidelines with skip-networking the port won't work. The safest solution to connect is using the socket option for all connections. This works with dspam and sqlgrey as I set it up myself. However this is still a stange error.

To make sure your my.cnf is used, make some changes that you would note there and restart mysql to see if the changes are reflected in the running mysql.

I found several times that errors where related to mysql server not running while I thought it was.