Re: MySQL 4.0.x and RH 9

[James Olin Oden <joden malachi lee k12 nc us>]

On Sat, 30 Aug 2003, Andre Costa wrote:

> Hi all,
> 
> please excuse if you receive a duplicate for this: I sent another msg
> about this yesterday, and since it didn't appear so far, I am sending
> another one.
> 
> I am trying to build MySQL 4.0.14 on my RH9 box using official SRPM from
> MySQL.org, and I am going through some weird problem.
> 
> First: I had to replace
> 
> %install -n mysql-%{mysql_version}
> 
> by
> 
> %install
> 
> on the spec file (will report this to mysql.org). Second, all RPMs build
> fine (aside from a couple of "installed but unpackaged" complaints):
> 
> [...]
> Checking for unpackaged file(s): /usr/lib/rpm/check-files /var/tmp/rpm/MySQL-4.0.14-build
> warning: Installed (but unpackaged) file(s) found:
>    /shared-libs.tar
>    /usr/bin/mysql_fix_extensions
>    /usr/bin/mysql_install
>    /usr/bin/mysql_tableinfo
>    /usr/bin/mysqldumpslow
>    /usr/share/man/man1/mysql_fix_privilege_tables.1.gz
> Wrote: /home/costa/redhat/SRPMS/MySQL-4.0.14-0.src.rpm
> Wrote: /home/costa/redhat/RPMS/athlon/MySQL-server-4.0.14-0.athlon.rpm
> Wrote: /home/costa/redhat/RPMS/athlon/MySQL-client-4.0.14-0.athlon.rpm
> Wrote: /home/costa/redhat/RPMS/athlon/MySQL-bench-4.0.14-0.athlon.rpm
> Wrote: /home/costa/redhat/RPMS/athlon/MySQL-devel-4.0.14-0.athlon.rpm
> Wrote: /home/costa/redhat/RPMS/athlon/MySQL-shared-4.0.14-0.athlon.rpm
> Wrote: /home/costa/redhat/RPMS/athlon/MySQL-Max-4.0.14-0.athlon.rpm
> Wrote: /home/costa/redhat/RPMS/athlon/MySQL-embedded-4.0.14-0.athlon.rpm
> 
> The probl is that MySQL-client lists "perl(the)" as one of its requirements:
> 
> rpm -qpR /home/costa/redhat/RPMS/athlon/MySQL-client-4.0.14-0.athlon.rpm
> /bin/sh  
> /usr/bin/perl  
> perl(CGI)  
> perl(Exporter)  
> perl(Fcntl)  
> perl(Getopt::Long)  
> perl(IPC::Open3)  
> perl(POSIX)  
> perl(Sys::Hostname)  
> perl(the)  
> rpmlib(CompressedFileNames) <= 3.0.4-1
> rpmlib(PayloadFilesHavePrefix) <= 4.0-1
> 
> As a result, I just can't install the RPM:
>
RPM is running a script that scans perl scripts and libraries for "use"
and "require" lines.  You need to go through MySQL's sources and see if 
there are anyone ones that call for the (the) perl module (which I have
never heard of by the way, and it seems like a false positive).  If it is
a false positive, then you can do something silly in their spec file like:

	Provides perl(the)

And the problem goes away; If its not a false positive and the thing is 
really using or requiring something called "the", then you'll need to go
to cpan and download the module.  You can use cpanflute2 to build an rpm
from this module (if it exists).

Cheers...james