Hello,

I have a weird problem concerning MySQL 4.1.7. I had a working system with Apache 1.3.32, PHP 5.02 and MySQL 4.0.20. Everything worked (also phpMyAdmin). Because the PHP version was compiled with shared libraries, I had to compile MySQL from source with the appropriate flag and installed it with checkinstall.

Now I wanted to upgrade MySQL to the latest stable release (4.1.7). I removed the MySQL package with removepkg, deleted the /usr/local/mysql folder and compiled MySQL 4.1.7 from source. Everything went fine. I then created the grant tables with

/usr/local/mysql/bin/mysql_install_db

The path to the dynamic libraries in /etc/ld.so.conf already existed

/usr/local/mysql/libmysql

so I didn't do anything with that (in the end I even ran ldconfig again just to be sure =)). PHP should also be configured (as I mentioned above, I already had a running installation). I have the following lines in /etc/apache/php.ini:

extension_dir = "/usr/lib/php/extensions/"
extension=mysql.so

The file mysql.so also exists in /usr/lib/php/extensions/ and is also executable:

-rwxr-xr-x 1 root root 44828 Sep 25 15:19 mysql.so*

But the problem is whenever I try to run phpMyAdmin I get the following error:

cannot load mysql extension,
please check PHP Configuration
Documentation

phpinfo() also doesn't show MySQL anymore. The server is running correctly. I can also access it with other languages, for example with Java and JDBC. No errors there.

I really have no clue what's missing, especially because everything worked before the upgrade. I also looked through the MySQL manual, but couldn't find anything related to my problem. Maybe someone can help me with that. Thanks a lot =).

Lars

Have you restarted apache since the mysql install?

Thanks for the fast reply. Yes I did. It wasn't running during the whole process.

Forgot something. These are the flags with which I compiled MySQL:

./configure --prefix=/usr/local/mysql --enable-shared --enable-static --with-embedded-server

Maybe it has something to do with, even though I used the same for the old version that worked.

I guess I know what's wrong. After some more reading I found out that MySQL 4.1.x doesn't use the mysql-extension but the mysqli-extension. I always upgraded my PHP versions with the packages from linuxpackages. I'm afraid they are not compiled with mysqli-support. So I think I have to compile PHP from source.

Thanks anyway.