{"id":9,"date":"2004-07-21T19:57:31","date_gmt":"2004-07-21T16:57:31","guid":{"rendered":"http:\/\/void.gr\/kargig\/blog\/?p=9"},"modified":"2004-07-21T19:58:14","modified_gmt":"2004-07-21T16:58:14","slug":"webdav-mod_mysql_auth","status":"publish","type":"post","link":"https:\/\/www.void.gr\/kargig\/blog\/2004\/07\/21\/webdav-mod_mysql_auth\/","title":{"rendered":"WebDav + mod_mysql_auth ?"},"content":{"rendered":"

I have several users on an http server (apache of course) and they all have a seperate dir for WebDav<\/a> . The authentication is being done using the default htaccess file-scheme. I want to change that and use mod_auth_mysql<\/a>. Searching google was not really helpfull. But I found a very interesting module called mod_auth_user_dir<\/a> for multiple webdav users (this sounds familiar!). It says it supports various authentication modules…I might try it if I can’t make mod_auth_mysql work on it’s own with webdav.<\/p>\n

What I’ve done so far is find how normal .htaccess authentication can be replaced with sql authentication.
\nHere’s a sample of an older .htaccess file and the newer one:<\/p>\n

old<\/em>
\nAuthUserFile \/foo\/bar\/moo\/.htpasswd
\nAuthName \"lala la lalal\"
\nAuthType Basic
\n< limit GET >
\nrequire valid-user
\n< \/limit >
\n<\/><\/><\/code><\/p><\/blockquote>\n

new<\/em>
\nAuthType Basic
\nAuthName \"lala la lalal\"
\nAuthMySQLHost localhost
\nAuthMySQLUser htpasswd
\nAuthMySQLPassword THATSMYSUPERSECRETPASSWORD
\nAuthMySQLDB htpasswd
\nAuthMySQLAuthoritative On
\nAuthMySQLKeepAlive On
\nrequire user MYUSER
\n<\/code><\/p><\/blockquote>\n

Why is it better ? <\/p>\n

  • More centralized (really helpfull if you have multiple servers and the same users all over)<\/li>\n
  • When you change one user it’s global and you don’t have to repeat the changes on every single host<\/li>\n
  • It’s faster <\/li>\n
  • I wanted to play with it <\/li>\n

    Btw, there’s a great script<\/a> for automating the whole process of adding users, etc to the db.<\/p>\n","protected":false},"excerpt":{"rendered":"

    I have several users on an http server (apache of course) and they all have a seperate dir for WebDav . The authentication is being done using the default htaccess file-scheme. I want to change that and use mod_auth_mysql. Searching google was not really helpfull. But I found a very interesting module called mod_auth_user_dir for […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-9","post","type-post","status-publish","format-standard","hentry","category-general"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t