scripting / snippets / notepad

crpb · 2022-07-12T17:36:53+00:00

I will use this Thread as a collection of various Scripts and Hacks for the Community. For even more you could have a look in my public github grommunio rep...

crpb

sqlitestudio

FYI, sqlitestudio is now available in Debian Forky and Sid but you can even install it on Trixie w/o any dependency issues.
So for anyone who is also annoyed by sqlitebrowser and it's buggy interface. Switch now to an awesome sqlite tool for those times you need to fetch data from exmdb.sqlite3.

🥹

crpb

Force Schema-Upgrade after gromox update

To make sure all ~~domain and~~ user mailbox schemas will be upgraded you can use the following command

gromox-mbop foreach.mb.here \( echo-username \) \( ping \)

You can watch the progress in another window/session/pane

journalctl -f -u gromox-http

WalterH

To update the schema for the domain databases, you can use this command:

grommunio-admin domain query domainname | grep "\." | while read -r line; do i=$((i+1)); echo -e "\n\nTest / upgrade schema for $line - #$i."; grommunio-admin exmdb "$line" folder list; done

crpb

Debian / Chawan for html2plain

After discovering chawan in the gromox sources a while ago i got a DD hooked aswell so here is how you can make use of it easily with automatic updates in Debian.
To use chawan instead of w3m or pandoc you can install chawan from forky (while trixie is still stable).

The pinning prevents upgrading to forky packages by mistake tho if you still use -t forky or packagename=version it would still work. So you have been warned! And of course when you will upgrade to forky in a year or so you should delete the file 😛.

root@grom-deb:~# more /etc/apt/sources.list.d/forky.sources /etc/apt/preferences.d/chawan  |cat
::::::::::::::
/etc/apt/sources.list.d/forky.sources
::::::::::::::
Types: deb deb-src
URIs: http://deb.debian.org/debian
Suites: forky forky-updates
Include: chawan
Exclude: *
Components: main contrib non-free non-free-firmware
Signed-By: /usr/share/keyrings/debian-archive-keyring.gpg
::::::::::::::
/etc/apt/preferences.d/chawan
::::::::::::::
Package: *
Pin: release n=forky*,l=Debian*,o=Debian
Pin-Priority: -10

Package: chawan
Pin: release n=forky*,l=Debian*,o=Debian
Pin-Priority: 100
root@grom-deb:~# apt policy chawan
chawan:
  Installed: 0.4.4-1
  Candidate: 0.4.4-1
  Version table:
 *** 0.4.4-1 100
         -1 http://deb.debian.org/debian forky/main amd64 Packages
        100 /var/lib/dpkg/status
root@grom-deb:~# apt policy base-files
base-files:
  Installed: 13.8+deb13u6
  Candidate: 13.8+deb13u6
  Version table:
     14.2 -10
         -1 http://deb.debian.org/debian forky/main amd64 Packages
 *** 13.8+deb13u6 500
        500 http://deb.debian.org/debian trixie/main amd64 Packages
        100 /var/lib/dpkg/status

« Previous Page