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!

list all databases associated with a reseller !!

Discussion in 'General Discussion' started by furquan, Aug 23, 2010.

  1. furquan

    furquan Well-Known Member

    Joined:
    Jul 27, 2002
    Messages:
    471
    Likes Received:
    4
    Trophy Points:
    168
    Hello All :

    I have a requirement from a reseller and he needs to know all the DB's associated with all his hosted accounts. he has some 100 account and i cannot go browsing each panel for the info.

    How is it possible to get it via CLI or any available script ?

    Any assistance please !!!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 furquan, Aug 23, 2010
  2. sirdopes

    sirdopes Well-Known Member
    PartnerNOC

    Joined:
    Sep 25, 2007
    Messages:
    141
    Likes Received:
    0
    Trophy Points:
    66
    This can easily be done in bash. I am sure there are better ways but I would use something like the following:

    for i in `grep OWNER=owername /var/cpanel/users/* -l | cut -d '/' -f 5`; do ls /var/lib/mysql/ | grep $i_ ; done

    That should print out a list of all of the databases assuming that you are not using the new cpanel feature where the databases do not start with the user_.
     
    #2 sirdopes, Aug 24, 2010
  3. furquan

    furquan Well-Known Member

    Joined:
    Jul 27, 2002
    Messages:
    471
    Likes Received:
    4
    Trophy Points:
    168
    Thanks sirdopes :

    I'll have this run and will see how it goes :)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 furquan, Aug 24, 2010
(You must log in or sign up to post here.)
Loading...
Similar Threads - list databases associated
  1. chris0147

    New Thread Email blacklisted still goes to spam

    chris0147, Oct 16, 2018 at 3:27 PM, in forum: E-mail Discussion
    Replies:
    0
    Views:
    14
    chris0147
    Oct 16, 2018 at 3:27 PM
  2. Tamer Youssef

    Edit user's email white-list?

    Tamer Youssef, Oct 13, 2018 at 5:13 AM, in forum: E-mail Discussion
    Replies:
    1
    Views:
    39
    cPanelLauren
    Oct 16, 2018 at 1:00 PM
  3. chris0147

    Email Blacklisted Going to Spam

    chris0147, Oct 5, 2018, in forum: E-mail Discussion
    Replies:
    9
    Views:
    166
    chris0147
    Oct 10, 2018
  4. Brooky A

    error: clcommon: get_lve_version: Can`t open file /proc/lve/list

    Brooky A, Oct 3, 2018, in forum: CloudLinux
    Replies:
    2
    Views:
    71
    cPanelLauren
    Oct 8, 2018
  5. Sue Young

    Configuring eMail list question

    Sue Young, Oct 1, 2018, in forum: General Discussion
    Replies:
    1
    Views:
    57
    cPanelLauren
    Oct 5, 2018

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.
    Accept Learn More...
    Dismiss Notice