Thanks for the quick response.
Firstly, the app itself uses MySQL for content successfully already so
the php connections are fine. The MySQL socket is in the Apache
chroot (/var/www/var/run/mysql/mysql.sock). I did try running apache
with httpd -u, and got the exact same result.
Further responses inline below...
On Feb 3, 2008 8:35 PM, Brian A. Seklecki (Mobile)
<[EMAIL PROTECTED]> wrote:
> Show:
>
> $ pkg_info | grep -i sql
# pkg_info | grep -i sql
mod_auth_mysql-3.2p2 Apache MySQL authentication module
mysql-client-5.0.45 multithreaded SQL database (client)
mysql-server-5.0.45 multithreaded SQL database (server)
p5-DBD-mysql-3.0008 MySQL drivers for the Perl DBI
php4-mysql-4.4.1p1 mysql database access extensions for php4
>
> Also:
>
> $ ldd /usr/lib/apache/modules/mod_auth_mysql.so
# ldd /usr/lib/apache/modules/mod_auth_mysql.so
/usr/lib/apache/modules/mod_auth_mysql.so:
Start End Type Open Ref GrpRef Name
0a68d000 2a691000 dlib 1 0 0
/usr/lib/apache/modules/mod_auth_mysql.so
0ca65000 2ca93000 rlib 0 1 0
/usr/local/lib/libmysqlclient.so.18.0
0610b000 26113000 rlib 0 1 0 /usr/lib/libz.so.4.1
0baae000 2badd000 rlib 0 1 0 /usr/lib/libcrypto.so.13.0
00d50000 20d5b000 rlib 0 1 0 /usr/lib/libssl.so.11.0
0d6f6000 2d6fd000 rlib 0 1 0 /usr/lib/libm.so.2.3
>
> Does the reference to the mysql lib have a valid path? Likely the
> package is simply not installed.
It would appear to be installed ok. That file exists in that
location, perms are ok (In fact, the package installs it with more
perms than the existing modules).
>
> ~BAS
>
>
> On Sun, 2008-02-03 at 14:30 -0600, L. V. Lammert wrote:
> > At 08:22 PM 2/3/2008 +0000, Simon H wrote:
> > >Hi all
> > >
> > >I recently inherited an old php/mysql app which I have migrated onto
> > >OpenBSD 4.2 with the latest MySQL/PHP packages and modules.
> > >
> > >I installed the mod_auth_mysql package after realizing the app did
> > >basic auth with this backend and when trying to start the server again
> > >I get:
> > >
> > >/usr/sbin/httpd:/usr/lib/apache/modules/mod_auth_mysql.so: undefined
> > >symbol 'mysql_connect'
> >
> > You don't have a mysql connection - check php_info(), .. are you running
> > chroot'd? If so, test with -u or copy all your libraries into the chroot.
> >
> > Lee
Any further ideas?
