Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

phpMyAdmin access log

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

  1. InteractM

    InteractM Well-Known Member

    Joined:
    Apr 2, 2013
    Messages:
    135
    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:
    16,352
    Likes Received:
    402
    Trophy Points:
    583
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. InteractM

    InteractM Well-Known Member

    Joined:
    Apr 2, 2013
    Messages:
    135
    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:
    16,352
    Likes Received:
    402
    Trophy Points:
    583
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. InteractM

    InteractM Well-Known Member

    Joined:
    Apr 2, 2013
    Messages:
    135
    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:
    16,352
    Likes Received:
    402
    Trophy Points:
    583
    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?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice