Project

General

Profile

History

Docs » Z Ancient »

Docs ModMySQLVhost » History » Revision 8

Revision 7 (Anonymous, 2007-10-24 05:20) → Revision 8/22 (Anonymous, 2007-10-24 05:20) 

[[TracNav(DocsToc)]] 
 {{{ 
 #!rst 
 ==================== 
 MySQL-based vhosting 
 ==================== 

 ----------------------- 
 Module: mod_mysql_vhost 
 ----------------------- 

 .. meta:: 
   :keywords: lighttpd, mysql, vhost 

 .. contents:: Table of Contents 

 Description2 
 ============ =========== 

 With MySQL-based vhosting you can store the path to a given host's 
 document root in a MySQL database. 

 .. note:: Keep in mind that only one vhost module should be active at a time. 
           Don't mix mod_simple_vhost with mod_mysql_vhost. 

 Options 
 ======= 

 Example: :: 

   mysql-vhost.db               = "lighttpd" 
   mysql-vhost.user             = "lighttpd" 
   mysql-vhost.pass             = "secret" 
   mysql-vhost.sock             = "/var/run/mysqld/mysqld.sock" 
   mysql-vhost.sql              = "SELECT docroot FROM domains WHERE domain='?';" 


 MySQL setup: :: 

   GRANT SELECT ON lighttpd.* TO lighttpd@localhost IDENTIFIED BY 'secret'; 

   CREATE DATABASE lighttpd; 

   USE lighttpd; 

   CREATE TABLE domains ( 
     domain varchar(64) not null primary key, 
     docroot varchar(128) not null 
   ); 

   INSERT INTO domains VALUES ('host.dom.ain','/http/host.dom.ain/'); 

 }}}