MySQL search replace update where sql query
14.Feb.2019

yes, it is NOT the most convenient, query you could imagine. UPDATE `table_name` SET `column_name` = REPLACE(`column_name`, ‚replace_this‘, ‚with_this‘) WHERE `column_name` LIKE ‚%with_this%‘ COLLATE utf8mb4_bin; it is what phpmyadmin generates when you go here:

opening png images on Android phones is not safe anymore
12.Feb.2019

Outlook hacked by receiving an email – fax machine – hacked by receiving a fax – Android SmartPhones hacked by vieweing a picture.png (it’s a bug in the Framework/SDK) – „great“ whats next?Will SmartPhones and „THE INTERNET“ be doomed „unsafe“ […]

Pine64 – Pine Phone Pine Laptop Notebook Free Hardware
08.Feb.2019

https://www.pine64.org/ Low cost Board and a ARM based laptop for below 100USD? NICE! https://www.pine64.org/?post_type=product https://www.phoronix.com/scan.php?page=article&item=pine-64-benchmark https://en.wikipedia.org/wiki/Pine64 Pine Phone Pine Book LOOKS GREAT 🙂 cheap, light, 6h battery 14″ display: https://www.pine64.org/?product=pinebook 11″ display: https://www.pine64.org/?product=11-6-pinebook http://wiki.pine64.org/index.php/1080P_Pinebook_Main_Page OS: can run Debian/Ubuntu http://wiki.pine64.org/index.php/Pinebook_Software_Release#Xenial_Mate_eMMC Benchmarks: […]

self hosted wordpress setup script
07.Feb.2019

WARNING! BACKUP YOUR MACHINE! UNTESTED! before running this script change to your new web root: /home/UserName/web/domain.com/public_html then run it like /scripts/install_wordpress.sh it tries to: download and unpack the latest wordpress into the current directory disable xmlrpc.php disable wp-cron.php requirements: a […]

DSGVO – Verzeichnis von Daten Verarbeitungstätigkeiten OpenOffice LibreOffice Vorlage Muster Template odt
05.Feb.2019

Die OpenOffice/LibreOffice Version: (editierbar) Verzeichnis von Verarbeitungstätigkeiten OpenOffice LibreOffice nach Vorlage LDABayern v1 2019-01.odt PDF-Version: (nicht editierbar) Verzeichnis von Verarbeitungstätigkeiten OpenOffice LibreOffice nach Vorlage LDABayern v1 2019-01.pdf basierend auf: https://www.lda.bayern.de/media/muster_1_verein_verzeichnis.pdf Achtung! Ich biete hier nach bestem Wissen und Gewissen eine […]

remote network mount directory via ssh – sshfs
04.Feb.2019

it is super slow, but for copying small files it works. if /mnt/cifs/here is owned by non-root user, also non-root users are allowed to mount. (which is rather tricky with mount cifs) # setup software apt install sshfs yum install […]

lnav – like less but more colorful output of log files
03.Feb.2019

how to monitor all logs… https://dwaves.org/2017/06/15/linux-monitor-all-logs-in-real-time-d-follow-all-show-changes-to-log-files-under-varlog/ as i was wondering what combination of less -R with or without ccze would allow me to view log files colorful (because a desert of black and white… does not give you a good […]

howto wordpress vestacp increase upload max file size limit
27.Jan.2019

1. check what php.ini is used/loaded 1.1. place vim /home/user/web/domain.com/public_html/info.php with this content: <?php phpinfo(); which will look like this in your browser: MAKE SURE TO REMOVE info.php afterwards! nobody needs to know the details of your webserver. 2. centos7 […]

The Y2038 Problem – cars and embedded systems
23.Jan.2019

in comparison to Y2K: „The issue became when it became 2000 because that would be stored as 00 in the program. This caused many to believe that say, bank software wouldn’t be able to get your money out because it […]

Retro Computing
20.Jan.2019

I gutted a 1975 Zenith Blackstripe television and stuffed a flatscreen monitor into it so I could show off games I made on it (you can see a Lubuntu shutdown screen here). pic.twitter.com/3sGxD6rX6j — Ranibow Sprimkle Baker (@destroyed4com4t) January 20, […]

iphone ipad – change Relocate backup location
12.Jan.2019

On computers with SSD system drives any iOS device backups can take up a significant proportion of the available space. iTunes doesn’t provide a mechanism for choosing where this backup data is stored, but it can be relocated onto another […]

08.Jan.2019

visit via browser: https://ipinfo.io/ or from bash: curl ipinfo.io { „ip“: „123.123.123.123“, „hostname“: „domain.com“, „city“: „City“, „region“: „Region“, „country“: „DE“, „loc“: „49.XXXX,10.XXXX“, „postal“: „12345“, „org“: „Hetzner Online GmbH“

08.Jan.2019

list all jails fail2ban-client status Status |- Number of jail: 1 `- Jail list: sshd get status: /scripts/fail2ban_status.sh echo „===== fail2ban status =====“ JAILS=`fail2ban-client status | grep „Jail list“ | sed -E ’s/^[^:]+:[ \t]+//‘ | sed ’s/,//g’` for JAIL in […]

debian and cups rename printer
08.Jan.2019

if you print from a laptop at home at at office, and it happens you have the same printer model here and there, you might to want to distinguish between them by name. # become root sudo bash # backup […]

HardKernel new Odroid H2 powerfull embedded x86 with dual SATA
03.Jan.2019

… question is, can it run Debian only with free drivers? 😉 2x SATA = RAID1 = GREAT FOR NAS! http://linuxgizmos.com/odroid-h2-is-worlds-first-gemini-lake-hacker-board/ ODROID-H2 Key Features Intel Quad-core processor J4105 (14nm) with 4MiB Cache, up to 2.5Ghz(Single Thread) or 2.3Ghz(Multi Thread) Dual-channel […]