Mysql says it failed to start but is up anyway?

I’me running MySQL 8 under Ubuntu 20.04 WSL2

I’m starting MySQL with sudo service mysql restart

Output is:

* Stopping MySQL database server mysqld      [ok] * Starting MySQL database server mysqld      [fail] 

But when I now run sudo service mysql status, I get:

 * /usr/bin/mysqladmin  Ver 8.0.21-0ubuntu0.20.04.4 for Linux on x86_64 ((Ubuntu)) Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.  Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.  Server version          8.0.21-0ubuntu0.20.04.4 Protocol version        10 Connection              Localhost via UNIX socket UNIX socket             /var/run/mysqld/mysqld.sock Uptime:                 45 sec  Threads: 2  Questions: 4  Slow queries: 0  Opens: 430  Flush tables: 3  Open tables: 27  Queries per second avg: 0.088 

Error log is:

2020-09-11T22:15:33.048074Z 11 [System] [MY-013172] [Server] Received SHUTDOWN from user debian-sys-maint. Shutting down mysqld (Version: 8.0.21-0ubuntu0.20.04.4). 2020-09-11T22:15:33.136150Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4)  (Ubuntu). 2020-09-11T22:15:33.231510Z mysqld_safe mysqld from pid file /var/lib/mysql/LAPTOP-77E86FL8.pid ended 2020-09-11T22:15:34.784720Z mysqld_safe Logging to '/var/log/mysql/error.log'. 2020-09-11T22:15:35.002180Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2020-09-11T22:15:35.073728Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 1024 (requested 8161) 2020-09-11T22:15:35.073742Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 431 (requested 4000) 2020-09-11T22:15:35.392127Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 6495 2020-09-11T22:15:35.412902Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2020-09-11T22:15:35.992356Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2020-09-11T22:15:36.261631Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock 2020-09-11T22:15:36.404215Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2020-09-11T22:15:36.404659Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2020-09-11T22:15:36.456568Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.21-0ubuntu0.20.04.4'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu). 

My issue is that sudo service mysql restart returns a non-zero status code.

What may I check or look for?

Thank you!

Fey Ancestry says “Magic can’t put you to sleep” and Brass Dragon has the ability to “exhales sleep gas”. Does the breath weapon affect elves?

I always assumed that elves/half elves were just immune to sleep effects, but re-reading Fey Ancestry, it says “magic can’t put you to sleep”.

Brass Dragons and Kamadans (Tomb of Annihilation p225) have Sleep Breath, and I just assumed it wouldn’t affect elves, but now I’m not so sure.

Am I just overthinking it?

Are there any other magical sleep effects besides the Sleep spell? If not, then I would assume it’s intended to include sleeping gas. But maybe the Fey Ancestry is a mix of magic resistance and “elves don’t sleep” so it really is just against magical sleep?

HTTP2 is enabled and working, but PHP $_SERVER[‘SERVER_PROTOCOL’] still says “HTTP/1.1”

I’ve been migrating to a new host (AWS Lightsail with a Ubuntu instance) and while everything is working just fine I’m running into a quirk that I can’t quite figure out.

I’ve enabled HTTP2 on my virtual server and confirmed that files are using that protocol (via DevTools and http2.pro):

HTTP2 working in DevTools

HTTP2 working per http2.pro

For reference, here is my server showing the Apache HTTP2 mod is enabled (and I did restart apache afterwords)

http2 mod already enabled

However, in PHP when I output $ _SERVER['SERVER_PROTOCOL'] on my server it is still showing "HTTP/1.1":

http1.1

php code

But this same exact software (WordPress theme) on other servers is showing "HTTP/2.0" correctly:

http2 detected with same exact code

I believe I have my Apache2 conf files setup correctly:

Port 443:

<VirtualHost *:443>     Protocols h2 h2c http/1.1 

and just to be thorough I did Port 80 as well:

<VirtualHost *:80>     Protocols h2 h2c http/1.1 

Unfortunately I do not have access to the conf files (or ssh) on the server that is working, so I can’t cross-reference those files.

I’ve been reading a bunch of tutorials on HTTP2 to see if there is any additional setting or configuration that I may have missed, but most are showing the same instructions that I’ve implemented.

Can anyone point me in the right direction as to why this PHP "detection" is incorrectly displaying the protocol, or if there is something I missed that is preventing PHP from using HTTP2 in this one situation?

it says, N Integrate has evaluated to non-numerical values for all sampling points in the region with boundaries {{0,20}

when I run the code it says,NIntegrate has evaluated to non-numerical values for all sampling points in the
region with boundaries {{0,20}

\[Chi][b_] := (Z/k1)*NIntegrate[Subscript[f, pp1][q]*Subscript[F, pp1][q]*BesselJ[0, q*b]*q, {q, 0, b}] +  (Nn/K1)*NIntegrate[Subscript[f, pn1][q]*Subscript[F, pn1][q]*BesselJ[0, q*b]*q, {q, 0, b}]   data = Table[{b, \[Chi][b]}, {b, 0, 5.1, 0.1}]   

LetsEncrypt says “DNS validation failed”. Site is behind Cloudflare

Hello, i tried to disable FULL SSL option in my cloudflare account to become "Off" and then attempt to setup wildcard free LetsEncrypt certificate from within DirectAdmin control panel. But it continue to fail. "DNS validation failed"
I would rather think it is problem related to Cloudflare. Maybe i have to "Pause" cloudflare for that domain entirely and retry?

This issue is interesting because also the Gmail is unable to connect mail.mydomain.com using SSL even the "Full SSL" is enabled in…

LetsEncrypt says "DNS validation failed". Site is behind Cloudflare

Google says text too small too read when all text on the page is 14 point

I’m having no end of problems trying to get my site listed on Google. It was sitting right at the top of the rankings. Then, after I’d added a couple of extra sponsor logos, the mobile crawler decided the home page has “text to small to read.” Every bit of text on all 63 pages in the wbsite is 14 points or more. It has said this is the case on 5 pages of the site… I’ve checked each page and there’s nothing under 14 point. In addition it’s saying 7 pages have clickable elements too close together and that 5 have content wider than the screen. I’ve checked each page rigouously and re-submitted with no luck… the same 5 pages keep getting singled out. The site is for a festival that takes place in 3 weeks, so solving this problem is urgent

How to deal with a player who says no all the time?

I am a fairly new DM. I am playing with a group I have tried to DM and have played with as a PC. There is one person in that group that plays as a PC that says no, AKA he is the opposite of a murder hobo.

When faced with a decision or a turning point in the story he will say no to most of the possible outcomes and bring the story to a halt because either the DM is trying to come up with another method to put to the players, the party is arguing about what to do now, or the other players just want to follow his lead and he doesn’t want to do anything.

He does this to see how frustrated the DM can get before giving up and then complains that we don’t play because no one wants to deal with this every single time.

I am the DM for the next campaign and I am looking for an advice on how to deal with him. The common methods of just killing his character or excluding him but I don’t want to that. I want him and everyone to have fun and be a part of it but I also don’t want to get frustrated with his play style.

What can I do to either deal with him as PC or can I do anything as a DM to help the story without the mental state of “No I am God you will do what I tell you and that is the story”?

[ Politics ] Open Question : In 2016 Sen.Bernie Sanders encouraged Elizabeth Warren to run for president. Now she says he’s sexist. Why is she lying like Hillary Clinton?

If anything, she’s turned many progressives against her as many are demanding refunds of donations made to her campaign.  Why value does she and Hillary see in attacking progressives instead of Trump?

I’m using PHP 7.1 but Hostgator says they are on 5.4, and Cron throws an error

Trying to make sense of this. Doing a quick phpinfo() I get:

PHP Version 7.1.14 System  Linux gatorxxxxx.hostgator.com n.nn.nnn-nnn.nnn.nnn.x86_64 #1 SMP Tue May 21 13:24:40 CDT 2019 x86_64 

But when I try to install a cron that hits a URL every 30 days for the Auto-Install-free-SSL plugin that I’ve been using for years on a different host, cron reports:

Your server is running PHP version 5.4.45 but WordPress 5.3.2 requires at least 5.6.20.

Got Hostgator on the phone and they reported that all shared hosts are still on 5.4.x which fits the error message, but if phpinfo() is showing I’m on 7.1… what the heck is actually going on here? How can I get cron to also use 7.1 so the command will execute?