DaveM Posted March 4, 2008 Share Posted March 4, 2008 I have hit a problem while installing SMF 1.1.4 Ok let me give a bit of background here. I am the host so I will be setting up the whole thing. I am using the following software WindowXP Pro SP2 Apache2.2 MySQL Server 5.0 PHP 5.2.5 Win32 Now I install all the software as instructed but when I come to setting up SMF I get the following error when running install.php. SMF Installer The installer was unable to detect MySQL support in PHP. Please ask your host to ensure that PHP was compiled with MySQL, or that the proper extension is being loaded. Click here to try this step again. Quote Link to comment https://forums.phpfreaks.com/topic/94226-unable-to-detect-mysql-support-in-php-error/ Share on other sites More sharing options...
aschk Posted March 4, 2008 Share Posted March 4, 2008 You haven't compiled PHP with MySQL, it really is that simple. Because you're using the Windows setup I expect that you haven't specified the modules inside your php.ini and don't have the extension in the ext directory. Quote Link to comment https://forums.phpfreaks.com/topic/94226-unable-to-detect-mysql-support-in-php-error/#findComment-482659 Share on other sites More sharing options...
DaveM Posted March 4, 2008 Author Share Posted March 4, 2008 Ok I must admit I am not sure what you mean here, how do I compile PHP with MySQL, ??? Quote Link to comment https://forums.phpfreaks.com/topic/94226-unable-to-detect-mysql-support-in-php-error/#findComment-482666 Share on other sites More sharing options...
aschk Posted March 4, 2008 Share Posted March 4, 2008 I know to do it on a linux based system but i'm afraid you're going to have to refer to documentation to answer your question regarding installing on Windows. Basically during PHP installation you need to specify the extensions that you're loading. http://uk3.php.net/install.windows should get you started Quote Link to comment https://forums.phpfreaks.com/topic/94226-unable-to-detect-mysql-support-in-php-error/#findComment-482671 Share on other sites More sharing options...
DaveM Posted March 4, 2008 Author Share Posted March 4, 2008 Here is my php.ini file ??? cannot upload it ??? So here are the MySQL parts out of it ;;;;;;;;;;;;;;;;;;;;;; ; Dynamic Extensions ; ;;;;;;;;;;;;;;;;;;;;;; ; ; If you wish to have an extension loaded automatically, use the following ; syntax: ; ; extension=modulename.extension ; ; For example, on Windows: ; ; // MySQL extension extension=php_mysql.dll [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 ; Default port number for mysql_connect(). If unset, mysql_connect() will use ; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the ; compile-time value defined MYSQL_PORT (in that order). Win32 will only look ; at MYSQL_PORT. mysql.default_port = ; Default socket name for local MySQL connects. If empty, uses the built-in ; MySQL defaults. 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 = ; Default password for mysql_connect() (doesn't apply in safe mode). ; Note that this is generally a *bad* idea to store passwords in this file. ; *Any* user with PHP access can run 'echo get_cfg_var("mysql.default_password") ; and reveal this password! And of course, any users with read access to this ; file will be able to reveal the password as well. mysql.default_password = ; Maximum time (in seconds) for connect timeout. -1 means no limit mysql.connect_timeout = 60 ; Trace mode. When trace_mode is active (=On), warnings for table/index scans and ; SQL-Errors will be displayed. mysql.trace_mode = Off [MySQLi] ; Maximum number of links. -1 means no limit. mysqli.max_links = -1 ; Default port number for mysqli_connect(). If unset, mysqli_connect() will use ; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the ; compile-time value defined MYSQL_PORT (in that order). Win32 will only look ; at MYSQL_PORT. mysqli.default_port = 3306 ; Default socket name for local MySQL connects. If empty, uses the built-in ; MySQL defaults. mysqli.default_socket = ; Default host for mysql_connect() (doesn't apply in safe mode). mysqli.default_host = ; Default user for mysql_connect() (doesn't apply in safe mode). mysqli.default_user = ; Default password for mysqli_connect() (doesn't apply in safe mode). ; Note that this is generally a *bad* idea to store passwords in this file. ; *Any* user with PHP access can run 'echo get_cfg_var("mysqli.default_pw") ; and reveal this password! And of course, any users with read access to this ; file will be able to reveal the password as well. 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 Quote Link to comment https://forums.phpfreaks.com/topic/94226-unable-to-detect-mysql-support-in-php-error/#findComment-482675 Share on other sites More sharing options...
DaveM Posted March 4, 2008 Author Share Posted March 4, 2008 I have gone through that documentation and it basically just tell me that MySQL is not loaded by default in this version. I already know that but cannot work out how to fix it ??? Quote Link to comment https://forums.phpfreaks.com/topic/94226-unable-to-detect-mysql-support-in-php-error/#findComment-482677 Share on other sites More sharing options...
aschk Posted March 4, 2008 Share Posted March 4, 2008 Where have you put the php_mysql.dll ? Usually I would expect this to be in the "ext" directory in your PHP install. Can you verify that this file is there? Quote Link to comment https://forums.phpfreaks.com/topic/94226-unable-to-detect-mysql-support-in-php-error/#findComment-482683 Share on other sites More sharing options...
DaveM Posted March 4, 2008 Author Share Posted March 4, 2008 It is in the root of my PHP folder php_mysqli.dll 88 KB 2008/02/21 Quote Link to comment https://forums.phpfreaks.com/topic/94226-unable-to-detect-mysql-support-in-php-error/#findComment-482685 Share on other sites More sharing options...
wildteen88 Posted March 4, 2008 Share Posted March 4, 2008 Add PHP to the PATH Environment Variable Also all extensions (file which start with php_) should be stored within the ext/ folder. Make sure the extension_dir directive is set to the full path to PHP ext/ folder Quote Link to comment https://forums.phpfreaks.com/topic/94226-unable-to-detect-mysql-support-in-php-error/#findComment-483325 Share on other sites More sharing options...
DaveM Posted March 5, 2008 Author Share Posted March 5, 2008 Ok I have PHP in the path that was one of the first things I did after the install. Now I think I may be seeing where it is all going wrong as I do not have “ext” folder in my install. Looking at the PHP.net I find that there are the following files that can be downloaded PHP 5.2.5 zip package [9,713Kb] - 08 November 2007 md5: a1e31c0d872ab030a2256b1cd6d3b7d1 PHP 5.2.5 installer [19,803Kb] - 15 November 2007 md5: f9396b654721d9a18c95ea6412c3d54e Note: Updated due to problems with the original installer for this release. PECL 5.2.5 Win32 binaries [2,879Kb] - 08 November 2007 md5: a3553b61c9332d08a5044cf9bf89f2df PHP 5.2.5 Non-thread-safe Win32 binaries [9,619Kb] - 08 November 2007 md5: 41ef1582f43cfdb6e546a626b9ef93d6 PECL 5.2.5 Non-thread-safe Win32 binaries [4,114Kb] - 08 November 2007 md5: 6e5ac694907b4aae080b2c9b6e83748a Note: (Most of these PECL extension files come standard with the PHP 4 Windows binaries, but have since been moved into this separate PECL download. Files such as php_pdf.dll, php_ssh2.dll, etc.) This one (PHP 5.2.5 installer) seems to be an installer version that has an executable file that seems to do it all. However when I install it and try and install SMF it tells me that php has not been configured in MySQL? If I take this one (PHP 5.2.5 zip package) it unzips to be a complete folder with all its sub folders, now I cannot see any installer in this one? I try and read the installation file and it tells me about some installer that I cannot find or know what they are talking about. So now do I need to use both the PHP 5.2.5 installer and PHP 5.2.5 zip package when doing the installation. If yes how do I do this, do I use the installer first and then copy the unzipped zip package into my now PHP installed folder under program Files PHP? Quote Link to comment https://forums.phpfreaks.com/topic/94226-unable-to-detect-mysql-support-in-php-error/#findComment-483534 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.