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

[iGraphics]

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!

Please Help

 

[IgorG]

What about

# plesk repair db

?

 

[iGraphics]

What about

# plesk repair db

?

Thank you for reply, I made it but nothing same message appear: Unable to find "main" IP address in psa database.

 

[IgorG]

What is the output of following SQL command:

select id, ip_address, main from IP_Addresses;

?

 

[iGraphics]

What is the output of following SQL command:

select id, ip_address, main from IP_Addresses;

?

Nothing appear!

 

[IgorG]

Try the same SQL command after

# plesk bin ipmanage --reread

 

[iGraphics]

Try the same SQL command after

# plesk bin ipmanage --reread

I get
IP addresses were reread from the system.

But Same Message

 

[IgorG]

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

 

[iGraphics]

Please, show me output of SQL command

select id, ip_address, main from IP_Addresses;

after command

# plesk bin ipmanage --reread

 

[iGraphics]

# mysql> select id, ip_address, main from IP_Addresses;
# plesk bin ipmanage --reread
IP addresses were reread from the system.

 

[IgorG]

# mysql> select id, ip_address, main from IP_Addresses;

Have you run this command after

# plesk db

?

 

[iGraphics]

Have you run this command after

# plesk db

?

What is NEXT ?

 

[IgorG]

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.

 

[iGraphics]

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 ?

 

[IgorG]

No. Only one IP address can be main.