Still doesnt work...
Hello,
I am upgrading our Ubuntu 10.04 server from 10.2 to 10.3 and have followed the instructions here with no luck:
Here is a step by step:
root@dev:~# mysql -h 127.0.0.1 -P 3306 -uadmin -p`cat /etc/psa/.psa.shadow`
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 999
Server version: 5.1.41-3ubuntu12.10 (Ubuntu)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> exit
Bye
root@dev:~# /opt/psa/bootstrapper/pp10.12.0-bootstrapper/bootstrapper.sh repair
config updated
===> Updated /etc/psa/psa.conf
===> Preparing upgrade
Stopping psa... done
Stopping mail handlers tmpfs storage
psa is stopped
Stopping psa... done
Stopping mail handlers tmpfs storage
===> Cumulative database upgrade has been started
===> Upgrade completed.
System start/stop links for /etc/init.d/xinetd already exist.
System start/stop links for /etc/init.d/xinetd already exist.
Module ssl already enabled
ln: creating symbolic link `/var/named/run-root/etc/bind/rndc.conf': File exists
update-rc.d: /etc/init.d/named: file does not exist
mknod: `/var/www/vhosts/chroot/dev/null': File exists
Module suexec already enabled
Module include already enabled
Module rewrite already enabled
Module userdir already enabled
**** 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
Checking for the system groups and users necessary for Apache...
Checking for the group 'www-data'...
Group 'www-data' already exists
Checking for the user 'www-data'...
User 'www-data' 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 'www-data'... 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 mysql... /usr/sbin/mysqld (pid 15337) 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.10.11.0-10.12.0.20110725-115440.dump.gz
Checking that /opt/psa/bin/chrootsh registered as 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 'www-data'... already there
===> Performing safe prep-install database actions
===> Upgrading database
Trying to start service mysql... /usr/sbin/mysqld (pid 15337) is running...
done
Trying to establish test connection... connected
done
Trying to find psa database... version is 010120
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.10.11.0-10.12.0.20110725-115441.dump.gz
no upgrade for 80
no upgrade for 81
no upgrade for 82
no upgrade for 83
no upgrade for 84
no upgrade for 86
no upgrade for 90
no upgrade for 92
no upgrade for 93
no upgrade for 95
no upgrade for 100
no upgrade for 101
no upgrade for 107
no upgrade for 108
no upgrade for 109
no upgrade for 1010
no upgrade for 1011
no upgrade for 1012
Trying to set psa database version to 010120... Warning: there are no bootstrapper prep_install actions for component 'horde'
Trying to generate default psa SSL Certificate... default certificate already exists
done
Trying to install PAM module... PAM configuration loaded from (directory="/etc/pam.d", file="/etc/pam.conf"). Configuration contains 25 file(s)
PAM configuration saved (directory="/etc/pam.d", file="/etc/pam.conf")
done
Checking that /bin/false registered as login shell...
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... * Stopping internet superserver xinetd
...done.
* Starting internet superserver xinetd
...done.
done
Trying to restart service xinetd... * Starting internet superserver xinetd
...fail!
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
Trying to restart service xinetd... * Stopping internet superserver xinetd
...done.
* Starting internet superserver xinetd
...done.
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 mysql... /usr/sbin/mysqld (pid 15337) is running...
done
Trying to establish test connection... connected
done
===> Installing Admin Server
===> Installing Apache Server
Trying to stop service apache2... * Stopping web server apache2
... waiting ...done.
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 'bind'...
Group 'bind' already exists
Checking for the user 'bind'...
User 'bind' already exists
Stop running named daemon
Trying to stop service bind9... * Stopping domain name service... bind9
WARNING: key file (/etc/bind/rndc.key) exists, but using default configuration file (/etc/bind/rndc.conf)
named: no process found
named: no process found
named: no process found
named: no process found
named: no process found
named: no process found
named: no process found
named: no process found
named: no process found
named: no process found
...done.
done
Trying to untar named run-root directory structure... mknod: `dev/random': File exists
mknod: `dev/urandom': File exists
done
Trying to set up default permissions... done
Trying to register service named... done
Trying to stop service bind9... done
Trying to start service bind9... * Starting domain name service... bind9
...done.
done
Trying to install chrooted environment... `/bin/bash' -> `bash'
`/bin/cat' -> `cat'
`/bin/cp' -> `cp'
`/bin/grep' -> `grep'
`/usr/bin/head' -> `head'
`/usr/bin/id' -> `id'
`/bin/less' -> `less'
`/bin/ln' -> `ln'
`/bin/ls' -> `ls'
`/bin/mkdir' -> `mkdir'
`/bin/more' -> `more'
`/bin/mv' -> `mv'
`/bin/pwd' -> `pwd'
`/bin/rm' -> `rm'
`/bin/rmdir' -> `rmdir'
`/bin/sh' -> `sh'
`/usr/bin/tail' -> `tail'
`/bin/touch' -> `touch'
`/usr/bin/du' -> `du'
`/usr/bin/vi' -> `vi'
`/bin/true' -> `true'
`/bin/false' -> `false'
`/usr/bin/scp' -> `scp'
`/usr/bin/groups' -> `groups'
Trying to install sftp-server binary into chroot environment... `/usr/lib/openssh/sftp-server' -> `/var/www/vhosts/chroot/usr/lib/openssh/sftp-server'
done
done
===> Installing phpMyAdmin
Trying to create pmadb... done
done
===> Installing /usr/lib/apache2/suexec replacement
Leaving `diversion of /usr/lib/apache2/suexec to /usr/lib/apache2/suexec.distrib by psa'
`/opt/psa/suexec/psa-suexec' -> `/usr/lib/apache2/suexec'
Trying to set up APS controller database... Attempting to check APS db connection via ODBC, using /usr/bin/isql (empty output is good)
[ISQL]ERROR: Could not SQLConnect
Failed, rc = 1.
Attempting to check APS db connection via ODBC, using /usr/bin/iusql (empty output is good)
[ISQL]ERROR: Could not SQLDriverConnect
Failed, rc = 1.
Failed to establish test connection. Cleaning up.
ERROR while trying to establish test connection to APS database via ODBC
Check the error reason(see log file: /tmp/plesk_10.3.0_installation.log), fix and try again
***** problem report *****
ERROR while trying to establish test connection to APS database via ODBC
Check the error reason(see log file: /tmp/plesk_10.3.0_installation.log), fix and try again
Your help is appreciated.