• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Get hosting IP address in psa database

Samuelcr

New Pleskian
Hello,

I guess a change in psa has been made in this version.

In previous versions i could get IP address with hosting.ip_address_id pointing to IP_Addresses table.

Now this reference is always "0". Where can i find that relationship now?

Thank!
 
I answer to mysqelf.

Form some mysterious reason that relationship is now in dom_param.

dom_id points to hosting.dom_id
look for a param = 'ip_addr_id'
Its value points to IP_Addresses.

So, for example...

SELECT domains.name, IP_Addresses.ip_address
FROM domains
INNER JOIN hosting ON domains.id = hosting.dom_id
INNER JOIN dom_param ON hosting.dom_id = dom_param.dom_id AND dom_param.param = 'ip_addr_id'
INNER JOIN IP_Addresses ON dom_param.val = IP_Addresses.id

A pain in the *** to obtain consistently the IP through versions... tough...
 
Back
Top