Question Obtain Letsencrypt flag "Select what else can be secured" from database

[mr-wolf]

I would like to issue an SQL-command that shows me all the domains that has the flag "Select what else can be secured" not selected.
It seems several clients are getting into troubles because of this.

Even when the website is not using it, Microsoft's Outlook mail settings discovery can stumble over it because it checks the https://www.<domain> before it checks the server set with an SRV-record and shows a certificate error now and then...


I can't seem to find where this flag is stored in the database

 

[IgorG]

You can enable Plesk debug mode and try to find related SQL query in panel.log when you select or unselect this option.

 

[mr-wolf]

Hi Igor, thanks for this hint...
I tried this and have been looking at those logs for quite a while, but I can't see where that flag is.
It's not that it only updates that flag.
It is doing a lot of stuff.

Would it be possible to ask one of the technicians?
This would be really valuable information for me and others.

I can return the favour to the community by writing and publishing a script here that enables all Plesk users to do the same.

I have written several scripts that checks configurations.
An example is a script that shows all domains that have mail enabled whilst the MX-records in fact point to another server.
Or setting all TTL records to the default values when they are set different.

 

[IgorG]

Developers have informed that these flags are not stored in the database, but are parsed on the fly from certificates. They offered a script that does it.

 

[mr-wolf]

Thanks Igor and thanks to them....

Here's how I get a list of "1 dot domains" that don't have WWW set using that script:

php cert.php | grep -B1 'Has WWW.*No' | grep -v '\..*\.' | grep ^Domain

Having that list of domains I could then correct all the domains on that server.

Thanks