Falsche Anfrage / Wrong QuerySQL when letsencrypt fails
When requesting an letsencrypt certificate, and for whatever reason the request fails i'm receiving the following error message:
02.10.2016-13:16 - WARNING - Falsche Anfrage / Wrong QuerySQL-Query = UPDATE web_domain SET ssl
= 'y', ssl_letsencrypt
= 'n' WHERE domain
= 'cxxx.xx' -> 1143 (UPDATE command denied to user 'ispcsrv12'@'xxxx' for column 'ssl' in table 'web_domain')
When updating and running: Reconfigure Permissions in master database ? does not fix the problem.
Digging into the update or installer code (installer_base.lib.php) specific the function: grant_master_database_rights i found out that for the web_domain table only the following columns are granted for the ispcsrv account: ssl_request
, ssl_cert
, ssl_action
, ssl_key
. I think we are missing the following 2 column also (which would fix the above error message): ssl
, ssl_letsencrypt
Will create a merge request for this.