by I have a fresh installation of OpenBSD 3.2. I have not made any
alterations to the base installation. I enabled Apache via rc.conf
and tested (I also enabled server-status & server-info in httpd.conf).
I installed PHP4 from the packages tree at 3.2/Packages. I configured
according to the instructions at webmonkey and tested with phpinfo().
I integrated with Apache and tested with the sample php3 script shown
below:
<html>
<body>
<?php
$myvar = "Hello Adam";
echo $myvar;
?>
</body>
</html>
which worked fine. (Returned "Hello Adam")
I then installed mysql from the package currently in 3.2/Packages with
its supporting packages (p5-DBD-1.30, mysql-client-3.23.54,
p5-DBD-Mssql-Mysql-1.22.19, libiconv-1.8, gettext-0.10.40 and
recode-3.6). I enabled MySQL to start at reboot using the
instructions at http://www.hostbaby.com/misc/mysql-openbsd.html.
After a reboot, mysql starts on port 3306 w/a PID of 8643. I set the
password, created a test database and verified the functionality of
the base databases.
I added the php4-mysql-4.2.3 package to enable integration with MySql
and verified that phpinfo() returns MySQL integration successfully,
which it does.
I prepared the following script in /var/www/htdocs (named test2.php3):
<html>
<body>
<?php
$db = mysql_connect("localhost", "root");
mysql_select_db("mydb",$db);
$result = mysql_query("SELECT * FROM employees",$db);
printf("First Name: %s<br>\n", mysql_result($result,0,"first"));
?>
</body>
</html>
When I open my browser to http://target_Svr/test2.php3, I get the
following
Warning: Can't connect to local MySQL server through socket
'/var/run/mysql/mysql.sock' (2) in /htdocs/test2.php3 on line 7
Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/var/run/mysql/mysql.sock' (2) in /htdocs/test2.php3
on line 7
Warning: mysql_select_db(): supplied argument is not a valid
MySQL-Link resource in /htdocs/test2.php3 on line 9
Warning: mysql_query(): supplied argument is not a valid MySQL-Link
resource in /htdocs/test2.php3 on line 11
Warning: mysql_result(): supplied argument is not a valid MySQL result
resource in /htdocs/test2.php3 on line 13
First Name:
So, I rolled over to /var/run/mysql and noticed that mysql.sock did
exist with filesize 0.
I have been searching and working on this for over a week, any help
would be greatly appreciated. Top it off, its for a non-profit org
that I decided to help out.. so its a good cause.