Lighttpd MySQL virtual hosting

2013年2月2日 (六) 06:18的最后版本

Module: mod_mysql_vhost

This module provides virtual hosts (vhosts) based on a MySQL table

Example: ::

 mysql-vhost.db             = "lighttpd"
 mysql-vhost.user           = "lighttpd"
 mysql-vhost.pass           = "secret"
 mysql-vhost.sock           = "/var/mysql.lighttpd.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/');