Problem after upgrade

[FabrizioR]

Hello,

I update plesk with

/usr/local/psa/admin/sbin/autoinstaller --select-release-id PLESK_9_5_4 --upgrade-installed-components

It was fine, no error.
Now, when I try to connect to my plesk I get this error:

Configuration variable not found: PLESK_LIBEXEC_DIR

and I can't see the panel

Could please someone help me?
Thanks!

 

[FabrizioR]

Solved,

I manually added

# Plesk fix
PLESK_MAILNAMES_D /var/qmail/mailnames

and

# Directory for service utilities
PLESK_LIBEXEC_DIR /usr/lib/plesk-9.0

to my /etc/psa/psa.conf

But now I have a really big problem and I don't know how to solve it.
When I try to access to my panel, I see this error:

ERROR: PleskFatalException
Components::componentUpdate() failed: Unable to exec utility packagemng: packagemng: Unable to clean BackendCache in DB: Table 'psa.BackendCache' doesn't exist

Additionally, an exception has occurred while trying to report this error: PleskMainDBException
MySQL query failed: Table 'psa.PersistentCache' doesn't exist

0: auth.php3:491


Could some one tell me more about this error?
Thank you.

 

[IgorG]

Seems Plesk was not correctly upgraded. Check that you haven't mismatch in version in database and other places:

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` -Dpsa -e"SELECT * FROM misc WHERE param = 'version'"

# cat /usr/local/psa/version ; rpm -q psa

Contact Support Team if you can't repair this broken upgrade by yourself.

 

[FabrizioR]

Hi Igor,

thank you so much for your answer.

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` -Dpsa -e"SELECT * FROM misc WHERE param = 'version'"
+---------+------+
| param | val |
+---------+------+
| version | 0821 |
+---------+------+
# cat /usr/local/psa/version ; rpm -q psa
Version : 9.5.4
Release : rhel4.build95101209.08
psa-9.5.4-rhel4.build95101209.08

Seems like on database there is an old version of plesk
Is there a way to update the schema to the 9.5.4 ?
I'm creating the missing table by hand but it does not work. Now I have a different sql error:

ERROR: PleskMainDBException
MySQL query failed: Unknown column 'c1.type' in 'field list'

Additionally, an exception has occurred while trying to report this error: PleskMainDBException
MySQL query failed: Unknown column 'c1.type' in 'field list'

0: common_func.php3:206
db_query(string 'select c1.id, c1.type
from (((clients c1
inner join clients c2 on c1.parent_id=c2.id)
inner join ip_pool p1 on c1.pool_id = p1.id)
inner join ip_pool p2 on c2.pool_id = p2.id)
inner join IP_Addresses ip on ip.id = p1.ip_address_id
where p2.type="exclusive" and ip.ip_address = "216.139.224.168" and p2.ip_address_id = p1.ip_address_id')
1: common_func.php3:253
db_query_ex(string 'select c1.id, c1.type
from (((clients c1
inner join clients c2 on c1.parent_id=c2.id)
inner join ip_pool p1 on c1.pool_id = p1.id)
inner join ip_pool p2 on c2.pool_id = p2.id)
inner join IP_Addresses ip on ip.id = p1.ip_address_id
where p2.type="exclusive" and ip.ip_address = "?(ip)" and p2.ip_address_id = p1.ip_address_id', array)
2: elements.php3:911
getCustomPageTitle(object of type UserNone)
3: elements.php3:884
getPleskTitle()
4: login.php3:23

Do you know if there is a way to upgrade (or re-install) Plesk database schema?

Thank you.

 

[IgorG]

Yes, database was not upgraded for some reason.
Recovering of such type of broken upgrade is not simple task. Therefore I suggest you contact Support Team.