• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

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