MySQL extension for PHP 5.2.3 not working

Printable View

Show 100 post(s) from this thread on one page

12-06-2007, 10:55 PM
Jerrythafast

MySQL extension for PHP 5.2.3 not working

Hey everyone,

Today I felt like getting rid of the Apache2Triad server bundle (which includes many servers I never use) and decided to install fresh installations of Apache 2.2, MySQL 5.0.41 and PHP 5.2.3 (all latest versions, according to their sites). But there is one thing not working properly: MySQL in PHP.

Apache install information
I installed the Apache 2.2 server to C:\Program Files\Apache 2.2. I didn't install the documentation, because if I use it, the online documentation is usually more up-to-date. The root directory you see when going to http://localhost (http://84.107.204.56 for you guys ;p) is C:\Program Files\Apache 2.2\htdocs.

MySQL install information
I installed the MySQL 5.0.41 server to C:\Program Files\MySQL Server 5.0. I installed all the 'Client Programs' (Command Line Shell, Command Line Utilities and Server Instance Config) and the 'Instance Manager' and left out the Documentation and Developer Components.

PHP install information
I installed PHP 5.2.3 to C:\Program Files\PHP. In the setup options, I selected both 'CLI Executable' and 'Script Executable', the Web Server Setup for Apache 2.2.x and the extentions GD2 (which is working just fine) and MySQL. My php.ini file is located in the PHP root directory (see above). Extension_dir is set to /ext in the PHP root directory. The php_mysql.dll file is in /ext in the PHP root directory and is uncommented (un-semi-colon-ed ;p lol) in php.ini, just like the php_gd2.dll file. There is a file libmysql.dll in the PHP root directory. Before you ask so, I did restart the Apache server. You can find all information provided by phpinfo() in http://84.107.204.56/phpinfo.php (only when my computer is online, of course, which it will be in around 10 hours from now).

I'm quite sure it's the MySQL extension which is not working, because:
-It is nowhere mentioned in phpinfo() (but GD2 is...)
-I'm getting the following error in phpMyAdmin: "Cannot load mysql extension. Please check your PHP configuration."
-I'm getting the following error in my phpBB2 testing board (which will be kinda empty as I forgot to export the database before uninstalling Apache2Triad ;p): "Fatal error: Call to undefined function mysql_connect() in C:\Program Files\Apache 2.2\htdocs\phpBB2\db\mysql4.php on line 48."

I hope there's anyone around who can help me find the problem, as I can't find it myself after trying all kinds things for about an hour and a half.

Thanks in advance for any replies,
Jerry
12-06-2007, 11:20 PM
awm

Its been a while since I did a MySQL install but I recall that newer versions of PHP do not load it by default. If it doesn't show up when you call phpinfo(); make sure you have the ini file set to load the .dll (or whatever it is on Windoze, its been even longer for me doing a Windows install).
12-06-2007, 11:34 PM
alsenior

have you installed myodbc connector and set it up? it is a seperate install package
13-06-2007, 12:36 AM
awm

The MyODBC is not needed. He wants the MySQL plugin directly. Reading more carefully I could suggest verifying the MySQL thinggy is right for the version you have. Can you find any logs for apache/php startup that complain about anything?
13-06-2007, 01:13 AM
Budding

Have you started the MySQL service? You might want to run the MySQL Configuration Wizard which is located in your MySQL installation folder.
13-06-2007, 09:55 AM
awm

Its got be more than that. Now that the phpinfo(); stuff is up its clear that the dll isn't loading. Can you copy your .ini file, rename it .txt and give us a link, thanks.
13-06-2007, 01:23 PM
Jerrythafast

Quote:

Originally Posted by awm

Its been a while since I did a MySQL install but I recall that newer versions of PHP do not load it by default. If it doesn't show up when you call phpinfo(); make sure you have the ini file set to load the .dll (or whatever it is on Windoze, its been even longer for me doing a Windows install).

1) You are right it's not loaded by default (in fact, it's not even installed by default).
2) As said, the php.ini file contains a referance to the MySQL dll file, and it's not commented out.

Quote:

Originally Posted by alsenior

have you installed myodbc connector and set it up? it is a seperate install package

==>

Quote:

Originally Posted by awm

The MyODBC is not needed. He wants the MySQL plugin directly. Reading more carefully I could suggest verifying the MySQL thinggy is right for the version you have. Can you find any logs for apache/php startup that complain about anything?

I just tried to find a log complaining about something, and I got this from the Apache error log:

Code:

[Wed Jun 13 09:23:43 2007] [notice] Apache/2.2.4 (Win32) PHP/5.2.3 configured -- resuming normal operations [Wed Jun 13 09:23:43 2007] [notice] Server built: Jan 9 2007 23:17:20 [Wed Jun 13 09:23:43 2007] [notice] Parent: Created child process 920 PHP Warning: PHP Startup: Unable to load dynamic library 'C:\\Program Files\\PHP\\ext\\php_mysql.dll' - Kan opgegeven procedure niet vinden.\r\n in Unknown on line 0 [Wed Jun 13 09:23:43 2007] [notice] Child 920: Child process is running [Wed Jun 13 09:23:43 2007] [notice] Child 920: Acquired the start mutex. [Wed Jun 13 09:23:43 2007] [notice] Child 920: Starting 250 worker threads. [Wed Jun 13 09:23:43 2007] [notice] Child 920: Starting thread to listen on port 80.

"Kan opgegeven procedure niet vinden" is Dutch for "Can't find selected procedure".

Quote:

Originally Posted by Budding

Have you started the MySQL service? You might want to run the MySQL Configuration Wizard which is located in your MySQL installation folder.

mysqld-nt.exe is running, I think that's the service. In services.msc MySQL 5 shows up as 'Gestart' (Started). I have run the Configruation Wizard directly after installation.

Quote:

Originally Posted by awm

Its got be more than that. Now that the phpinfo(); stuff is up its clear that the dll isn't loading. Can you copy your .ini file, rename it .txt and give us a link, thanks.

http://84.107.204.56/php.txt
13-06-2007, 01:28 PM
awm

Switch to the mysqli extension (next line after mysql) its the improved version. Also make sure the extension matches with you install version. If the mysql install came with a php extension use that. Best of luck!
13-06-2007, 02:55 PM
Jerrythafast

Installed MySQLi extension through the PHP installer and checked if php.ini was updated correctly and the file was present. Restarted Apache. The php.txt file has also been updated. Things stil don't work.

Error log now says:

Code:

[Wed Jun 13 15:49:36 2007] [notice] Parent: Received restart signal -- Restarting the server. [Wed Jun 13 15:49:36 2007] [notice] Child 920: Exit event signaled. Child process is ending. [Wed Jun 13 15:49:37 2007] [notice] Child 920: Released the start mutex [Wed Jun 13 15:49:40 2007] [notice] Child 920: Waiting for 250 worker threads to exit. [Wed Jun 13 15:49:40 2007] [notice] Child 920: All worker threads have exited. [Wed Jun 13 15:49:40 2007] [notice] Child 920: Child process is exiting [Wed Jun 13 15:49:40 2007] [notice] Apache/2.2.4 (Win32) PHP/5.2.3 configured -- resuming normal operations [Wed Jun 13 15:49:40 2007] [notice] Server built: Jan 9 2007 23:17:20 [Wed Jun 13 15:49:41 2007] [notice] Parent: Created child process 2704 PHP Warning: PHP Startup: Unable to load dynamic library 'C:\\Program Files\\PHP\\ext\\php_mysql.dll' - Kan opgegeven procedure niet vinden.\r\n in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library 'C:\\Program Files\\PHP\\ext\\php_mysqli.dll' - Kan opgegeven procedure niet vinden.\r\n in Unknown on line 0 [Wed Jun 13 15:49:41 2007] [notice] Child 2704: Child process is running [Wed Jun 13 15:49:41 2007] [notice] Child 2704: Acquired the start mutex. [Wed Jun 13 15:49:41 2007] [notice] Child 2704: Starting 250 worker threads. [Wed Jun 13 15:49:41 2007] [notice] Child 2704: Starting thread to listen on port 80.

There is only one dll file in the MySQL directory, it's /bin/libmySQL.dll. It's entirely different from the one in the PHP directory. I tried to replace the one that came with PHP with the one that came with MySQL (restarted Apache) but this also didn't work.
13-06-2007, 03:02 PM
Jerrythafast

Lol now it's working. Now that I know what PHP writes to the error log, I tried searching that instead of 'Call to undefined function'. I ended on this page:
http://www.cementhorizon.com/wiki/in...d_not_be_found.

It says that, though the PHP directory is in the Paths it's still required to put the libmyql.dll file in the system32 direcory. If there is any solution to this, so that I can leave it in the PHP directory, I'd like to know as I prefer to have things in their 'normal' folders ;p
13-06-2007, 03:42 PM
Jerrythafast

Okay, now I ran into another problem. When I try to set up phpMyAdmin it complains about the files not being writeable. As I'm running Windows, I can't CHMOD the folder. Everyone everywhere is saying just the same three words: rightclick properties security. Even the phpMyAdmin documentation says the same three words. However, there is no Security tab/button/link/whatever anywhere in the properties window :O_o1: The only option Windows gives me, is to share it with other computers inside the LAN.

WTH?:confused:
13-06-2007, 03:43 PM
Budding

Do you actually have the php_mysql.dll and php_mysqli.dll in your PHP/ext folder?? Seems to me you are missing those files.
If you are, then you need to download the bigger PHP installation binary file as opposed to the windows executable, and copy the correct libraries into your /ext/ folder. All the extension libraries will be located in the binary.

Edit: above is reply to your previous previous post

Which files is it saying that is not writable? Perhaps it's the database access rights in MySQL that need to be modified instead of the actual files in Windows. If you want to change file permission in Windows, it's right click>Properties>Attributes
13-06-2007, 04:09 PM
Jerrythafast

Quote:

Originally Posted by Budding

Which files is it saying that is not writable? Perhaps it's the database access rights in MySQL that need to be modified instead of the actual files in Windows. If you want to change file permission in Windows, it's right click>Properties>Attributes

phpMyAdmin says
"Please create web server writable folder config in phpMyAdmin toplevel directory as described in documentation. Otherwise you will be only able to download or display it."
When clicking on the word 'documentation' I get information on how to CHMOD things on Linux/Unix and a link to FAQ #1.26 which contains the three words.

The attribute Write Only is not selected on any file.
13-06-2007, 04:57 PM
awm

Are you running Windows Home edition. Those sometimes hide all the permissions stuff.
13-06-2007, 05:08 PM
Jerrythafast

Yeh, I am. Is there any way to unhide it?
13-06-2007, 05:13 PM
awm

I'm not sure. I just have a Mac now. I just remember that was a problem. I'd suggest Google.

Show 100 post(s) from this thread on one page