Applicable to:
- Plesk Obsidian for Linux
Symptoms
-
Unable to list APS applications for a domain with the error:
PLESK_ERROR: Search results could not be loaded at the moment
-
Unable to upgrade Plesk:
PLESK_ERROR: Unable to find "main" IP address in "psa" database.
-
The following error can be found in
/var/log/sw-cp-server/error_log
file:CONFIG_TEXT: ERR (3): APS Catalog error: Unable to define main IP address
Cause
Product issue:
-
#PPPM-11484 "Re-reading IP addresses on the server no longer results in the same IP address being displayed twice (with and without the “Main IP address” flag in Plesk under specific circumstances."
Fixed in:- Plesk Obsidian 27 October 2020 (Linux)
- Plesk Obsidian 15 September 2020 (Linux)
- Plesk Obsidian 12 May 2020 (Linux)
- Plesk Obsidian 17 March 2020 (Linux)
Resolution
Workaround
Apply one of the following solutions:
- Log into Plesk.
- Go to Tools & Settings > IP addresses.
- Press the Reread IP button.
Note: in case the solution did not help, use the steps from the "Via server access" section.
- Connect to the server via SSH.
- Run the following command:
# /usr/local/psa/bin/ipmanage --reread
-
If the solution above did not help, apply the solution below:
-
Create a backup of
psa
database:# plesk db dump psa > psa.sql
-
Connect to
psa
database in MySQL console:# plesk db
-
Change the value of main to true for one of the IP addresses:
MYSQL_LIN: mysql> UPDATE IP_Addresses set main='true' WHERE ip_address='10.10.10.10';
Note: replace the IP Address 10.10.10.10 with yours one.
-
Comments
2 comments
On plesk 17.0.17 I am trying to upgrade to 17.5.3 and I am getting:
I edited in "Server: localhost:3306 »Database: psa »Table: IP_Addresses" and set the "main" field to true for main ip.
adrianTNT,
Thank you for your input. We have modified the article for the cases when reread does not fix the inconsistency (that case is not typical one. I have tested that in our environment and reread changes 'main' field to true automatically)
As for ip_pool table, several same ids are being added by design. Let me explain that:
ip_pool.id value is connected with clients.ip_pool column. So, every customer has one IP pool assigned. And if a customer has several IP addresses, the same amount of entries with common id will be displayed in ip_pool table.
Please sign in to leave a comment.