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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

SOLVED What file contains a list of usernames and the main account domain?

Discussion in 'General Discussion' started by Ishware, Jan 14, 2018.

  1. Ishware

    Ishware Well-Known Member

    Joined:
    Nov 7, 2003
    Messages:
    190
    Likes Received:
    3
    Trophy Points:
    168
    Location:
    Panama City, FL
    cPanel Access Level:
    Root Administrator
    So another thread led me to /etc/domainusers, which is *almost* exactly what I need, except that it contains all the domains in use for each user.

    What I need is something I can grep from bash that will return a username *once* with its corresponding main domain.

    Or is there a way to query cPanel's setup somehow to return this from bash?

    Basically, if you have the username as $user and do
    Code:
    grep ': $user' /etc/userdomains
    , you get something like
    Code:
    example.com: username
    - which is perfect, except you get multiple domains if they have addon domains. I need something that will allow me to only get the primary domain associated with an account.

    Any ideas? :)
     
    #1 Ishware, Jan 14, 2018
  2. sparek-3

    sparek-3 Well-Known Member

    Joined:
    Aug 10, 2002
    Messages:
    1,601
    Likes Received:
    64
    Trophy Points:
    328
    cPanel Access Level:
    Root Administrator
    cat /var/cpanel/users/%user% | grep ^DNS= | sed s/^DNS=//g
     
    #2 sparek-3, Jan 14, 2018
  3. Ishware

    Ishware Well-Known Member

    Joined:
    Nov 7, 2003
    Messages:
    190
    Likes Received:
    3
    Trophy Points:
    168
    Location:
    Panama City, FL
    cPanel Access Level:
    Root Administrator
    You are magic. Thank you so so very much. :)
     
    #3 Ishware, Jan 14, 2018
  4. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,734
    Likes Received:
    78
    Trophy Points:
    78
    Location:
    India
    cPanel Access Level:
    Root Administrator
    There is much simpler way than using a complex sed and grep combination when there is already a file that has the data that you are looking for.

    /etc/userdomains contains list of all Addon and Subdomain. If you want just get a list of main account and its user, use trueuserdomains.

    # cat /etc/trueuserdomains
    This is the file that contains a list of the main domain and their respective usernames..
     
    #4 24x7server, Jan 15, 2018
  5. cPWilliamL

    cPWilliamL cP Technical Analyst II
    Staff Member

    Joined:
    May 15, 2017
    Messages:
    257
    Likes Received:
    29
    Trophy Points:
    103
    Location:
    America
    cPanel Access Level:
    Root Administrator
    Just to follow up with a few examples:
    Code:
    # whmapi1 listaccts search='^cptest$' searchtype=user|grep -oP '(?<=domain: ).+'
cptest.tld

# grep -oP "[^:]+(?=: cptest$)" /etc/trueuserdomains
cptest.tld
     
    #5 cPWilliamL, Jan 15, 2018
(You must log in or sign up to post here.)
Loading...
Similar Threads - file contains list
  1. jcbox

    Can't connect to FTP with Filezilla when username contains @

    jcbox, Nov 23, 2016, in forum: Workarounds and Optimization
    Replies:
    1
    Views:
    818
    cPanelMichael
    Nov 23, 2016
  2. Pippab

    Proper file structure for new account?

    Pippab, Apr 25, 2018 at 7:46 AM, in forum: General Discussion
    Replies:
    1
    Views:
    33
    cPanelLauren
    Apr 25, 2018 at 10:51 AM
  3. User8472

    mod_cache not creating cache files?

    User8472, Apr 24, 2018 at 6:15 PM, in forum: Workarounds and Optimization
    Replies:
    3
    Views:
    44
    cPanelMichael
    Apr 25, 2018 at 11:46 AM
  4. Hedloff

    Horde generating large number of cache files

    Hedloff, Apr 23, 2018 at 1:34 PM, in forum: E-mail Discussions
    Replies:
    2
    Views:
    35
    Hedloff
    Apr 23, 2018 at 2:08 PM
  5. Otávio Serra

    HSTS file issue

    Otávio Serra, Apr 23, 2018 at 1:27 PM, in forum: Security
    Replies:
    7
    Views:
    74
    cPanelMichael
    Apr 24, 2018 at 9:39 AM

Share This Page