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.

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:
    454
    Likes Received:
    2
    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 !!!
     
    #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:
    454
    Likes Received:
    2
    Trophy Points:
    168
    Thanks sirdopes :

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

    Spam source is manually blacklisted

    sgwd, Jul 14, 2017, in forum: E-mail Discussions
    Replies:
    2
    Views:
    51
    cPanelMichael
    Jul 17, 2017 at 2:04 PM
  2. roni777

    SOLVED exim route_list for 2 remote servers

    roni777, Jul 10, 2017, in forum: E-mail Discussions
    Replies:
    3
    Views:
    72
    cPanelMichael
    Jul 11, 2017
  3. WorkinOnIt

    Failed to check if server netblock is added to the cPGreyList trusted hosts: WHOIS lookup failed

    WorkinOnIt, Jul 8, 2017, in forum: E-mail Discussions
    Replies:
    1
    Views:
    42
    Infopro
    Jul 8, 2017
  4. kencook

    FTP doesn't go beyond Retrieving directory listing

    kencook, Jul 6, 2017, in forum: General Discussion
    Replies:
    11
    Views:
    94
    cPanelMichael
    Jul 7, 2017
  5. DWaters

    Mod Security Whitelist

    DWaters, Jul 4, 2017, in forum: Security
    Replies:
    2
    Views:
    79
    quizknows
    Jul 4, 2017

Share This Page