Re: apache,php,mysql

[Derek Sivers <list@hitmedia.com>]

IMPORTANT:
This will save you hours of hair-pulling unsucessfully port-installing 
PHP+MySQL on OpenBSD.
(I know because I just installed these things yesterday...)

Last week, I installed the newest MySQL port, but the MySQLdaemon was 
stopping & starting all the time!
I wrote the list about this and Brad who made the MySQL port replied:

=--------------------------------=
    Unfortunately, the OpenBSD threads library has been known to be
    problematic at the moment, try using MySQL with the Pth threads library
    in the meantime. This can be automated quite easily by using the pth
    FLAVOR of the MySQL port. "make FLAVOR=pth install".
    // Brad
    brad@openbsd.org
=--------------------------------=

But when you make MySQL with "flavor=pth" then you can't do a PHP "make 
flavor="mysql" install" because it's looking for mysql-3.23.32 NOT 
mysql-3.23.32-pth!!!

This took hours and hours and hours of reinstalling to figure out.  Because 
it also won't properly UNinstall either.  SO...

I HIGHLY RECOMMEND THIS  (works perfectly, with the newest ports):

1. Go into /usr/ports/databases/mysql
2. Edit the Makefile to force a pth flavor.  Remove the "IF / FI" tags 
around these lines:

LIB_DEPENDS=    pthread.13::devel/pth
CONFIGURE_ENV=  CPPFLAGS="-I${LOCALBASE}/include" \
                 LDFLAGS="-L${LOCALBASE}/lib"

(in other words - make those lines happen no matter what - without a 
"flavor=" command.)

3.  Then just do "make install" and it will do the pth flavor.  MUCH more 
reliable and wonderful MySQL.

4.  Then go to /usr/ports/www/php4/ and do "make flavor=mysql install" and 
voila!  No problems!  FINALLY!

5.  Don't forget to copy your php.ini-dist into /var/www/conf/php.ini.  It 
doesn't do that automatically.