Plesk 11.5 Applications: psa, apsc Database Dependencies and Tables Descriptions.

Created:

2016-11-16 12:56:52 UTC

Modified:

2017-08-16 16:02:07 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Plesk 11.5 Applications: psa, apsc Database Dependencies and Tables Descriptions.

Applicable to:

  • Plesk 10.x for Linux
  • Plesk 11.x for Windows
  • Plesk 11.x for Linux
  • Plesk 12.0 for Linux

11.5 applications: psa , apsc database dependencies and descriptions of tables.

The following dumps for ' psa ' and ' apsc ' databases only contain records for one application. They were created in the following way: create a dump of the ' psa ' and ' apsc ' databases before and after application installation, then diff these dumps.

diff psa.sql_before psa.sql_after
diff apsc.sql_before apsc.sql_after

psa dump

apsc dump

psa <=> apsc dependencies scheme


psa

apsResources , apsResourcesParameters

Contains information about all application resources:

  1. urlPrefix, isSiteRoot, phpMinVersion

  2. Information about application paths:

  3. application root
  4. '/blogs/media'
  5. '/wp-content'
  6. '/tmp'

  7. Information about databases

  8. Information about database users

apsContextsApplications , apsContexts

These two tables connect the ' Subscription ' and ' domains ' tables and the ' apsc.aps_registry_object ' table.

smb_apsInstances, smb_apsContexts, smb_serviceInstances, smb_apsMetas, smb_serviceEntryPoints, smb_servicePermissions, smb_userServicePermissions

These tables contain information about:

  • The package from which the application was installed
  • URL links to the CMS administrative interface, blogs, upload theme and upload plugin
  • User permissions

smb_apsPackages

Contains information about the package: id, name, version, release, registryUid and others.

apsc

aps_application

Contains information about the application:

  • The registry_object_id of this application
  • The package_id from which this application was installed
  • package_config_id

aps_registry_object

Contains the UID for applications, packages, application resources and creation time.
The resource UID connects (3 resource records for one application):

  • psa.smb_apsInstances
  • psa.apsResources (two records with pleskType = 'hosting' and 'urlMapping')
  • psa.apsResources (two records with pleskType = 'db' and 'db_user')

aps_registry_object_setting , aps_package_resource_setting

Contains information about this application (a CMS), made up of 5 records:

  • admin_email
  • admin_name
  • admin_password
  • locale
  • title

aps_registry_object_tag

Two records with the same value. This connects the two aps_registry_object records: aps.application with aps.resource . It is easy to find required APS resources by selecting the 3-4 lines after aps.application in the aps_registry_object table.

aps_resource

Contains a description of these resources:

  • wordpress
  • aps.environment
  • aps.database

aps_package

Contains full information about the application package: id , registry_object_id , name , version , content_root_path , etc.

apsc.aps_package.id = psa.smb_apsPackages.id

Useful MySQL queries

Get the application_id , application_registry_object_id , package_id , package_name by the domain:

select app.id as application_id, regob.id as application_registry_object_id, app.package_id, pack.name as package_name 
from apsc.aps_application app, apsc.aps_package pack, apsc.aps_registry_object regob
where regob.id = app.registry_object_id and
app.package_id = pack.id and
regob.uid = ( select conapp.registryApplicationId
from psa.apsContextsApplications conapp, psa.apsContexts cont, psa.domains dom
where cont.id=conapp.apsContextId and dom.id=cont.pleskId and dom.name like 'domain.tld');

Get all records that are present in the psa.smb_apsInstances but which are absent in the apsc.aps_registry_object :

select smb_apsInstances.registryResourceId from  smb_apsInstances left JOIN apsc.aps_registry_object on apsc.aps_registry_object.uid = smb_apsInstances.registryResourceId where  apsc.aps_registry_object.uid is NULL;

Attachments:

Have more questions? Submit a request
Please sign in to leave a comment.