Zabbix Proxy installation from Packagies

[nabberuk]

I've just attempted to install zabbix proxy (MySQL) from the Ubuntu repository as per https://www.zabbix.com/documentation..._from_packages

Trouble is it doesn't look like its configured or even created the MySQL database. What should I do? How come it hasn't created it?

EDIT:

Looks like the database hasn't been created.

2316:20141208:121833.405 [Z3001] connection to database 'zabbix_proxy' failed: [1049] Unknown database 'zabbix_proxy'
2316:20141208:121833.405 Cannot connect to the database. Exiting...

[Alberto Freire]

Send the result this command:

# mysql -u root -p -e "show databases;"


and this:

# grep -v "^#" /pathzabbixconf/zabbix_proxy.conf | sed '/^$/d'


Cheers!

[nabberuk]

I have the following databases;

information_schema
MySQL
performance_schema
zabbix_proxy

and the next command outputs the following (edited);

Server=monitor.domain.com
ServerPort=10051
Hostname=KIB_Proxy
LogFile=/var/log/zabbix-proxy/zabbix_proxy.log
PidFile=/var/run/zabbix/zabbix_proxy.pid
DBHost=localhost
DBName=zabbix_proxy
DBUser=root
DBPassword=edited
FpingLocation=/usr/bin/fping
Fping6Location=/usr/bin/fping6


I've managed to connect to the zabbix_proxy database via workbench and import the data. after checking the logs it still gives the above error saying unknown database.

[nabberuk]

When installing from a package, should it install the database and schema by default as I have a few proxies to setup and don't want to mess about each time I install one.

[Alberto Freire]

Well, I guess that a package or installation were corrupted. Try as root, to remove and re-install the Proxy, but remember of delete the database proxy_zabbix.

Ps: My installations are created DB called 'zabbix' and not 'zabbix_proxy', same thing to user.


Good luck.

[nabberuk]

Well, I guess that a package or installation were corrupted. Try as root, to remove and re-install the Proxy, but remember of delete the database proxy_zabbix.

Ps: My installations are created DB called 'zabbix' and not 'zabbix_proxy', same thing to user.


Good luck.

I may have created the zabbix_proxy database. I'm doing a clean install now of the OS. Do I need to do anything other than install zabbix-proxy-MySQL?
I'm guessing it will auto install/configure the db?

[Alberto Freire]

In my zabbix servers (ubuntu), I install these packages:

build-essential mysql-server libmysqlclient15-dev php5 php5-gd php5-mysql snmp libsnmp-dev snmpd libcurl4-openssl-dev fping

After, follow the manual: https://www.zabbix.com/documentation..._from_packages


Cheers!

[nabberuk]

In my zabbix servers (ubuntu), I install these packages:

build-essential mysql-server libmysqlclient15-dev php5 php5-gd php5-mysql snmp libsnmp-dev snmpd libcurl4-openssl-dev fping

After, follow the manual: https://www.zabbix.com/documentation..._from_packages


Cheers!

how come you install build-essential etc, thought that was for if you were building from source?

Oh and is this for the zabbix proxy and not zabbix

[Alberto Freire]

Hmm... I don't know! I never install the Zabbix* from apt-get, yum...
But don't cost try to install theses packages...


Cheers!