[Icinga-devel] Review & IDOUTILS (trying SQLite)

mareadmin mail at mare-system.de
Wed May 13 20:41:27 CEST 2009


Hi there,

just done a setup from incinga.git, trying to 
get it working in the first step and then,
afterwards, trying to come as close as possible 
to get idoutils working with sqlite_database; well,
in short, last step was FAIL ;-)

you'll find the whole transcript with lots of 
command_line_outputs from configure and make and
so on here: http://www.mare-system.de/dev/icinga_installation.html

installtion-machien was an actual blank debian5 with lamp and
nagios-plugins/nrpe installed. 

- additional installed software:

aptitude install libgd2 libgd-dev   libgd-gd2-perl   libgd-graph-perl  libgd-tools 
aptitude install libgd2-xpm-dev  libgd2 
aptitude install libdbi0-dev  libdbi0 libdbd-mysql  libdbd-sqlite3   libdbd-odbc-perl libdbd-pgsql
aptitude install libembperl-perl



- because i had time today to lurk here:

groupadd  icinga
sudo useradd -g icinga  -m icinga

- configuring with –enable-embedded-perl failed (installing 
  libembperl-perl doesnt work), so i used the following configuring options: 

./configure --prefix=$HOME/icinga_devel --disable-statuswrl --enable-nanosleep \
   --enable-event-broker  --enable-idoutils 

make all
sudo make install && sudo make install-init && sudo make install-commandmode && sudo make install-idoutils && sudo make install-config

- no problems so far, beside some backup_copies in left in installdir/etc/*.*~ 
  after a new installation

- apache_conf from src_dir/sample-config/httpd.conf is NOT installed during any
  make_stuff (SHOULD), so copied to /etc/apache2/confd && apache_restart

- install_dir/etc/htpasswd.users is not present (SHOULD) after installation;
  created file an added icingaadmin / password to it (this file shoudl be
  there an contain some default_user/password , like icingaadmin/nagios or so)

- login after this changes was ok (oh ... nice interface ;-)

- last thing: moified resources.conf and changed $USER1$ to an actual existing
  plugin_directory, et voila,! everythin is green now


that was part one of installation, beside some little bugs which could be 
done easily, no problems

part 2 was trying to get sqlite work as a database-backend for idoutils, or 
at least try to come as far as possible

at first i changed mysql.sql,which was no so tricky, to work with a
sqlite_database; next steps was trying to get ido2db working; 
running as icinga_user bin/ido2db -c etc/ido2db.cfg from icinga_install_dir 
works so far, but db_servertype=sqlite will not work ... 

from ido2db.c / line 332ff

	else if(!strcmp(var,"db_servertype")){
		if(!strcmp(val,"mysql"))
			ndo2db_db_settings.server_type=NDO2DB_DBSERVER_MYSQL;
		else if(!strcmp(val,"pgsql"))
			ndo2db_db_settings.server_type=NDO2DB_DBSERVER_PGSQL;
		else
			return NDO_ERROR;
	        }


at least, no other database-backend than mysql/pgsql implemented
yet, and since sqlite is a file_based bms and not server/client_based
the source of at least ido2db.c has to be modified 

so far, so good. 


if no one cries HERE!! I DID IT i'll check ido2db/postgres next time




Markus Manzke


MARE System Kiel   .:.   http://www.mare-system.de






More information about the icinga-devel mailing list