PDA

Archiv verlassen und diese Seite im Standarddesign anzeigen : PHP erkennt keine MySQL-Befehle



Bibiman
17.12.02, 10:39
Ich habe gerade alles frisch installiert und nun kennt PHP keine MySQL-Funktionen mehr. In der php.ini hab ich "extension=mysql.so" geladen. Muss ich sonst noch was tun damit es geht?

PigPen|tuX
17.12.02, 10:54
huhu,

ein paar mehr angaben wären nicht schlecht, Distri, Versionen der installierten Proggies,
error-log und ähnliches :(

mfg.
thom

Bibiman
17.12.02, 11:08
Als Error kommt das (oder so ähnlich) "Fatal error: Call to undefined function: mysql_pconnect() "

RedHat 8.0, Apache 2.0
php version 4.2.2
und das sagt phpinfo()

System Linux daffy.perf.redhat.com 2.4.18-11smp #1 SMP Thu Aug 15 06:41:59 EDT 2002 i686 i686 i386 GNU/Linux
Build Date Sep 3 2002 05:25:09
Configure Command './configure' '--host=i686-pc-linux-gnu' '--build=i686-pc-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' '--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-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
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
Off Off
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.4


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=fakeentr y a=href,area=href,frame=src,input=src,form=fakeentr y


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.6b [engine] 9 Jul 2001


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.4.23
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.6b) (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


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 20025


Apache 2.0
Additional Modules
sysvshm
sysvsem


Environment
Variable Value
HOSTNAME dhcppc2
TERM linux
SHELL /bin/bash
HISTSIZE 1000
USER root
LS_COLORS no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd =40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;4 1:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.b tm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar= 01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01 ;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.b z2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio= 01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01 ;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:
USERNAME root
MAIL /var/spool/mail/root
PATH /usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin
INPUTRC /etc/inputrc
PWD /root
LANG de_AT.UTF-8
SHLVL 1
HOME /root
BASH_ENV /root/.bashrc
LOGNAME root
LESSOPEN |/usr/bin/lesspipe.sh %s
G_BROKEN_FILENAMES 1
_ /usr/sbin/httpd


PHP Variables
Variable Value
_COOKIE["bblastvisit"] 1030981969
_COOKIE["bbuserid"] 1
_COOKIE["bbpassword"] 900150983cd24fb0d6963f7d28e17f72
_SERVER["UNIQUE_ID"] jcgvCsCoAAIAAAM3YpgAAAAC
_SERVER["HTTP_ACCEPT"] image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*
_SERVER["HTTP_ACCEPT_LANGUAGE"] de-at
_SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate
_SERVER["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
_SERVER["HTTP_HOST"] 192.168.0.2
_SERVER["HTTP_CONNECTION"] Keep-Alive
_SERVER["HTTP_COOKIE"] bblastvisit=1030981969; bbuserid=1; bbpassword=900150983cd24fb0d6963f7d28e17f72
_SERVER["PATH"] /usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin
_SERVER["SERVER_SIGNATURE"] <address>Apache/2.0.40 Server at 192.168.0.2 Port 80</address>

_SERVER["SERVER_SOFTWARE"] Apache/2.0.40 (Red Hat Linux)
_SERVER["SERVER_NAME"] 192.168.0.2
_SERVER["SERVER_ADDR"] 192.168.0.2
_SERVER["SERVER_PORT"] 80
_SERVER["REMOTE_ADDR"] 192.168.0.5
_SERVER["DOCUMENT_ROOT"] /var/www/html
_SERVER["SERVER_ADMIN"] bibiman@gmx.net
_SERVER["SCRIPT_FILENAME"] /var/www/html/test.php
_SERVER["REMOTE_PORT"] 2210
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["REQUEST_METHOD"] GET
_SERVER["QUERY_STRING"]
_SERVER["REQUEST_URI"] /test.php
_SERVER["SCRIPT_NAME"] /test.php
_SERVER["PHP_SELF"] /test.php
_SERVER["argv"] Array
(
)


_SERVER["argc"] 0
_ENV["HOSTNAME"] dhcppc2
_ENV["TERM"] linux
_ENV["SHELL"] /bin/bash
_ENV["HISTSIZE"] 1000
_ENV["USER"] root
_ENV["LS_COLORS"] no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd =40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;4 1:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.b tm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar= 01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01 ;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.b z2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio= 01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01 ;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:
_ENV["USERNAME"] root
_ENV["MAIL"] /var/spool/mail/root
_ENV["PATH"] /usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin
_ENV["INPUTRC"] /etc/inputrc
_ENV["PWD"] /root
_ENV["LANG"] de_AT.UTF-8
_ENV["SHLVL"] 1
_ENV["HOME"] /root
_ENV["BASH_ENV"] /root/.bashrc
_ENV["LOGNAME"] root
_ENV["LESSOPEN"] |/usr/bin/lesspipe.sh %s
_ENV["G_BROKEN_FILENAMES"] 1
_ENV["_"] /usr/sbin/httpd

Bauchi
17.12.02, 11:12
wie wärs wenn du das rpm php-mysql nachziehst ... ist so ne redhat angewohnheit alle modules einzeln zu ver rpm'en :-)

PigPen|tuX
17.12.02, 11:16
huhu,

nun hast du den apachen selbst kompliert oder die rpms genommen ?,

ich vermisse in der apache-config so was in dieser Form -> --prefix=/usr/local/mysql/xxxxxx --localstatedir=/var/mysql/data

lt phpinfo supportet dein Apache mysql, aber vielleicht kennt er nicht den Weg zum DB-Server ?

mfg.
thom

ps: snapszahl *einenausgeb* :D -> habe zu lange geschrieben, bauchi war schneller ;)

comrad
17.12.02, 12:21
du musst php mit mysql support kompilieren oder das php-modul mit mysql support installierne. php kann von haus aus kein mysql.

hautverduenner
17.12.02, 17:29
Original geschrieben von Bauchi
wie wärs wenn du das rpm php-mysql nachziehst ... ist so ne redhat angewohnheit alle modules einzeln zu ver rpm'en :-)

falls du das aber getan haben solltest, alles nochma runterschmeißen und dann mysql unbedingt VOR php installieren. das von bauchi erwähnte paket nicht vergessen

Bibiman
17.12.02, 18:07
Ok danke vielmals, dieses Paket hat gefehlt :)