> On Feb 3, 2008 12:58 PM, Simon H <[EMAIL PROTECTED]> wrote:
> 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?
>
It sure sounds like you're missing
php5-mysql-5.x.x mysql database access extensions for php5
What's the output of:
pkg_info | grep php5-mysql
Once that package is built (and installed) in the case of 4.2, you'll
need to run:
# /usr/local/sbin/phpxs -a mysql
After which you should see something like:
Activating extension : mysql
Good luck with it,
Allen
P.S. Remember to restart Apache, too. ;-)
--
http://www.alliedquotes.com -
Health Insurance Quotes, Resources & More.
Get free quotes in all 50 U.S. States.
