SitePoint Sponsor

User Tag List

Results 1 to 8 of 8
  1. #1
    SitePoint Zealot
    Join Date
    Oct 2005
    Posts
    128
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question trouble getting mysqli or mysql extension to load

    Hi, I just recently installed PHP 5, apache2 and mysql 4.1. I tested my server and the php works fine, but I cannot get the mysql extensions to load. The weird thing is I can get other extensions to load like mbstring.dll, so my extension path must be right.

    I checked the apache error logs and it gives me the following message

    Code:
    [Fri May 05 16:48:18 2006] [notice] Apache/2.0.54 (Win32) PHP/5.1.2 configured -- resuming normal operations
    [Fri May 05 16:48:18 2006] [notice] Server built: Apr 16 2005 14:25:31
    [Fri May 05 16:48:18 2006] [notice] Parent: Created child process 2016
    PHP Warning:  PHP Startup: Unable to load dynamic library 'U:/PHP5/ext/php_mysqli.dll' - The specified module could not be found.\r\n in Unknown on line 0
    [Fri May 05 16:48:19 2006] [notice] Child 2016: Child process is running
    [Fri May 05 16:48:19 2006] [notice] Child 2016: Acquired the start mutex.
    [Fri May 05 16:48:19 2006] [notice] Child 2016: Starting 250 worker threads.
    It also gives me an error exactly like this when I try and load the regular mysql.dll extension. Other extensions can be loaded but for some reason these two can't. Any help is appreciated, thanks

  2. #2
    SitePoint Wizard cmuench's Avatar
    Join Date
    Jul 2005
    Location
    At my computer
    Posts
    2,251
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Can you put the following in a page?
    PHP Code:
    <?php
    phpinfo
    (); 
    ?>
    Then link to the page if possible. Just checking to see if php is installed right and then we will work from there. Also this thread should be moved to the Apache Forum.

  3. #3
    SitePoint Zealot
    Join Date
    Oct 2005
    Posts
    128
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Code:
    PHP Logo
    PHP Version 5.1.2
    
    System 	Windows NT BOBEEP 5.1 build 2600
    Build Date 	Jan 11 2006 16:35:21
    Configure Command 	cscript /nologo configure.js "--enable-snapshot-build" "--with-gd=shared"
    Server API 	Apache 2.0 Handler
    Virtual Directory Support 	enabled
    Configuration File (php.ini) Path 	U:\PHP5\php.ini
    PHP API 	20041225
    PHP Extension 	20050922
    Zend Extension 	220051025
    Debug Build 	no
    Thread Safety 	enabled
    Zend Memory Manager 	enabled
    IPv6 Support 	enabled
    Registered PHP Streams 	php, file, 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.*, zlib.*
    
    Zend logo This program makes use of the Zend Scripting Language Engine:
    Zend Engine v2.1.0, Copyright (c) 1998-2006 Zend Technologies
    
    PHP Credits
    Configuration
    PHP Core
    Directive	Local Value	Master Value
    allow_call_time_pass_reference	Off	Off
    allow_url_fopen	On	On
    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	2039	2039
    expose_php	On	On
    extension_dir	U:/PHP5/ext/	U:/PHP5/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:\Website\includes\	.;C:\Website\includes\
    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_time	60	60
    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
    
    apache2handler
    Apache Version 	Apache/2.0.54 (Win32) PHP/5.1.2
    Apache API Version 	20020903
    Server Administrator 	admin@localhost.com
    Hostname:Port 	localhost:0
    Max Requests 	Per Child: 0 - Keep Alive: on - Max Per Connection: 100
    Timeouts 	Connection: 300 - Keep-Alive: 15
    Virtual Server 	No
    Server Root 	U:/Apache/Apache2
    Loaded Modules 	core mod_win32 mpm_winnt http_core mod_so mod_access mod_actions mod_alias mod_asis mod_auth mod_autoindex mod_cgi mod_dir mod_env mod_imap mod_include mod_isapi mod_log_config mod_mime mod_negotiation mod_setenvif mod_userdir mod_php5
    
    Directive	Local Value	Master Value
    engine	1	1
    last_modified	0	0
    xbithack	0	0
    
    Apache Environment
    Variable	Value
    HTTP_HOST 	localhost:447
    HTTP_USER_AGENT 	Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20051111 Firefox/1.5
    HTTP_ACCEPT 	text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
    HTTP_ACCEPT_LANGUAGE 	en-us,en;q=0.5
    HTTP_ACCEPT_ENCODING 	gzip,deflate
    HTTP_ACCEPT_CHARSET 	ISO-8859-1,utf-8;q=0.7,*;q=0.7
    HTTP_KEEP_ALIVE 	300
    HTTP_CONNECTION 	keep-alive
    HTTP_CACHE_CONTROL 	max-age=0
    PATH 	C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem
    SystemRoot 	C:\WINDOWS
    COMSPEC 	C:\WINDOWS\system32\cmd.exe
    PATHEXT 	.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
    WINDIR 	C:\WINDOWS
    SERVER_SIGNATURE 	<address>Apache/2.0.54 (Win32) PHP/5.1.2 Server at localhost Port 447</address>
    SERVER_SOFTWARE 	Apache/2.0.54 (Win32) PHP/5.1.2
    SERVER_NAME 	localhost
    SERVER_ADDR 	127.0.0.1
    SERVER_PORT 	447
    REMOTE_ADDR 	127.0.0.1
    DOCUMENT_ROOT 	C:/Website
    SERVER_ADMIN 	admin@localhost.com
    SCRIPT_FILENAME 	C:/Website/info.php
    REMOTE_PORT 	1121
    GATEWAY_INTERFACE 	CGI/1.1
    SERVER_PROTOCOL 	HTTP/1.1
    REQUEST_METHOD 	GET
    QUERY_STRING 	no value
    REQUEST_URI 	/info.php
    SCRIPT_NAME 	/info.php
    
    HTTP Headers Information
    HTTP Request Headers
    HTTP Request 	GET /info.php HTTP/1.1
    Host 	localhost:447
    User-Agent 	Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20051111 Firefox/1.5
    Accept 	text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
    Accept-Language 	en-us,en;q=0.5
    Accept-Encoding 	gzip,deflate
    Accept-Charset 	ISO-8859-1,utf-8;q=0.7,*;q=0.7
    Keep-Alive 	300
    Connection 	keep-alive
    Cache-Control 	max-age=0
    HTTP Response Headers
    X-Powered-By 	PHP/5.1.2
    Keep-Alive 	timeout=15, max=100
    Connection 	Keep-Alive
    Transfer-Encoding 	chunked
    Content-Type 	text/html
    
    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
    Timezone Database Version 	2005.18
    Timezone Database 	internal
    Default timezone 	America/Los_Angeles
    
    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.22
    HTML Support 	enabled
    XPath Support 	enabled
    XPointer Support 	enabled
    Schema Support 	enabled
    RelaxNG Support 	enabled
    
    ftp
    FTP support 	enabled
    
    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
    
    libxml
    libXML support 	active
    libXML Version 	2.6.22
    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 	6.2 01-Aug-2005
    
    Reflection
    Reflection	enabled
    Version 	$Id: php_reflection.c,v 1.164.2.17 2006/01/01 12:50:12 sniper 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_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.10 $
    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, 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.22
    
    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:\Documents and Settings\All Users
    CommonProgramFiles 	C:\Program Files\Common Files
    COMPUTERNAME 	BOBEEP
    ComSpec 	C:\WINDOWS\system32\cmd.exe
    FP_NO_HOST_CHECK 	NO
    NUMBER_OF_PROCESSORS 	1
    OS 	Windows_NT
    Path 	C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem
    PATHEXT 	.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
    PROCESSOR_ARCHITECTURE 	x86
    PROCESSOR_IDENTIFIER 	x86 Family 6 Model 10 Stepping 0, AuthenticAMD
    PROCESSOR_LEVEL 	6
    PROCESSOR_REVISION 	0a00
    ProgramFiles 	C:\Program Files
    SystemDrive 	C:
    SystemRoot 	C:\WINDOWS
    TEMP 	C:\WINDOWS\TEMP
    TMP 	C:\WINDOWS\TEMP
    USERPROFILE 	C:\Documents and Settings\LocalService
    windir 	C:\WINDOWS
    AP_PARENT_PID 	2848
    
    PHP Variables
    Variable	Value
    _SERVER["HTTP_HOST"]	localhost:447
    _SERVER["HTTP_USER_AGENT"]	Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20051111 Firefox/1.5
    _SERVER["HTTP_ACCEPT"]	text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
    _SERVER["HTTP_ACCEPT_LANGUAGE"]	en-us,en;q=0.5
    _SERVER["HTTP_ACCEPT_ENCODING"]	gzip,deflate
    _SERVER["HTTP_ACCEPT_CHARSET"]	ISO-8859-1,utf-8;q=0.7,*;q=0.7
    _SERVER["HTTP_KEEP_ALIVE"]	300
    _SERVER["HTTP_CONNECTION"]	keep-alive
    _SERVER["HTTP_CACHE_CONTROL"]	max-age=0
    _SERVER["PATH"]	C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem
    _SERVER["SystemRoot"]	C:\WINDOWS
    _SERVER["COMSPEC"]	C:\WINDOWS\system32\cmd.exe
    _SERVER["PATHEXT"]	.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
    _SERVER["WINDIR"]	C:\WINDOWS
    _SERVER["SERVER_SIGNATURE"]	<address>Apache/2.0.54 (Win32) PHP/5.1.2 Server at localhost Port 447</address>
    _SERVER["SERVER_SOFTWARE"]	Apache/2.0.54 (Win32) PHP/5.1.2
    _SERVER["SERVER_NAME"]	localhost
    _SERVER["SERVER_ADDR"]	127.0.0.1
    _SERVER["SERVER_PORT"]	447
    _SERVER["REMOTE_ADDR"]	127.0.0.1
    _SERVER["DOCUMENT_ROOT"]	C:/Website
    _SERVER["SERVER_ADMIN"]	admin@localhost.com
    _SERVER["SCRIPT_FILENAME"]	C:/Website/info.php
    _SERVER["REMOTE_PORT"]	1121
    _SERVER["GATEWAY_INTERFACE"]	CGI/1.1
    _SERVER["SERVER_PROTOCOL"]	HTTP/1.1
    _SERVER["REQUEST_METHOD"]	GET
    _SERVER["QUERY_STRING"]	no value
    _SERVER["REQUEST_URI"]	/info.php
    _SERVER["SCRIPT_NAME"]	/info.php
    _SERVER["PHP_SELF"]	/info.php
    _SERVER["REQUEST_TIME"]	1146945149
    
    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.

  4. #4
    SitePoint Member Sicloan's Avatar
    Join Date
    Nov 2005
    Posts
    18
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Did you use the windows installer? i had the same problem and had to download all the extensions int he .zip package and make the ext folder. Basically the .dll's arent being found. Make sure you have the paths right.

  5. #5
    SitePoint Zealot
    Join Date
    Oct 2005
    Posts
    128
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I got it to find the extensions, but now I can't get mysql to work with it.

  6. #6
    SitePoint Zealot
    Join Date
    Oct 2005
    Posts
    128
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well I finally got php, mysql and apache to work for the most part. I just left the install directories to their default locations and it seemed to do the trick. Now my .htaccess files don't work I swear trying to get these three things to work in harmony is a nightmare, no matter how many times you do there is always something wrong

  7. #7
    SitePoint Zealot
    Join Date
    Oct 2005
    Posts
    128
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    All is well again <takes a long walk>

  8. #8
    SitePoint Wizard cmuench's Avatar
    Join Date
    Jul 2005
    Location
    At my computer
    Posts
    2,251
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Sounds like you finally got it fixed. Thats great!!! I use XAMPP for windows installations because that is the easiest to get them all working on Windows. Just unzip and click apache_start.bat
    http://www.apachefriends.org/en/xampp-windows.html


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •