Expressions in 1.1b9 not working correctly

[bdub]

I'm not sure if this is my fault or a bug, either way, I'm on a looming deadline to get this working, so any help would be appreciated.

I'm attempting the following trigger:

{testbed:mysql[ping].max(300)}=1

The graph for this trigger is constantly showing [No Data]

My agentd.conf file looks like this:
###################################

Server=10.5.5.10
# Server port for sending active checks
ServerPort=10051
Hostname=dingey
ListenPort=10050
#ListenIP=127.0.0.1
StartAgents=5
# How often refresh list of active checks. 2 minutes by default.
#RefreshActiveChecks=120
#DisableActive=1
#EnableRemoteCommands=1
DebugLevel=4
PidFile=/var/tmp/zabbix_agentd.pid
LogFile=/tmp/zabbix_agentd.log
Timeout=3
UserParameter=mysql.ping,mysqladmin -uroot -p <password> ping|grep alive|wc -l

#########################################

My agentd.log looks OK:
002558:20060502:102011 Before read
002558:20060502:102011 In delete_all_metrics()
002558:20060502:102011 Parsed [ZBX_EOF]
002558:20060502:102011 Sleeping for 60 seconds
002558:20060502:102111 Sleeping for 60 seconds
002558:20060502:102211 In refresh_metrics()
002558:20060502:102211 get_active_checks: host[10.5.5.10] port[10051]
002558:20060502:102211 Sending [ZBX_GET_ACTIVE_CHECKS
dingey
]
002558:20060502:102211 Before read
002558:20060502:102211 In delete_all_metrics()
002558:20060502:102211 Parsed [ZBX_EOF]
002558:20060502:102211 Sleeping for 60 seconds

But my server log is showing the following errors:

004050:20060502:095848 Expression [{11256}=0] cannot be evaluated [Unable to get value for functionid [11256]]
004053:20060502:095900 Evaluation of expression [{11237}=0] failed [Unable to get value for functionid [11237]]
004053:20060502:095900 Expression [{11237}=0] cannot be evaluated [Unable to get value for functionid [11237]]
004053:20060502:095901 Evaluation of expression [{11238}=0] failed [Unable to get value for functionid [11238]]
004053:20060502:095901 Expression [{11238}=0] cannot be evaluated [Unable to get value for functionid [11238]]
004053:20060502:095930 Evaluation of expression [{11237}=0] failed [Unable to get value for functionid [11237]]
004053:20060502:095930 Expression [{11237}=0] cannot be evaluated [Unable to get value for functionid [11237]]
004053:20060502:095930 Evaluation of expression [{11238}=0] failed [Unable to get value for functionid [11238]]
004053:20060502:095930 Expression [{11238}=0] cannot be evaluated [Unable to get value for functionid [11238]]

If anyone has any ideas of where else I can look, something else I could troubleshoot, or any other ideas as to what could be wrong, I'd GREATLY appreciate any help you can provide.

Thanks much!

brian

[krusty]

It´s only an idea.

I use in zabbix_agentd.conf this

UserParameter=mysql.ping,mysqladmin -uroot -p<password> ping|grep alive|wc -l

This works for me. (use -p without space character).

Perhaps this was the fault

[nikoula]

re : Expressions in 1.1b9 not working correctly

If you look carefully at the UserParameter and the item you can find that thay're different.

Userparam : mysql.ping
Item : mysql[ping]

I've the same problem and i've change my item key to "mysql.ping", everything goes fine now for this point

[bdub]

If you look carefully at the UserParameter and the item you can find that thay're different.

Userparam : mysql.ping
Item : mysql[ping]

I've the same problem and i've change my item key to "mysql.ping", everything goes fine now for this point

I did that, and still no dice.

It´s only an idea.

I use in zabbix_agentd.conf this

UserParameter=mysql.ping,mysqladmin -uroot -p<password> ping|grep alive|wc -l

This works for me. (use -p without space character).

Perhaps this was the fault

Actually, since I'm troubleshooting this issue, I've removed the password from the database. So, from the command line, the parameter works

brian@testbed:/tmp$ mysqladmin -u root ping
mysqld is alive
brian@testbed:/tmp$ mysqladmin -uroot ping|grep alive|wc -l
1

This is a little frustrating!

Anyone have any other ideas as to what could be wrong? I very much want my company to adopt this as our primary monitoring tool, but I need the mysql check to work...

Thanks so much for your help thus far guys...

brian

[KarmaPolice]

how do you have the item defined on the front end?

[bdub]

I'm using the stock "Application.MySQL is Alive" item.

Type: Zabbix Agent
Key: mysql.ping (changed from mysql[ping] as previously reccomended)
Type of Info: Numeric (float)
Units: blank
Multiplier: Do Not Use
Update Int.: 60 seconds
keep in history: 7 days
keep trends: 365
status: monitored
store value: as is