#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)
Change History (6)
Changed 7 years ago by josephsacco
Attachment: | Portfile.diff added |
---|
Changed 7 years ago by josephsacco
Attachment: | patch_client_authentication.cc.diff added |
---|
mysql-common/client_authentication.cc diff
comment:1 Changed 7 years ago by ryandesign (Ryan Carsten Schmidt)
Keywords: | haspatch added |
---|---|
Resolution: | → duplicate |
Status: | new → closed |
Summary: | mysql: update to 5.6.39 → mysql56: 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.
Portfile diff