Mailing-List: contact dev-help@httpd.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@httpd.apache.org
Reply-To: <bedouglas@earthlink.net>
From: "bruce" <bedouglas@earthlink.net>
To: <mysql@lists.mysql.com>,
	<php-general@lists.php.net>,
	<dev@httpd.apache.org>,
	<users@httpd.apache.org>
Subject: building php5.0 as an apache module, with mysqli functionality
Date: Sun, 18 Jul 2004 15:32:37 -0700
Message-ID: <003201c46d17$21d948e0$0301a8c0@Mesa.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Importance: Normal

hi...

this is cross posted to a number of lists as it seems to touch on all the
apps...

that said. i'm trying to build the PHP-5.0 version to run as an Apache mod.
i need to work with mysql to get the "mysqli" function.

i have rh8.0 linux. i'm using
-httpd-2.0.50 (built from both rpm/src)
-php-5.0 (building from source)
-MySQL-4.1.3 (beta) tried with src/rpms..
-MySQL-Server
-MySQL-devel
-MySQL-shared

my dir structure is pretty much the default....

i'm trying to build php using the following process

./configure
.make clean
make
make install


i'm trying to use the following "configure"

./configure  --with-apxs2=/usr/sbin/apxs --with-config-file-path=/etc --with
-mysql=/usr/include/mysql  --with-mysqli=/usr/local/mysql/bin/mysql_config -
-with-ldap --with-pgsql

./configure  --with-apxs2=/usr/sbin/apxs --with-config-file-path=/etc --with
-mysql=/usr/local/mysql/include  --with-mysqli=/usr/local/mysql/bin/mysql_co
nfig --with-ldap --with-pgsql

the issue i'm having is that i can't get make portion to work without
returning "multiple define" errors like

[root@lserver2 php-5.0.0]# make
/bin/sh /usr/src/php-5.0.0/libtool --silent --preserve-dup-deps --mode=link
gcc -g -O2 -prefer-pic  -rpath
/usr/src/php-5.0.0/libs -avoid-version -module -L/usr/local/mysql/lib  -R
/usr/local/mysql/lib ext/libxml/libxml.lo ext/ctype/ctype.lo
ext/dom/php_dom.lo ext/dom/attr.lo ext/dom/document.lo
ext/dom/domerrorhandler.lo ext/dom/domstringlist.lo ext/dom/domexception.lo
ext/dom/namelist.lo ext/dom/processinginstruction.lo ext/dom/cdatasection.lo
ext/dom/documentfragment.lo ext/dom/domimplementation.lo ext/dom/element.lo
ext/dom/node.lo ext/dom/string_extend.lo ext/dom/characterdata.lo
ext/dom/documenttype.lo ext/dom/domimplementationlist.lo ext/dom/entity.lo
ext/dom/nodelist.lo ext/dom/text.lo ext/dom/comment.lo
ext/dom/domconfiguration.lo ext/dom/domimplementationsource.lo
ext/dom/entityreference.lo ext/dom/notation.lo ext/dom/xpath.lo
ext/dom/dom_iterators.lo ext/dom/typeinfo.lo ext/dom/domerror.lo
ext/dom/domlocator.lo ext/dom/namednodemap.lo ext/dom/userdatahandler.lo
ext/iconv/iconv.lo ext/ldap/ldap.lo ext/mysql/php_mysql.lo
ext/mysqli/mysqli.lo ext/mysqli/mysqli_api.lo ext/mysqli/mysqli_prop.lo
ext/mysqli/mysqli_nonapi.lo ext/mysqli/mysqli_fe.lo
ext/mysqli/mysqli_report.lo ext/mysqli/mysqli_repl.lo
ext/pcre/pcrelib/maketables.lo ext/pcre/pcrelib/get.lo
ext/pcre/pcrelib/study.lo ext/pcre/pcrelib/pcre.lo ext/pcre/php_pcre.lo
ext/pgsql/pgsql.lo ext/posix/posix.lo ext/session/session.lo
ext/session/mod_files.lo ext/session/mod_mm.lo ext/session/mod_user.lo
ext/simplexml/simplexml.lo ext/spl/php_spl.lo ext/spl/spl_functions.lo
ext/spl/spl_engine.lo ext/spl/spl_iterators.lo ext/spl/spl_array.lo
ext/spl/spl_directory.lo ext/spl/spl_sxe.lo ext/sqlite/sqlite.lo
ext/sqlite/sess_sqlite.lo ext/sqlite/libsqlite/src/opcodes.lo
ext/sqlite/libsqlite/src/parse.lo ext/sqlite/libsqlite/src/encode.lo
ext/sqlite/libsqlite/src/auth.lo ext/sqlite/libsqlite/src/btree.lo
ext/sqlite/libsqlite/src/build.lo ext/sqlite/libsqlite/src/delete.lo
ext/sqlite/libsqlite/src/expr.lo ext/sqlite/libsqlite/src/func.lo
ext/sqlite/libsqlite/src/hash.lo ext/sqlite/libsqlite/src/insert.lo
ext/sqlite/libsqlite/src/main.lo ext/sqlite/libsqlite/src/os.lo
ext/sqlite/libsqlite/src/pager.lo ext/sqlite/libsqlite/src/printf.lo
ext/sqlite/libsqlite/src/random.lo ext/sqlite/libsqlite/src/select.lo
ext/sqlite/libsqlite/src/table.lo ext/sqlite/libsqlite/src/tokenize.lo
ext/sqlite/libsqlite/src/update.lo ext/sqlite/libsqlite/src/util.lo
ext/sqlite/libsqlite/src/vdbe.lo ext/sqlite/libsqlite/src/attach.lo
ext/sqlite/libsqlite/src/btree_rb.lo ext/sqlite/libsqlite/src/pragma.lo
ext/sqlite/libsqlite/src/vacuum.lo ext/sqlite/libsqlite/src/copy.lo
ext/sqlite/libsqlite/src/vdbeaux.lo ext/sqlite/libsqlite/src/date.lo
ext/sqlite/libsqlite/src/where.lo ext/sqlite/libsqlite/src/trigger.lo
regex/regcomp.lo regex/regexec.lo regex/regerror.lo regex/regfree.lo
ext/standard/array.lo ext/standard/base64.lo ext/standard/basic_functions.lo
ext/standard/browscap.lo ext/standard/crc32.lo ext/standard/crypt.lo
ext/standard/cyr_convert.lo ext/standard/datetime.lo ext/standard/dir.lo
ext/standard/dl.lo ext/standard/dns.lo ext/standard/exec.lo
ext/standard/file.lo ext/standard/filestat.lo ext/standard/flock_compat.lo
ext/standard/formatted_print.lo ext/standard/fsock.lo ext/standard/head.lo
ext/standard/html.lo ext/standard/image.lo ext/standard/info.lo
ext/standard/iptc.lo ext/standard/lcg.lo ext/standard/link.lo
ext/standard/mail.lo ext/standard/math.lo ext/standard/md5.lo
ext/standard/metaphone.lo ext/standard/microtime.lo ext/standard/pack.lo
ext/standard/pageinfo.lo ext/standard/parsedate.lo
ext/standard/quot_print.lo ext/standard/rand.lo ext/standard/reg.lo
ext/standard/soundex.lo ext/standard/string.lo ext/standard/scanf.lo
ext/standard/syslog.lo ext/standard/type.lo ext/standard/uniqid.lo
ext/standard/url.lo ext/standard/url_scanner.lo ext/standard/var.lo
ext/standard/versioning.lo ext/standard/assert.lo ext/standard/strnatcmp.lo
ext/standard/levenshtein.lo ext/standard/incomplete_class.lo
ext/standard/url_scanner_ex.lo ext/standard/ftp_fopen_wrapper.lo
ext/standard/http_fopen_wrapper.lo ext/standard/php_fopen_wrapper.lo
ext/standard/credits.lo ext/standard/css.lo ext/standard/var_unserializer.lo
ext/standard/ftok.lo ext/standard/sha1.lo ext/standard/user_filters.lo
ext/standard/uuencode.lo ext/standard/filters.lo ext/standard/proc_open.lo
ext/standard/sunfuncs.lo ext/standard/streamsfuncs.lo ext/standard/http.lo
ext/tokenizer/tokenizer.lo ext/xml/xml.lo ext/xml/compat.lo TSRM/TSRM.lo
TSRM/tsrm_strtok_r.lo TSRM/tsrm_virtual_cwd.lo main/main.lo main/snprintf.lo
main/spprintf.lo main/php_sprintf.lo main/safe_mode.lo
main/fopen_wrappers.lo main/alloca.lo main/php_scandir.lo main/php_ini.lo
main/SAPI.lo main/rfc1867.lo main/php_content_types.lo main/strlcpy.lo
main/strlcat.lo main/mergesort.lo main/reentrancy.lo main/php_variables.lo
main/php_ticks.lo main/network.lo main/php_open_temporary_file.lo
main/php_logos.lo main/output.lo main/streams/streams.lo
main/streams/cast.lo main/streams/memory.lo main/streams/filter.lo
main/streams/plain_wrapper.lo main/streams/userspace.lo
main/streams/transports.lo main/streams/xp_socket.lo main/streams/mmap.lo
Zend/zend_language_parser.lo Zend/zend_language_scanner.lo
Zend/zend_ini_parser.lo Zend/zend_ini_scanner.lo Zend/zend_alloc.lo
Zend/zend_compile.lo Zend/zend_constants.lo Zend/zend_dynamic_array.lo
Zend/zend_execute_API.lo Zend/zend_highlight.lo Zend/zend_llist.lo
Zend/zend_opcode.lo Zend/zend_operators.lo Zend/zend_ptr_stack.lo
Zend/zend_stack.lo Zend/zend_variables.lo Zend/zend.lo Zend/zend_API.lo
Zend/zend_extensions.lo Zend/zend_hash.lo Zend/zend_list.lo
Zend/zend_indent.lo Zend/zend_builtin_functions.lo Zend/zend_sprintf.lo
Zend/zend_ini.lo Zend/zend_qsort.lo Zend/zend_multibyte.lo
Zend/zend_ts_hash.lo Zend/zend_stream.lo Zend/zend_iterators.lo
Zend/zend_interfaces.lo Zend/zend_exceptions.lo Zend/zend_objects.lo
Zend/zend_object_handlers.lo Zend/zend_objects_API.lo Zend/zend_mm.lo
Zend/zend_default_classes.lo Zend/zend_reflection_api.lo
Zend/zend_execute.lo sapi/apache2handler/mod_php5.lo
sapi/apache2handler/sapi_apache2.lo sapi/apache2handler/apache_config.lo
sapi/apache2handler/php_functions.lo
main/internal_functions.lo -lcrypt -lcrypt -lpq -lmysqlclient -lldap -llber 
-lresolv -lm -ldl -lnsl -lxml2 -lz -lm -lxml2 -lz -lm -lmysqlclient -lz -lcr
ypt -lnsl -lm -lnss_files -lnss_dns -lresolv -lnss_files -lnss_dns -lresolv 
-lxml2 -lz -lm -lcrypt -lxml2 -lz -lm -lcrypt  -o libphp5.la
/usr/lib/mysql/libmysqlclient.a(libmysql.o)(.data+0x0): multiple definition
of `net_buffer_length'
/usr/lib/mysql/libmysqlclient.a(libmysql.o)(.data+0x0): first defined here
/usr/lib/mysql/libmysqlclient.a(libmysql.o)(.data+0x4): multiple definition
of `max_allowed_packet'
/usr/lib/mysql/libmysqlclient.a(libmysql.o)(.data+0x4): first defined here
/usr/lib/mysql/libmysqlclient.a(libmysql.o)(.data+0x8): multiple definition
of `net_read_timeout'
/usr/lib/mysql/libmysqlclient.a(libmysql.o)(.data+0x8): first defined here
/usr/lib/mysql/libmysqlclient.a(libmysql.o)(.data+0xc): multiple definition
of `net_write_timeout'
/usr/lib/mysql/libmysqlclient.a(libmysql.o)(.data+0xc): first defined here
/usr/lib/mysql/libmysqlclient.a(libmysql.o): In function
`mysql_server_init':
libmysql.o(.text+0x0): multiple definition of `mysql_server_init'
/usr/lib/mysql/libmysqlclient.a(libmysql.o)(.text+0x0): first defined here
/usr/lib/mysql/libmysqlclient.a(libmysql.o): In function `mysql_debug':
libmysql.o(.text+0x1d0): multiple definition of `mysql_debug'
/usr/lib/mysql/libmysqlclient.a(libmysql.o)(.text+0x1d0): first defined here
/usr/lib/mysql/libmysqlclient.a(libmysql.o): In function `mysql_server_end':
libmysql.o(.text+0xf0): multiple definition of `mysql_server_end'
/usr/lib/mysql/libmysqlclient.a(libmysql.o)(.text+0xf0): first defined here
/usr/lib/mysql/libmysqlclient.a(libmysql.o): In function `mysql_thread_end':
libmysql.o(.text+0x150): multiple definition of `mysql_thread_end'
/usr/lib/mysql/libmysqlclient.a(libmysql.o)(.text+0x150): first defined here
/usr/lib/mysql/libmysqlclient.a(libmysql.o): In function
`mysql_get_parameters':
libmysql.o(.text+0x130): multiple definition of `mysql_get_parameters'
...
...
...


the issue of the multiple defines appears to point to some collision between
either the same lib being used multiple times (perhaps from different
versions that haven't been properly cleaned up..) or from the same
function/item being multiply defined by different apps.. (i seriously doubt
this...)

a review of google indicates that this issue has occured from/between
numerous people with no apparent real solution.

removing "--with-apxs2..." works... which is what i would have expected if i
didn't tie into the apache mods...

any ideas/comments/thoughts/etc, would be appreciated, particularly if
you've run across this issue and managed to solve it!!!!


thanks

-bruce