Today I had to regain access to the admin panel of one of my root servers that uses Plesk as administrative panel. I had configured a IP restriction for the panel under Tools and Settings > Restrict Administrative Access. The problem was, that I wanted to access the machine from outside of the company network (my […]
The different PHP versions unter Plesk ODIN are situated in /opt/plesk/php/. So the PHP paths are for example: /opt/plesk/php/5.2/bin/php /opt/plesk/php/5.3/bin/php /opt/plesk/php/5.4/bin/php /opt/plesk/php/5.5/bin/php /opt/plesk/php/5.6/bin/php /opt/plesk/php/7.0/bin/php Which PHP versions are available depends on the versions installed. You can see your installed versions under https://yourdomain.com:8443/admin/php-handler/list/ in the Plesk backend.
If you have read my article Plesk – get information about aliases you already know how to determine the aliases in the system. To get a list of configured domains, you can use the following query after connecting to the Plesk database via key:
|
1 2 |
mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa mysql> select * from domains; |
This will give you something like that:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
+----+------------+-----------------------------------+-----------------------------------+-------------+--------+---------+--------------+-------+-------------+-----------+-----------+--------------------------------------+-------------+---------+-----------+-----------+-------------+-----------------+----------------+----------------+------------------+---------------------+-------------+-----------+-----------+ | id | cr_date | name | displayName | dns_zone_id | status | htype | real_size | cl_id | cert_rep_id | limits_id | params_id | guid | external_id | overuse | gl_filter | vendor_id | webspace_id | webspace_status | parentDomainId | permissions_id | adminDescription | resellerDescription | description | icpStatus | icpPermit | +----+------------+------------------------------------+----------------------------------+-------------+--------+---------+--------------+-------+-------------+-----------+-----------+--------------------------------------+-------------+---------+-----------+-----------+-------------+-----------------+----------------+----------------+------------------+---------------------+-------------+-----------+-----------+ | 1 | 2014-12-08 | preview.asksheldon.de | preview.asksheldon.de | 2 | 0 | vrt_hst | 12785790976 | 1 | 0 | 0 | 0 | 6bb68df0-c4b7-4d0a-8111-7c06015b03ec | | false | on | 1 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | 0 | NULL | | 2 | 2014-12-08 | zmp.asksheldon.de | zmp.asksheldon.de | 3 | 16 | vrt_hst | 253433241600 | 1 | 2 | 0 | 0 | 01103186-8f53-44b3-ba70-6dfaa659d681 | | false | on | 1 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | 0 | NULL | | 3 | 2015-09-28 | asksheldon.asksheldon.de | asksheldon.asksheldon.de | 6 | 0 | vrt_hst | 86978876076 | 1 | 3 | 0 | 0 | 2097dbfe-c28b-4ac1-9924-431b1fa950ca | | false | on | 1 | 0 | 0 | 0 | 0 | | | | 0 | NULL | | 4 | 2016-02-16 | asksheldonstage.asksheldon.de | asksheldonstage.asksheldon.de | 7 | 0 | vrt_hst | 31841124352 | 1 | 4 | 0 | 0 | b7011bd3-01fd-40ef-a217-c6624d765781 | | false | on | 1 | 0 | 0 | 0 | 0 | | | | 0 | NULL | | 5 | 2016-02-16 | asksheldondev.asksheldon.de | asksheldondev.asksheldon.de | 8 | 0 | vrt_hst | 27434414080 | 1 | 5 | 0 | 0 | 5c82a626-491d-45e2-a693-1a738ff81a99 | | false | on | 1 | 0 | 0 | 0 | 0 | | | | 0 | NULL | | 6 | 2016-02-22 | asksheldon-cms.asksheldon.de | asksheldon-cms.asksheldon.de | 9 | 0 | vrt_hst | 5287936 | 1 | 0 | 0 | 0 | cfc6c982-bb8b-4e93-8ce8-2a962d2554e3 | | false | on | 1 | 3 | 0 | 0 | 0 | | | | 0 | NULL | | 7 | 2016-02-22 | asksheldonstage-cms.asksheldon.de | asksheldonstage-cms.asksheldon.de | 10 | 0 | vrt_hst | 8597504 | 1 | 0 | 0 | 0 | 10872589-24aa-4ffc-93b1-f506fac2b434 | | false | on | 1 | 4 | 0 | 0 | 0 | | | | 0 | NULL | | 8 | 2016-02-22 | asksheldondev-cms.asksheldon.de | asksheldondev-cms.asksheldon.de | 11 | 0 | vrt_hst | 4943872 | 1 | 0 | 0 | 0 | f1c7a0fc-94d6-40a6-b53a-772a009edc07 | | false | on | 1 | 5 | 0 | 0 | 0 | | | | 0 | NULL | | 9 | 2016-09-20 | cb.asksheldon.de | cb.asksheldon.de | 19 | 0 | vrt_hst | 487424 | 1 | 0 | 0 | 0 | c2f89da8-8114-4aa9-a5d8-b1ac6468ec62 | | false | on | 1 | 0 | 0 | 0 | 0 | | | | 0 | NULL | | 10 | 2016-09-22 | cb-dev.asksheldon.de | cb-dev.asksheldon.de | 20 | 0 | vrt_hst | 790781952 | 1 | 0 | 0 | 0 | f069f835-4823-4e32-bfb2-a20146a9c3ff | | false | on | 1 | 0 | 0 | 0 | 0 | | | | 0 | NULL | +----+------------+-----------------------------------+-----------------------------------+-------------+--------+---------+--------------+-------+-------------+-----------+-----------+--------------------------------------+-------------+---------+-----------+-----------+-------------+-----------------+----------------+----------------+------------------+---------------------+-------------+-----------+-----------+ 10 rows in set (0.00 sec) |
What you nee is […]
To get a list of all existing aliases defined for the respective system, you can connect to the MySQL database of Plesk as admin via key file:
|
1 |
$> mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa |
Afterwards you can get a list of all aliases by the following select statement:
|
1 |
select * from domain_aliases; |
This will give you something like that:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
+----+--------+-------------+--------+---------------------------------+---------------------------------+------+------+------+--------+-------------+-------------+-----------+-----------+ | id | dom_id | dns_zone_id | status | name | displayName | dns | mail | web | tomcat | seoRedirect | external_id | icpStatus | icpPermit | +----+--------+-------------+--------+---------------------------------+---------------------------------+------+------+------+--------+-------------+-------------+-----------+-----------+ | 1 | 2 | 5 | 3 | shop.zmp.asksheldon.de | shop.zmp.asksheldon.de | true | true | true | false | false | NULL | 0 | NULL | | 2 | 5 | 12 | 0 | asksheldonshop.se | asksheldonshop.se | true | true | true | false | false | NULL | 0 | NULL | | 3 | 5 | 13 | 0 | asksheldonshop.fi | asksheldonshop.fi | true | true | true | false | false | NULL | 0 | NULL | | 5 | 5 | 15 | 0 | asksheldonshop.dk | asksheldonshop.dk | true | true | true | false | false | NULL | 0 | NULL | | 6 | 5 | 16 | 0 | asksheldonshop.no | asksheldonshop.no | true | true | true | false | false | NULL | 0 | NULL | | 7 | 5 | 17 | 0 | asksheldonshop-nordic.com | asksheldonshop-nordic.com | true | true | true | false | false | NULL | 0 | NULL | | 8 | 5 | 18 | 0 | asksheldonscandinavia.com | asksheldonscandinavia.com | true | true | true | false | false | NULL | 0 | NULL | | 13 | 5 | 25 | 0 | asksheldonshop.au | asksheldonshop.au | true | true | true | false | false | NULL | 0 | NULL | | 14 | 5 | 26 | 0 | asksheldonusa.com | asksheldonusa.com | true | true | true | false | false | NULL | 0 | NULL | | 15 | 8 | 27 | 0 | cms.asksheldonshop.au | cms.asksheldonshop.au | true | true | true | false | false | NULL | 0 | NULL | | 16 | 8 | 28 | 0 | cms.asksheldonusa.com | cms.asksheldonusa.com | true | true | true | false | false | NULL | 0 | NULL | | 17 | 4 | 29 | 0 | stage.asksheldonshop.se | stage.asksheldonshop.se | true | true | true | false | false | NULL | 0 | NULL | | 18 | 4 | 30 | 0 | stage.asksheldonshop.fi | stage.asksheldonshop.fi | true | true | true | false | false | NULL | 0 | NULL | | 19 | 4 | 31 | 0 | stage.asksheldonshop.dk | stage.asksheldonshop.dk | true | true | true | false | false | NULL | 0 | NULL | | 20 | 4 | 32 | 0 | stage.asksheldonshop.no | stage.asksheldonshop.no | true | true | true | false | false | NULL | 0 | NULL | | 21 | 4 | 33 | 0 | stage.asksheldonshop.au | stage.asksheldonshop.au | true | true | true | false | false | NULL | 0 | NULL | | 22 | 4 | 34 | 0 | stage.asksheldonusa.com | stage.asksheldonusa.com | true | true | true | false | false | NULL | 0 | NULL | +----+--------+-------------+--------+---------------------------------+---------------------------------+------+------+------+--------+-------------+-------------+-----------+-----------+ |
To get more information about […]
This is how to remove a domain alias via root console:
|
1 |
$> /usr/local/psa/bin/domalias -d cms.ask-sheldon.au |
In Parallels Plesk 9.x, 10.x and 11.x for Linux (in this case CentOS 6.6) there is a bug. You can not authenticate via ssh key or add one f.e. with:
|
1 |
$> ssh-copy-id -i .ssh/deploy_rsa.pub user@ask-sheldon.com |
Thats why you have to do this: Edit ssh deamon configuration:
|
1 |
$> sudo nano /etc/ssh/sshd_config |
Add the following line:
|
1 |
AuthorizedKeysFile %h/private/.ssh/authorized_keys |
Restart the SSH Deamon:
|
1 |
$> sudo service sshd restart |
Now the […]
