Ad Widget

**stemasie** · 11-02-2010, 10:59

hey,

take a look at this.
maybe it's the same problem with sqlite. try to recreate the DB file manually

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

**TriCK** · 11-02-2010, 11:32

Originally posted by stemasie

hey,

take a look at this.
maybe it's the same problem with sqlite. try to recreate the DB file manually

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

I have mysql. That topic doesn't have any right solutions. Just only guesses and recomendations that didn't solve the problem. But thanks for comment.

**stemasie** · 11-02-2010, 12:28

it solved the problem for me perfectly

**TriCK** · 11-02-2010, 13:09

Originally posted by stemasie

it solved the problem for me perfectly

Are you using sqlite or mysql?

I do not use autocreation. I use mysql. I've created mysql database manually and made >cat initial_db.sql | mysql zabbix_proxy by hands and granted all on zabbix_proxy.* to zabbix_proxy user.

**stemasie** · 11-02-2010, 13:17

i'm using mysql too (since 5 minutes...).
when you create a new db (example:zabbix2) and conduct the following steps again:

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

---edit---
don't forget to set the new dbname in zabbix_proxy.conf

**stemasie** · 12-02-2010, 11:12

I've the same issue with mysql now. ..

**TriCK** · 16-02-2010, 15:20

Originally posted by stemasie

I've the same issue with mysql now. ..

So your solution with db recreation does not help?

I can't find any difference between your recreation and initial setup which i made at the beginning...and solution did not help as it supposed to be.

Guys, do you have any ideas?

**stemasie** · 17-02-2010, 08:36

it works after a recreation...but only for a while, 1-2 times a week i've the problem again.
i've started the troubleshooting again, i assume that the problem depends on any cache options or a connection maximum.

@developers: what are you thinking? it's not the first thread about that problem. do you have any ideas?

**fjrial** · 17-02-2010, 12:36

not getting values

Hi:

I think that my problem is similar to yours: I'm in the process of moving our noc software to zabbix.

I've monitored some elements. One of them is an SNMP router juniper m20.
I've monitorized all interfaces of the router and created graphs for all of them.

Zabbix starts monotoring everything fine, but after some time, it stops getting values from some interfaces and so the graphs are interrupted at some points. If I clear the history of the item graphed then it starts monitoring fine, but after some undefined time, it stops monotoring the interface.

Any help will be appreciated.
thanks

**stemasie** · 17-02-2010, 12:39

That sounds simular...
Have you tried to set the "max_connection" parameter in the mysql configuration file (my.cnf) higher?

**TriCK** · 17-02-2010, 17:25

Originally posted by stemasie

That sounds simular...
Have you tried to set the "max_connection" parameter in the mysql configuration file (my.cnf) higher?

Guys, let's talk about zabbix-proxy.

I didn't find any solution yet. I've fixed error messages about active checks on zabbix agents but it wasn't a reason that cause lags.

**stemasie** · 18-02-2010, 06:52

Which database engine are you using with zabbix-proxy?
--edit--
i have this problem now once a day, same time.

**TriCK** · 18-02-2010, 13:38

Originally posted by stemasie

Which database engine are you using with zabbix-proxy?
--edit--
i have this problem now once a day, same time.

As i said i use mysql from Debian Lenny.

**TriCK** · 24-02-2010, 10:45

Zabbix guru, take a glance at this problem please.

Ad Widget

Zabbix-proxy and data arrival delay.

Zabbix-proxy and data arrival delay.

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment