Skip navigation links

MySQL Forums :: PHP :: MySQL not loaded in phpinfo() for Windows & IIS 7


Advanced Search

MySQL not loaded in phpinfo() for Windows & IIS 7
Posted by: Dwayne Leacock ()
Date: September 13, 2007 08:52AM

Hello All!

The following is the output from my info.php file. As you will all notice that MySQL support is not enabled. Before we go any further I should tell you that I have read everything that I can to resolve this issue myself. I have downloaded the correct connectors and installed them correctly. I have also made the nesscary changes to the php.ini file with is located in the windows directory. I have also read the forge.mysql.com/wiki/php_faq.

Does anyone have anything else they would like me to try?

*Windows Vista
*MySQL version 5
*IIS 7 with compatiblity with II6


Thanks

PHP Version 5.2.4

System Windows NT LAPTOP 6.0 build 6000
Build Date Aug 30 2007 07:05:48
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:\WINDOWS\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



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

--

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 ./inetpub/php/ext ./inetpub/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 Off Off
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 no value no value
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.6
Timezone Database internal
Default timezone America/New_York

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 no value no value


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


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 C:\inetpub\wwwroot\zen-cart\zc_install\includes\phpinfo.php
REMOTE_ADDR ::1
REMOTE_HOST ::1
REQUEST_METHOD GET
SERVER_NAME localhost
SERVER_PORT 80
SERVER_PROTOCOL HTTP/1.1
SERVER_SOFTWARE Microsoft-IIS/7.0
APPL_MD_PATH /LM/W3SVC/1/ROOT
APPL_PHYSICAL_PATH C:\inetpub\wwwroot
INSTANCE_ID 1
INSTANCE_META_PATH /LM/W3SVC/1
URL /zen-cart/zc_install/includes/phpinfo.php
ALL_HTTP HTTP_CONNECTION:Keep-Alive HTTP_CONTENT_LENGTH:0 HTTP_ACCEPT:*/*

HTTP_ACCEPT_ENCODING:gzip, deflate HTTP_ACCEPT_LANGUAGE:en-ca

HTTP_COOKIE:CFID=5900; CFTOKEN=40744536 HTTP_HOST:localhost

HTTP_USER_AGENT:Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET

CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506) HTTP_UA_CPU:x86
HTTPS off
SCRIPT_NAME /zen-cart/zc_install/includes/phpinfo.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


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.2 2007-06-19

Directive Local Value Master Value
pcre.backtrack_limit 100000 100000
pcre.recursion_limit 100000 100000


Reflection
Reflection enabled
Version $Id: php_reflection.c,v 1.164.2.33.2.45 2007/08/20 17:01:22 sebastian

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 no value no value
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.35 $
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


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:\ProgramData
APPDATA C:\Windows\ServiceProfiles\NetworkService\AppData\Roaming
CommonProgramFiles C:\Program Files\Common Files
COMPUTERNAME LAPTOP
ComSpec C:\Windows\system32\cmd.exe
FP_NO_HOST_CHECK NO
LOCALAPPDATA C:\Windows\ServiceProfiles\NetworkService\AppData\Local
NUMBER_OF_PROCESSORS 2
OnlineServices Online Services
OS Windows_NT
Path

C:\ColdFusion8\verity\k2\_nti40\bin;C:\CFusionMX7\verity\k2\_nti40\bin;C:\Wind

ows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Program Files\Common

Files\Roxio Shared\DLLShared\;C:\Program Files\Common Files\Roxio

Shared\DLLShared\;C:\Program Files\Common Files\Roxio

Shared\9.0\DLLShared\;c:\Program Files\Microsoft SQL

Server\90\Tools\binn\;C:\Program Files\MySQL\MySQL Server 5.0\bin
PATHEXT .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PCBRAND Pavilion
PLATFORM MCD
PROCESSOR_ARCHITECTURE x86
PROCESSOR_IDENTIFIER x86 Family 6 Model 14 Stepping 12, GenuineIntel
PROCESSOR_LEVEL 6
PROCESSOR_REVISION 0e0c
ProgramData C:\ProgramData
ProgramFiles C:\Program Files
PUBLIC C:\Users\Public
RoxioCentral C:\Program Files\Common Files\Roxio Shared\9.0\Roxio Central33\
SystemDrive C:
SystemRoot C:\Windows
TEMP C:\Windows\SERVIC~2\NETWOR~1\AppData\Local\Temp
TMP C:\Windows\SERVIC~2\NETWOR~1\AppData\Local\Temp
USERDOMAIN WIREDLABS
USERNAME LAPTOP$
USERPART E:
USERPROFILE C:\Windows\ServiceProfiles\NetworkService
VERITY_CFG C:\ColdFusion8\verity\k2\common\verity.cfg
windir C:\Windows


PHP Variables
Variable Value
_REQUEST["CFID"] 5900
_REQUEST["CFTOKEN"] 40744536
_COOKIE["CFID"] 5900
_COOKIE["CFTOKEN"] 40744536
_SERVER["ALL_HTTP"] HTTP_CONNECTION:Keep-Alive HTTP_CONTENT_LENGTH:0

HTTP_ACCEPT:*/* HTTP_ACCEPT_ENCODING:gzip, deflate HTTP_ACCEPT_LANGUAGE:en-ca

HTTP_COOKIE:CFID=5900; CFTOKEN=40744536 HTTP_HOST:localhost

HTTP_USER_AGENT:Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET

CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506) HTTP_UA_CPU:x86
_SERVER["HTTPS"] off
_SERVER["SCRIPT_NAME"] /zen-cart/zc_install/includes/phpinfo.php
_SERVER["HTTP_COOKIE"] CFID=5900; CFTOKEN=40744536
_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"] C:\inetpub\wwwroot
_SERVER["QUERY_STRING"] no value
_SERVER["REMOTE_ADDR"] ::1
_SERVER["REMOTE_HOST"] ::1
_SERVER["REMOTE_USER"] no value
_SERVER["REQUEST_METHOD"] GET
_SERVER["SERVER_NAME"] localhost
_SERVER["SERVER_PORT"] 80
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["SERVER_SOFTWARE"] Microsoft-IIS/7.0
_SERVER["APPL_MD_PATH"] /LM/W3SVC/1/ROOT
_SERVER["APPL_PHYSICAL_PATH"] C:\inetpub\wwwroot
_SERVER["INSTANCE_ID"] 1
_SERVER["INSTANCE_META_PATH"] /LM/W3SVC/1
_SERVER["LOGON_USER"] no value
_SERVER["REQUEST_URI"] /zen-cart/zc_install/includes/phpinfo.php
_SERVER["URL"] /zen-cart/zc_install/includes/phpinfo.php
_SERVER["SCRIPT_FILENAME"]

C:\inetpub\wwwroot\zen-cart\zc_install\includes\phpinfo.php
_SERVER["ORIG_PATH_INFO"] /zen-cart/zc_install/includes/phpinfo.php
_SERVER["PATH_INFO"] no value
_SERVER["ORIG_PATH_TRANSLATED"]

C:\inetpub\wwwroot\zen-cart\zc_install\includes\phpinfo.php
_SERVER["DOCUMENT_ROOT"] C:\inetpub\wwwroot
_SERVER["PHP_SELF"] /zen-cart/zc_install/includes/phpinfo.php
_SERVER["HTTP_CONNECTION"] Keep-Alive
_SERVER["HTTP_CONTENT_LENGTH"] 0
_SERVER["HTTP_ACCEPT"] */*
_SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate
_SERVER["HTTP_ACCEPT_LANGUAGE"] en-ca
_SERVER["HTTP_HOST"] localhost
_SERVER["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0;

SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506)
_SERVER["HTTP_UA_CPU"] x86
_SERVER["REQUEST_TIME"] 1189694739


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.

Options: ReplyQuote


Subject Written By Posted
MySQL not loaded in phpinfo() for Windows & IIS 7 Dwayne Leacock 09/13/2007 08:52AM
Re: MySQL not loaded in phpinfo() for Windows & IIS 7 Peter Brawley 09/13/2007 10:49PM
Re: MySQL not loaded in phpinfo() for Windows & IIS 7 Koh Chun Ming Alvin 09/14/2007 12:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.