I've installed zabbix from the RPMs on a Centos 6.6 server using the following -
yum -y update
rpm -ivh http://repo.zabbix.com/zabbix/2.4/rh...el6.noarch.rpm
yum install zabbix-server-pgsql zabbix-web-pgsql zabbix-agent
After that I made the config changes to my php.ini (validates in setup) and to my zabbix_server.conf to point to my external postgresql server which other applications connect to fine.
The logging is set to debug and I see no issues but when I try to test my database connection with the same data in the zabbix_server.conf it just says "Error connecting to database."
yum -y update
rpm -ivh http://repo.zabbix.com/zabbix/2.4/rh...el6.noarch.rpm
yum install zabbix-server-pgsql zabbix-web-pgsql zabbix-agent
After that I made the config changes to my php.ini (validates in setup) and to my zabbix_server.conf to point to my external postgresql server which other applications connect to fine.
The logging is set to debug and I see no issues but when I try to test my database connection with the same data in the zabbix_server.conf it just says "Error connecting to database."
Code:
13356:20150926:143715.549 Starting Zabbix Server. Zabbix 2.4.6 (revision 54796). 13356:20150926:143715.549 ****** Enabled features ****** 13356:20150926:143715.549 SNMP monitoring: YES 13356:20150926:143715.549 IPMI monitoring: YES 13356:20150926:143715.549 WEB monitoring: YES 13356:20150926:143715.549 VMware monitoring: YES 13356:20150926:143715.549 Jabber notifications: YES 13356:20150926:143715.549 Ez Texting notifications: YES 13356:20150926:143715.549 ODBC: YES 13356:20150926:143715.549 SSH2 support: YES 13356:20150926:143715.549 IPv6 support: YES 13356:20150926:143715.549 ****************************** 13356:20150926:143715.549 using configuration file: /etc/zabbix/zabbix_server.conf 13356:20150926:143715.549 In load_modules() 13356:20150926:143715.549 End of load_modules():SUCCEED 13356:20150926:143715.550 In init_database_cache() 13356:20150926:143715.550 In zbx_mem_required_size() size:0 chunks_num:4 descr:'history cache' param:'HistoryCacheSize' 13356:20150926:143715.550 End of zbx_mem_required_size() size:543 13356:20150926:143715.550 In zbx_mem_create() descr:'history cache' param:'HistoryCacheSize' size:8388583 13356:20150926:143715.550 valid user addresses: [0x7f3464485170, 0x7f3464c84fd8] total size: 8388200 13356:20150926:143715.550 End of zbx_mem_create() 13356:20150926:143715.550 In zbx_mem_required_size() size:0 chunks_num:1 descr:'history text cache' param:'HistoryTextCacheSize' 13356:20150926:143715.550 End of zbx_mem_required_size() size:435 13356:20150926:143715.550 In zbx_mem_create() descr:'history text cache' param:'HistoryTextCacheSize' size:16777216 13356:20150926:143715.550 valid user addresses: [0x7f3463485178, 0x7f3464484ff0] total size: 16776824 13356:20150926:143715.550 End of zbx_mem_create() 13356:20150926:143715.550 In init_trend_cache() 13356:20150926:143715.550 In zbx_mem_required_size() size:0 chunks_num:1 descr:'trend cache' param:'TrendCacheSize' 13356:20150926:143715.550 End of zbx_mem_required_size() size:422 13356:20150926:143715.550 In zbx_mem_create() descr:'trend cache' param:'TrendCacheSize' size:4194304 13356:20150926:143715.550 valid user addresses: [0x7f3463085170, 0x7f3463484ff0] total size: 4193920 13356:20150926:143715.550 End of zbx_mem_create() 13356:20150926:143715.550 End of init_trend_cache() 13356:20150926:143715.550 End of init_database_cache() 13356:20150926:143715.550 In init_configuration_cache() size:8388608 13356:20150926:143715.550 In zbx_mem_create() descr:'configuration cache' param:'CacheSize' size:7130317 13356:20150926:143715.551 valid user addresses: [0x7f34629b8170, 0x7f3463084cc0] total size: 7129936 13356:20150926:143715.551 End of zbx_mem_create() 13356:20150926:143715.551 In zbx_strpool_create() 13356:20150926:143715.551 In zbx_mem_create() descr:'string pool' param:'CacheSize' size:1258291 13356:20150926:143715.551 valid user addresses: [0x7f3462884168, 0x7f34629b7328] total size: 1257920 13356:20150926:143715.551 End of zbx_mem_create() 13356:20150926:143715.551 End of zbx_strpool_create() 13356:20150926:143715.551 End of init_configuration_cache() 13356:20150926:143715.551 In init_selfmon_collector() 13356:20150926:143715.551 init_selfmon_collector() size:7072 13356:20150926:143715.551 End of init_selfmon_collector() collector:0x7f3462882000 13356:20150926:143715.551 In zbx_vc_init() 13356:20150926:143715.551 In zbx_mem_required_size() size:0 chunks_num:1 descr:'value cache size' param:'ValueCacheSize' 13356:20150926:143715.551 End of zbx_mem_required_size() size:427 13356:20150926:143715.551 In zbx_mem_create() descr:'value cache size' param:'ValueCacheSize' size:8388608 13356:20150926:143715.551 valid user addresses: [0x7f3462082170, 0x7f3462881ff0] total size: 8388224 13356:20150926:143715.551 End of zbx_mem_create() 13356:20150926:143715.551 End of zbx_vc_init() 13356:20150926:143715.551 In zbx_db_get_database_type() 13356:20150926:143715.551 In DBconnect() flag:0 13356:20150926:143715.570 query without transaction detected 13356:20150926:143715.570 query [txnlev:0] [set schema 'public'] 13356:20150926:143715.571 query [txnlev:0] [select oid from pg_type where typname='bytea'] 13356:20150926:143715.573 PostgreSQL Server version: 90404 13356:20150926:143715.573 query without transaction detected 13356:20150926:143715.573 query [txnlev:0] [set escape_string_warning to off] 13356:20150926:143715.574 query [txnlev:0] [show standard_conforming_strings] 13356:20150926:143715.574 query without transaction detected 13356:20150926:143715.574 query [txnlev:0] [set bytea_output=escape] 13356:20150926:143715.575 End of DBconnect():0 13356:20150926:143715.575 query [txnlev:0] [select userid from users limit 1] 13356:20150926:143715.576 there is at least 1 record in "users" table 13356:20150926:143715.576 End of zbx_db_get_database_type():ZBX_DB_SERVER 13356:20150926:143715.576 In DBcheck_version() 13356:20150926:143715.576 In DBconnect() flag:0 13356:20150926:143715.591 query without transaction detected 13356:20150926:143715.591 query [txnlev:0] [set schema 'public'] 13356:20150926:143715.592 query [txnlev:0] [select oid from pg_type where typname='bytea'] 13356:20150926:143715.594 PostgreSQL Server version: 90404 13356:20150926:143715.594 query without transaction detected 13356:20150926:143715.594 query [txnlev:0] [set escape_string_warning to off] 13356:20150926:143715.595 query [txnlev:0] [show standard_conforming_strings] 13356:20150926:143715.595 query without transaction detected 13356:20150926:143715.596 query [txnlev:0] [set bytea_output=escape] 13356:20150926:143715.596 End of DBconnect():0 13356:20150926:143715.596 query [txnlev:0] [select 1 from information_schema.tables where table_name='dbversion' and table_schema='public'] 13356:20150926:143715.601 query [txnlev:0] [select mandatory,optional from dbversion] 13356:20150926:143715.602 current database version (mandatory/optional): 02040000/02040000 13356:20150926:143715.602 required mandatory version: 02040000 13356:20150926:143715.602 End of DBcheck_version():SUCCEED 13356:20150926:143715.602 In DBconnect() flag:0 13356:20150926:143715.617 query without transaction detected 13356:20150926:143715.617 query [txnlev:0] [set schema 'public'] 13356:20150926:143715.618 query [txnlev:0] [select oid from pg_type where typname='bytea'] 13356:20150926:143715.620 PostgreSQL Server version: 90404 13356:20150926:143715.620 query without transaction detected 13356:20150926:143715.620 query [txnlev:0] [set escape_string_warning to off] 13356:20150926:143715.621 query [txnlev:0] [show standard_conforming_strings] 13356:20150926:143715.621 query without transaction detected 13356:20150926:143715.621 query [txnlev:0] [set bytea_output=escape] 13356:20150926:143715.622 End of DBconnect():0 13356:20150926:143715.622 In DCload_config() 13356:20150926:143715.622 query [txnlev:0] [select refresh_unsupported,discovery_groupid,snmptrap_logging,severity_name_0,severity_name_1,severity_name_2,severity_name_3,severity_name_4,severity_name_5,hk_events_mode,hk_events_trigger,hk_events_internal,hk_events_discovery,hk_events_autoreg,hk_services_mode,hk_services,hk_audit_mode,hk_audit,hk_sessions_mode,hk_sessions,hk_history_mode,hk_history_global,hk_history,hk_trends_mode,hk_trends_global,hk_trends from config] 13356:20150926:143715.624 In DCsync_config() 13356:20150926:143715.624 End of DCsync_config() 13356:20150926:143715.624 End of DCload_config() 13356:20150926:143715.624 In DCsync_configuration() 13356:20150926:143715.624 query [txnlev:0] [select refresh_unsupported,discovery_groupid,snmptrap_logging,severity_name_0,severity_name_1,severity_name_2,severity_name_3,severity_name_4,severity_name_5,hk_events_mode,hk_events_trigger,hk_events_internal,hk_events_discovery,hk_events_autoreg,hk_services_mode,hk_services,hk_audit_mode,hk_audit,hk_sessions_mode,hk_sessions,hk_history_mode,hk_history_global,hk_history,hk_trends_mode,hk_trends_global,hk_trends from config] 13356:20150926:143715.625 query [txnlev:0] [select hostid,proxy_hostid,host,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,maintenance_status,maintenance_type,maintenance_from,errors_from,available,disable_until,snmp_errors_from,snmp_available,snmp_disable_until,ipmi_errors_from,ipmi_available,ipmi_disable_until,jmx_errors_from,jmx_available,jmx_disable_until,status,name from hosts where status in (0,1,5,6) and flags<>2] 13356:20150926:143715.627 query [txnlev:0] [select hostid,inventory_mode from host_inventory] 13356:20150926:143715.629 query [txnlev:0] [select hostid,templateid from hosts_templates order by hostid,templateid] 13356:20150926:143715.630 query [txnlev:0] [select globalmacroid,macro,value from globalmacro] 13356:20150926:143715.631 query [txnlev:0] [select hostmacroid,hostid,macro,value from hostmacro] 13356:20150926:143715.632 query [txnlev:0] [select interfaceid,hostid,type,main,useip,ip,dns,port,bulk from interface] 13356:20150926:143715.633 query [txnlev:0] [select i.itemid,i.hostid,i.status,i.type,i.data_type,i.value_type,i.key_,i.snmp_community,i.snmp_oid,i.port,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassphrase,i.ipmi_sensor,i.delay,i.delay_flex,i.trapper_hosts,i.logtimefmt,i.params,i.state,i.authtype,i.username,i.password,i.publickey,i.privatekey,i.flags,i.interfaceid,i.snmpv3_authprotocol,i.snmpv3_privprotocol,i.snmpv3_contextname,i.lastlogsize,i.mtime,i.delta,i.multiplier,i.formula,i.history,i.trends,i.inventory_link,i.valuemapid,i.units,i.error from items i,hosts h where i.hostid=h.hostid and h.status in (0,1) and i.flags<>2] 13356:20150926:143715.638 query [txnlev:0] [select distinct t.triggerid,t.description,t.expression,t.error,t.priority,t.type,t.value,t.state,t.lastchange,t.status from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and h.status in (0,1) and t.flags<>2] 13356:20150926:143715.642 query [txnlev:0] [select d.triggerid_down,d.triggerid_up from trigger_depends d order by d.triggerid_down] 13356:20150926:143715.643 query [txnlev:0] [select i.itemid,f.functionid,f.function,f.parameter,t.triggerid from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and h.status in (0,1) and t.flags<>2] 13356:20150926:143715.645 query [txnlev:0] [select r.name,e.expressionid,e.expression,e.expression_type,e.exp_delimiter,e.case_sensitive from regexps r,expressions e where r.regexpid=e.regexpid] 13356:20150926:143715.646 In DCsync_config() 13356:20150926:143715.646 End of DCsync_config() 13356:20150926:143715.646 In DCsync_hosts() 13356:20150926:143715.646 End of DCsync_hosts() 13356:20150926:143715.646 In DCsync_host_inventory() 13356:20150926:143715.646 End of DCsync_host_inventory() 13356:20150926:143715.646 In DCsync_htmpls() 13356:20150926:143715.646 End of DCsync_htmpls() 13356:20150926:143715.646 In DCsync_gmacros() 13356:20150926:143715.647 End of DCsync_gmacros() 13356:20150926:143715.647 In DCsync_hmacros() 13356:20150926:143715.647 End of DCsync_hmacros() 13356:20150926:143715.647 In DCsync_interfaces() 13356:20150926:143715.647 End of DCsync_interfaces() 13356:20150926:143715.647 In DCsync_items() 13356:20150926:143715.647 End of DCsync_items() 13356:20150926:143715.647 In DCsync_triggers() 13356:20150926:143715.647 End of DCsync_triggers() 13356:20150926:143715.647 In DCsync_trigdeps() 13356:20150926:143715.647 End of DCsync_trigdeps() 13356:20150926:143715.648 In DCsync_functions() 13356:20150926:143715.648 End of DCsync_functions() 13356:20150926:143715.648 In DCsync_expressions() 13356:20150926:143715.648 End of DCsync_expressions() 13356:20150926:143715.648 DCsync_configuration() config : sql:0.000774 sync:0.000097 sec. 13356:20150926:143715.648 DCsync_configuration() hosts : sql:0.002286 sync:0.000096 sec. 13356:20150926:143715.648 DCsync_configuration() host_invent: sql:0.001550 sync:0.000073 sec. 13356:20150926:143715.648 DCsync_configuration() templates : sql:0.001351 sync:0.000101 sec. 13356:20150926:143715.648 DCsync_configuration() globmacros : sql:0.000865 sync:0.000079 sec. 13356:20150926:143715.648 DCsync_configuration() hostmacros : sql:0.000845 sync:0.000073 sec. 13356:20150926:143715.648 DCsync_configuration() interfaces : sql:0.001077 sync:0.000086 sec. 13356:20150926:143715.648 DCsync_configuration() items : sql:0.005303 sync:0.000467 sec. 13356:20150926:143715.648 DCsync_configuration() triggers : sql:0.003892 sync:0.000188 sec. 13356:20150926:143715.648 DCsync_configuration() trigdeps : sql:0.000961 sync:0.000134 sec. 13356:20150926:143715.648 DCsync_configuration() functions : sql:0.001729 sync:0.000172 sec. 13356:20150926:143715.648 DCsync_configuration() expressions: sql:0.001281 sync:0.000096 sec. 13356:20150926:143715.648 DCsync_configuration() total sql : 0.021915 sec. 13356:20150926:143715.648 DCsync_configuration() total sync : 0.001661 sec. 13356:20150926:143715.648 DCsync_configuration() proxies : 0 (1009 slots) 13356:20150926:143715.648 DCsync_configuration() hosts : 1 (1009 slots) 13356:20150926:143715.648 DCsync_configuration() hosts_h : 1 (1009 slots) 13356:20150926:143715.648 DCsync_configuration() ipmihosts : 1 (1009 slots) 13356:20150926:143715.648 DCsync_configuration() host_invent: 0 (1009 slots) 13356:20150926:143715.649 DCsync_configuration() htmpls : 14 (1009 slots) 13356:20150926:143715.649 DCsync_configuration() gmacros : 1 (1009 slots) 13356:20150926:143715.649 DCsync_configuration() gmacros_m : 1 (1009 slots) 13356:20150926:143715.649 DCsync_configuration() hmacros : 0 (1009 slots) 13356:20150926:143715.649 DCsync_configuration() hmacros_hm : 0 (1009 slots) 13356:20150926:143715.649 DCsync_configuration() interfaces : 1 (1009 slots) 13356:20150926:143715.649 DCsync_configuration() interfac_ht: 1 (1009 slots) 13356:20150926:143715.649 DCsync_configuration() if_snmpitms: 0 (1009 slots) 13356:20150926:143715.649 DCsync_configuration() if_snmpaddr: 0 (1009 slots) 13356:20150926:143715.649 DCsync_configuration() items : 64 (1009 slots) 13356:20150926:143715.649 DCsync_configuration() items_hk : 64 (1009 slots) 13356:20150926:143715.649 DCsync_configuration() numitems : 58 (1009 slots) 13356:20150926:143715.649 DCsync_configuration() snmpitems : 0 (1009 slots) 13356:20150926:143715.649 DCsync_configuration() ipmiitems : 0 (1009 slots) 13356:20150926:143715.649 DCsync_configuration() flexitems : 0 (1009 slots) 13356:20150926:143715.649 DCsync_configuration() trapitems : 0 (1009 slots) 13356:20150926:143715.649 DCsync_configuration() logitems : 0 (1009 slots) 13356:20150926:143715.649 DCsync_configuration() dbitems : 0 (1009 slots) 13356:20150926:143715.649 DCsync_configuration() sshitems : 0 (1009 slots) 13356:20150926:143715.649 DCsync_configuration() telnetitems: 0 (1009 slots) 13356:20150926:143715.649 DCsync_configuration() simpleitems: 0 (1009 slots) 13356:20150926:143715.649 DCsync_configuration() jmxitems : 0 (1009 slots) 13356:20150926:143715.649 DCsync_configuration() calcitems : 0 (1009 slots) 13356:20150926:143715.649 DCsync_configuration() deltaitems : 0 (1009 slots) 13356:20150926:143715.649 DCsync_configuration() functions : 41 (1009 slots) 13356:20150926:143715.649 DCsync_configuration() triggers : 41 (1009 slots) 13356:20150926:143715.649 DCsync_configuration() trigdeps : 35 (1009 slots) 13356:20150926:143715.649 DCsync_configuration() t_trigs[0] : 1 (32 allocated) 13356:20150926:143715.649 DCsync_configuration() expressions: 4 (1009 slots) 13356:20150926:143715.650 DCsync_configuration() queue[0] : 0 (0 allocated) 13356:20150926:143715.650 DCsync_configuration() queue[1] : 0 (0 allocated) 13356:20150926:143715.650 DCsync_configuration() queue[2] : 0 (0 allocated) 13356:20150926:143715.650 DCsync_configuration() queue[3] : 0 (0 allocated) 13356:20150926:143715.650 DCsync_configuration() queue[4] : 0 (0 allocated) 13356:20150926:143715.650 DCsync_configuration() pqueue : 0 (0 allocated) 13356:20150926:143715.650 DCsync_configuration() configfree : 94.900129% 13356:20150926:143715.650 DCsync_configuration() strings : 183 (1009 slots) 13356:20150926:143715.650 DCsync_configuration() strpoolfree: 98.297771% 13356:20150926:143715.650 === memory statistics for configuration cache === 13356:20150926:143715.650 free chunks of size >= 256 bytes: 1 13356:20150926:143715.650 min chunk size: 6766680 bytes 13356:20150926:143715.650 max chunk size: 6766680 bytes 13356:20150926:143715.650 memory of total size 7129936 bytes fragmented into 468 chunks 13356:20150926:143715.650 of those, 6766680 bytes are in 1 free chunks 13356:20150926:143715.650 of those, 355784 bytes are in 467 used chunks 13356:20150926:143715.650 ================================ 13356:20150926:143715.650 === memory statistics for string pool === 13356:20150926:143715.650 free chunks of size >= 256 bytes: 1 13356:20150926:143715.650 min chunk size: 1236872 bytes 13356:20150926:143715.650 max chunk size: 1236872 bytes 13356:20150926:143715.650 memory of total size 1257920 bytes fragmented into 186 chunks 13356:20150926:143715.650 of those, 1236872 bytes are in 1 free chunks 13356:20150926:143715.650 of those, 18088 bytes are in 185 used chunks 13356:20150926:143715.650 ================================ 13356:20150926:143715.650 End of DCsync_configuration() 13356:20150926:143715.651 server #0 started [main process] 13359:20150926:143715.654 server #3 started [poller #1] 13360:20150926:143715.656 server #4 started [poller #2] 13358:20150926:143715.658 server #2 started [db watchdog #1] 13358:20150926:143715.658 db watchdog [pinging database] 13358:20150926:143715.658 In DBconnect() flag:2 13361:20150926:143715.659 server #5 started [poller #3] 13362:20150926:143715.660 server #6 started [poller #4] 13357:20150926:143715.661 server #1 started [configuration syncer #1] 13357:20150926:143715.661 configuration syncer [waiting 60 sec for processes] 13363:20150926:143715.662 server #7 started [poller #5] 13364:20150926:143715.663 server #8 started [unreachable poller #1] 13365:20150926:143715.665 server #9 started [trapper #1] 13365:20150926:143715.665 trapper #1 [connecting to the database] 13365:20150926:143715.665 In DBconnect() flag:0 13366:20150926:143715.666 server #10 started [trapper #2] 13366:20150926:143715.666 trapper #2 [connecting to the database] 13366:20150926:143715.666 In DBconnect() flag:0 13367:20150926:143715.675 server #11 started [trapper #3] 13367:20150926:143715.675 trapper #3 [connecting to the database] 13367:20150926:143715.675 In DBconnect() flag:0 13368:20150926:143715.678 server #12 started [trapper #4] 13368:20150926:143715.678 trapper #4 [connecting to the database] 13368:20150926:143715.678 In DBconnect() flag:0 13369:20150926:143715.678 server #13 started [trapper #5] 13369:20150926:143715.678 trapper #5 [connecting to the database] 13369:20150926:143715.678 In DBconnect() flag:0 13370:20150926:143715.680 server #14 started [icmp pinger #1] 13370:20150926:143715.680 icmp pinger #1 [getting values] 13370:20150926:143715.680 In get_pinger_hosts() 13370:20150926:143715.680 In DCconfig_get_poller_items() poller_type:3 13370:20150926:143715.680 End of DCconfig_get_poller_items():0 13370:20150926:143715.681 End of get_pinger_hosts():0 13370:20150926:143715.681 In process_pinger_hosts() 13370:20150926:143715.681 End of process_pinger_hosts() 13370:20150926:143715.681 In DCconfig_get_poller_nextcheck() poller_type:3 13370:20150926:143715.681 End of DCconfig_get_poller_nextcheck():-1 13370:20150926:143715.681 icmp pinger #1 [got 0 values in 0.000182 sec, idle 5 sec] 13371:20150926:143715.681 server #15 started [alerter #1] 13371:20150926:143715.681 alerter [connecting to the database] 13371:20150926:143715.681 In DBconnect() flag:0 13372:20150926:143715.681 server #16 started [housekeeper #1] 13372:20150926:143715.682 housekeeper [startup idle for 30 minutes] 13373:20150926:143715.686 server #17 started [timer #1] 13373:20150926:143715.686 timer #1 [connecting to the database] 13373:20150926:143715.686 In DBconnect() flag:0 13374:20150926:143715.688 server #18 started [http poller #1] 13374:20150926:143715.688 http poller #1 [connecting to the database] 13374:20150926:143715.688 In DBconnect() flag:0 13376:20150926:143715.690 server #20 started [history syncer #1] 13376:20150926:143715.690 history syncer #1 [connecting to the database] 13376:20150926:143715.690 In DBconnect() flag:0 13377:20150926:143715.691 server #21 started [history syncer #2] 13377:20150926:143715.691 history syncer #2 [connecting to the database] 13377:20150926:143715.691 In DBconnect() flag:0 13378:20150926:143715.692 server #22 started [history syncer #3] 13378:20150926:143715.692 history syncer #3 [connecting to the database] 13378:20150926:143715.692 In DBconnect() flag:0 13358:20150926:143715.697 query without transaction detected 13358:20150926:143715.697 query [txnlev:0] [set schema 'public'] 13380:20150926:143715.698 server #24 started [escalator #1] 13380:20150926:143715.698 escalator [connecting to the database] 13380:20150926:143715.698 In DBconnect() flag:0 13381:20150926:143715.699 server #25 started [proxy poller #1] 13381:20150926:143715.699 proxy poller #1 [connecting to the database] 13381:20150926:143715.699 In DBconnect() flag:0 13379:20150926:143715.699 server #23 started [history syncer #4] 13379:20150926:143715.699 history syncer #4 [connecting to the database] 13379:20150926:143715.699 In DBconnect() flag:0 13358:20150926:143715.706 query [txnlev:0] [select oid from pg_type where typname='bytea'] 13382:20150926:143715.712 server #26 started [self-monitoring #1] 13382:20150926:143715.712 self-monitoring [processing data] 13382:20150926:143715.712 In collect_selfmon_stats() 13382:20150926:143715.712 End of collect_selfmon_stats() 13382:20150926:143715.712 self-monitoring [processed data in 0.000071 sec, idle 1 sec] 13358:20150926:143715.723 PostgreSQL Server version: 90404 13358:20150926:143715.723 query without transaction detected 13358:20150926:143715.723 query [txnlev:0] [set escape_string_warning to off] 13358:20150926:143715.737 query [txnlev:0] [show standard_conforming_strings] 13358:20150926:143715.739 query without transaction detected 13358:20150926:143715.739 query [txnlev:0] [set bytea_output=escape] 13358:20150926:143715.741 End of DBconnect():0 13358:20150926:143715.741 db watchdog [syncing configuration] 13358:20150926:143715.741 In sync_config() 13358:20150926:143715.741 query [txnlev:0] [select mt.mediatypeid,mt.type,mt.description,mt.smtp_server,mt.smtp_helo,mt.smtp_email,mt.exec_path,mt.gsm_modem,mt.username,mt.passwd,m.sendto from media m,users_groups u,config c,media_type mt where m.userid=u.userid and u.usrgrpid=c.alert_usrgrpid and m.mediatypeid=mt.mediatypeid and m.active=0 and mt.status=0] 13365:20150926:143715.775 query without transaction detected 13365:20150926:143715.775 query [txnlev:0] [set schema 'public'] 13365:20150926:143715.783 query [txnlev:0] [select oid from pg_type where typname='bytea'] 13365:20150926:143715.786 PostgreSQL Server version: 90404 13365:20150926:143715.786 query without transaction detected 13365:20150926:143715.786 query [txnlev:0] [set escape_string_warning to off] 13366:20150926:143715.792 query without transaction detected 13366:20150926:143715.792 query [txnlev:0] [set schema 'public'] 13366:20150926:143715.798 query [txnlev:0] [select oid from pg_type where typname='bytea'] 13358:20150926:143715.800 End of sync_config() values_num:0 13358:20150926:143715.800 db watchdog [synced alerts config in 0.141826 sec, idle 60 sec] 13366:20150926:143715.803 PostgreSQL Server version: 90404 13366:20150926:143715.803 query without transaction detected 13366:20150926:143715.803 query [txnlev:0] [set escape_string_warning to off] 13365:20150926:143715.814 query [txnlev:0] [show standard_conforming_strings] 13365:20150926:143715.815 query without transaction detected 13365:20150926:143715.815 query [txnlev:0] [set bytea_output=escape] 13365:20150926:143715.816 End of DBconnect():0 13365:20150926:143715.816 trapper #1 [processed data in 0.000000 sec, waiting for connection] 13368:20150926:143715.818 query without transaction detected 13368:20150926:143715.818 query [txnlev:0] [set schema 'public'] 13369:20150926:143715.819 query without transaction detected 13369:20150926:143715.819 query [txnlev:0] [set schema 'public'] 13367:20150926:143715.819 query without transaction detected 13367:20150926:143715.819 query [txnlev:0] [set schema 'public'] 13366:20150926:143715.819 query [txnlev:0] [show standard_conforming_strings] 13368:20150926:143715.820 query [txnlev:0] [select oid from pg_type where typname='bytea'] 13367:20150926:143715.820 query [txnlev:0] [select oid from pg_type where typname='bytea'] 13366:20150926:143715.821 query without transaction detected 13366:20150926:143715.821 query [txnlev:0] [set bytea_output=escape] 13369:20150926:143715.821 query [txnlev:0] [select oid from pg_type where typname='bytea'] 13367:20150926:143715.825 PostgreSQL Server version: 90404 13367:20150926:143715.825 query without transaction detected 13367:20150926:143715.825 query [txnlev:0] [set escape_string_warning to off] 13366:20150926:143715.825 End of DBconnect():0 13366:20150926:143715.825 trapper #2 [processed data in 0.000000 sec, waiting for connection] 13371:20150926:143715.826 query without transaction detected 13371:20150926:143715.826 query [txnlev:0] [set schema 'public'] 13373:20150926:143715.827 query without transaction detected 13373:20150926:143715.827 query [txnlev:0] [set schema 'public'] 13368:20150926:143715.829 PostgreSQL Server version: 90404 13368:20150926:143715.829 query without transaction detected 13368:20150926:143715.829 query [txnlev:0] [set escape_string_warning to off] 13376:20150926:143715.831 query without transaction detected 13376:20150926:143715.831 query [txnlev:0] [set schema 'public'] 13369:20150926:143715.835 PostgreSQL Server version: 90404 13369:20150926:143715.835 query without transaction detected 13369:20150926:143715.835 query [txnlev:0] [set escape_string_warning to off] 13378:20150926:143715.837 query without transaction detected 13378:20150926:143715.837 query [txnlev:0] [set schema 'public'] 13371:20150926:143715.838 query [txnlev:0] [select oid from pg_type where typname='bytea'] 13373:20150926:143715.838 query [txnlev:0] [select oid from pg_type where typname='bytea'] 13376:20150926:143715.838 query [txnlev:0] [select oid from pg_type where typname='bytea'] 13374:20150926:143715.838 query without transaction detected 13374:20150926:143715.838 query [txnlev:0] [set schema 'public'] 13378:20150926:143715.839 query [txnlev:0] [select oid from pg_type where typname='bytea'] 13377:20150926:143715.842 query without transaction detected 13377:20150926:143715.842 query [txnlev:0] [set schema 'public'] 13374:20150926:143715.842 query [txnlev:0] [select oid from pg_type where typname='bytea'] 13376:20150926:143715.845 PostgreSQL Server version: 90404 13376:20150926:143715.845 query without transaction detected 13376:20150926:143715.845 query [txnlev:0] [set escape_string_warning to off] 13377:20150926:143715.845 query [txnlev:0] [select oid from pg_type where typname='bytea'] 13374:20150926:143715.848 PostgreSQL Server version: 90404 13374:20150926:143715.848 query without transaction detected 13374:20150926:143715.848 query [txnlev:0] [set escape_string_warning to off] 13377:20150926:143715.849 PostgreSQL Server version: 90404 13377:20150926:143715.849 query without transaction detected 13377:20150926:143715.849 query [txnlev:0] [set escape_string_warning to off] 13367:20150926:143715.850 query [txnlev:0] [show standard_conforming_strings] 13368:20150926:143715.851 query [txnlev:0] [show standard_conforming_strings] 13369:20150926:143715.851 query [txnlev:0] [show standard_conforming_strings] 13379:20150926:143715.853 query without transaction detected 13379:20150926:143715.853 query [txnlev:0] [set schema 'public'] 13367:20150926:143715.853 query without transaction detected 13367:20150926:143715.853 query [txnlev:0] [set bytea_output=escape] 13368:20150926:143715.853 query without transaction detected 13368:20150926:143715.853 query [txnlev:0] [set bytea_output=escape] 13369:20150926:143715.853 query without transaction detected 13369:20150926:143715.853 query [txnlev:0] [set bytea_output=escape] 13373:20150926:143715.854 PostgreSQL Server version: 90404 13373:20150926:143715.854 query without transaction detected 13373:20150926:143715.854 query [txnlev:0] [set escape_string_warning to off] 13380:20150926:143715.854 query without transaction detected 13380:20150926:143715.854 query [txnlev:0] [set schema 'public'] 13371:20150926:143715.854 PostgreSQL Server version: 90404 13371:20150926:143715.854 query without transaction detected 13371:20150926:143715.854 query [txnlev:0] [set escape_string_warning to off] 13367:20150926:143715.855 End of DBconnect():0 13367:20150926:143715.855 trapper #3 [processed data in 0.000000 sec, waiting for connection] 13368:20150926:143715.855 End of DBconnect():0 13368:20150926:143715.855 trapper #4 [processed data in 0.000000 sec, waiting for connection] 13369:20150926:143715.855 End of DBconnect():0 13369:20150926:143715.855 trapper #5 [processed data in 0.000000 sec, waiting for connection] 13378:20150926:143715.855 PostgreSQL Server version: 90404 13378:20150926:143715.855 query without transaction detected 13378:20150926:143715.855 query [txnlev:0] [set escape_string_warning to off] 13379:20150926:143715.856 query [txnlev:0] [select oid from pg_type where typname='bytea'] 13381:20150926:143715.856 query without transaction detected 13381:20150926:143715.856 query [txnlev:0] [set schema 'public'] 13376:20150926:143715.856 query [txnlev:0] [show standard_conforming_strings] 13374:20150926:143715.856 query [txnlev:0] [show standard_conforming_strings] 13377:20150926:143715.856 query [txnlev:0] [show standard_conforming_strings] 13371:20150926:143715.856 query [txnlev:0] [show standard_conforming_strings] 13373:20150926:143715.857 query [txnlev:0] [show standard_conforming_strings] 13380:20150926:143715.857 query [txnlev:0] [select oid from pg_type where typname='bytea'] 13378:20150926:143715.857 query [txnlev:0] [show standard_conforming_strings] 13380:20150926:143715.860 PostgreSQL Server version: 90404 13380:20150926:143715.860 query without transaction detected 13380:20150926:143715.860 query [txnlev:0] [set escape_string_warning to off] 13371:20150926:143715.860 query without transaction detected 13371:20150926:143715.860 query [txnlev:0] [set bytea_output=escape] 13373:20150926:143715.860 query without transaction detected 13373:20150926:143715.860 query [txnlev:0] [set bytea_output=escape] 13381:20150926:143715.860 query [txnlev:0] [select oid from pg_type where typname='bytea'] 13376:20150926:143715.861 query without transaction detected 13376:20150926:143715.861 query [txnlev:0] [set bytea_output=escape] 13374:20150926:143715.861 query without transaction detected 13374:20150926:143715.861 query [txnlev:0] [set bytea_output=escape] 13377:20150926:143715.861 query without transaction detected 13377:20150926:143715.861 query [txnlev:0] [set bytea_output=escape] 13378:20150926:143715.861 query without transaction detected 13378:20150926:143715.861 query [txnlev:0] [set bytea_output=escape] 13379:20150926:143715.861 PostgreSQL Server version: 90404 13379:20150926:143715.861 query without transaction detected 13379:20150926:143715.861 query [txnlev:0] [set escape_string_warning to off] 13371:20150926:143715.862 End of DBconnect():0
Comment