title: Database monitoring - Item not supported
body: <p>I created an item for monitoring a value from a database table but it's "Not supported" without any further explanation, and I can't find any relevant documentation. A "getting started" guide on the various issues would have made <code>Zabbix</code> so, so much friendlier.</p>
  
  <p>Here's my configuration:</p>
  
  <p>Item name: RESPONSE_TIME</p>
  
  <p>Type: Database monitor</p>
  
  <p>Key: db.odbc.select[response_time]</p>
  
  <p>Username: </p>
  
  <p>Password: </p>
  
  <p>SQL Query: select RESPONSE_TIME from dbname.monitor_data order by action_timestamp desc limit 1;</p>
  
  <p>Type of information: Numeric unsigned (the value is a MySql INT)</p>
  
  <p>Interval: 50</p>
  
  <p>Store value: as is</p>
  
  <p>Show value: as is</p>
  
  <p>New Application: </p>
  
  <p>Applications: none</p>
  
  <p>Populate host inventory field: none</p>
  
  <p>Description: Monitors the response time for the latest action on dbname.monitor_data.</p>
  
  <p>The database was created on the MySql that comes with the Zabbix server installation. So it's sitting on the same host machine.</p>
  
  <p>There is no zabbix agent on the machine. The OS is Ubuntu 12.04.</p>
  
  <p>I installed ODBC but I'm not sure if it's configured correctly or not.</p>
  
  <p>Like I said, the item is "Not supported."</p>
  
  <p>What am I missing? </p>
  
  <p>EDIT: One problem was that my <code>ODBC</code> wasn't installed correctly. It is installed now and tested to work through <code>isql</code>: <code>sudo /usr/local/bin/isql -v eyalora</code></p>
  
  <p>I changed the Item key to <code>db.odbc.select["response_time",eyalora]</code> which seems to be the correct syntax, and now I'm getting the following error: <code>Cannot connect to ODBC DSN:[SQL_ERROR]:[01000][0][[unixODBC][Driver Manager]Can't open lib '/usr/lib' : file not found]|</code></p>
  
  <p>Is this a <code>ODBC</code> issue or a <code>Zabbix</code> issue? Do I have a permissions problem? 
  What's the next step? Do I need to relogin or something like that? </p>