Return to mysqlvhost.txt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / lighttpd / doc / outdated

Annotation of embedaddon/lighttpd/doc/outdated/mysqlvhost.txt, revision 1.1

1.1     ! misho       1: ====================
        !             2: MySQL-based vhosting
        !             3: ====================
        !             4: 
        !             5: -----------------------
        !             6: Module: mod_mysql_vhost
        !             7: -----------------------
        !             8: 
        !             9: :Author: ada@riksnet.se
        !            10: :Date: $Date: 2004/08/29 09:43:49 $
        !            11: :Revision: $Revision: 1.1 $
        !            12: 
        !            13: :abstract:
        !            14:   This module provides virtual hosts (vhosts) based on a MySQL table
        !            15: 
        !            16: .. meta::
        !            17:   :keywords: lighttpd, mysql, vhost
        !            18: 
        !            19: .. contents:: Table of Contents
        !            20: 
        !            21: Description
        !            22: ===========
        !            23: 
        !            24: With MySQL-based vhosting you can store the path to a given host's
        !            25: document root in a MySQL database.
        !            26: 
        !            27: .. note:: Keep in mind that only one vhost module should be active at a time.
        !            28:           Don't mix mod_simple_vhost with mod_mysql_vhost.
        !            29: 
        !            30: Options
        !            31: =======
        !            32: 
        !            33: Example: ::
        !            34: 
        !            35:   mysql-vhost.db             = "lighttpd"
        !            36:   mysql-vhost.user           = "lighttpd"
        !            37:   mysql-vhost.pass           = "secret"
        !            38:   mysql-vhost.sock           = "/var/mysql.lighttpd.sock"
        !            39:   mysql-vhost.sql            = "SELECT docroot FROM domains WHERE domain='?'"
        !            40: 
        !            41: 
        !            42: MySQL setup: ::
        !            43: 
        !            44:   GRANT SELECT ON lighttpd.* TO lighttpd@localhost IDENTIFIED BY 'secret';
        !            45: 
        !            46:   CREATE DATABASE lighttpd;
        !            47: 
        !            48:   USE lighttpd;
        !            49: 
        !            50:   CREATE TABLE domains (
        !            51:     domain varchar(64) not null primary key,
        !            52:     docroot varchar(128) not null
        !            53:   );
        !            54: 
        !            55:   INSERT INTO domains VALUES ('host.dom.ain','/http/host.dom.ain/');
        !            56: 
        !            57: 
        !            58: