The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

phpMyAdmin access log

Discussion in 'General Discussion' started by InteractM, Oct 20, 2015.

  1. InteractM

    InteractM Well-Known Member

    Joined:
    Apr 2, 2013
    Messages:
    133
    Likes Received:
    1
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Where I can find access log to phpMyAdmin for hosting accounts? One of the accounts has problems with phpMyAdmin export (downloading) and I need to check logs if this is a server issue or his network issue.

    Thanks
     
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,463
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    /usr/local/cpanel/logs/access_log

    If you've got CSF installed you can view this file right from within WHM > Plugins > ConfigServer Security&Firewall > Watch System Logs. You should see entries in that log similar to this:
    Code:
    [10/20/2015:13:57:48 -0000] "GET /cpsess468083601/3rdparty/phpMyAdmin/index.php
     
  3. InteractM

    InteractM Well-Known Member

    Joined:
    Apr 2, 2013
    Messages:
    133
    Likes Received:
    1
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    OK.

    So in case there is response 200 for GET request and phpMyAdmin export script it means connection was established properly and issue is on the clients network side?
     
  4. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,463
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Are you able to export a database via phpMyAdmin? What issue is this user having exactly? You don't mention that.
     
  5. InteractM

    InteractM Well-Known Member

    Joined:
    Apr 2, 2013
    Messages:
    133
    Likes Received:
    1
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Here:

    Recently I’ve been attempting to download gzipped versions of the sql database. However, frequently the download will complete, but will be only a fraction of the size I expect. Currently, a successful download of a compressed mydb.sql file is 21.4 MB. However, it will ofter stop only at 6MB or less. Sometimes 10MB.​
     
  6. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,463
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    "frequently" and "Sometimes" can be a lot of things, neither does you any good here. ;)

    Are you able to successfully download the same database this user is having troubles with?

    What happens for this user when he attempts to download a MySQL Database Backup from the Backups area of his cPanel?
     
Loading...

Share This Page