Unable to detect MySQL support in PHP - Error

[DaveM]

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.

[aschk]

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.

[DaveM]

Ok I must admit I am not sure what you mean here, how do I compile PHP with MySQL,  ???

[aschk]

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

[DaveM]

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

 

 

[DaveM]

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  ???

[aschk]

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?

[DaveM]

It is in the root of my PHP folder php_mysqli.dll 88 KB 2008/02/21

[wildteen88]

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

[DaveM]

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?