Question List of Subscriptions and the IP (some have two ips)

[Michael Huber]

i found solution to create my list:
How to get a list of subscriptions and their IP addresses on Plesk server?

if I run the command, I get a List but some Subscriptions have two IPs

| xxxxx.xxx | 1.2.3.4 , 4.3.2.1 | <<<< ???
| xxxxx.xxx | 1.2.3.4 |

how can this be?

 

[IgorG]

For each hosting subscription only one of the following options can be allocated:

• One IPv4 address
• One IPv6 address
• One IPv4 + one IPv6 address (dual-stack subscriptions)

Assigning multiple IP addresses on one subscription is not supported in Plesk at that moment.
Most probably there is database inconsistency of misconfiguration. Try to check database with

$ plesk repair db

at least.

 

[Michael Huber]

IgorG, i know this. but look in the Database SELECT in the article.

IF(ip.public_ip_address IS NULL, ip.IP_Address, ip.public_ip_address)) SEPARATOR ', ')

i just want the subscriber IP address
this query not run on a fresh up2date install .. i get a list with domain names and IP is enty