Plesk : Différence entre versions

De Sn4kY
Aller à : navigation, rechercher
(Page créée avec « = Lister les redirections emails = mysql -uadmin -p$(cat /etc/psa/.psa.shadow) --batch psa -e "SELECT CONCAT_WS('@',mail.mail_name,domains.name) AS adresse ,mail_redir.ad... »)
 
Ligne 1 : Ligne 1 :
 +
= Lister les domaines =
 +
plesk bin domain --list
 +
 
= Lister les redirections emails =
 
= Lister les redirections emails =
 
  mysql -uadmin -p$(cat /etc/psa/.psa.shadow) --batch psa -e "SELECT CONCAT_WS('@',mail.mail_name,domains.name) AS adresse ,mail_redir.address AS redirection FROM domains,mail,mail_redir WHERE domains.id=mail.dom_id AND mn_id=mail.id ORDER BY domains.name ASC,mail.mail_name ASC;" | sed 's/\t/\t->\t/g'
 
  mysql -uadmin -p$(cat /etc/psa/.psa.shadow) --batch psa -e "SELECT CONCAT_WS('@',mail.mail_name,domains.name) AS adresse ,mail_redir.address AS redirection FROM domains,mail,mail_redir WHERE domains.id=mail.dom_id AND mn_id=mail.id ORDER BY domains.name ASC,mail.mail_name ASC;" | sed 's/\t/\t->\t/g'
Ligne 5 : Ligne 8 :
 
  MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin -Dpsa -e"SELECT dom.id, dom.name, ia.ipAddressId, iad.ip_address FROM domains dom LEFT JOIN DomainServices d ON (dom.id = d.dom_id AND d.type = 'web') LEFT JOIN IpAddressesCollections ia ON ia.ipCollectionId = d.ipCollectionId LEFT JOIN IP_Addresses iad ON iad.id = ia.ipAddressId WHERE iad.ip_address='<THE.IP.ADDRESS.HERE>'"
 
  MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin -Dpsa -e"SELECT dom.id, dom.name, ia.ipAddressId, iad.ip_address FROM domains dom LEFT JOIN DomainServices d ON (dom.id = d.dom_id AND d.type = 'web') LEFT JOIN IpAddressesCollections ia ON ia.ipCollectionId = d.ipCollectionId LEFT JOIN IP_Addresses iad ON iad.id = ia.ipAddressId WHERE iad.ip_address='<THE.IP.ADDRESS.HERE>'"
  
= Lister les domaines par version/handler PHP =
+
= Lister les handlers PHP =
  mysql -uadmin -p$(cat /etc/psa/.psa.shadow) psa -e "select dom_id,www_root,php_handler_id from hosting where php_handler_id LIKE '%5.2%';"
+
plesk bin php_handler --list
 +
 
 +
= Lister les id de domaines par version/handler PHP =
 +
  MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin psa -e "select dom_id,php_handler_id from hosting where php_handler_id LIKE '%5.2%';"
 +
 
 +
= Lister les domaines qui ont une version spécifique de PHP =
 +
MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin psa --batch -e "select name from domains, hosting WHERE domains.id=hosting.dom_id AND hosting.php_handler_id LIKE '%72%';"

Version du 27 juin 2018 à 14:58

Lister les domaines

plesk bin domain --list

Lister les redirections emails

mysql -uadmin -p$(cat /etc/psa/.psa.shadow) --batch psa -e "SELECT CONCAT_WS('@',mail.mail_name,domains.name) AS adresse ,mail_redir.address AS redirection FROM domains,mail,mail_redir WHERE domains.id=mail.dom_id AND mn_id=mail.id ORDER BY domains.name ASC,mail.mail_name ASC;" | sed 's/\t/\t->\t/g'

Lister les domaines par IP

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin -Dpsa -e"SELECT dom.id, dom.name, ia.ipAddressId, iad.ip_address FROM domains dom LEFT JOIN DomainServices d ON (dom.id = d.dom_id AND d.type = 'web') LEFT JOIN IpAddressesCollections ia ON ia.ipCollectionId = d.ipCollectionId LEFT JOIN IP_Addresses iad ON iad.id = ia.ipAddressId WHERE iad.ip_address='<THE.IP.ADDRESS.HERE>'"

Lister les handlers PHP

plesk bin php_handler --list

Lister les id de domaines par version/handler PHP

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin psa -e "select dom_id,php_handler_id from hosting where php_handler_id LIKE '%5.2%';"

Lister les domaines qui ont une version spécifique de PHP

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin psa --batch -e "select name from domains, hosting WHERE domains.id=hosting.dom_id AND hosting.php_handler_id LIKE '%72%';"