Technical Stuff

Windows Dienste - Abhängigkeiten erstellen

Mitunter muss man Abhängikeiten von Windows-Diensten (ein Dienst kann nur gestartet werden, wenn ein Anderer bereits läuft) ändern. Ein simples Editieren oder Löschen aus der Registry reicht dabei nicht aus. Einfach und vorallem erfolgsversprechender ist es, mit dem passenden Befehl zu arbeiten.

Auszug aus der Hilfe des „sc“-Befehls:

sc config [Dienstname] depend= <Abhängigkeiten (getrennt durch / (Schrägstrich))>

Zu beachten ist die Leerstelle nach „depend= „.

Alle Abhängikeiten entfernen:

sc config [DIENSTNAME] depend= /

Beispielsweise wurde bei einem Kunden benötigt, nachdem von MySQL 5.6 auf MySQL 5.7 umgestellt wurde und die Dienst-Abhängigkeit eines hMailServer zu ändern:

sc config hMailServer depend= RPCSS/MySQL57

Erst nach dieser Änderung lies sich der hMailServer-Dienst wieder erfolgreich starten.

SQL Abfragen

SELECT 
  date(alarm_log.timedate), 
  COUNT(alarm_log.source)
FROM 
  fms01.alarm_log
WHERE 
  alarm_log.source LIKE 'U_Phoenix_101%' AND 
  alarm_log.messages LIKE '%Increase%'
GROUP BY
  date(alarm_log.timedate)
ORDER BY
  date(alarm_log.timedate) ASC
;





SELECT 
  alarm_log.timedate, 
  alarm_log.source,
  alarm_log.messages
FROM 
  fms01.alarm_log
WHERE 
  alarm_log.source LIKE '%PAC%02%' AND 
  alarm_log.messages NOT LIKE '%Increase%'

ORDER BY
  alarm_log.timedate ASC
;

SELECT 
  event_log.timedate, 
  event_log.source,
  event_log.messages
FROM 
  fms01.event_log
WHERE 
  event_log.messages LIKE '%state%' AND
  event_log.source LIKE '%AG%' AND
  event_log.messages NOT LIKE '%Unit Working%'
ORDER BY
  event_log.timedate ASC
;

Mit Python eine CSV Datei modifizieren (löschen)

mport pandas as pd
import os

directory = '.'

for filename in os.listdir(directory):
    if filename.endswith(".csv") and not filename.startswith('changed_'):
        
        input_file = filename
        output_file = "changed_" + filename

        if not os.path.exists(output_file):
            print(input_file)
            print(output_file)
            df = pd.read_csv(input_file, usecols=range(6))
            dfnew = df.drop('Comment', axis=1)
            export_csv = dfnew.to_csv (output_file, index = None, header=True)

JPEG Fotos aren't displayed in LCD160CR

I have created an image in JPG with 160x128 Pixels, 144 dpi and 24 Bitdepth. But with every exporting try in GIMP it can't be read. This is the Code in Python:

    path_startImage='/home/pi/logo.jpg'
    with open(path_startImage,'rb') as f:
        logo=f.read()

Now I finally have found a solution. It seems GIMP (and other tools) are putting too much info into the jpeg and the LCD160CR can't read it correctly.

Steps I have done:

sudo apt-get install libjpeg-turbo-progs
jpegtran logo.jpg > logo_opt.jpg
Changed the path_startImage to the new logo:
path_startImage='/home/pi/logo_opt.jpg'

That's it :)

Some mad stuff to remember - UART2, GPIO, Python and stuff

I am running an DietPi (downloaded on dietpi -> NanoPi Air) on a NanoPi Air. These are the huddles I had:

Theme: UART2 and i2c0

Afer reading and reading and reading the web, there was one simple solution. And I mean really simple!!

Error: serial.serialutil.SerialException: Could not configure port: (5, 'Input/output error')

connected to the SSH:

sudo vim /boot/armbianEnv.txt

and changed this line:

overlays=usbhost2 usbhost3 uart2 i2c0

Theme: GPIO with python3

After trying to use RPi.GPIO or NPi.GPIO or RPi.GPIO_NP or whatever, I always got the error that my NanoPi Air isn't a Raspberry or with the NPi.GPIO not an NanoPI device. Which is really strange.

Error Message:

RuntimeError: This module can only be run on a Raspberry Pi!

RuntimeError: This module can only be run on a NanoPi!

But one of the RPi.GPIO helped me out:

https://github.com/auto3000/RPi.GPIO_NP/blob/master/INSTALL.txt

If you are using armbian on NanoPi Neo/Neo2:

1. clone repository and install to your home dir

git clone https://github.com/auto3000/RPi.GPIO_NP

cd RPi.GPIO_NP

2. install library

python3 setup.py install

or if you are using python 2.x

python2 setup.py install

3. Test installation. Run python console and try to import RPi.GPIO

python

>>> import RPi.GPIO as GPIO

if above command didn't throw error everything should be ok.

If you received:

File "<stdin>", line 1, in <module>

ImportError: No module named 'RPi.GPIO'

try:

>>> import RPi._GPIO

   If you still get error something went wrong. Try to reboot and check if import works OK.

5. Run your first python code using GPIO:

create file test.py:

nano ./test.py

paste following code:

#!/usr/bin/python3

import RPi.GPIO as GPIO

import time

led = 12

GPIO.setmode(GPIO.BOARD)

GPIO.setwarnings(False)

GPIO.setup(led,GPIO.OUT)

i=0

while i<10:

print("LED on")

time.sleep(1)

print("LED off")

GPIO.output(led,GPIO.LOW)

time.sleep(1)

i=i+1

save file with ctrl+x and run the code:

sudo ./test.py

please remeber /dev/mem is writeprotected under Armbian and only root can access this device. This feature prevents anyone (even those in kmem group) to access GPIO ports! Original RPi.GPIO library under raspbian use /dev/gpiomem that allow anyone access to gpio memory connected  to GPIO and forbids access to other addresses. At the moment there is no solution to freely access GPIO ports. 

Theme: GPIO with bash

Source: https://raspberrypi-aa.github.io/session2/bash.html

#   Exports pin to userspace
echo "18" > /sys/class/gpio/export                  

# Sets pin 18 as an output
echo "out" > /sys/class/gpio/gpio18/direction

# Sets pin 18 to high
echo "1" > /sys/class/gpio/gpio18/value

# Sets pin 18 to low
echo "0" > /sys/class/gpio/gpio18/value

installing NI LabView Runtime - Error

http://www.catalog.update.microsoft.com/Search.aspx?q=KB4482887

https://knowledge.ni.com/KnowledgeArticleDetails?id=kA00Z0000019YOnSAM&l=de-DE

Issue Details

I have recently updated my computer to Windows 10 operating system and I discovered that NI software installers can not run anymore. I am getting an error message thrown by Microsoft Visual C++ Runtime Library:

Runtime Error!

Program:
<Path to executable>

This application has requested the Runtime to terminate it in
an unusual way.
Please contact the application's support team for more
information.

The result is the same no matter what NI installer I try to run (LabVIEW, Drivers (ie: NI-DAQmx), VeriStand, DIAdem, patches, both 32/64-bit versions, etc). Other (non-NI) installers work fine and already installed NI software also work fine.

Solution

This issue has been known to occur on Windows 10 systems updated to version 1809 (the September 2018 update) that use a certain subset of all "Regional format"s of the form English (<My Country>). Microsoft has published an update to Windows 10 version 1809 in KB4482887 that resolves the error. The same issue occurs in Windows 10 version 1903 (released in August 2019), though as no update to Windows that resolves the error has been published, please follow the steps below.

To determine what version of Windows 10 you are running, type "winver.exe" into the Windows Start Menu and hit enter.

The following Regional format settings have been confirmed to cause this issue:

English (Sweden)
English (Denmark)
English (Netherlands)
English (Switzerland)
English (Germany)
English (Europe)

Here are some examples that do work:

English (United Kingdom)
English (Belgium)
English (United States)
Dansk (Danmark)

To obtain the update to Windows 10:

Open the Start menu
Click the Settings gear
Click Update & security
Click Check for updates

If you are unable to install the update or attempting to fix the issue for Windows v1903, to get past this error you can:

Open the Windows Start Menu and type "Region Settings", then hit enter (screenshot below)
Change the Region Format to one of the known working regions included above and close the dialog.
Run the installer and reboot if prompted.
Change the region setting back to its original language.
If there are different accounts in the computer, change the settings of the Administrator Account. Changing only the settings of other accounts may not fix the issue.

Additional Information

This error is happening because Microsoft changed a longstanding behaviour of a language system API in Windows 10 v1809 and again in v1903 that results in the fatal installer error.

This error will be encountered while running the following types of NI installers:

Any product installer released in 2011 or later.
Any installer created by NI Software (LabVIEW, TestStand, etc.) will build correctly but crash when run.
Installers run by NI Update Service.
Installers built in LabVIEW 2019 are not affected by this issue, though it is yet to be confirmed whether all 2019 versions of NI software are unaffected by this issue.

Can't access shared folder from Linux VM Virtualbox

Windows Host - Linux VM Virtualbox

in Linux-Terminal:

sudo usermod -G vboxsf -a $USER

VIM cheat Sheet

from https://vim.rotrr.com:

Global

:h[elp] keyword - open help for keyword
:sav[eas] file - save file as
:clo[se] - close current pane
:ter[minal] - open a terminal window
K - open man page for word under the cursor

Tip Run vimtutor in a terminal to learn the first Vim commands.

Cursor movement

h - move cursor left
j - move cursor down
k - move cursor up
l - move cursor right
H - move to top of screen
M - move to middle of screen
L - move to bottom of screen
w - jump forwards to the start of a word
W - jump forwards to the start of a word (words can contain punctuation)
e - jump forwards to the end of a word
E - jump forwards to the end of a word (words can contain punctuation)
b - jump backwards to the start of a word
B - jump backwards to the start of a word (words can contain punctuation)
% - move to matching character (default supported pairs: '()', '{}', '[]' - use :h matchpairs in vim for more info)
0 - jump to the start of the line
^ - jump to the first non-blank character of the line
$ - jump to the end of the line
g_ - jump to the last non-blank character of the line
gg - go to the first line of the document
G - go to the last line of the document
5gg or 5G - go to line 5
fx - jump to next occurrence of character x
tx - jump to before next occurrence of character x
Fx - jump to previous occurence of character x
Tx - jump to after previous occurence of character x
; - repeat previous f, t, F or T movement
, - repeat previous f, t, F or T movement, backwards
} - jump to next paragraph (or function/block, when editing code)
{ - jump to previous paragraph (or function/block, when editing code)
zz - center cursor on screen
Ctrl + e - move screen down one line (without moving cursor)
Ctrl + y - move screen up one line (without moving cursor)
Ctrl + b - move back one full screen
Ctrl + f - move forward one full screen
Ctrl + d - move forward 1/2 a screen
Ctrl + u - move back 1/2 a screen

Tip Prefix a cursor movement command with a number to repeat it. For example, 4j moves down 4 lines.

Insert mode - inserting/appending text

i - insert before the cursor
I - insert at the beginning of the line
a - insert (append) after the cursor
A - insert (append) at the end of the line
o - append (open) a new line below the current line
O - append (open) a new line above the current line
ea - insert (append) at the end of the word
Ctrl + h - delete the character before the cursor during insert mode
Ctrl + w - delete word before the cursor during insert mode
Ctrl + j - begin new line during insert mode
Ctrl + t - indent (move right) line one shiftwidth during insert mode
Ctrl + d - de-indent (move left) line one shiftwidth during insert mode
Ctrl + n - insert (auto-complete) next match before the cursor during insert mode
Ctrl + p - insert (auto-complete) previous match before the cursor during insert mode
Ctrl + rx - insert the contents of register x
Esc - exit insert mode

Editing

r - replace a single character
J - join line below to the current one with one space in between
gJ - join line below to the current one without space in between
gwip - reflow paragraph
g~ - switch case up to motion
gu - change to lowercase up to motion
gU - change to uppercase up to motion
cc - change (replace) entire line
C - change (replace) to the end of the line
c$ - change (replace) to the end of the line
ciw - change (replace) entire word
cw - change (replace) to the end of the word
s - delete character and substitute text
S - delete line and substitute text (same as cc)
xp - transpose two letters (delete and paste)
u - undo
U - restore (undo) last changed line
Ctrl + r - redo
. - repeat last command

Marking text (visual mode)

v - start visual mode, mark lines, then do a command (like y-yank)
V - start linewise visual mode
o - move to other end of marked area
Ctrl + v - start visual block mode
O - move to other corner of block
aw - mark a word
ab - a block with ()
aB - a block with {}
at - a block with <> tags
ib - inner block with ()
iB - inner block with {}
it - inner block with <> tags
Esc - exit visual mode

Tip Instead of b or B one can also use ( or { respectively.

Visual commands

> - shift text right
< - shift text left
y - yank (copy) marked text
d - delete marked text
~ - switch case
u - change marked text to lowercase
U - change marked text to uppercase

Registers

:reg[isters] - show registers content
"xy - yank into register x
"xp - paste contents of register x
"+y - yank into the system clipboard register
"+p - paste from the system clipboard register

Tip Registers are being stored in ~/.viminfo, and will be loaded again on next restart of vim.

Tip Special registers:

0 - last yank
" - unnamed register, last delete or yank
% - current file name
# - alternate file name
* - clipboard contents (X11 primary)
+ - clipboard contents (X11 clipboard)
/ - last search pattern
: - last command-line
. - last inserted text
- - last small (less than a line) delete
= - expression register
_ - black hole register

Marks and positions

:marks - list of marks
ma - set current position for mark A
`a - jump to position of mark A
y`a - yank text to position of mark A
`0 - go to the position where Vim was previously exited
`" - go to the position when last editing this file
`. - go to the position of the last change in this file
`` - go to the position before the last jump
:ju[mps] - list of jumps
Ctrl + i - go to newer position in jump list
Ctrl + o - go to older position in jump list
:changes - list of changes
g, - go to newer position in change list
g; - go to older position in change list
Ctrl + ] - jump to the tag under cursor

Tip To jump to a mark you can either use a backtick (`) or an apostrophe ('). Using an apostrophe jumps to the beginning (first non-black) of the line holding the mark.

Macros

qa - record macro a
q - stop recording macro
@a - run macro a
@@ - rerun last run macro

Cut and paste

yy - yank (copy) a line
2yy - yank (copy) 2 lines
yw - yank (copy) the characters of the word from the cursor position to the start of the next word
y$ - yank (copy) to end of line
p - put (paste) the clipboard after cursor
P - put (paste) before cursor
dd - delete (cut) a line
2dd - delete (cut) 2 lines
dw - delete (cut) the characters of the word from the cursor position to the start of the next word
D - delete (cut) to the end of the line
d$ - delete (cut) to the end of the line
x - delete (cut) character

Indent text

>> - indent (move right) line one shiftwidth
<< - de-indent (move left) line one shiftwidth
>% - indent a block with () or {} (cursor on brace)
>ib - indent inner block with ()
>at - indent a block with <> tags
3== - re-indent 3 lines
=% - re-indent a block with () or {} (cursor on brace)
=iB - re-indent inner block with {}
gg=G - re-indent entire buffer
]p - paste and adjust indent to current line

Exiting

:w - write (save) the file, but don't exit
:w !sudo tee % - write out the current file using sudo
:wq or :x or ZZ - write (save) and quit
:q - quit (fails if there are unsaved changes)
:q! or ZQ - quit and throw away unsaved changes
:wqa - write (save) and quit on all tabs

Search and replace

/pattern - search for pattern
?pattern - search backward for pattern
\vpattern - 'very magic' pattern: non-alphanumeric characters are interpreted as special regex symbols (no escaping needed)
n - repeat search in same direction
N - repeat search in opposite direction
:%s/old/new/g - replace all old with new throughout file
:%s/old/new/gc - replace all old with new throughout file with confirmations
:noh[lsearch] - remove highlighting of search matches

Search in multiple files

:vim[grep] /pattern/ {`{file}`} - search for pattern in multiple files

e.g. :vim[grep] /foo/ **/*

:cn[ext] - jump to the next match
:cp[revious] - jump to the previous match
:cope[n] - open a window containing the list of matches
:ccl[ose] - close the quickfix window

Tabs

:tabnew or :tabnew {page.words.file} - open a file in a new tab
Ctrl + wT - move the current split window into its own tab
gt or :tabn[ext] - move to the next tab
gT or :tabp[revious] - move to the previous tab
#gt - move to tab number #
:tabm[ove] # - move current tab to the #th position (indexed from 0)
:tabc[lose] - close the current tab and all its windows
:tabo[nly] - close all tabs except for the current one
:tabdo command - run the command on all tabs (e.g. :tabdo q - closes all opened tabs)

Working with multiple files

:e[dit] file - edit a file in a new buffer
:bn[ext] - go to the next buffer
:bp[revious] - go to the previous buffer
:bd[elete] - delete a buffer (close a file)
:b[uffer]# - go to a buffer by index #
:b[uffer] file - go to a buffer by file
:ls or :buffers - list all open buffers
:sp[lit] file - open a file in a new buffer and split window
:vs[plit] file - open a file in a new buffer and vertically split window
:vert[ical] ba[ll] - edit all buffers as vertical windows
:tab ba[ll] - edit all buffers as tabs
Ctrl + ws - split window
Ctrl + wv - split window vertically
Ctrl + ww - switch windows
Ctrl + wq - quit a window
Ctrl + wx - exchange current window with next one
Ctrl + w= - make all windows equal height & width
Ctrl + wh - move cursor to the left window (vertical split)
Ctrl + wl - move cursor to the right window (vertical split)
Ctrl + wj - move cursor to the window below (horizontal split)
Ctrl + wk - move cursor to the window above (horizontal split)

Diff

zf - manually define a fold up to motion
zd - delete fold under the cursor
za - toggle fold under the cursor
zo - open fold under the cursor
zc - close fold under the cursor
zr - reduce (open) all folds by one level
zm - fold more (close) all folds by one level
zi - toggle folding functionality
]c - jump to start of next change
[c - jump to start of previous change
do or :diffg[et] - obtain (get) difference (from other buffer)
dp or :diffpu[t] - put difference (to other buffer)
:diffthis - make current window part of diff
:dif[fupdate] - update differences
:diffo[ff] - switch off diff mode for current window

Tip The commands for folding (e.g. za) operate on one level. To operate on all levels, use uppercase letters (e.g. zA).

Tip To view the differences of files, one can directly start Vim in diff mode by running vimdiff in a terminal. One can even set this as git difftool.

Additional Resources

Languages

About the vim cheat sheet

This project aims to be one of the most accessible vim guides available. We made sure to support mobile, desktop, and other languages.

You can read about how to contribute (and help improve) by viewing our README . There you can see how to set up this project, or how to contribute a new language. Here is a big thank you to our contributors!

This project is licensed under The MIT License (MIT) .

More resources

Interactive Vim tutorial: Open Vim

Vim quick reference from Vim help pages: quickref.txt

List of all Vim ex (:) commands: ex-cmd-index

Multiple Teams Account in Windows

I couldn't run 2 Microsoft Teams Account on the same time so I found through reddit a solution:

Rambox (https://rambox.pro/#home)

And lots of other plugins are available (Telegram, Whatsapp, Android Messages)

Virtual Box does not run EXE Files on Shared VM Folders

Change gpedit.msc (see picture) and UAC (Start -> Run -> uac) to never notify