MySQL SSL Gives Warnings about big name Certificate Authorities

I have been able to setup my MySQL to use LetsEncrypt certificates with the steps below, unfortunately it is issuing warnings about official certs being self-signed (like from DigiCert, Comodo, etc…), so I wonder if there’s something missing from the configuration. anyways, here’s my ssl configuration:

[mysqld] require_secure_transport = on mysqlx = 0 ssl_capath  = /etc/ssl/certs ssl_ca      = /etc/ssl/certs/lets-encrypt-x3-cross-signed.pem ssl_cert    = /etc/mysql/cert.pem ssl_key     = /etc/mysql/privkey.pem ssl_cipher  = DHE-RSA-AES256-GCM-SHA384 tls_version = TLSv1.2 

the problem

Everything in the ssl_capath comes up as a warning in the startup log (im doing tail -f /var/log/mysql/error.log):

YYYY-MM-DDTHH:mm:ss.SSSSSZ 0 [Warning] [MY-010068] [Server] CA certificate /etc/ssl/certs/SwissSign_Gold_CA_-_G2.pem is self signed. YYYY-MM-DDTHH:mm:ss.SSSSSZ 0 [Warning] [MY-010068] [Server] CA certificate /etc/ssl/certs/Trustwave_Global_ECC_P256_Certification_Authority.pem is self signed. ... 

background

the ssl_ca file is from doing wget https://letsencrypt.org/certs/lets-encrypt-x3-cross-signed.pem -O /etc/ssl/certs/lets-encrypt-x3-cross-signed.pem

the ssl_cert is from getting my LE live subfolder cert.pem file, same with the ssl_key (from LE’s privkey.pem). I’ve also restricted cipher and TLS version, but that’s probably not it.

To verify that everything is indeed working correctly, I have added the following to my client configuration (locally, not on that server):

[mysql] ssl_capath = /etc/ssl/certs 

and this session output:

user@localhost:~$   mysql --ssl-mode=VERIFY_IDENTITY -h mydomain.mytld -u remote -p -e "show variables like '%ssl%'; show session status like '%cipher%';" +-------------------------------------+-------------------------------------------------+ | Variable_name                       | Value                                           | +-------------------------------------+-------------------------------------------------+ | admin_ssl_ca                        |                                                 | | admin_ssl_capath                    |                                                 | | admin_ssl_cert                      |                                                 | | admin_ssl_cipher                    |                                                 | | admin_ssl_crl                       |                                                 | | admin_ssl_crlpath                   |                                                 | | admin_ssl_key                       |                                                 | | have_openssl                        | YES                                             | | have_ssl                            | YES                                             | | performance_schema_show_processlist | OFF                                             | | ssl_ca                              | /etc/ssl/certs/lets-encrypt-x3-cross-signed.pem | | ssl_capath                          | /etc/ssl/certs                                  | | ssl_cert                            | /etc/mysql/cert.pem                             | | ssl_cipher                          | DHE-RSA-AES256-GCM-SHA384                       | | ssl_crl                             |                                                 | | ssl_crlpath                         |                                                 | | ssl_fips_mode                       | OFF                                             | | ssl_key                             | /etc/mysql/privkey.pem                          | +-------------------------------------+-------------------------------------------------+ +--------------------------+------------------------------------------------------------------------------------------------------+ | Variable_name            | Value                                                                                                | +--------------------------+------------------------------------------------------------------------------------------------------+ | Current_tls_cipher       | DHE-RSA-AES256-GCM-SHA384                                                                            | | Current_tls_ciphersuites |                                                                                                      | | Ssl_cipher               | DHE-RSA-AES256-GCM-SHA384                                                                            | | Ssl_cipher_list          | TLS_AES_256_GCM_SHA384:TLS_CHACHA20_POLY1305_SHA256:TLS_AES_128_GCM_SHA256:DHE-RSA-AES256-GCM-SHA384 | +--------------------------+------------------------------------------------------------------------------------------------------+ 

Include page name in posts slug

I have created a custom page template with option to select a tag from posts Categories to query the respective posts with that tag when the page is opened.

Page with name Trips are created, custom template selected and also category tag Trips is selected.

Page is then added to the menu under About Us menu item.

When I open the page site.com/about-us/trips/ A custom template are loaded with all the posts with term Trips.

When I open the post, the URL of the post is site.com/trips/post-slug where "trips" are the category tag slug.

Is there any option for those posts to include their "parent" page slugs like in this example it would be site.com/about-us/trips/post-slug ?
I could set the category base as ‘about-us’, but that is not a solution because there could be multiple pages with that custom template and another category tag selected f.e. site.com/about-us/interviews/post-slug

I am sorry, I have no code example for what I have done so far as I dont even know where to start 🙂

SQL Server Data Tools – Data Link Properties – Server Name Drop Down Empty

I’m using VS 2019 with the latest version of SQL Server Integration Services Projects plugin. I have 2 local SQL Server instances installed on the same machine which are up and running (including Browser service). SQL Server is 2017 and 2019 (default and named instance respectively) and their Hide Instance flag is set to No. When adding Data Link for Data Flow SSIS tasks server drop down not showing my SQL instances like that: enter image description here

At the same time if I type in SQL Server instance name I can connect just fine. What can be causing my SQL instances not showing up here?

Disable custom taxonomy by name in function

I need delete some custom taxonomy with function. Users creates new taxonomies, but when user create any disabled taxonomy (for example named "custom_taxonomy1") so WP remove it with function (so blacklist for specific taxonomy name).

How can I delete with something like this:

If post type "custom_post_type" – do remove taxonomy with name array "custom_taxonomy1", "custom_taxonomy2"...

or with wp_remove_object_term() function

or I find this, but how achieve it:

function wpse_296972_pre_delete_term( $  term_id, $  taxonomy_name ) {     if ( $  taxonomy_name === 'organization' ) {         $  objects = get_objects_in_term( $  term_id, $  taxonomy );          // delete here .     } } add_action( 'pre_delete_term', 'wpse_296972_pre_delete_term' ); 

Cryptocurrency Product Review Blog with Great Brand Name

https://coin.camp

I've been in crypto since 2013, and created this blog a couple years ago as a hobby. I was too busy to continue with it shortly after. Now I thought someone else might be able to take over.

This is a starter blog with 4 unique articles and a custom logo. No traffic or earnings.
I wrote all the articles and designed the logo myself.
The domain name is great, short and catchy.
The blogging software is ghost – https://ghost.org. Ghost is very…

Cryptocurrency Product Review Blog with Great Brand Name