Bug #48352 Can't install DB2i plugin

• Submitted: 27 Oct 2009 15:16
• Modified: 11 Mar 2011 7:07
• Reporter: sam Pinkhasov
• Status: Unsupported
• Category: MySQL Server: DB2SE for IBM i
• Severity: S2 (Serious)
• Version: 5.1.35 MySQL Community Server
• OS: IBM i
• CPU Architecture: Any
• Tags: db2, db2, db2, ibm, ibm, ibm, storages, storages, storages

[27 Oct 2009 15:16] sam Pinkhasov

Description:
Running following statment in mysql command line produces an error message

mysql> INSTALL PLUGIN ibmdb2i SONAME "ha_ibmdb2i.so";
ERROR 1146 (42S02): Table 'mysql.plugin' doesn't exist

Sam

How to repeat:
mysql> INSTALL PLUGIN ibmdb2i SONAME "ha_ibmdb2i.so";
ERROR 1146 (42S02): Table 'mysql.plugin' doesn't exist

[27 Oct 2009 22:57] MySQL Verification Team

Could you please verify if actually the plugin table exists in the mysql database. Thanks in advance.

[27 Oct 2009 22:57] MySQL Verification Team

Could you please verify if actually the plugin table exists in the mysql database. Thanks in advance.

[27 Oct 2009 22:57] MySQL Verification Team

Could you please verify if actually the plugin table exists in the mysql database. Thanks in advance.

[28 Oct 2009 3:28] sam Pinkhasov

The ibdb2i plugin exist in .mysql/lib/plugin directory. Here is the list from that directory:
ha_ibmdb2i.a           STMF           
ha_ibmdb2i.la          STMF           
ha_ibmdb2i.so          SYMLNK->STMF   
ha_ibmdb2i.so.0        SYMLNK->STMF   
ha_ibmdb2i.so.0.0. >   STMF

[28 Oct 2009 12:55] MySQL Verification Team

I meant not the plugin but the mysql database table i.e: on Windows:

c:\>dir c:\dbs\5.1\data\mysql\plugin.*
 O volume na unidade C não tem nome.
 O Número de Série do Volume é 12AA-61D8

 Pasta de c:\dbs\5.1\data\mysql

26/10/2009  14:35             8.586 plugin.frm
26/10/2009  14:35                 0 plugin.MYD
26/10/2009  14:35             1.024 plugin.MYI
               3 arquivo(s)          9.610 bytes
               0 pasta(s)   43.290.193.920 bytes disponíveis

[28 Oct 2009 13:05] sam Pinkhasov

Hi,
I do not have following files in MySQL directory in IBM i server:
  plugin.frm
  plugin.MYD
  plugin.MYI

[28 Oct 2009 13:57] Valeriy Kravchuk

Please, try to repeat with a newer version of MySQL server, 5.1.40, and inform about the results.

[29 Nov 2009 0:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

[10 Mar 2011 19:52] Scott Walters

This happens when upgrading to MySQL to 5.1+ on a database created from 5.0 or prior.  I'm commenting here since this is essentially the GoogleBomb for the search `` "ERROR 1146 (42S02): Table 'mysql.plugin' doesn't exist" ''.

Do this at the mysql prompt when logged in as root:

use mysql;

CREATE TABLE `plugin` (
  `name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `dl` char(128) COLLATE utf8_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='MySQL plugins';

Then execute your 'INSTALL PLUGIN' command.

[10 Mar 2011 20:49] Scott Walters

No, ignore that.  That won't actually work.  Run your mysql_upgrade.