Stuck with MySQL insertion

[DiedX]

Hi there,

I'm becoming a real guru now ;)

I have a question inserting hard into the MySQL database.
We have several servers, which can be inserted into the hosts table. This works.

Also, the adding of items can be done.

But how can I add triggers and alerts into zabbix via the MySQL database? I'm a little bit stuck, which is probably due to missing documentation?
Who has done this before, and is willing to share his knowledge?

[DiedX]

Maybe this one should be moved to help?

[charles]

I fully intended to do the same thing, but never had the time to look deeply into what was involved, and decided it would be fragile.

Instead I just made a simple php file that calls the same core code to do these things but collects the data differently. This approach was trivial to implement. We'll see how hard its going to be to upgrade :)

hth
charles

[DiedX]

I fully intended to do the same thing, but never had the time to look deeply into what was involved, and decided it would be fragile.

Instead I just made a simple php file that calls the same core code to do these things but collects the data differently. This approach was trivial to implement. We'll see how hard its going to be to upgrade :)

hth
charles
Charles,

thanks for answering. PHP IS an option, but better not. I want to be able to run it from Perl or Python.
But basically you "reverse engineered" the PHP scripts from Alexey?

Ok, other way: is there somebody that can give me in depth the database structure. Maybe then I can imagine what happens! (And no, not the manual. I want the "graphical" structure)