Hallo everyone,
I've setup a web server with OpenBSD 3.7, default install Apache, PHP 5.0.3
and MySQL 4.0.23. When I connect from other hosts to mysql, everything works
fine, and then I try to connect to mysql local console, it works too. I know
that apache is chrooted so my rc.local looks like this:
<--snip-->
if [ X"${mysql}" == X"YES" -a -x /usr/local/bin/mysqld_safe ];
then
echo -n ' mysqld';
/usr/local/bin/mysqld_safe --user=_mysql --bind-address=10.30.1.222
--log=/var/mysql/errorlog >/dev/null 2>&1 &
for i in 1 2 3 4 5 6;
do if [ -S /var/run/mysql/mysql.sock ];
then
break
else
sleep 1
echo -n '.'
fi done
sleep 5
ln -sf /var/run/mysql/mysql.sock /var/www/var/run/mysql/mysql.sock
fi
</--snip-->
Like you see I'm using soft link, it's because my /var and /var/www are on
different mount points, so hard links can't be made. To test if socket is
working I've issued this command:
mysqladmin --socket=/var/www/var/run/mysql/mysql.sock version -u 'user' -p
And it works perfectly, but when I try to use a test web page with code:
<--snip-->
<?
$link = mysql_connect('localhost', 'user', 'password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>
</--snip-->
I get an error:
<--snip-->
[error] PHP Warning: mysql_connect() [<a
href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to
local MySQL server through socket '/var/www/var/run/mysql/mysql.sock' (2)
</--snip-->
I've been playing around with this configuration for about too days and it
seems I've tried everything, but I can't get it working, please help me,
what I'm missing here...
