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 sjorge: http://wiki.apache.org/httpd/ApacheVirtualHostMysql ------------------------------------------------------------------------------ You should be good to go. Feel free to make more changes to the templates and or the configuration files - == Adding a host == + == Adding a hosts == + Use the mysql client or phpMyAdmin or similar to access the database. + === adding host entry == + {{{ + INSERT INTO hosts VALUES(null, 'localhost', 1, 0, 0, 0, 0); + }}} + || value || description || + || null || auto increment host id || + || 'localhost' || host name || + || 1 || enable (0 to disable the host) || + || 0 || disable webdav (1 to enable) || + || 0 || disable cgi (1 to enable) || + || 0 || disable server side included (1 to enable) || + || 0 || disable php (1 to enable) || + + '''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) === + Only require when you enable webdav for a host. + {{{ + INSERT INTO users VALUES(null, 1, 'user', 'apache-ecoded-password', 'dav'); + null = auto increment user id + 1 = host id user belongs too (check hosts table to get it) + 'user' = user name for + }}} + + === adding aliases (optional) === + === adding addition configuration options (optional) === == 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 seperate from : to ; for the php_admin_values. + Other database systems can be used by modifying the configuration files. PostrgesSQL should work fine for example. +
