mysql56: update to 5.6.39

[josephsacco]

I have managed to get mysql-5.6.9 to build and run on an old G4 PowerMac using macports-gcc-7 and the openssl variant. The build required patching:

• Portfile
• mysql-common/client_authentication.cc

Diffs are attached to this ticket.

Why build the openssl variant?

Without it, the PHP and Python connectors to do work. The mySQL Password() function produces a hash that does not match what is produced by the PHP and Python connectors.

-Joseph

[josephsacco]

Portfile diff

[josephsacco]

mysql-common/client_authentication.cc diff

[ryandesign (Ryan Carsten Schmidt)]

What problem did you encounter with parallel building? (You disabled it in your Portfile.diff.)

Duplicate of #55488.

[josephsacco]

Parallel Build
I shut off the parallel build to eliminate a possible source of error when building on an old G4-based machine.

Using openssl
Unlike, mysql-5.6.x, the default build of mysql-5.5.53 which uses the yaSSL library included with the mysql source, produces a PASSWORD() function that generates the correct hashes. I have not had the opportunity to explore why the default build of mysql-5.6.x fails to generate the correct hashes. I do know that the mySQL PASSWORD('password-string') function is equivalent to SHA1(UNHEX(SHA1('password-string'))).

-Joseph

[kencu (Ken)]

BTW, git built on PPC Tiger also generates incorrect hashes unless you build it with gcc6 or gcc7. The similarity is interesting, and makes me wonder if there's a connection here.

[chrstphrchvz (Christopher Chavez)]

In a79f6dc9ad0dee9fc35a55c3347e462db06e9c02/macports-ports (master):

mysql56: update to 5.6.44

Closes: #55488

Add patch for client_authentication.cc
See: #56254