Client/Server support - Unix/Windows

virtualenv in Ubuntu Python 2.7.17

python --version
Python 2.7.17
...
apt install python-pip
...
The following NEW packages will be installed:
  libexpat1-dev libpython-all-dev libpython-dev libpython2.7-dev python-all python-all-dev python-asn1crypto python-cffi-backend python-cryptography python-dbus python-dev
  python-enum34 python-gi python-idna python-ipaddress python-keyring python-keyrings.alt python-pip python-pip-whl python-pkg-resources python-secretstorage
  python-setuptools python-six python-wheel python-xdg python2.7-dev
...
pip install flask
Installing collected packages: itsdangerous, click, Werkzeug, MarkupSafe, Jinja2, flask
Successfully installed Jinja2-2.11.3 MarkupSafe-1.1.1 Werkzeug-1.0.1 click-7.1.2 flask-1.1.4 itsdangerous-1.1.0
..
python -m virtualenv flask
created virtual environment CPython2.7.17.final.0-64 in 520ms
...
root@my-desktop:/home/mydir# python -m virtualenv venv
created virtual environment CPython2.7.17.final.0-64 in 353ms
...

Arduino Nano : Cannot upload code

Quite common that could not upload code to my Arduino Nano. Uno, Mega no problem. So could not be an issue with the USB ports. Tried out different Arduino IDE versions. Different operating systems/versions. Still not possible to upload code. Finally found out that the reason was that upload requires the old bootloader. Most of the Arduino Nano s (at least the ones that I own) do not use the standard bootloader. I saw old bootloaders are required for …

WCH	CH340G AMS1117 5.0 H947MK
Diymore/WCH	CH3400 AMS1117 ATMEL M328 P

Anzeige von Datenbankabfragen

*Eine solche Darstellung ist sehr ärgerlich*

Ich habe eine Datenbank mit ca 200 Abkürzungen (Schwerpunkt Wirtschaft und Gesellschaft Lateinamerikas). Bei einer Abfrage, ich verwende dabei PHP, bekomme ich allerdings keine spanischen Buchstaben angezeigt, deutlich zu sehen beim ñ. Stattdessen kommt das Unicode Ersatzzeichen (U+FFFD) Ein Blick in die Datenbank : Hier ist alles in Ordnung..

Diese Datenbank war zuvor in XOOPS (ein Webportal, etwa mit WordPress vergleichbar) integriert. Hier sind die spanischen Zeichen immer richtig angezeigt worden. Von daher wusste ich dass das Problem nicht etwa an den Einstellungen des MySQL servers liegen konnten (LAMP Installation, MySql  Ver  Distrib 5.7.41 Ubuntu0.18.04.1).
In meine Suche nach einer Lösung probierte ich aus ob ich eine richtige Formatierung nicht etwas über HTML zustande bekommen könnte ... vergebens.
Es war nicht das erste Mal dass dieses Problem erschien ...
Folgende Möglichkeiten gab es zur Behebung :
header('Content-Type: text/html; charset=utf-8');
header('Content-Type: text/html; charset=UTF-8');
header('Content-Type: text/html; charset=iso-8859-1');
Es schien nicht an der Schreibweise des Charsets zu liegen 
(Gross/Kleinschreibung).
Ich bin nicht mehr völlig sicher ob ich die Lösung hier gefunden habe,
jedenfalls wird sie hier erwähnt :
...
$title = mb_convert_encoding($article['title'], "UTF-8", "iso-8859-1");
Sie führte mich zur Lösung (3. Option!):
header('Content-Type: text/html; charset=iso-8859-1');

*Korrekte Anzeige nach Hinzufügen von charset=iso-8859-1*

Raspberry GPIO Expansion board

Took me quite a while to find the name for this adapter : GPIO 40pin Breakout Expansion Board

This photograph shows how the adapter is placed on the breadboard

How the adapter is placed on the Raspberry Pi GPIO s. The black cable is to be found at the angle.

Further information please have a look at … http://wiki.sunfounder.cc/index.php?title=GPIO_40pin_Breakout_Expansion_Board

Ubuntu : PS2 Mouse is not responding

Took me quite a while to find out how to overcome this problem. Because quite weary restarting the PC.
The keyboard was working fine. Just the mouse. Did not want to take a USB Mouse (matter of not compromising ressources).

Could get it fixed opening a terminal window …

sudo modprobe -rv psmouse
sudo modprobe -v psmouse

Reference :
Thread : I can’t get any PS2 mouse working:
http://ubuntuforums.org/showthread.php?t=2178803

HDD enclosures Wavlink ./. Orico. HDD 2,5 ” Recycling

I did already buy some Orico products and have been quite happy with them.

For some reason, when I needed a HDD enclosure for my old HDD (taken out of my broken Lenovo Ideapad S10) I bought a Wavlink enclosure. Maybe because Wavlink was promising that it were working with all SATA types … SATA I/II/III. Orico publishes less information.

Reason for doing this is that I like to reuse the harddisks. Already did have some problems accessing the MicroSD card on my Raspberry and now trying to save data on an external HDD.

I do have a HDD SATA adapter as well, but an enclosure is more beautiful than leaving the HDD with an adapter on the office desk .

However, when the Wavlink enclosure has been shipped, I saw that there was no access to the data. So this enclosure was quite useless.

The solution to this problem was ordering an Orico encloser, which, in fact was working.

PHPMyAdmin is not starting [Raspian (HW Raspi 3) / Latest version 2022]

It s a wonderful world but this world is not perfect.

The PhpMyAdmin installation does not run out of the box (based on Apache, MariaDB, PHP).

PHP installation seems to be fine.

Launching Phpmyadmin nothing happens.

Quite tricky troubleshooting this issue.

The solution I could find here :

https://pimylifeup.com/raspberry-pi-phpmyadmin/

The Apache config file has to be edited …

-rw-r–r– 1 root root 7224 Dec 21 2021 apache2.conf
pi@raspberrypi:/etc/apache2 $ sudo chmod 777 apache2.conf

Basically, the fix is to include the following line in the apache config file …

Include /etc/phpmyadmin/apache.conf

As mentioned on the Pimylifeup website … “This line will include PHPMyAdmin’s configuration and allow it to be loaded in and listened to by Apache.”

-> back to the original permissions

pi@raspberrypi:/etc/apache2 $ sudo chmod 644 apache2.conf

Migration from Outlook 2010 to Thunderbird

My email provider told me that I would not get my mail (POP3) no more, because Outlook does not support the TLS 1.1 version.

So good bye Outlook, hello Thunderbird, but … I still want to have access to all my messages. This is not an easy task.

There are several websites proposing a solution :

How to Transfer Outlook Emails to Thunderbird Easily

https://www.freeviewer.org/blog/import-outlook-mail-to-thunderbird/

But they want me to buy a special application. Not interested in doing that because I got no more than two PST files to convert and then I am done.

I already knew that there is a tool to convert PST files to a mbox format …

It is the libpst Utilities …

https://slackbuilds.org/repository/14.2/libraries/libpst/

“libpst” is a MS Outlook Personal Folders converter. The libpst project includes a library and a set of utilities to decode
and convert MS Outlook PST files. The tool I need is readpst for to convert PST files to mbox and other formats

Further information can be found here :

https://www.kali.org/tools/libpst/

First the utilities have to be installed ..

sudo apt install pst-utils

Then the mailbox conversion has to be performed

$ readpst -u 1.pst

Now that I have converted the data file to the mbox format I was looking for a way to import the file to the Thunderbird application

The decisive hint came from …

Import MBOX to Thunderbird – A Complete Step by Step Guide

For to import to Thunderbird the “ImportExportTools NG” can be used· It is completely free.

(https://www.bitrecover.com/blog/import-mbox-to-thunderbird/ is recommending the Thunderbird import wizard – This is also a software I would have to pay for …).

The setback of this method is when importing the mbox formatted data there are many folders with the foldername mbox created , for instance …

mbox123
mbox147
mbox111
mbox132

etc.

That means … the “ImportExportTools NG” does not keep the namens of the Outlook folders. It puts “mbox” there followed by a number.

After the migration I have to change the name of these folders,there are nearly one hundred folders to be renamed so there is quite a lot of work to be done.

At a certain point I have been worried about where to find the storage place of my mailbox.

That s not hard to find with a right click on the inbox, it appears as …

/home/pi/.thunderbird/togys4ze.default-default/Mail/pop.gmx.net/Inbox.sbd

MS Access : Objekt oder Klasse unterstützt diese Ereignismenge nicht

Beim Öffnen einer Access Datei kommt folgende Fehlermeldung : Sie haben als Einstellung der Ereigniseigenschaft den Ausdruck Bei Laden eingegeben. Dieser Ausdruck hat einen Fehler verursacht: Objekt oder Klasse unterstützt diese Ereignismenge nicht. Diese Fehlermeldung kommt wenn nicht die richtige Access Version installiert ist, etwas MS Access 2013 statt MS Access 2010.