Re: mysql_connect problem rh7.3

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




It doesn't appear you have the PHP MySQL functions installed. When you run 
phpinfo() you should get something like:

mysql
MySQL Supportenabled
Active Persistent Links1
Active Links1
Client API version3.23.39
MYSQL_MODULE_TYPEbuiltin
MYSQL_SOCKET/var/lib/mysql/mysql.sock
MYSQL_INCLUDE
MYSQL_LIBS

The command I've always used for this during compile time is "--with-mysql" 
without any options. I'm not sure what "=shared, /tmp" does, but apparently 
it's not doing the trick.

-Micah


At 03:32 PM 11/2/2002 +0100, Wouter wrote:
>Hello,
>
>I've a rather complete php install on redhat 7.3, yet I cant't get php to 
>connect to mysql. I get:
>
>         Fatal error: Call to undefined function: mysql_connect() in
>         ...
>
>It seems that the necessary packages are installed:
>
>[root@axon ~]# rpm -qa | grep php
>php-4.1.2-7.3.4
>php-mysql-4.1.2-7.3.4
>asp2php-0.76.2-1
>php-devel-4.1.2-7.3.4
>php-ldap-4.1.2-7.3.4
>php-imap-4.1.2-7.3.4
>[root@axon ~]# rpm -qa | gi mysql
>mysql-3.23.49-3
>mysql-server-3.23.49-3
>php-mysql-4.1.2-7.3.4
>mysql-devel-3.23.49-3
>mysqlclient9-3.23.22-6
>
>
>I've attached the start of phpinfo() at the end...
>
>Any ideas? Maybe php.ini needs some change, but I can't figure which one..
>
>Thanks,
>Wouter
>
>
>PHP Version 4.1.2
>
>System Linux stripples.devel.redhat.com 2.4.18-11smp #1 SMP Thu Aug 15 
>06:41:59 EDT 2002 i686 unknown
>Build Date Aug 21 2002
>Configure Command  './configure' 'i386-redhat-linux' '--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' '--prefix=/usr' '--with-config-file-path=/etc' 
>'--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-mm' '--with-openssl' '--with-png' '--with-pspell' 
>'--with-regex=system' '--with-xml' '--with-expat-dir=/usr' '--with-zlib' 
>'--with-layout=GNU' '--enable-bcmath' '--enable-debugger' '--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-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-mbstring' '--enable-mbstr-enc-trans' '--with-apxs=/usr/sbin/apxs'
>Server API Apache
>Virtual Directory Support disabled
>Configuration File (php.ini) Path /etc/php.ini
>ZEND_DEBUG disabled
>Thread Safety disabled
>
>Zend logo This program makes use of the Zend Scripting Language Engine:
>Zend Engine v1.1.1, Copyright (c) 1998-2001 Zend Technologies
>
>PHP 4.0 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
>no value no value
>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
>On On
>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
>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.2
>
>wddx
>WDDX Support enabled
>WDDX Session Serializer enabled
>
>standard
>Regex Library System 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
>session.use_trans_sid
>1 1
>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
>
>pspell
>PSpell Support enabled
>
>posix
>Revision $Revision: 1.33.2.1 $
>
>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.6b [engine] 9 Jul 2001
>
>ncurses
>ncurses support enabled
>
>mbstring
>Multibyte (Japanese) Support enabled
>http input encoding translation enabled
>
>Directive Local Value Master Value
>mbstring.detect_order
>no value no value
>mbstring.http_input
>no value no value
>mbstring.http_output
>no value no value
>mbstring.internal_encoding
>no value no value
>mbstring.substitute_character
>no value no value
>
>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
>
>domxml
>DOM/XML enabled
>libxml Version 2.4.19
>XPath Support enabled
>XPointer Support enabled
>
>dbx
>dbx support enabled
>dbx version 1.0.0
>supported databases MySQL<br />ODBC<br />PostgreSQL<br />Microsoft SQL 
>Server<br />FrontBase
>
>dba
>DBA support enabled
>Supported handlers gdbm db3
>
>curl
>CURL support enabled
>CURL Information libcurl 7.9.5 (OpenSSL 0.9.6b) (ipv6 enabled)
>
>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.3
>Linked Version 1.1.3
>
>apache
>APACHE_INCLUDE
>APACHE_TARGET
>Apache Version Apache/1.3.23
>Apache Release 10323100
>Apache API Version 19990320
>Hostname:Port ...
>User/Group apache(48)/48
>Max Requests Per Child: 1000 - Keep Alive: on - Max Per Connection: 50
>Timeouts Connection: 300 - Keep-Alive: 15
>Server Root /etc/httpd
>Loaded Modules mod_ssl, mod_dav, mod_php4, mod_perl, mod_setenvif, mod_so, 
>mod_headers, mod_expires, mod_auth_db, mod_auth_anon, mod_auth, 
>mod_access, mod_rewrite, mod_alias, mod_userdir, mod_actions, mod_imap, 
>mod_asis, mod_cgi, mod_dir, mod_autoindex, mod_include, mod_info, 
>mod_status, mod_negotiation, mod_mime, mod_log_referer, mod_log_agent, 
>mod_log_config, mod_env, mod_vhost_alias, http_core
>
>Directive Local Value Master Value
>child_terminate
>0 0
>engine
>1 1
>last_modified
>0 0
>xbithack
>0 0
>
>
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
>

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux