Misbehaving mysql57-server

[John Korchok]

With the addition of sudo, I get:

COMMAND PID USER    FD   TYPE DEVICE SIZE/OFF                  NODE       NAME
mysqld         79  _mysql 10u unix   0x40bdd8b3f53719a7        0t0            /opt/local/var/run/mysql56/mysqld.sock

but there is still no sock file at that location. As I mentioned earlier, the mysql-error log does show the creation of the sock file on the last line after restarting.

Is there a process that might destroy it after it's created?

John Korchok

-----Original Message-----
From: macports-users <macports-users-bounces at lists.macports.org> On Behalf Of Bill Cole
Sent: Sunday, March 29, 2020 5:52 PM
To: macports-users at lists.macports.org
Subject: Re: Misbehaving mysql57-server

NOTE: There's no need to mail me copies of replies that are also sent to the list. I am actually LESS likely to see messages sent to my list-specific addresses which do not arrive via their list.

On 29 Mar 2020, at 17:00, John Korchok wrote:

> Hi Bill,
>
> Thanks, but that command doesn't return any information.

I should have included 'sudo' before that command because you do need to run it as root. Like this:

	$ sudo lsof -U -a -p $( pgrep mysqld )
	Password:
	COMMAND   PID   USER   FD   TYPE             DEVICE SIZE/OFF NODE NAME
	mysqld  74438 _mysql   21u  unix 0x1a24756463c9ab69      0t0      
/opt/local/var/run/mysql57/mysqld.sock

> I haven't enabled networking. In the Activity Monitor, MySQL is 
> running.
>
> I tried installing mysql56, then switched to that version, but that 
> isn't creating a sock file either. In the mysql-error log, mySQL 
> thinks it's created the sock file (I saw nearly identical messages in
> 5.7 error log):
> Version: '5.6.45' socket:  '/opt/local/var/run/mysql56/mysqld.sock'  
> port: 0 Source distribution
>
> But that folder only contains the hidden file .turd_mysql56-server 
> (same thing in 5.7).

I am mystified. I installed mysql57 with MacPorts for the first time to look into this problem and didn't run into the missing socket problem nor did I get that hidden file:

	$ ls -la /opt/local/var/run/mysql57/
	total 8
	drwxr-xr-x  4 _mysql  _mysql  128 Mar 29 00:41 .
	drwxr-xr-x  5 root    wheel   160 Mar 27 15:38 ..
	srwxrwxrwx  1 _mysql  _mysql    0 Mar 28 22:48 mysqld.sock
	-rw-------  1 _mysql  _mysql    6 Mar 28 22:48 mysqld.sock.lock


--
Bill Cole
bill at scconsult.com or billcole at apache.org (AKA @grumpybozo and many *@billmail.scconsult.com addresses) Not For Hire (currently)


-- 
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus