MySQL Extension for PHP4

Aurorius · 02-09-2007, 04:59 AM

Hello everyone..

I've been trying to load my phpMyAdmin for the past few hours but failed because it says "Cannot load mysql extension". I'm using packages from linuxpackages.net (php-4.4.4-i486-3.tgz and mysql-4.1.14-i486-1.tgz).

Configure commands from phpinfo

Quote:

./configure' '--prefix=/usr' '--disable-static' '--with-apxs=/usr/sbin/apxs' '--enable-discard-path' '--sysconfdir=/etc' '--with-config-file-path=/etc/apache' '--enable-safe-mode' '--with-openssl' '--with-ldap' '--with-mhash' '--enable-bcmath' '--with-bz2' '--with-pic' '--enable-calendar' '--enable-ctype' '--with-gdbm' '--with-db4' '--with-imap-ssl=/usr/local/lib/c-client' '--with-imap=/usr/local/lib/c-client' '--enable-dbase' '--enable-ftp' '--with-iconv' '--with-dom' '--with-exif' '--enable-exif' '--with-gd' '--enable-gd-native-ttf' '--with-jpeg-dir=/usr' '--with-png' '--with-ttf' '--with-freetype-dir=/usr' '--with-gmp' '--enable-mbstring' '--with-curl=/usr' '--with-pcre-regex=/usr' '--with-mysql=shared,/usr' '--with-gettext=shared,/usr' '--with-expat-dir=/usr' '--with-xml' '--enable-wddx' '--with-mm=/usr' '--enable-trans-sid' '--enable-shmop' '--enable-sockets' '--with-regex=php' '--enable-sysvsem' '--enable-sysvshm' '--enable-yp' '--enable-memory-limit' '--with-tsrm-pthreads' '--enable-shared' '--disable-debug' '--with-zlib=/usr'

I've been searching from this forum and tried various things, but still failed. I've even tried compiling php myself, but it gets weirder. Could anyone please help ?

allend · 02-09-2007, 07:26 AM

I have no experience with this, but the message suggests that the problem lies with communication with MySQL. Have you configured your system to start the MySQL daemon?

GrapefruiTgirl · 02-09-2007, 08:25 AM

I see you have PHP configured to work with MySQL, but have you got MySQL installed/activated in your Apache installation?
Hopefully yes, but if not, make sure you have uncommented the MySQL (and) MySQLi Apache modules, and have set the port (default=3306), and restart Apache to re-read the httpd.conf.
It's been a couple months since I dealt with MySQL config, but I hope this helps a bit.

SV
PS- Check the Apache.org website and MySQL.net for further details.

Aurorius · 02-09-2007, 08:35 AM

I just tried reinstalling all those packages.. this time using packages from slackware website. Still not working.

Quote:

Originally Posted by allend

I have no experience with this, but the message suggests that the problem lies with communication with MySQL. Have you configured your system to start the MySQL daemon?

I can assure you that I've started the daemon. I can query the database. I just can't load the extension for PHP. I can't find mysql section in phpinfo even though the configure command did put --with-mysql.

Quote:

Originally Posted by GrapefruiTgirl

I see you have PHP configured to work with MySQL, but have you got MySQL installed/activated in your Apache installation?
Hopefully yes, but if not, make sure you have uncommented the MySQL (and) MySQLi Apache modules, and have set the port (default=3306), and restart Apache to re-read the httpd.conf.
It's been a couple months since I dealt with MySQL config, but I hope this helps a bit.

SV
PS- Check the Apache.org website and MySQL.net for further details.

I don't think my PHP has been configured to work with MySQL because there's no MySQL section in my phpinfo(); I thought Apache has nothing to do with MySQL (at least for this case) ? But I'll check the docs.

GrapefruiTgirl · 02-09-2007, 12:48 PM

Yeah, apache does have 'something' to do with MySQL, more-so perhaps than PHP does. Basically, PHP is the go-between between MySQL and Apache, in the majority of server applications. It will be you or your users accessing the MySQL data, either directly or indirectly. Directly,as an example, is with a website which uses a database; and indirectly is where something behind the scenes, like a user/password database with which the server (Apache) verifies users' identities.
MySQL is like a large extension of the Apache server in these cases.
You need the MySQL modules in the PHP setup, you are correct. But also, MySQL/MySQLi has to be enabled in Apache in order to interact with the database.