User Accounts?

[Eric Pretorious]

Is there a way to generate a list of all user accounts on the system (and the subscription that they're associated with)?

 

[MislavO]

I know that you can get list of all users (clients/resellers) in psa database -> clients. The other part I don't know.

 

[Eric Pretorious]

I know that you can get list of all users (clients/resellers) in psa database -> clients. The other part I don't know.

1. AFAICT: Users, Clients, and Resellers are different entities. Yes?
2. Is there an interface for accessing the PSA database?

 

[MislavO]

Ok, my bad, I understood you wrong.

Well, you can access PSA database from Plesk itself, just go to Tools & Settings -> Database Servers, opet the local MySQL server and browse through phpmyadmin.

 

[Eric Pretorious]

Well, you can access PSA database from Plesk itself, just go to Tools & Settings -> Database Servers, opet the local MySQL server and browse through phpmyadmin.

Thanks, Mislav:

The psa database contains 174 tables! Which of these should I query?

 

[aegide]

Hi,

i was intrigued by the question so i looked at what i could find...

Looking at the database in phpmyadmin there are a couple of relevant tables it seems:

psa->accounts (don't know yet)
psa->clients (list of clients and their logins w/o mention of subscriptions)
psa->db_users (empty on my fresh install, looking at column names should be individually created db users from w/i subscriptions)
psa->domains (list of all created domains relating column "cl_id" to client id from psa->clients)
psa->filesharing_users (don't know yet)
psa->ftpusers (ftp logins where "sys_user_id" column refers to psa->sys_users->"id")
psa->mail (list of email accounts (no aliases) where "dom_id" relates to psa->domains->"id")
psa->mail_aliases (list of mail aliases where "mn_id" relates to psa->mail->"id")
psa->pd_users (list of usersnames from password protected web directories where "pd_id" relates to psa->protected_dirs->"id")
psa->smb_users (list of all clients & additional system users that where created? not entirely sure)
psa->sys_users (list of userlogins managing subscriptions (ftp login/ webadmins(?, maybe rather in psa->web_users which is still empty at my site) etc where "home" shows login dir)

A simple

grep vhosts /etc/passwd

on the shell also shows logins from psa->sys_users are created as local system users with (in my case) /bin/false as shell.

In addition, there are the commands under (in my case) /opt/psa/bin and /opt/psa/admin/bin/ where

/opt/psa/bin/
client
customer
reseller
subscription
user
webuser

seem relevant but don't have a -list option afaict. Some can check existance of accounts though and "-h" switch shows available options.

Also

/opt/psa/admin/bin/
usermng -h

shows a deprecated "--get-users-list" switch that will result in some formatted /etc/passwd output including vhost accounts.

There's more i'm sure and the above info may be incomplete/ inaccurate (beware, i just looked at this for the first time).

Getting a list should be simpler than diving into the db, but hey... Maybe i'm missing something.

hth
aeg

 

[Eric Pretorious]

psa->clients (list of clients and their logins w/o mention of subscriptions)
psa->smb_users (list of all clients & additional system users that where created...)

Thanks, aeg:

There are seven tables in the psa database with the word "user" in their name: db_users, ftp_user, fileSharingUsers, pd_users, smb_users, sys_users, & web_users. I checked the contents of the psa->smb_users table and believe that I've found what I was looking for: The psa->smb_users table contains all accounts, indexed by the client account to which they're associated (in the psa->clients->id).

 

[Eric Pretorious]

psa->sys_users (list of userlogins managing subscriptions...

grep vhosts /etc/passwd

on the shell also shows logins from psa->sys_users are created as local system users with (in my case) /bin/false as shell.

Yes - I've confirmed that the system users (i.e., the accounts found in /etc/passwd and in psa->sys_users) are one and the same as the usernames associated with the subscriptions (the value found in Home > Subscriptions > foobar.com > Change hosting Settings of foobar.com).