See www.zabbix.com for the official Zabbix site.
DB2 Installation Cookbook
Contents |
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;
