Setting up proxy using rpi

[cliffennis]

Good afternoon,

I've seen this discussed but have not yet seen anyone successfully install the proxy using mysql on Raspberry Pi. There are 2 issues I'm hitting:

1. When installing the package "zabbix-proxy-mysql_2.4.5+dfsg-1_armhf.deb" it fails because of version dependencies. For example libc6 is at version 2.13 on Raspbian and no higher version is available. But this package depends on version 2.17.

This is from the Raspbian package repository:
Package: libc6
Source: eglibc
Version: 2.13-38+rpi2+deb7u8
Architecture: armhf

2. If I try to install zabbix from source it fails with:
"configure: error: MySQL library not found"

This seems to resolve if you install the mysql-devel package. But mysql-devel is not available from the Raspbian package archives.

The zabbix-proxy with mysql seems to be designed to work on Raspberry Pi, or systems of similar architecture, otherwise they would not have made a deb package for it. Has anyone found a way to install the proxy with mysql on Pi?

[cliffennis]

I got the 2.4.5 rpi proxies working, just not through a repo. If anyone is wanting to do the same this is what I did:

1. Upgrade Raspbian to Jessie
2. Download 3 packages that are required

wget http://mirrordirector.raspbian.org/raspbian/pool/main/z/zabbix/zabbix-proxy-mysql_2.4.5+dfsg-1_armhf.deb
wget http://mirrordirector.raspbian.org/raspbian/pool/main/n/net-snmp/libsnmp-base_5.7.3+dfsg-1_all.deb
wget http://mirrordirector.raspbian.org/raspbian/pool/main/n/net-snmp/libsnmp30_5.7.3+dfsg-1_armhf.deb

3. Install some of the required packages that are available from the repo. I used MySql as the proxy database. MySql will prompt for creating a password for the root database user. Make it whatever you want.

apt-get install mysql-server libodbc1 libopenipmi0 fping

4. Install the downloaded deb packages, force the installation of failed dependencies, and install the Zabbix proxy.

dpkg -i libsnmp-base_5.7.3+dfsg-1_all.deb
dpkg -i libsnmp30_5.7.3+dfsg-1_armhf.deb
apt-get -f install
dpkg -i zabbix-proxy-mysql_2.4.5+dfsg-1_armhf.deb

5. Download the Zabbix Source and unpack the archive. In the zabbix-2.4.5\database\mysql directory there is schema.sql. Copy this file to your rpi.

6. Create the Zabbix database and import the schema.sql.

#> mysql -uroot -p<password>
mysql> create database zabbix_proxy character set utf8 collate utf8_bin;
mysql> grant all privileges on zabbix_proxy.* to zabbix@localhost identified by '<password>';
mysql> quit;
#> mysql -uzabbix -p<password> zabbix_proxy < schema.sql

7. Update the configuration file. You'll need to set the following:
- Hostname (this has to match what you create as your proxy name in the Zabbix server)
- Server (address or DNS name of your Zabbix server)
- DBHost (127.0.0.1 in this case)
- DBUser ("zabbix" in this example)
- DBPassword (the password you created for you "zabbix" mysql user)

8. Add the proxy to your Zabbix server.

The proxy should be talking to the server now barring any network issues.