bravehartk2

[bravehartk2]

Make an electrical junction box cap

[bravehartk2]

Velociraptor Resonating Chamber Stand

[bravehartk2]

SQL: Query after GUID field

This tiny code snippet demonstrates how to query for GUID fields in SQL by using string values, contrasting it with the MySQL approach.

[bravehartk2]

Find and shorten file and folder names with a certain length

[bravehartk2]

Flush DNS Cache for PowerShell and WSL

When using Windows 10+ in combination with WLS(2) (Window Subsystem for Linux), you probably will stumble over some DNS resolution issues. For example: when you’ve changed the A-record for an IP and  you try to ping or dig the targeted domain. If you still get old IPs there, it could be caused by cached DNS entries. Hence in the standard setup the WSL uses the hosts (Windows) DNS including the…

[bravehartk2]

Shrink PDF

For some applications it is necessary to keep the file size of an PDF under a certain limit. For example for  document uploads on some websites or to maintain the attachment file size limit of some email server. You can use the following shell script to have a schrink command (Source: https://dev.to/manishfoodtechs/shrinking-file-size-of-pdf-using-a-small-bash-script-2pd1). #!/bin/sh shrink…

[bravehartk2]

Memcache Admin

To see what is going on in Memcache: wget http://phpmemcacheadmin.googlecode.com/files/phpMemcachedAdmin-1.2.2-r262.tar.gz tar -xvzf phpMemcachedAdmin-1.2.2-r262.tar.gz chmod +r * chmod 0777 Config/Memcache.php More information: https://code.google.com/p/phpmemcacheadmin/

[bravehartk2]

Zip files in php

<?php $filePath = '/path/to/store/zip/in/'; $zip = new ZipArchive(); $download = "{$filePath}download.zip"; $zip->open($download, ZipArchive::CREATE); foreach (glob($filePath . "*.jpg") as $file) { #add it to the zip $zip->addFile($file); } $zip->close(); header("Pragma: public"); header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Cache-Control:…

[bravehartk2]

Convert latint1 database to UTF-8

$> mysqldump --opt -Q -u USER -p PASSWORT -h HOST DB > dump.sql $> sed -i 's/CHARSET=latin1/CHARSET=utf8 COLLATE=utf8_unicode_ci/g' dump.sql $> sed -i 's/SET NAMES latin1/SET NAMES utf8/g' dump.sql $> mysql -u USER -pPASSWORT --default-character-set=utf8 database < dump.sql

[bravehartk2]

Run Gitlab behind ISPConfig

This little snipped shows how to run and configure Gitlab behind ISPConfig as a proxy including Let's Encrypt for a valid SSL certificate.

Before a while I had the idea to setup my own Gitlab instance to manage my git repositories on my own server. In order to install Gitlab, I ran into a few problems, because I’m already using ISPConfig as administration panel for my root server. Hence I am slightly going to migrate my whole hosting infrastructure to a docker based solution, I wanted Gitlab to run as an independent docker stack…

[bravehartk2]

Override classes and constructor arguments

This tiny snippet shows how to override classes and constructor arguments of overridden classes in Magento2 via dependency injection.

As for Magento 1 it is possible to override classes in Magento 2 as well. Don’t get me wrong. It is not recommended to override classes or methods. It should be the really last resort. Use a plugin or an observer whenever possible. But sometimes the code you’re working against isn’t suitable for one of theses prefered methods. So you have to use a class override. An override can be easily…

[bravehartk2]

Create Symlinks in Windows 10

This short tutorial shows how to create Symlinks in Windows 10 using the standard command prompt (cmd) or the Microsoft PowerShell as well.

Because Windows improved a lot over the recent years, I decided to give it another try. Therefore I installed Windows 10 in addition to my Mint Linux. Yes folks, that really happened 😀 . One of the first “again a beginner” – questions I stumbled upon, was how to create Symlinks in windows 10.  The reason was, that Windows didn’t allow me to use a folder of my Nextcloud mount folder as a source for…

[bravehartk2]

Set static IP on LibreELEC

Set static IP on LibreELEC

Today I stumbled upon the fact that my KODI based media box (Raspberry Pi 4) is still using a dynamic IPv4 address. Hence I want to connect via ssh regularly, I had to set a static IP on LibreElec (former OpenELEC) which my KODI mediacenter is running on.

To achieve that, I had to connect to the Raspberry via SSH and ran the following command.

$> connmanctl config "$(connmanctl services | awk…

[bravehartk2]

Find and reference standard attribute types in Akeneo code

Find and reference standard attribute types in Akeneo code

All standard attribute types available in Akeneo are listed in “\Akeneo\Pim\Structure\Component\AttributeTypes” (File: src/Akeneo/Pim/Structure/Component/AttributeTypes.php).

[bravehartk2]

Unknown Facts About PhenQ Made Known

Unknown Facts About PhenQ Made Known

In a society ruled by junk food and sedentary lifestyle, people often lose track of the figure so becoming unhealthy or heavy.

Precisely the same society yet, glorifies skeletal models and designer clothes and failing to mix into the style, usually alienates individuals. This builds up a urge to shed weight or gain some depending on the type of crowd you need to mix into but attempting to tough…

[bravehartk2]

New Thing on Thingiverse

Recently I realised, that my girlfriend had some FloppyDisk left and wanted to throw them into trash! :-O Hence these awesome relics of computer history reminded me of my childhood and youth, I decided to build something new out of them. To be creative so to say! 😀 As a result I created a few 3D Models to build a desktop FloppyDisk Pen Holder. The Thing is published on Thingiverse. So if you have kept some FloppyDisks too, print it and have fun with your own FloppyDisk Pen Holder.

  Desktop FloppyDisk Pen Holder New Thing on Thingiverse Recently I realised, that my girlfriend had some FloppyDisk left and wanted to throw them into trash!

[bravehartk2]

Create a bcrypt hash on commandline

Create a bcrypt hash on commandline

Its easy to create a bcrypt hash  on commandline with this command:

$> htpasswd -nbBC 10 USER PASSWORD

Just replace the Placeholder USER and PASSWORD with the corresponding values.

The Result should be something like that:

USER:$2y$10$gfPbhclOrdjmMLEXSc5CTOWP5aBfjl59hhGvjp/qWXf1FfbQKb5ca

The part before “:” is the username. The rest is the bcrypt password hash. The -Cparameter specifies the…