Articles in this section

See more

Unable to list APS applications: Search results could not be loaded at the moment

Avatar
Dinara Tsydenova
Updated
Follow
DoNotDelete:docref kb: fixed kb: bug ABT: Group A Plesk Obsidian for Linux

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:

Resolution

Please consider updating your server:

Workaround

Apply one of the following solutions:

Via Plesk GUI
  1. Log into Plesk.
  2.  Go to Tools & Settings >  IP addresses.
  3. Press the Reread IP button.

    Note: in case the solution did not help, use the steps from the "Via server access" section.

Via Server access
  1. Connect to the server via SSH.
  2.  Run the following command:

    # /usr/local/psa/bin/ipmanage --reread

  3. 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

Sort by Date Votes
  • Avatar
    adrian TNT

    On plesk 17.0.17 I am trying to upgrade to 17.5.3 and I am getting:

    Plesk pre-upgrade check
    WARNING: Unable to find "main" IP address in psa database. Please, check http://kb.plesk.com/en/112417 for more details.
     
    I ran: 
     
    # /usr/local/psa/bin/ipmanage --reread
     
    No change.
     
    So for me this is just another inaccurate article.

    I edited in "Server: localhost:3306 »Database: psa »Table: IP_Addresses" and set the "main" field to true for main ip. 
    Now it works.
     
    BTW, in another table (phpmyadmin > psa database > ip_pool) I see the IPs having same "1" id field, looks like a bug to me, maybe someone used bad table schema when defining the ip_pool table ?! If so, nobody cares I guess.
     
    0
    Comment actions Permalink
  • Avatar
    Konstantin Annikov (Edited )

    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.  

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles