[HyperSQL] zlib.error: Error -5 while decompressing data: incomplete or truncated stream

Apparently, versions up to 3.9.8 have a problem with cleaning their own cache. As workaround, delete all the files in the cache directory:

del /f /s %install_direcotry_of_HyperSQL%\cache\*

rm -rf ${install_direcotry_of_HyperSQL}/cache/*

[Windoof] OneDrive unable to connect, Exploder crashes

Problem

You have M$ OneDrive and it is supposed to synch with a local folder.

• The tray icon keeps telling, there is no connection.
• Neither does it show any context menu, clicking on it.
• Exploring the folder at some point (not time but location) the exploder crashes. Maybe it does not actually crash, but it tries to sync and does not get a connection timeout. Either way, the system gets rather unusable.

Solution

Well, it is not guaranteed to work, but in my case there was a problem with the file system. As administrator execute

chkdsk /f

Having done so, you need to restart your computer. It will initiate a file system check.

In the likely event this does not help or you just do not want to try it: There is kind of a work around to the crashes (not the lack of synching). Do not use Windoof Exploder and no file manager based on its principles/API/whatsover. Which ones there are I cannot really tell. I know that Q-Dir and FileVoyager behave the same way as the Exploder. On the other hand, file opening dialogs of jEdit (Java application) works as well as FreeCommander XE, TreeSize and 7zip. This holds true for their PortableApps version as of time of writing. I suppose, they do not use the same calls as Exploder.

How to horizontal ellipsis (…)?

From time to time, I want to use the horizontal elipsis character, those three consecutive dots. But how?

• On Windows you can press [ALT]+([NUM 0], [NUM 1], [NUM 3] and [NUM 3]). 
• With jEdit Character Map, you find it on the General Punctiation block.
  

[Linux] Disable the keyboard joystick

At time, the keyboard joystick goes rampage sending the pointer flying all over the screen - ok, it is more like it makes it creep about. Be it as it may, one can switch of such sticks:

xinput --disable $(xinput --list | grep -F Stick | cut -d "=" -f 2 | cut -d '[' -f 1)

[tmux] recreate the same session

I often find my self starting a tmux session and recreating the same windows and so on in it again and again. I recon, for me it is easiest to use tmuxp, which is a tmux session manager written in Python. There are others like Tmuxinator and Teamocil, but since they are written in Ruby, but I am fairly familiar with Python only and thus usually have already Python installed on my system, I opt for tmuxp. You can write a shell script too if you like a the third links demonstrates.

Some links

• tmuxp helps you manage tmux workspaces.
• Writing your tmux config: a detailed guide
• How to create tmux session with a script

[tmux] How to scroll in history

I thought, it would need magic but acutally it is as simple as

[ctrl][B] and then [PgUp]

[DbVis] Monitor file details lacks database connection section

Locate the correct meta data file (.met) in the Monitors of the settings directory. Locate the

exec.connection

line and set the databse id as found in the active

configXYZ/dbvis.xml

file. Possibly you also need to set a value for

exec.schema

.

[DbVis] DBMS_OUTPUT not working

• Make sure to switch on polling in the DBMS_OUTPUT tab of DbVis
• Make sure to switch on server output of Oracle

  begin
      DBMS_OUTPUT.ENABLE();
  end;
  /

[Debian/Skolelinux/Ubuntu in fact any systemd based distribution] Management of System services/daemons

As expample, PostgreSQL installation of version 11 with cluster main is being used. Replace postgresql@11-main accordingly. Many services might not have clusters or even parallel versions, e.g. the ssh daemon.

Start service

sudo systemctl start postgresql@11-main

Stop service

sudo systemctl stop postgresql@11-main

Reload configuration of service

sudo systemctl reload postgresql@11-main

Restart service

sudo systemctl restart postgresql@11-main

Query status

sudo systemctl status postgresql@11-main

Make services start at boot

sudo systemctl enable postgresql@11-main

Release services from starting at boot

sudo systemctl disable postgresql@11-main

View log

If the viewing user is not in the group adm or systemd-journal, one neeeds to sudo. See also https://linuxhandbook.com/journalctl-command/

journalctl -u postgresql@11-main.service # to see the log entries of the PostgreSQL 11 main cluster
journalctl --follow --unit=ssh.service # to keep tracing the log entries of the ssh daemon

[VMware view on Debian] Athentication works but starting into the actual session ends with getting closed its window

Further symptoms

Starting VMware view on the console reveals:

terminate called after throwing an instance of 'boost::filesystem::filesystem_error'
  what():  boost::filesystem::create_directories: Permission denied: "/tmp/user/vmware-thiemo"

Environment

Product: VMware Horizon Client
Version: 2111
Build: 8.4.0 (build-18957622)
Host-OS: Linux 5.10.0-10-amd64
Gtk+-Version: 3.24.24
Glib-Version: 2.66.8

(Temporal) solution (adapt to your actual user)

The linked directory already existed.

sudo ln -s /tmp/vmware-thiemo /tmp/user/vmware-thiemo