help with zabbix

[mijaresey]

Good afternoon, I is presenting the following error, then place the .pgpass file and import it still gives me the following error 12207: 20150914: 182136,793 item "prueba_9.4:pgsql.get.pg.slow_query[{$PGSCRIPTDIR},{$PGSCRIPT_CONFDIR},{HOST.HOST},{$ZABBIX_AGENTD_CONF},{$PGSLOWQUERY_TIME_THRESHOLD}]" Became not supported: Received value [password for user postgres: psql: fe_sendauth: no password supplied] is not suitable for value type [Numeric (unsigned)] and data type [Decimal] 12205: 20150914: 182141,794 item "prueba_9.4:pgsql.get.pg.sr.status[{$PGSCRIPTDIR},{$PGSCRIPT_CONFDIR},{HOST.HOST},{$ZABBIX_AGENTD_CONF}]" Became not supported: Received value [password for user postgres: psql: fe_sendauth: no password supplied] is not suitable for value type [Numeric (unsigned)] and data tt ype [Decimal] 12205: 20150914: 182141,794 item "prueba_9.4:pgsql.get.pg.transactions[{$PGSCRIPTDIR},{$PGSCRIPT_CONFDIR},{HOST.HOST},{$ZABBIX_AGENTD_CONF}]" Became not supported: Received value [password for user postgres: psql: fe_sendauth: no password supplied] is not suitable for value type [Numeric (unsigned)] and datt to type [Decimal] 12206: 20150914: 182156,798 item "prueba_9.4: psql.primary_server [{$ PGSCRIPTDIR}, {$ PGSCRIPT_CONFDIR}]" Became not supported: Received value [Password for uu ser postgres: psql: fe_sendauth: no password supplied] is not suitable for value type [Numeric (unsigned)] and data type [Decimal] 12205: 20150914: 182206,799 item "prueba_9.4: psql.standby_server [{$ PGSCRIPTDIR}, {$ PGSCRIPT_CONFDIR}]" Became not supported: Received value [Password for uu ser postgres: psql: fe_sendauth: no password supplied] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]

I'm using postgresql 9.4, they appreciate what I could to help. thank you

[funzie19]

The credentials on the pgpass are not correct. To test the credentials login as it Zabbix user and try to connect to the database. You will probably get the password error the Zabbix agent is receiving. Once you fix the issue you should be able to login to the database without using a password.

[mijaresey]

my credentials in the pgpass are as follows : : *: postgres: #postgres# and do the same thing with another agent but this was in postgresql 9.3 , not whether versions have something to do

[PandaRoux8]

I have the same problem, but only for one database. I dont understand where this come from.

------------EDIT-------------- Ok my bad, it was only a bad config' in the pgpass

ip:port:databasename:username:password

I wrote something for the databasename and I changed that by a <*> and after a restart it worked fine

[nikhilkorde]

Hi Dear,

I have pass the pgpass file but same error can you help to resolve.,

060:20160127:111406.215 item "pp:psql.standby_server[{$PGSCRIPTDIR},{$PGSCRIP T_CONFDIR}]" became not supported: Received value [Password for user postgres: p sql: fe_sendauth: no password supplied] is not suitable for value type [Numeric (un

pgpass file in etc

localhost:5432:postgres:postgres

Thanks, Nik