• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Issue WARNING: Unable to find "main" IP address in psa database.

iGraphics

Basic Pleskian
Hello,

I face a problem with Plesk upgrade to Obsidian! When I want to upgrade this message appear:

WARNING: Unable to find "main" IP address in psa database. Please, check Unable to list APS applications: Search results could not be loaded at the moment for more details.


I made all steps in this article: Unable to list APS applications: Search results could not be loaded at the moment but same message appear!

EKcpFhjWsAA6PUB

Please Help
 
What is the output of following SQL command:

select id, ip_address, main from IP_Addresses;

?
 
Try the same SQL command after

# plesk bin ipmanage --reread
 
I get
IP addresses were reread from the system.

But Same Message

Please, show me output of SQL command

select id, ip_address, main from IP_Addresses;

after command

# plesk bin ipmanage --reread
 
Code:
# mysql> select id, ip_address, main from IP_Addresses;
# plesk bin ipmanage --reread
IP addresses were reread from the system.
 
As you can see from SQL command, both of your IP addresses has false in main column.
Now you have to set one of them as main with command

mysql> UPDATE IP_Addresses set main='true' WHERE ip_address='x.x.x.x';

where x.x.x.x is IP address which should be main.
 
As you can see from SQL command, both of your IP addresses has false in main column.
Now you have to set one of them as main with command

mysql> UPDATE IP_Addresses set main='true' WHERE ip_address='x.x.x.x';

where x.x.x.x is IP address which should be main.
Thank you so much ... I have IPv6 Must make it True too ?
 
Back
Top