[Phpmyadmin-devel] [Fwd: mysql phpmyadmin problem]

[Marc Delisle]

Thanks Mike and Sebastian,

I merged this patch which IMO fixes this problem:

Index: database_interface.lib.php
===================================================================
RCS file: 
/cvsroot/phpmyadmin/phpMyAdmin/libraries/database_interface.lib.php,v
retrieving revision 2.51
retrieving revision 2.52
diff -C2 -d -r2.51 -r2.52
*** database_interface.lib.php	22 Jun 2006 19:59:30 -0000	2.51
--- database_interface.lib.php	25 Jun 2006 12:40:29 -0000	2.52
***************
*** 298,302 ****
               null, $link);
           unset( $sql_where_table, $sql );
!     } else {
           foreach ( $databases as $each_database ) {
               if ( true === $tbl_is_group ) {
--- 298,306 ----
               null, $link);
           unset( $sql_where_table, $sql );
!     }
!     // If permissions are wrong on even one database directory,
!     // information_schema does not return any table info for any database
!     // this is why we fall back to SHOW TABLE STATUS even for MySQL >= 
50002
!     if ( PMA_MYSQL_INT_VERSION < 50002 || empty($tables)) {
           foreach ( $databases as $each_database ) {
               if ( true === $tbl_is_group ) {


Sebastian Mendel a écrit :
> 
> -------- Original-Nachricht --------
> Betreff: mysql phpmyadmin problem
> Datum: Fri, 23 Jun 2006 23:46:23 -0400
> Von: Michael <mike at brenden.com>
> An: cybot_tm at users.sourceforge.net
> 
> Hi there,
> 
> As an offshoot of mysql/phpmyadmin bug #1436171
> 
> If permissions change away from mysql.mysql on any database directory
> under /var/lib/mysql (to, say, root.root),
> 
> and phpmyadmin detects mysql version > 5.whatever (i.e., phpmyadmin
> tries to utilize information_schema),
> 
> then phpmyadmin reports No database tables found, despite there
> obviously being, say, dozens of databases, and hundreds of tables.
> 
> So the one permissions error on one database's directory screws up every
> database as far as phpmyadmin is concerned.
> 
> Thought you should know.
> 
> Best regards from outside washington, dc
> Michael