Project

General

Profile

Docs ModVhostDbi » History » Revision 5

Revision 4 (ver, 2011-02-14 08:29) → Revision 5/10 (ver, 2011-02-14 08:33)

h1. Docs:ModDbiVhost 

 *Module: mod_dbi_vhost* 

 {{>toc}} 

 h2. Description 

 mod_dbi_vhost is a modified version of [[mod_mysql_vhost]] which instead uses "libDBI":http://libdbi.sf.net/ to read vhost to document root associations. 

 h2. Installation 

 This module is a 3rd party module and is not included in the official distribution. You can download the patch from here: 

 * For lighttpd 1.4.28: http://riverroadcable.com/~doneill/lighttpd-1.4.28-dbi.patch 

 Once applied, run autogen.sh and pass the option @--with-dbi@ to let the GNU tools find it, or @--with-dbi=/path/to/dbi@ to specify the location. 

 h2. Options 

 *vhost.dbi => ( "dbname" => "..." )* - Required 

 The name of the database for network database connections, or a database filename for local database implementations (Sqlite). 

 *vhost.dbi => ( "dbtype" => "..." )* - Required 

 Set this to your database type.    This is usually included in the DBD file name.    Eg., libdbdmysql.so is "mysql", and libdbdpgsql.so is "pgsql". 

 Some options include: _mysql_, _pgsql_, _sqlite3_, _freetds_, _sqlite_ 

 *vhost.dbi => ( "sql" => "..." )* - Required 

 The actual query used to get the document root for a vhost.    Use '?' in place of the hostname, for example: 
 <pre> 
 vhost.dbi += ( "sql" => "SELECT docroot FROM vhosts WHERE host='?'" ) 
 </pre> 

 h2. Common Options 

 *vhost.dbi += ( "user" => "..." )* - Optional 

 The username to use for opening a typical network-based database connection. 

 *vhost.dbi += ( "pass" => "..." )* - Optional 

 A password used to authenticate to a database connection. 

 *vhost.dbi += ( "hostname" => "..." )* - Optional 

 A hostname used in establishing a database connection. 

 *vhost.dbi += ( "port" => _i_ i )* - Optional 

 A port number used to authenticate to a database connection.    If not specified, the default for the specified database type will be used. 

 h2. MySQL-Specific Options 

 *vhost.dbi += ( "encoding" => "..." )* - Optional 

 For example, "@UTF-8@".    This parameter compatibility and available options depend on the driver.    I use it to tell the MySQL DBD to use UTF-8. 

 h2. Sqlite3-Specific Options 

 *vhost.dbi += ( "sqlite3_dbdir" => "..." )* - Required 

 The directory on the filesystem where the database file (specified in "dbname") is located. 

 h3. Examples 

 <pre># Sqlite3 
 vhost.dbi += ( 
        "dbtype"          => "sqlite3", 
        "dbname"          => "lighttpd.db", 
        "sqlite3_dbdir" => "/etc/lighttpd", 
        "encoding"        => "UTF-8", 
        "sql"             => "SELECT docroot FROM vhosts WHERE host='?'" 
 ) 

 # PostgreSQL 
 vhost.dbi += ( 
        "dbtype"          => "pgsql", 
        "dbname"          => "lighttpd", 
        "user"            => "postgres", 
        "hostname"        => "localhost", 
        "encoding"        => "UTF-8", 
        "sql"             => "SELECT docroot FROM vhosts WHERE host='?'" 
 ) 

 # MySQL 
 vhost.dbi += ( 
        "dbtype"          => "mysql", 
        "dbname"          => "lighttpd", 
        "user"            => "root", 
        "password"        => "somepassword", 
        "hostname"        => "localhost", 
        "encoding"        => "UTF-8", 
        "sql"             => "SELECT docroot FROM vhosts WHERE host='?'" 
 ) 

 server.modules            += ( "mod_dbi_vhost" ) 
 </pre>