마님네

## 컴파일시 필요 구성 패키지
yum install libdbi libdbi-devel libdbi-dbd-mysql libdib-dbd-mysql
yum install gcc-c++

## mod_dbi_pool 먼저 설치

wget http://www.outoforder.cc/downloads/mod_dbi_pool/mod_dbi_pool-0.4.0.tar.bz2

tar xvfpj mod_dbi_pool-0.4.0.tar.bz2

./configure --with-apxs=/usr/local/httpd/bin/apxs

make make install


## mod_dbi_pool 설치가 안됐을시 컴파일 에러 발생

wget http://www.outoforder.cc/downloads/mod_vhost_dbi/mod_vhost_dbi-0.1.0.tar.bz2

tar xvfpj mod_vhost_dbi-0.1.0.tar.bz2

cd mod_vhost_dbi-0.1.0

./configure --with-apxs=/usr/local/httpd/bin/apxs

make make install



## httpd.conf 추가 할 사항
LoadModule dbi_pool_module      modules/mod_dbi_pool.so
LoadModule vhost_dbi_module    modules/mod_vhost_dbi.so

PoolDbiDriver         VHOST  mysql
PoolDbiHost           VHOST  dbserver
PoolDbiUsername       VHOST  hosting
PoolDbiPassword       VHOST  my1q2w3e
PoolDbiDBName         VHOST  hosting
PoolDbiConnMin        VHOST  1
PoolDbiConnSoftMax    VHOST  1
PoolDbiConnHardMax    VHOST  5
PoolDbiConnTTL        VHOST  30
 

  VhostDbiEnabled On
  VhostDbiConnName VHOST
  VhostDbiQuery "SELECT ServerName, DocumentRoot, Username 
                        FROM vhosts WHERE ServerName = &{RequestHostname} AND active ='on'"


테이블 생성

CREATE TABLE IF NOT EXISTS `vhosts` (
  `active` varchar(3) default NULL,
  `ServerName` varchar(255) NOT NULL default '',
  `DocumentRoot` varchar(255) default NULL,
  `Username` varchar(255) default NULL,
  PRIMARY KEY  (`ServerName`),
  KEY `active` (`active`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;