[MacPorts] #43088: mysql5 @5.1.72 uses /tmp for socket
#43088: mysql5 @5.1.72 uses /tmp for socket --------------------------+-------------------------------- Reporter: ctreleaven@… | Owner: macports-tickets@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.2.1 Keywords: | Port: mysql5 --------------------------+-------------------------------- Hi guys: I wanted to add a local mysql5-server but could not make a connection to it. What I've found is that it is ignoring the configure directive ('--with-unix-socket-path=/opt/local/var/run/mysql5/mysqld.sock ') and looking for the socket in tmp: {{{ CT-MBP11:~ craigtreleaven$ mysql5 --help |grep ^socket socket /tmp/mysql.sock }}} I've rebuilt msyql5 (twice) with no change. I'll attach the debug build output from the most recent attempt. Is it possibly a permissions issue? I've had mysql5 installed on this machine since @5.1.61_0 although it has always been used to access a remote server. Permissions on /opt/local/var/run/mysql5 are 0755. It was only a few days ago that I installed mysql5-server and experienced this issue. -- Ticket URL: <https://trac.macports.org/ticket/43088> MacPorts <http://www.macports.org/> Ports system for OS X
#43088: mysql5 @5.1.72 uses /tmp for socket ---------------------------+-------------------------------- Reporter: ctreleaven@… | Owner: macports-tickets@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.2.1 Resolution: | Keywords: Port: mysql5 | ---------------------------+-------------------------------- Comment (by ryandesign@…): The mysql5 port has been deprecated for years. Please use a modern mysql port (mysql51, mysql55, mysql56, mariadb or percona) and let us know if the problem persists there. -- Ticket URL: <https://trac.macports.org/ticket/43088#comment:1> MacPorts <http://www.macports.org/> Ports system for OS X
#43088: mysql5 @5.1.72 uses /tmp for socket ---------------------------+-------------------------------- Reporter: ctreleaven@… | Owner: macports-tickets@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.2.1 Resolution: | Keywords: Port: mysql5 | ---------------------------+-------------------------------- Comment (by ctreleaven@…): I understand and when the next major version of mythtv is released, I'll revise the port to use a modern version. BTW, I replaced my 'database server' machine a couple of months ago and did a fresh install of all the software. It doesn't exhibit this problem: {{{ MediumMini:~ mytthtv$ port installed mysql5 The following ports are currently installed: mysql5 @5.1.72_0 (active) MediumMini:~ mytthtv$ mysql5 --help |grep ^socket socket (No default value) }}} Any suggestions on how to get the older machine to behave like the new one? ;) Perhaps mysql5 should be modified so that port info highlights that it is to be phased out? -- Ticket URL: <https://trac.macports.org/ticket/43088#comment:2> MacPorts <http://www.macports.org/> Ports system for OS X
#43088: mysql5 @5.1.72 uses /tmp for socket ---------------------------+-------------------------------- Reporter: ctreleaven@… | Owner: macports-tickets@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.2.1 Resolution: | Keywords: Port: mysql5 | ---------------------------+-------------------------------- Comment (by ctreleaven@…): pixilla's comment in email sparked me to look for other my.cnf files. There was an old config file in /private/etc/my.cnf. It is dated in 2010, before I started to use MacPorts. In fact, before I bought this machine. Migration Assistant must have copied it over from my former Mac. After deleting this file, mysql5 is behaving as expected. Sorry for the noise; please close the ticket. Thanks! -- Ticket URL: <https://trac.macports.org/ticket/43088#comment:3> MacPorts <http://www.macports.org/> Ports system for OS X
#43088: mysql5 @5.1.72 uses /tmp for socket ---------------------------+-------------------------------- Reporter: ctreleaven@… | Owner: macports-tickets@… Type: defect | Status: closed Priority: Normal | Milestone: Component: ports | Version: 2.2.1 Resolution: invalid | Keywords: Port: mysql5 | ---------------------------+-------------------------------- Changes (by ryandesign@…): * status: new => closed * resolution: => invalid Comment: Ok, great! -- Ticket URL: <https://trac.macports.org/ticket/43088#comment:4> MacPorts <http://www.macports.org/> Ports system for OS X
participants (1)
-
MacPorts