#260 Unable to "browse" mysql.user table with latest release

closed
1
2003-07-23
2003-06-11
No

Since a couple of revisions of phpMyAdmin ago, I'm
unable to browse the MySQL "users" table. When I go
to do this, it just hangs. This is true with 2.5.1.

I have MySQL-3.23.56 installed, and am able to browse
this table with other tools or through the command line.

I tried modifying the "control" user to be root, to
experiment, and the same problem occurs. Is this a
known bug, or did I do something wrong in the config?

I granted privileges to the "control" user and indeed
the "control" user is able to view other tables... and if I
remove the password for "control" phpmyadmin will show
an error from the mysql server.

If I use the command line mysql client to select from the
mysql.user database, I am able to read it fully without
any problem. So, I'm going to presume the bug is
somewhere in the phpmysqladmin process.

This is the mysql statement I used:

GRANT USAGE ON mysql.* TO 'control'@'localhost'
IDENTIFIED BY 'somepassword';
GRANT SELECT ON mysql.db TO 'control'@'localhost';
GRANT SELECT ON mysql.host TO 'control'@'localhost';
GRANT SELECT (Host, Db, User, Table_name, Table_priv,
Column_priv)
ON mysql.tables_priv TO 'control'@'localhost';

GRANT SELECT (
Host, User, Select_priv, Insert_priv, Update_priv,
Delete_priv,
Create_priv, Drop_priv, Reload_priv, Shutdown_priv,
Process_priv,
File_priv, Grant_priv, References_priv, Index_priv,
Alter_priv
) ON mysql.user TO 'control'@'localhost';

I'm not sure how to debug this, and would appreciate
any assistance as it's very aggravating :-)

Thanks,
Forrest

Discussion

  • Forrest Aldrich

    Forrest Aldrich - 2003-06-11
    • priority: 5 --> 7
     
  • Garvin Hicking

    Garvin Hicking - 2003-06-12

    Logged In: YES
    user_id=473563

    At first, it's really very bad if something just 'hangs'. If
    this was a privilege problem, you should get errors displayed.

    So, try to review your php Errorlogfile (see php.ini and/or
    your webserver configuration on how to enable that) and see
    if there are errors set. Also please try to wait longer than
    your max_execution_time is set. Maybe after 30 seconds
    you'll get displayed wher PMA hangs.

    Then, please report back :)

     
  • Garvin Hicking

    Garvin Hicking - 2003-06-12
    • priority: 7 --> 3
    • assigned_to: nobody --> garvinhicking
     
  • Forrest Aldrich

    Forrest Aldrich - 2003-06-12

    Logged In: YES
    user_id=1408

    I did as you asked. One area I'm not certain about in php.ini
    is this setting:

    error_log = /var/log/apache/php.log ; log errors to
    specified file

    where the value was originally commented out and
    said "filename". Yes, I stopped and restarted the server
    after this was done. Nothing is logged there.

    For some strange reason, ONCE, I was able to get to
    mysql.user, but only once. And when I submit the changes,
    it again hangs, and has been hanging for more than 20mins...
    so I'm guessing nothing will happen. This is the httpd-
    access.log entry for this (there is nothing in the httpd-
    error.log about this).

    I'm really puzzled about what the problem could be. I
    checked to ensure that the username/passwords I use are
    working - again, I'm able to do anything with them on the
    command-line interface, or with Mysql Control Center. I also
    checked to endure that the AbsoluteURI matched and that
    my DNS is correct for it - so I don't think that's the issue
    either.

    Any other possible traps I could look into?

    192.168.1.21 - forrie [12/Jun/2003:12:33:46 -
    0400] "POST /phpmyadmin/tbl_replace.php HTTP/1.1" 302
    5 "http://forrie.com/phpmyadmin/tbl_change.php?lang=en-iso-
    8859-
    1&server=1&db=mysql&table=user&pos=0&session_max_rows=
    30&disp_direction=horizontal&repeat_cells=100&dontlimitchars
    =0&primary_key=+%60Host%60+%3D+%27localhost%
    27+AND+%60User%60+%3D+%27rt3%
    27&sql_query=SELECT++%2A+%0AFROM++%60user%
    60+&goto=sql.php" "Mozilla/4.0 (compatible; MSIE 6.0;
    Windows NT 5.1; .NET CLR 1.0.3705; .NET CLR 1.1.4322)"
    192.168.1.21 - forrie [12/Jun/2003:12:33:46 -
    0400] "GET /phpmyadmin/sql.php?lang=en-iso-8859-
    1&server=1&db=mysql&table=user&pos=0&session_max_rows=
    30&disp_direction=horizontal&repeat_cells=100&dontlimitchars
    =0&sql_query=SELECT++%2A+%0AFROM++%60user%
    60+&disp_message=Modifications+have+been+saved&disp_que
    ry=UPDATE+%60user%60+SET+%60Select_priv%60+%3D+%
    27Y%27%2C+%60Insert_priv%60+%3D+%27Y%27%2C+%
    60Update_priv%60+%3D+%27Y%27%2C+%60Delete_priv%
    60+%3D+%27Y%27%2C+%60Create_priv%60+%3D+%27Y%
    27%2C+%60Drop_priv%60+%3D+%27Y%27%2C+%
    60Reload_priv%60+%3D+%27Y%27%2C+%60Index_priv%
    60+%3D+%27Y%27%2C+%60Alter_priv%60+%3D+%27Y%
    27+WHERE+%60Host%60+%3D+%27localhost%27+AND+%
    60User%60+%3D+%27rt3%27+LIMIT+1%3B HTTP/1.1" 200
    5676 "http://forrie.com/phpmyadmin/tbl_change.php?lang=en-
    iso-8859-
    1&server=1&db=mysql&table=user&pos=0&session_max_rows=
    30&disp_direction=horizontal&repeat_cells=100&dontlimitchars
    =0&primary_key=+%60Host%60+%3D+%27localhost%
    27+AND+%60User%60+%3D+%27rt3%
    27&sql_query=SELECT++%2A+%0AFROM++%60user%
    60+&goto=sql.php" "Mozilla/4.0 (compatible; MSIE 6.0;
    Windows NT 5.1; .NET CLR 1.0.3705; .NET CLR 1.1.4322)"

     
  • Garvin Hicking

    Garvin Hicking - 2003-06-12

    Logged In: YES
    user_id=473563

    Hm, so what you're doing is to login and click on the
    'browse' button on the left frame for your mysql.user table,
    right? And then the right page goes to a blank white screen
    and does nothing, right?

    Just out of curiousity, try to disable $cfg['OBGZip'] in
    your config.inc.php (phpMyAdmin) and maybe any mod_gzip
    modules from apache.

    Possibly your mysql.user table is rather large and you are
    facing the famous IE6+OBGzip Bug - in which case we could
    use you as a crash-test dummy to get behind the problem once
    and for all - currently this problem with OBGZip is not
    completely solved as to what webserver/browser version
    exactly it is reproducible.

    Regards,
    Garvin.

     
  • Forrest Aldrich

    Forrest Aldrich - 2003-06-12

    Logged In: YES
    user_id=1408

    That was it! OBGzip was the problem.

    Thank you (100 times). I don't know how many bodily hairs
    I've pulled out trying to figure this problem out.

    So, I will be happy to be the crash-test dummy to help you
    debug this. Feel free to contact me directly/privately at
    forrie@forrie.com.

    Now: I do not have mod_gzip installed into Apache, though I
    was looking at it recently. I can do that now, and then re-
    enable the OBGzip if you like.

    Let me know, and thanks once again.

     
  • Garvin Hicking

    Garvin Hicking - 2003-06-12
    • priority: 3 --> 1
     
  • Garvin Hicking

    Garvin Hicking - 2003-06-12

    Logged In: YES
    user_id=473563

    Forrie,

    great to have helped you out. I just send you an email with
    the steps how we can try to work on that issue. We'll
    continue our discussion on a email-basis and I will post the
    results here.

    Thanks in advance,
    Garvin.

     
  • Garvin Hicking

    Garvin Hicking - 2003-07-23

    Logged In: YES
    user_id=473563

    The conversation somehow died, and the IE6 patch '2800'
    seems to be the cause of the problems. As we have now OBGzip
    disabled for IE6, we'll have to see what feature has in hold
    for IE6.x :)

     
  • Garvin Hicking

    Garvin Hicking - 2003-07-23
    • status: open --> closed
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks