Facebook
Twitter
Hi
I have search solution on forum to problems below and could not find any fix.Can guru please bring some light
as most importantly our postfix is not worming and all mail boxes unacceptable
1. In control panel when we press Websites &Domain error page SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.domainaliases' doesn't exist
as well as mail tab same error
We recently upgrade to 11.0.9
Solution tried
/usr/local/psa/bootstrapper/pp11.0.9-bootstrapper/bootstrapper.sh repair
/usr/local/psa/admin/sbin/mchk -without-spam
/usr/local/psa/admin/sbin/autoinstaller --select-release-current --install-component postfix
/etc/init.d/psa start
/usr/local/psa/admin/sbin/httpdmng --reconfigure-all
mysql_upgrade -T --debug-check -u admin -p`cat /etc/psa/.psa.shadow` mysql
/usr/local/psa/bootstrapper/pp11.0.9-bootstrapper/bootstrapper.sh repair comes back with error
We
I have search solution on forum to problems below and could not find any fix.Can guru please bring some light
as most importantly our postfix is not worming and all mail boxes unacceptable
1. In control panel when we press Websites &Domain error page SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.domainaliases' doesn't exist
as well as mail tab same error
We recently upgrade to 11.0.9
Solution tried
/usr/local/psa/bootstrapper/pp11.0.9-bootstrapper/bootstrapper.sh repair
/usr/local/psa/admin/sbin/mchk -without-spam
/usr/local/psa/admin/sbin/autoinstaller --select-release-current --install-component postfix
/etc/init.d/psa start
/usr/local/psa/admin/sbin/httpdmng --reconfigure-all
mysql_upgrade -T --debug-check -u admin -p`cat /etc/psa/.psa.shadow` mysql
/usr/local/psa/bootstrapper/pp11.0.9-bootstrapper/bootstrapper.sh repair comes back with error
Code:
**** Product repair started.
===> Checking for previous installation ... found.
Create user 'psaadm' and group 'psaadm'
Checking for the group 'psaadm'...
Group 'psaadm' already exists
Checking for the user 'psaadm'...
User 'psaadm' already exists
Create group swkey-data
Checking for the group 'swkey-data'...
Group 'swkey-data' already exists
Checking for the group 'swkey-data'...
Trying to add supplementary group 'swkey-data' for user 'psaadm'... already there
Create Mail accounts
Checking for the group 'popuser'...
Group 'popuser' already exists
Checking for the user 'popuser'...
User 'popuser' already exists
Checking for the user 'mhandlers-user'...
User 'mhandlers-user' already exists
Trying to got legacy variables... done
Trying to save legacy variables... done
Checking for the system groups and users necessary for ftp server...
Checking for the group 'psaftp'...
Group 'psaftp' already exists
Checking for the user 'psaftp'...
User 'psaftp' already exists
Trying to start service mysqld... mysqld (pid 2754) is running...
done
Checking for the system groups and users necessary for Apache...
Checking for the group 'apache'...
Group 'apache' already exists
Checking for the user 'apache'...
User 'apache' already exists
===> Checking for the necessary system accounts
Checking for the system groups and users necessary for MySQL...
Checking for the group 'mysql'...
Group 'mysql' already exists
Checking for the user 'mysql'...
User 'mysql' already exists
Checking for the system groups and users necessary for admin server...
Checking for the group 'psaadm'...
Group 'psaadm' already exists
Checking for the user 'psaadm'...
User 'psaadm' already exists
Checking for the group 'psaserv'...
Group 'psaserv' already exists
Checking for the group 'psaserv'...
Trying to add supplementary group 'psaserv' for user 'apache'... already there
Checking for the group 'psaserv'...
Trying to add supplementary group 'psaserv' for user 'psaftp'... already there
Checking for the group 'psaserv'...
Trying to add supplementary group 'psaserv' for user 'psaadm'... already there
Checking for the group 'psacln'...
Group 'psacln' already exists
Trying to start service mysqld... mysqld (pid 2754) is running...
done
Trying to establish test connection... connected
done
Trying to backup MySQL database... done
MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.11.0.9-11.0.9.20130907-154343.dump.gz
Checking that /usr/local/psa/bin/chrootsh registered as login shell...
/usr/local/psa/bin/chrootsh already registered as a login shell
Create PPSB support group
Checking for the group 'psasb'...
Group 'psasb' already exists
Checking for the group 'psasb'...
Trying to add supplementary group 'psasb' for user 'psaadm'... already there
Checking for the group 'psasb'...
Trying to add supplementary group 'psasb' for user 'apache'... already there
===> Performing safe prep-install database actions
===> Upgrading database
Trying to start service mysqld... mysqld (pid 2754) is running...
done
Trying to establish test connection... connected
done
Trying to find psa database... version is 011009
Version is OK, no need to create psa database.
Trying to backup MySQL database... done
MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.11.0.9-11.0.9.20130907-154347.dump.gz
no upgrade from 80
no upgrade from 81
no upgrade from 82
no upgrade from 83
no upgrade from 84
no upgrade from 86
no upgrade from 90
no upgrade from 92
no upgrade from 93
no upgrade from 95
no upgrade from 100
no upgrade from 101
no upgrade from 107
no upgrade from 108
no upgrade from 109
no upgrade from 1010
no upgrade from 1011
no upgrade from 1012
no upgrade from 1013
no upgrade from 1100
Trying to set psa database version to 011009... Warning: there are no bootstrapper prep_install actions for component 'horde'
Warning: there are no bootstrapper prep_install actions for component 'mail-pc-driver'
Trying to start service mysqld... mysqld (pid 2754) is running...
done
Trying to establish test connection... connected
done
Service /etc/init.d/courier-imap failed to restart
Service /etc/init.d/courier-imap failed to restart
Trying to generate default psa SSL Certificate... default certificate already exists
done
Trying to add header to file /etc/awstats/awstats.model.conf... file /etc/awstats/awstats.model.conf already contains required header
Trying to install PAM module... PAM configuration loaded from (directory="/etc/pam.d", file="/etc/pam.conf"). Configuration contains 53 file(s)
calculated 1 position(s) to change 'password' stacks
required 'password' stack(s) modified (in memory)
PAM configuration saved (directory="/etc/pam.d", file="/etc/pam.conf")
done
Checking that /bin/false registered as login shell...
/bin/false already registered as a login shell
Trying to add header to file /etc/xinetd.d/ftp_psa... file /etc/xinetd.d/ftp_psa already contains required header
Checking for ftp home directory for 'clients' group...
@psacln
'@psacln' is already in the /etc/ftpchroot
Trying to register service xinetd... done
Trying to restart service xinetd... xinetd (pid 2499) is running...
Stopping xinetd: [60G[[0;32m OK [0;39m]
Starting xinetd: [60G[[0;32m OK [0;39m]
done
Checking for the group 'psaadm'...
Trying to add supplementary group 'psaadm' for user 'sw-cp-server'... already there
Trying to register service xinetd... done
Setting the default locale
The default locale is set to en-US (ENGLISH, UNITED STATES)
===> Installing rbash
Checking that /bin/rbash registered as login shell...
/bin/rbash
/bin/rbash is already registered as login shell
Trying to define valid mysql credentials... Trying to establish test connection... connected
done
Trying to start service mysqld... mysqld (pid 2754) is running...
done
Trying to establish test connection... connected
done
===> Installing Admin Server
===> Installing Apache Server
Trying to stop service httpd... httpd (pid 4713) is running...
Stopping httpd: [60G[[0;32m OK [0;39m]
done
Copying apache files... done
===> Installing and configuring Named Server
Checking for the system groups and users necessary for named (bind)...
Checking for the group 'named'...
Group 'named' already exists
Checking for the user 'named'...
User 'named' already exists
Stop running named daemon
Trying to stop service named... number of zones: 6
debug level: 0
xfers running: 0
xfers deferred: 0
soa queries in progress: 0
query logging is OFF
recursive clients: 0/1000
tcp clients: 0/100
server is up and running
named (pid 3023) is running...
Stopping named: [60G[[0;32m OK [0;39m]
done
Trying to untar named run-root directory structure...
ERROR while trying to untar named run-root directory structure
Check the error reason(see log file: /tmp/plesk_11.0.9_installation.log), fix and try again
===> Restoring database from backup /var/lib/psa/dumps/mysql.preupgrade.11.0.9-11.0.9.20130907-154347.dump.gz
**** Product repair failed.
***** problem report *****
ERROR while trying to untar named run-root directory structure
Check the error reason(see log file: /tmp/plesk_11.0.9_installation.log), fix and try again
STOP Bootstrapper 11.0.9 repair AT Sat Sep 7 15:43:59 BST 2013
Last edited:
