Re: PHP4 + mod_auth_mysql Problems

what you should be doing is compiling with a fresh source tree of mysql (or fresh binary distro) --with-mysql=/usr/local/mysql. That will force the compile to NOT use the client that is included with php4. You only need this (/usr/local/mysql) to compile the PHP4, it won't need it to run and that won't be the DB that it will try to connect to. It only has to be there so that it can find the includes and library files that it needs. Remember, when you are done, mysql_connect('the.other.machines','',''); (I think) you can once PHP is compiled, delete the /usr/local/mysql directory (I haven't done it in a while to know for sure... so you'll want to check) Then you should be set. -jeremy brand _______________________________________________________________________ GnuPG Fingerprint: 9F5E 95E0 1CC2 E054 84EA 6099 8ACD 9DBA D2C0 5EA9 _ http://www.JeremyBrand.com/Jeremy/Brand/Jeremy_Brand.html for more __ On Sun, 20 Aug 2000, Mike Goelzer wrote: > Date: Sun, 20 Aug 2000 12:43:41 -0400 > From: Mike Goelzer <mwglists@dailyjolt.com> > To: PHP General <php-general@lists.php.net> > Subject: [PHP] PHP4 + mod_auth_mysql Problems > > Is anyone else trying to use the combination of PHP4 + mod_auth_mysql? I'm > having some problems with this. > > Here's the basic story. I grabbed the PHP4.0.1pl2 tarball and ran the > following ./configure line: > > ./configure --with-mysql --with-apache=../apache_1.3.12 [other stuff...] > > The configure process worked fine, but at the very end it displayed the > following warning: > > +--------------------------------------------------------------------+ > | *** WARNING *** | > | | > | You chose to compile PHP with the built-in MySQL support. If you | > | are compiling a server module, and intend to use other server | > | modules that also use MySQL (e.g, mod_auth_mysql, PHP 3.0, | > | mod_perl) you must NOT rely on PHP's built-in MySQL support, and | > | instead build it with your local MySQL support files, by adding | > | --with-mysql=/path/to/mysql to your configure line. | > +--------------------------------------------------------------------+ > > Now, here's my problem. MySQL is not running on this server. That is, I > have two different servers: a mysql server and a web server. I am trying > to build PHP4 and mod_auth_mysql on the web server, but they will connect > to the mysql server when they need to use databases. So simply changing > the configure line to --with-mysql=/some/path/ isn't really an option for > me, since the path to mysql is not on the same physical machine. > > I have thought about using NFS to mount the mysql server's disk on the web > server's filesystem, but I don't really want to use NFS and I'd like to try > to avoid this if at all possible. Does anyone have any other > suggestions? The only other thing I can think of is to install a 'dummy' > installation of MySQL on the web server, which never gets used for anything > except to share the libs with PHP4. This is aesthetically displeasing > (extra software installed on the web server for no good reason), but it's > not hard. Is there a cleaner solution? > > -mike > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >