shiguera Posted February 6, 2007 Share Posted February 6, 2007 I'm running Win XP sp2, installed apache 2.2.4 and PHP 5.2.0. Tested and work ok (the "It works!" page appears as well as the info from phpinfo.php). I then installed MySQL 5.0.27 and tested it alone, it works ok from the command line. BUT, did an http://localhost/phpinfo.php and there is no section on MySQL. Did a phpmyadmin and it says that it can't load MySQL. I checked for the usual things like the extension, the \ext directory, the PHP and MySQL/bin directories are in the PATH, etc., everything seems to be ok except that I don't have a copy of libmysql.dll in the system32 directory. I went ahead and enabled showing startup errors and I get a warning saying that the dynamic library module php_mysql.dll was not found, but the file is present and so is the libmysql.dll. I've been thinking about uninstalling MySQL and reinstalling again but first I want some advice from you. Please any idea(s) will be appreciated. Link to comment Share on other sites More sharing options...
fenway Posted February 6, 2007 Share Posted February 6, 2007 I don't know specifcally how to fix this, but the output of phpinfo() is probably required for anyone else to assist you. Link to comment Share on other sites More sharing options...
shiguera Posted February 6, 2007 Author Share Posted February 6, 2007 Can i e-mail the file to you? in what format (html or txt)? Link to comment Share on other sites More sharing options...
fenway Posted February 6, 2007 Share Posted February 6, 2007 Not e-mail... just post the relevant sections here, and someone more knowledgeable than I will hopefully come take a look. Link to comment Share on other sites More sharing options...
shiguera Posted February 7, 2007 Author Share Posted February 7, 2007 Here are the main parts (to my understanding...) of my phpinfo results: phpinfo()PHP Version 5.2.0 System Windows NT TEST-A72880BC08 5.1 build 2600 Build Date Nov 2 2006 11:50:55 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 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 © 1998-2006 Zend Technologies PHP Credits Configuration PHP Core DirectiveLocal ValueMaster Value allow_call_time_pass_referenceOffOff allow_url_fopenOnOn allow_url_includeOffOff always_populate_raw_post_dataOffOff arg_separator.input&& arg_separator.output&& asp_tagsOffOff auto_append_fileno valueno value auto_globals_jitOnOn auto_prepend_fileno valueno value browscapno valueno value default_charsetno valueno value default_mimetypetext/htmltext/html define_syslog_variablesOffOff disable_classesno valueno value disable_functionsno valueno value display_errorsOnOn display_startup_errorsOnOn doc_rootno valueno value docref_extno valueno value docref_rootno valueno value enable_dlOnOn error_append_stringno valueno value error_logc:\PHP\log\php_error.logc:\PHP\log\php_error.log error_prepend_stringno valueno value error_reporting61436143 expose_phpOnOn extension_dirC:\PHP\ext\C:\PHP\ext\ file_uploadsOnOn 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_errorsOnOn ignore_repeated_errorsOffOff ignore_repeated_sourceOffOff ignore_user_abortOffOff implicit_flushOffOff include_path.;C:\php5\pear.;C:\php5\pear log_errorsOnOn log_errors_max_len10241024 magic_quotes_gpcOffOff magic_quotes_runtimeOffOff magic_quotes_sybaseOffOff mail.force_extra_parametersno valueno value max_execution_time3030 max_input_time6060 open_basedirno valueno value output_buffering40964096 output_handlerno valueno value post_max_size8M8M precision1414 realpath_cache_size16K16K realpath_cache_ttl120120 register_argc_argvOffOff register_globalsOffOff register_long_arraysOffOff report_memleaksOnOn report_zend_debugOnOn safe_modeOffOff safe_mode_exec_dirno valueno value safe_mode_gidOffOff safe_mode_include_dirno valueno value sendmail_fromno valueno value sendmail_pathno valueno value serialize_precision100100 short_open_tagOnOn SMTPlocalhostlocalhost smtp_port2525 sql.safe_modeOffOff track_errorsOnOn unserialize_callback_funcno valueno value upload_max_filesize2M2M upload_tmp_dirno valueno value user_dirno valueno value variables_orderGPCSGPCS xmlrpc_error_number00 xmlrpc_errorsOffOff y2k_complianceOnOn zend.ze1_compatibility_modeOffOff apache2handler Apache Version Apache/2.2.4 (Win32) PHP/5.2.0 Apache API Version 20051115 Server Administrator sergio.higuera@ca.schneider-electric.com Hostname:Port localhost:80 Max Requests Per Child: 0 - Keep Alive: on - Max Per Connection: 100 Timeouts Connection: 300 - Keep-Alive: 5 Virtual Server No Server Root C:/Apache22 Loaded Modules core mod_win32 mpm_winnt http_core mod_so mod_actions mod_alias mod_asis mod_auth_basic mod_authn_default mod_authn_file mod_authz_default mod_authz_groupfile mod_authz_host mod_authz_user mod_autoindex mod_cgi mod_dir mod_env mod_imagemap mod_include mod_isapi mod_log_config mod_mime mod_negotiation mod_setenvif mod_userdir mod_php5 DirectiveLocal ValueMaster Value engine11 last_modified00 xbithack00 Apache Environment VariableValue HTTP_ACCEPT image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, */* HTTP_ACCEPT_LANGUAGE en-us HTTP_ACCEPT_ENCODING gzip, deflate HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) HTTP_HOST localhost HTTP_CONNECTION Keep-Alive PATH C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\PHP;C:\PHP\ext;C:\MySQLSr5\bin 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 no value SERVER_SOFTWARE Apache/2.2.4 (Win32) PHP/5.2.0 SERVER_NAME localhost SERVER_ADDR 127.0.0.1 SERVER_PORT 80 REMOTE_ADDR 127.0.0.1 DOCUMENT_ROOT C:/Apache22/htdocs SERVER_ADMIN sergio.higuera@ca.schneider-electric.com SCRIPT_FILENAME C:/Apache22/htdocs/phpinfo.php REMOTE_PORT 1044 GATEWAY_INTERFACE CGI/1.1 SERVER_PROTOCOL HTTP/1.1 REQUEST_METHOD GET QUERY_STRING no value REQUEST_URI /phpinfo.php SCRIPT_NAME /phpinfo.php HTTP Headers Information HTTP Request Headers HTTP Request GET /phpinfo.php HTTP/1.1 Accept image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, */* Accept-Language en-us Accept-Encoding gzip, deflate User-Agent Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) Host localhost Connection Keep-Alive HTTP Response Headers X-Powered-By PHP/5.2.0 Keep-Alive timeout=5, max=99 Connection Keep-Alive Transfer-Encoding chunked Content-Type text/html libxml libXML support active libXML Version 2.6.26 libXML streams enabled odbc ODBC Supportenabled Active Persistent Links 0 Active Links 0 ODBC library Win32 DirectiveLocal ValueMaster Value odbc.allow_persistentOnOn odbc.check_persistentOnOn odbc.default_dbno valueno value odbc.default_pwno valueno value odbc.default_userno valueno value odbc.defaultbinmodereturn as isreturn as is odbc.defaultlrlreturn up to 4096 bytesreturn up to 4096 bytes odbc.max_linksUnlimitedUnlimited odbc.max_persistentUnlimitedUnlimited session Session Support enabled Registered save handlers files user Registered serializer handlers php php_binary wddx DirectiveLocal ValueMaster Value session.auto_startOffOff session.bug_compat_42OffOff session.bug_compat_warnOnOn session.cache_expire180180 session.cache_limiternocachenocache session.cookie_domainno valueno value session.cookie_httponlyOffOff session.cookie_lifetime00 session.cookie_path// session.cookie_secureOffOff session.entropy_fileno valueno value session.entropy_length00 session.gc_divisor10001000 session.gc_maxlifetime14401440 session.gc_probability11 session.hash_bits_per_character55 session.hash_function00 session.namePHPSESSIDPHPSESSID session.referer_checkno valueno value session.save_handlerfilesfiles session.save_pathno valueno value session.serialize_handlerphpphp session.use_cookiesOnOn session.use_only_cookiesOffOff session.use_trans_sid00 Additional Modules Module Name Environment VariableValue ALLUSERSPROFILE C:\Documents and Settings\All Users CommonProgramFiles C:\Program Files\Common Files COMPUTERNAME TEST-A72880BC08 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;C:\PHP;C:\PHP\ext;C:\MySQLSr5\bin PATHEXT .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH PROCESSOR_ARCHITECTURE x86 PROCESSOR_IDENTIFIER x86 Family 6 Model 8 Stepping 10, GenuineIntel PROCESSOR_LEVEL 6 PROCESSOR_REVISION 080a 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 1772 PHP Variables VariableValue _SERVER["HTTP_ACCEPT"]image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, */* _SERVER["HTTP_ACCEPT_LANGUAGE"]en-us _SERVER["HTTP_ACCEPT_ENCODING"]gzip, deflate _SERVER["HTTP_USER_AGENT"]Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) _SERVER["HTTP_HOST"]localhost _SERVER["HTTP_CONNECTION"]Keep-Alive _SERVER["PATH"]C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\PHP;C:\PHP\ext;C:\MySQLSr5\bin _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"]no value _SERVER["SERVER_SOFTWARE"]Apache/2.2.4 (Win32) PHP/5.2.0 _SERVER["SERVER_NAME"]localhost _SERVER["SERVER_ADDR"]127.0.0.1 _SERVER["SERVER_PORT"]80 _SERVER["REMOTE_ADDR"]127.0.0.1 _SERVER["DOCUMENT_ROOT"]C:/Apache22/htdocs _SERVER["SERVER_ADMIN"]sergio.higuera@ca.schneider-electric.com _SERVER["SCRIPT_FILENAME"]C:/Apache22/htdocs/phpinfo.php _SERVER["REMOTE_PORT"]1044 _SERVER["GATEWAY_INTERFACE"]CGI/1.1 _SERVER["SERVER_PROTOCOL"]HTTP/1.1 _SERVER["REQUEST_METHOD"]GET _SERVER["QUERY_STRING"]no value _SERVER["REQUEST_URI"]/phpinfo.php _SERVER["SCRIPT_NAME"]/phpinfo.php _SERVER["PHP_SELF"]/phpinfo.php _SERVER["REQUEST_TIME"]1170834058 Link to comment Share on other sites More sharing options...
shiguera Posted February 7, 2007 Author Share Posted February 7, 2007 And this is the php.ini file without much of the comments... Maybe someone can come up with a solution to the problem. ;;;;;;;;;;;;;;;;;;; ; About php.ini ; ;;;;;;;;;;;;;;;;;;; ; ; ;;;;;;;;;;;;;;;;;;; ; About this file ; ;;;;;;;;;;;;;;;;;;; ;;;;;;;;;;;;;;;;;;;; ; Language Options ; ;;;;;;;;;;;;;;;;;;;; ; Enable the PHP scripting language engine under Apache. engine = On ; Enable compatibility mode with Zend Engine 1 (PHP 4.x) zend.ze1_compatibility_mode = Off ; Allow the <? tag. Otherwise, only <?php and <script> tags are recognized. short_open_tag = On ; Allow ASP-style <% %> tags. asp_tags = Off ; The number of significant digits displayed in floating point numbers. precision = 14 ; Enforce year 2000 compliance (will cause problems with non-compliant browsers) y2k_compliance = On output_buffering = 4096 ; Note: output_handler must be empty if this is set 'On' !!!! ; Instead you must use zlib.output_handler. ;output_handler = ; Note: You need to use zlib.output_handler instead of the standard ; output_handler, or otherwise the output will be corrupted. zlib.output_compression = Off ;zlib.output_compression_level = -1 ;zlib.output_handler = implicit_flush = Off ; callback-function. unserialize_callback_func= serialize_precision = 100 allow_call_time_pass_reference = Off ; ; Safe Mode ; safe_mode = Off safe_mode_gid = Off safe_mode_include_dir = safe_mode_exec_dir = safe_mode_allowed_env_vars = PHP_ safe_mode_protected_env_vars = LD_LIBRARY_PATH ;open_basedir = disable_functions = disable_classes = ; realpath_cache_size=16k ; realpath_cache_ttl=120 ; expose_php = On ;;;;;;;;;;;;;;;;;;; ; Resource Limits ; ;;;;;;;;;;;;;;;;;;; max_execution_time = 30 ; Maximum execution time of each script, in seconds max_input_time = 60 ; Maximum amount of time each script may spend parsing request data memory_limit = 16M ; Maximum amount of memory a script may consume (16MB) ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ; Error handling and logging ; ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;error_reporting = E_COMPILE_ERROR|E_RECOVERABLE_ERROR|E_ERROR|E_CORE_ERROR ; ; - Show all errors, except coding standards warnings ; error_reporting = E_ALL ;display_errors = Off display_errors = On ;display_startup_errors = Off display_startup_errors = On log_errors = On log_errors_max_len = 1024 ignore_repeated_errors = Off ignore_repeated_source = Off report_memleaks = On ;report_zend_debug = 0 ; Store the last error/warning message in $php_errormsg (boolean). track_errors = On ;html_errors = Off ;docref_root = "/phpmanual/" ;docref_ext = .html ; String to output before an error message. ;error_prepend_string = "<font color=ff0000>" ; String to output after an error message. ;error_append_string = "</font>" ; Log errors to specified file. error_log = "c:\PHP\log\php_error.log" ; Log errors to syslog (Event Log on NT, not valid in Windows 95). ;error_log = syslog ;;;;;;;;;;;;;;;;; ; Data Handling ; ;;;;;;;;;;;;;;;;; ; ;arg_separator.output = "&" ;arg_separator.input = ";&" variables_order = "GPCS" register_globals = Off register_long_arrays = Off register_argc_argv = Off auto_globals_jit = On ; Maximum size of POST data that PHP will accept. post_max_size = 8M ; Magic quotes ; ; Magic quotes for incoming GET/POST/Cookie data. magic_quotes_gpc = Off ; Magic quotes for runtime-generated data, e.g. data from SQL, from exec(), etc. magic_quotes_runtime = Off ; Use Sybase-style magic quotes (escape ' with '' instead of \'). magic_quotes_sybase = Off ; Automatically add files before or after any PHP document. auto_prepend_file = auto_append_file = default_mimetype = "text/html" ;default_charset = "iso-8859-1" ; Always populate the $HTTP_RAW_POST_DATA variable. ;always_populate_raw_post_data = On ;;;;;;;;;;;;;;;;;;;;;;;;; ; Paths and Directories ; ;;;;;;;;;;;;;;;;;;;;;;;;; ; UNIX: "/path1:/path2" ;include_path = ".:/php/includes" ; ; Windows: "\path1;\path2" ;include_path = ".;c:\php\includes" ; The root of the PHP pages, used only if nonempty. ; if PHP was not compiled with FORCE_REDIRECT, you SHOULD set doc_root ; if you are running php as a CGI under any web server (other than IIS) ; see documentation for security issues. The alternate is to use the ; cgi.force_redirect configuration below doc_root = ; The directory under which PHP opens the script using /~username used only ; if nonempty. user_dir = ; Directory in which the loadable extensions (modules) reside. ;extension_dir = "c:\PHP\ext\" extension_dir = "C:\PHP\ext\" ; Whether or not to enable the dl() function. The dl() function does NOT work ; properly in multithreaded servers, such as IIS or Zeus, and is automatically ; disabled on them. enable_dl = On ; cgi.force_redirect is necessary to provide security running PHP as a CGI under ; most web servers. Left undefined, PHP turns this on by default. You can ; turn it off here AT YOUR OWN RISK ; **You CAN safely turn this off for IIS, in fact, you MUST.** ; cgi.force_redirect = 1 ; if cgi.nph is enabled it will force cgi to always sent Status: 200 with ; every request. ; cgi.nph = 1 ; cgi.redirect_status_env = ; ; fastcgi.impersonate = 1; ; Disable logging through FastCGI connection ; fastcgi.log = 0 ;cgi.rfc2616_headers = 0 ;;;;;;;;;;;;;;;; ; File Uploads ; ;;;;;;;;;;;;;;;; ; Whether to allow HTTP file uploads. file_uploads = On ; Temporary directory for HTTP uploaded files (will use system default if not ; specified). ;upload_tmp_dir = ; Maximum allowed size for uploaded files. upload_max_filesize = 2M ;;;;;;;;;;;;;;;;;; ; Fopen wrappers ; ;;;;;;;;;;;;;;;;;; ; Whether to allow the treatment of URLs (like http:// or ftp://) as files. allow_url_fopen = On ; Whether to allow include/require to open URLs (like http:// or ftp://) as files. allow_url_include = Off ; Define the anonymous ftp password (your email address) ;from="john@doe.com" ; Define the User-Agent string ; user_agent="PHP" ; Default timeout for socket based streams (seconds) default_socket_timeout = 60 ; auto_detect_line_endings = Off ;;;;;;;;;;;;;;;;;;;;;; ; Dynamic Extensions ; ;;;;;;;;;;;;;;;;;;;;;; ; ;extension=php_mbstring.dll ;extension=php_bz2.dll ;extension=php_curl.dll ;extension=php_dba.dll ;extension=php_dbase.dll ;extension=php_exif.dll ;extension=php_fdf.dll ;extension=php_filepro.dll ;extension=php_gd2.dll ;extension=php_gettext.dll ;extension=php_ifx.dll ;extension=php_imap.dll ;extension=php_interbase.dll ;extension=php_ldap.dll ;extension=php_mcrypt.dll ;extension=php_mhash.dll ;extension=php_mime_magic.dll ;extension=php_ming.dll ;extension=php_mssql.dll ;extension=php_msql.dll ; MySQL extension extension=php_mysql.dll ;extension=php_oci8.dll ;extension=php_openssl.dll ;extension=php_oracle.dll ;extension=php_pgsql.dll ;extension=php_shmop.dll ;extension=php_snmp.dll ;extension=php_sockets.dll ;extension=php_sqlite.dll ;extension=php_sybase_ct.dll ;extension=php_tidy.dll ;extension=php_xmlrpc.dll ;extension=php_xsl.dll ;;;;;;;;;;;;;;;;;;; ; Module Settings ; ;;;;;;;;;;;;;;;;;;; [Date] ; Defines the default timezone used by the date functions ;date.timezone = ;date.default_latitude = 31.7667 ;date.default_longitude = 35.2333 ;date.sunrise_zenith = 90.583333 ;date.sunset_zenith = 90.583333 [filter] ;filter.default = unsafe_raw ;filter.default_flags = [iconv] ;iconv.input_encoding = ISO-8859-1 ;iconv.internal_encoding = ISO-8859-1 ;iconv.output_encoding = ISO-8859-1 [sqlite] ;sqlite.assoc_case = 0 [xmlrpc] ;xmlrpc_error_number = 0 ;xmlrpc_errors = 0 [Pcre] ;pcre.recursion_limit=100000 ;pcre.backtrack_limit=100000 [syslog] ; Whether or not to define the various syslog variables (e.g. $LOG_PID, ; $LOG_CRON, etc.). Turning it off is a good idea performance-wise. In ; runtime, you can define these variables by calling define_syslog_variables(). define_syslog_variables = Off [mail function] ; For Win32 only. SMTP = localhost smtp_port = 25 ; For Win32 only. ;sendmail_from = me@example.com ;sendmail_path = ;mail.force_extra_parameters = [sql] sql.safe_mode = Off [ODBC] ;odbc.default_db = Not yet implemented ;odbc.default_user = Not yet implemented ;odbc.default_pw = Not yet implemented ; Allow or prevent persistent links. odbc.allow_persistent = On ; Check that a connection is still valid before reuse. odbc.check_persistent = On ; Maximum number of persistent links. -1 means no limit. odbc.max_persistent = -1 ; Maximum number of links (persistent + non-persistent). -1 means no limit. odbc.max_links = -1 ; Handling of LONG fields. Returns number of bytes to variables. 0 means ; passthru. odbc.defaultlrl = 4096 odbc.defaultbinmode = 1 [MySQL] ; Allow or prevent persistent links. mysql.allow_persistent = On ; Maximum number of persistent links. -1 means no limit. mysql.max_persistent = -1 ; Maximum number of links (persistent + non-persistent). -1 means no limit. mysql.max_links = -1 mysql.default_port = mysql.default_socket = ; Default host for mysql_connect() (doesn't apply in safe mode). mysql.default_host = ; Default user for mysql_connect() (doesn't apply in safe mode). mysql.default_user = mysql.default_password = ; Maximum time (in seconds) for connect timeout. -1 means no limit mysql.connect_timeout = 60 mysql.trace_mode = Off [MySQLi] ; Maximum number of links. -1 means no limit. mysqli.max_links = -1 mysqli.default_port = 3306 mysqli.default_socket = mysqli.default_host = mysqli.default_user = mysqli.default_pw = ; Allow or prevent reconnect mysqli.reconnect = Off [mSQL] ; Allow or prevent persistent links. msql.allow_persistent = On ; Maximum number of persistent links. -1 means no limit. msql.max_persistent = -1 ; Maximum number of links (persistent+non persistent). -1 means no limit. msql.max_links = -1 [PostgresSQL] ; Allow or prevent persistent links. pgsql.allow_persistent = On pgsql.auto_reset_persistent = Off ; Maximum number of persistent links. -1 means no limit. pgsql.max_persistent = -1 ; Maximum number of links (persistent+non persistent). -1 means no limit. pgsql.max_links = -1 pgsql.ignore_notice = 0 pgsql.log_notice = 0 [sybase] ; Allow or prevent persistent links. sybase.allow_persistent = On ; Maximum number of persistent links. -1 means no limit. sybase.max_persistent = -1 ; Maximum number of links (persistent + non-persistent). -1 means no limit. sybase.max_links = -1 ;sybase.interface_file = "/usr/sybase/interfaces" ; Minimum error severity to display. sybase.min_error_severity = 10 ; Minimum message severity to display. sybase.min_message_severity = 10 sybase.compatability_mode = Off [sybase-CT] ; Allow or prevent persistent links. sybct.allow_persistent = On ; Maximum number of persistent links. -1 means no limit. sybct.max_persistent = -1 ; Maximum number of links (persistent + non-persistent). -1 means no limit. sybct.max_links = -1 ; Minimum server message severity to display. sybct.min_server_severity = 10 ; Minimum client message severity to display. sybct.min_client_severity = 10 [bcmath] ; Number of decimal digits for all bcmath functions. bcmath.scale = 0 [browscap] ;browscap = extra/browscap.ini [informix] ; Default host for ifx_connect() (doesn't apply in safe mode). ifx.default_host = ; Default user for ifx_connect() (doesn't apply in safe mode). ifx.default_user = ; Default password for ifx_connect() (doesn't apply in safe mode). ifx.default_password = ; Allow or prevent persistent links. ifx.allow_persistent = On ; Maximum number of persistent links. -1 means no limit. ifx.max_persistent = -1 ; Maximum number of links (persistent + non-persistent). -1 means no limit. ifx.max_links = -1 ; If on, select statements return the contents of a text blob instead of its id. ifx.textasvarchar = 0 ; If on, select statements return the contents of a byte blob instead of its id. ifx.byteasvarchar = 0 ; Trailing blanks are stripped from fixed-length char columns. May help the ; life of Informix SE users. ifx.charasvarchar = 0 ; If on, the contents of text and byte blobs are dumped to a file instead of ; keeping them in memory. ifx.blobinfile = 0 ; NULL's are returned as empty strings, unless this is set to 1. In that case, ; NULL's are returned as string 'NULL'. ifx.nullformat = 0 [session] ; Handler used to store/retrieve data. session.save_handler = files ; ; session.save_path = "N;MODE;/path" ;session.save_path = "/tmp" ; Whether to use cookies. session.use_cookies = 1 ;session.cookie_secure = ; session.use_only_cookies = 1 ; Name of the session (used as cookie name). session.name = PHPSESSID ; Initialize session on request startup. session.auto_start = 0 ; Lifetime in seconds of cookie or, if 0, until browser is restarted. session.cookie_lifetime = 0 ; The path for which the cookie is valid. session.cookie_path = / ; The domain for which the cookie is valid. session.cookie_domain = session.cookie_httponly = ; Handler used to serialize data. php is the standard serializer of PHP. session.serialize_handler = php session.gc_probability = 1 session.gc_divisor = 1000 session.gc_maxlifetime = 1440 session.bug_compat_42 = 0 session.bug_compat_warn = 1 session.referer_check = ; How many bytes to read from the file. session.entropy_length = 0 ; Specified here to create the session id. session.entropy_file = ;session.entropy_length = 16 ;session.entropy_file = /dev/urandom session.cache_limiter = nocache ; Document expires after n minutes. session.cache_expire = 180 session.use_trans_sid = 0 ; Select a hash function ; 0: MD5 (128 bits) ; 1: SHA-1 (160 bits) session.hash_function = 0 session.hash_bits_per_character = 5 url_rewriter.tags = "a=href,area=href,frame=src,input=src,form=fakeentry" [MSSQL] ; Allow or prevent persistent links. mssql.allow_persistent = On ; Maximum number of persistent links. -1 means no limit. mssql.max_persistent = -1 ; Maximum number of links (persistent+non persistent). -1 means no limit. mssql.max_links = -1 ; Minimum error severity to display. mssql.min_error_severity = 10 ; Minimum message severity to display. mssql.min_message_severity = 10 ; Compatibility mode with old versions of PHP 3.0. mssql.compatability_mode = Off ; Connect timeout ;mssql.connect_timeout = 5 ; Query timeout ;mssql.timeout = 60 ; Valid range 0 - 2147483647. Default = 4096. ;mssql.textlimit = 4096 ; Valid range 0 - 2147483647. Default = 4096. ;mssql.textsize = 4096 ; Limits the number of records in each batch. 0 = all records in one batch. ;mssql.batchsize = 0 ;mssql.datetimeconvert = On ; Use NT authentication when connecting to the server mssql.secure_connection = Off ;mssql.max_procs = -1 ;mssql.charset = "ISO-8859-1" [Assertion] ; Assert(expr); active by default. ;assert.active = On ; Issue a PHP warning for each failed assertion. ;assert.warning = On ; Don't bail out by default. ;assert.bail = Off ; User-function to be called if an assertion fails. ;assert.callback = 0 ;assert.quiet_eval = 0 [COM] ; path to a file containing GUIDs, IIDs or filenames of files with TypeLibs ;com.typelib_file = ; allow Distributed-COM calls ;com.allow_dcom = true ; autoregister constants of a components typlib on com_load() ;com.autoregister_typelib = true ; register constants casesensitive ;com.autoregister_casesensitive = false ; show warnings on duplicate constant registrations ;com.autoregister_verbose = true [mbstring] ; language for internal character representation. ;mbstring.language = Japanese ; internal/script encoding. ; Some encoding cannot work as internal encoding. ; (e.g. SJIS, BIG5, ISO-2022-*) ;mbstring.internal_encoding = EUC-JP ; http input encoding. ;mbstring.http_input = auto ;mbstring.http_output = SJIS ;mbstring.encoding_translation = Off ;mbstring.detect_order = auto ;mbstring.substitute_character = none; ;mbstring.func_overload = 0 ; enable strict encoding detection. ;mbstring.strict_encoding = Off [FrontBase] ;fbsql.allow_persistent = On ;fbsql.autocommit = On ;fbsql.show_timestamp_decimals = Off ;fbsql.default_database = ;fbsql.default_database_password = ;fbsql.default_host = ;fbsql.default_password = ;fbsql.default_user = "_SYSTEM" ;fbsql.generate_warnings = Off ;fbsql.max_connections = 128 ;fbsql.max_links = 128 ;fbsql.max_persistent = -1 ;fbsql.max_results = 128 [gd] ;gd.jpeg_ignore_warning = 0 [exif] ;exif.encode_unicode = ISO-8859-15 ;exif.decode_unicode_motorola = UCS-2BE ;exif.decode_unicode_intel = UCS-2LE ;exif.encode_jis = ;exif.decode_jis_motorola = JIS ;exif.decode_jis_intel = JIS [Tidy] ;tidy.default_config = /usr/local/lib/php/default.tcfg tidy.clean_output = Off [soap] soap.wsdl_cache_enabled=1 soap.wsdl_cache_dir="/tmp" soap.wsdl_cache_ttl=86400 ; Local Variables: ; tab-width: 4 ; End: Link to comment Share on other sites More sharing options...
shoz Posted February 7, 2007 Share Posted February 7, 2007 This is a PHP-Installation issue and the following topic in the PHP-Installation forum addresses the problem you're having http://www.phpfreaks.com/forums/index.php/topic,87276.0.html Link to comment Share on other sites More sharing options...
shiguera Posted February 7, 2007 Author Share Posted February 7, 2007 ok, I pasted php.ini all over the place ( c:\windows; c\windows\system32) and neither one did the trick. I had already tried the rest of the suggestions. I think I'll just downgrade but which one should I downgrade? Apache? PHP? I downloaded the following: apache_1.3.37-win32-x86-no_src.msi php-4.4.4-Win32.zip Any suggestions? remember that I have installed: Apache2.2.4, PHP2.0 and MySQL5.0.27 Link to comment Share on other sites More sharing options...
shoz Posted February 7, 2007 Share Posted February 7, 2007 The thread I linked to has a link to a tutorial on how to get php's mysql extension working. The thread itself should be used to ask for additional help after going through the tutorial. Link to comment Share on other sites More sharing options...
wildteen88 Posted February 7, 2007 Share Posted February 7, 2007 I'm running Win XP sp2, installed apache 2.2.4 and PHP 5.2.0. Tested and work ok (the "It works!" page appears as well as the info from phpinfo.php). I then installed MySQL 5.0.27 and tested it alone, it works ok from the command line. BUT, did an http://localhost/phpinfo.php and there is no section on MySQL. Did a phpmyadmin and it says that it can't load MySQL. I checked for the usual things like the extension, the \ext directory, the PHP and MySQL/bin directories are in the PATH, etc., everything seems to be ok except that I don't have a copy of libmysql.dll in the system32 directory. I went ahead and enabled showing startup errors and I get a warning saying that the dynamic library module php_mysql.dll was not found, but the file is present and so is the libmysql.dll. I've been thinking about uninstalling MySQL and reinstalling again but first I want some advice from you. Please any idea(s) will be appreciated. If you have added PHP to the PATH then you dont need to move any files. Keep all files that came with PHP in PHP's installation folder. If you move files all over the place it causes complications. It is best to keep all files in one central place. When you added PHP to the path you will need to restart Windows in order for the changes to the PATH variable to come into effect. Now the problem you are having with the error is not to do with MySQL in any shape or form, but PHP's configuration. Due to changes from PHP4 to PHP5, PHP no longer comes with MySQL support enabled by default. Instead you have to enable the MySQL extension in the php.ini. I have setup a thread which tells you how to enable this extension, which is here. Also when ever you move or make any changes to configuration files related to the server (httpd.conf or php.ini) you must restart the server (Apache). Link to comment Share on other sites More sharing options...
Recommended Posts