Cannot get proxy working

[Hrobocop]

Just added Zabbix proxy to my setup.
Proxy config seems to be tuned ok, but on main Zabbix server, I see correct heartbeat info (every minute), but no data are collected.

ConfigFrequency set to 300, agent restarted, waiting for more than hour but still no data on Zabbix server.

Proxy name same on both proxy and server.
Nothing suspictious in proxy's log file.
Proxy 2.0.3 apt-get on Ubuntu, server 2.0.2rc2 as appliance.

Any clue?
Thanx!!!

[Hrobocop]

Plz any update on this?

still not lucky with setup

Here is few lines from log:

977:20121229:225244.321 Received configuration data from server. Datalen 18340
977:20121229:225244.325 Invalid table name "interface"
995:20121229:225738.350 Executing housekeeper
995:20121229:225738.353 Deleted 0 records from history [0.001136 seconds]
977:20121229:225744.915 Received configuration data from server. Datalen 3854
977:20121229:225744.918 Invalid table name "interface"

[heaje]

based on the log entry about the interface table, you have something wrong with your proxy database. What DB engine are you using? Try the SQLite one for testing. It auto creates the DB and I haven't had any issues with it.

[Hrobocop]

based on the log entry about the interface table, you have something wrong with your proxy database. What DB engine are you using? Try the SQLite one for testing. It auto creates the DB and I haven't had any issues with it.

Thanx for direction, looks like some troube with mysql config. I'm just cofused by the log -something like "cannot connect to db" would me more helpful.

[Hrobocop]

Tested everything. MySQL configured well, proxy connects to MySQL. MySQL database exists, there is lot of tables, but all tables have 0 rows

Check both logs on zabbix server and proxy, nothing special. Only one thing which I dont undersatd in proxy log is still:
Invalid table name "interface"

[Hrobocop]

It looks like there is one table missing:

3273:20121230:123724.799 In process_proxyconfig_table() tablename:'hosts'
3273:20121230:123724.799 query [txnlev:1] [select hostid from hosts]
3273:20121230:123724.803 query [txnlev:1] [insert into hosts (hostid,host,status,ipmi_authtype,ipmi_privilege,i pmi_username,ipmi_password) values (10140,'Leela - from public IP',0,-1,2,'','');
]
3282:20121230:123724.804 proxy #10 started [trapper #1]
3282:20121230:123724.805 In main_trapper_loop()
3282:20121230:123724.805 In DBconnect() flag:0
3283:20121230:123724.808 proxy #11 started [trapper #2]
3283:20121230:123724.809 In main_trapper_loop()
3283:20121230:123724.809 In DBconnect() flag:0
3273:20121230:123724.811 End of process_proxyconfig_table():SUCCEED
3273:20121230:123724.811 In process_proxyconfig_table() tablename:'interface'
3273:20121230:123724.812 Invalid table name "interface"
3273:20121230:123724.812 End of process_proxyconfig_table():FAIL

[dmorrow]

Did you ever resolve this?

I have run into same issue

[tchjts1]

I've recently just set up a proxy and have had no issues at all.

What version proxy are you using?

[dmorrow]

I installed zabbix-proxy-mysql using apt-get on Ubuntu

With mysql I ran the mysql.sql to setup the database

I keep getting this error that the interfaces table does not exist

[tchjts1]

Do you have root access to the server the proxy is on?
Doing your own compile is extremely simple. I can give you the steps here on how to do it if you can sudo to root and you have a GCC compiler installed.

I never did like doing apt-get for my Zabbix stuff.

Otherwise, you could retry creating the DB using this:

sudo mysql
create database zabbix character set utf8;
grant all on zabbix.* to zabbix@’localhost’ identified by ‘zabbixuserpassword’;
quit;
mysql -uroot -pyourpassword zabbix < database/mysql/schema.sql

[dmorrow]

Thanks. I took your advice and it seems to be sort of working.

The Proxy appears on my Zabbix server.
I see some log entries that the server is successfully talking to it.

I added a single agent. The agent appears in the available hosts when I edit the Proxy under Admin/DM so something is working.

The issue I am seeing now is on the Zabbix Proxy I am seeing a log entry

cannot send list of active checks to [10.210.10.36]: host [ip-10-210-10-36] not found

And on the Zabbix Server GUI

Zabbix agent on ip-10-210-10-36 is unreachable for 5 minutes

Any ideas?

[tchjts1]

The thing with using Active checks... in your zabbix_agentd.conf file there is a parameter Hostname= and whatever you have entered there, has to be an EXACT match (including case sensitive) to the name you have for that server in the Zabbix frontend.

It looks like this is what you have in zabbix_agentd.conf: ip-10-210-10-36
Is that what you have in the frontend?

And for "Zabbix agent unreachable"... that usually means the agent is not running.