Opened 7 years ago

Closed 7 years ago

Last modified 6 years ago

#56254 closed update (duplicate)

mysql56: update to 5.6.39

Reported by: josephsacco Owned by:
Priority: Normal Milestone:
Component: ports Version:
Keywords: haspatch Cc: ryandesign (Ryan Carsten Schmidt), pixilla (Bradley Giesbrecht)
Port: mysql56

Description

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

Attachments (2)

Portfile.diff (1.1 KB) - added by josephsacco 7 years ago.
Portfile diff
patch_client_authentication.cc.diff (553 bytes) - added by josephsacco 7 years ago.
mysql-common/client_authentication.cc diff

Download all attachments as: .zip

Change History (6)

Changed 7 years ago by josephsacco

Attachment: Portfile.diff added

Portfile diff

Changed 7 years ago by josephsacco

mysql-common/client_authentication.cc diff

comment:1 Changed 7 years ago by ryandesign (Ryan Carsten Schmidt)

Keywords: haspatch added
Resolution: duplicate
Status: newclosed
Summary: mysql: update to 5.6.39mysql56: update to 5.6.39

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

Duplicate of #55488.

comment:2 Changed 7 years ago by 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

comment:3 Changed 7 years ago by 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.

comment:4 Changed 6 years ago by chrstphrchvz (Christopher Chavez)

In a79f6dc9ad0dee9fc35a55c3347e462db06e9c02/macports-ports (master):

mysql56: update to 5.6.44

Closes: #55488

Add patch for client_authentication.cc
See: #56254

Note: See TracTickets for help on using tickets.