Plesk Onyx for Linux
kb: technical
ABT: Group A
Applicable to:
- Plesk Onyx for Linux
Symptoms
- Plesk cannot be installed:
PLESK_INFO: ERROR 1146 (42S02) at line 1: Table 'psa.misc' doesn't exist
- Plesk autoinstaller cannot create 'psa' database. Also, it is not possible to create the database manually:
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa < /usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/db/psa_db.sql
ERROR 1364 (HY000) at line 141: Field 'pname' doesn't have a default value - MySQL server is running in strict mode:
# plesk db "show variables like 'sql_mode'"
sql_mode | STRICT_TRANS_TABLES,STRICT_ALL_TABLES
Cause
Strict mode does not allow inserting NULL value into a NOT NULL column.
Resolution
- Login to the server over SSH
- Disable the strict mode in
/etc/my.cnf
(RHEL/Centos) or/etc/mysql/my.cnf
(Debian/Ubuntu):CONFIG_TEXT: [mysqld]
sql_mode="" - Restart MySQL server:
# service mysql restart || service mariadb restart || service mysqld restart
Comments
0 comments
Please sign in to leave a comment.