Give zabbix root permissions?

[Eithco]

I'm trying to monitor a database table and running into what seems like a permissions issue.

The "Not supported" Item message is "Cannot connect to ODBC DSN:[SQL_ERROR]:[01000][0][[unixODBC][Driver Manager]Can't open lib '/usr/lib' : file not found]|"

/usr/lib is obviously owned by root. The library itself (the Driver) is /usr/lib/odbc/libmyodbc.so and it's also owned by root.

I'm not sure how to approach this. If I'm not mistaken zabbix is running on my own user? How do I find out? (my user and root are the only ones on this Ubuntu machine.)

I chowned /usr/lib/odbc/libmyodbc.so to myuser:mysuer but zabbix still gives the same error message.

Is there a solution for this 2 day miery?



The key I'm using: db.odbc.select["response_time",eyalora]

[martijnatlico]

The fact that /usr/lib/odbc/libmyodbc.so and /usr/lib are owned by root is not the cause of your problem. As long as the permissions are set correctly (644 on the file and 755 on all the directories) zabbix will have no problem accessing it.

We need more information, like what does the UserParameter db.odbc.select do?

[martijnatlico]

Never mind my earlier post (still awaiting moderation), I was unfamiliar with the Database monitor. But meanwhile I saw your two other topics on this same subject. Please don't keep making new topics for the same issue.