Discuz! 官方站

 找回密码
 立即注册

QQ登录

只需一步,快速开始

搜索
查看: 91323|回复: 13

郁闷的问题 PHP5就是不支持MYSQL 找了一天了!

[复制链接]
发表于 2007-7-18 18:45:40 | 显示全部楼层 |阅读模式
几乎把网上的方法都用到了,就是不行。不知道是什么原因。
CMD可以正常登陆 MYSQL已经启动。
PHP探针也可以用。 附件里有我的INI文件,希望高手给看看!
具体是环境是 2003 IIS6 PHP5.23 MYSQL5.23 ZOND3.26
phpMyAdmin - 错误Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly.

PHP探针
PHP Version 5.2.3


System  Windows NT WLXX-101 5.2 build 3790  
Build Date  May 31 2007 09:36:39  
Configure Command  cscript /nologo configure.js "--enable-snapshot-build" "--with-gd=shared"  
Server API  ISAPI  
Virtual Directory Support  enabled  
Configuration File (php.ini) Path  C:\WINDOWS  
Loaded Configuration File  C:\PHP\php.ini  
PHP API  20041225  
PHP Extension  20060613  
Zend Extension  220060519  
Debug Build  no  
Thread Safety  enabled  
Zend Memory Manager  enabled  
IPv6 Support  enabled  
Registered PHP Streams  php, file, data, http, ftp, compress.zlib  
Registered Stream Socket Transports  tcp, udp  
Registered Stream Filters  convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, zlib.*  

This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
    with Zend Extension Manager v1.2.0, Copyright (c) 2003-2007, by Zend Technologies
    with Zend Optimizer v3.2.6, Copyright (c) 1998-2007, by Zend Technologies



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

PHP Credits

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

Configuration
PHP Core
Directive Local Value Master Value
allow_call_time_pass_reference Off Off
allow_url_fopen On On
allow_url_include Off Off
always_populate_raw_post_data Off Off
arg_separator.input & &
arg_separator.output & &
asp_tags Off Off
auto_append_file no value no value
auto_globals_jit On On
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_classes no value no value
disable_functions no value no value
display_errors Off Off
display_startup_errors Off Off
doc_root no value no value
docref_ext no value no value
docref_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 6143 6143
expose_php On On
extension_dir C:\PHP\ext C:\PHP\ext
file_uploads On On
highlight.bg #FFFFFF #FFFFFF
highlight.comment #FF8000 #FF8000
highlight.default #0000BB #0000BB
highlight.html #000000 #000000
highlight.keyword #007700 #007700
highlight.string #DD0000 #DD0000
html_errors On On
ignore_repeated_errors Off Off
ignore_repeated_source Off Off
ignore_user_abort Off Off
implicit_flush Off Off
include_path .;C:\php5\pear .;C:\php5\pear
log_errors On On
log_errors_max_len 1024 1024
magic_quotes_gpc Off Off
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
mail.force_extra_parameters no value no value
max_execution_time 30 30
max_input_nesting_level 64 64
max_input_time 60 60
memory_limit 128M 128M
open_basedir no value no value
output_buffering 4096 4096
output_handler no value no value
post_max_size 8M 8M
precision 14 14
realpath_cache_size 16K 16K
realpath_cache_ttl 120 120
register_argc_argv Off Off
register_globals Off Off
register_long_arrays Off Off
report_memleaks On On
report_zend_debug 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 no value no value
sendmail_path no value no value
serialize_precision 100 100
short_open_tag On On
SMTP localhost localhost
smtp_port 25 25
sql.safe_mode Off Off
track_errors Off Off
unserialize_callback_func no value no value
upload_max_filesize 2M 2M
upload_tmp_dir C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\php\upload C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\php\upload
user_dir no value no value
variables_order GPCS GPCS
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
y2k_compliance On On
zend.ze1_compatibility_mode Off Off


bcmath
BCMath support  enabled  


calendar
Calendar support  enabled  


com_dotnet
COM support enabled
DCOM support disabled
.Net support enabled

Directive Local Value Master Value
com.allow_dcom 0 0
com.autoregister_casesensitive 1 1
com.autoregister_typelib 0 0
com.autoregister_verbose 0 0
com.code_page no value no value
com.typelib_file no value no value


ctype
ctype functions  enabled  


date
date/time support  enabled  
"Olson" Timezone Database Version  2007.5  
Timezone Database  internal  
Default timezone  PRC  

Directive Local Value Master Value
date.default_latitude 31.7667 31.7667
date.default_longitude 35.2333 35.2333
date.sunrise_zenith 90.583333 90.583333
date.sunset_zenith 90.583333 90.583333
date.timezone PRC PRC


dom
DOM/XML  enabled  
DOM/XML API Version  20031129  
libxml Version  2.6.26  
HTML Support  enabled  
XPath Support  enabled  
XPointer Support  enabled  
Schema Support  enabled  
RelaxNG Support  enabled  


filter
Input Validation and Filtering  enabled  
Revision  $Revision: 1.52.2.39 $  

Directive Local Value Master Value
filter.default unsafe_raw unsafe_raw
filter.default_flags no value no value


ftp
FTP support  enabled  


gd
GD Support  enabled  
GD Version  bundled (2.0.34 compatible)  
FreeType Support  enabled  
FreeType Linkage  with freetype  
FreeType Version  2.1.9  
T1Lib Support  enabled  
GIF Read Support  enabled  
GIF Create Support  enabled  
JPG Support  enabled  
PNG Support  enabled  
WBMP Support  enabled  
XBM Support  enabled  


hash
hash support  enabled  
Hashing Engines  md2 md4 md5 sha1 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru gost adler32 crc32 crc32b haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5  


iconv
iconv support  enabled  
iconv implementation  "libiconv"  
iconv library version  1.9  

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


ISAPI
Server Variable Value
CONTENT_LENGTH  0  
PATH_TRANSLATED  e:\web\php.php  
REMOTE_ADDR  127.0.0.1  
REMOTE_HOST  127.0.0.1  
REQUEST_METHOD  GET  
SERVER_NAME  127.0.0.1  
SERVER_PORT  80  
SERVER_PROTOCOL  HTTP/1.1  
SERVER_SOFTWARE  Microsoft-IIS/6.0  
APPL_MD_PATH  /LM/W3SVC/1/ROOT  
APPL_PHYSICAL_PATH  e:\web\  
INSTANCE_ID  1  
INSTANCE_META_PATH  /LM/W3SVC/1  
URL  /php.php  
ALL_HTTP  HTTP_CONNECTION:Keep-Alive HTTP_ACCEPT:image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */* HTTP_ACCEPT_ENCODING:gzip, deflate HTTP_ACCEPT_LANGUAGE:zh-cn HTTP_HOST:127.0.0.1 HTTP_USER_AGENT:Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.2; .NET CLR 1.1.4322; InfoPath.2) HTTP_UA_CPU:x86  
HTTPS  off  
SCRIPT_NAME  /php.php  
SERVER_PORT_SECURE  0  


json
json support  enabled  
json version  1.2.1  


libxml
libXML support  active  
libXML Version  2.6.26  
libXML streams  enabled  


mbstring
Multibyte Support  enabled  
Multibyte string engine  libmbfl  
Multibyte (japanese) regex support  enabled  
Multibyte regex (oniguruma) version  4.4.4  
Multibyte regex (oniguruma) backtrack check  On  

mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.

Directive Local Value Master Value
mbstring.detect_order no value no value
mbstring.encoding_translation Off Off
mbstring.func_overload 0 0
mbstring.http_input pass pass
mbstring.http_output pass pass
mbstring.internal_encoding no value no value
mbstring.language neutral neutral
mbstring.strict_detection Off Off
mbstring.substitute_character no value no value


mssql
MSSQL Support enabled
Active Persistent Links  0  
Active Links  0  
Library version  7.0  

Directive Local Value Master Value
mssql.allow_persistent On On
mssql.batchsize 0 0
mssql.compatability_mode Off Off
mssql.connect_timeout 5 5
mssql.datetimeconvert On On
mssql.max_links Unlimited Unlimited
mssql.max_persistent Unlimited Unlimited
mssql.max_procs Unlimited Unlimited
mssql.min_error_severity 10 10
mssql.min_message_severity 10 10
mssql.secure_connection Off Off
mssql.textlimit Server default Server default
mssql.textsize Server default Server default
mssql.timeout 60 60


odbc
ODBC Support enabled
Active Persistent Links  0  
Active Links  0  
ODBC library  Win32  

Directive Local Value Master Value
odbc.allow_persistent On On
odbc.check_persistent On On
odbc.default_db no value no value
odbc.default_pw no value no value
odbc.default_user no value no value
odbc.defaultbinmode return as is return as is
odbc.defaultlrl return up to 4096 bytes return up to 4096 bytes
odbc.max_links Unlimited Unlimited
odbc.max_persistent Unlimited Unlimited


pcre
PCRE (Perl Compatible Regular Expressions) Support  enabled  
PCRE Library Version  7.0 18-Dec-2006  


Reflection
Reflection enabled
Version  $Id: php_reflection.c,v 1.164.2.33.2.39 2007/05/29 08:44:05 helly Exp $  


session
Session Support  enabled  
Registered save handlers  files user  
Registered serializer handlers  php php_binary wddx  

Directive Local Value Master Value
session.auto_start Off Off
session.bug_compat_42 Off Off
session.bug_compat_warn On On
session.cache_expire 180 180
session.cache_limiter nocache nocache
session.cookie_domain no value no value
session.cookie_httponly Off Off
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_divisor 1000 1000
session.gc_maxlifetime 1440 1440
session.gc_probability 1 1
session.hash_bits_per_character 5 5
session.hash_function 0 0
session.name PHPSESSID PHPSESSID
session.referer_check no value no value
session.save_handler files files
session.save_path C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\php\session C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\php\session
session.serialize_handler php php
session.use_cookies On On
session.use_only_cookies Off Off
session.use_trans_sid 0 0


SimpleXML
Simplexml support enabled
Revision  $Revision: 1.151.2.22.2.26 $  
Schema support  enabled  


SPL
SPL support enabled
Interfaces  Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject  
Classes  AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainException, EmptyIterator, FilterIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RegexIterator, RuntimeException, SimpleXMLIterator, SplFileInfo, SplFileObject, SplObjectStorage, SplTempFileObject, UnderflowException, UnexpectedValueException  


standard
Regex Library  Bundled library enabled  
Dynamic Library Support  enabled  
Internal Sendmail Support for Windows  enabled  

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
auto_detect_line_endings 0 0
default_socket_timeout 60 60
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
user_agent no value no value


tokenizer
Tokenizer Support  enabled  


wddx
WDDX Support enabled
WDDX Session Serializer  enabled  


xml
XML Support  active  
XML Namespace Support  active  
libxml2 Version  2.6.26  


xmlreader
XMLReader  enabled  


xmlwriter
XMLWriter  enabled  


Zend Optimizer
Optimization Pass 1  enabled  
Optimization Pass 2  enabled  
Optimization Pass 3  enabled  
Optimization Pass 4  enabled  
Optimization Pass 9  enabled  
Zend Loader  enabled  
License Path  no value  
Obfuscation level  3  


zlib
ZLib Support  enabled  
Stream Wrapper support  compress.zlib://  
Stream Filter support  zlib.inflate, zlib.deflate  
Compiled Version  1.2.3  
Linked Version  1.2.3  

Directive Local Value Master Value
zlib.output_compression Off Off
zlib.output_compression_level -1 -1
zlib.output_handler no value no value


Additional Modules
Module Name


Environment
Variable Value
ALLUSERSPROFILE  C:\Documents and Settings\All Users  
ClusterLog  C:\WINDOWS\Cluster\cluster.log  
CommonProgramFiles  C:\Program Files\Common Files  
COMPUTERNAME  WLXX-101  
ComSpec  C:\WINDOWS\system32\cmd.exe  
FP_NO_HOST_CHECK  NO  
NUMBER_OF_PROCESSORS  2  
OS  Windows_NT  
Path  C:\PHP\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\MySQL5\bin  
PATHEXT  .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH  
PHPRC  C:\PHP\  
PROCESSOR_ARCHITECTURE  x86  
PROCESSOR_IDENTIFIER  x86 Family 15 Model 67 Stepping 2, AuthenticAMD  
PROCESSOR_LEVEL  15  
PROCESSOR_REVISION  4302  
ProgramFiles  C:\Program Files  
Rav  C:\Documents and Settings\All Users\Application Data\Rising\Rav  
SystemDrive  C:  
SystemRoot  C:\WINDOWS  
TEMP  C:\WINDOWS\TEMP  
TMP  C:\WINDOWS\TEMP  
USERPROFILE  C:\Documents and Settings\Default User  
windir  C:\WINDOWS  


PHP Variables
Variable Value
_SERVER["ALL_HTTP"] HTTP_CONNECTION:Keep-Alive HTTP_ACCEPT:image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */* HTTP_ACCEPT_ENCODING:gzip, deflate HTTP_ACCEPT_LANGUAGE:zh-cn HTTP_HOST:127.0.0.1 HTTP_USER_AGENT:Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.2; .NET CLR 1.1.4322; InfoPath.2) HTTP_UA_CPU:x86  
_SERVER["HTTPS"] off
_SERVER["SCRIPT_NAME"] /php.php
_SERVER["HTTP_COOKIE"] no value
_SERVER["AUTH_PASSWORD"] no value
_SERVER["AUTH_TYPE"] no value
_SERVER["AUTH_USER"] no value
_SERVER["CONTENT_LENGTH"] 0
_SERVER["CONTENT_TYPE"] no value
_SERVER["PATH_TRANSLATED"] e:\web
_SERVER["QUERY_STRING"] no value
_SERVER["REMOTE_ADDR"] 127.0.0.1
_SERVER["REMOTE_HOST"] 127.0.0.1
_SERVER["REMOTE_USER"] no value
_SERVER["REQUEST_METHOD"] GET
_SERVER["SERVER_NAME"] 127.0.0.1
_SERVER["SERVER_PORT"] 80
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["SERVER_SOFTWARE"] Microsoft-IIS/6.0
_SERVER["APPL_MD_PATH"] /LM/W3SVC/1/ROOT
_SERVER["APPL_PHYSICAL_PATH"] e:\web\
_SERVER["INSTANCE_ID"] 1
_SERVER["INSTANCE_META_PATH"] /LM/W3SVC/1
_SERVER["LOGON_USER"] no value
_SERVER["REQUEST_URI"] /php.php
_SERVER["URL"] /php.php
_SERVER["SCRIPT_FILENAME"] e:\web\php.php
_SERVER["ORIG_PATH_INFO"] /php.php
_SERVER["PATH_INFO"] no value
_SERVER["ORIG_PATH_TRANSLATED"] e:\web\php.php
_SERVER["DOCUMENT_ROOT"] e:\web
_SERVER["PHP_SELF"] /php.php
_SERVER["HTTP_CONNECTION"] Keep-Alive
_SERVER["HTTP_ACCEPT"] image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*
_SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate
_SERVER["HTTP_ACCEPT_LANGUAGE"] zh-cn
_SERVER["HTTP_HOST"] 127.0.0.1
_SERVER["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.2; .NET CLR 1.1.4322; InfoPath.2)
_SERVER["HTTP_UA_CPU"] x86
_SERVER["REQUEST_TIME"] 1184755511


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.

[ 本帖最后由 lfghx 于 2007-7-19 08:48 编辑 ]

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
发表于 2007-7-18 22:12:47 | 显示全部楼层
是php找不到mysql,所有的方法,有点吹了.
回复

使用道具 举报

 楼主| 发表于 2007-7-19 08:27:22 | 显示全部楼层
那高手给介绍点常见故障
回复

使用道具 举报

发表于 2007-7-19 17:17:20 | 显示全部楼层
不知道这是咋会事。在www.siteengine.net上有集成pnp+mysql+zend的集成环境,比较好用,我一般都用那个,就再也不用配环境了。
回复

使用道具 举报

发表于 2007-7-19 18:05:19 | 显示全部楼层
不用集成的,集成的自己不大好整,自己配置,不用拷文件,我都是一次性成功的.\
回复

使用道具 举报

发表于 2007-7-19 19:15:43 | 显示全部楼层
将这个文件将入windows目录下面即可。

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
回复

使用道具 举报

发表于 2007-7-20 11:04:38 | 显示全部楼层
libmysql.dll复制到system32或者ext目录下面
回复

使用道具 举报

发表于 2007-7-31 12:18:42 | 显示全部楼层
照我这里做了
(X:\Server_Core) 这里是你安装的目录

第一步:
(1) 测试MySQL工作是否正常。
打开cmd命令提示符窗口,输入命令:mysql –u root –p
输入密码后,如果能够正常进入MySQL控制台则说明MySQL安装正常。

(2) 更改MySQL数据库目录
a) 打开cmd命令提示符窗口,输入命令:net stop mysql 停止MySQL服务运行;
b) 打开X:\Server_Core\MySQL\my.ini,
找到:
Datadir = “X:\Server_Core\MySQL\data”
修改为:
Datadir = “X:\Database”
c) 将X:\Server_Core\MySQL\data 文件夹复制到X:\,并重命名为X:\Database;
d) 打开cmd命令提示符窗口,输入命令:net start mysql 启动MySQL服务。
e) 重新测试MySQL是否工作正常。

(3) 准备LibMySQL动态链接库
将X:\Server_Core\MySQL\bin\libmySQL.dll 文件
复制到 C:\Windows\System32。

第二步:
打开php.ini文件,找到:
extension_dir = "./"
将其改为;
extension_dir = "X:\Server_Core\PHP\ext"
(4) 找到:Windows Extensions
在Windows Extensions下方的动态模块配置中,需要打开以下模块支持:(去掉模块配置每行前面的;号即可)
extension=php_mbstring.dll
extension=php_gd2.dll
extension=php_mysql.dll
(5) 找到:
disable_functions =
改为:
disable_functions =
passthru,exec,system,popen,chroot,escapeshellcmd,escapeshellarg,shell_exec,pro
c_open,proc_get_status

(6)然后查找:register_globals = Off 改为on  修改完之后保存此文件
(7) 保存php.ini文件,并将其复制到C:\Windows\

第三步:复制php目录下的libmysql.dll文件到system32下

这样一定行.,我就是这样改好的
回复

使用道具 举报

发表于 2007-9-8 15:44:16 | 显示全部楼层
如上所述还是不行 难道是目录权限问题
回复

使用道具 举报

发表于 2007-9-16 09:44:14 | 显示全部楼层

还是搞不定,有这么难吗?

,高手在哪里呢?
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

Discuz! Q 3.0 全新来袭 助力变现

小黑屋|Discuz! 官方站 ( 粤B2-20090059-165 )star

GMT+8, 2021-9-28 00:24

Powered by Discuz! X3.4

Copyright © 2001-2019 Tencent Cloud.

快速回复 返回顶部 返回列表