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;

Groupware

People have heard about sharepoint, some people have heard about exchange…. Not difficult to miss if you consider the marketing engine that is behind it. Microsoft is desperately trying to change its business model now that Linux has become an low-cost alternative for people that are not wanting to pay for something that should be free.

The idea behind sharepoint is to tie people into an eco-system that will generate a future-proof eco-system. It took linux years to become ready for the mass market. Now that it is, Windows is only there for specific needs or for the ignorant. The only way windows will survive in the future, is to make it free for the masses.

Now this takes away a revenue stream for Microsoft. So they positioned a new one. Sharepoint is there to surplant Exchange, and to make people dependent.

Here are a few alternatives that already exist on the market (Article on groupwares).

LDAP install guide CentOS

At first sight a good explanation on setting up an ldap on a CentOS machine.

First we start looking at a low profile CentOS machine to activate on my ESXi. Follow these steps:

1) Getting CentOS:
http://www.server-world.info/en/note?os=CentOS_5&p=make_media

2) Preparing the ESXi instance:
http://www.server-world.info/en/note?os=CentOS_5&p=vmware_esxi&f=3

3) Installing CentOS:
http://www.server-world.info/en/note?os=CentOS_5&p=install

4) Installing LDAP:
http://www.server-world.info/en/note?os=CentOS_5&p=ldap&f=1

5) Testing LDAP:
… to be done … I will update the article once finished.

e.g.: http://vuksan.com/linux/LDAP_authentication_under_Linux.html

Multiple web-sites behind a single IP

In order to install multiple web-sites with the same IP, the web-sites have to be identified by DNS name. Secondly, one will want to have a different installation of apache for each of the individual web-sites.

I configured a set-up where I have a single forwarding proxy, and all different vm’s with individual web-services. With Apache 2.2, the config is as follows.

The firewall has a public ip, and is forwarding all requests on port 80 and port 443 to the private proxy. The proxy server has a private ip (e.g. 10.0.1.10) and is forwarding all requests to individual servers. I will present 2, but you can repeat as much as you want. The private servers are on 10.0.1.21 and up….

Activate your proxy includes by creating a symbolic link:
su root
cd /etc/apache2/mods-enabled
ln -s ../mods-available/proxy.load proxy.load
ln -s ../mods-available/proxy_http.load proxy_http.load

Edit /etc/apache2/httpd.conf and add following sections:
UseCanonicalName On
NameVirtualHost 10.0.1.10

<virtualhost 10.0.1.10>
ServerName webmail.mydomain.com
ServerAlias www.webmail.mydomain.com
ProxyPreserveHost On
ProxyPass / http://10.0.1.21/
ProxyPassReverse / http://10.0.1.21/
</virtualhost>

<virtualhost 10.0.1.10>
ServerName clientzone.mydomain.com
ServerAlias www.clientzone.mydomain.com
ProxyPreserveHost On
ProxyPass / http://10.0.1.22/
ProxyPassReverse / http://10.0.1.22/
</virtualhost>

… that is it… simple once you know but it took me a lot of time to find it out.

Redmine

How to install redmine on a Mac:

http://www.apple.com/downloads/macosx/development_tools/bitnamiredminestack.html