• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    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.

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
Resolved DB query failed - Deadlock
Replies
16
Views
4K
miguelcarmona
M
R
Issue need help error mariadb
Replies
17
Views
3K
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
22K
Apparire
A
Back
Top