Linux Mauritius

Upgrade Zabbix from 2.0x to 2.2

Posted on: 23/11/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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Enter your email address to follow this blog and receive notifications of new posts by email.

Member of the Fedora Project

Home of SnowBird Linux Remix

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

%d bloggers like this: