[HOW TO] How to get site UUID and directory ID by name of Plesk domain?

Created:

2016-11-16 13:23:42 UTC

Modified:

2017-08-08 13:45:28 UTC

0

Was this article helpful?


Have more questions?

Submit a request

[HOW TO] How to get site UUID and directory ID by name of Plesk domain?

Applicable to:

  • Plesk 12.0 for Linux

Symptoms

Plesk Sitebuilder 4.5 is registered in Plesk 9.x or component Web Presence Builder version 10.x or above is enabled in Plesk version 10.x or above.

How to get site uuid and directory name by name of Parallels Plesk Panel domain?

Resolution

Parallels Plesk Panel 9.x (database name is 'psa') and Parallels Plesk Sitebuilder 4.5 (database name is 'sitebuilder3')

[root@plesk95 ~]# MYSQL_PWD=`cat /etc/psa/.psa.shadow`  mysql -uadmin psa
...

mysql> select d.name as 'Plesk Domain', s.alias as 'Site Alias', s.dir_name as 'Directory ID' from psa.domains d, psa.SBSites sbs, sitebuilder3.site s where d.id=sbs.virtualHost_id and s.site_id=sbs.sb_site_id;
+--------------+-------------+----------------------------------+
| Plesk Domain | Site Alias  | Directory ID                     |
+--------------+-------------+----------------------------------+
| plesk95.com  | plesk95.com | 803fd702a5ee48810a47fe53580d71dc |

...

The site is located in directory:

/usr/local/sitebuilder/htdocs/sites/80/803fd702a5ee48810a47fe53580d71dc/

The site is published into domain's directory:

/var/www/vhosts/plesk95.com/httpdocs/

Plesk version 10.x or above (database name is 'psa') and Web Presence Builder version 10.x or above (database name is 'sitebuilder5')

[root@plesk10 ~]# MYSQL_PWD=`cat /etc/psa/.psa.shadow`  mysql -uadmin psa
...
mysql> select d.name as 'Plesk Domain', s.uuid as 'Site uuid', s.dir_name as 'Directory ID' from psa.domains d, psa.dom_param dp, sitebuilder5.site s where d.id=dp.dom_id and dp.param='site_builder_site_id' and s.uuid=dp.val;
+--------------+--------------------------------------+----------------------------------+
| Plesk Domain | Site uuid                            | Directory ID                     |
+--------------+--------------------------------------+----------------------------------+
| plesk10.com  | b1d53377-aead-255c-fd5f-e340fcb3a8a5 | 8dd0d7b786c99eb902229171766a3a5e |
...

NOTE: in Web Presence Builder Site Alias is the same as Directory ID .

Site is located in directory

/usr/local/sb/htdocs/sites/fc/fc57a105e2447c76f2656c00bc6c24d4/

The site is published into domain's directory

/var/www/vhosts/plesk10.com/httpdocs/
Have more questions? Submit a request
Please sign in to leave a comment.