Linux Mauritius

Archive for November 2013

I decided to upgrade my Zabbix instance to 2.2 as the upgrade process is supposed to be easier since the database upgrade is performed by the server. Grabbed and installed the latest zabbix-release rpm, fired up yum update and to my surprise no updates 😦 .. It had to be done manually, so I did a rpm -qa | grep zabbix and downloaded the matching updates. This time it worked when running yum localinstall *.rpm , so that had to be it. Pointed my browser to the Zabbix url and that’s when disaster struck ” Database error: The frontend does not match the Zabbix database” A quick look at the server log revealed that the database upgrade failed since it’s trying to drop an inexistent column (lastvalue) from the items table.  Let’s make the database upgrade script happy by creating the missing column (as it will drop it in any case) and restart the server.

mysql -u root -p

use zabbix;

ALTER TABLE items ADD lastvalue VARCHAR(60);

Restart the Zabbix server using service zabbix-server restart and watch the Zabbix server log, the database upgrade process will be shown and once complete you can login again to your instance. Hope this saves someone some frustration.

I always start with a minimal install when provisioning new systems which are usually deployed through Spacewalk but there are some instances where I have no deployment server, so after a DVD install I have a broken XForwarding which is quite easy to fix.

yum install xorg-x11-xauth xorg-x11-fonts*

It’s quite handy when scripted within a kickstart file, which is why I don’t always remember it 🙂 so documenting it on the blog keeps it accessible. You don’t need to plug in all the fonts but if you work with legacy applications or Oracle, you’ll want to have them on the system.

If you’ve played a lot with putty and need a remote session management tool, have a look at PAC Manager @ techmint.com


negativo17.org

I'm not dumb. I just have a command of thoroughly useless information.

Red Hat Services Speak

Insights and news on Red Hat training, certification and consulting

Máirín Duffy

Open design forever.

Matthew Garrett

Penguins on the paradise island

Remi's RPM repository - Blog

Penguins on the paradise island

Brno hat

Blog of Jiri Eischmann

Simon + Fedora

Penguins on the paradise island

Luc de Louw's Blog

Penguins on the paradise island

Richard WM Jones

Virtualization, tools and tips