mysql 4.0.24 to mysql 4.1.12 upgrade problem

tuxrules · 07-16-2005, 02:16 PM

Hi everybody,

Last night i upgraded from mysql 4.0.24 to 4.1.12 from slackware current. After upgrade, I'm having problems with mysql.

PHPMyAdmin now gives me the following message when i try to administer mysql

Code:

cannot load mysql extension;
please check PHP configuration
Refer Documentation

I referred the documentation and it says.

Quote:

To connect to a MySQL server, PHP needs a set of MySQL functions called "MySQL extension". This extension may be part of the PHP distribution (compiled-in), otherwise it needs to be loaded dynamically. Its name is probably mysql.so or php_mysql.dll. phpMyAdmin tried to load the extension but failed.

Usually, the problem is solved by installing a software package called "PHP-MySQL" or something similar.

I've also checked php.ini file for "mysql.so" extension and it is not commented out.

I have also recompiled php taking cues from slackware php 5.0.4 package and adding couple more compile switches. Here's the compile i've used.

Quote:

./configure --prefix=/usr --disable-static --with-apxs=/usr/sbin/apxs --sysconfdir=/etc
--enable-discard-path --with-config-file-path=/etc/apache --enable-safe-mode --with-openssl
--with-mhash --enable-bcmath --with-bz2 --with-pic --enable-calendar --enable-ctype
--with-gdbm --with-db3 --enable-dbase --enable-ftp --with-iconv --with-exif --enable-exif
--with-gd --enable-gd-native-ttf --with-jpeg-dir=/usr --with-png --with-gmp --with-mysql=shared,/usr --with-mysqli=/usr/bin/mysql_config --with-mysql-sock=/var/run/mysql --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 --enable-yp --with-libxml-dir=/usr --enable-sqlite-utf8 --enable-mbstring

Should i be using the two mysql switches highlighted above?

After all this, i'm getting the phpmyadmin error i mentioned before. I'm stumped at this now. I'll appreciate if someone knows this and can help me out.

Also if you read the quote on this post, the possible answers mentions a "PHP-MyQSL" package
to install to get rid of this error. Where can i find this package, if it exists?

Thanks
Tux,

Nathanael · 07-16-2005, 02:28 PM

check the php.ini file ans see if the mysql extention gets loaded twice!

tuxrules · 07-16-2005, 02:38 PM

Nope, it's not getting loaded twice.

Nathanael · 07-16-2005, 02:48 PM

check the extention file is in the right location?

tuxrules · 07-16-2005, 03:15 PM

Thanks for the reply Nathanael, I was actually trying to find out the same thing. I figured out that extension were in /usr/lib/php/extensions/no-debug-no-zts-20041030 directory instead of /usr/lib/php/extensions.

I actually then made a symlink of mysql.so into /usr/lib/php/extensions. Now i can use phpmyadmin. However, I have a new problem. I also run a webserver with php and mysql. I'm using wordpress and openbook. After the upgrade (and now that i'm able to use phpmyadmin), wordpress is complaining that

Quote:

Your PHP installation appears to be missing the MySQL which is required for WordPress.

I've checked the php configuration via web and i see that php is recognizing mysqli support.

Tux,

Nathanael · 07-16-2005, 04:02 PM

i have no idea what wordpress is, but could there be some version issues? ie: wordpress expecting to find mysql 4.0 and not 4.1?

tuxrules · 07-16-2005, 04:06 PM

Wordpress is a php based blogging software. I however, tried reading the mysql error log and found that I needed to fix table privileges. The new mysql installation came with a script to do that.

# /usr/bin/mysql_fix_privilege_tables

I ran that script but it was giving me the same error and was kinda pissing me off. In a moment of desperation, I decided to reboot...and voila!!! after reboot everything works. I have no idea why that reboot worked since I'd tried restarting mysql server to no avail.

Anyway I would like to thank you for taking time and helping me solve this thing

Thanks again Nathanael

Tux

php4u · 08-13-2005, 06:43 PM

need help with a recent install of phpMyAdmin. It was working for several weeks, then stopped. The versions include;
PHP 4.3.9 (cgi) (built: Jul 7 2005 21:38:20)
mysql Ver 14.7 Distrib 4.1.10a, for redhat-linux-gnu (i686)
phpMyAdmin 2.6.3-pl1
Server version: Apache/2.0.52
...SeLinux is disabled

phpinfo = --with-mysql=shared,/usr

When I try to pull up the phpMyAdmin index page, I get the following error;
cannot load mysql extension;

I do not see any errors in the messages, access, or error logs.

I have configured this application many times before with much success...this one has me stumped.

Thank you in advance for any suggestions!
Ralph