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.