Hallo
also der Fehler besteht immer noch, die Domains (Zertifikate) mit www. sind immer valid und die ohne bleiben auf Pending stehen.
In den Logs habe ich folgende Fehler gefunden:
[2025/04/23 09:22:23.868520] [1370462|1370470] ERROR: Releasing db connection, but still have open statements
[2025/04/23 09:22:23.868532] [1370462|1370470] aborting SQL: 'UPDATE SSLFILEAUTH SET SFA_ERROR= 0, SFA_CONFIRMED= ? WHERE SFA_SERVERID = ? AND SFA_NAME = ? AND SFA_FILE = ? AND SFA_PATH = ?'
[2025/04/23 09:22:23.868566] [1370462|1370470] ERROR: Releasing db connection, but still have running transaction (-> forcing ROLLBACK)
[2025/04/23 09:22:23.868635] [1370462|1370470] Database exception: mysql_stmt_execute: (1020) Record has changed since last read in table 'SSLFILEAUTH' (SQL: UPDATE SSLFILEAUTH SET SFA_ERROR= 0, SFA_CONFIRMED= ? WHERE SFA_SERVERID = ? AND SFA_NAME = ? AND SFA_FILE = ? AND SFA_PATH = ?)
[2025/04/23 09:22:23.868923] [1370462|1370470] successfully wrote domain validation file '/.well-known/acme-challenge/pCA6NEc5lBTWOekwcRbeNLK2L1Ay6Zuwll2AFfkySJ0' for domain 'Kundendomain'
[2025/04/23 09:22:23.869051] [1370462|1370472] ERROR: Releasing db connection, but still have open statements
[2025/04/23 09:22:23.869060] [1370462|1370472] aborting SQL: 'UPDATE SSLFILEAUTH SET SFA_ERROR= 0, SFA_CONFIRMED= ? WHERE SFA_SERVERID = ? AND SFA_NAME = ? AND SFA_FILE = ? AND SFA_PATH = ?'
[2025/04/23 09:22:23.869100] [1370462|1370472] ERROR: Releasing db connection, but still have running transaction (-> forcing ROLLBACK)
[2025/04/23 09:22:23.869166] [1370462|1370472] Database exception: mysql_stmt_execute: (1020) Record has changed since last read in table 'SSLFILEAUTH' (SQL: UPDATE SSLFILEAUTH SET SFA_ERROR= 0, SFA_CONFIRMED= ? WHERE SFA_SERVERID = ? AND SFA_NAME = ? AND SFA_FILE = ? AND SFA_PATH = ?)
[2025/04/23 09:22:23.869327] [1370463|1370467] [LUA] Created SSL/TLS domain-validation file '/var/www/.well-known/htdocs/acme-challenge/www.Kundendomain.de.njj967gEVF9_2TzwWAc-vT6QWALkahb-0_zoWKicqf0'
[2025/04/23 09:22:23.869840] [1370462|1370472] successfully wrote domain validation file '/.well-known/acme-challenge/njj967gEVF9_2TzwWAc-vT6QWALkahb-0_zoWKicqf0' for domain 'http://www.Kundendomain.de'
[2025/04/23 09:22:36.713620] [1370462|1370829] Updating AppInstaller repository (https://update.liveconfig.com/repo-v3.json)...
Vielleicht kann man dadurch den Fehler besser finden.
In der Regel reicht ein:
systemctl restart liveconfig.service
um das Ausstellen der Zertifikate erneut anzustoßen.
Mit freundlichen Grüßen
Martin Krüger