Installing
To install Subversion and the Apache module run the following command:

sudo apt-get install subversion libapache2-svn

Setting up SVN
The first that needs to be done is to set up a group for subversion:

sudo addgroup subversion

The next thing is to make a directory for the SVN repository. I usually create it in the root directory named repo or svn:

sudo mkdir /repo

The premissions and owner of the repo directory have to be changed. The owner of the directory to www-data and the group needs to be subversion:

sudo chown www-data:subversion /repo
sudo chmod g+rws /repo

To create the actual SVN repository svnadmin is used with create. You can use any name you like for the SVN repository:

sudo svn create /repo/YourRepoName

The owner and permissions have to be changed on the repository:

sudo chown www-data:subversion /repo/YourRepoName
sudo chmod g+rws /repo/YourRepoName

Setting up the Apache Module
Edit the file /etc/apache2/mods-available/dav_svn.config with your favourite editor. I like to use nano:

sudo nano /etc/apache2/mods-available/dav_svn.config

At the bottom of the file add the following lines:

<Location /svn/yourrepo>
    DAV svn
    SVNPath /repo/mpshouse
    AUTHType Basic
    AUTHName "Your Subversion Repository"
    AuthUserFile /etc/subversion/passwd
    Require valid-user
</Location>

The 2 lines that need attention is the first, the sixth ans the last. The first line:

<Location /svn/yourrepo>

has /svn/yourrepo in it which will be the address that you can access your SVN. If your domain is yourdomain.com, you can access the SVN at yourdomain.com/svn/yourrepo. The sixth line:

AuthUserFile /etc/subversion/passwd

is where the password file is located. The last line:

Require valid-user

will stop anonymous browsing of your projects and force the browser to show an authentication dialog to continue.

Adding a User Account
To add a user account to a new password file the -c flag is used. If the file already exists and a new user needs to be added to an existing file the -c flag is not needed. The password file needs to be created in the directory specified in the dav_svn.config file that was just edited. The command will ask you for the password of the user after pressing enter.

sudo htpasswd -c /etc/subversion/passwd bill

Opening System Settings
Open the system settings:

All Applications > Settings > System Settings

Open up the shortcuts:

Common Appearance and Behavior > Shorcuts and Gestures > System Settings

Click Keyboard Shortcuts then select KWin as the KDE component in the drop down menu.

Setting the Shortcuts
You can set any shortcuts you like but the ones in this tutorial are to emulate Gnome desktop switching. To set the shortcut you click on the row you want to edit the shortcut for, click custom, then the button which will record the shortcut. The button with the x will clear the shortcut.

The following shortcuts will move to other desktops:

Switch One Desktop Down  >  Ctrl + Alt + Down
Switch One Desktop to the Left  >  Ctrl + Alt + Left
Switch One Desktop to the Right  >  Ctrl + Alt + Right
Switch One Desktop Up  >  Ctrl + Alt + Up

The following shortcuts will move the current window to other desktops:

Window One Desktop Down  >  Ctrl + Alt + Shift + Down
Window One Desktop to the Left  >  Ctrl + Alt + Shift + Left
Window One Desktop to the Right  >  Ctrl + Alt + Shift + Right
Window One Desktop Up  >  Ctrl + Alt + Shift + Up

Click apply and test it out.

First Update
To load a list of the latest updates into the server:

apt-get update

To perform the upgrade:

apt-get upgrade

To perform a distribution upgrade:

apt-get dist-upgrade

Retrieving Required Packages
These are the packages required for the server setup:

apt-get install nano libnet-ssleay-perl libauthen-pam-perl libio-pty-perl apt-show-versions libapt-pkg-perl libauthen-pam-perl mysql-server mysql-client proftpd-mod-mysql php5 libapache2-mod-php5 php5-sqlite php5-mysql apache2

You will be asked to enter a password for mysql and set the startup mode for proftpd as standalone.

Adding Your User Account
To add your user account:

useradd -d /home/myname -s /bin/bash -m myname

To set your account password: (It will ask you to type your password)

passwd myname

To add your account to the sudoers list use the following command:

visudo

In the section “User privilege specification” under root add:

myname    ALL=(ALL:ALL) ALL

Exit and save the file

Create The FTP Directory
Create the directory and change to it. This is done now so the webmin file can be downloaded into it. I usually create the FTP directory in var:

mkdir /var/ftp
cd /var/ftp

Download and Install Webmin
Check for the latest file to download and install here. The link used in this tutorial may be old. You can download the file like this:

wget http://prdownloads.sourceforge.net/webadmin/webmin_1.580_all.deb

Install webmin with:

dpkg -i webmin_1.580_all.deb

(remember to change the name of the file if there is a newer one available)
You can log into webmin with:

https://yourdomain.com:10000

Installing ProFTPd
Add the user and group for proftpd:

groupadd -g 2001 ftpgroup
useradd -u 2001 -s /bin/false -d /bin/null -c "proftpd user" -g ftpgroup ftpuser

Log into MySQL:

mysql -u root -p

create the database and account for the FTP database:

CREATE DATABASE ftp;
GRANT SELECT, INSERT, UPDATE, DELETE ON ftp.* TO 'proftpd'@'localhost' IDENTIFIED BY 'mypassword';
GRANT SELECT, INSERT, UPDATE, DELETE ON ftp.* TO 'proftpd'@'localhost.localdomain' IDENTIFIED BY 'mypassword';
FLUSH PRIVILEGES;

Select the database ftp to use:

USE ftp;

Create the required tables:

CREATE TABLE ftpgroup (
groupname varchar(16) NOT NULL default '',
gid smallint(6) NOT NULL default '5500',
members varchar(16) NOT NULL default '',
KEY groupname (groupname)
) TYPE=MyISAM COMMENT='ProFTP group table';

CREATE TABLE ftpquotalimits (
name varchar(30) default NULL,
quota_type enum('user','group','class','all') NOT NULL default 'user',
per_session enum('false','true') NOT NULL default 'false',
limit_type enum('soft','hard') NOT NULL default 'soft',
bytes_in_avail bigint(20) unsigned NOT NULL default '0',
bytes_out_avail bigint(20) unsigned NOT NULL default '0',
bytes_xfer_avail bigint(20) unsigned NOT NULL default '0',
files_in_avail int(10) unsigned NOT NULL default '0',
files_out_avail int(10) unsigned NOT NULL default '0',
files_xfer_avail int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM;

CREATE TABLE ftpquotatallies (
name varchar(30) NOT NULL default '',
quota_type enum('user','group','class','all') NOT NULL default 'user',
bytes_in_used bigint(20) unsigned NOT NULL default '0',
bytes_out_used bigint(20) unsigned NOT NULL default '0',
bytes_xfer_used bigint(20) unsigned NOT NULL default '0',
files_in_used int(10) unsigned NOT NULL default '0',
files_out_used int(10) unsigned NOT NULL default '0',
files_xfer_used int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM;

CREATE TABLE ftpuser (
id int(10) unsigned NOT NULL auto_increment,
userid varchar(32) NOT NULL default '',
passwd varchar(32) NOT NULL default '',
uid smallint(6) NOT NULL default '5500',
gid smallint(6) NOT NULL default '5500',
homedir varchar(255) NOT NULL default '',
shell varchar(16) NOT NULL default '/sbin/nologin',
count int(11) NOT NULL default '0',
accessed datetime NOT NULL default '0000-00-00 00:00:00',
modified datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (id),
UNIQUE KEY userid (userid)
) TYPE=MyISAM COMMENT='ProFTP user table';

Quit mysql with:

quit;

Open up the file /etc/proftpd/modules.conf with: (or use your favorite editor)

nano /etc/proftpd/modules.conf

Activate the following modules by removing the # symbol in front of the line:

LoadModule mod_sql.c
LoadModule mod_sql_mysql.c
LoadModule mod_quotatab_sql.c

Open the following file:

nano /etc/proftpd/proftpd.conf

Add the following lines and remember to change mypassword to the value you used when creating the mysql account for ftp:

# Choose a SQL backend among MySQL or PostgreSQL.
# Both modules are loaded in default configuration, so you have to specify the backend
# or comment out the unused module in /etc/proftpd/modules.conf.
# Use 'mysql' or 'postgres' as possible values.
#
#<IfModule mod_sql.c>
# SQLBackend                    mysql
#</IfModule>

DefaultRoot ~

SQLBackend              mysql
# The passwords in MySQL are encrypted using CRYPT
SQLAuthTypes            Plaintext Crypt
SQLAuthenticate         users groups

# used to connect to the database
# databasename@host database_user user_password
SQLConnectInfo  ftp@localhost proftpd mypassword

# Here we tell ProFTPd the names of the database columns in the "usertable"
# we want it to interact with. Match the names with those in the db
SQLUserInfo     ftpuser userid passwd uid gid homedir shell

# Here we tell ProFTPd the names of the database columns in the "grouptable"
# we want it to interact with. Again the names match with those in the db
SQLGroupInfo    ftpgroup groupname gid members

# set min UID and GID - otherwise these are 999 each
SQLMinID        500

# create a user's home directory on demand if it doesn't exist
CreateHome on

# Update count every time user logs in
SQLLog PASS updatecount
SQLNamedQuery updatecount UPDATE "count=count+1, accessed=now() WHERE userid='%u'" ftpuser

# Update modified everytime user uploads or deletes a file
SQLLog  STOR,DELE modified
SQLNamedQuery modified UPDATE "modified=now() WHERE userid='%u'" ftpuser

# User quotas
# ===========
QuotaEngine on
QuotaDirectoryTally on
QuotaDisplayUnits Mb
QuotaShowQuotas on

SQLNamedQuery get-quota-limit SELECT "name, quota_type, per_session, limit_type, bytes_in_avail, bytes_out_avail, bytes_xfer_avail, files_in_avail, files_out_avail, files_xfer_avail FROM ftpquotalimits WHERE name = '%{0}' AND quota_type = '%{1}'"

SQLNamedQuery get-quota-tally SELECT "name, quota_type, bytes_in_used, bytes_out_used, bytes_xfer_used, files_in_used, files_out_used, files_xfer_used FROM ftpquotatallies WHERE name = '%{0}' AND quota_type = '%{1}'"

SQLNamedQuery update-quota-tally UPDATE "bytes_in_used = bytes_in_used + %{0}, bytes_out_used = bytes_out_used + %{1}, bytes_xfer_used = bytes_xfer_used + %{2}, files_in_used = files_in_used + %{3}, files_out_used = files_out_used + %{4}, files_xfer_used = files_xfer_used + %{5} WHERE name = '%{6}' AND quota_type = '%{7}'" ftpquotatallies

SQLNamedQuery insert-quota-tally INSERT "%{0}, %{1}, %{2}, %{3}, %{4}, %{5}, %{6}, %{7}" ftpquotatallies

QuotaLimitTable sql:/get-quota-limit
QuotaTallyTable sql:/get-quota-tally/update-quota-tally/insert-quota-tally

RootLogin off
RequireValidShell off

In the same file comment out the following lines by adding a # symbol in front of them link this:

#<IfModule mod_quotatab.c>
#QuotaEngine off
#</IfModule>

Restart proftpd:

/etc/init.d/proftpd restart

Get back into mysqland use the ftp database:

mysql -u root -p
USE ftp;

Insert the FTP group into the database:

INSERT INTO `ftpgroup` (`groupname`, `gid`, `members`) VALUES ('ftpgroup', 2001, 'ftpuser');

The next two inserts can be done multiple times depending on how many user accounts you want to create for your ftp server. The value after ‘hard’ can be set (in bytes) to the quota for the user account, 0 is for unlimited. This is for one account:

INSERT INTO `ftpquotalimits` (`name`, `quota_type`, `per_session`, `limit_type`, `bytes_in_avail`, `bytes_out_avail`, `bytes_xfer_avail`, `files_in_avail`, `files_out_avail`, `files_xfer_avail`) VALUES ('myname', 'user', 'true', 'hard', 0, 0, 0, 0, 0, 0);
INSERT INTO `ftpuser` (`userid`, `passwd`, `uid`, `gid`, `homedir`, `shell`, `count`, `accessed`, `modified`) VALUES ('myname', 'mypassword', 2001, 2001, '/var/ftp', '/sbin/nologin', 0, '', '');

And that is it, let me know what you think…

Installing
I use MEncoder to convert video and it installs MPlayer with it. In an Ubuntu based operating system it can be installed with the following command:

sudo apt-get install mencoder

To install MPlayer without MEncoder use the following command:

sudo apt-get install mplayer

MPlayer Output Drivers
MPlayer can route the video through different drivers. Some of these will show the video in interesting ways. To list the output drivers available to MPlayer:

mplayer -vo help

A list will be displayed like this one:

mplayer: Symbol `ff_codec_bmp_tags' has different size in shared object, consider re-linking
MPlayer SVN-r33713-4.6.1 (C) 2000-2011 MPlayer Team
Available video output drivers:
        xmga    Matrox G200/G4x0/G550 overlay in X11 window (using /dev/mga_vid)
        mga     Matrox G200/G4x0/G550 overlay (/dev/mga_vid)
        tdfxfb  3Dfx Banshee/Voodoo3/Voodoo5
        3dfx    3dfx (/dev/3dfx)
        vdpau   VDPAU with X11
        xv      X11/Xv
        gl_nosw OpenGL no software rendering
        x11     X11 ( XImage/Shm )
        xover   General X11 driver for overlay capable video output drivers
        sdl     SDL YUV/RGB/BGR renderer (SDL v1.1.7+ only!)
        gl      OpenGL
        gl2     X11 (OpenGL) - multiple textures version
        dga     DGA ( Direct Graphic Access V2.0 )
        fbdev   Framebuffer Device
        fbdev2  Framebuffer Device
        svga    SVGAlib
        matrixview      MatrixView (OpenGL)
        aa      AAlib
        caca    libcaca
        v4l2    V4L2 MPEG Video Decoder Output
        directfb        Direct Framebuffer Device
        dfbmga  DirectFB / Matrox G200/G400/G450/G550
        xvidix  X11 (VIDIX)
        cvidix  console VIDIX
        null    Null video output
        xvmc    XVideo Motion Compensation
        mpegpes MPEG-PES to DVB card
        yuv4mpeg        yuv4mpeg output for mjpegtools
        png     PNG file
        jpeg    JPEG file
        gif89a  animated GIF output
        tga     Targa output
        pnm     PPM/PGM/PGMYUV file
        md5sum  md5sum of each frame

The Fun Part
You may have seen some ASCII art which is pictures or video displayed using text characters. MPlayer can do this with the videos you want to play.
To display the video using ASCII:

mplayer -vo caca <video file>

If you have seen the Matrix you would be familiar with the Matrix effect. This output driver looks really nice and is resizable.
To display the video using the matrix effect:

mplayer -vo matrixview <video file>

(Remember to replace <video file> with the file to play)

1. Run “gpmc.msc” or click “Start -> Administrative Tools -> Group Policy Management”
2. Expand Group Policy Management -> Forest: <domain> -> Domains -> <domain>
3. Right click Default Domain Policy and click edit.
4. Expand Computer Configuration -> Policies -> Windows Settings -> Security Settings -> Account Policies -> Password Policy
5. Edit your password complexity.

Download API
The API can be downloaded from the Microsoft Website
(please contact me if the link is broken)

Compiling
I had some problems with the Exchange namespace not being recognised and and asking for a reference to be added to the project even though I had added the reference. To overcome this hurdle, the “.NET Framework 4″ target framework must be used on the project. Do not use the “.NET Framework 4 Client Profile”.

Namespace
The namespace that should be added is:

using Microsoft.Exchange.WebServices.Data;

Connecting
The best way to connect to the exchange server is using auto discover if the exchange server is clustered:

ExchangeService es = new ExchangeService(ExchangeVersion.Exchange2010_SP1);
es.Credentials = new NetworkCredential("user", "password");
es.AutodiscoverUrl( "user@mpshouse.com" );

I do not bother with this as the application I am using is for internal use and I do not have a clustered echange server. To set the URL of the exchange server:

ExchangeService es = new ExchangeService(ExchangeVersion.Exchange2010_SP1);
es.Url = new Uri("http://192.168.0.100/EWS/Exchange.asmx");
es.Credentials = new NetworkCredential("user", "password");

Example
To get a list of all the emails from a specific user:

ExchangeService es = new ExchangeService(ExchangeVersion.Exchange2010_SP1);
es.Url = new Uri("http://192.168.0.100/EWS/Exchange.asmx");
es.Credentials = new NetworkCredential("user", "password");

FindItemsResults findResults = es.FindItems(WellKnownFolderName.Inbox, new ItemView(10));

foreach (Item item in findResults.Items)
    Console.WriteLine("Subject: " + item.Subject + "n");

The action can't be completed because the folder or a file in
it is open in another program

Close the folder or file and try again.

There is a very useful program that can help.

The Program
The program OpenedFilesView can display which programs have which files opened or locked. Closing the right process will solve this problem. optionally, you can also release the file by closing the handle from OpenedFilesView utility. However, be aware that after closing a file in this way, the program that opened the file may become unstable, and even crash.

The Command
The command that will be used is “find” with “xargs” and “grep”. A few options are supplied to the command to only print out file names and also not search in hidden directories. This will result in a neat readable output.

find <directory to search> -type f | xargs grep -rl '<text to search for>'

 
Example
If I wanted to search a hypothetical backup directory (/ftp/backup) for the text “mpshouse”:

find /ftp/backup/ -type f | xargs grep -rl 'mpshouse'

There is more than one way of searching for text in files, this is just one.

mysqldump -u root -p --no-data apsec > C:UsersbillDesktoptables.sql

Creating The Form
The first function needed is one to create some HTML with a hidden form to post data to the exchange server. This function expects a user name, password and a boolean that is set to true if you want to use the OWA basic mode and false for the full version. This is handy as the basic mode does not require popups. Change the IP “192.168.0.100″ to the IP address of your server.

private string CreateOWAPage(string uname, string pword, bool BasicMode)
{
    StringBuilder strPage = new StringBuilder();
    strPage.AppendLine("<html>");
    strPage.AppendLine("  <head>");
    strPage.AppendLine("    <script language='javascript'>");
    strPage.AppendLine("      function owaLogin(user, pass)");
    strPage.AppendLine("      {");
    strPage.AppendLine("        var ctrlForm = document.getElementById('logonForm');");
    strPage.AppendLine("        ctrlForm.username.value = user;");
    strPage.AppendLine("        ctrlForm.password.value = pass;");
    strPage.AppendLine("        ctrlForm.submit();");
    strPage.AppendLine("      }");
    strPage.AppendLine("    </script>");
    strPage.AppendLine("  </head>");
    strPage.AppendLine("  <body onload="javascript:owaLogin('" + uname + "', '" + pword + "');">");
    strPage.AppendLine("    <form id="logonForm" name="logonForm" target="_self" action="https://192.168.0.100/owa/auth/owaauth.dll" method="post">");
    strPage.AppendLine("      <input type="hidden" name="destination" value="https://192.168.0.100/owa" />");
    strPage.AppendLine("      <input type="hidden" name="username" id="username" />");
    strPage.AppendLine("      <input type="hidden" name="password" id="password" />");
    strPage.AppendLine("      <input type="hidden" id="SubmitCreds" name="SubmitCreds" value="Connection" />");
    strPage.AppendLine("      <input type="hidden" id="rdoRich" name="forcedownlevel" value="0" />");
    strPage.AppendLine("      <input type="hidden" id="rdoPublic" name="trusted" value="0" />");
    if (BasicMode == true)
        strPage.AppendLine("      <input type="hidden" name="flags" value="5" />");
    else
        strPage.AppendLine("      <input type="hidden" name="flags" value="0" />");
    strPage.AppendLine("    </form>");
    strPage.AppendLine("  </body>");
    strPage.AppendLine("</html>");
    return strPage.ToString();
}

Implementation
The easiest way to imlement the OWA auto login is to use a web browser (WebBrowser) component and navigate to the HTML string. Change the “MyUserName” and “MyPassword” values to a user name and password of an account that exists on your server.

wbBrowser.NavigateToString(CreateOWAPage("MyUserName", "MyPassword", true));