PHP-MySQL problems

From: Date: Sat, 15 Apr 2006 22:27:36 +0000
Subject: PHP-MySQL problems
Groups: php.install 
Request: Send a blank email to php-install+get-17270@lists.php.net to get a copy of this message
Hello, I recently moved to a Linux Fedora Core 2 box, and am having some issues getting PHP to work with MySQL. The host setup PHP for me, but I needed to upgrade both MySQL and PHP in order to get the additional functionality of MySQL 4+, PHP 5. Here is the configure command I am using: './configure' '--host=i686-redhat-linux-gnu' '--build=i686-redhat-linux-gnu' '--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-db4=/usr' '--with-curl' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--with-gd' '--enable-gd-native-ttf' '--without-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-dom=shared,/usr' '--with-dom-xslt=/usr' '--with-dom-exslt=/usr' '--with-xmlrpc=shared' '--with-pcre-regex=/usr' '--with-zlib' '--with-layout=GNU' '--enable-bcmath' '--enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx' '--with-pear=/usr/share/pear' '--with-imap=shared' '--with-imap-ssl' '--with-kerberos' '--with-ldap=shared' '--with-pgsql=shared' '--with-snmp=shared,/usr' '--with-snmp=shared' '--enable-ucd-snmp-hack' '--with-unixODBC=shared,/usr' '--enable-memory-limit' '--enable-bcmath' '--enable-shmop' '--enable-calendar' '--enable-dbx' '--enable-dio' '--enable-mcal' '--enable-mbstring=shared' '--enable-mbstr-enc-trans' '--enable-mbregex' '--with-pic' '--enable-force-cgi-redirect' '--with-mysql=/usr' '--with-mysqli=/usr/bin/mysql_config' The problem is that MySQL and MySQLi show up in phpinfo(), but any PHP script that I call will error out with: *Fatal error*: Call to undefined function: mysql_connect() . I have mysql up and running, and can interact with it through the command line...just can't through PHP. Here is the information on MySQL and MySQLi from my phpinfo(). mysql MySQL Supportenabled Active Persistent Links 0 Active Links 0 Client API version 5.0.20 MYSQL_MODULE_TYPE external MYSQL_SOCKET /var/lib/mysql/mysql.sock MYSQL_INCLUDE -I/usr/include/mysql MYSQL_LIBS -L/usr/lib -lmysqlclient DirectiveLocal ValueMaster Value mysql.allow_persistentOnOn mysql.connect_timeout6060 mysql.default_host*no value**no value* mysql.default_password*no value**no value* mysql.default_port*no value**no value* mysql.default_socket/var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock mysql.default_user*no value**no value* mysql.max_linksUnlimitedUnlimited mysql.max_persistentUnlimitedUnlimited mysql.trace_modeOffOff mysqli MysqlI Supportenabled Client API version 5.0.20 MYSQLI_SOCKET /var/lib/mysql/mysql.sock DirectiveLocal ValueMaster Value mysqli.default_host*no value**no value* mysqli.default_port33063306 mysqli.default_pw*no value**no value* mysqli.default_socket*no value**no value* mysqli.default_user*no value**no value* mysqli.max_linksUnlimitedUnlimited mysqli.reconnectOffOff Any help would be much appreciated! -- - Steven Michaels steven.michaels@gmail.com http://www.HollowGame.com/

« previous php.install (#17270) next »