Resolved Pre-upgrade check from 12.0.18 to 12.5.30 warning

[Jat]

Hi,

I'm trying to upgrade to the last Plesk panel version in a Ubuntu 14.04 server, but i get this warning:

"Parallels Panel pre-upgrade check...
/etc/init.d/apparmor: 35: .: Can't open /lib/apparmor/functions
WARNING: Unable to find "main" IP address in psa database. Please, check http://kb.odin.com/en/112417 for more details."

I have followed the kb resolution showed in the message but still showing the same warning.
Apparmor is not installed in my system.

 

[IgorG]

But do you have file /etc/init.d/apparmor on your server? Make sure that Apparmor package is completely uninstalled and disable apparmor init script with

# /etc/init.d/apparmor stop
# /etc/init.d/apparmor teardown
# update-rc.d -f apparmor remove

 

[Jat]

Hi,

I have renamed the appamor init script and now i don't get the appamor error, but still getting the "WARNING: Unable to find "main" IP address in psa database." and the KB resolution is not working for me.
Any idea?

 

[IgorG]

Try to fix it with

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

 

[Jat]

I already did it, this procedure is in the KB but not resolve

root@xxxx:/etc/init.d# /usr/local/psa/bin/ipmanage --reread
IP addresses were reread from the system.

 

[IgorG]

And what is output of following SQL query from psa database?

select id, ip_address, main from IP_Addresses;

 

[Jat]

The showed IP is the correct one:

id ip_address main
2 159.171.xxx.xxx false

 

[IgorG]

Set it to 'true' with

update IP_Addresses set main='true' where id=2;

BTW, it is strange that you have not IP address with id=1 and main='true' in this table. Are you sure that you have no missing IP address?

 

[Jat]

Not sure what do you mean with missing IP address. This two links show the IP setup i have in the server:

http://screencast.com/t/YjAfKT4MqcW
http://screencast.com/t/K9FVoO2Lu

Now i'm done with that command, this is the output:

mysql> update IP_Addresses set main='true' where id=2;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select id, ip_address, main from IP_Addresses;
+----+----------------+------+
| id | ip_address | main |
+----+----------------+------+
| 2 | 159.171.xxx.xxx | true |
+----+----------------+------+

Must i try to update Plesk now, or need to do any other step before?

 

[IgorG]

Ok. Try to run update again.

 

[Jat]

Ok, the update process has already begun, i will take further contact when it's finish.

 

[Jat]

It seems that update process have finished without errors.

Thank for your help, have a nice day!

 

[CoyoteKG]

Hi,
I have the same issue but with updating Onyx version to 17.5.3.
Pre-upgrade check show "WARNING: Unable to find "main" IP address in psa database."
I read KB article Unable to list APS applications: Search results could not be loaded at the moment
and yes, I have in plesk database two IP-s with false main status

1. 188.99.xx.xxx false
2. 22a01:4f8:10a:xxxx::2 false

Those two IP-s are in Tools and Settings, and I Reread it, but nothing changed.
Is it safe to change that 1. IP to True, and after that run update?
What's the worst that can happen?

 

[Bitpalast]

Yes it is safe. You can simply manually update the data set to "true". The major difference afterwards is that the IP address will be shown in bold face type and that Plesk prohibits its removal through the GUI IP address function. Else there are no consequences that follow from the manual change.

 

[CoyoteKG]

Helo Peter,
thank you for answer.

I changed it and updated plesk to 17.5.3.
And yes, that IP address after changing status to true, was bold.
After rereading IPs, again status for that IP was changed to "false"

 

[Bitpalast]

I do not know why this is happening, I think it is a bug, but don't really know whether it is or whether a setting on the server is causing the utility to treat both IP addresses equally and set both to false.