• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

404 - Not Found for Plesk control panel after upgrade to 10.3.1

F

Funboy-63

Guest
Hi,

I have upgrade to 10.3.1 using the command line. Once it had finished, I am no longer able to access the Parallels Plesk control panel or Customer & Business Manager. All admin pages just give me a 404 - Not Found error.

All hosted websites are working although Horde webmail is not.

This is dedicated server - hosted by 1and1.

#cat /etc/*release*
CentOS release 5.7 (Final) (64 -bit)

#mysql -h sparc -V
mysql Ver 14.14 Distrib 5.5.17, for Linux (x86_64)

#php -v
PHP 5.3.8 (cli) (built: Oct 31 2011 18:26:52)
Copyright (c) 1997-2011 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2011 Zend Technologies
with eAccelerator v0.9.6-svn358-dev, Copyright (c) 2004-2007 eAccelerator, by eAccelerator
with the ionCube PHP Loader v4.0.10, Copyright (c) 2002-2011, by ionCube Ltd., and
with Zend Guard Loader v3.3, Copyright (c) 1998-2010, by Zend Technologies


Have checked for error messages within /var/log/sw-cp-server/error_log

all children busy, launch additional (total 3, limit 30)
all children busy, launch additional (total 3, limit 30)
2011-11-09 23:11:04: (log.c.135) server stopped
2011-11-10 00:41:26: (log.c.75) server started
2011-11-10 00:41:33: (log.c.135) server stopped
2011-11-10 00:41:34: (log.c.75) server started
2011-11-10 00:41:47: (log.c.135) server stopped
2011-11-10 00:41:47: (log.c.75) server started

But the above means little to me. Any help no matter how small on what is required to fixed this greatly appreciated.
 
Have since tried:

/usr/local/psa/bootstrapper/pp10.12.0-bootstrapper/bootstrapper.sh repair

Resulting in the following:

#/usr/local/psa/bootstrapper/pp10.12.0-bootstrapper/bootstrapper.sh repair
Changing shell for popuser.
Shell not changed.
Changing shell for mhandlers-user.
Shell not changed.
===> Preparing upgrade
===> Cumulative database upgrade has been started

**** 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 2473) 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 2473) 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.20111110-083901.dump.gz
httpsd: no process killed
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 2473) is running...
done
Trying to establish test connection... connected
done
Trying to find psa database... version is 010110
Trying to backup MySQL database... done
MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.10.11.0-10.12.0.20111110-083903.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
===> Perform upgrade to 1011
Trying to remove /usr/local/psa/admin/sbin/backupmng from crontab... done
ERROR 1005 (HY000) at line 5: Can't create table './psa/BackupsScheduled.frm' (errno: 121)

=====================================
111110 8:39:07 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 13 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 14, signal count 14
Mutex spin waits 0, rounds 116, OS waits 0
RW-shared spins 26, OS waits 13; RW-excl spins 1, OS waits 1
------------
TRANSACTIONS
------------
Trx id counter 0 119313
Purge done for trx's n:eek: < 0 119277 undo n:eek: < 0 0
History list length 52
Total number of lock structs in row lock hash table 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0 0, not started, process no 2473, OS thread id 1103051072
MySQL thread id 5718, query id 164827 localhost admin
SHOW ENGINE innodb status
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (write thread)
Pending normal aio reads: 0, aio writes: 0,
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
370 OS file reads, 332 OS file writes, 123 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.08 writes/s, 0.08 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2,
9 inserts, 9 merged recs, 9 merges
Hash table size 17393, used cells 319, node heap has 2 buffer(s)
0.08 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 0 32532190
Log flushed up to 0 32532180
Last checkpoint at 0 32532170
0 pending log writes, 0 pending chkp writes
98 log i/o's done, 0.08 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 20783082; in additional pool allocated 1034240
Buffer pool size 512
Free buffers 51
Database pages 459
Modified db pages 2
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 360, created 99, written 397
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Main thread process no. 2473, id 1166100800, state: sleeping
Number of rows inserted 282, updated 2, deleted 1, read 852
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 21.23 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================


ERROR while trying to install backup manager tables during upgrade
Check the error reason(see log file: /tmp/plesk_10.3.1_installation.log), fix and try again

***** problem report *****
ERROR while trying to install backup manager tables during upgrade
Check the error reason(see log file: /tmp/plesk_10.3.1_installation.log), fix and try again
 
Last edited by a moderator:
/tmp/plesk_10.3.1_installation.log

SNIP data same as above:

ERROR while trying to install backup manager tables during upgrade
Check the error reason(see log file: /tmp/plesk_10.3.1_installation.log), fix and try again


===> Restoring database from backup /var/lib/psa/dumps/mysql.preupgrade.10.11.0-10.12.0.20111110-083941.dump.gz


**** Product repair failed.

***** problem report *****
ERROR while trying to install backup manager tables during upgrade
Check the error reason(see log file: /tmp/plesk_10.3.1_installation.log), fix and try again
STOP Bootstrapper 10.12.0 repair AT Thu Nov 10 08:39:49 GMT 2011

So how to resolve backup manager table issues?
 
Hi IgorG,

Here is the hard drive space output.

# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 3.7G 1.9G 1.9G 50% /
/dev/mapper/vg00-usr 146G 7.5G 139G 6% /usr
/dev/mapper/vg00-var 196G 23G 174G 12% /var
/dev/mapper/vg00-home
66G 56M 66G 1% /home
/usr/tmpDSK 6.0G 862M 4.8G 16% /tmp
/usr/tmpDSK 6.0G 862M 4.8G 16% /tmp
 
Full readout: /tmp/plesk_10.3.1_installation.log


START Bootstrapper 10.12.0 repair AT Thu Nov 10 14:18:15 GMT 2011

**** 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 2473) 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 2473) 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.20111110-141817.dump.gz
httpsd: no process killed
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 2473) is running...
done
Trying to establish test connection... connected
done
Trying to find psa database... version is 010110
Trying to backup MySQL database... done
MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.10.11.0-10.12.0.20111110-141820.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
===> Perform upgrade to 1011
Trying to remove /usr/local/psa/admin/sbin/backupmng from crontab... done
ERROR 1005 (HY000) at line 5: Can't create table './psa/BackupsScheduled.frm' (errno: 121)

=====================================
111110 14:18:22 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 30 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 38, signal count 38
Mutex spin waits 0, rounds 196, OS waits 2
RW-shared spins 70, OS waits 35; RW-excl spins 1, OS waits 1
------------
TRANSACTIONS
------------
Trx id counter 0 120249
Purge done for trx's n:eek: < 0 120213 undo n:eek: < 0 0
History list length 247
Total number of lock structs in row lock hash table 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0 0, not started, process no 2473, OS thread id 1103051072
MySQL thread id 8392, query id 307643 localhost admin
SHOW ENGINE innodb status
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (write thread)
Pending normal aio reads: 0, aio writes: 0,
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
445 OS file reads, 1328 OS file writes, 488 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2,
9 inserts, 9 merged recs, 9 merges
Hash table size 17393, used cells 319, node heap has 2 buffer(s)
0.03 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 0 33170037
Log flushed up to 0 33170027
Last checkpoint at 0 33170027
0 pending log writes, 0 pending chkp writes
409 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 20880026; in additional pool allocated 1043968
Buffer pool size 512
Free buffers 1
Database pages 509
Modified db pages 1
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 435, created 255, written 1498
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Main thread process no. 2473, id 1166100800, state: sleeping
Number of rows inserted 1524, updated 2, deleted 1, read 3336
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 9.20 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================


ERROR while trying to install backup manager tables during upgrade
Check the error reason(see log file: /tmp/plesk_10.3.1_installation.log), fix and try again


===> Restoring database from backup /var/lib/psa/dumps/mysql.preupgrade.10.11.0-10.12.0.20111110-141820.dump.gz


**** Product repair failed.

***** problem report *****
ERROR while trying to install backup manager tables during upgrade
Check the error reason(see log file: /tmp/plesk_10.3.1_installation.log), fix and try again
STOP Bootstrapper 10.12.0 repair AT Thu Nov 10 14:18:27 GMT 2011

Been banging away at this all day with no joy, as backup manager tables are causing install issues I even noticed that the "psa" is not getting installed within the "/etc/init.d/psa" directory only noticed that once I ran "service psa status" so no wonder its not starting!

Have been trawling the net for an answer but no joy so far, anyone got a bright idea what to try?
 
Back
Top