Bug #34588 PKG postinstall fails due to SQL error
Submitted: 15 Feb 2008 11:24 Modified: 19 Mar 2008 14:52
Reporter: MC Brown Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Installing Severity:S3 (Non-critical)
Version:5.0.56 OS:Solaris (SPARC, SPARC 64-bit)
Assigned to: Gleb Shchepa CPU Architecture:Any

[15 Feb 2008 11:24] MC Brown 
Description:
When running a PKG install of 5.0.56 the postinstall script fails (during mysql_install_db): 

## Executing postinstall script.
ERROR: 1136  Column count doesn't match value count at row 1
080215 10:42:37 [ERROR] Aborting

Running the mysql_install_db after this works fine: 

./scripts/mysql_install_db --user=mysql
Installing MySQL system tables...
OK
Filling help tables...
OK
...

How to repeat:
Run:

pkgadd -d mysql-classic-5.0.56-solaris10-sparc.pkg
[18 Mar 2008 16:22] Gleb Shchepa 
Can't repeat with x86 build on Solaris 10 (mysql-classic-5.0.56-solaris10-i386.pkg)
[19 Mar 2008 14:52] Gleb Shchepa 
Can't repeat on SunOS 5.10 Generic_120011-14 sun4v:

======================================================================

## Executing postinstall script.
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/opt/mysql/mysql/bin/mysqladmin -u root password 'new-password'
/opt/mysql/mysql/bin/mysqladmin -u root -h sol10-sparc-d.mysql.com password 'new-password'

Alternatively you can run:
/opt/mysql/mysql/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

Please report any problems with the ./bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com

Installation of <mysql> was successful.

======================================================================