Upgrade Zabbix 2.2

[thomphi]

mysql>select * from dbversion;
ERROR 1146: table "zabbix.dbversion' doesn't exist

[pc99096]

can you delete the whole database and create a new one? you will lose all settings, data, history etc.

mysql> drop database zabbix;
and then

https://www.zabbix.com/documentation/2.0/manual/appendix/install/db_scripts

[thomphi]

No I can't delete the database. My data are precious ��

It's why I would like to upgrade. Otherwise I reinstall zabbix properly

[pc99096]

find / -name zabbix_server

zabbix_server --version


it is not a good idea to upgrade an appliance version

[steveboyson]

The problem is that the zabbix guys do not provide the RPMs they use for the appliances builds. So, an "in place" upgrade of 2.0.x to 2.2.x appliance is a little bit complicated.

There is a repo at

http://download.opensuse.org/repositories/server:/monitoring/openSUSE_12.3

(12.3 is the base of the 2.0.x appliances) but there might be some caveats.

You may want to start from your previously backed-up VM, add that repository and try an upgrade.

[steveboyson]

For example, in difference to installs built from scratch, Opensuse packages have "-" and not "_" in the binary's names.

so: instead of "zabbix_agentd" it is "zabbix-agentd", "zabbix_server" => "zabbix-server" and so on. Same for config files.

Since you are on Suse already, this should not be a big problem, though.

I would give the repo and the upgrade a try. Be sure to check your backups BEFORE the operation.

[thomphi]

Thank you man, I alreay try this.. (zypper update)
Look :

[thomphi]

And zypper dup:

[steveboyson]

12.1 is the wrong repo. As I mentioned before, 2.0.x appliance builds are based on 12.3

Nevertheless, you may get the src.rpm and do a "rpmbuild --rebuild <name-of-source-rpm>.src.rpm" and see what is happening.

Have a look at /etc/SuSE-release. What is in there?
This is your base distribution to look for in the repos

[thomphi]

Ok, my repos :


EDIT: Oops I put the same repo twice

And /etc/Suse-release :


And I didn't understand your thing with "rpm" ..

[thomphi]

It's very complicated to upgrade Zabbix in 2.2 with Opensuse. LOL

[pc99096]

"You can use this Appliance to evaluate Zabbix. The Appliance is not intended for serious production use at this time."

first question, why are you upgrading to 2.2 at all?

[thomphi]

Because, I saw that Zabbix is 2.5x faster and other stuff interesting for me.

[steveboyson]

Ok, it seems that your base distro is 12.1
And: there is no "server_monitoring" repo for 12.1

So, your best bet is to build the RPMs from the source rpm as mentioned before.
get

http://download.opensuse.org/repositories/server:/monitoring/openSUSE_12.3/src/zabbix-2.2.2-1.1.src.rpm

and do a "rpmbuild --rebuild zabbix-2.2.2-1.1.src.rpm".

A different solution would be to get a 2.0.9 appliance (which is based on 12.3), export your 12.1 database (mysqldump), import it into the new 12.3 appliance and upgrade that one via the repos to 2.2.1

[thomphi]

http://download.opensuse.org/reposit....2-1.1.src.rpm : Repository is invalid

If I download Zabbix Appliance 2.2.2 (at the bottom), I just do export my database.sql (from Zabbix 2.0). is it possible? easy?