Dear Wiki user, You have subscribed to a wiki page or wiki category on "Httpd Wiki" for change notification.
The following page has been changed by ChrisPepper: http://wiki.apache.org/httpd/ApacheVirtualHostMysql The comment on the change is: More cleanup ------------------------------------------------------------------------------ {{{ INSERT INTO hosts VALUES(null, 'localhost', 1, 0, 0, 0, 0); }}} + || '''value''' || '''description''' || || null || auto-increment host ID || || 'localhost' || host name || @@ -98, +99 @@ '''Note: The directories for this vhost will be created automatically when apache is (re)started!''' - '''Note: Removal isn't automatic, if you remove a host + aliases + users + configuration the files will remain) + '''Note: Removal isn't automatic, if you remove a host + aliases + users + configuration the files will remain)''' '''Note: I recommend adding localhost as your first vhost. All request with and unknown host header will go to this host.''' - === adding users (require/optional) === + === adding users === + - Only require when you enable webdav for a host. + Only required when you enable WebDAV for a host. + {{{ INSERT INTO users VALUES(null, 1, 'user', 'apache-encrypted-password', 'dav'); }}} + || '''value''' || '''description''' || || null || auto increment user id || || 1 || host id user belongs too (check hosts table to get it) || @@ -116, +120 @@ === adding aliases (optional) === + - You can create aliases for hosts as well if you wish. (multiple aliases possible per host, alias it self must be unique) + You can create aliases for hosts as well if you wish (multiple aliases possible per host; each alias must be unique). + {{{ INSERT INTO aliases VALUES(1, 'cygnus'); }}} - || value || description || - || 1 || host id alias belongs too (check hosts table to get it) || - || 'cgynus' || alias for host || + || '''value''' || '''description''' || + || 1 || host ID alias belongs too (check hosts table to get it) || + || 'cygnus' || alias for host || + - === adding addition configuration options (optional) === + === adding additional configuration options (optional) === + - Setting up a host as reverse proxy? not a problem. (not reverse proxy config not shown) + Setting up a host as reverse proxy? not a problem (note reverse proxy config not shown). + {{{ INSERT INTO configuration VALUES(1, '#proxy config'); }}} + - || value || description || + || '''value'' || '''description''' || || 1 || host id configuration belongs too (check hosts table to get it) || || '#proxy config' || configuration for host || == Portability == - This configuration works on both windows and linux (presumable mac as well). - To get it to work on windows you need to edit http.tmpl and update the path separate from : to ; for the php_admin_values. + This configuration works on both Windows and Linux (presumably Macs as well). - Other database systems can be used by modifying the configuration files. PostrgesSQL should work fine for example. + To get it to work on Windows you need to edit http.tmpl and update the path separate from : to ; for the php_admin_values. + Other database systems can be used by modifying the configuration files. PostrgesSQL should work fine, for example. +
