April 3, 20215 yr Running the cron today delivered me an email with: Quote froxlor[5842]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '209' for key 'PRIMARY' froxlor[5842]: --- DEBUG: #0 /var/www/froxlor/lib/Froxlor/Database/Database.php(83): PDOStatement->execute(Array) #1 /var/www/froxlor/lib/Froxlor/Cron/Http/LetsEncrypt/AcmeSh.php(368): Froxlor\Database\Database::pexecute(Object(PDOStatement), Array) #2 /var/www/froxlor/lib/Froxlor/Cron/Http/LetsEncrypt/AcmeSh.php(296): Froxlor\Cron\Http\LetsEncrypt\AcmeSh::runAcmeSh(Array, Array, 'issue', Object(Froxlor\FroxlorLogger), 1, false) #3 /var/www/froxlor/lib/Froxlor/Cron/Http/HttpConfigBase.php(37): Froxlor\Cron\Http\LetsEncrypt\AcmeSh::run(true) #4 /var/www/froxlor/lib/Froxlor/Cron/System/TasksCron.php(148): Froxlor\Cron\Http\HttpConfigBase->init() #5 /var/www/froxlor/lib/Froxlor/Cron/System/TasksCron.php(52): Froxlor\Cron\System\TasksCron::rebuildWebserverConfigs() #6 /var/www/froxlor/lib/Froxlor/Cron/MasterCron.php(111): Froxlor\Cron\System\TasksCron::run() #7 /var/www/froxlor/scripts/froxlor_master_cronjob.php(20): Froxlor\Cron\MasterCron::run() #8 {main} We are sorry, but a MySQL - error occurred. The administrator may find more information in the syslog The syslog itself didn't show more, database integrity check said everything is okay, and a --force --debug runs through until a specific domain is ready for Let's Encrypt. (always the same) So i had a look at the database around the specific domain, but no duplicate entries found 😕 How to fix that? edit: now some steps further, in domain_ssl_settings there are some entries which have the same domainid, might this be the issue? If yes, which one to delete? THX
April 3, 20215 yr 21 minutes ago, lonesomewalker said: edit: now some steps further, in domain_ssl_settings there are some entries which have the same domainid, might this be the issue? If yes, which one to delete? Yes, there can of course only be ONE certificate per domain. no idea how you managed to get around that but the database design does not allow that. The entries should have a date in the field "expirationdate" - just keep the one that expires the latest
April 3, 20215 yr Author Okay, deleted the duplicated ones with older timestamps -> still the SQL error 😕 Since the debug message says acme, this should be somewhat related to SSL, right?
April 3, 20215 yr Author Ewww... is this right? There are two tables: panel_domains and panel_domainss What the...? I have never seen that in the past, how can this happen, and how to fix that? 😬
April 3, 20215 yr Just now, lonesomewalker said: Ewww... is this right? There are two tables: panel_domains and panel_domainss no of course not... 1 minute ago, lonesomewalker said: I have never seen that in the past, how can this happen, and how to fix that? 😬 Cannot tell you how, I'm not your system admin. 'panel_domainss' it not part of froxlor. 11 minutes ago, lonesomewalker said: Okay, deleted the duplicated ones with older timestamps -> still the SQL error 😕 Since the debug message says acme, this should be somewhat related to SSL, right? delete all of the dupliactes. You somehow seem to have managed to let froxlor think the domain should get a new entry instead of an update...very very bizarre...not idea how you've managed that. But given your additional table problem I'd suggest you check your system thoroughly
April 3, 20215 yr Author Okay, the duplicated table is solved; old backup. The ugly part: i think the SSL stuff can be solved by just deleting ALL the entries and do a full recreation. Unfortunately there is a rate limit... Any possibility to find the one duplicate? Already did a full search in the table, no duplicate so far.
Archived
This topic is now archived and is closed to further replies.