mysql55 fails checksum

[theboergers@…]

The ports tree has been updated. To upgrade your installed ports, you should run
  port upgrade outdated
--->  Computing dependencies for mysql55
--->  Verifying checksum(s) for mysql55
Error: Checksum (rmd160) mismatch for mysql-5.5.23.tar.gz
Error: Checksum (sha256) mismatch for mysql-5.5.23.tar.gz
Error: Target org.macports.checksum returned: Unable to verify file checksums
Log for mysql55 is at: /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mysql55/mysql55/main.log
Error: Unable to upgrade port: 1

[skymoo (Adam Mercer)]

Have you followed the steps in the FAQ?

[pixilla (Bradley Giesbrecht)]

The checksums appear to be correct on my system.

$ port distfiles mysql55
--->  Distfiles for mysql55
[mysql-5.5.23.tar.gz] /opt/local/var/macports/distfiles/mysql55/mysql-5.5.23.tar.gz
 rmd160: 1c5b086be0b8f5e1f3128c160e1e4814f68dac95
 sha256: 20a6303e281ac7875997c6c5e34b1129a02d1fb3f886b8ccb2c7b958cd67746a
...

Can you clean the distfiles and try again. If it fails post your log.

$ sudo port -v extract mysql55
$ open $(dirname $(port logfile mysql55))

[theboergers@…]

Attempting to clean the port

[~] : portup
--->  Updating MacPorts base sources using rsync
MacPorts base version 2.0.4 installed,
MacPorts base version 2.0.4 downloaded.
--->  Updating the ports tree
--->  MacPorts base is already the latest version

The ports tree has been updated. To upgrade your installed ports, you should run
  port upgrade outdated
--->  Computing dependencies for mysql55
--->  Fetching archive for mysql55
--->  Attempting to fetch mysql55-5.5.23_0.darwin_11.x86_64.tbz2 from http://packages.macports.org/mysql55
--->  Fetching mysql55
--->  Attempting to fetch mysql-5.5.23.tar.gz from http://mysql.mirrors.pair.com/Downloads/MySQL-5.5/
--->  Verifying checksum(s) for mysql55
Error: Checksum (rmd160) mismatch for mysql-5.5.23.tar.gz
Error: Checksum (sha256) mismatch for mysql-5.5.23.tar.gz
Error: Target org.macports.checksum returned: Unable to verify file checksums
Log for mysql55 is at: /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mysql55/mysql55/main.log
Error: Unable to upgrade port: 1
To report a bug, see <http://guide.macports.org/#project.tickets>
[~] : sudo port -v extract mysql55
Password:
--->  Verifying checksum(s) for mysql55
--->  Checksumming mysql-5.5.23.tar.gz
Error: Checksum (rmd160) mismatch for mysql-5.5.23.tar.gz
Portfile checksum: mysql-5.5.23.tar.gz rmd160 1c5b086be0b8f5e1f3128c160e1e4814f68dac95
Distfile checksum: mysql-5.5.23.tar.gz rmd160 26e3e076fd90b506866ce9deec8f0060196d1049
Error: Checksum (sha256) mismatch for mysql-5.5.23.tar.gz
Portfile checksum: mysql-5.5.23.tar.gz sha256 20a6303e281ac7875997c6c5e34b1129a02d1fb3f886b8ccb2c7b958cd67746a
Distfile checksum: mysql-5.5.23.tar.gz sha256 edcd76710d7367300a551688003cfe3ed2fc0acb20a8c4c32b145ca4315ce9e5
The correct checksum line may be:
checksums           rmd160  26e3e076fd90b506866ce9deec8f0060196d1049 \
                    sha256  edcd76710d7367300a551688003cfe3ed2fc0acb20a8c4c32b145ca4315ce9e5
Error: Target org.macports.checksum returned: Unable to verify file checksums
Warning: the following items did not execute (for mysql55): org.macports.extract org.macports.checksum
Log for mysql55 is at: /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mysql55/mysql55/main.log
Error: Status 1 encountered during processing.
To report a bug, see <http://guide.macports.org/#project.tickets>

The logfile:

version:1
:debug:main Executing org.macports.main (mysql55)
:debug:main changing euid/egid - current euid: 0 - current egid: 0
:debug:main egid changed to: 501
:debug:main euid changed to: 503
:debug:main Skipping completed org.macports.fetch (mysql55)
:debug:main Privilege de-escalation not attempted as not running as root.
:debug:checksum checksum phase started at Tue May  1 09:00:54 EDT 2012
:notice:checksum --->  Verifying checksum(s) for mysql55
:debug:checksum Executing org.macports.checksum (mysql55)
:info:checksum --->  Checksumming mysql-5.5.23.tar.gz
:error:checksum Checksum (rmd160) mismatch for mysql-5.5.23.tar.gz
:info:checksum Portfile checksum: mysql-5.5.23.tar.gz rmd160 1c5b086be0b8f5e1f3128c160e1e4814f68dac95
:info:checksum Distfile checksum: mysql-5.5.23.tar.gz rmd160 26e3e076fd90b506866ce9deec8f0060196d1049
:error:checksum Checksum (sha256) mismatch for mysql-5.5.23.tar.gz
:info:checksum Portfile checksum: mysql-5.5.23.tar.gz sha256 20a6303e281ac7875997c6c5e34b1129a02d1fb3f886b8ccb2c7b958cd67746a
:info:checksum Distfile checksum: mysql-5.5.23.tar.gz sha256 edcd76710d7367300a551688003cfe3ed2fc0acb20a8c4c32b145ca4315ce9e5
:info:checksum The correct checksum line may be:
:info:checksum checksums           rmd160  26e3e076fd90b506866ce9deec8f0060196d1049 \
                    sha256  edcd76710d7367300a551688003cfe3ed2fc0acb20a8c4c32b145ca4315ce9e5
:error:checksum Target org.macports.checksum returned: Unable to verify file checksums
:debug:checksum Backtrace: Unable to verify file checksums
    while executing
"$procedure $targetname"
:info:checksum Warning: the following items did not execute (for mysql55): org.macports.extract org.macports.checksum
:notice:checksum Log for mysql55 is at: /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mysql55/mysql55/main.log

[theboergers@…]

Copy/Paste missed the part where I cleaned the port but I did perform the action

[~] : sudo port clean --dist mysql55
--->  Cleaning mysql55

[pixilla (Bradley Giesbrecht)]

I manually downloaded the source file from the same site in your fetch phase and my checksums match the Portfile. Try it yourself. You may have networking issues.

$ curl http://mysql.mirrors.pair.com/Downloads/MySQL-5.5/mysql-5.5.23.tar.gz -O
$ du -h mysql-5.5.23.tar.gz 
 23M	mysql-5.5.23.tar.gz
$ openssl rmd160 mysql-5.5.23.tar.gz 
RIPEMD160(mysql-5.5.23.tar.gz)= 26e3e076fd90b506866ce9deec8f0060196d1049
$ openssl sha256 mysql-5.5.23.tar.gz 
SHA256(mysql-5.5.23.tar.gz)= edcd76710d7367300a551688003cfe3ed2fc0acb20a8c4c32b145ca4315ce9e5

[chawco (Craig Hawco)]

Those are not the checksums currently in the Portfile:

​https://trac.macports.org/browser/trunk/dports/databases/mysql55/Portfile#L43

[pixilla (Bradley Giesbrecht)]

Bad distfile at mysql.mirrors.pair.com. See r92591

[pixilla (Bradley Giesbrecht)]

craig: after you "port sync" or "port selfupdate", clean the distfiles again and you should pull down a good file next upgrade/install.

[theboergers@…]

Cleaned the port then ran selfupdate at 7:00 a.m. EDT and still get a bad checksum.

version:1
:msg:main --->  Computing dependencies for mysql55:info:main .:debug:main Searching for dependency: cmake
:debug:main Found Dependency: receipt exists for cmake
:debug:main Searching for dependency: zlib
:debug:main Found Dependency: receipt exists for zlib
:debug:main Searching for dependency: readline
:debug:main Found Dependency: receipt exists for readline
:debug:main Searching for dependency: mysql_select
:debug:main Found Dependency: receipt exists for mysql_select
:msg:main 
:debug:main Executing org.macports.main (mysql55)
:debug:main changing euid/egid - current euid: 0 - current egid: 0
:debug:main egid changed to: 501
:debug:main euid changed to: 503
:debug:archivefetch archivefetch phase started at Wed May  2 06:58:19 EDT 2012
:msg:archivefetch --->  Fetching archive for mysql55
:debug:archivefetch Executing org.macports.archivefetch (mysql55)
:debug:archivefetch euid/egid changed to: 0/0
:debug:archivefetch chowned /opt/local/var/macports/software/mysql55 to macports
:debug:archivefetch euid/egid changed to: 503/501
:debug:archivefetch euid/egid changed to: 0/0
:debug:archivefetch chowned /opt/local/var/macports/incoming to macports
:debug:archivefetch euid/egid changed to: 503/501
:info:archivefetch --->  mysql55-5.5.23_0.darwin_11.x86_64.tbz2 doesn't seem to exist in /opt/local/var/macports/software/mysql55
:msg:archivefetch --->  Attempting to fetch mysql55-5.5.23_0.darwin_11.x86_64.tbz2 from http://packages.macports.org/mysql55
:debug:archivefetch Fetching archive failed:: The requested URL returned error: 404
:debug:archivefetch Privilege de-escalation not attempted as not running as root.
:debug:fetch fetch phase started at Wed May  2 06:58:19 EDT 2012
:notice:fetch --->  Fetching mysql55
:debug:fetch Can't run fetch on this port without elevated privileges. Escalating privileges back to root.
:debug:fetch euid changed to: 0. egid changed to: 0.
:debug:fetch changing euid/egid - current euid: 0 - current egid: 0
:debug:fetch egid changed to: 501
:debug:fetch euid changed to: 503
:debug:fetch Executing org.macports.fetch (mysql55)
:info:fetch --->  mysql-5.5.23.tar.gz doesn't seem to exist in /opt/local/var/macports/distfiles/mysql55
:debug:fetch Pinging mysql.mirrors.pair.com...
:debug:fetch Pinging mysql.he.net...
:debug:fetch Pinging mirrors.sunsite.dk...
:debug:fetch Pinging sunsite.informatik.rwth-aachen.de...
:debug:fetch Pinging mirror.facebook.net...
:debug:fetch Pinging ftp.plusline.de...
:debug:fetch Pinging distfiles.macports.org...
:debug:fetch Pinging aarnet.au.distfiles.macports.org...
:debug:fetch Pinging her.gr.distfiles.macports.org...
:debug:fetch Pinging jog.id.distfiles.macports.org...
:debug:fetch Pinging lil.fr.distfiles.macports.org...
:debug:fetch Pinging sea.us.distfiles.macports.org...
:debug:fetch Pinging ykf.ca.distfiles.macports.org...
:debug:fetch mysql.mirrors.pair.com ping time is 36.960
:debug:fetch mysql.he.net ping time is 81.617
:debug:fetch mirrors.sunsite.dk ping time is 139.337
:debug:fetch sunsite.informatik.rwth-aachen.de ping time is 129.545
:debug:fetch mirror.facebook.net ping time is 75.389
:debug:fetch ftp.plusline.de ping time is 120.009
:debug:fetch distfiles.macports.org ping time is 72.891
:debug:fetch aarnet.au.distfiles.macports.org ping time is 252.308
:debug:fetch her.gr.distfiles.macports.org ping time is 180.149
:debug:fetch jog.id.distfiles.macports.org ping time is 275.203
:debug:fetch lil.fr.distfiles.macports.org ping time is 119.228
:debug:fetch sea.us.distfiles.macports.org ping time is 10000
:debug:fetch ykf.ca.distfiles.macports.org ping time is 49.361
:notice:fetch --->  Attempting to fetch mysql-5.5.23.tar.gz from http://mysql.mirrors.pair.com/Downloads/MySQL-5.5/
:debug:fetch Privilege de-escalation not attempted as not running as root.
:debug:checksum checksum phase started at Wed May  2 06:58:37 EDT 2012
:notice:checksum --->  Verifying checksum(s) for mysql55
:debug:checksum Executing org.macports.checksum (mysql55)
:info:checksum --->  Checksumming mysql-5.5.23.tar.gz
:error:checksum Checksum (rmd160) mismatch for mysql-5.5.23.tar.gz
:info:checksum Portfile checksum: mysql-5.5.23.tar.gz rmd160 1c5b086be0b8f5e1f3128c160e1e4814f68dac95
:info:checksum Distfile checksum: mysql-5.5.23.tar.gz rmd160 26e3e076fd90b506866ce9deec8f0060196d1049
:error:checksum Checksum (sha256) mismatch for mysql-5.5.23.tar.gz
:info:checksum Portfile checksum: mysql-5.5.23.tar.gz sha256 20a6303e281ac7875997c6c5e34b1129a02d1fb3f886b8ccb2c7b958cd67746a
:info:checksum Distfile checksum: mysql-5.5.23.tar.gz sha256 edcd76710d7367300a551688003cfe3ed2fc0acb20a8c4c32b145ca4315ce9e5
:info:checksum The correct checksum line may be:
:info:checksum checksums           rmd160  26e3e076fd90b506866ce9deec8f0060196d1049 \
                    sha256  edcd76710d7367300a551688003cfe3ed2fc0acb20a8c4c32b145ca4315ce9e5
:error:checksum Target org.macports.checksum returned: Unable to verify file checksums
:debug:checksum Backtrace: Unable to verify file checksums
    while executing
"$procedure $targetname"
:info:checksum Warning: the following items did not execute (for mysql55): org.macports.install org.macports.checksum org.macports.extract org.macports.patch org.macports.configure org.macports.build org.macports.destroot
:notice:checksum Log for mysql55 is at: /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mysql55/mysql55/main.log

[pixilla (Bradley Giesbrecht)]

If you see mysql.mirrors.pair.com in the output of the following command then you do not have the most recent Portfile.

$ port distfiles mysql55

Chances are you use the MacPorts default rsync to sync your ports tree and you simply synced before svn had a chance to update the rsync tree. Please clean and repeat.

If you continue to have a sync issue please address this on the ​macports-users mailing list.