PHP install w/MySQL difference question

[Erik Price <pricee@xxxxxxxxxxx>]

Hello,

[The contents of this email contain quite an annoying amount of output 
from the command line, but please note that I have deleted most of the 
unnecessary output and tried to comment the parts that I felt were 
necessary.]

I am curious as to what the difference will be if I choose to install 
PHP4 with MySQL functionality, using only the built-in MySQL support.  
If I specify the /path/to/mysql in my ./configure option --with-mysql, 
then I get the following output:

localhost:~/tmp/apache_mod_php-6-2/php$ ./configure --with-xml 
--with-zlib --with-apxs=/usr/sbin/apxs --with-mysql=/usr/local/mysql
creating cache ./config.cache
... ( for sake of space, most ./configure output omitted ) ...

Generating files
checking for working mkdir -p... yes
creating config_vars.mk
updating cache ./config.cache
creating ./config.status
creating php4.spec
creating Zend/Makefile
creating main/build-defs.h
creating pear/scripts/pear
creating pear/scripts/phpize
creating pear/scripts/php-config
creating TSRM/Makefile
creating main/php_config.h
creating sapi/Makefile
creating ext/Makefile
creating Makefile
creating pear/Makefile
creating main/Makefile
creating ext/zlib/Makefile
creating ext/mysql/Makefile
creating ext/pcre/Makefile
creating ext/pcre/pcrelib/Makefile
creating ext/posix/Makefile
creating ext/session/Makefile
creating ext/standard/Makefile
creating ext/xml/Makefile
creating ext/xml/expat/Makefile
creating ext/xml/expat/xmlparse/Makefile
creating ext/xml/expat/xmltok/Makefile
creating sapi/apache/Makefile
creating regex/Makefile
creating number.c
creating number.h
creating main/internal_functions.c
+--------------------------------------------------------------------+
| License:                                                           |
| This software is subject to the PHP License, available in this     |
| distribution in the file LICENSE.  By continuing this installation |
| process, you are bound by the terms of this license agreement.     |
| If you do not agree with the terms of this license, you must abort |
| the installation process at this point.                            |
+--------------------------------------------------------------------+

Thank you for using PHP.

localhost:~/tmp/apache_mod_php-6-2/php$



But when I 'make' PHP, I get the following warnings (after it is done 
compiling):



*** Warning: This library needs some functionality provided by 
-lmysqlclient.
*** I have the capability to make that library automatically link in when
*** you link to this library.  But I can only do this if you have a
*** shared version of the library, which you do not appear to have.

*** Warning: This library needs some functionality provided by 
-lmysqlclient.
*** I have the capability to make that library automatically link in when
*** you link to this library.  But I can only do this if you have a
*** shared version of the library, which you do not appear to have.

*** Warning: libtool could not satisfy all declared inter-library
*** dependencies of module libphp4.  Therefore, libtool will create
*** a static module, that should work as long as the dlopening
*** application is linked with the -dlopen flag.
~/tmp/apache_mod_php-6-2/php/.libs/libphp4.lax/libZend.al
~/tmp/apache_mod_php-6-2/php/.libs/libphp4.lax/libsapi.al
~/tmp/apache_mod_php-6-2/php/.libs/libphp4.lax/libmain.al
~/tmp/apache_mod_php-6-2/php/.libs/libphp4.lax/libregex.al
~/tmp/apache_mod_php-6-2/php/.libs/libphp4.lax/libzlib.al
~/tmp/apache_mod_php-6-2/php/.libs/libphp4.lax/libmysql.al
~/tmp/apache_mod_php-6-2/php/.libs/libphp4.lax/libpcre.al
~/tmp/apache_mod_php-6-2/php/.libs/libphp4.lax/libposix.al
~/tmp/apache_mod_php-6-2/php/.libs/libphp4.lax/libsession.al
~/tmp/apache_mod_php-6-2/php/.libs/libphp4.lax/libstandard.al
~/tmp/apache_mod_php-6-2/php/.libs/libphp4.lax/libxml.al
~/tmp/apache_mod_php-6-2/php/.libs/libphp4.lax/libtsrm.al
~/tmp/apache_mod_php-6-2/php/.libs
Making all in pear
localhost:~/tmp/apache_mod_php-6-2/php$



So now it seems like I'm in the green -- it says that 'libtool will 
create a static module' for me.  But when I try to 'make install', I get 
an error.



localhost:~/tmp/apache_mod_php-6-2/php$ sudo make install
password:
... ( for sake of space, most 'make install' output omitted ) ...
Making install in .
/Users/eprice/tmp/apache_mod_php-6-2/php/build/shtool mkdir -p 
"/usr/libexec/httpd" && /usr/sbin/apxs -S 
LIBEXECDIR="/usr/libexec/httpd" -i -a -n php4 libs/libphp4.so
[activating module `php4' in /etc/httpd/httpd.conf]
cp libs/libphp4.so /usr/libexec/httpd/libphp4.so
cp: libs/libphp4.so: No such file or directory
apxs:Break: Command failed with rc=1
make[1]: *** [install-sapi] Error 1
make: *** [install-recursive] Error 1
localhost:~/tmp/apache_mod_php-6-2/php$



There seems not to have been a 'libphp4.so' to copy into 
'/usr/libexec/httpd/libphp4.so'.  I posted to this list earlier, asking 
for advice on making this 'libphp4.so' file, but it seems no one knew 
the answer.  So, now I am wondering what the net effect would be of not 
specifying any directory argument to the '--with-mysql' configure 
option.  In other words, I would do (note the change in the ./configure 
options):



localhost:~/tmp/apache_mod_php-6-2/php$ ./configure --with-xml 
--with-zlib --with-apxs=/usr/sbin/apxs --with-mysql
creating cache ./config.cache
... ( for sake of space, most ./configure output omitted ) ...
+--------------------------------------------------------------------+
|                        *** 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.                |
+--------------------------------------------------------------------+
| License:                                                           |
| This software is subject to the PHP License, available in this     |
| distribution in the file LICENSE.  By continuing this installation |
| process, you are bound by the terms of this license agreement.     |
| If you do not agree with the terms of this license, you must abort |
| the installation process at this point.                            |
+--------------------------------------------------------------------+

Thank you for using PHP.

localhost:~/tmp/apache_mod_php-6-2/php$



I need to get PHP and MySQL running by the end of the day or my boss is 
going to kill me.  If I just use this form of PHP (using built-in MySQL 
support), will I be able to re-compile the version with the appropriate 
/path/to/mysql at a later date?  Will the PHP code that I write for this 
(built-in MySQL) version of PHP4 work in a later version of PHP4 where I 
have indeed specified a directory?

Thanks to any who can help me -- and I apologize to those who are 
becoming annoyed with these questions!  Once I get this up and running I 
will do my best to never bother anyone again!


-- Erik




---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread92373@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php