php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #28285 php_mysql.dll unclear on module installation
Submitted: 2004-05-05 16:37 UTC Modified: 2008-06-22 17:55 UTC
Votes:14
Avg. Score:4.7 ± 0.7
Reproduced:13 of 14 (92.9%)
Same Version:9 (69.2%)
Same OS:4 (30.8%)
From: pburden98 at yahoo dot com Assigned:
Status: Not a bug Package: *Configuration Issues
PHP Version: 5.0.0RC2 OS: windows 98 2nd Edition
Private report: No CVE-ID: None
 [2004-05-05 16:37 UTC] pburden98 at yahoo dot com
Description:
------------
Standard installation of php5 works with apache how ever I am trying to enable c:\php\ext\php_mysql.dll

Chosen path of installation as follows

1) Installed php5rc2

1.1 unzip into directory c:\php
1.1 copied "c:\php\php-php.ini-dist" to "C:\Program Files\Apache Group\Apache\php.ini"
1.2 edited php.ini 
1.2.1 changed line 'extension_dir = "./"' to extension_dir = "c:\php\ext\"

2) Setup Apache with php5rc2
2.1 copied "c:\php\php5ts.dll" to "C:\Program Files\Apache Group\Apache\php5ts.dll"
2.2 added the following lines to "C:\Program Files\Apache Group\Apache\conf\httpd.conf"
   ---start of new lines added to httpd.conf---
   LoadModule php5_module c:/php/php5apache.dll
   AddModule mod_php5.c
   AddType application/x-httpd-php .php
   ---end of new lines added to httpd.conf---

3) Set up test environment on Apache so I check php5 works
3.1 I set up a "virtualhost 192.168.0.5:8081" on apache

---Start of new lines in httpd.conf---
Listen *:8081
<VirtualHost 192.168.0.5:8081>
DocumentRoot /phpco/www/
ServerName pjb
DirectoryIndex index.html index.htm index.php
</VirtualHost>
---End of new lines in httpd.conf---

3.2 I set up a file index.php in the directory

---start contents of index.php---
<HTML>
hi from apache<BR>
<?php echo "hi from php5rc2"; ?>
</HTML>
---end contents of index.php---
3.3 I setup phpinfo.php too 
  <?php phpinfo(); ?>
3.4 Restarted the apache.  No problems accept for (exec() command not found 'bug in apache'). saw the message

"Apache/1.3.29 (Win32) PHP/5.0.0RC2 running..."

4 Tested the PHP5
4.1 Visited the site "http://192.168.0.5:8081/"
  ---OUTPUT on mozilla 1.6---
   hi from apache
   hi from php5rc2
   ---OUTPUT on mozilla 1.6---
4.2 Also done a phpinfo.php
  Out i saw looked fine.

5 Enabled mysql extension
5.1 uncommented line 565 
   "extension=php_mysql.dll"
6 verified there is no more required dll files to be installed
6.1 I checked the INSTALL notes on any other dll files required for the mysql extension to run [nothin]
6.2 I checked the php.net manuals on dll files to be installed [nothing]

7 Restarted apache

8 Verified it wasnt any dlls required by old distrobution
8.1 I reported the following 
http://bugs.php.net/bug.php?id=28255

SOFTWARE THAT WORKS
===================
windows98 box
--------------
SOFTWARE USED (sorted by Installed order)
1 Mozilla 1.6 [binary edition] works
2 MySQL server version: 4.0.18 [binary edtion] works
3 Apache/1.3.29 [binary edtion] works
4 php5.0.0rc2 [binary edition] works but with no extensions


linux box (stable all works, I have lots projects that work)
--------- 
PHP Version 4.2.2 [compiled by redhat team version9 386] works
Apache httpd-2.0.40-21.9 [compiled by redhat team version9 386] works
MySQL server version: 4.0.18-standard [compiled by me] works



Expected result:
----------------
Expected it to run or explain what is missing.

Actual result:
--------------
Error reported when loading php5
----Start of error----
PHP Warning:  PHP Startup: Unable to load dynamic library '/php/ext/php_mysql.dll' - A device attached to the system is not functioning. in Unknown on line 0
----End of error----

This is unclear.  And I wanted to use php5 to connect to my linux box.  I dont know what php5 wants for me to use the mysql functions in php.

I have done the following to try and fix the problem
1) STFW (Searched the fantastic web)
1.1 Found out it could be a DLL file problem not loaded or not part of the system 
1.2 Found out that php_mssql.dll has been reported on the BUG database for php4.  Was closed due to not enought information.
1.3 http://blogs.phparch.com/mt/archives/000025.html
  explains about copying the dlls.  I could not do this test because
"http://bugs.php.net/bug.php?id=28255"

1.4 Tried to see if I get this new mysqli working
http://www.zend.com/manual/ref.mysqli.php
1.4.1 Couldnt has im working with a binary edition

2) Verified the following dll files (libMySQL.dll,php_mysql.dll)


2.1 I tried placing the php_mysql.dll in different places
   apache directory
   c:\windows\system directory

3) Verified latest MDAC is installed as requested by INSTALL (this maybe another bug)
3.1 Downloaded mdac 2.8 from microsoft.com

4) Verified mysql works on windows

5) Verified php works

6) Verified apache works

7) Retraced my steps with other developers on irc

---END OF ACTUAL RESULTS

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2004-05-08 10:28 UTC] noreply at brutex dot de
What I found out, that might be of interest:

If you do a correct setup of PHP5.0.0RC2 and then you try to enable php_mysql extension it says to me at loading
"Prozedureinsprungpunkt nicht gefunden". Found some google results of similar problems.
To me it seems there is an error in libMySQL.dll, however it is the same with php_mysqli.dll.

I am using Win2000 with apache. The error occours when I startup apache.
 [2004-05-13 19:29 UTC] edink@php.net
Please try these simplified instructions (and don't copy any files anywhere except for php.ini).

1. Unpack snap to say c:\php
2. Make sure c:\php is in your system path
3. Adjust apache config accordingly (load c:\php\php5apache.dll directly)

This should work. Please remember to remove any remains of old php installs.

 [2004-05-21 01:00 UTC] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
 [2006-08-26 15:22 UTC] charles dot wicksteed at lycos dot com
I have reproduced this problem with Windows 98, and have some more information to put into the documentation.  In the Apache error log:

PHP Warning:  PHP Startup: Unable to load dynamic library 'd:\\php\\ext\\php_mysql.dll' - A device attached to the system is not functioning.\r\n in Unknown on line 0

Environment: 
  Apache/2.0.54 (Win32) PHP/5.1.6
  Windows 98 (4.10.1998)

I followed all the instructions about setting my PATH (C:\WINDOWS;C:\WINDOWS\COMMAND;D:\PHP).
Command line PHP loads the MySQL extension OK (comes up in phpinfo).
It works if I copy libmysql.dll to Apache's bin directory, so that is my chosen workround.
It looks as though this version of Windows does not use the PATH for DLLs, but looks in the directory where the original executable (apache.exe) lives.
I expect it would have worked if I had copied the DLL to the central DLL location, which is C:\WINDOWS\SYSTEM on Windows 98, but I don't want to do that.

This is a documentation problem, affecting Windows 98 users.
 [2007-02-08 02:26 UTC] sprite at zatokapucka dot pl
I've expierienced the same problem with PHP 5.0.5 and 5.2.0 on Windows XP and Apache 2.0.48. I'be installed recently some programming stuff (Delphi 2005, .NET SDK and some other) and after restart I've got warnings:

PHP Warning:  PHP Startup: Unable to load dynamic library 'c:\\Program Files\\php\\ext\\php_mysql.dll' - Nie mo\xbfna odnale\x9f\xe6 okre\x9clonego modu\xb3u.\r\n in Unknown on line 0

Copy libmysql.dll to Apache's bin directory solved the problem for me too. Thanks for your comments!
 [2007-03-25 18:52 UTC] _saber_ at mail dot ru
hi
error on start apache2
log..

PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\\php5\\php_mysql.dll' - \xcd\xe5 \xed\xe0\xe9\xe4\xe5\xed \xf3\xea\xe0\xe7\xe0\xed\xed\xfb\xe9 \xec\xee\xe4\xf3\xeb\xfc.\r\n in Unknown on line 0
[Mon Mar 26 02:49:07 2007] [notice] Apache/2.0.59 (Win32) PHP/5.1.2 configured -- resuming normal operations
[Mon Mar 26 02:49:07 2007] [notice] Server built: Jul 27 2006 15:55:03
[Mon Mar 26 02:49:07 2007] [notice] Parent: Created child process 2360
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\\php5\\php_mysql.dll' - \xcd\xe5 \xed\xe0\xe9\xe4\xe5\xed \xf3\xea\xe0\xe7\xe0\xed\xed\xfb\xe9 \xec\xee\xe4\xf3\xeb\xfc.\r\n in Unknown on line 0
[Mon Mar 26 02:49:07 2007] [notice] Child 2360: Child process is running
[Mon Mar 26 02:49:07 2007] [notice] Child 2360: Acquired the start mutex.
[Mon Mar 26 02:49:07 2007] [notice] Child 2360: Starting 250 worker threads.
 [2008-06-22 17:23 UTC] phpbugreport at southportnews dot com
On windows 2000 , This bug started happening for me
"PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\\PHP\\ext\\php_mysql.dll' - The specified module could not be found.\r\n in Unknown on line 0"

Turned out that I needed my 'User variables' Path to include 'C:/php'
rather than the 'System Variables' section of the Environment variables.


I'd installed something that screwed up my paths.
 [2008-06-22 17:55 UTC] pajoye@php.net
It is well explained in the documentation.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Mar 28 22:01:26 2024 UTC