Resolved how to obtain the SSL/TLS certificate used for mail?

[Pnia]

Is there any way to get the certificate used in mail server?


I can get if a domain is using DKIM for outgoing email with spam-protect-sign field of the api call for Mail Service Preferences Mail Service Preferences because the Extensions API (Extensions API Documentation - Plesk 18.0) don't expose it.

I dont find nothing about the certificate used for mail in Extensions API nor XML API.

 

[Pnia]

Nor can it be done by command line mailserver: Mail Server Settings

 

[Pnia]

I've found "something"

In the database there is something thatmight be what i'm looking for

SELECT * FROM `Parameters` WHERE parameter='mail_certificate_id'

what the field 'id' in that table refers to?

Can i connect to database from an extension? maybe calling the command line?

 

[Pnia]

This Query shows the information i need.

SELECT d.name,ds.type,c.name
FROM domains d
LEFT JOIN DomainServices ds ON ds.dom_id=d.id AND ds.type='mail'
LEFT JOIN Parameters p ON p.id=ds.parameters_id AND p.parameter='mail_certificate_id'
LEFT JOIN certificates c ON c.id=p.value

Is there any way to execute queries in database from an extension?

Thanks.

 

[vimobe]

I have no idea because I always secure and select certificate from the plesk panel itself

 

[Pnia]

Thanks for your answer, i know it, but I mean with code, in an extension.

 

[Pnia]

If someone needs it, this is how you can make a database query from an extension

$data= pm_Bootstrap::getDbAdapter()->query("SELECT * FROM table")->fetchAll();