Bug #20078 MySQL-bench-5.0.21 RPMs contain strange dependencies
Submitted: 25 May 2006 21:29 Modified: 26 Jun 2006 13:56
Reporter: Valeriy Kravchuk Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Packaging Severity:S3 (Non-critical)
Version:5.0.21 OS:Linux (Linux FC4, RHEL4, SuSE 9.3)
Assigned to: Kent Boortz CPU Architecture:Any

[25 May 2006 21:29] Valeriy Kravchuk
Description:
RPM packages for MySQL-bench-5.0.21 (MySQL-Test-5.0.21-1, in case of RHEL4) depends on several *.pl files that usually are located in mysql-test/lib subdirectory (in MySQL test suite), but not included in any other RPM MySQL usually provides. As a result, these RPMs are useless.

How to repeat:
suse:/tmp # rpm -i MySQL-server-5.0.21-0.glibc23.i386.rpm
warning: MySQL-server-5.0.21-0.glibc23.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h suse password 'new-password'
See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

Please report any problems with the /usr/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
doneting MySQL
suse:/tmp # rpm -q -l MySQL-server-5.0.21 | grep mtr_cases.pl
suse:/tmp # rpm -i MySQL-Max-5.0.21-0.glibc23.i386.rpm
warning: MySQL-Max-5.0.21-0.glibc23.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Restarting mysqld.
suse:/tmp # rpm -q -l MySQL-Max-5.0.21-0.glibc23.i386.rpm | grep mtr_cases.pl
suse:/tmp # rpm -i MySQL-client-5.0.21-0.glibc23.i386.rpm
warning: MySQL-client-5.0.21-0.glibc23.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
suse:/tmp # rpm -q -l MySQL-client-5.0.21-0.glibc23.i386.rpm | grep mtr_cases.pl
suse:/tmp # rpm -i MySQL-devel-5.0.21-0.glibc23.i386.rpm
warning: MySQL-devel-5.0.21-0.glibc23.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
suse:/tmp # rpm -q -l MySQL-devel-5.0.21-0.glibc23.i386.rpm | grep mtr_cases.pl
suse:/tmp # rpm -i MySQL-bench-5.0.21-0.glibc23.i386.rpm
warning: MySQL-bench-5.0.21-0.glibc23.i386.rpm: V3 DSA signature: NOKEY, key ID
5072e1f5
error: Failed dependencies:
        perl(lib::mtr_cases.pl) is needed by MySQL-bench-5.0.21-0.glibc23
        perl(lib::mtr_diff.pl) is needed by MySQL-bench-5.0.21-0.glibc23
        perl(lib::mtr_gcov.pl) is needed by MySQL-bench-5.0.21-0.glibc23
        perl(lib::mtr_gprof.pl) is needed by MySQL-bench-5.0.21-0.glibc23
        perl(lib::mtr_io.pl) is needed by MySQL-bench-5.0.21-0.glibc23
        perl(lib::mtr_match.pl) is needed by MySQL-bench-5.0.21-0.glibc23
        perl(lib::mtr_misc.pl) is needed by MySQL-bench-5.0.21-0.glibc23
        perl(lib::mtr_process.pl) is needed by MySQL-bench-5.0.21-0.glibc23
        perl(lib::mtr_report.pl) is needed by MySQL-bench-5.0.21-0.glibc23
        perl(lib::mtr_stress.pl) is needed by MySQL-bench-5.0.21-0.glibc23
        perl(lib::mtr_timer.pl) is needed by MySQL-bench-5.0.21-0.glibc23

Suggested fix:
Include complete test suite in RPM binaries.
[13 Jun 2006 2:37] Rizwan Kassim
Exact same problem verified.
[16 Jun 2006 6:33] Lenz Grimmer
This is just another variation of what has been reported in BUG#13634 - we should try to disable the Perl module dependency checking altogether. The other bug report has a few pointers on how to do that.
[22 Jun 2006 22:37] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/8109
[23 Jun 2006 19:39] Kent Boortz
The correction for the dependency problem in
the "bench" and "test" RPM packages will be
in 4.1.21, 5.0.23 and 5.1.12.
[26 Jun 2006 13:56] Jon Stephens
Documented bugfix in 4.1.21/5.0.23/5.1.12 changelogs. Closed.