Errors building mysql55-client

Thu Jun 27 09:21:30 UTC 2013

On Thu, 27 Jun 2013 07:55-0000, C. L. Martinez wrote:

> Hi all,
> 
>  There is an error when poudriere tries to build mysql55-client:
> 
> ===>  License GPLv2 accepted by the user
> ===> Fetching all distfiles required by mysql-client-5.5.32 for building
> => SHA256 Checksum mismatch for mysql-5.5.32.tar.gz.
> ===>  Refetch for 1 more times files: mysql-5.5.32.tar.gz
> ===>  License GPLv2 accepted by the user
> => mysql-5.5.32.tar.gz doesn't seem to exist in /distfiles/.
> => Attempting to fetch
> ftp://ftp.fi.muni.cz/pub/mysql/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz
> fetch: ftp://ftp.fi.muni.cz/pub/mysql/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz:
> Unknown FTP error
> => Attempting to fetch
> http://mysql.mirrors.cybercity.dk/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz
> fetch: http://mysql.mirrors.cybercity.dk/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz:
> No route to host
> => Attempting to fetch
> ftp://ftp.fh-wolfenbuettel.de/pub/database/mysql/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz
> fetch: ftp://ftp.fh-wolfenbuettel.de/pub/database/mysql/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz:
> Unknown FTP error
> => Attempting to fetch
> ftp://ftp.gwdg.de/pub/misc/mysql/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz
> fetch: mysql-5.5.32.tar.gz: local file (24625029 bytes) is longer than
> remote file (24589274 bytes)
> => Attempting to fetch
> http://netmirror.org/mirror/mysql.com/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz
> fetch: http://netmirror.org/mirror/mysql.com/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz:
> Operation timed out
> => Attempting to fetch
> ftp://netmirror.org/mysql.com/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz
> fetch: ftp://netmirror.org/mysql.com/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz:
> Protocol error
> => Attempting to fetch
> http://mirrors.ntua.gr/MySQL/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz
> fetch: http://mirrors.ntua.gr/MySQL/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz:
> Requested Range Not Satisfiable
> => Attempting to fetch
> ftp://ftp.ntua.gr/pub/databases/mysql/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz
> fetch: mysql-5.5.32.tar.gz: local file (24625029 bytes) is longer than
> remote file (24589274 bytes)
> => Attempting to fetch
> http://mysql.sote.hu/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz
> fetch: http://mysql.sote.hu/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz:
> No address record
> => Attempting to fetch
> ftp://ftp.rhnet.is/pub/mysql/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz
> fetch: ftp://ftp.rhnet.is/pub/mysql/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz:
> File unavailable (e.g., file not found, no access)
> => Attempting to fetch
> ftp://mirror.widexs.nl/pub/mysql/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz
> fetch: ftp://mirror.widexs.nl/pub/mysql/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz:
> File unavailable (e.g., file not found, no access)
> => Attempting to fetch
> ftp://mirror.switch.ch/mirror/mysql/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz
> fetch: mysql-5.5.32.tar.gz: local file (24625029 bytes) is longer than
> remote file (24589274 bytes)
> => Attempting to fetch
> http://mysql.dp.ua/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz
> fetch: http://mysql.dp.ua/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz: No
> address record
> => Attempting to fetch
> http://mysql.mirrored.ca/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz
> fetch: http://mysql.mirrored.ca/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz:
> size mismatch: expected 24589274, actual 51
> => Attempting to fetch
> ftp://mirror.services.wisc.edu/mirrors/mysql/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz
> fetch: ftp://mirror.services.wisc.edu/mirrors/mysql/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz:
> No address record
> => Attempting to fetch
> http://mysql.mirrors.pair.com/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz
> fetch: http://mysql.mirrors.pair.com/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz:
> Requested Range Not Satisfiable
> => Attempting to fetch
> ftp://ftp.linorg.usp.br/mysql/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz
> fetch: ftp://ftp.linorg.usp.br/mysql/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz:
> No address record
> => Attempting to fetch
> ftp://ftp.cbn.net.id/mirror/mysql/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz
> fetch: ftp://ftp.cbn.net.id/mirror/mysql/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz:
> File unavailable (e.g., file not found, no access)
> => Attempting to fetch
> ftp://ftp.easynet.be/mysql/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz
> fetch: ftp://ftp.easynet.be/mysql/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz:
> Unknown FTP error
> => Attempting to fetch
> http://download.softagency.net/MySQL/Downloads/MySQL-5.5/mysql-5.5.32.tar.gz
> fetch: mysql-5.5.32.tar.gz: local file (24625029 bytes) is longer than
> remote file (24589274 bytes)
> => Attempting to fetch
> ftp://ftp.FreeBSD.org/pub/FreeBSD/ports/distfiles/mysql-5.5.32.tar.gz
> fetch: ftp://ftp.FreeBSD.org/pub/FreeBSD/ports/distfiles/mysql-5.5.32.tar.gz:
> size mismatch: expected 24589274, actual 24625029
> => Couldn't fetch it - please try to retrieve this
> => port manually into /distfiles/ and try again.
> *** Error code 1
> 
> Stop in /usr/ports/databases/mysql55-client.
> *** Error code 1
> 
> Stop in /usr/ports/databases/mysql55-client.
> ===>  Cleaning for mysql-client-5.5.32
> 
> Any idea why??

Either the file named distinfo is messed up, or the maintainer has 
access to a different file than the rest of us. Maybe you should wait 
until the MySQL mirrors catches up.

Here's contents of /usr/ports/databases/mysql55-server/distinfo on one 
of my systems as of r321850:

root at enterprise:~>cat /usr/ports/databases/mysql55-server/distinfo
SHA256 (mysql-5.5.32.tar.gz) = babb19a1e58f6b285ff75e876f550a798d37fb72b5a548ffb411e8a4a51f6890
SIZE (mysql-5.5.32.tar.gz) = 24589274

Here's info on the file itself:

root at enterprise:~>stat -x /usr/ports/distfiles/mysql-5.5.32.tar.gz
  File: "/usr/ports/distfiles/mysql-5.5.32.tar.gz"
  Size: 24625029     FileType: Regular File
  Mode: (0644/-rw-r--r--)         Uid: (    0/    root)  Gid: (    0/   
wheel)
Device: 129,129302626   Inode: 4958    Links: 1
Access: Thu Jun 27 11:03:49 2013
Modify: Fri May 17 07:44:35 2013
Change: Fri Jun 14 09:20:22 2013

root at enterprise:~>sha256 /usr/ports/distfiles/mysql-5.5.32.tar.gz
SHA256 (/usr/ports/distfiles/mysql-5.5.32.tar.gz) = 20930c3d934937f3863073af0a54cb014a4c6469e5460a81e2ff75062755377e

Neither the file's length nor its SHA256 hash matches what's stored in 
the distinfo file.

If you accept the risks, you could perform some surgery on the 
/usr/ports/databases/mysql55-server/distinfo file, changing its 
contents to:

SHA256 (mysql-5.5.32.tar.gz) = 20930c3d934937f3863073af0a54cb014a4c6469e5460a81e2ff75062755377e
SIZE (mysql-5.5.32.tar.gz) = 24625029

You should probably generate/verify these values yourself.

I updated both mysql55-server and mysql55-client on June 14th, 2013.

root at enterprise:~>mysql --version
mysql  Ver 14.14 Distrib 5.5.32, for FreeBSD9.1 (amd64) using  5.2

-- 
+-------------------------------+------------------------------------+
| Vennlig hilsen,               | Best regards,                      |
| Trond Endrestøl,              | Trond Endrestøl,                   |
| IT-ansvarlig,                 | System administrator,              |
| Fagskolen Innlandet,          | Gjøvik Technical College, Norway,  |
| tlf. mob.   952 62 567,       | Cellular...: +47 952 62 567,       |
| sentralbord 61 14 54 00.      | Switchboard: +47 61 14 54 00.      |
+-------------------------------+------------------------------------+