Difference between revisions of "Workarounds"

From wiki
(Add roundcube/fail2ban)
(Kmail: Multiple merge candidates, aborting)
 
(One intermediate revision by the same user not shown)
Line 11: Line 11:
 
https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=810287
 
https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=810287
  
Path to log overridden in <code>/etc/fail2ban/jail.d/roundcube-auth.conf</code>  
+
Path to log overridden in <code>/etc/fail2ban/jail.d/roundcube-auth.conf</code>
 +
 
 +
== laptop_mode not reapplied on resume from suspend ==
 +
Bug: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=798777
 +
 
 +
Created file <code>/lib/systemd/system-sleep/laptop-mode.sh</code> <syntaxhighlight lang="shell">
 +
#!/bin/sh
 +
 
 +
case "$1" in
 +
  pre )
 +
    ;;
 +
  post )
 +
    sleep 5 && /usr/sbin/laptop_mode force
 +
    ;;
 +
esac
 +
</syntaxhighlight>File is not in <code>/etc</code> due to https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=787711
 +
 
 +
== Kmail: Multiple merge candidates, aborting ==
 +
This [https://bugs.kde.org/show_bug.cgi?id=338658 sadly famous Kmail bug] will block synchronization of you email. Unfortunately there is no way to find the problematic email through the UI.
 +
 
 +
To find duplicate run the following using the ''DB Console'' tab from ''Akonadi Console''<syntaxhighlight lang="sql">
 +
SELECT pimitemtable.*, collectiontable.name FROM pimitemtable
 +
INNER JOIN pimitemtable dup ON pimitemtable.id != dup.id and pimitemtable.remoteId = dup.remoteId and pimitemtable.collectionId = dup.collectionId
 +
INNER JOIN collectiontable ON pimitemtable.collectionId = collectiontable.id
 +
ORDER by pimitemtable.remoteId
 +
</syntaxhighlight>To delete duplicates, you can run<syntaxhighlight lang="sql">
 +
DELETE FROM pimitemtable WHERE pimitemtable.id in (
 +
    SELECT id FROM (
 +
        SELECT id FROM pimitemtable
 +
        LEFT OUTER JOIN (
 +
            SELECT MIN(pimitemtable.id) as RowId, pimitemtable.remoteId, pimitemtable.collectionId FROM pimitemtable GROUP by pimitemtable.remoteId, pimitemtable.collectionId
 +
        )
 +
        as KeepRows ON pimitemtable.id = KeepRows.RowId
 +
        WHERE KeepRows.RowId IS NULL
 +
    ) AS foo
 +
)
 +
</syntaxhighlight>
 
[[Category:TODO]]
 
[[Category:TODO]]

Latest revision as of 21:50, 11 December 2016

Digikam

Crash when using bracketing fusion tool

https://bugs.kde.org/show_bug.cgi?id=354364

$ cd ~/.kde/share/apps/digikam
$ mkdir toolbar
$ cp /usr/share/icons/oxygen/22x22/animations/process-working.png toolbar

https://bugs.kde.org/show_bug.cgi?id=354364#c29

Roundcube/Fail2ban

https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=810287

Path to log overridden in /etc/fail2ban/jail.d/roundcube-auth.conf

laptop_mode not reapplied on resume from suspend

Bug: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=798777

Created file /lib/systemd/system-sleep/laptop-mode.sh

#!/bin/sh

case "$1" in
  pre )
    ;;
  post )
    sleep 5 && /usr/sbin/laptop_mode force
    ;;
esac

File is not in /etc due to https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=787711

Kmail: Multiple merge candidates, aborting

This sadly famous Kmail bug will block synchronization of you email. Unfortunately there is no way to find the problematic email through the UI.

To find duplicate run the following using the DB Console tab from Akonadi Console

SELECT pimitemtable.*, collectiontable.name FROM pimitemtable
INNER JOIN pimitemtable dup ON pimitemtable.id != dup.id and pimitemtable.remoteId = dup.remoteId and pimitemtable.collectionId = dup.collectionId
INNER JOIN collectiontable ON pimitemtable.collectionId = collectiontable.id
ORDER by pimitemtable.remoteId

To delete duplicates, you can run

DELETE FROM pimitemtable WHERE pimitemtable.id in (
    SELECT id FROM (
        SELECT id FROM pimitemtable
        LEFT OUTER JOIN (
            SELECT MIN(pimitemtable.id) as RowId, pimitemtable.remoteId, pimitemtable.collectionId FROM pimitemtable GROUP by pimitemtable.remoteId, pimitemtable.collectionId
        )
        as KeepRows ON pimitemtable.id = KeepRows.RowId
        WHERE KeepRows.RowId IS NULL
    ) AS foo
)