Dietrich Schroff
Dietrich Schroffhttps://plus.google.com/101232877473830670008noreply@blogger.comBlogger425125
Updated: 2 hours 51 min ago
Missing directory in /var/run or /run - tmpfiles.d
Sometimes is happens, that an application/demon refuses to start because of missing files/directories in /var/run.
The first solution is:
Not really.
After the next reboot, the directory is missing again and you have to go for the "first" solution again.
The right solution works like this:
Inside /usr/lib/tmpfiles.d create a myexample.conf file with this content:
The first solution is:
- Create the directory in /var/run
- Change the permissions
Not really.
After the next reboot, the directory is missing again and you have to go for the "first" solution again.
The right solution works like this:
Inside /usr/lib/tmpfiles.d create a myexample.conf file with this content:
d /var/run/myexample 0755 schroff schroff -To check if everything is ok run the following command:
systemd-tmpfiles --create myexample.confand you will see:
# ls -l /var/run/ |grep mxexampleAnd this directory will be created with each reboot...
drwxr-xr-x 2 schroff schroff 40 19. Sep 22:45 myexample
MySQL 8: New Features
After installing mysql 8 on my ubuntu i did a lookaround for the new features. Oracle itself stated:
And if you create your own database each table is stored in its own ibd file and not all in one tablespace file, because innodb_file_per_table is set to 1 as default. With this shrinking tables can be done without a problem...
This is really cool, but how to test this?
A first look inside the standard data directory /var/lib/mysql shows:
/var/lib/mysql# ls -l
insgesamt 168012
-rw-r----- 1 mysql mysql 56 Aug 17 20:53 auto.cnf
-rw-r----- 1 mysql mysql 498 Aug 17 20:53 binlog.000001
-rw-r----- 1 mysql mysql 554 Aug 17 21:07 binlog.000002
-rw-r----- 1 mysql mysql 32 Aug 17 20:54 binlog.index
-rw------- 1 mysql mysql 1676 Aug 17 20:53 ca-key.pem
-rw-r--r-- 1 mysql mysql 1112 Aug 17 20:53 ca.pem
-rw-r--r-- 1 mysql mysql 1112 Aug 17 20:53 client-cert.pem
-rw------- 1 mysql mysql 1680 Aug 17 20:53 client-key.pem
-rw-r----- 1 mysql mysql 4533 Aug 17 20:53 ib_buffer_pool
-rw-r----- 1 mysql mysql 12582912 Aug 17 21:07 ibdata1
-rw-r----- 1 mysql mysql 50331648 Aug 17 21:07 ib_logfile0
-rw-r----- 1 mysql mysql 50331648 Aug 17 20:53 ib_logfile1
-rw-r----- 1 mysql mysql 12582912 Aug 17 20:56 ibtmp1
drwxr-x--- 2 mysql mysql 4096 Aug 17 21:07 mydatabase
drwxr-x--- 2 mysql mysql 4096 Aug 17 20:53 mysql
-rw-r----- 1 mysql mysql 25165824 Aug 17 21:07 mysql.ibd
drwxr-x--- 2 mysql mysql 4096 Aug 17 20:53 performance_schema
-rw------- 1 mysql mysql 1680 Aug 17 20:53 private_key.pem
-rw-r--r-- 1 mysql mysql 452 Aug 17 20:53 public_key.pem
-rw-r--r-- 1 mysql mysql 1112 Aug 17 20:53 server-cert.pem
-rw------- 1 mysql mysql 1680 Aug 17 20:53 server-key.pem
drwxr-x--- 2 mysql mysql 4096 Aug 17 20:53 sys
-rw-r----- 1 mysql mysql 10485760 Aug 17 21:07 undo_001
-rw-r----- 1 mysql mysql 10485760 Aug 17 21:07 undo_002
The sys and the perfomance_schema directories does not contain any frm or ISAM-style files.
The mysql server team shows these pictures on their site (https://mysqlserverteam.com/mysql-8-0-data-dictionary-status-in-the-8-0-0-dmr/)
mysql 8: installation on ubuntu
Today i tried to install mysql 8 on my ubuntu:
First i visited the site https://dev.mysql.com/downloads/repo/apt/ which says:
So i downloaded this file (https://dev.mysql.com/get/mysql-apt-config_0.8.10-1_all.deb) and here we go:
First i visited the site https://dev.mysql.com/downloads/repo/apt/ which says:
# dpkg -i mysql-apt-config_0.8.10-1_all.debwith:
Vormals nicht ausgewähltes Paket mysql-apt-config wird gewählt.
(Lese Datenbank ... 414911 Dateien und Verzeichnisse sind derzeit installiert.)
Vorbereitung zum Entpacken von mysql-apt-config_0.8.10-1_all.deb ...
Entpacken von mysql-apt-config (0.8.10-1) ...
mysql-apt-config (0.8.10-1) wird eingerichtet ...
Warning: apt-key should not be used in scripts (called from postinst maintainerscript of the package mysql-apt-config)
OK
root@zerberus:~/Downloads# apt-get update
OK:1 http://de.archive.ubuntu.com/ubuntu bionic InRelease
Holen:2 http://de.archive.ubuntu.com/ubuntu bionic-updates InRelease [88,7 kB]
Holen:3 http://security.ubuntu.com/ubuntu bionic-security InRelease [83,2 kB]
Holen:4 http://repo.mysql.com/apt/ubuntu bionic InRelease [16,9 kB]
Holen:5 http://de.archive.ubuntu.com/ubuntu bionic-backports InRelease [74,6 kB]
Holen:6 http://de.archive.ubuntu.com/ubuntu bionic-updates/main amd64 Packages [290 kB]
Holen:7 http://repo.mysql.com/apt/ubuntu bionic/mysql-8.0 Sources [898 B]
Holen:8 http://security.ubuntu.com/ubuntu bionic-security/main amd64 Packages [147 kB]
Holen:9 http://de.archive.ubuntu.com/ubuntu bionic-updates/main i386 Packages [262 kB]
Holen:10 http://de.archive.ubuntu.com/ubuntu bionic-updates/main Translation-en [111 kB]
Holen:11 http://repo.mysql.com/apt/ubuntu bionic/mysql-apt-config amd64 Packages [568 B]
Holen:12 http://de.archive.ubuntu.com/ubuntu bionic-updates/main amd64 DEP-11 Metadata [138 kB]
Holen:13 http://de.archive.ubuntu.com/ubuntu bionic-updates/main DEP-11 48x48 Icons [31,4 kB]
Holen:14 http://de.archive.ubuntu.com/ubuntu bionic-updates/main DEP-11 64x64 Icons [53,7 kB]
Holen:15 http://de.archive.ubuntu.com/ubuntu bionic-updates/universe amd64 Packages [161 kB]
Holen:16 http://security.ubuntu.com/ubuntu bionic-security/main i386 Packages [119 kB]
Holen:17 http://de.archive.ubuntu.com/ubuntu bionic-updates/universe i386 Packages [161 kB]
Holen:18 http://security.ubuntu.com/ubuntu bionic-security/main Translation-en [57,4 kB]
Holen:19 http://repo.mysql.com/apt/ubuntu bionic/mysql-apt-config i386 Packages [568 B]
Holen:20 http://de.archive.ubuntu.com/ubuntu bionic-updates/universe Translation-en [73,6 kB]
Holen:21 http://security.ubuntu.com/ubuntu bionic-security/main amd64 DEP-11 Metadata [204 B]
Holen:22 http://security.ubuntu.com/ubuntu bionic-security/universe i386 Packages [50,8 kB]
Holen:23 http://de.archive.ubuntu.com/ubuntu bionic-updates/universe amd64 DEP-11 Metadata [152 kB]
Holen:24 http://security.ubuntu.com/ubuntu bionic-security/universe amd64 Packages [50,9 kB]
Holen:25 http://security.ubuntu.com/ubuntu bionic-security/universe Translation-en [29,4 kB]
Holen:26 http://security.ubuntu.com/ubuntu bionic-security/universe amd64 DEP-11 Metadata [5.792 B]
Holen:27 http://de.archive.ubuntu.com/ubuntu bionic-updates/universe DEP-11 48x48 Icons [153 kB]
Holen:28 http://security.ubuntu.com/ubuntu bionic-security/universe DEP-11 48x48 Icons [6.962 B]
Holen:29 http://security.ubuntu.com/ubuntu bionic-security/multiverse i386 Packages [1.608 B]
Holen:30 http://security.ubuntu.com/ubuntu bionic-security/multiverse amd64 Packages [1.444 B]
Holen:31 http://de.archive.ubuntu.com/ubuntu bionic-updates/universe DEP-11 64x64 Icons [262 kB]
Holen:32 http://repo.mysql.com/apt/ubuntu bionic/mysql-8.0 i386 Packages [7.004 B]
Holen:33 http://de.archive.ubuntu.com/ubuntu bionic-updates/multiverse amd64 Packages [3.772 B]
Holen:34 http://de.archive.ubuntu.com/ubuntu bionic-updates/multiverse i386 Packages [3.928 B]
Holen:35 http://de.archive.ubuntu.com/ubuntu bionic-updates/multiverse amd64 DEP-11 Metadata [2.468 B]
Holen:36 http://de.archive.ubuntu.com/ubuntu bionic-backports/universe amd64 DEP-11 Metadata [5.100 B]
Holen:37 http://repo.mysql.com/apt/ubuntu bionic/mysql-8.0 amd64 Packages [7.002 B]
Holen:38 http://repo.mysql.com/apt/ubuntu bionic/mysql-tools amd64 Packages [2.519 B]
Holen:39 http://repo.mysql.com/apt/ubuntu bionic/mysql-tools i386 Packages [1.882 B]
Es wurden 2.617 kB in 1 s geholt (2.002 kB/s).
Paketlisten werden gelesen... Fertig
root@zerberus:~/Downloads# apt-get install mysql-server
Paketlisten werden gelesen... Fertig
Abhängigkeitsbaum wird aufgebaut.
Statusinformationen werden eingelesen.... Fertig
Die folgenden Pakete wurden automatisch installiert und werden nicht mehr benötigt:
btrfs-tools esound-common gnome-dictionary gnome-icon-theme-symbolic libarmadillo7 libaudiofile1 libboost-date-time1.62.0 libboost-filesystem1.62.0
libboost-iostreams1.62.0 libboost-random1.62.0 libboost-regex1.62.0 libboost-serialization1.62.0 libboost-system1.62.0 libboost-thread1.62.0
libcapnp-0.5.3 libcaribou-gtk-module libcaribou-gtk3-module libdevhelp-3-4 libesd0 libfabric1 libfolks-telepathy25 libgeos-3.5.1 libgit2-24 libgl2ps1
libgl2ps1.4 libgnome-games-support-1-2 libhdf5-openmpi-100 libhttp-parser2.1 libhwloc-plugins libhwloc5 libical2 libiso9660-8 libjsoncpp1
libjsonrpc-glib-1.0-0 liblept5 liblivemedia58 libllvm5.0 liblouis12 liblouisutdml7 liblttng-ust-ctl2 libmirclient-dev libmircommon-dev libmircookie-dev
libmircookie2 libmircore-dev libnetcdf-c++4 libnetcdf11 libntfs-3g872 libopencv-core3.1 libopencv-flann3.1 libopencv-imgproc3.1 libopencv-ml3.1
libopencv-photo3.1 libopencv-shape3.1 libopencv-video3.1 libopencv-viz3.1 libopenmpi2 liborcus-0.12-0 libpoppler68 libprocess-cpp3 libprotobuf-dev
libpsm-infinipath1 libqpdf18 librpm3 librpmbuild3 librpmio3 librpmsign3 libruby2.3 libsodium18 libsrtp0 libsuitesparseconfig4 libtbb2 libtesseract-data
libtesseract3 libunity-api0 libva-drm1 libva-wayland1 libva-x11-1 libva1 libvlccore8 libvpx4 libvtk6.3 libx264-148 libx265-130 libxerces-c3.1
libxkbcommon-dev libzmqpp4 openmpi-bin openmpi-common python-gi python3-libarchive-c python3-libnacl ruby2.3 snapd-login-service
Verwenden Sie »apt autoremove«, um sie zu entfernen.
Die folgenden zusätzlichen Pakete werden installiert:
libmecab2 mecab-ipadic mecab-ipadic-utf8 mecab-utils mysql-client mysql-common mysql-community-client mysql-community-client-core mysql-community-server
mysql-community-server-core
Die folgenden NEUEN Pakete werden installiert:
libmecab2 mecab-ipadic mecab-ipadic-utf8 mecab-utils mysql-client mysql-community-client mysql-community-client-core mysql-community-server
mysql-community-server-core mysql-server
Die folgenden Pakete werden aktualisiert (Upgrade):
mysql-common
1 aktualisiert, 10 neu installiert, 0 zu entfernen und 36 nicht aktualisiert.
Es müssen 54,2 MB an Archiven heruntergeladen werden.
Nach dieser Operation werden 414 MB Plattenplatz zusätzlich benutzt.
Möchten Sie fortfahren? [J/n]
Holen:1 http://de.archive.ubuntu.com/ubuntu bionic/universe amd64 libmecab2 amd64 0.996-5 [257 kB]
Holen:2 http://repo.mysql.com/apt/ubuntu bionic/mysql-8.0 amd64 mysql-common amd64 8.0.12-1ubuntu18.04 [78,6 kB]
Holen:3 http://de.archive.ubuntu.com/ubuntu bionic/universe amd64 mecab-utils amd64 0.996-5 [4.856 B]
Holen:4 http://de.archive.ubuntu.com/ubuntu bionic/universe amd64 mecab-ipadic all 2.7.0-20070801+main-1 [12,1 MB]
Holen:5 http://repo.mysql.com/apt/ubuntu bionic/mysql-8.0 amd64 mysql-community-client-core amd64 8.0.12-1ubuntu18.04 [1.435 kB]
Holen:6 http://de.archive.ubuntu.com/ubuntu bionic/universe amd64 mecab-ipadic-utf8 all 2.7.0-20070801+main-1 [3.522 B]
Holen:7 http://repo.mysql.com/apt/ubuntu bionic/mysql-8.0 amd64 mysql-community-client amd64 8.0.12-1ubuntu18.04 [2.292 kB]
Holen:8 http://repo.mysql.com/apt/ubuntu bionic/mysql-8.0 amd64 mysql-client amd64 8.0.12-1ubuntu18.04 [75,7 kB]
Holen:9 http://repo.mysql.com/apt/ubuntu bionic/mysql-8.0 amd64 mysql-community-server-core amd64 8.0.12-1ubuntu18.04 [16,9 MB]
Holen:10 http://repo.mysql.com/apt/ubuntu bionic/mysql-8.0 amd64 mysql-community-server amd64 8.0.12-1ubuntu18.04 [21,0 MB]
Holen:11 http://repo.mysql.com/apt/ubuntu bionic/mysql-8.0 amd64 mysql-server amd64 8.0.12-1ubuntu18.04 [75,7 kB]
Es wurden 54,2 MB in 10 s geholt (5.396 kB/s).
Vorkonfiguration der Pakete ...
(Lese Datenbank ... 414916 Dateien und Verzeichnisse sind derzeit installiert.)
Vorbereitung zum Entpacken von .../00-mysql-common_8.0.12-1ubuntu18.04_amd64.deb ...
Entpacken von mysql-common (8.0.12-1ubuntu18.04) über (5.8+1.0.4) ...
Vormals nicht ausgewähltes Paket mysql-community-client-core wird gewählt.
Vorbereitung zum Entpacken von .../01-mysql-community-client-core_8.0.12-1ubuntu18.04_amd64.deb ...
Entpacken von mysql-community-client-core (8.0.12-1ubuntu18.04) ...
Vormals nicht ausgewähltes Paket mysql-community-client wird gewählt.
Vorbereitung zum Entpacken von .../02-mysql-community-client_8.0.12-1ubuntu18.04_amd64.deb ...
Entpacken von mysql-community-client (8.0.12-1ubuntu18.04) ...
Vormals nicht ausgewähltes Paket mysql-client wird gewählt.
Vorbereitung zum Entpacken von .../03-mysql-client_8.0.12-1ubuntu18.04_amd64.deb ...
Entpacken von mysql-client (8.0.12-1ubuntu18.04) ...
Vormals nicht ausgewähltes Paket libmecab2:amd64 wird gewählt.
Vorbereitung zum Entpacken von .../04-libmecab2_0.996-5_amd64.deb ...
Entpacken von libmecab2:amd64 (0.996-5) ...
Vormals nicht ausgewähltes Paket mysql-community-server-core wird gewählt.
Vorbereitung zum Entpacken von .../05-mysql-community-server-core_8.0.12-1ubuntu18.04_amd64.deb ...
Entpacken von mysql-community-server-core (8.0.12-1ubuntu18.04) ...
Vormals nicht ausgewähltes Paket mysql-community-server wird gewählt.
Vorbereitung zum Entpacken von .../06-mysql-community-server_8.0.12-1ubuntu18.04_amd64.deb ...
Entpacken von mysql-community-server (8.0.12-1ubuntu18.04) ...
Vormals nicht ausgewähltes Paket mecab-utils wird gewählt.
Vorbereitung zum Entpacken von .../07-mecab-utils_0.996-5_amd64.deb ...
Entpacken von mecab-utils (0.996-5) ...
Vormals nicht ausgewähltes Paket mecab-ipadic wird gewählt.
Vorbereitung zum Entpacken von .../08-mecab-ipadic_2.7.0-20070801+main-1_all.deb ...
Entpacken von mecab-ipadic (2.7.0-20070801+main-1) ...
Vormals nicht ausgewähltes Paket mecab-ipadic-utf8 wird gewählt.
Vorbereitung zum Entpacken von .../09-mecab-ipadic-utf8_2.7.0-20070801+main-1_all.deb ...
Entpacken von mecab-ipadic-utf8 (2.7.0-20070801+main-1) ...
Vormals nicht ausgewähltes Paket mysql-server wird gewählt.
Vorbereitung zum Entpacken von .../10-mysql-server_8.0.12-1ubuntu18.04_amd64.deb ...
Entpacken von mysql-server (8.0.12-1ubuntu18.04) ...
Trigger für ureadahead (0.100.0-20) werden verarbeitet ...
mysql-common (8.0.12-1ubuntu18.04) wird eingerichtet ...
Neue Version der Konfigurationsdatei /etc/mysql/conf.d/mysql.cnf wird installiert ...
Neue Version der Konfigurationsdatei /etc/mysql/my.cnf.fallback wird installiert ...
libmecab2:amd64 (0.996-5) wird eingerichtet ...
mysql-community-client-core (8.0.12-1ubuntu18.04) wird eingerichtet ...
mysql-community-server-core (8.0.12-1ubuntu18.04) wird eingerichtet ...
Trigger für libc-bin (2.27-3ubuntu1) werden verarbeitet ...
Trigger für systemd (237-3ubuntu10.3) werden verarbeitet ...
Trigger für man-db (2.8.3-2) werden verarbeitet ...
mecab-utils (0.996-5) wird eingerichtet ...
mysql-community-client (8.0.12-1ubuntu18.04) wird eingerichtet ...
mecab-ipadic (2.7.0-20070801+main-1) wird eingerichtet ...
Compiling IPA dictionary for Mecab. This takes long time...
reading /usr/share/mecab/dic/ipadic/unk.def ... 40
emitting double-array: 100% |###########################################|
/usr/share/mecab/dic/ipadic/model.def is not found. skipped.
reading /usr/share/mecab/dic/ipadic/Noun.adverbal.csv ... 795
reading /usr/share/mecab/dic/ipadic/Adverb.csv ... 3032
reading /usr/share/mecab/dic/ipadic/Postp.csv ... 146
reading /usr/share/mecab/dic/ipadic/Suffix.csv ... 1393
reading /usr/share/mecab/dic/ipadic/Verb.csv ... 130750
reading /usr/share/mecab/dic/ipadic/Adnominal.csv ... 135
reading /usr/share/mecab/dic/ipadic/Prefix.csv ... 221
reading /usr/share/mecab/dic/ipadic/Noun.demonst.csv ... 120
reading /usr/share/mecab/dic/ipadic/Noun.csv ... 60477
reading /usr/share/mecab/dic/ipadic/Conjunction.csv ... 171
reading /usr/share/mecab/dic/ipadic/Noun.verbal.csv ... 12146
reading /usr/share/mecab/dic/ipadic/Noun.proper.csv ... 27327
reading /usr/share/mecab/dic/ipadic/Others.csv ... 2
reading /usr/share/mecab/dic/ipadic/Filler.csv ... 19
reading /usr/share/mecab/dic/ipadic/Noun.number.csv ... 42
reading /usr/share/mecab/dic/ipadic/Noun.org.csv ... 16668
reading /usr/share/mecab/dic/ipadic/Symbol.csv ... 208
reading /usr/share/mecab/dic/ipadic/Noun.nai.csv ... 42
reading /usr/share/mecab/dic/ipadic/Noun.adjv.csv ... 3328
reading /usr/share/mecab/dic/ipadic/Noun.place.csv ... 72999
reading /usr/share/mecab/dic/ipadic/Interjection.csv ... 252
reading /usr/share/mecab/dic/ipadic/Noun.name.csv ... 34202
reading /usr/share/mecab/dic/ipadic/Postp-col.csv ... 91
reading /usr/share/mecab/dic/ipadic/Noun.others.csv ... 151
reading /usr/share/mecab/dic/ipadic/Adj.csv ... 27210
reading /usr/share/mecab/dic/ipadic/Auxil.csv ... 199
emitting double-array: 100% |###########################################|
reading /usr/share/mecab/dic/ipadic/matrix.def ... 1316x1316
emitting matrix : 100% |###########################################|
done!
update-alternatives: /var/lib/mecab/dic/ipadic wird verwendet, um /var/lib/mecab/dic/debian (mecab-dictionary) im automatischen Modus bereitzustellen
mysql-client (8.0.12-1ubuntu18.04) wird eingerichtet ...
mecab-ipadic-utf8 (2.7.0-20070801+main-1) wird eingerichtet ...
Compiling IPA dictionary for Mecab. This takes long time...
reading /usr/share/mecab/dic/ipadic/unk.def ... 40
emitting double-array: 100% |###########################################|
/usr/share/mecab/dic/ipadic/model.def is not found. skipped.
reading /usr/share/mecab/dic/ipadic/Noun.adverbal.csv ... 795
reading /usr/share/mecab/dic/ipadic/Adverb.csv ... 3032
reading /usr/share/mecab/dic/ipadic/Postp.csv ... 146
reading /usr/share/mecab/dic/ipadic/Suffix.csv ... 1393
reading /usr/share/mecab/dic/ipadic/Verb.csv ... 130750
reading /usr/share/mecab/dic/ipadic/Adnominal.csv ... 135
reading /usr/share/mecab/dic/ipadic/Prefix.csv ... 221
reading /usr/share/mecab/dic/ipadic/Noun.demonst.csv ... 120
reading /usr/share/mecab/dic/ipadic/Noun.csv ... 60477
reading /usr/share/mecab/dic/ipadic/Conjunction.csv ... 171
reading /usr/share/mecab/dic/ipadic/Noun.verbal.csv ... 12146
reading /usr/share/mecab/dic/ipadic/Noun.proper.csv ... 27327
reading /usr/share/mecab/dic/ipadic/Others.csv ... 2
reading /usr/share/mecab/dic/ipadic/Filler.csv ... 19
reading /usr/share/mecab/dic/ipadic/Noun.number.csv ... 42
reading /usr/share/mecab/dic/ipadic/Noun.org.csv ... 16668
reading /usr/share/mecab/dic/ipadic/Symbol.csv ... 208
reading /usr/share/mecab/dic/ipadic/Noun.nai.csv ... 42
reading /usr/share/mecab/dic/ipadic/Noun.adjv.csv ... 3328
reading /usr/share/mecab/dic/ipadic/Noun.place.csv ... 72999
reading /usr/share/mecab/dic/ipadic/Interjection.csv ... 252
reading /usr/share/mecab/dic/ipadic/Noun.name.csv ... 34202
reading /usr/share/mecab/dic/ipadic/Postp-col.csv ... 91
reading /usr/share/mecab/dic/ipadic/Noun.others.csv ... 151
reading /usr/share/mecab/dic/ipadic/Adj.csv ... 27210
reading /usr/share/mecab/dic/ipadic/Auxil.csv ... 199
emitting double-array: 100% |###########################################|
reading /usr/share/mecab/dic/ipadic/matrix.def ... 1316x1316
emitting matrix : 100% |###########################################|
done!
update-alternatives: /var/lib/mecab/dic/ipadic-utf8 wird verwendet, um /var/lib/mecab/dic/debian (mecab-dictionary) im automatischen Modus bereitzustellen
mysql-community-server (8.0.12-1ubuntu18.04) wird eingerichtet ...
update-alternatives: /etc/mysql/mysql.cnf wird verwendet, um /etc/mysql/my.cnf (my.cnf) im automatischen Modus bereitzustellen
Created symlink /etc/systemd/system/multi-user.target.wants/mysql.service → /lib/systemd/system/mysql.service.
mysql-server (8.0.12-1ubuntu18.04) wird eingerichtet ...
Trigger für systemd (237-3ubuntu10.3) werden verarbeitet ...
Trigger für ureadahead (0.100.0-20) werden verarbeitet ...
And everything is ready:
mysql -u root -pmysupersecretpassword
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.12 MySQL Community Server - GPL
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
systemd: systemd-notify not working for non-root-users
Sometimes you have to write your own startup scripts. Recent linux distributions require systemd scripts. This is not really a problem except you have to fulfill the following requirements:
# cat /lib/systemd/system/TEST.service
[Unit]
Description=MyTestSystemdConfiguration
[Service]
User=schroff
Type=notify
ExecStart=/home/schroff/bin/test.sh
NotifyAccess=allThe service startup scripts have to look like this:
$ cat /home/schroff/bin/test.sh
#!/bin/bash
echo Starting serivce
sleep 10
#Starting your services
echo Services started
/bin/systemd-notify --ready
echo Notify done
while test 1 do
sleep 600
done
#keep this scripts running, as long your service runsIn the startup phase you will get the following:
schroff@zerberus:~/bin$ systemctl status TEST.service
● TEST.service - MyTestSystemdConfiguration
Loaded: loaded (/lib/systemd/system/TEST.service; static; vendor preset: enabled)
Active: activating (start) since 19:39:27 CET; 7s ago
Main PID: 17390 (test.sh)
Tasks: 2 (limit: 4915)
Memory: 532.0K::
CPU: 7ms
CGroup: /system.slice/TEST.service
├─17390 /bin/bash /home/schroff/bin/test.sh
└─17395 sleep 10
19:39:27 zerberus systemd[1]: Starting MyTestSystemdConfiguration...
19:39:27 zerberus test.sh[17390]: Starting serivceAnd after the startup phase this is the output (if there were no errors):
schroff@zerberus:~/bin$ systemctl status TEST.service
● TEST.service - MyTestSystemdConfiguration
Loaded: loaded (/lib/systemd/system/TEST.service; static; vendor preset: enabled)
Active: active (running) since 19:38:38 CET; 3s ago
Main PID: 17242 (test.sh)
Tasks: 2 (limit: 4915)
Memory: 932.0K
CPU: 9ms
CGroup: /system.slice/TEST.service
├─17242 /bin/bash /home/schroff/bin/test.sh
└─17259 sleep 600
19:38:28 zerberus systemd[1]: Starting MyTestSystemdConfiguration...
19:38:28 zerberus test.sh[17242]: Starting serivce
19:38:38 zerberus test.sh[17242]: Services started
19:38:38 zerberus systemd[1]: Started MyTestSystemdConfiguration.
19:38:38 zerberus test.sh[17242]: Notify doneBut sometime you will get:
# systemctl restart TEST.service
Job for TEST.service failed because a timeout was exceeded.
See "systemctl status TEST.service" and "journalctl -xe" for details.19:44:46 zerberus systemd[1]: TEST.service: Start operation timed out. Terminating.
19:44:46 zerberus systemd[1]: Failed to start MyTestSystemdConfiguration.
-- Subject: Unit TEST.service has failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit TEST.service has failed.
--
-- The result is failed.
19:44:46 zerberus systemd[1]: TEST.service: Unit entered failed state.
19:44:46 zerberus systemd[1]: TEST.service: Failed with result 'timeout'.
Note that this will happen after 600s (default). You can change this with the parameter (systemd configuration, see manpage systemd.service)
TimeoutSecBut changing this Parameter will not help, because systemd status will never enter the state "active (running)".
The problem is systemd-notify doesn't work, since it lives too short (Redhat Bugzilla).
A workaround is described in that bug entry:
Instead of
systemd-notify --readyuse
python -c "import systemd.daemon, time; systemd.daemon.notify('READY=1'); time.sleep(5)"
- Run the service as a non-root-user
- The service has a startup phase and you want to start the next startup scripts after this startup phase
# cat /lib/systemd/system/TEST.service
[Unit]
Description=MyTestSystemdConfiguration
[Service]
User=schroff
Type=notify
ExecStart=/home/schroff/bin/test.sh
NotifyAccess=allThe service startup scripts have to look like this:
$ cat /home/schroff/bin/test.sh
#!/bin/bash
echo Starting serivce
sleep 10
#Starting your services
echo Services started
/bin/systemd-notify --ready
echo Notify done
while test 1 do
sleep 600
done
#keep this scripts running, as long your service runsIn the startup phase you will get the following:
schroff@zerberus:~/bin$ systemctl status TEST.service
● TEST.service - MyTestSystemdConfiguration
Loaded: loaded (/lib/systemd/system/TEST.service; static; vendor preset: enabled)
Active: activating (start) since 19:39:27 CET; 7s ago
Main PID: 17390 (test.sh)
Tasks: 2 (limit: 4915)
Memory: 532.0K::
CPU: 7ms
CGroup: /system.slice/TEST.service
├─17390 /bin/bash /home/schroff/bin/test.sh
└─17395 sleep 10
19:39:27 zerberus systemd[1]: Starting MyTestSystemdConfiguration...
19:39:27 zerberus test.sh[17390]: Starting serivceAnd after the startup phase this is the output (if there were no errors):
schroff@zerberus:~/bin$ systemctl status TEST.service
● TEST.service - MyTestSystemdConfiguration
Loaded: loaded (/lib/systemd/system/TEST.service; static; vendor preset: enabled)
Active: active (running) since 19:38:38 CET; 3s ago
Main PID: 17242 (test.sh)
Tasks: 2 (limit: 4915)
Memory: 932.0K
CPU: 9ms
CGroup: /system.slice/TEST.service
├─17242 /bin/bash /home/schroff/bin/test.sh
└─17259 sleep 600
19:38:28 zerberus systemd[1]: Starting MyTestSystemdConfiguration...
19:38:28 zerberus test.sh[17242]: Starting serivce
19:38:38 zerberus test.sh[17242]: Services started
19:38:38 zerberus systemd[1]: Started MyTestSystemdConfiguration.
19:38:38 zerberus test.sh[17242]: Notify doneBut sometime you will get:
# systemctl restart TEST.service
Job for TEST.service failed because a timeout was exceeded.
See "systemctl status TEST.service" and "journalctl -xe" for details.19:44:46 zerberus systemd[1]: TEST.service: Start operation timed out. Terminating.
19:44:46 zerberus systemd[1]: Failed to start MyTestSystemdConfiguration.
-- Subject: Unit TEST.service has failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit TEST.service has failed.
--
-- The result is failed.
19:44:46 zerberus systemd[1]: TEST.service: Unit entered failed state.
19:44:46 zerberus systemd[1]: TEST.service: Failed with result 'timeout'.
Note that this will happen after 600s (default). You can change this with the parameter (systemd configuration, see manpage systemd.service)
TimeoutSecBut changing this Parameter will not help, because systemd status will never enter the state "active (running)".
The problem is systemd-notify doesn't work, since it lives too short (Redhat Bugzilla).
A workaround is described in that bug entry:
Instead of
systemd-notify --readyuse
python -c "import systemd.daemon, time; systemd.daemon.notify('READY=1'); time.sleep(5)"
Oracle SOA Suite 12c : Audit Levels (Off, Production, Development)
Inside the Enterprise Manager (URL: http://yourhost:7001/em) you can configure SOA Suite Audit Levels:
Click on "Change Profile"
The oracle documentation shows the following:
Choose "Common Properties"
- Off:
No business flow instance tracking and payload tracking information is collected. Drilling down into a flow shows the components and their status. Using this setting limits database growth, and also helps reduce latency and improve throughput.
- Production:
Flow and audit event information is collected and stored in the database. Drilling down into a flow provides the flow trace. The flow trace shows the exact sequence of component interaction, and also shows component statuses. Drilling down into a BPEL instance shows the execution of BPEL activities, and their statuses.
As the flow-trace audit trail may not be required for all composites, you may want to set the audit level to Off at the SOA Infrastructure level, and set the audit level to Production for the required composites
- Development:
This option collects payload details in addition to flow and audit events. This setting is not recommended for a production environment, as it will impact performance and result in rapid database growth. This level is useful largely for testing and debugging purposes only.
Ubuntu / Linux: WLAN connections fails with "denied authentication (status 17)"
During holidays i was not able to connect my laptop to the WLAN.
The /var/log/syslog showed the following:
The /var/log/syslog showed the following:
Jul 15 13:45:20 pc wpa_supplicant[935]: wlp3s0: SME: Trying to authenticate with 14:9d:09:fe:a4:b3 (SSID='HUAWEI BTV' freq=2437 MHz)
Jul 15 13:45:20 pc kernel: [ 6972.826888] wlp3s0: authenticate with 14:9d:09:fe:a4:b3
Jul 15 13:45:20 pc NetworkManager[797]: [1531655120.4746] device (wlp3s0): supplicant interface state: disconnected -> authenticating
Jul 15 13:45:20 pc kernel: [ 6972.829942] wlp3s0: send auth to 14:9d:09:fe:a4:b3 (try 1/3)
Jul 15 13:45:20 pc kernel: [ 6972.833433] wlp3s0: 14:9d:09:fe:a4:b3 denied authentication (status 17)
Jul 15 13:45:20 pc wpa_supplicant[935]: wlp3s0: CTRL-EVENT-SSID-TEMP-DISABLED id=0 ssid="HUAWEI BTV" auth_failures=1 duration=10 reason=CONN_FAILED
Jul 15 13:45:20 pc NetworkManager[797]: [1531655120.5031] device (wlp3s0): supplicant interface state: authenticating -> disconnected
Jul 15 13:45:20 pc org.freedesktop.Notifications[1248]: ** (notify-osd:1448): WARNING **: dnd_is_idle_inhibited(): got error "The name org.gnome.SessionManager was not provided by any .service files"
Hmmm.
STATUS 17What the hell does this error code tell me?
The explanation was quite easy: The WLAN was provided by a tablet via tethering. And Android limits the number of devices in such a WLAN to 5.
After removing one of the other devices everything worked fine...
STATUS 17What the hell does this error code tell me?
The explanation was quite easy: The WLAN was provided by a tablet via tethering. And Android limits the number of devices in such a WLAN to 5.
After removing one of the other devices everything worked fine...
Where to find the oracle-database-ee-18c-1.0-1.x86_64.rpm package?
After writing about the release of Oracle database 18c i wanted to download
oracle-database-ee-18c-1.0-1.x86_64.rpmto try the rpm-based installation.
But this rpm is not included in
LINUX.X64_180000_db_home.zipThe oracle documentation shows:
But on OTN and Delivery Cloud only the zipfile without the rpm can be downloaded...
So let's see, when the download pages are updated...
oracle-database-ee-18c-1.0-1.x86_64.rpmto try the rpm-based installation.
But this rpm is not included in
LINUX.X64_180000_db_home.zipThe oracle documentation shows:
So let's see, when the download pages are updated...
Oracle Weblogic 12c: Extracting the complete configuration via wlst.sh python script
If you want to get all information out of a weblogic server via wlst.sh than you can use the following script:
The output file would look like this:
domainRuntime
###############################################
1 /
1 -r-- ActivationTime Fri Feb 23 13:03:05 EST 2018
1 -r-- MigrationDataRuntimes null
1 -r-- Name ovm_domain
1 -rw- Parent null
1 -r-- ServiceMigrationDataRuntimes null
1 -r-- Type DomainRuntime
1 -r-x preDeregister Void :
1 -r-x restartSystemResource Void : WebLogicMBean(weblogic.management.configuration.SystemResourceMBean)
2 AppRuntimeStateRuntime
2 drw- AppRuntimeStateRuntime
3 AppRuntimeStateRuntime
3 -r-- ApplicationIds java.lang.String[oracle.sdp.client#2.0@12.1.3, oracle.pwdgen#2.0@12.1.3, owasp.esapi#2.0@12.1.3, oracle.wsm.seedpolicies#2.0@12.1.3, odl.clickhistory#1.0@12.1.3, odl.clickhistory.webapp#1.0@12.1.3, oracle.jrf.system.filter, oracle.jsp.next#12.1.3@12.1.3, oracle.dconfig-infra#2.0@12.1.3, orai18n-adf#11@11.1.1.1.0, oracle.adf.dconfigbeans#1.0@12.1.3.0.0, adf.oracle.domain#1.0@12.1.3.0.0, adf.oracle.businesseditor#1.0@12.1.3.0.0, oracle.adf.management#1.0@12.1.3.0.0, adf.oracle.domain.webapp#1.0@12.1.3.0.0, jsf#2.1@2.1.7-01-, jstl#1.2@1.2.0.1, UIX#11@12.1.3.0.0, ohw-rcf#5@12.1.3.0.0, ohw-uix#5@12.1.3.0.0, oracle.adf.desktopintegration.model#1.0@12.1.3.0.0, oracle.adf.desktopintegration#1.0@12.1.3.0.0, oracle.bi.jbips#11.1.1@0.1, oracle.bi.composer#11.1.1@0.1, oracle.bi.adf.model.slib#1.0@12.1.3.0.0, oracle.bi.adf.view.slib#1.0@12.1.3.0.0, oracle.bi.adf.webcenter.slib#1.0@12.1.3.0.0, state-management-provider-memory-rar-12.1.3, wsil-wls#12.1.3.0.0, DMS Application#12.1.3.0.0, coherence-transaction-rar, ovm_core, ovm_console, ovm_help]
3 -r-- Name AppRuntimeStateRuntime
3 -r-- Type AppRuntimeStateRuntime
3 -r-x getCurrentState String : String(appid),String(moduleid),String(subModuleId),String(target)
3 -r-x getCurrentState String : String(appid),String(moduleid),String(target)
[.....]
4 JVMRuntime
4 drw- AdminServer
5 AdminServer
5 -r-- HeapFreeCurrent 447991664
5 -r-- HeapFreePercent 90
5 -r-- HeapSizeCurrent 841109504
5 -r-- HeapSizeMax 4151836672
5 -r-- JavaVMVendor Oracle Corporation
5 -r-- JavaVendor Oracle Corporation
5 -r-- JavaVersion 1.7.0_151
5 -r-- Name AdminServer
5 -r-- OSName Linux
5 -r-- OSVersion 4.1.12-94.3.9.el7uek.x86_64
5 -r-- Type JVMRuntime
5 -r-- Uptime 22612965
5 -r-x preDeregister Void :
# written by Dietrich Schroff 2018This is a recursiv program which steps into all directories until a level of 5. On my weblogic server this scripts ran for more than two minutes:
import sys
OutputFile='myfile.txt'
sys.stdout = open(OutputFile,'w')
connect('weblogic','mypasswd','t3://localhost:7001')
depth=0
def loopOverAllSubdirectories(goIntoThisDirectory,depth):
depth=depth+1
cd(goIntoThisDirectory)
print depth," "*depth*2,goIntoThisDirectory
try:
completeInput=ls()
inputArray=completeInput.split('\n')
allParameters=[ x for x in inputArray if (not ("dr--" in x) or ("drw-" in x)) ]
for Parameter in allParameters:
if Parameter != "" :
print depth," "*depth*2,Parameter
allDirectoriesWrongFormat=[ x for x in inputArray if (("dr--" in x) or ("drw-" in x)) ]
allDirectoriesWrongFormat2=[x.replace('dr--', '') for x in allDirectoriesWrongFormat]
allDirectoriesToManyBlanks=[x.replace('drw-', '') for x in allDirectoriesWrongFormat2]
allDirectories=[x.lstrip().rstrip() for x in allDirectoriesToManyBlanks]
for Directory in allDirectories:
if depth < 5 :
loopOverAllSubdirectories(Directory,depth)
cd('..')
except:
cd('..')
domainRuntime()
print "domainRuntime"
print "###############################################"
loopOverAllSubdirectories('/',0)
serverConfig()
print "ServerConfig"
print "###############################################"
loopOverAllSubdirectories('/',0)
# time ./wlst.sh myScript.py > /dev/nullI tried unlimited depth, but then i had to stop at level 1500, because i think, that it will never stop ;-).
real 2m35.241s
user 0m29.405s
sys 0m4.259s
The output file would look like this:
domainRuntime
###############################################
1 /
1 -r-- ActivationTime Fri Feb 23 13:03:05 EST 2018
1 -r-- MigrationDataRuntimes null
1 -r-- Name ovm_domain
1 -rw- Parent null
1 -r-- ServiceMigrationDataRuntimes null
1 -r-- Type DomainRuntime
1 -r-x preDeregister Void :
1 -r-x restartSystemResource Void : WebLogicMBean(weblogic.management.configuration.SystemResourceMBean)
2 AppRuntimeStateRuntime
2 drw- AppRuntimeStateRuntime
3 AppRuntimeStateRuntime
3 -r-- ApplicationIds java.lang.String[oracle.sdp.client#2.0@12.1.3, oracle.pwdgen#2.0@12.1.3, owasp.esapi#2.0@12.1.3, oracle.wsm.seedpolicies#2.0@12.1.3, odl.clickhistory#1.0@12.1.3, odl.clickhistory.webapp#1.0@12.1.3, oracle.jrf.system.filter, oracle.jsp.next#12.1.3@12.1.3, oracle.dconfig-infra#2.0@12.1.3, orai18n-adf#11@11.1.1.1.0, oracle.adf.dconfigbeans#1.0@12.1.3.0.0, adf.oracle.domain#1.0@12.1.3.0.0, adf.oracle.businesseditor#1.0@12.1.3.0.0, oracle.adf.management#1.0@12.1.3.0.0, adf.oracle.domain.webapp#1.0@12.1.3.0.0, jsf#2.1@2.1.7-01-, jstl#1.2@1.2.0.1, UIX#11@12.1.3.0.0, ohw-rcf#5@12.1.3.0.0, ohw-uix#5@12.1.3.0.0, oracle.adf.desktopintegration.model#1.0@12.1.3.0.0, oracle.adf.desktopintegration#1.0@12.1.3.0.0, oracle.bi.jbips#11.1.1@0.1, oracle.bi.composer#11.1.1@0.1, oracle.bi.adf.model.slib#1.0@12.1.3.0.0, oracle.bi.adf.view.slib#1.0@12.1.3.0.0, oracle.bi.adf.webcenter.slib#1.0@12.1.3.0.0, state-management-provider-memory-rar-12.1.3, wsil-wls#12.1.3.0.0, DMS Application#12.1.3.0.0, coherence-transaction-rar, ovm_core, ovm_console, ovm_help]
3 -r-- Name AppRuntimeStateRuntime
3 -r-- Type AppRuntimeStateRuntime
3 -r-x getCurrentState String : String(appid),String(moduleid),String(subModuleId),String(target)
3 -r-x getCurrentState String : String(appid),String(moduleid),String(target)
[.....]
4 JVMRuntime
4 drw- AdminServer
5 AdminServer
5 -r-- HeapFreeCurrent 447991664
5 -r-- HeapFreePercent 90
5 -r-- HeapSizeCurrent 841109504
5 -r-- HeapSizeMax 4151836672
5 -r-- JavaVMVendor Oracle Corporation
5 -r-- JavaVendor Oracle Corporation
5 -r-- JavaVersion 1.7.0_151
5 -r-- Name AdminServer
5 -r-- OSName Linux
5 -r-- OSVersion 4.1.12-94.3.9.el7uek.x86_64
5 -r-- Type JVMRuntime
5 -r-- Uptime 22612965
5 -r-x preDeregister Void :
# wc -l myfile.txtNearly 20.000 parameters... not bad...
19787 myfile.txt
Oracle 18c database is released for Linux (on premise)
After my posting nearly a week ago about the published 18c documentation on monday the binaries for Oracle 18c database were released:
and
Here the link to the download page: oracle.com
In one of the next postings i will try a rpm installation...
and
Here the link to the download page: oracle.com
In one of the next postings i will try a rpm installation...
Oracle Database 18c: Documentation released!
Today i surfed to docs.oracle.com and there i found the documentation for oracle database 18c:
In march 2018 i wrote about the new installation procedure of oracle database 18c via rpm, which was announced inside the "new features".
The installation guide for Linux contains now the commands for installing the database via rpm. Here a screencopy of chapter 11:
Oracle DBCA creates the Oracle Database listener, the Oracle Database instance, starts the instance, and completes the Oracle Database creation process. Review the status information that is displayed on your screen.
Here the link to docs.oracle.com chapter 11 "Running RPM Packages to Install Oracle Database".
In march 2018 i wrote about the new installation procedure of oracle database 18c via rpm, which was announced inside the "new features".
The installation guide for Linux contains now the commands for installing the database via rpm. Here a screencopy of chapter 11:
rpm -ivh oracle-ee-db-18.1.0.0.0-1.x86_64.rpmThis command creates the Oracle home at the location
/opt/oracle/product/18.0.0.0.0-1/dbhome_1.Cool!
The next step is to run the dbca:
7 The screen displays information that prompts you to create a database by using Oracle Database Configuration Assistant (Oracle DBCA) in silent mode.
[...]
8 Log in as the
[...]oracle user and run Oracle DBCA in silent mode to create the database.Oracle DBCA creates the Oracle Database listener, the Oracle Database instance, starts the instance, and completes the Oracle Database creation process. Review the status information that is displayed on your screen.
Here the link to docs.oracle.com chapter 11 "Running RPM Packages to Install Oracle Database".
Oracle SOA Suite: Profiles (SOA Foundation, BPEL only, Orchestration, Enterprise, BPM Classic, ...)
Inside the Enterprise Manager (URL: http://yourhost:7001/em) you can configure SOA Suite profiles:
Click on "Change Profile"
The oracle documentation shows the following:
The full set of adapters:
Choose "Common Properties"
The full set of adapters:
- file,
- FTP,
- database,
- JMS,
- MQSeries,
- AQ,
- E-Business Suite,
- User Messaging Service,
- socket,
- LDAP,
- Coherence,
- MSMQ,
- JDE
- file,
- FTP,
- database,
- JMS,
- MQSeries,
- AQ,
- E-Business Suite,
- User Messaging Service
Docker: Networking with docker swarm: creating new subnets/gateways/...
In this posting i explained how to configure the network for a container on a docker machine.
If you want to do this for a docker swarm, you have to change the commands. The network driver "bridge" does not work in swarm mode:
(How to run a container inside a swarm take a look here)
You have to configure an overlay network:
Verification:
and after stopping the service (docker service rm helloworld) the overlay "myoverlay" is removed again:
If you want to do this for a docker swarm, you have to change the commands. The network driver "bridge" does not work in swarm mode:
(How to run a container inside a swarm take a look here)
docker service create --network mybrigde --name helloworld alpine ping 192.168.178.1Even if you create your bridge on every node.
Error: No such network: mybrigde
You have to configure an overlay network:
alpine:~# docker service create --network myoverlay --name helloworld alpine ping 192.168.178.1And then you can deploy your service like this:
alpine:~# docker service create --replicas 2 --network myoverlay --name helloworld alpine ping 10.200.0.1
ij613sb26sfrgqknq8nnscqeg
overall progress: 2 out of 2 tasks
1/2: running [==================================================>]
2/2: running [==================================================>]
verify: Service converged
Verification:
alpine:~# docker psOn each docker swarm node you can find now:
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
6193ebb361fa alpine:latest "ping 10.200.0.1" 12 seconds ago Up 11 seconds helloworld.1.9zoyocdpsdthuqmlk4efk96wz
alpine:~# docker logs 6193ebb361fa
PING 10.200.0.1 (10.200.0.1): 56 data bytes
64 bytes from 10.200.0.1: seq=0 ttl=64 time=0.344 ms
64 bytes from 10.200.0.1: seq=1 ttl=64 time=0.205 ms
64 bytes from 10.200.0.1: seq=2 ttl=64 time=0.184 ms
node2:~# docker network ls
NETWORK ID NAME DRIVER SCOPE
5019841c7e25 bridge bridge local
6e795c964251 docker_gwbridge bridge local
9d9fa338a975 host host local
273dc1ddbc57 mybrigde bridge local
siiyo60iaojs myoverlay overlay swarm
9ff819cf7ddb none null local
and after stopping the service (docker service rm helloworld) the overlay "myoverlay" is removed again:
node2:~# docker network ls
NETWORK ID NAME DRIVER SCOPE
5019841c7e25 bridge bridge local
6e795c964251 docker_gwbridge bridge local
9d9fa338a975 host host local
273dc1ddbc57 mybrigde bridge local
9ff819cf7ddb none null local
Oracle Database Software Downloads: 18c released
Ok - not the database binaries but the Oracle Database 18c Release 1 Client is released:
Only for windows and linux - not really suprising, but that shows, which platforms are well supported ;-)
The documentation can be found here.
The documentation is for solaris, too - but without binaries this sounds a little bit strange:
The documentation can be found here.
The documentation is for solaris, too - but without binaries this sounds a little bit strange:
Docker: Network configuration: How to customize the network bridge and use my own subnet / netmask / CiDR
In my last posting i described how to configure the network settings of a container via docker command line:
--net none
--net bridgeNow i want to try to change the subnet from the standard 172.17.0.0/16 to another ip range.
There are some tutorials out there which say:
First you have to create new network:
and narrowing the IP range can be done like this:
If you are not familiar with the CIDR notation, just us this nice online tool (http://www.subnet-calculator.com/cidr.php):
--net none
--net bridgeNow i want to try to change the subnet from the standard 172.17.0.0/16 to another ip range.
There are some tutorials out there which say:
docker run -it --net bridge --fixed-cidr "10.100.0.0/24" alpine /bin/ashbut this doesa not work any more.
unknown flag: --fixed-cidr
First you have to create new network:
docker network create --driver=bridge --subnet=10.100.0.0/24 --gateway=10.100.0.1 mybrigdeJust do a verification:
6249c9a5f6c6f7e36e7e61009b9bde7ac338173d8e222e214a65b9793d36ad6c
docker network lsand here we go:
NETWORK ID NAME DRIVER SCOPE
a00386e6a5bc bridge bridge local
9365e4a966d0 docker_gwbridge bridge local
9d9fa338a975 host host local
6249c9a5f6c6 mybrigde bridge local
9ff819cf7ddb none null local
alpine:~# docker run -it --network mybrigde alpine /bin/ashRemoving the network bridge is easy:
/ # ifconfig
eth0 Link encap:Ethernet HWaddr 02:42:0A:64:00:02
inet addr:10.100.0.2 Bcast:0.0.0.0 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:14 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:1156 (1.1 KiB) TX bytes:0 (0.0 B)
lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
UP LOOPBACK RUNNING MTU:65536 Metric:1
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1
RX bytes:0 (0.0 B) TX bytes:0 (0.0 B)
docker network rm mybrigde
and narrowing the IP range can be done like this:
alpine:~# docker network create --driver=bridge --subnet=10.100.0.0/24 --ip-range=10.100.0.128/25 --gateway=10.100.0.1 mybrigdeJust do a check:
b0ba1d963a6ca3097d083d4f5fd979e0fb0f91f81f1279132ae773c06f821396
alpine:~# docker run -it --network mybrigde alpine /bin/ashThe ip address of the container is set to 10.100.0.128 as configured with --ip-range 10.100.0.128/25.
/ # ifconfig
eth0 Link encap:Ethernet HWaddr 02:42:0A:64:00:80
inet addr:10.100.0.128 Bcast:0.0.0.0 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:12 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:1016 (1016.0 B) TX bytes:0 (0.0 B)
lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
UP LOOPBACK RUNNING MTU:65536 Metric:1
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1
RX bytes:0 (0.0 B) TX bytes:0 (0.0 B)
If you are not familiar with the CIDR notation, just us this nice online tool (http://www.subnet-calculator.com/cidr.php):
Ubuntu 16.04: Installation of chrome-browser fails with libnss3 (>= 2:3.22) [2]
dpkg: Abhängigkeitsprobleme verhindern Konfiguration von google-chrome-stable:But now i know, what the problem was:
google-chrome-stable hängt ab von libnss3 (>= 2:3.22); aber:
Version von libnss3:amd64 auf dem System ist 2:3.21-1ubuntu4.
dpkg: Fehler beim Bearbeiten des Paketes google-chrome-stable (--install):
Abhängigkeitsprobleme - verbleibt unkonfiguriert
Inside /etc/apt/sources.list the entry:
deb http://security.ubuntu.com/ubuntu/ xenial-security restricted main multiverse universewas missing. After adding this line i was able to install the libnss3 2.3.22:
# apt-get install libnss3
Paketlisten werden gelesen... Fertig
Abhängigkeitsbaum wird aufgebaut.
Statusinformationen werden eingelesen.... Fertig
Die folgenden Pakete wurden automatisch installiert und werden nicht mehr benötigt:
libappindicator1 libcurl3 libdbusmenu-gtk4 libindicator7
Verwenden Sie »sudo apt autoremove«, um sie zu entfernen.
Die folgenden zusätzlichen Pakete werden Installiert
libnspr4 libnss3-nssdb
Die folgenden Pakete werden aktualisiert (Upgrade):
libnspr4 libnss3 libnss3-nssdb
3 aktualisiert, 0 neu installiert, 0 zu entfernen und 490 nicht aktualisiert.
Es müssen 1.270 kB an Archiven heruntergeladen werden.
Nach dieser Operation werden 31,7 kB Plattenplatz zusätzlich benutzt.
Möchten Sie fortfahren? [J/n]
Holen:1 http://security.ubuntu.com/ubuntu xenial-security/main amd64 libnspr4 amd64 2:4.13.1-0ubuntu0.16.04.1 [112 kB]
Holen:2 http://security.ubuntu.com/ubuntu xenial-security/main amd64 libnss3-nssdb all 2:3.28.4-0ubuntu0.16.04.3 [10,6 kB]
Holen:3 http://security.ubuntu.com/ubuntu xenial-security/main amd64 libnss3 amd64 2:3.28.4-0ubuntu0.16.04.3 [1.148 kB]
Es wurden 1.270 kB in 1 s geholt (737 kB/s).
(Lese Datenbank ... 140220 Dateien und Verzeichnisse sind derzeit installiert.)
Vorbereitung zum Entpacken von .../libnspr4_2%3a4.13.1-0ubuntu0.16.04.1_amd64.deb ...
Entpacken von libnspr4:amd64 (2:4.13.1-0ubuntu0.16.04.1) über (2:4.11-1ubuntu1) ...
Vorbereitung zum Entpacken von .../libnss3-nssdb_2%3a3.28.4-0ubuntu0.16.04.3_all.deb ...
Entpacken von libnss3-nssdb (2:3.28.4-0ubuntu0.16.04.3) über (2:3.21-1ubuntu4) ...
Vorbereitung zum Entpacken von .../libnss3_2%3a3.28.4-0ubuntu0.16.04.3_amd64.deb ...
Entpacken von libnss3:amd64 (2:3.28.4-0ubuntu0.16.04.3) über (2:3.21-1ubuntu4) ...
libnspr4:amd64 (2:4.13.1-0ubuntu0.16.04.1) wird eingerichtet ...
libnss3-nssdb (2:3.28.4-0ubuntu0.16.04.3) wird eingerichtet ...
libnss3:amd64 (2:3.28.4-0ubuntu0.16.04.3) wird eingerichtet ...
Trigger für libc-bin (2.23-0ubuntu3) werden verarbeitet ...After this, google-chrome installed without any problem:
root@estherpc:~/Downloads# dpkg -i google-chrome-stable_current_amd64\ \(2\).deb
Vormals nicht ausgewähltes Paket google-chrome-stable wird gewählt.
(Lese Datenbank ... 140222 Dateien und Verzeichnisse sind derzeit installiert.)
Vorbereitung zum Entpacken von google-chrome-stable_current_amd64 (2).deb ...
Entpacken von google-chrome-stable (64.0.3282.186-1) ...
google-chrome-stable (64.0.3282.186-1) wird eingerichtet ...
update-alternatives: /usr/bin/google-chrome-stable wird verwendet, um /usr/bin/x-www-browser (x-www-browser) im automatischen Modus bereitzustellen
update-alternatives: /usr/bin/google-chrome-stable wird verwendet, um /usr/bin/gnome-www-browser (gnome-www-browser) im automatischen Modus bereitzustellen
update-alternatives: /usr/bin/google-chrome-stable wird verwendet, um /usr/bin/google-chrome (google-chrome) im automatischen Modus bereitzustellen
Trigger für bamfdaemon (0.5.3~bzr0+16.04.20160415-0ubuntu1) werden verarbeitet ...
Rebuilding /usr/share/applications/bamf-2.index...
Trigger für gnome-menus (3.13.3-6ubuntu3) werden verarbeitet ...
Trigger für desktop-file-utils (0.22-1ubuntu5) werden verarbeitet ...
Trigger für mime-support (3.59ubuntu1) werden verarbeitet ...
Trigger für man-db (2.7.5-1) werden verarbeitet ...
Docker: Network configuration - none / brigde / hostname / dns entries
If you are starting your docker container you can add some network configuration details via command line.
Let's start with the easiest network setting:
Let's start with the easiest network setting:
docker run -it --net none alpine /bin/ashThis setting starts the container without any connectivity to the network:
# ip addr showThe default is --net bridge:
1: lo: mtu 65536 qdisc noqueue state UNKNOWN qlen 1
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
docker run -it --net bridge alpine /bin/ashWith this setting your network access is via a bridge of your host:
# ip addr showThis is the docker0 interface on your docker server machine:
1: lo: mtu 65536 qdisc noqueue state UNKNOWN qlen 1
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
7: eth0@if8: mtu 1500 qdisc noqueue state UP
link/ether 02:42:ac:11:00:02 brd ff:ff:ff:ff:ff:ff
inet 172.17.0.2/16 scope global eth0
valid_lft forever preferred_lft forever
alpine:~# ip addr showFinally you can configure your hostname and manipulate dns entries:
1: lo: mtu 65536 qdisc noqueue state UNKNOWN qlen 1
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: eth0: mtu 1500 qdisc pfifo_fast state UP qlen 1000
link/ether 08:00:27:72:ae:ef brd ff:ff:ff:ff:ff:ff
inet 192.168.178.46/24 brd 192.168.178.255 scope global eth0
valid_lft forever preferred_lft forever
inet6 fe80::a00:27ff:fe72:aeef/64 scope link
valid_lft forever preferred_lft forever
3: docker0: mtu 1500 qdisc noqueue state DOWN
link/ether 02:42:ba:e9:4d:6a brd ff:ff:ff:ff:ff:ff
inet 172.17.0.1/16 scope global docker0
valid_lft forever preferred_lft forever
inet6 fe80::42:baff:fee9:4d6a/64 scope link
valid_lft forever preferred_lft forever
4: docker_gwbridge: mtu 1500 qdisc noqueue state DOWN
link/ether 02:42:62:f0:92:82 brd ff:ff:ff:ff:ff:ff
inet 172.18.0.1/16 scope global docker_gwbridge
valid_lft forever preferred_lft forever
# docker run -it --net bridge --hostname myhostname --add-host mygoogle.com:8.8.8.8 alpine /bin/ash
/ # hostname
myhostname
/ # nslookup mygoogle.com
nslookup: can't resolve '(null)': Name does not resolve
Name: mygoogle.com
Address 1: 8.8.8.8 mygoogle.com
Docker: How to limit memory
By starting your container you can limit the RAM usage simply by adding
(this limits the memory to 4 megabytes).
To check this simply run:
and on your docker machine check the following entry:
-m 4M
(this limits the memory to 4 megabytes).
To check this simply run:
docker run -it -m=4M --rm alpine /bin/ash
and on your docker machine check the following entry:
alpine:~# cat /sys/fs/cgroup/memory/docker/4ce0403caf667e7a6d446eac3820373aefafe4e73463357f680d7b38a392ba62/memory.limit_in_bytes
4194304
Oracle SOAR ?!
Larry Ellison announced yesterday Oracle SOAR:
Soar [https://en.oxforddictionaries.com/definition/soar]:
Fly or rise high in the air.
It is about migrating into the cloud [press release]:
the world’s first automated enterprise cloud application upgrade product that will enable Oracle customers to reduce the time and cost of cloud migration by up to 30 percent. By providing a complete set of automated tools and proven cloud transition methodologies, the new “Soar to the Cloud” solution enables customers with applications running on premises to upgrade to Oracle Cloud Applications in as little as 20 weeks.
Oracle does not see a bird - Oracle SOAR is more like a rocket ;-)
But it is not for plain databases or application servers. It is only for E-Business Suite, PeopleSoft and Hyperion:
The Oracle Soar offering is available today for Oracle E-Business Suite, Oracle PeopleSoft and Oracle Hyperion Planning customers who are moving to Oracle ERP Cloud, Oracle SCM Cloud and Oracle EPM Cloud. Oracle will continue to invest in the development of the product, extending the solution to Oracle PeopleSoft and Oracle E-Business Suite customers moving to Oracle HCM Cloud, and Oracle Siebel customers moving to Oracle CX Cloud in the future.
Soar [https://en.oxforddictionaries.com/definition/soar]:
Fly or rise high in the air.
‘the bird spread its wings and soared into the air’
the world’s first automated enterprise cloud application upgrade product that will enable Oracle customers to reduce the time and cost of cloud migration by up to 30 percent. By providing a complete set of automated tools and proven cloud transition methodologies, the new “Soar to the Cloud” solution enables customers with applications running on premises to upgrade to Oracle Cloud Applications in as little as 20 weeks.
But it is not for plain databases or application servers. It is only for E-Business Suite, PeopleSoft and Hyperion:
The Oracle Soar offering is available today for Oracle E-Business Suite, Oracle PeopleSoft and Oracle Hyperion Planning customers who are moving to Oracle ERP Cloud, Oracle SCM Cloud and Oracle EPM Cloud. Oracle will continue to invest in the development of the product, extending the solution to Oracle PeopleSoft and Oracle E-Business Suite customers moving to Oracle HCM Cloud, and Oracle Siebel customers moving to Oracle CX Cloud in the future.
Oracle SOA Suite 12c: How to deploy a BPEL onto a weblogic server
After you have created your BPEL inside Jdeveloper, you have to add an application server inside jdev:
And here we go:
Then go to the applications view:
And after the deployment check via Application Server view, if the BPEL version was deployed:
And after the deployment check via Application Server view, if the BPEL version was deployed:
Docker: Lessons learned - Logging
After some time working with docker here my experiences:
Some days ago i created my own container with a minimal web service.
Here the ncweb.sh:
After building the image
To get the right command:
If i change the ncweb.sh to
Conclusion: It is better to use STDOUT than local logfiles. Or even better: use syslog or other central logging mechanisms.
Related posts:
Some days ago i created my own container with a minimal web service.
Here the ncweb.sh:
#!/bin/ashThis is the Dockerfile:
sed -i 's/Hostname:.*/Hostname: '$HOSTNAME'/g' index.html
while true; do { echo -e 'HTTP/1.1 200 OK\r\n'; cat index.html;} | nc -l -p 8080 2>&1 >> logfile; done
FROM alpine
WORKDIR /tmp
RUN mkdir ncweb
ADD . /tmp
ENTRYPOINT [ "/tmp/ncweb.sh" ]
After building the image
docker build -t ncweb:0.4 .And starting the container:
docker run -d -p 8080:8080 ncweb:0.4 --name ncweb0.4I was able to connect to the container and view the log:
To get the right command:
docker ps |grep ncweb:0.4 |awk '{print "docker exec -it "$1" ash"}'and then use the output:docker exec -it e4f9960fc8e5 ash
alpine:~/ncweb# docker exec -it e4f9960fc8e5 ashBut this is not the right way.
/tmp # ls
Dockerfile hexdump index.html logfile ncweb ncweb.sh
/tmp # cat logfile
GET / HTTP/1.1
Host: 192.168.178.46:8080
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Language: en,de;q=0.7,en-US;q=0.3
Accept-Encoding: gzip, deflate
Connection: keep-alive
Upgrade-Insecure-Requests: 1
Cache-Control: max-age=0
Thu May 10 10:01:23 UTC 2018 request done
If i change the ncweb.sh to
#!/bin/ashthen you can do the following (after building a new container version):
sed -i 's/Hostname:.*/Hostname: '$HOSTNAME'/g' index.html
while true; do { echo -e 'HTTP/1.1 200 OK\r\n'; cat index.html;} | nc -l -p 8080 ;done
alpine:~/ncweb# docker run -d -p 8080:8080 ncweb:0.5 --name ncweb0.5To get the logs (which are written to STDOUT):
9589f77fc289a3713354a365f8f08098279e6d0e893de99a0431d8fbd62c834a
alpine:~/ncweb# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
9589f77fc289 ncweb:0.5 "/tmp/ncweb.sh --n..." 8 seconds ago Up 7 seconds 0.0.0.0:8080->8080/tcp gracious_archimedes
alpine:~/ncweb# docker logs -f 9589f77fc289
GET / HTTP/1.1
Host: 192.168.178.46:8080
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Language: en,de;q=0.7,en-US;q=0.3
Accept-Encoding: gzip, deflate
Connection: keep-alive
Upgrade-Insecure-Requests: 1
Cache-Control: max-age=0
Conclusion: It is better to use STDOUT than local logfiles. Or even better: use syslog or other central logging mechanisms.
Related posts:
- Docker on Ubuntu
- Running through a tutorial / investigating the processes
- Creating a small linux for my docker cluster (Alpine Linux)
- How to build a docker swarm
- Creating a minimal webserver container and deploying it to docker swarm
- Setting up a tomcat with docker
- Running a swarm with multiple managers
- Mysql inside a docker container - persistency with docker volumes
- How to change the configuration of a standard docker container(e.g. changing tomcats memory settings)
- Lessons learned - Logging