[MacPorts] #20949: mysql_update5 expects 'mysql' instead of 'mysql5'
#20949: mysql_update5 expects 'mysql' instead of 'mysql5' ----------------------------------+----------------------------------------- Reporter: ora.et.labora@… | Owner: macports-tickets@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 1.8.0 Keywords: | Port: mysql5 @5.0.85 ----------------------------------+----------------------------------------- $ mysql_upgrade5 Looking for 'mysql' as: mysql FATAL ERROR: Can't execute 'mysql' -- Ticket URL: <http://trac.macports.org/ticket/20949> MacPorts <http://www.macports.org/> Ports system for Mac OS
#20949: mysql_update5 expects 'mysql' instead of 'mysql5' ----------------------------------+----------------------------------------- Reporter: ora.et.labora@… | Owner: ryandesign@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 1.8.0 Keywords: | Port: mysql5 ----------------------------------+----------------------------------------- Changes (by snc@…): * owner: macports-tickets@… => ryandesign@… * port: mysql5 @5.0.85 => mysql5 Old description:
$ mysql_upgrade5 Looking for 'mysql' as: mysql FATAL ERROR: Can't execute 'mysql'
New description: {{{ $ mysql_upgrade5 Looking for 'mysql' as: mysql FATAL ERROR: Can't execute 'mysql' }}} -- -- Ticket URL: <http://trac.macports.org/ticket/20949#comment:1> MacPorts <http://www.macports.org/> Ports system for Mac OS
#20949: mysql5: mysql_upgrade5 expects 'mysql' instead of 'mysql5' ----------------------------------+----------------------------------------- Reporter: ora.et.labora@… | Owner: ryandesign@… Type: defect | Status: assigned Priority: Normal | Milestone: Component: ports | Version: 1.8.0 Keywords: | Port: mysql5 ----------------------------------+----------------------------------------- Changes (by ryandesign@…): * status: new => assigned Comment: Confirmed in mysql5 @5.1.41_0. Need to check if mysql5-devel @5.4.x is also affected. -- Ticket URL: <http://trac.macports.org/ticket/20949#comment:3> MacPorts <http://www.macports.org/> Ports system for Mac OS
#20949: mysql5: mysql_upgrade5 expects 'mysql' instead of 'mysql5' ----------------------------------+----------------------------------------- Reporter: ora.et.labora@… | Owner: ryandesign@… Type: defect | Status: assigned Priority: Normal | Milestone: Component: ports | Version: 1.8.0 Keywords: | Port: mysql5 ----------------------------------+----------------------------------------- Comment(by ryandesign@…): A workaround for now is to call the script by its full canonical name: {{{ /opt/local/lib/mysql5/bin/mysql_upgrade }}} -- Ticket URL: <http://trac.macports.org/ticket/20949#comment:4> MacPorts <http://www.macports.org/> Ports system for Mac OS
#20949: mysql5: mysql_upgrade5 expects 'mysql' instead of 'mysql5' ----------------------------------+----------------------------------------- Reporter: ora.et.labora@… | Owner: ryandesign@… Type: defect | Status: assigned Priority: Normal | Milestone: Component: ports | Version: 1.8.0 Keywords: | Port: mysql5 ----------------------------------+----------------------------------------- Comment(by dweber@…): How about symlinks? {{{ for f in /opt/local/bin/mysql*; do symlink=$(echo $f | sed s/5$//); echo "ln -s $symlink $f"; done }}} Gives: {{{ ln -s /opt/local/bin/mysql /opt/local/bin/mysql5 ln -s /opt/local/bin/mysql_client_test /opt/local/bin/mysql_client_test5 ln -s /opt/local/bin/mysql_client_test_embedded /opt/local/bin/mysql_client_test_embedded5 ln -s /opt/local/bin/mysql_config /opt/local/bin/mysql_config5 ln -s /opt/local/bin/mysql_convert_table_format /opt/local/bin/mysql_convert_table_format5 ln -s /opt/local/bin/mysql_find_rows /opt/local/bin/mysql_find_rows5 ln -s /opt/local/bin/mysql_fix_extensions /opt/local/bin/mysql_fix_extensions5 ln -s /opt/local/bin/mysql_fix_privilege_tables /opt/local/bin/mysql_fix_privilege_tables5 ln -s /opt/local/bin/mysql_install_db /opt/local/bin/mysql_install_db5 ln -s /opt/local/bin/mysql_secure_installation /opt/local/bin/mysql_secure_installation5 ln -s /opt/local/bin/mysql_setpermission /opt/local/bin/mysql_setpermission5 ln -s /opt/local/bin/mysql_tzinfo_to_sql /opt/local/bin/mysql_tzinfo_to_sql5 ln -s /opt/local/bin/mysql_upgrade /opt/local/bin/mysql_upgrade5 ln -s /opt/local/bin/mysql_waitpid /opt/local/bin/mysql_waitpid5 ln -s /opt/local/bin/mysql_zap /opt/local/bin/mysql_zap5 ln -s /opt/local/bin/mysqlaccess /opt/local/bin/mysqlaccess5 ln -s /opt/local/bin/mysqladmin /opt/local/bin/mysqladmin5 ln -s /opt/local/bin/mysqlbinlog /opt/local/bin/mysqlbinlog5 ln -s /opt/local/bin/mysqlbug /opt/local/bin/mysqlbug5 ln -s /opt/local/bin/mysqlcheck /opt/local/bin/mysqlcheck5 ln -s /opt/local/bin/mysqld_multi /opt/local/bin/mysqld_multi5 ln -s /opt/local/bin/mysqld_safe /opt/local/bin/mysqld_safe5 ln -s /opt/local/bin/mysqldump /opt/local/bin/mysqldump5 ln -s /opt/local/bin/mysqldumpslow /opt/local/bin/mysqldumpslow5 ln -s /opt/local/bin/mysqlhotcopy /opt/local/bin/mysqlhotcopy5 ln -s /opt/local/bin/mysqlimport /opt/local/bin/mysqlimport5 ln -s /opt/local/bin/mysqlshow /opt/local/bin/mysqlshow5 ln -s /opt/local/bin/mysqlslap /opt/local/bin/mysqlslap5 ln -s /opt/local/bin/mysqltest /opt/local/bin/mysqltest5 ln -s /opt/local/bin/mysqltest_embedded /opt/local/bin/mysqltest_embedded5 }}} Maybe only for a stable version of mysql? -- Ticket URL: <http://trac.macports.org/ticket/20949#comment:5> MacPorts <http://www.macports.org/> Ports system for Mac OS
#20949: mysql5: mysql_upgrade5 expects 'mysql' instead of 'mysql5' ----------------------------------+----------------------------------------- Reporter: ora.et.labora@… | Owner: ryandesign@… Type: defect | Status: assigned Priority: Normal | Milestone: Component: ports | Version: 1.8.0 Keywords: | Port: mysql5 ----------------------------------+----------------------------------------- Comment(by ryandesign@…): No, we don't want symlinks in /opt/local/bin without the major version number; if we wanted the files in there without the major version number we'd just remove all the munging we do in the port to add the major version number in the first place. Presumably we want the major version number appended so that we can install multiple versions of MySQL simultaneously. Installing mysql4 and mysql5 is no longer very interesting since MySQL 4 is so old now, but installing MySQL 5.0, 5.1 and 5.5 simultaneously is interesting and has already been requested a couple times. The mysql5 port should be renamed mysql51, a new mysql50 port should be created, the mysql5-devel port should be renamed mysql55, and they should all not conflict with one another and should install files with the appropriate suffixes. See #4115 and #22251. For this ticket, we want a solution that allows running mysql_upgrade5 to work. -- Ticket URL: <http://trac.macports.org/ticket/20949#comment:6> MacPorts <http://www.macports.org/> Ports system for Mac OS
#20949: mysql5: mysql_upgrade5 expects 'mysql' instead of 'mysql5' ----------------------------------+----------------------------------------- Reporter: ora.et.labora@… | Owner: ryandesign@… Type: defect | Status: assigned Priority: Normal | Milestone: Component: ports | Version: 1.8.0 Keywords: | Port: mysql5 ----------------------------------+----------------------------------------- Comment(by d@…): The problem with a lack of things like "mysql_config" is that other utilities and build scripts that depend on there being a central mysql installation, often fail. There should definitely be a way to set ONE mysql installation as the default, just like you can select a default python version. If there already is such a thing, I have not found it, and for this I apologize. Even if the macports scripts all work, other installations often fail and cause serious pains. The only solution I've found is to put /opt/local/lib/mysql5/bin into the $PATH, which is not a solution IMHO. -- Ticket URL: <https://trac.macports.org/ticket/20949#comment:9> MacPorts <http://www.macports.org/> Ports system for Mac OS
#20949: mysql5: mysql_upgrade5 expects 'mysql' instead of 'mysql5' ----------------------------------+----------------------------------------- Reporter: ora.et.labora@… | Owner: ryandesign@… Type: defect | Status: assigned Priority: Normal | Milestone: Component: ports | Version: 1.8.0 Keywords: | Port: mysql5 ----------------------------------+----------------------------------------- Comment(by ryandesign@…): Replying to [comment:9 d@…]:
There should definitely be a way to set ONE mysql installation as the default,
That's requested in #29907. -- Ticket URL: <https://trac.macports.org/ticket/20949#comment:11> MacPorts <http://www.macports.org/> Ports system for Mac OS
#20949: mysql5: mysql_upgrade5 expects 'mysql' instead of 'mysql5' ----------------------------------+----------------------------------------- Reporter: ora.et.labora@… | Owner: ryandesign@… Type: defect | Status: assigned Priority: Normal | Milestone: Component: ports | Version: 1.8.0 Keywords: | Port: mysql5 ----------------------------------+----------------------------------------- Comment(by ryandesign@…): Has duplicate #29991. -- Ticket URL: <https://trac.macports.org/ticket/20949#comment:12> MacPorts <http://www.macports.org/> Ports system for Mac OS
#20949: mysql5: mysql_upgrade5 expects 'mysql' instead of 'mysql5' ------------------------------+-------------------------- Reporter: ora.et.labora@… | Owner: ryandesign@… Type: defect | Status: assigned Priority: Normal | Milestone: Component: ports | Version: 1.8.0 Resolution: | Keywords: Port: mysql5 | ------------------------------+-------------------------- Comment (by egall@…): Replying to [comment:12 ryandesign@…]:
Has duplicate #29991.
And now also #40606 with mysql56. -- Ticket URL: <https://trac.macports.org/ticket/20949#comment:13> MacPorts <http://www.macports.org/> Ports system for OS X
participants (1)
-
MacPorts