• 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 11.5 installation failure. cl-mysql-server.

ArtemF

Basic Pleskian
Hello,

I have cloudlinux 6.4 with cl-MySQL-server-5.6.13-1.el6.4.cloudlinux.x86_64 installed.
Plesk installation fails with errors:
Exception: Failed to solve dependencies:
plesk-core-11.5.30-rhel6.build115130819.13.x86_64 requires mysql-server >= 5.0.60
pp11.5.30-bootstrapper-11.5.30-cos6.build115131112.14.x86_64 requires mysql-server >= 5.0.60

How to resolve this dependency problem?
 
You seem to be already running MySQL and an older version ...Perhaps start by removing it (if you have nothing much to loose) and then again attempt to install plesk.
 
Hi abdi,

mysqld --version
mysqld Ver 5.6.13-cll-lve for Linux on x86_64 (MySQL Community Server (GPL))
 
Apparently, CL repo maintainers decided that their MySQL packages are not compatible with vanilla mysql-server (by not providing 'mysql-server', you may check this via $ rpm -qp cl-MySQL-server-5.6.13-1.el6.4.cloudlinux.x86_64.rpm --provides or similar command). Therefore you cannot safely use it with Plesk.

Also Plesk <= 11.5 doesn't support MySQL >= 5.6.
 
I've completely removed all mysql components. Now i have following installation error:
===> 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:eek: < 0 0 undo n:eek: < 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.
 
As I said, features enabled by default since 5.6 are not supported by Plesk 11.5. Most probably your MySQL installation operates in one of the strict modes, e.g. STRICT_TRANS_TABLES SQL mode is on. Maybe this happened due configs from newer MySQL version being used. Try disabling strict mode before installation.
 
Nikolay, you were right:
mysql> SELECT @@GLOBAL.sql_mode;
+--------------------------------------------+
| @@GLOBAL.sql_mode |
+--------------------------------------------+
| STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION |
+--------------------------------------------+
Unfortunately adding "sql_mode" parameter with different options under "[mysqld]" section does nothing. It seems like it is better to reinstall OS, because mysql installation seems to be broken and reinstalling mysql doesn't change situation.
 
Back
Top