Datei in einer windows.wim image ändern

 Um Dateien in einer Datei.wim zu ändern, und zwar nicht im 1. Index sondern 2. öffnet man Powershell (ich habs jetzt im admin Modus gestartet):

Nachdem es gemounted ist, kann mann Dateien und andere Sachen im C:\dism machen.

mkdir c:\dism
dism /Mount-Wim /MountDir:"C:\dism" /wimfile:"d:\windows.wim" /index:2
 

Registry Werte im WIM kann man mit diesen Befehlen ändern:

reg load HKLM\OFFLINE C:\dism\Windows\System32\Config\Software  

Dann kann man mit dem "normalen" regedit unter Computer\HKEY_LOCAL_MACHINE\OFFLINE die Werte ändern die man braucht.

Mit diesem Befehl schließt man die Registry:

reg unload HKLM\OFFLINE

Um die Änderungen im WIM abzuspeichern:

dism /Unmount-Wim /MountDir:"C:\dism" /Commit

Um die Änderungen im WIM zu verwerfen:

dism /Unmount-Wim /MountDir:"C:\dism" /Discard

 

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:

  1. sudo apt-get install libjpeg-turbo-progs
  2. jpegtran logo.jpg > logo_opt.jpg
  3. 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:
  1. Open the Start menu
  2. Click the Settings gear
  3. Click Update & security
  4. 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:
  1. Open the Windows Start Menu and type "Region Settings", then hit enter (screenshot below)
  2. Change the Region Format to one of the known working regions included above and close the dialog.
  3. Run the installer and reboot if prompted.
  4. Change the region setting back to its original language.
  5. 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.

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)

Datei in einer windows.wim image ändern

 Um Dateien in einer Datei.wim zu ändern, und zwar nicht im 1. Index sondern 2. öffnet man Powershell (ich habs jetzt im admin Modus gestart...