See www.zabbix.com for the official Zabbix site.

DB2 Installation Cookbook

From Zabbix.org
Jump to: navigation, search

zabbix installation notes

Prerequisites

Must have the SUSE Linux Enterprise Software Development Kit 11 Service Pack 1 discs 1 and 2. SUSE® Linux* Enterprise SDK is available for download for each available platform as two DVD ISO images. DVD1 contains the binary packages, DVD2 the source code. SLES 11SP1 SDK DOWNLOAD

Adding the SDK During Installation

To add the SDK while installing SUSE Linux Enterprise 11 Service Pack 1, select the Include Add-On Products from Separate Media box on the Installation Mode screen. Depending on your installation, you can add the SDK from DVD1 or from a remote installation SDK source, such as an FTP server, on the next screen.

Adding the SDK After Installation

To add the SDK after you have already installed SUSE Linux Enterprise 11 Service Pack 1, start YaST2. Go to Software - Add-On Products add DVD1 of the SDK or a remote installation SDK source. You can then either manually select the specific packages you want to install, or choose from the predefined patterns under the Install and Remove Software option. If you don't find a specific package that you need in any of the suggested usage patterns, try the package search. Some packages might not be included in a pattern.

Install DB2 9.7

download from DB2

Install Zend PHP

Prerequisites

prereq's:libxml2-devel, openssl-devel, curl-devel, libjpeg-devel, libpng-devel, gmp-devel, ncurses-devel, net-snmp-devel, libxslt-devel

troubleshooting

Error posts on config:

configure: error: libpng.(a|so) not found.<pre>
copy files from /usr/lib64 to /usr/lib i.e.
<pre>cp /usr/lib64/libpng.so /usr/lib/ 

download, unpack and run addrepo script

prereq: mount the SLES11sp1 Disk register and download script at zend.com
install Zend Server, change into the directory extracted from this package and run the following command, as root or using sudo:

 
./install_zs.sh 5.3 ce
# or
sudo ./install_zs.sh 5.3 ce 

Post Installation Config

Install the PECL DB2 Module

/usr/local/zend/bin/pecl install ibm_db2

this will ask for the db2 installation directory...

/opt/ibm/db2/V9.7/

Restart Apache for settings to take effect

/usr/local/zend/bin/zendctl.sh restart

verify

pecl list
php -m

Edit php.ini

change "/usr/local/zend/etc/php.ini"

vi /usr/local/zend/etc/php.ini

#line 440 from
max_execution_time = 30      ; Maximum execution time of each script, in seconds 
#to
max_execution_time = 600     ; Maximum execution time of each script, in seconds

#line 450 from
max_input_time = 60    ; Maximum amount of time each script may spend parsing request data
#to
max_input_time = 600    ; Maximum amount of time each script may spend parsing request data

#ling 458 from
memory_limit = 128M
#to
memory_limit = 256M  

#line 728 from
post_max_size = 8M to 
post_max_size = 32M

#line 879
upload_max_filesize = 2M  to 
upload_max_filesize = 16M

#Line 992
uncomment by removing ;
date.timezone = America/New_York

Check your work

Perform these sanity checks to verify your install went OK:

$ /usr/local/apache2/bin/httpd -t
Syntax OK

$ /usr/local/apache2/bin/httpd -v
Server version: Apache/2.2.17
Server built:   March 29 2011 12:40:55


$ /usr/local/apache2/bin/httpd -V
Server version: Apache/2.2.17
Server built:   March 29 2011 12:40:55
Server's Module Magic Number: 20051115:2
Server loaded:  APR 1.2.7, APR-Util 1.2.7
Compiled using: APR 1.2.7, APR-Util 1.2.7
Architecture:   32-bit
Server MPM:     Prefork
  threaded:     no
    forked:     yes (variable process count)
Server compiled with....
 -D APACHE_MPM_DIR="server/mpm/prefork"
 -D APR_HAS_SENDFILE
 -D APR_HAS_MMAP
 -D APR_HAVE_IPV6 (IPv4-mapped addresses enabled)
 -D APR_USE_SYSVSEM_SERIALIZE
 -D APR_USE_PTHREAD_SERIALIZE
 -D SINGLE_LISTEN_UNSERIALIZED_ACCEPT
 -D APR_HAS_OTHER_CHILD
 -D AP_HAVE_RELIABLE_PIPED_LOGS
 -D DYNAMIC_MODULE_LIMIT=128
 -D HTTPD_ROOT="/usr/local/apache"
 -D SUEXEC_BIN="/usr/local/apache/bin/suexec"
 -D DEFAULT_PIDLOG="logs/httpd.pid"
 -D DEFAULT_SCOREBOARD="logs/apache_runtime_status"
 -D DEFAULT_LOCKFILE="logs/accept.lock"
 -D DEFAULT_ERRORLOG="logs/error_log"
 -D AP_TYPES_CONFIG_FILE="conf/mime.types"
 -D SERVER_CONFIG_FILE="conf/httpd.conf"

$ /usr/local/apache2/bin/httpd -S
VirtualHost configuration:
. . .

$ /usr/local/apache2/bin/httpd -l
Compiled in modules:
  core.c
  . . .
  mod_so.c

$ /usr/local/apache2/bin/httpd -M
Loaded Modules:
. . .
 php5_module (shared)
Syntax OK

(the above works for Apache 2.2.x and higher only)

$ ps -ef |grep httpd
root     24069     1  0 09:17 ?        00:00:08 /usr/local/apache2/bin/httpd -k s
apache   29917 24069  0 15:30 ?        00:00:00 /usr/local/apache2/bin/httpd -k s
. . .

Install Zabbix

download zabbix

 wget http://prdownloads.sourceforge.net/zabbix/zabbix-1.8.5.tar.gz

Prep for DB

grant access to create DB min /data FS

chown db2inst1:zabbix /data

create the DB and grant access to zabbix user

sudo su - db2inst1
db2 "CREATE DB ZABBIX AUTOMATIC STORAGE YES ON /data DBPATH ON /data USING CODESET UTF-8 TERRITORY US PAGESIZE 32768;
db2 CONNECT TO ZABBIX;
db2 GRANT  CREATETAB,CONNECT,IMPLICIT_SCHEMA,LOAD ON DATABASE  TO USER ZABBIX;
db2 CONNECT RESET;

Configuration