Thanks Allen but I'm running php4 not php5. This is an Apache module issue, not a php module issue. The app functions fine with data returning from the DB.
Thanks anyway! On Feb 3, 2008 9:15 PM, Allen <[EMAIL PROTECTED]> wrote: > > > 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. > -- Simon H
