Observium installation on Debian 9 – adding devices fails

Installing fresh Observium (18.9.9420) (community version) on Debian 9 does not end up with a working installation.  (See Observium documentation)

Only one device is added, that cannot be viewed afterwards.

Possible solution: modify the database structure after installation and before adding your devices.

Start checking if the devices_id field has an auto-increment value set and is the primary key.

One can do so by issuing following commands:

mysql>show columns from devices from observium;

or alternatively:

mysql>show create table devices;

If the auto-increment value is missing, please add it:

mysql> use observium;

mysql> alter table devices change column device_id device_id int(11) not null auto_increment;

Easy fix, but takes some time to find out.

Some background information from the logs:

##### Software versions #####

o OS Linux 4.9.0-8-amd64 [amd64] (Debian 9.6)
o Apache 2.4.25
o PHP 7.0.33-0+deb9u1 (OPcache: DISABLED)
o Python 2.7.13
o MySQL 10.1.37-MariaDB-0+deb9u1 (extension: mysqli 5.0.12-dev)
o SNMP NET-SNMP 5.7.3
o RRDtool 1.6.0
o Fping 3.15 (IPv4 and IPv6)

##### Memory Limit #####

o PHP Unlimited

##### MySQL mode #####

o MySQL NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

##### Charset info #####

o PHP UTF-8
o MySQL utf8

##### Timezones info #####

o Date Wednesday, 15-May-19 13:35:30 CAT
o PHP +02:00
o MySQL +02:00

After making the change, please check the auto_increment value is there.

show columns from devices from observium;

Mint update from 18.3 to 19 – Wine broke

After updating from Linux Mint 18.3 to 19, wine stopped working. This is what was required to correct.

sudo all below commands if required

dpkg --add-architecture i386
apt-add-repository 'deb https://dl.winehq.org/wine-builds/ubuntu/ bionic main'
wget -nc https://dl.winehq.org/wine-builds/Release.key
apt-key add Release.key

Check if you do not have duplicate lines from an earlier install.

vi /etc/apt/sources.list.d/additional-repositories.list

Then the final step.

apt-get update
reboot

apt-get install --install-recommends winehq-stable

Source: Ubuntu – WineHQ Wiki

Unknown media type in type Fix

If Linux Mint 19 (Tara) shows error during update fril 18.3.

Unknown media type in type 'all/all'
Unknown media type in type 'all/allfiles'

To fix run following with sudo user:

cd /usr/share/mime
grep -R all/all *

in kde xml, remove the sections containing:
<mime-type type="all/allfiles">
<mime-type type="all/all">

sudo vi packages/kde.xml

the other files showing these sections can remain untouched.

Then run following, no errors should occur

sudo update-mime-database /usr/share/mime

Source: Unknown media type in type Fix