• 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

Plesk installation fails. ERROR while trying to install initial psa database

Status
Not open for further replies.

ArtemF

Basic Pleskian
Cloudlinux 6.4 64bit. Mysql 5.1.69
log:
Code:
===> Installing psa database
Trying to check psa database... Trying to find psa database... not found
Trying to install initial psa database... ERROR 1364 (HY000) at line 141: Field 'pname' doesn't have a default value
InnoDB	
=====================================
131128 17:10:37 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 1 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 4, signal count 4
Mutex spin waits 0, rounds 20, OS waits 1
RW-shared spins 4, OS waits 2; RW-excl spins 1, OS waits 1
------------
TRANSACTIONS
------------
Trx id counter 0 1283
Purge done for trx's n < 0 0 undo n < 0 0
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0 0, not started, process no 2308, OS thread id 140656467617536
MySQL thread id 4, query id 15 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
25 OS file reads, 6 OS file writes, 6 OS fsyncs
2.00 reads/s, 16384 avg bytes/read, 3.00 writes/s, 3.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2,
0 inserts, 0 merged recs, 0 merges
Hash table size 17393, node heap has 1 buffer(s)
0.00 hash searches/s, 111.89 non-hash searches/s
---
LOG
---
Log sequence number 0 68813
Log flushed up to 0 68813
Last checkpoint at 0 44233
0 pending log writes, 0 pending chkp writes
11 log i/o's done, 3.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 20364272; in additional pool allocated 737536
Dictionary memory allocated 78208
Buffer pool size 512
Free buffers 476
Database pages 35
Modified db pages 27
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 19, created 16, written 0
2.00 reads/s, 15.98 creates/s, 0.00 writes/s
Buffer pool hit rate 998 / 1000
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Main thread process no. 2308, id 140656244668160, state: sleeping
Number of rows inserted 0, updated 0, deleted 0, read 0
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================


ERROR while trying to install initial psa database
Check the error reason(see log file: /tmp/plesk_11.5.30_installation.log), fix and try again

***** problem report *****
ERROR while trying to install initial psa database
Check the error reason(see log file: /tmp/plesk_11.5.30_installation.log), fix and try again

Bootstrapper has finished action (exec time: 0.05 sec.): parent_name='panel', sequence='prep', stage='execute', sequence_order='0', operation='install', exec_cmd='/usr/local/psa/bootstrapper/pp11.5.30-bootstrapper/bootstrapper.sh prep-install BASE'
~empty
Bootstrapper has finished action (exec time: 0 sec.): parent_name='PLESK_11_5_30', sequence='prep', stage='rollback', sequence_order='1', operation='install', exec_cmd='rm -f /tmp/pp-bootstrapper-mode.flag; rm -f /var/lock/parallels-panel-maintenance-mode.flag; rm -f /var/lock/parallels-panel-upgrade-failure.flag; :'
Execute command /usr/local/psa/admin/bin/send-error-report install
Error: An error occurred during performing of installation PREP actions (see log for details). Installation was rolled back.
 
psa database is actually created. It contains 3 empty tables:
mysql> show tables;
+------------------+
| Tables_in_psa |
+------------------+
| accounts |
| clients |
| password_secrets |
+------------------+
 
After second installation attempt the error is following:
===> Installing psa database
Trying to check psa database... Trying to find psa database... ERROR 1146 (42S02) at line 1: Table 'psa.misc' doesn't exist
....
DATABASE ERROR!!!
Database psa found, but version undefined
 
Hello Igor,

So Cloudlinux 6.4 is not supported? Well, that's surprise, because this page(which could be opened from product main page http://www.parallels.com/products/plesk/):
http://www.parallels.com/download/plesk/11.5/requirements/
states, that CloudLinux 6.x is supported. Moreover "CloudLinux 6.x" is written in bold, which means, that CloudLinux 6.x is recommended by parallels.
Could you please explain, how Cloudlinux 6.4 is not "CloudLinux 6.x"?
Release Notes also show that RHEL 6.4 is not supported. What are your recommendations to people who are already running CloudLinux 6 or RHEL 6? Should they keep there system outdated, full of security holes in order to run plesk?
Or information in "System requirements" page is incorrect?

So if i understand your statement correctly, I've got an error, and that's the way things should be.
I wonder when do parallels plan to add Cloudlinux 6.4 support? Cloudlinux 6.4 was released 4th march 2013 http://www.cloudlinux.com/blog/clnews/cloudlinux-64-is-out.php
so almost 9 months past from release date and plesk still don't have clouldlinux 6.4 support? Even more time past since RHEL 6.4 release and plesk doesn't support it? How is that even possible?
Can anyone else from parallels team officially confirm this?
 
I've reinstalled system from scratch. Cloudlinux 6.5(64 bit) minimal installation. Installation of plesk 11.5 went smoothly. After plesk installation I've installed cloudlinux components(LVE manager, cagefs, php-selector and mysql governor), upgraded MySQL from 5.1 to 5.5 via mysql governor. No problems so far.
 
Status
Not open for further replies.
Back
Top