[TriLUG] SUSE LAMP Server problems with PHPMyAdmin

[Craig Duncan]

Brian Blater (BBList) wrote:

>I have a SLES 9 box that I have upgraded to Apache2-2.0.54, MySQL 4.1.19 and PHP 5.1.4. Everything appears to be working correctly. However, I installed phpmyadmin on the box and when I access phpmyadmin it gives me an error that it "cannot load mysql extension." From what I can tell this means it cannot find the mysql.so.
>
>Sure enough I cannot find the mysql.so file anywhere on the system. On another SLES9 box (this hasn't been upgraded from the default versions installed with SLES so it is Apache2-2.0.49, MySQL 4.0.18 and PHP 4.3.4) it is located in /usr/lib/php/extensions/mysql.so. An rpm -qf /usr/lib/php/extensions/mysql.so shows this file coming from php4-mysql-4.3.4.
>
>I guess I could install the php4-mysql-4.3.4 package with its dependencies, but is there a mysql.so for php5 and how do I get it?
>
>Documentation on the php site for the error says to configure php with the --with-mysqli option (which I did) to enable MySQL support. It says you can download headers and libraries from the MySQL site, howerver, I was not able to find them (problably because I have no clue what I'm actually looking for.
>I'm sure this seems easy to most of you, but this is my first real attempt at installing something from source (I've allways been able to find and install an RPM) but since SLES9 doesn't support PHP5 out of the box I've got to build it myself.
>
>Any help on getting MySQL support with PHP5 on this box will be greatly appreciated.
>
>Thanks,
>Brian
>
>--
>TriLUG mailing list        : http://www.trilug.org/mailman/listinfo/trilug
>TriLUG Organizational FAQ  : http://trilug.org/faq/
>TriLUG Member Services FAQ : http://members.trilug.org/services_faq/
>
>  
>
If you did not have the headers the library would not be built. What 
does phpinfo() tell you? Do you actually need Mysqli?

Craig Duncan
Entuend, Inc.