Unable to find "main" IP address in "psa" database
A server with multiple IP addresses was planned to be upgraded from Plesk 17 (Onyx) to Plesk 18 (Obsidian). This was not possible because the server's main IP got lost or could not be determined by Plesk. To solve this problem, log on to your linux server using ssh as user root and execute the following command: /usr/local/psa/bin/ipmanage --reread
It may very well be possible that this operations fails, so it's best to look it up manually, just in case:
- RHEL/CentOS
[root@server ~]# grep IP /etc/sysconfig/network-scripts/ifcfg-e*
Your primary network interface is called eth0 (eth1, ...) using the traditional naming scheme or something like enp0s31f6, which is named after device type, pci slot and so on. Note down the IP of your primary network interface. - Debian/Alpine
Here you will find the information in /etc/network/interfaces (or /etc/network/interfaces.d/...)
Enter the command plesk db in your ssh terminal and afterwards the following sql command:
mysql> select * from IP_Addresses; +----+----------------------+-----------------+-----------+--------------------+-------------------+-------+--------+---------------+-------------------+-------+ | id | ip_address | mask | iface | ssl_certificate_id | default_domain_id | ftps | status | serviceNodeId | public_ip_address | main | +----+----------------------+-----------------+-----------+--------------------+-------------------+-------+--------+---------------+-------------------+-------+ | 1 | 138.201.2.2 | 255.255.255.255 | enp0s31f6 | 3 | 0 | false | 0 | 1 | 138.201.2.2 | true | | 2 | 2a01:4f8:123:123::2 | 64 | enp0s31f6 | 3 | 0 | false | 0 | 1 | NULL | false | | 3 | 138.201.2.3 | 255.255.255.255 | enp0s31f6 | 3 | 0 | false | 0 | 1 | NULL | false | +----+----------------------+-----------------+-----------+--------------------+-------------------+-------+--------+---------------+-------------------+-------+
Have a look at the last column called main (you may need to scroll to the right). If all entries show false, then change the following sql command to reflect your IP address and execute it:
UPDATE IP_Addresses set main='true' WHERE ip_address='138.201.2.2';
Now you can leave mysql monitor by entering \q or STRG d.