Unable to provide check_snmp_int.pl data to Graphite and JasperReports

I am an absolute beginner with Icinga and I have already tried several desperate attempts at finding a solution to it.
After finally bringing check_snmp_int.pl to give me performance data I’ve tried to provide this data to JasperReports and Graphite.
I’ve googled several desperate hours but couldn’t find any answer. I can’t seem to find where check_snmp_int.pl saves it’s data for performance checks.

I’m working on:
Ubuntu 14.04
Icinga2 version:r2.5.4-1
IcingaWeb2 version 2.3.4

I have already installed the plugin check_snmp_int.pl.

object CheckCommand "check_snmp_int" {
    import "plugin-check-command"
    command = [PluginDir + "/check_snmp_int.pl"]
    arguments = {
            "-H" = "$snmp_address$"
            "-C" = "$snmp_community$"
            "-p" = "$snmp_port$"
            "-2" = {set_if = "$snmp_v2$"}
         "-o" = "$snmp_oid$"
            "-f" = {set_if = "$snmp_perf$"}
            "-w" = "$snmp_warn$"
            "-c" = "$snmp_crit$"

This is the service I have implemented with the plugin.

apply Service "bandbreitenueberwachung" {
    check(unknown) at 12:40 ..._int"
    check_interval = 5m
    assign where host.vars.os == "Switch"

tldr: where does check_snmp_int.pl save data and where does it retrieve it’s data so I can use them in IcingaWeb.



Graphite SQLite3 DatabaseError: database is locked

While going through the initial installation and set up of Graphite on CentOS 6.4 using Apache mod_wsgi via the stock graphite-web rpm, I’m getting the following “DatabaseError: database is locked” message:

mod_wsgi (pid=9009): Target WSGI script '/usr/share/graphite/graphite-web.wsgi' cannot be loaded as Python module.
mod_wsgi (pid=9009): Exception occurred processing WSGI script '/usr/share/graphite/graphite-web.wsgi'.
Traceback (most recent call last):
  File "/usr/share/graphite/graphite-web.wsgi", line 16, in <module>
    import graphite.metrics.search
  File "/usr/lib/python2.6/site-packages/graphite/metrics/search.py", line 6, in <module>
    from graphite.storage import is_pattern, match_entries
  File "/usr/lib/python2.6/site-packages/graphite/storage.py", line 7, in <module>
    from graphite.remote_storage import RemoteStore
  File "/usr/lib/python2.6/site-packages/graphite/remote_storage.py", line 8, in <module>
    from graphite.util import unpickle
  File "/usr/lib/python2.6/site-packages/graphite/util.py", line 82, in <module>
  File "/usr/lib/python2.6/site-packages/django/db/models/base.py", line 460, in save
    self.save_base(using=using, force_insert=force_insert, force_update=force_update)
  File "/usr/lib/python2.6/site-packages/django/db/models/base.py", line 553, in save_base
    result = manager._insert(values, return_id=update_pk, using=using)
  File "/usr/lib/python2.6/site-packages/django/db/models/manager.py", line 195, in _insert
    return insert_query(self.model, values, **kwargs)
  File "/usr/lib/python2.6/site-packages/django/db/models/query.py", line 1436, in insert_query
    return query.get_compiler(using=using).execute_sql(return_id)
  File "/usr/lib/python2.6/site-packages/django/db/models/sql/compiler.py", line 791, in execute_sql
    cursor = super(SQLInsertCompiler, self).execute_sql(None)
  File "/usr/lib/python2.6/site-packages/django/db/models/sql/compiler.py", line 735, in execute_sql
    cursor.execute(sql, params)
  File "/usr/lib/python2.6/site-packages/django/db/backends/util.py", line 34, in execute
    return self.cursor.execute(sql, params)
  File "/usr/lib/python2.6/site-packages/django/db/backends/sqlite3/base.py", line 234, in execute
    return Database.Cursor.execute(self, query, params)
DatabaseError: database is locked

I’ve verified that the DB file (“/var/lib/graphite-web/graphite.db“) is accessible by the apache user which owns the httpd process.

Also, I’ve tried restarting both the httpd and the carbon-cache processes as mentioned in this thread on github.

A list of lsof shows the following:

# lsof | grep graphite.db
httpd      9006    apache   17u      REG              253,2    69632     526186 /var/lib/graphite-web/graphite.db
httpd      9007    apache   17u      REG              253,2    69632     526186 /var/lib/graphite-web/graphite.db
httpd      9008    apache   17u      REG              253,2    69632     526186 /var/lib/graphite-web/graphite.db
httpd      9008    apache   22u      REG              253,2    69632     526186 /var/lib/graphite-web/graphite.db
httpd      9009    apache   17u      REG              253,2    69632     526186 /var/lib/graphite-web/graphite.db
httpd      9009    apache   22u      REG              253,2    69632     526186 /var/lib/graphite-web/graphite.db
httpd      9010    apache   17ur     REG              253,2    69632     526186 /var/lib/graphite-web/graphite.db
httpd      9010    apache   18u      REG              253,2      512     526174 /var/lib/graphite-web/graphite.db-journal
httpd      9010    apache   24ur     REG              253,2    69632     526186 /var/lib/graphite-web/graphite.db
httpd      9011    apache   17u      REG              253,2    69632     526186 /var/lib/graphite-web/graphite.db
httpd      9012    apache   17u      REG              253,2    69632     526186 /var/lib/graphite-web/graphite.db
httpd      9013    apache   17u      REG              253,2    69632     526186 /var/lib/graphite-web/graphite.db

In my mind it’s got to be related to httpd, but I’m not getting anywhere with it.