Article ID: 3122, created on Nov 30, 2007, last review on Apr 17, 2012

  • Applies to:
  • H-Sphere


Before getting user-related information out of system database, make sure to do the following: 1. Start PostgreSQL on CP server. 2. Log into the H-Sphere system database before running queries: 1.) Login as the cpanel user to the server where the system database is located (usually, CP server). 2.) Enter the hsphere database (usually, under the wwwuser user name): # psql hsphere [user_name] 3. Run the query you need. For more information on it, go to a. To get user emails knowing their MySQL database names, run the following query: select from mysqldb m, parent_child pc, accounts a, contact_info c where m.db_name='DBNAME' and and pc.child_type=6001 and and; b. To get the list of email addresses of active customers ignoring resellers' end users, run the following query: select from contact_info c_i join accounts a on ( and a.reseller_id=1); Even more information is at:

f213b9fa8759d57bee5d547445806fe7 6311ae17c1ee52b36e68aaf4ad066387

Email subscription for changes to this article
Save as PDF