zabbix - postfix: postfix is running but can't see info from it on zabbix
Linux - ServerThis forum is for the discussion of Linux Software used in a server related context.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
zabbix - postfix: postfix is running but can't see info from it on zabbix
Hi! Did I say postfix? It's postbix. Damn!
I'm trying to set up postbix to monitor a postgresql service.
I have already configured it to monitor the db and, from what the log is telling me, it's working:
Code:
2013-02-26 16:12:24,134 [pool-1-thread-3] INFO Postbix - Done with dbJob on database sanos_omega QueryList elapsed time 6 ms
2013-02-26 16:13:24,142 [pool-1-thread-4] INFO Postbix - Done with dbJob on database sanos_omega QueryList elapsed time 10 ms
2013-02-26 16:14:24,159 [pool-1-thread-5] INFO Postbix - Done with dbJob on database sanos_omega QueryList elapsed time 14 ms
2013-02-26 16:15:24,213 [pool-1-thread-6] INFO Postbix - Done with dbJob on database sanos_omega QueryList elapsed time 64 ms
2013-02-26 16:16:24,212 [pool-1-thread-7] INFO Postbix - Done with dbJob on database sanos_omega QueryList elapsed time 6 ms
2013-02-26 16:17:24,221 [pool-1-thread-8] INFO Postbix - Done with dbJob on database sanos_omega QueryList elapsed time 7 ms
2013-02-26 16:18:24,223 [pool-1-thread-9] INFO Postbix - Done with dbJob on database sanos_omega QueryList elapsed time 7 ms
On zabbix, I uploaded the postgresql template. I set up the host (which was already created) to use the postbix template (called Template_PostgreSQL... with no other configuration, perhaps that's the problem), however I don't get to see anything about it on monitoring->latest data. I think I'm missing one configuration step that matches the Host as defined in zabbix with the host as seen in postfix. Perhaps I'm not looking in the wrong place for the readings from postbix? What do you think?
Last edited by eantoranz; 02-26-2013 at 03:28 PM.
Reason: used the wrong word
Well... this is interesting. I was thinking about the architecture of postbix. If I'm not wrong it could actually be run from any given host (like not the zabbix server, not the postgresql server... you tell it the DBs you want to monitor, including the server, and you also tell it the zabbix servers this info will be pushed to). Is that the case? Then, how does zabbix server know what server information postbix is trying to send it belongs to?
Well... hope someone can explain to me a little bit more how the pieces fir together.
Bu the way, when postbix does its check on the DB service, there's a ton of additional network traffic going to zabbix server so I assume postbix is actually sending the info to zabbix server.
I set up the host (which was already created) to use the postbix template (called Template_PostgreSQL... with no other configuration, perhaps that's the problem), however I don't get to see anything about it on monitoring->latest data. I think I'm missing one configuration step that matches the Host as defined in zabbix with the host as seen in postfix. Perhaps I'm not looking in the wrong place for the readings from postbix? What do you think?
Is that the "Zabbix Server" in Zabbix?
give me some time to consider this issue as I'm beating up my own Zabbix 1.8.x at the moment. Damn WinTendo+snmp bull-pucky.
What zabbix version have you installed?
I don't have any PostgreSQL services running AFAIK, so I need time to think on this issue.
Oh... I hadn't understood to which of the hosts I was referring to you were asking about.
The zabbix server is also the host _running_ postbix. And the host I want to check the DBs running on it is _not_ the zabbix server. It's a host I had already created (it's set up to be monitored with zabbix agent but I don't have the agent running on the host yet..... and now I added the monitoring with postbix).
Zabbix server IP: 192.168.55.251. It's running zabbix server anid zabbix frontend. Postbix is running here also, configured to notify local zabbix server (localhost:10051).
PG server IP: 192.168.55.1. This host is running postgres and it's holding the zabbix DB, by the way.
you need to install the agent on every host you wish to monitor, unless you go "another route" (snmp, but that's very elaborate, so we won't go there).
You must modify /etc/zabbix/zabbix_agentd.conf for these 2 values on the host to be monitored, specifically:
Ok... got the agent running and showing up information on zabbix.... still no PG stuff to show off. I'll try installing postbix on the postgres host to see if it works that way.
Well.... I think postbix is actually sending the information to zabbix for it to process it and it's failing for some reason I can't tell at the moment.
this is from postbix log:
Code:
.
.
.
2013-02-27 10:57:22,444 [main] DEBUG Postbix - Note: buffers_alloc.ExcludeColumnsList error null
2013-02-27 10:57:22,444 [main] DEBUG Postbix - Note: buffers_alloc.RaceConditionQueryExcludeColumnsList error null
2013-02-27 10:57:22,445 [main] DEBUG Postbix - Ready to run DBJob for dbname ->sanos_omega
2013-02-27 10:57:22,445 [pool-1-thread-15] DEBUG Postbix - Starting dbJob on database sanos_omega QueryList
2013-02-27 10:57:22,447 [pool-1-thread-15] DEBUG Postbix - sending <req><host>c2Fub3Nfb21lZ2E=</host><key>YWxpdmU=</key><data>MQ==</data></req>
2013-02-27 10:57:22,453 [pool-1-thread-15] DEBUG Postbix - received OK
2013-02-27 10:57:22,454 [pool-1-thread-15] DEBUG Postbix - sending <req><host>c2Fub3Nfb21lZ2E=</host><key>UG9zdGJpeFZlcnNpb24=</key><data>UG9zdGJpeCBWZXJzaW9uIDEuMS4w</data></req>
2013-02-27 10:57:22,456 [pool-1-thread-15] DEBUG Postbix - received OK
2013-02-27 10:57:22,459 [pool-1-thread-15] INFO Postbix - Done with dbJob on database sanos_omega QueryList elapsed time 13 ms
This is from zabbix_server.log (debug level) (grepping):
Code:
2890:20130227:105522.381 Trapper got [<req><host>c2Fub3Nfb21lZ2E=</host><key>YWxpdmU=</key><data>MQ==</data></req>] len 76
2890:20130227:105522.381 In process_mass_data()
2890:20130227:105522.381 End of process_mass_data()
2892:20130227:105522.383 Trapper got [<req><host>c2Fub3Nfb21lZ2E=</host><key>UG9zdGJpeFZlcnNpb24=</key><data>UG9zdGJpeCBWZXJzaW9uIDEuMS4w</data></req>] len 112
2892:20130227:105522.383 In process_mass_data()
2892:20130227:105522.383 End of process_mass_data()
2905:20130227:105522.737 In process_escalations()
2905:20130227:105522.737 query [txnlev:1] [begin;]
2905:20130227:105522.738 query [txnlev:1] [select escalationid,actionid,triggerid,eventid,r_eventid,esc_step,status,nextcheck from escalations where 1=1 and escalationid between 100000000000000 and 199999999999999 order by actionid,triggerid,escalationid]
2905:20130227:105522.739 query [txnlev:1] [commit;]
2905:20130227:105522.740 End of process_escalations()
2905:20130227:105522.740 escalator #1 spent 0.002833 seconds while processing escalations
2905:20130227:105522.740 sleeping for 3 seconds
2907:20130227:105523.324 In collect_selfmon_stats()
2907:20130227:105523.325 End of collect_selfmon_stats()
2907:20130227:105523.325 sleeping for 1 seconds
2892:20130227:105524.306 Trapper got [] len 0
2907:20130227:105524.326 In collect_selfmon_stats()
2907:20130227:105524.326 End of collect_selfmon_stats()
I'm glad the info matches both logs but what does it mean? Thanks in advance
Since you are making progress, I'm going to think some more (re-read this post!) and let you analyze what your zabbix is collecting.
Still waiting for the url to the template.
That's twice now I have asked for info and not received it, and I'm not a big fan of wasting time, so if you can't or won't answer my questions, I could quit asking them? It's up to you.
Oh, sorry, man..... sometimes I forget where my nose is. Sure... the template. The template is the one included in the postbix tar.gz. Let me see if I can find it online.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.