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/webdav%2etmpl The comment on the change is: fixed problem with query ------------------------------------------------------------------------------ {{{ # DAV Server <IfDefine DAV> - <VirtualHost *:81> + <VirtualHost *:81> - ServerName %name%:81 + ServerName %name%:81 - ErrorLog "%host_dir%/%name%/_sys/logs/error_log" + ErrorLog "%host_dir%/%name%/_sys/logs/error_log" - CustomLog "%host_dir%/%name%/_sys/logs/access_log_dav" combined + CustomLog "%host_dir%/%name%/_sys/logs/access_log_dav" combined - DocumentRoot "%host_dir%/%name%" + DocumentRoot "%host_dir%/%name%" - DirectoryIndex dav_index_list + DirectoryIndex dav_index_list - # mysql connection - DBDriver mysql + # mysql connection + DBDriver mysql - DBDParams "host=%db_server% dbname=%db_name% user=%db_user% pass=%db_pass%" + DBDParams "host=%db_server% dbname=%db_name% user=%db_user% pass=%db_pass%" - DBDPersist On - DBDMin 1 - DBDKeep 2 - DBDMax 2 - DBDExptime 60 + DBDPersist On + DBDMin 1 + DBDKeep 2 + DBDMax 2 + DBDExptime 60 - <Directory "%host_dir%/%name%"> + <Directory "%host_dir%/%name%"> - Options FollowSymLinks - AllowOverride none - order allow,deny - Allow from All + Options FollowSymLinks + AllowOverride none + order allow,deny + Allow from All - # DAV Settings - DAV On + # DAV Settings + DAV On + + # Authentication + AuthName "DAV Authentication" + AuthType basic + AuthBasicProvider dbd + AuthDBDUserPWQuery "SELECT password FROM users WHERE (groups = 'dav' or groups LIKE '%,dav' or groups LIKE 'dav,%' or groups LIKE '%,dav,%') AND host = %id% AND name = %s;" + Require valid-user - # Authentication - AuthName "DAV for %name%" - AuthType basic - AuthBasicProvider dbd - AuthDBDUserPWQuery "SELECT password FROM users WHERE (groups = 'dav' or groups LIKE '%,dav%' or groups LIKE '%dav,%' or groups LIKE '%,dav,%') AND host = %id% AND name = %s;" - Require valid-user + #Remove filter for dynamic content + RemoveHandler .pl .cgi .shtm .shtml + RemoveHandler .php .phps + <Files ~ "^\.ht"> + Order allow,deny + Allow from all + </Files> + </Directory> + + BrowserMatch "Microsoft Data Access Internet Publishing Provider" redirect-carefully + BrowserMatch "MS FrontPage" redirect-carefully + BrowserMatch "^WebDrive" redirect-carefully + BrowserMatch "^WebDAVFS/1.[0123]" redirect-carefully + BrowserMatch "^gnome-vfs/1.0" redirect-carefully + BrowserMatch "^XML Spy" redirect-carefully + BrowserMatch "^Dreamweaver-WebDAV-SCM1" redirect-carefully + BrowserMatch "MSIE" AuthDigestEnableQueryStringHack=On + </VirtualHost> + </IfDefine> + }}} - #Remove filter for dynamic content - RemoveHandler .pl .cgi .shtm .shtml - RemoveHandler .php .phps - <Files ~ "^\.ht"> - Order allow,deny - Allow from all - </Files> - </Directory> - BrowserMatch "Microsoft Data Access Internet Publishing Provider" redirect-carefully - BrowserMatch "MS FrontPage" redirect-carefully - BrowserMatch "^WebDrive" redirect-carefully - BrowserMatch "^WebDAVFS/1.[0123]" redirect-carefully - BrowserMatch "^gnome-vfs/1.0" redirect-carefully - BrowserMatch "^XML Spy" redirect-carefully - BrowserMatch "^Dreamweaver-WebDAV-SCM1" redirect-carefully - BrowserMatch "MSIE" AuthDigestEnableQueryStringHack=On - </VirtualHost> - </IfDefine> - }} -
