Actions
Docs ModMySQLVhost » History » Revision 7
« Previous |
Revision 7/22
(diff)
| Next »
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/');
}}}
Updated by Anonymous almost 17 years ago · 7 revisions