Veröffentlicht am

Embedded MariaDB4j unable to load openssl lib 1.0.0 (Mac OS Catalina)

On my Mac (Mac OS Catalina 10.15.3), after a `brew update & brew upgrade` the openssl lib was updated from 1.0 to 1.1.

Sadly, the embedded MariaDB(j) I‘m using for Java Application UnitTests seems currently not to be compatible with opelssl 1.1.

Caused by: ch.vorburger.exec.ManagedProcessException: Program [/.../MariaDB4j/base/bin/mysql_install_db, ...) failed, exitValue=1, last 100 lines of console:
dyld: Library not loaded: /usr/local/opt/openssl/lib/libssl.1.0.0.dylib
Referenced from: /private/var/folders/ws/b6yxxmzj3hb20lkqndwws27r0000gp/T/MariaDB4j/base/bin/my_print_defaults
Reason: image not found

A similar issue reported here: https://github.com/vorburger/MariaDB4j/issues/48 and more specific in a comment from January 19th https://github.com/vorburger/MariaDB4j/issues/48#issuecomment-573946677

My (temporary) solution was to switch openssl back to lastest 1.0:
$ brew switch openssl 1.0.2t
Cleaning /usr/local/Cellar/openssl/1.0.2t
Opt link created for /usr/local/Cellar/openssl/1.0.2t

Veröffentlicht am

How to fetch field(s) from MySQL query result in bash

In case you want to fetch/export the result of a mysql query into a text file, but you don´t have the option to use the OUTFILE command you can simple use the following bash command:

:~$ mysql -u USER -p PASSWORD -h HOST --silent --skip-column-names -e 'select field1, field2, field3 from table' > query-result.csv

Veröffentlicht am

„//“ prefix in urls anchor hrefs (protocol relative url)

Beginning an url (anchor href/img source/ …) with „//“ is called protocol relative url and is defined within the RFC 3986.

Using this link notation is helpful if your link must (or should)  use the same protocol as the displayed page.

Examples:

  1. User visits http://www.example.com, all links or image resources should be referenced to the same protocol http.
  2. User visits https://www.example.com, all links or image resources should be referenced to the same protocol https.

A protocol relative url is not restricted to the same url – you may use it to link/refer to other urls as well.