Zabbix 2.0.2 database on different server

[gdobson]

Hi All,

I'm tryning to start the Zabbix 2.0.2 server process on a server (runnning FreeBSD) with the MySQL database located on a different server.

In the zabbix_server.conf file I specified the DBHost as follows:
DBHost=ourea.matrix

When doing this it defaults to `hostname` and produce the following error:

31252:20120822:160533.819 [Z3001] connection to database 'zabbix' failed: [1130] Host 'uranus.matrix' is not allowed to connect to this MySQL server

I found that when using DBHost='ourea.matrix' (quotes) it does use the DBHost value but still produce the same error... possibly the extra set of quotes causing this.

31042:20120822:155705.807 [Z3001] connection to database 'zabbix' failed: [2005] Unknown MySQL server host ''ourea.matrix'' (1)

Using the IPaddress of the remote db server, qouted and un-quoted, has the same results.

Help!!! This looks buggish... I hope not.

Thanks,
//GD

[tchjts1]

In the zabbix_server.conf file I specified the DBHost as follows:
DBHost=ourea.matrix

When doing this it defaults to `hostname` and produce the following error:

31252:20120822:160533.819 [Z3001] connection to database 'zabbix' failed: [1130] Host 'uranus.matrix' is not allowed to connect to this MySQL server

So you are saying that when you specify DBHost=ourea.matrix, the error is showing a different host name - failed: [1130] Host 'uranus.matrix' ?

Odd indeed. Where is it picking up that second name from?

Using the IPaddress of the remote db server, qouted and un-quoted, has the same results.

On a previous implementation of 1.8.x with the DB on a separate server, I always used the IP address for the DBHost= field. Our 2.0.2 setup currently has the DB on the same server as the Zabbix App, so we are using localhost.

Anyway, I assume you have granted correct rights to the DB?

GRANT ALL ON zabbix.* TO zabbix@'my.IP.address.here' IDENTIFIED BY 'mypasswordhere';

Additionally, how are you starting Zabbix server? Try specifying the Zabbix server conf file by using the -c switch when starting:

./zabbix_server -c /usr/local/etc/zabbix_server.conf

...Or wherever your conf file resides

One other thought... you are restarting Zabbix server process after you make any changes to the conf file, right?

[gdobson]

Thanks for the help.

It did turn out to be the mysql permissions. I didn't realize the zabbix error message contained the remote mysql server's error message and thus assumed it's attempting to connect to the wrong db server...

//GD