[TriLUG] SUSE LAMP Server problems with PHPMyAdmin

[Scott Lundgren]

Brian,

I'm a bit late on this but here's what's going on. In PHP5 the API  
into MySQL was rewritten to clean it up and deal with the new  
password schemes & other fun stuff in MySQL 4.1.x . Consequently PHP  
stopped redistributing the libraries and includes of MySQL that  
helped PHP figure out how MySQL was built while PHP was compiling. So  
that new interface is what you are using when you compile PHP5 --with- 
mysqli AND point the --with-mysqli=/path/to/your/mysql_config. The  
mysql_config replaces the need for PHP to include MySQL libraries.

Just keep the thread going if you need any more help along the way.

- SL


> 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/