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

[Carlos AlbertoO]

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

 

[IgorG]

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;

 

[Carlos AlbertoO]

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

 

[Carlos AlbertoO]

+------------+---------+-----------------------------------------------------------+--------------+------+------------+
| 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

 

[IgorG]

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

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)

 

[Carlos AlbertoO]

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

 

[IgorG]

Did you checked that mysqld service was correctly started?

 

[Carlos AlbertoO]

# service mysqld start
MySQL Daemon failed to start.
Iniciando MySQL: [FAIL]

 

[IgorG]

Try to find reason in /var/log/mysqld.log log file. If you can't fix it - contact Support Team.

 

[Carlos AlbertoO]

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

 

[IgorG]

http://www.parallels.com/support/