Hi,
I used GIT using following script
Thanks
# Icinga (with icinga-web) Ubuntu 10.10 Server Post-install Script
> # Chuck Dudley
> # April 9, 2011
>
> # Starts with a base 10.10 server installation, no packages/groups added
> during OS installation. Then
> # do
> apt-get update
> apt-get dist-upgrade
> # to get caught up
>
>
> # Post installation package installs
> # (git added to end of line, as I am pulling from repository. Omit git if
> you are using tarball)
>
> apt-get install apache2 build-essential libgd2-xpm-dev libjpeg62
> libjpeg62-dev libpng12-0 libpng12-dev mysql-server mysql-client libdbi0
> libdbi0-dev libdbd-mysql php5 php5-cli php-pear php5-xmlrpc php5-xsl
> php5-gd php5-ldap php5-mysql git
>
>
> # Add users/groups
>
> useradd -m icinga
> groupadd icinga-cmd
> usermod -a -G icinga-cmd icinga
> usermod -a -G icinga-cmd www-data
>
>
> # Get Icinga source from git repository
>
> cd /usr/src
> git clone git://git.icinga.org/icinga-core.git
> cd icinga-core
> git pull
> git submodule init
>
> # Add icinga-api source
>
> cd module
> git clone git://git.icinga.org/icinga-api.git
> cd icinga-api
> git pull
> git submodule init
>
> #Add icinga-web source
>
> cd ..
> git clone git://git.icinga.org/icinga-web.git
> cd icinga-web
> git pull
> git submodule init
>
>
> # Configure, make and (full)install Icinga
>
> cd /usr/src/icinga-core
> ./configure --with-command-group=icinga-cmd --enable-idoutils
> make all
> make fullinstall
>
>
> # Configure and install Icinga-web
>
> cd /usr/src/icinga-core/module/icinga-web
> ./configure
> make install
> make install-apache-config
>
>
> # Grab Nagios Plugins tarball. Untar, configure, make and install
>
> cd /usr/src
> wget
> https://downloads.sourceforge.net/project/nagiosplug/nagiosplug/1.4.16/nagios-plugins-1.4.16.tar.gz
> tar xzf nagios-plugins-1.4.16.tar.gz
> cd nagios-plugins-1.4.16/
> ./configure --prefix=/usr/local/icinga --with-cgiurl=/icinga/cgi-bin
> --with-htmurl=/icinga --with-nagios-user=icinga --with-nagios-group=icinga
> make
> make install
>
>
> # Create MySQL icinga DB and user. Create idoutils tables.
>
> echo -e "\a!!!!!!!!!! Next four password prompts are for the MySQL
> root password you just set. !!!!!!!!!!\a"
> mysql -u root -p <<Gfn123
> CREATE DATABASE icinga;
> GRANT USAGE ON *.* TO 'icinga'@'localhost' IDENTIFIED BY 'icinga' WITH
> MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0;
> GRANT SELECT , INSERT , UPDATE , DELETE ON icinga.* TO 'icinga'@
> 'localhost';
> FLUSH PRIVILEGES ;
> quit
> HERE
>
> mysql -u root -p icinga <
> /usr/src/icinga-core/module/idoutils/db/mysql/mysql.sql
>
>
> # Create MySQL icinga-web DB and user. Create icinga-web tables.
>
> mysql -u root -p <<HERE
> CREATE DATABASE icinga_web;
> GRANT USAGE ON *.* TO 'icinga_web'@'localhost' IDENTIFIED BY 'icinga_web'
> WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR
> 0;
> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, INDEX ON
> icinga_web.* TO 'icinga_web'@'localhost';
> quit
> HERE
>
> mysql -u root -p icinga_web <
> /usr/src/icinga-core/module/icinga-web/etc/schema/mysql.sql
>
>
> # Rename sample config files, enable broker module
>
> cd /usr/local/icinga/etc/
> mv ido2db.cfg-sample ido2db.cfg
> mv idomod.cfg-sample idomod.cfg
> sed -i '247 s/^.//' /usr/local/icinga/etc/icinga.cfg
> # ^^^ (Depends on broker config being line 247. Might want to check
> to make sure this hasn't changed.)
>
>
>
> # Set UI icingaadmin pw.
>
> echo -e "\a!!!!!!!!!! The new password prompt below is to set the web
> UI icingaadmin password. !!!!!!!!!!\a"
> htpasswd -c /usr/local/icinga/etc/htpasswd.users icingaadmin
> a2enmod rewrite
> /etc/init.d/apache2 reload
>
>
> # Configure and start services
>
> /etc/init.d/ido2db start
> /etc/init.d/icinga start
> update-rc.d ido2db defaults
> update-rc.d icinga defaults
>
>
> # Running this script as root (sudo sh <scriptname>) against a base 10.10
> server install should
> # have you up and running without any additional fiddling around. Let me
> know if you see a better way
> # to do this, or any glaring errors.
>
On Mon, Aug 13, 2012 at 4:34 PM, Markus Frosch <mar...@lazyfrosch.de> wrote:
> Hello Tal,
>
> >> Exception thrown: SQLSTATE[42S22]: Column not found: 1054 Unknown column
> >> 'c.cronk_system' in 'field list'
>
> Which version did you install?
>
> Have you installed it from the source tarball?
>
> Regards
> Markus
>
> --
> Markus Frosch
> mar...@lazyfrosch.de
> http://www.lazyfrosch.de
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> icinga-users mailing list
> icinga-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/icinga-users
>
--
Tal Bar-or
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
icinga-users mailing list
icinga-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/icinga-users
