• 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.

ERROR: PleskMainDBException MySQL query failed: Unknown table engine 'InnoDB

C

Carlos AlbertoO

Guest
Hi,

Suddenly I can´t connect with my dedicated server, receive this error:

ERROR: PleskMainDBException
MySQL query failed: Unknown table engine 'InnoDB'

0: common_func.php3:206
db_query(string 'select param, val from misc')
1: common_func.php3:625
get_param(string 'mysql41_compatible')
2: common_func.php3:522
db_set_names()
3: common_func.php3:501
db_connect_real(string 'localhost', string 'admin', string '***********', string 'psa')
4: common_func.php3:481
db_connect()
5: auth.php3:90

Linux server with Centos 5.

Regards
 
It looks like default Plesk /etc/my.cnf was changed. Try to restore default and check that engine is really there with

mysql> show engines;
Click to expand...
 
Hi

my.cnf

[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Only change before the problem: Update to php v5.3.3 .

Regards
 
+------------+---------+-----------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+------------+---------+-----------------------------------------------------------+--------------+------+------------+
| ndbcluster | NO | Clustered, fault-tolerant tables | NULL | NULL | NULL |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
+------------+---------+-----------------------------------------------------------+--------------+------+------------+
5 rows in set (0.00 sec)

Mysql:
mysql Ver 14.14 Distrib 5.1.50, for redhat-linux-gnu (i686) using readline 5.1

Php v5.3.3
 
Default my.cnf on fresh Plesk installation on Centos 5:

# cat /etc/my.cnf
[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0

skip-bdb

set-variable = innodb_buffer_pool_size=2M
set-variable = innodb_additional_mem_pool_size=500K
set-variable = innodb_log_buffer_size=500K
set-variable = innodb_thread_concurrency=2
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
skip-bdb

set-variable = innodb_buffer_pool_size=2M
set-variable = innodb_additional_mem_pool_size=500K
set-variable = innodb_log_buffer_size=500K
set-variable = innodb_thread_concurrency=2
Click to expand...


mysql> show engines;
+------------+----------+----------------------------------------------------------------+
| Engine | Support | Comment |
+------------+----------+----------------------------------------------------------------+
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables |
| InnoDB | YES | Supports transactions, row-level locking, and foreign keys |
| BerkeleyDB | DISABLED | Supports transactions and page-level locking |
| BLACKHOLE | NO | /dev/null storage engine (anything you write to it disappears) |
| EXAMPLE | NO | Example storage engine |
| ARCHIVE | NO | Archive storage engine |
| CSV | NO | CSV storage engine |
| ndbcluster | NO | Clustered, fault-tolerant, memory-based tables |
| FEDERATED | NO | Federated MySQL storage engine |
| MRG_MYISAM | YES | Collection of identical MyISAM tables |
| ISAM | NO | Obsolete storage engine |
+------------+----------+----------------------------------------------------------------+
12 rows in set (0.00 sec)
Click to expand...
 
Hi,

Change the my.cnf, and now give me this error:

ERROR: PleskFatalException
Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

0: common_func.php3:146
psaerror(string 'Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)')
1: auth.php3:93

Thanks

Regards
 
Did you checked that mysqld service was correctly started?
 
# service mysqld start
MySQL Daemon failed to start.
Iniciando MySQL: [FAIL]
 
Try to find reason in /var/log/mysqld.log log file. If you can't fix it - contact Support Team.
 
100921 8:15:21 [Note] /usr/libexec/mysqld: Shutdown complete

100921 08:15:21 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100921 08:20:47 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100921 8:20:47 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100921 8:20:47 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100921 8:20:47 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100921 8:20:47 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100921 8:20:47 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100921 8:20:47 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100921 8:20:47 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100921 8:20:47 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100921 8:20:47 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100921 8:20:47 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100921 8:20:47 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100921 8:20:47 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100921 8:20:47 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100921 8:20:47 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100921 8:20:47 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100921 8:20:47 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100921 8:20:47 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100921 8:20:47 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100921 8:20:47 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100921 8:20:47 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100921 8:20:47 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100921 8:20:47 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100921 8:20:47 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100921 8:20:47 [Warning] option 'innodb-additional-mem-pool-size': signed value 512000 adjusted to 524288
100921 8:20:47 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100921 8:20:47 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100921 8:20:47 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibYVqseS' (Errcode: 13)
100921 8:20:47 InnoDB: Error: unable to create temporary file; errno: 13
100921 8:20:47 [ERROR] Plugin 'InnoDB' init function returned error.
100921 8:20:47 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100921 8:20:47 [ERROR] /usr/libexec/mysqld: unknown option '--skip-bdb'
100921 8:20:47 [ERROR] Aborting

100921 8:20:47 [Note] /usr/libexec/mysqld: Shutdown complete

100921 08:20:47 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

How can contact with Support team?

Thanks

Regards
 
You must log in or register to reply here.

Similar threads

G
Issue DB query failed - Deadlock
Replies
2
Views
248
Sebahat.hadzhi
Sebahat.hadzhi
R
Issue need help error mariadb
Replies
17
Views
2K
ramater
R
C
Resolved Mariadb not working - DB query failed: SQLSTATE[HY000] [2002] No such file or directory
Replies
7
Views
3K
Crash79797
C
nisamudeen97
Issue Mysql service stops with [ERROR] InnoDB: CORRUPT LOG RECORD FOUND
Replies
0
Views
2K
nisamudeen97
nisamudeen97
H
Issue DB query failed: SQLSTATE[HY000] [2002] Connection refused
2
Replies
26
Views
21K
Apparire
A
Back
Top