Monday, September 20, 2010

How to install GeoIP and mod_geoip2 on RHEL/Cent OS for apache

How to install GeoIP and mod_geoip2 on centos for apache
1) yum install GeoIP GeoIP-devel GeoIP-data zlib-devel
2) mkdir /usr/local/share/GeoIP
3) Download the latest Country and City database files from maxmind
cd /usr/local/share/GeoIP
wget http://geolite.maxmind.com/download/geoip/database/GeoLiteCountry/GeoIP.dat.gz
wget http://geolite.maxmind.com/download/geoip/database/GeoLiteCity.dat.gz
gunzip GeoIP.dat.gz
gunzip GeoLiteCity.dat.gz
4) yum install httpd-devel apr-devel
5) wget http://geolite.maxmind.com/download/geoip/api/mod_geoip2/
6) tar xvzf mod_geoip2_1.2.5.tar.gz && cd mod_geoip2_1.2.5
7) apxs -i -a -L/usr/lib64 -I/usr/include -lGeoIP -c mod_geoip.c
8) Enabling mod-geoip
Nothing’s going to work unless mod-geoip is enabled in your apache configuration. You’ll need the following lines in your httpd.conf file (located on CentOS systems at /etc/httpd/conf/httpd.conf)
IfModule mod_geoip.c
GeoIPEnable On
GeoIPDBFile /usr/local/share/GeoIP/GeoIP.dat Standard
GeoIPDBFile /usr/local/share/GeoIP/GeoLiteCity.dat Standard
IfModule
9) Restart Apache so your changes will take effect by entering the following command.
#/etc/init.d/httpd restart
10) /usr/local/bin/geoipupdate

Wednesday, September 15, 2010

Install tomcat6 in 3 step Cent OS

cd /etc/yum.repos.d
wget 'http://www.jpackage.org/jpackage50.repo'
yum install tomcat6 tomcat6-webapps tomcat6-admin-webapps
service tomcat6 start
 http://localhost:8080

Thursday, September 9, 2010

Installation and configuration wordpress in 5 min

rpm -Uhv http://apt.sw.be/redhat/el5/en/i386/rpmforge/RPMS/rpmforge-release-0.3.6-1.el5.rf.i386.rpm

yum install mysql mysql-server httpd php php-mysql php-gd php-imap php-ldap php-odbc php-pear php-xml php-xmlrpc phpmyadmin

Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
rightscale-epel                                          |  951 B     00:00    
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package httpd.i386 0:2.2.3-31.el5.centos.4 set to be updated
---> Package mysql.i386 0:5.0.77-4.el5_4.2 set to be updated
--> Processing Dependency: perl(DBI) for package: mysql
---> Package mysql-server.i386 0:5.0.77-4.el5_4.2 set to be updated
--> Processing Dependency: perl-DBD-MySQL for package: mysql-server
---> Package php.i386 0:5.2.4-el5.centos set to be updated
--> Processing Dependency: php-common = 5.2.4-el5.centos for package: php
--> Processing Dependency: php-cli = 5.2.4-el5.centos for package: php
---> Package php-gd.i386 0:5.2.4-el5.centos set to be updated
---> Package php-imap.i386 0:5.2.4-el5.centos set to be updated
--> Processing Dependency: libc-client.so.1 for package: php-imap
---> Package php-ldap.i386 0:5.2.4-el5.centos set to be updated
---> Package php-mysql.i386 0:5.2.4-el5.centos set to be updated
--> Processing Dependency: php-pdo for package: php-mysql
---> Package php-odbc.i386 0:5.2.4-el5.centos set to be updated
--> Processing Dependency: libodbcpsql.so.2 for package: php-odbc
--> Processing Dependency: libodbc.so.1 for package: php-odbc
---> Package php-pear.noarch 1:1.4.9-6.el5 set to be updated
--> Processing Dependency: php-devel for package: php-pear
---> Package php-xml.i386 0:5.2.4-el5.centos set to be updated
--> Processing Dependency: libexslt.so.0 for package: php-xml
--> Processing Dependency: libxslt.so.1 for package: php-xml
---> Package php-xmlrpc.i386 0:5.2.4-el5.centos set to be updated
---> Package phpMyAdmin.noarch 0:2.11.10-1.el5 set to be updated
--> Processing Dependency: php-mcrypt >= 4.1.0 for package: phpMyAdmin
--> Processing Dependency: php-mbstring >= 4.1.0 for package: phpMyAdmin
--> Running transaction check
---> Package libc-client.i386 0:2004g-2.2.1 set to be updated
---> Package libxslt.i386 0:1.1.17-2.el5_2.2 set to be updated
---> Package perl-DBD-MySQL.i386 0:3.0007-2.el5 set to be updated
---> Package perl-DBI.i386 0:1.52-2.el5 set to be updated
---> Package php-cli.i386 0:5.2.4-el5.centos set to be updated
---> Package php-common.i386 0:5.2.4-el5.centos set to be updated
---> Package php-devel.i386 0:5.2.4-el5.centos set to be updated
---> Package php-mbstring.i386 0:5.2.4-el5.centos set to be updated
---> Package php-mcrypt.i386 0:5.2.4-el5.centos set to be updated
--> Processing Dependency: libmcrypt.so.4 for package: php-mcrypt
---> Package php-pdo.i386 0:5.2.4-el5.centos set to be updated
---> Package unixODBC.i386 0:2.2.11-7.1 set to be updated
--> Running transaction check
---> Package libmcrypt.i386 0:2.5.8-4.el5.centos set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package           Arch      Version                   Repository          Size
================================================================================
Installing:
 httpd             i386      2.2.3-31.el5.centos.4     updates            1.2 M
 mysql             i386      5.0.77-4.el5_4.2          updates            4.8 M
 mysql-server      i386      5.0.77-4.el5_4.2          updates            9.8 M
 php               i386      5.2.4-el5.centos          rightscale-epel    3.6 M
 php-gd            i386      5.2.4-el5.centos          rightscale-epel    319 k
 php-imap          i386      5.2.4-el5.centos          rightscale-epel    103 k
 php-ldap          i386      5.2.4-el5.centos          rightscale-epel     56 k
 php-mysql         i386      5.2.4-el5.centos          rightscale-epel    261 k
 php-odbc          i386      5.2.4-el5.centos          rightscale-epel    112 k
 php-pear          noarch    1:1.4.9-6.el5             base               344 k
 php-xml           i386      5.2.4-el5.centos          rightscale-epel    309 k
 php-xmlrpc        i386      5.2.4-el5.centos          rightscale-epel    129 k
 phpMyAdmin        noarch    2.11.10-1.el5             epel               4.2 M
Installing for dependencies:
 libc-client       i386      2004g-2.2.1               base               516 k
 libmcrypt         i386      2.5.8-4.el5.centos        extras             116 k
 libxslt           i386      1.1.17-2.el5_2.2          base               485 k
 perl-DBD-MySQL    i386      3.0007-2.el5              base               148 k
 perl-DBI          i386      1.52-2.el5                base               600 k
 php-cli           i386      5.2.4-el5.centos          rightscale-epel    2.6 M
 php-common        i386      5.2.4-el5.centos          rightscale-epel    352 k
 php-devel         i386      5.2.4-el5.centos          rightscale-epel    553 k
 php-mbstring      i386      5.2.4-el5.centos          rightscale-epel    1.3 M
 php-mcrypt        i386      5.2.4-el5.centos          rightscale-epel     44 k
 php-pdo           i386      5.2.4-el5.centos          rightscale-epel    157 k
 unixODBC          i386      2.2.11-7.1                base               832 k

Transaction Summary
================================================================================
Install     25 Package(s)        
Update       0 Package(s)        
Remove       0 Package(s)        

Total download size: 33 M
Is this ok [y/N]: y
Downloading Packages:
(1/25): php-mcrypt-5.2.4-el5.centos.i386.rpm             |  44 kB     00:00    
(2/25): php-ldap-5.2.4-el5.centos.i386.rpm               |  56 kB     00:00    
(3/25): php-imap-5.2.4-el5.centos.i386.rpm               | 103 kB     00:00    
(4/25): php-odbc-5.2.4-el5.centos.i386.rpm               | 112 kB     00:00    
(5/25): libmcrypt-2.5.8-4.el5.centos.i386.rpm            | 116 kB     00:00    
(6/25): php-xmlrpc-5.2.4-el5.centos.i386.rpm             | 129 kB     00:00    
(7/25): perl-DBD-MySQL-3.0007-2.el5.i386.rpm             | 148 kB     00:00    
(8/25): php-pdo-5.2.4-el5.centos.i386.rpm                | 157 kB     00:00    
(9/25): php-mysql-5.2.4-el5.centos.i386.rpm              | 261 kB     00:00    
(10/25): php-xml-5.2.4-el5.centos.i386.rpm               | 309 kB     00:00    
(11/25): php-gd-5.2.4-el5.centos.i386.rpm                | 319 kB     00:00    
(12/25): php-pear-1.4.9-6.el5.noarch.rpm                 | 344 kB     00:00    
(13/25): php-common-5.2.4-el5.centos.i386.rpm            | 352 kB     00:00    
(14/25): libxslt-1.1.17-2.el5_2.2.i386.rpm               | 485 kB     00:00    
(15/25): libc-client-2004g-2.2.1.i386.rpm                | 516 kB     00:00    
(16/25): php-devel-5.2.4-el5.centos.i386.rpm             | 553 kB     00:00    
(17/25): perl-DBI-1.52-2.el5.i386.rpm                    | 600 kB     00:00    
(18/25): unixODBC-2.2.11-7.1.i386.rpm                    | 832 kB     00:00    
(19/25): httpd-2.2.3-31.el5.centos.4.i386.rpm            | 1.2 MB     00:00    
(20/25): php-mbstring-5.2.4-el5.centos.i386.rpm          | 1.3 MB     00:00    
(21/25): php-cli-5.2.4-el5.centos.i386.rpm               | 2.6 MB     00:00    
(22/25): php-5.2.4-el5.centos.i386.rpm                   | 3.6 MB     00:00    
(23/25): phpMyAdmin-2.11.10-1.el5.noarch.rpm             | 4.2 MB     00:00    
(24/25): mysql-5.0.77-4.el5_4.2.i386.rpm                 | 4.8 MB     00:00    
(25/25): mysql-server-5.0.77-4.el5_4.2.i386.rpm          | 9.8 MB     00:00    
--------------------------------------------------------------------------------
Total                                            15 MB/s |  33 MB     00:02    
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing     : php-common                                              1/25
  Installing     : perl-DBI                                                2/25
  Installing     : mysql                                                   3/25
  Installing     : php-cli                                                 4/25
  Installing     : php-pdo                                                 5/25
  Installing     : httpd                                                   6/25
  Installing     : php                                                     7/25
  Installing     : php-mysql                                               8/25
  Installing     : perl-DBD-MySQL                                          9/25
  Installing     : php-mbstring                                           10/25
  Installing     : libc-client                                            11/25
  Installing     : unixODBC                                               12/25
  Installing     : libxslt                                                13/25
  Installing     : libmcrypt                                              14/25
  Installing     : php-mcrypt                                             15/25
  Installing     : php-xml                                                16/25
  Installing     : php-odbc                                               17/25
  Installing     : php-imap                                               18/25
  Installing     : mysql-server                                           19/25
  Installing     : php-gd                                                 20/25
  Installing     : php-ldap                                               21/25
  Installing     : php-xmlrpc                                             22/25
  Installing     : php-devel                                              23/25
  Installing     : phpMyAdmin                                             24/25
  Installing     : php-pear                                               25/25

Installed:
  httpd.i386 0:2.2.3-31.el5.centos.4      mysql.i386 0:5.0.77-4.el5_4.2       
  mysql-server.i386 0:5.0.77-4.el5_4.2    php.i386 0:5.2.4-el5.centos         
  php-gd.i386 0:5.2.4-el5.centos          php-imap.i386 0:5.2.4-el5.centos    
  php-ldap.i386 0:5.2.4-el5.centos        php-mysql.i386 0:5.2.4-el5.centos   
  php-odbc.i386 0:5.2.4-el5.centos        php-pear.noarch 1:1.4.9-6.el5       
  php-xml.i386 0:5.2.4-el5.centos         php-xmlrpc.i386 0:5.2.4-el5.centos  
  phpMyAdmin.noarch 0:2.11.10-1.el5     

Dependency Installed:
  libc-client.i386 0:2004g-2.2.1          libmcrypt.i386 0:2.5.8-4.el5.centos  
  libxslt.i386 0:1.1.17-2.el5_2.2         perl-DBD-MySQL.i386 0:3.0007-2.el5   
  perl-DBI.i386 0:1.52-2.el5              php-cli.i386 0:5.2.4-el5.centos      
  php-common.i386 0:5.2.4-el5.centos      php-devel.i386 0:5.2.4-el5.centos    
  php-mbstring.i386 0:5.2.4-el5.centos    php-mcrypt.i386 0:5.2.4-el5.centos   
  php-pdo.i386 0:5.2.4-el5.centos         unixODBC.i386 0:2.2.11-7.1           

Complete!
[root@domU-12-31-39-13-CD-47 ~]# service httpd restart
Stopping httpd:                                            [FAILED]
Starting httpd:                                            [  OK  ]
[root@domU-12-31-39-13-CD-47 ~]# service mysqld restart
Stopping MySQL:                                            [FAILED]
Initializing MySQL database:  Installing MySQL system tables...
100909 12:57:03 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100909 12:57:03 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
OK
Filling help tables...
100909 12:57:03 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100909 12:57:03 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h domU-12-31-39-13-CD-47 password 'new-password'

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
                                                           [  OK  ]
Starting MySQL:                                            [  OK  ]
[root@domU-12-31-39-13-CD-47 ~]#

vi /etc/httpd/conf.d/phpMyAdmin.conf

# phpMyAdmin - Web based MySQL browser written in php
#
# Allows only localhost by default
#
# But allowing phpMyAdmin to anyone other than localhost should be considered
# dangerous unless properly secured by SSL

Alias /phpMyAdmin /usr/share/phpMyAdmin
Alias /phpmyadmin /usr/share/phpMyAdmin
#Directory /usr/share/phpMyAdmin
#   order deny,allow
#   deny from all
#   allow from 127.0.0.1
#   allow from ::1
#Directory

# This directory does not require access over HTTP - taken from the original
# phpMyAdmin upstream tarball
#
Directory /usr/share/phpMyAdmin/libraries
    Order Deny,Allow
    Deny from All
    Allow from None
Directory

# This configuration prevents mod_security at phpMyAdmin directories from
# filtering SQL etc.  This may break your mod_security implementation.
#
#IfModule mod_security.c
#    Directory /usr/share/phpMyAdmin
#        SecRuleInheritance Off
#    Directory
#IfModule

http://youdomain.com/phpmyadmin

wget http://wordpress.org/latest.zip

unzip latest.zip
cd wordpress
cp -a * /var/www/html

configure wordpress
cd /var/www/html
mv wp-config-sample.php wp-config.php
vim wp-config.php
.- edit in this line -.

define('DB_NAME', 'wordpress_db');
define('DB_USER', 'root');
define('DB_PASSWORD', 'password');

install on web browser
open your web browser and goto url:

http://yourdomain/

http://i56.tinypic.com/1zpqsts.png

http://i53.tinypic.com/287ojlv.jpg

http://i52.tinypic.com/110aa7k.jpg

http://i55.tinypic.com/24173wm.jpg

http://i51.tinypic.com/35b5n35.jpg

Tuesday, September 7, 2010

vtiger Installation On CentOS 5.x

vtiger Installation On CentOS 5.x

vtiger is the CRM / complete tracking solution I have looked for and needed for 10 years!!! An all-in-one tracking everything organic package that ties everything together - because every task has many things associated with it, and vtiger works the way people think.
I will install vtiger in the /var/www/html/vtigercrm directory on a CentOS 5.x (i386) system where /var/www/html is the document root of the web site where I install vtiger.
vtiger can be installed as follows:
rpm -Uhv http://apt.sw.be/redhat/el5/en/i386/rpmforge/RPMS/rpmforge-release-0.3.6-1.el5.rf.i386.rpm
yum install php-mysql php-gd php-imap php-ldap php-odbc php-pear php-xml php-xmlrpc php-mapserver php-mbstring php-mcrypt php-mssql php-snmp php-soap php-tidy phpmyadmin mysql mysql-server httpd libpng libpng-devel libjpeg libjpeg-devel freetype freetype-devel zlib xFree86-dev openssl openssl-devel krb5-devel imap-2004d
php.ini configuration:
Variable Value
allow_call_time_pass_reference on
error_reporting E_WARNING & ~E_NOTICE
safe_mode off
display_errors on
file_uploads on
max_execution_time 600
memory_limit 64M
log_errors off
output_buffering on
register_globals off
short_open_tag on
wget http://sourceforge.net/projects/vtigercrm/files/vtiger%20CRM%205.1.0/vtigercrm-5.1.0.tar.gz
tar -xvzf vtigercrm-5.1.0.tar.gz
chmod -R a+rw /var/www/html/vtigercrm
Open a browser - you can access the vtiger installer under:
http:///vtigercrm/install.php
Click to enlarge

Click to enlarge

Click to enlarge

Click to enlarge

Click to enlarge

Click to enlarge

Click to enlarge

Click to enlarge

Click to enlarge