[Howto] create PostgreSQL database with UTF-8 encoding
postgreSQL v9.6 CREATE DATABASE testdb ENCODING ‘utf8’ LC_COLLATE ‘de_DE.UTF-8’ LC_CTYPE ‘de_DE.UTF-8’ TEMPLATE template0;
postgreSQL v9.6 CREATE DATABASE testdb ENCODING ‘utf8’ LC_COLLATE ‘de_DE.UTF-8’ LC_CTYPE ‘de_DE.UTF-8’ TEMPLATE template0;
if you’ve upgraded virtualbox and afterwards you can’t start the vm’s, because of the error ‘the device helper structure has changed’, you must reinstall/update your virtualbox extension pack. Run as root the following command: vboxmanage extpack install –replace ‘new-extpack-file’
Error message: Kernel driver not installed (rc=-1908) The VirtualBox Linux kernel driver (vboxdrv) is either not loaded or there is a permission problem with /dev/vboxdrv. Please reinstall virtualbox-dkms package and load the kernel module by executing ‘modprobe vboxdrv’ as root. … Continued
If you want to add a bonded interface in Debian Linux, you don’t need the package ifenslave anymore. You can create/modify/delete the bonded interface completly through sysfs. at first load the required bonding-driver into kernel: modprobe ‘bonding’ create a … Continued
Use the following Virtualbox command in your shell: (you must specifiy the target size in MB, for example 200 GB = 200000) VBoxManage modifymedium image.vdi –resize 200000 tested with: Virtualbox Version 5.0.24_Debian
Use the following Virtualbox command in your shell: VBoxManage clonehd old-file.vmdk converted-file.vdi –format VDI tested with: Virtualbox Version 5.0.24_Debian
every menu entry is a text file with the suffix “.desktop“ example.desktop [space_20] the menu entries are located in two different folders: for all users (global): /usr/share/applications (note: you need root-privileges to edit this folder) for local user (local): ~/.local/share/applications … Continued
If you want to update wordpress themes or plugins and you are automatically redirected to the ftp-download-page, you can manually force wordpress to go in maintenance-mode and to download and update directly. For this you have to put the following … Continued
#!/bin/bash gcc main.c -o main -I/usr/include/gtk-3.0/ \ -I/usr/include/glib-2.0/ \ -I/usr/lib/x86_64-linux-gnu/glib-2.0/include/ \ -I/usr/include/pango-1.0/ \ -I/usr/include/cairo/ \ -I/usr/include/gdk-pixbuf-2.0/ \ -I/usr/include/atk-1.0/ \ \ -L/usr/lib/x86_64-linux-gnu \ \ -lgtk-3 \ -lgobject-2.0
the following commands send a syslog-message to the syslog-daemon with the syslog-facility=auth and syslog-priority=info: #to localhost’s syslog-daemon logger -p auth.info <message> #to a remote syslog-daemon logger -h <IP> -P <Port> -p auth.info <message>