WebDav, Alias, Multiple site configuration

Configure a WebDAV enabled webserver for multiple user folders and one shared folder

 

DAVLockDB /serv/webdav.example.org/auth/DAVLock
DAVMinTimeout 180 

NameVirtualHost 10.1.1.1
<VirtualHost webdav.example.org>

    ServerName  webdav.example.org
    ServerAdmin webmaster@example.org

    DocumentRoot /serv/webdav.example.org/htdocs/

    LogLevel warn 

    ErrorLog /serv/webdav.example.org/logs/error.log
    CustomLog /serv/webdav.example.org/logs/access.log combined

    # user1
    Alias /user1 /serv/webdav.example.org/webdav/user1

    <Directory /serv/webdav.example.org/webdav/user1>
        DAV             On
        AuthType        Basic 
        AuthName        "My WebDav Directory"
        AuthUserFile    /serv/webdav.example.org/auth/webdav.user
        Require         valid-user 
    </Directory>

    <Location /user1/>
        Require     user user1
    </Location>

    # user2
    Alias /user2 /serv/webdav.example.org/webdav/user2

    <Directory /serv/webdav.example.org/webdav/user2>
        DAV             On
        AuthType        Basic 
        AuthName        "My WebDav Directory"
        AuthUserFile    /serv/webdav.example.org/auth/webdav.user
        Require         valid-user 
    </Directory>

    <Location /user2/>
        Require     user user2 
    </Location>

    # transfer 
    Alias /transfer /serv/webdav.example.org/webdav/transfer

    <Directory /serv/webdav.example.org/webdav/transfer>
        DAV             On
        AuthType        Basic 
        AuthName        "My WebDav Directory"
        AuthUserFile    /serv/webdav.example.org/auth/webdav.user
        Require         valid-user 
    </Directory>

    <Location /transfer/>
        Require    valid-user 
    </Location>

</VirtualHost>

MySQL, User Variable & connection string

http://vanilla47.com/MySQL%20Docs/connectors-en.html-chapter/connector-net.html#connector-net-programming-connecting-connection-string

 

요는 SQL Query에서 user variables을 써야 되는데,

@이게 파라미터 인식자로도 동작을 하기 때문에,

connection string에서

AllowUserVariables=true

을 해줘야 됨… ㅠㅜ

 

http://www.dreamincode.net/forums/topic/199334-using-mysqlhelper/