[prev in list] [next in list] [prev in thread] [next in thread] 

List:       macports-users
Subject:    RE: Misbehaving mysql57-server
From:       "John Korchok" <jkorchok () gmail ! com>
Date:       2020-03-29 23:58:24
Message-ID: 192d01d60625$ef6a8360$ce3f8a20$ () gmail ! com
[Download RAW message or body]

With the addition of sudo, I get:

COMMAND PID USER    FD   TYPE DEVICE SIZE/OFF                  NODE       N=
AME
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, t=
he 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@lists.macports.org> On Behalf =
Of Bill Cole
Sent: Sunday, March 29, 2020 5:52 PM
To: macports-users@lists.macports.org
Subject: Re: Misbehaving mysql57-server

NOTE: There's no need to mail me copies of replies that are also sent to th=
e 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 ru=
n 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 loo=
k 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@scconsult.com or billcole@apache.org (AKA @grumpybozo and many *@billm=
ail.scconsult.com addresses) Not For Hire (currently)


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

[prev in list] [next in list] [prev in thread] [next in thread]