Plesk 8.1.1 upgrade failed, domains down: h.miva problem

[akamaka]

My upgrade form Plesk 8.1.0 to 8.1.1 has failed, now all domains come up with CentOS default page, and websrvmng -av get this error:

websrvmng: Unable to define virtual hosts parameters: Unknown column 'h.miva' in 'field list'
websrvmng: Unable to define virtual hosts parameters: Unknown column 'h.miva' in 'field list'

Have anyone experienced this problem?

Thanks

 

[jluerken]

I am getting the same error message.

SWSoft Support is currently very bad

 

[gorilych]

It seems that upgrade failed for some reason.

You current 'psa' database is not upgraded - this is the reason of "Unknown column 'h.miva' in 'field list'" message

Check the following:

1) Errors during upgrade in /tmp/autoinstaller3.log

2) which psa is installed

# rpm -q psa

3) version file

# cat /usr/local/psa/version

4) psa db version

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e "select * from misc where param='version'"

 

[gorilych]

after checking you might need to reinstall plesk.

Preinstallation steps are:

1) remove psa-8.1.1 rpm from rpmdb if it is installed:

# rpm -e psa-8.1.1 --justdb --nodeps --force

2) install psa-8.1.0 into rpmdb:

# rpm -Uvh --justdb --nodeps --force /root/psa/PSA_8.1.0/dist../base/psa-8.1.0...rpm

2) correct version file to have 8.1.0 version

# echo 8.1.0 OSNAME OSVERSION 8100000 > /usr/local/psa/version

3) correct psa db version

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e "update misc set val='0810' where param='version'"

Installation (use tar.gz file for your distro, i placed here for rhel4 for example):

# wget -c ftp://download1.swsoft.com/Plesk/Plesk8.1/RedHatEL4/psa-8.1.1-rhel4.build81070322.16.i586.rpm.tar.gz
# tar zxf psa-8.1.1-rhel4.build81070322.16.i586.rpm.tar.gz -C swsoft/PSA_8.1.1/
# mv /root/.my.cnf /root/.my.cnf.back
# cd swsoft/PSA_8.1.1/dist-rpm-RedHat-el4-i386/opt/
# rpm -Uvh ../base/* api/* backup/* migration/* updater/* --force
# mv /root/.my.cnf.back /root/.my.cnf

 

[jluerken]

Originally posted by gorilych
It seems that upgrade failed for some reason.

1) Errors during upgrade in /tmp/autoinstaller3.log

These are the last entries

Getting packages to installation list:
Get packages to installation from selected component api
Update package names cache.
Resolve components
Regenerate packages provides cache.
Warning: unresolved requires 'psa = 8.1.0' from psa-api-rpc-8.1.0-suse9.3.build81061226.14.noarch
Warning: unresolved requires 'psa-api = 8.1.0-suse9.3.build81061226.14' from psa-api-rpc-8.1.0-suse9.3.build81061226.14.noarch
PkgManager: start to resolving component all.
findNecessaryPackages(): start pass 0
=== Content of necessaryList of component all ===
(s) system_installed_psa-api-rpc-8.1.1-suse9.3.build81070322.16.noarch.rpm
Check package set before installation

Originally posted by gorilych

2) which psa is installed
# rpm -q psa

psa-8.1.1-suse9.3.build81070322.16

Originally posted by gorilych

3) version file
# cat /usr/local/psa/version

No output after command

Originally posted by gorilych
4) psa db version

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e "select * from misc where param='version'"

+---------+------+
| param | val |
+---------+------+
| version | 0810 |
+---------+------+

 

[gorilych]

it means that version file is empty, psa-8.1.1 rpm was registered, but psa db is still 0810

So you will need to delete psa-8.1.1 from rpmdb and register psa-8.1.0, then fill version file and restart upgrade as described.

 

[jluerken]

Ok I can access the 8.1.1 admin gui again, thanks.

I am searching a way to install all installed packages again to be sure that all files are correct.

I am getting an error message when I try to remove or add applications. I think not all .rpm files are there or correctly installed

sappmng: utility /bin/rpm failed (result=1):
file /usr/local/psa/var/cgitory/phpBB-2.0.17-5 is not owned by any package
sappmng: Cannot get package name for phpBB-2.0.17-5
proc_close() failed:

0: /usr/local/psa/admin/plib/SiteApps/class.cSiteAppManager.php:157
cSiteAppManager->_callSAppMng(string 'test-package-removable', array, string '', array)
1: /usr/local/psa/admin/plib/SiteApps/class.cSiteAppManager.php:165
cSiteAppManager->_callSAppMng1(string 'test-package-removable', array)
2: /usr/local/psa/admin/plib/SiteApps/class.cSiteAppManager.php:358
cSiteAppManager->sappmng_test_package_removable(string 'phpBB-2.0.17-5')
3: /usr/local/psa/admin/plib/SiteApps/class.SiteAppPackageManager.php:413
SiteAppPackageManager->uninstallSiteAppPackageRemove(object of type SiteAppPackage)
4: /usr/local/psa/admin/plib/SiteApps/class.SiteAppPackageManager.php:430
SiteAppPackageManager->uninstallSiteAppPackage(object of type SiteAppPackage)
5: /usr/local/psa/admin/plib/SiteApps/class.ServerSiteAppPackagesList.php:33
ServerSiteAppPackagesList->uninstall(array)
6: /usr/local/psa/admin/htdocs/server/site_app_pkgs.php:60

Do you have a command for this to force 8.1.1 to install again?

 

[jluerken]

Ok I tested a little bit and I can install and uninstall all other applications.
It seems that there is only a double entry for the one above.

Is there a way to delete it manually from the db?

 

[gorilych]

try to install corresponding version of phpBB
rpm -ivh http://autoinstall.plesk.com/PSA_7.5.4/dist-rpm-SuSE-9.3-i386/opt/vault/phpBB-2.0.17-7518.noarch.rpm

this can help

may be you should just delete directory /usr/local/psa/var/cgitory/phpBB-2.0.17-5, but I am not sure about it, application can have links in psa db