Zabbix Proxy

[wizard-ict]

I'm having trouble getting my first Zabbix Proxy up and running.

I've installed the proxy and configured zabbix_proxy.conf with the hostname, database name, username and password etc. When I start the proxy I get the following in the log:

"connection to database 'zabbix' failed: [1049] Unknown database 'zabbix'"

I was under the impression that the proxy created the database itself?

I'm using mysql, the username provided has All Privileges to the whole install so there should be no issue creating it. If that were the case I'd also expect the log to show an error creating the database?

If I maually create the database I get a whole load of errors in the log "could not find table.." etc.


Am I wrong in thinking it automatically creates the database? If so is there a script somewhere tomanually create it and all the tables?

[wizard-ict]

Ok, well I managed to fix this by exporting the database structure from my Zabbix server and importing it to the proxy. The proxy now works fine but..... should I really have to do that??

[frankymryao]

proxy database is different from the master server.

For us, we use MySQL in zabbix proxy and Oracle in master server.

You can read the zabbix manual and install the proxy step by step.

[wizard-ict]

proxy database is different from the master server.

For us, we use MySQL in zabbix proxy and Oracle in master server.

You can read the zabbix manual and install the proxy step by step.

Unless I've overlooked it I haven't been able to find a step-by-step guide to install the proxy using mysql. Either way it's not the install that's the problem it's the database creation, as stated if I import the database schema from the master it works fine.

[frankymryao]

Unless I've overlooked it I haven't been able to find a step-by-step guide to install the proxy using mysql. Either way it's not the install that's the problem it's the database creation, as stated if I import the database schema from the master it works fine.

For proxy, import schema is neccessary, too.

In manual:
'''
For MySQL:

shell> mysql -u<username> -p<password>
mysql> create database zabbix character set utf8;
mysql> quit;
shell> cd create/schema
shell> cat mysql.sql | mysql -u<username> -p<password> zabbix
'''

[wizard-ict]

Thanks for the reply, that certainly seems to be the case but is completely the opposite of Alexei's comment in this post

http://www.zabbix.com/forum/showthread.php?t=9409

In which he states that the database will automatically be created for mysql as of 1.6. I'm using 1.8.8

[frankymryao]

Thanks for the reply, that certainly seems to be the case but is completely the opposite of Alexei's comment in this post

http://www.zabbix.com/forum/showthread.php?t=9409

In which he states that the database will automatically be created for mysql as of 1.6. I'm using 1.8.8

I'm not sure about that but for my usage I always import scheme according to the manual. I've marked the url and dig into it tomorrow.