PHP Installation problem - database type not supported

[bruceleung2000]

Hello,
I have 2 problems which I still cannot solve after reading the documentation in this site :
1) Originally, I wrote a test program (php) to call mysql_connect(). I found a suggestion from PHP documentation from

http://www.php.com

and change it to mysql_real_connect().
I still get the error message :
*** Fatal error: Call to undefined function: mysql_real_connect() in /var/

http://www/html/demo/board.php

on line 37 ***

I am stuck now and don't know how to carry on, please help !!!

2) When I tried to install phpBB2 by

http://localhost/phpBB2/install/install.php

and fill in all questons, I got the error msg even I try ALL the database types from mysql 3,4 and MS access from the list of install.php :
*** An error has occurred during installation
The PHP configuration on your server doesn't support the database type that you chose ***

3) However, when I recompile PHP with :
./configure --with-apxs2 , --with-mysql and --enable-track-vars OPTIONS
then make, and make install successfully.

I still got the same errors, could you tell whether I missed my steps or options for installation of PHP ???

Regards,
BL

 

[sleipnir214]

1. mysql_real_connect() is only available in PHP 5.0.

2. Does the PHP function phpinfo() report that MySQL functionality is available?



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[bruceleung2000]

Hello Sleipnir214,
Neither mqsql_connect() nor mqsel_real_connect() work for my environment.
Weh I recompiled PHP --with-mysql option, I got the following compilation results :
1) =nothing => it is using the default mysql and no compilation errro, but the runtime error as stated in my previous email (1st question in this thread)
BUT
2) =/usr, =/usr/mysql, OR =/path/to/mysql => the error is "cannot find my SQL Header file under /usr ... OR /path/to/mysql ... etc

My playform environment : X86 Red Hat linux 9.0, httpd-2.0.28, mysql 4.0, php 4.3.4

The following is output from phpinof()
========================================

PHP Version 4.2.2

System Linux sylvester.devel.redhat.com 2.4.20-2.41smp #1 SMP Sun Feb 9 09:29:47 EST 2003 i686 athlon i386 GNU/Linux
Build Date Feb 25 2003 09:44:31
Configure Command './configure' '--host=i386-redhat-linux' '--build=i386-redhat-linux' '--target=i386-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--cache-file=../config.cache' '--with-config-file-path=/etc' '--with-config-file-scan-dir=/etc/php.d' '--enable-force-cgi-redirect' '--disable-debug' '--enable-pic' '--disable-rpath' '--enable-inline-optimization' '--with-bz2' '--with-db3' '--with-curl' '--with-dom=/usr' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--with-gd' '--enable-gd-native-ttf' '--with-ttf' '--with-gdbm' '--with-gettext' '--with-ncurses' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-png' '--with-pspell' '--with-regex=system' '--with-xml' '--with-expat-dir=/usr' '--with-zlib' '--with-layout=GNU' '--enable-bcmath' '--enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-safe-mode' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-discard-path' '--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx' '--without-oci8' '--with-pear=/usr/share/pear' '--with-imap=shared' '--with-imap-ssl' '--with-kerberos=/usr/kerberos' '--with-ldap=shared' '--with-mysql=shared,/usr' '--with-pgsql=shared' '--with-snmp=shared,/usr' '--with-snmp=shared' '--enable-ucd-snmp-hack' '--with-unixODBC=shared' '--enable-memory-limit' '--enable-bcmath' '--enable-shmop' '--enable-versioning' '--enable-calendar' '--enable-dbx' '--enable-dio' '--enable-mcal' '--with-apxs2=/usr/sbin/apxs'
Server API Apache 2.0 Filter
Virtual Directory Support disabled
Configuration File (php.ini) Path /etc/php.ini
Scan this dir for additional .ini files /etc/php.d
additional .ini files parsed /etc/php.d/imap.ini,
/etc/php.d/ldap.ini

Debug Build no
Thread Safety disabled

This program makes use of the Zend Scripting Language Engine:
Zend Engine v1.2.0, Copyright (c) 1998-2002 Zend Technologies



--------------------------------------------------------------------------------

PHP 4 Credits

--------------------------------------------------------------------------------

Configuration
PHP Core
Directive Local Value Master Value
allow_call_time_pass_reference
On On
allow_url_fopen
1 1
always_populate_raw_post_data
0 0
arg_separator.input
& &
arg_separator.output
& &
asp_tags
Off Off
auto_append_file
no value no value
auto_prepend_file
no value no value
browscap
no value no value
default_charset
no value no value
default_mimetype
text/html text/html
define_syslog_variables
Off Off
disable_functions
no value no value
display_errors
On On
display_startup_errors
Off Off
doc_root
no value no value
enable_dl
On On
error_append_string
no value no value
error_log
no value no value
error_prepend_string
no value no value
error_reporting
2039 2039
expose_php
On On
extension_dir
/usr/lib/php4 /usr/lib/php4
file_uploads
1 1
gpc_order
GPC GPC
highlight.bg
#FFFFFF #FFFFFF
highlight.comment
#FF9900 #FF9900
highlight.default
#0000CC #0000CC
highlight.html
#000000 #000000
highlight.keyword
#006600 #006600
highlight.string
#CC0000 #CC0000
html_errors
On On
ignore_user_abort
Off Off
implicit_flush
Off Off
include_path
.:/usr/share/pear .:/usr/share/pear
log_errors
Off Off
magic_quotes_gpc
On On
magic_quotes_runtime
Off Off
magic_quotes_sybase
Off Off
max_execution_time
30 30
memory_limit
8M 8M
open_basedir
no value no value
output_buffering
no value no value
output_handler
no value no value
post_max_size
8M 8M
precision
14 14
register_argc_argv
On On
register_globals
Off Off
safe_mode
Off Off
safe_mode_exec_dir
no value no value
safe_mode_gid
Off Off
safe_mode_include_dir
no value no value
sendmail_from
me@localhost.com me@localhost.com
sendmail_path
/usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i
short_open_tag
On On
SMTP
localhost localhost
sql.safe_mode
Off Off
track_errors
Off Off
unserialize_callback_func
no value no value
upload_max_filesize
2M 2M
upload_tmp_dir
no value no value
user_dir
no value no value
variables_order
EGPCS EGPCS
xmlrpc_error_number
0 0
xmlrpc_errors
Off Off
y2k_compliance
Off Off


yp
YP Support enabled


xml
XML Support active
XML Namespace Support active
EXPAT Version expat_1.95.5


wddx
WDDX Support enabled
WDDX Session Serializer enabled


standard
Regex Library Bundled library enabled
Dynamic Library Support enabled
Path to sendmail /usr/sbin/sendmail -t -i

Directive Local Value Master Value
assert.active
1 1
assert.bail
0 0
assert.callback
no value no value
assert.quiet_eval
0 0
assert.warning
1 1
safe_mode_allowed_env_vars
PHP_ PHP_
safe_mode_protected_env_vars
LD_LIBRARY_PATH LD_LIBRARY_PATH
url_rewriter.tags
a=href,area=href,frame=src,input=src,form=fakeentry a=href,area=href,frame=src,input=src,form=fakeentry


sockets
Sockets Support enabled


shmop
shmop support enabled


session
Session Support enabled

Directive Local Value Master Value
session.auto_start
Off Off
session.cache_expire
180 180
session.cache_limiter
nocache nocache
session.cookie_domain
no value no value
session.cookie_lifetime
0 0
session.cookie_path
/ /
session.cookie_secure
Off Off
session.entropy_file
no value no value
session.entropy_length
0 0
session.gc_maxlifetime
1440 1440
session.gc_probability
1 1
session.name
PHPSESSID PHPSESSID
session.referer_check
no value no value
session.save_handler
files files
session.save_path
/tmp /tmp
session.serialize_handler
php php
session.use_cookies
On On
session.use_trans_sid
1 1


pspell
PSpell Support enabled


posix
Revision $Revision: 1.42.2.2 $


pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 3.4 22-Aug-2000


openssl
OpenSSL support enabled
OpenSSL Version OpenSSL 0.9.7a Feb 19 2003


iconv
iconv support enabled

Directive Local Value Master Value
iconv.input_encoding
ISO-8859-1 ISO-8859-1
iconv.internal_encoding
ISO-8859-1 ISO-8859-1
iconv.output_encoding
ISO-8859-1 ISO-8859-1


gmp
gmp support enabled


gettext
GetText Support enabled


gd
GD Support enabled
GD Version 1.6.2 or higher
FreeType Support enabled
FreeType Linkage with freetype
JPG Support enabled
PNG Support enabled
WBMP Support enabled


ftp
FTP support enabled


exif
EXIF Support enabled
EXIF Version 1.2
Supported EXIF Version 02100
Supported filetypes JPEG,TIFF


domxml
DOM/XML enabled
libxml Version 2.5.4
HTML Support enabled
XPath Support enabled
XPointer Support enabled


dio
dio support enabled


dbx
dbx support enabled
dbx version 1.0.0
supported databases MySQL
ODBC
PostgreSQL
Microsoft SQL Server
FrontBase
Oracle 8 (not really)
Sybase-CT


dba
DBA support enabled
Supported handlers gdbm db3


curl
CURL support enabled
CURL Information libcurl 7.9.8 (OpenSSL 0.9.7a) (ipv6 enabled)


ctype
ctype functions enabled (experimental)


calendar
Calendar support enabled


bz2
BZip2 Support Enabled
BZip2 Version 1.0.2, 30-Dec-2001


bcmath
BCMath support enabled


zlib
ZLib Support enabled
'zlib:' fopen wrapper enabled
Compiled Version 1.1.4
Linked Version 1.1.4

Directive Local Value Master Value
zlib.output_compression
Off Off


imap
IMAP Support enabled
IMAP c-Client Version 2001
SSL Support enabled
Kerberos Support enabled


ldap
LDAP Support enabled
RCS Version $Id: ldap.c,v 1.116.2.1 2002/04/23 18:59:57 derick Exp $
Total Links 0/unlimited
API Version 2004
Vendor Name OpenLDAP
Vendor Version 20026


Apache 2.0
Additional Modules
sysvshm
sysvsem


Environment
Variable Value
CONSOLE /dev/console
TERM linux
INIT_VERSION sysvinit-2.84
PATH /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
RUNLEVEL 5
runlevel 5
PWD /
LANG en_US.UTF-8
PREVLEVEL N
previous N
HOME /
SHLVL 2
_ /sbin/initlog


PHP Variables
Variable Value
_SERVER["UNIQUE_ID"] JumOqn8AAAEAAANWbLkAAAAD
_SERVER["HTTP_ACCEPT"] image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/msword, application/vnd.ms-powerpoint, */*
_SERVER["HTTP_ACCEPT_LANGUAGE"] zh-tw,zh-hk;q=0.5
_SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate
_SERVER["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 6.0; Windows 98; Win 9x 4.90)
_SERVER["HTTP_HOST"] 192.168.1.2
_SERVER["HTTP_CONNECTION"] Keep-Alive
_SERVER["PATH"] /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
_SERVER["SERVER_SIGNATURE"] <address>Apache/2.0.40 Server at all-delight Port 80</address>

_SERVER["SERVER_SOFTWARE"] Apache/2.0.40 (Red Hat Linux)
_SERVER["SERVER_NAME"] all-delight
_SERVER["SERVER_ADDR"] 192.168.1.2
_SERVER["SERVER_PORT"] 80
_SERVER["REMOTE_ADDR"] 192.168.1.4
_SERVER["DOCUMENT_ROOT"] /var/

http://www/html

_SERVER["SERVER_ADMIN"] bruceleung2000@hotmail.com
_SERVER["SCRIPT_FILENAME"] /var/

http://www/html/demo/phpinfo.php

_SERVER["REMOTE_PORT"] 1210
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["REQUEST_METHOD"] GET
_SERVER["QUERY_STRING"]
_SERVER["REQUEST_URI"] /demo/phpinfo.php
_SERVER["SCRIPT_NAME"] /demo/phpinfo.php
_SERVER["PHP_SELF"] /demo/phpinfo.php
_SERVER["argv"] Array
(
)


_SERVER["argc"] 0
_ENV["CONSOLE"] /dev/console
_ENV["TERM"] linux
_ENV["INIT_VERSION"] sysvinit-2.84
_ENV["PATH"] /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
_ENV["RUNLEVEL"] 5
_ENV["runlevel"] 5
_ENV["PWD"] /
_ENV["LANG"] en_US.UTF-8
_ENV["PREVLEVEL"] N
_ENV["previous"] N
_ENV["HOME"] /
_ENV["SHLVL"] 2
_ENV["_"] /sbin/initlog


PHP License
This program is free software; you can redistribute it and/or modify it under the terms of the PHP License as published by the PHP Group and included in the distribution in the file: LICENSE

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

If you did not receive a copy of the PHP license, or have any questions about PHP licensing, please contact license@php.net.

Regards,
BL

 

[sleipnir214]

I've had success on several systems with using "--with-mysql=/usr".


According to the excessive phpinfo() output you posted, you've compiled PHP to use the MySQL libraries in shared mode. This may be because PHP's compilation system can't find the MySQL client libraries.


From where did you get MySQL, what parts of MySQL did you install, and from where did you get the install?

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[bruceleung2000]

Hello Sleipnir214,
I got mysql package right from

http://www.mysql.com,

do you mean I should get it for non-shared package.
Please advise any specific bookmark page I should go from

http://www.mysql.com

to get a version for my red hat linux 9.x.

Thanks again !
BL

 

[sleipnir214]

Package"? You installed from RPMs found at

http://www.msql.com?

Which packages, exactly, did you install? PHP's not going to be able to implement MySQL connectivity unless the MySQL libraries and header files are installed on your system.

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[bruceleung2000]

Hello Sleipnir214,
I have installed as follows :
1) rpm -ivh MySQL-server-4.0.18-0.i386.rpt
2) MySQL-client-*.rpm
3) MySQL-shared-*.rpm

a) Am I missing some or how to do it ?
b) Do I install something else instead of shared.rpm ?

Please enlighten me again !

BL

 

[sleipnir214]

You're not going to be able to compile the functionality into PHP without libraries and headers.

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[bruceleung2000]

Hello Sleipnir214,
This time, I reinstalled MySQL RPM as follows :
1) MySQL-server-*.rpm
2) Max-*.rpm
3) client-*.rpm
4) devel-*.rpm
5) shared-compat*.rpm
6) embedded-*.rpm

Then I recompiled PHP with configure --with-mysql=/usr
There is NO "cannot find my SQL Header file under ..." error now.
However, it still does NOT work for neither mysql_real_server NOT mysql_server.

 

[bruceleung2000]

Sorry,
Even though ./configure has NO error, but when I type make, it shows the following compilation error as follows :
============
# make
/bin/sh /usr/local/php-4.3.4/libtool --silent --preserve-dup-deps --mode=compile
gcc -Imain/ -I/usr/local/php-4.3.4/main/ -DPHP_ATOM_INC -I/usr/local/php-4.3.4
/include -I/usr/local/php-4.3.4/main -I/usr/local/php-4.3.4 -I/usr/local/php-4.3
.4/Zend -I/usr/include/mysql -I/usr/local/php-4.3.4/ext/xml/expat -I/usr/local/
php-4.3.4/TSRM -g -O2 -prefer-pic -c main/internal_functions.c -o main/interna
l_functions.lo
/bin/sh /usr/local/php-4.3.4/libtool --silent --preserve-dup-deps --mode=link gc
c -g -O2 -prefer-pic -rpath /usr/local/php-4.3.4/libs -avoid-version -module
ext/ctype/ctype.lo ext/mysql/php_mysql.lo ext/overload/overload.lo ext/pcre/pcre
lib/maketables.lo ext/pcre/pcrelib/get.lo ext/pcre/pcrelib/study.lo ext/pcre/pcr
elib/pcre.lo ext/pcre/php_pcre.lo ext/posix/posix.lo ext/session/session.lo ext/
session/mod_files.lo ext/session/mod_mm.lo ext/session/mod_user.lo regex/regcomp
.lo regex/regexec.lo regex/regerror.lo regex/regfree.lo ext/standard/array.lo ex
t/standard/base64.lo ext/standard/basic_functions.lo ext/standard/browscap.lo ex
t/standard/crc32.lo ext/standard/crypt.lo ext/standard/cyr_convert.lo ext/standa
rd/datetime.lo ext/standard/dir.lo ext/standard/dl.lo ext/standard/dns.lo ext/st
andard/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/hea
d.lo ext/standard/html.lo ext/standard/image.lo ext/standard/info.lo ext/standar
d/iptc.lo ext/standard/lcg.lo ext/standard/link.lo ext/standard/mail.lo ext/stan
dard/math.lo ext/standard/md5.lo ext/standard/metaphone.lo ext/standard/microtim
e.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/so
undex.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_sc
anner.lo ext/standard/var.lo ext/standard/versioning.lo ext/standard/assert.lo e
xt/standard/strnatcmp.lo ext/standard/levenshtein.lo ext/standard/incomplete_cla
ss.lo ext/standard/url_scanner_ex.lo ext/standard/ftp_fopen_wrapper.lo ext/stand
ard/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 ex
t/standard/aggregation.lo ext/standard/sha1.lo ext/tokenizer/tokenizer.lo ext/xm
l/xml.lo ext/xml/expat/xmlparse.lo ext/xml/expat/xmlrole.lo ext/xml/expat/xmltok
.lo TSRM/TSRM.lo TSRM/tsrm_strtok_r.lo TSRM/tsrm_virtual_cwd.lo main/main.lo mai
n/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/merge
sort.lo main/reentrancy.lo main/php_variables.lo main/php_ticks.lo main/streams.
lo main/network.lo main/php_open_temporary_file.lo main/php_logos.lo main/output
.lo main/memory_streams.lo main/user_streams.lo Zend/zend_language_parser.lo Zen
d/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_arr
ay.lo Zend/zend_execute_API.lo Zend/zend_highlight.lo Zend/zend_llist.lo Zend/ze
nd_opcode.lo Zend/zend_operators.lo Zend/zend_ptr_stack.lo Zend/zend_stack.lo Ze
nd/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.l
o Zend/zend_sprintf.lo Zend/zend_ini.lo Zend/zend_qsort.lo Zend/zend_multibyte.l
o Zend/zend_execute.lo sapi/apache2handler/sapi_apache2.lo sapi/apache2handler/a
pache_config.lo sapi/apache2handler/php_functions.lo main/internal_functions.lo
-lcrypt -lcrypt -lmysqlclient -lresolv -lm -ldl -lnsl -lcrypt -lcrypt -o libphp
4.la
/bin/sh /usr/local/php-4.3.4/libtool --silent --preserve-dup-deps --mode=compile
gcc -Imain/ -I/usr/local/php-4.3.4/main/ -DPHP_ATOM_INC -I/usr/local/php-4.3.4
/include -I/usr/local/php-4.3.4/main -I/usr/local/php-4.3.4 -I/usr/local/php-4.3
.4/Zend -I/usr/include/mysql -I/usr/local/php-4.3.4/ext/xml/expat -I/usr/local/
php-4.3.4/TSRM -g -O2 -prefer-pic -c main/internal_functions_cli.c -o main/int
ernal_functions_cli.lo
/bin/sh /usr/local/php-4.3.4/libtool --silent --preserve-dup-deps --mode=link gc
c -export-dynamic -g -O2 ext/ctype/ctype.lo ext/mysql/php_mysql.lo ext/overl
oad/overload.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/posix/posix.l
o ext/session/session.lo ext/session/mod_files.lo ext/session/mod_mm.lo ext/sess
ion/mod_user.lo regex/regcomp.lo regex/regexec.lo regex/regerror.lo regex/regfre
e.lo ext/standard/array.lo ext/standard/base64.lo ext/standard/basic_functions.l
o ext/standard/browscap.lo ext/standard/crc32.lo ext/standard/crypt.lo ext/stand
ard/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/fi
lestat.lo ext/standard/flock_compat.lo ext/standard/formatted_print.lo ext/stand
ard/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/metap
hone.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/st
andard/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/standa
rd/url.lo ext/standard/url_scanner.lo ext/standard/var.lo ext/standard/versionin
g.lo ext/standard/assert.lo ext/standard/strnatcmp.lo ext/standard/levenshtein.l
o ext/standard/incomplete_class.lo ext/standard/url_scanner_ex.lo ext/standard/f
tp_fopen_wrapper.lo ext/standard/http_fopen_wrapper.lo ext/standard/php_fopen_wr
apper.lo ext/standard/credits.lo ext/standard/css.lo ext/standard/var_unserializ
er.lo ext/standard/ftok.lo ext/standard/aggregation.lo ext/standard/sha1.lo ext/
tokenizer/tokenizer.lo ext/xml/xml.lo ext/xml/expat/xmlparse.lo ext/xml/expat/xm
lrole.lo ext/xml/expat/xmltok.lo TSRM/TSRM.lo TSRM/tsrm_strtok_r.lo TSRM/tsrm_vi
rtual_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 ma
in/php_ticks.lo main/streams.lo main/network.lo main/php_open_temporary_file.lo
main/php_logos.lo main/output.lo main/memory_streams.lo main/user_streams.lo Zen
d/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_const
ants.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_s
tack.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_q
sort.lo Zend/zend_multibyte.lo Zend/zend_execute.lo sapi/cli/php_cli.lo sapi/cli
/getopt.lo main/internal_functions_cli.lo -lcrypt -lcrypt -lmysqlclient -lresolv
-lm -ldl -lnsl -lcrypt -lcrypt -o sapi/cli/php
ext/mysql/php_mysql.lo(.text+0x22c4): In function `zif_mysql_create_db':
/usr/local/php-4.3.4/ext/mysql/php_mysql.c:1158: undefined reference to `mysql_c
reate_db'
ext/mysql/php_mysql.lo(.text+0x24fb): In function `zif_mysql_drop_db':
/usr/local/php-4.3.4/ext/mysql/php_mysql.c:1200: undefined reference to `mysql_d
rop_db'
collect2: ld returned 1 exit status
make: *** [sapi/cli/php] Error 1
#

 

[sleipnir214]

How did you invoke configure?

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[bruceleung2000]

Hello,
Under /usr/local/php-4.3.4, I run the following command :

./configure --with-apxs2=/usr/local/apache/bin/apxs --with-config-file-path=/usr/local/apache/conf --enable-versioning --with-mysql=/usr/local --enable-ftp --with-gd --enable-bcmath --disable-debug --enable-memory-limit=yes --enable-track-vars --with-jpeg-dir=/usr/lib

then make ; then make install
...
This time, the compilation looks ok, but the execution to mysql_real_connect() and mysql_connect() still NOT ok.

Quite frustrated !

BL

 

[sleipnir214]

Try running configure with --with-mysql=/usr

That has always worked for me.

Want the best answers? Ask the best questions!

TANSTAAFL!!