Learning is an Art

WANdisco is offering some free online training sessions over the next few weeks, for any that are interested.

The topics will include:

Introduction to Subversion for Developers – 5th May

All About Subversion Hook Scripts – 19th May

Using Subversion Locking – 2nd June

All About Subversion Checkouts – 16th June

Using the Subversion Diff Command – 30th June

Branching and Merging in Subversion 1.6.9 – 14th July

Feel free to see the website for more information:
http://wandisco.com/webinar/subversion/training

To install latest version of postgresql we first we need to add pgdg repository to list of repositories open terminal and fire following commands, you need to be root.

Once repository is installed properly use yum to install postgresql as shown below

You can do above in a single line choice is yours.

Initialize the database

Start the database server

Voila your database server is setup and ready to use.

Here I am with my first youtube upload I have been trying a while to do some videos for demos but was not able to do it, so I went ahead first created a flash demo using wink and after googling around for a while I came across nice utility from iWisoft which is flash to video converter and conversion was pretty easy and straight forward. There is no audio added to it, I have used annotations for explaining things where ever required. This was my maiden effort may not be that good but still someone might find it useful, enjoy and have fun.

This video covers some basics of TortoiseSVN a client for Subversion.
Steps covered are checking out your code, adding some existing content, commiting changes to repository, reverting to older revision and how to view log and compare two revisions.

In this article I am going to put on links to various useful Subversion resource available on internet which can get you started with using Subversion easily; whether you are end user or a developer looking for an API for language of your choice and I hope you all can contribute to grow this list further I am aware that there is exhaustive list already available on tigris site.

Lets start this list

Subversion Home : Home of the great tool you can find the binaries for latest version from the website based on operating system of your choice it also includes collabnet certified binaries.

TortoiseSVN : Most preferred Subversion client for windows

VisualSVN : Great tool to get you started quickly with Subversion without any hassles comes with Apache and wizard based setup is just awesome for newbies

AnkhSVN : Visual studio integration for all M$ fans

RapidSVN : Multi-platform GUI front-end

SVNKIT : Java API for Subversion, pretty easy to get started lot’s examples available and documentation is just awesome

PySVN : Python API for Subversion, nice pythonic interface, some people might differ and point out Subvertpy is more pythonic, I like both of them equally.

This list is In progress and I will keep updating it.

I recently setup Subversion on Centos as well as RHEL, so thought will share the steps followed though it’s pretty straight forward it will help people looking for it and will be available to me for future references as well

Step1 Install rpmforge repository

Step2 Install Subversion

Step3 Install mod_dav_svn (Only required if you planning Apache Integration)

Voila and you are done, go to command prompt and type following

You should see output as below

I just go a mail on Subversion mailing list informing that today is the 6th Birthday of Subversion for those who are thinking what is Subversion they can read here.

So Subversion has come along pretty well since it’s 1.0 release 6 years back and this day I would like to thank all developers who have put in there efforts to make Subversion what it is today; it stands tall among the many commercial tools.

So how I celebrated the Subversion’s birthday I went to svnforum.org and tried to answer queries of people as thats the way you can help Subversion adoption to grow among masses.

Developers are doing there bit by developing it; so we as a part of community need to contribute in what ever way possible.

This day I wish many many happy returns of the day to Subversion and want to congratulate Subversion community for great going looking ahead to more great accomplishments in future.

Few days back I was trying to create database in a batch job using createdb.exe and I encountered this problem createdb.exe prompts for password and there is no way of passing password from command line as an argument.
I tried to find out how to do this but in vein there is no way you can pass password as an command line argument; than after looking around for sometime and googling I found two ways of doing it

• Setting up PGPASSWORD environment variable : This method is not preferable as it’s insecure more for further details read this

• Setting up password in pgpass.conf : The file is to be located
  %APPDATA%\postgresql\pgpass.conf

File has the following format

Each of the first four fields may be a literal value, or *, which matches anything.

For further details the postgres documentation

Here I am going to talk about three useful and handy subcommands  of svnadmin that will help us in dumping our data and restoring it back to fresh repository, restore is very critical, as we keep on backing up data but we seldom bother about restoring it to check if everything is working fine or not. I would like to put one point across that your backup is as good as your last restore.

Dumping the repository

This is the simplest option for dumping the repository for purpose of backing up your repository. If you want to do an incremental back than you need to specify –incremental flag and give start and end revision for same.

Restoring the repository back

Verify the restore

Habit of restoring the data regularly is very important for having usable backup.

This article covers how to setup domain authentication for Subversion with Apache using mod_auth_sspi , I am running Apache 2.2 and Subversion 1.5. First of all you need to get SSPI module from its new home at sourceforge , module can be directly downloaded from here. Once you have downloaded the module extract using some zip utility there will be a bin folder inside the extracted folder and inside bin folder there will a file named mod_auth_sspi.so take this file and drop it in Apache’s modules folder.

Once you are done with above steps we now need to modify Apache’s httpd.conf to include the domain authentication for our Subversion repository make changes to httpd.conf as shown below,  first we need to ensure that we have required modules loaded

To mod_dav_svn to work you need to uncomment the line which loads mod_dav module Apache look for it and uncomment if its commented.

Now the real magic configuration starts which will enable us to authenticate Subversion users against AD domains make changes in httpd.conf as shown below

Once done with above changes save the file and restart Apache and try accessing the URL http://<yourservername>/svn/myrepo you will be prompted for authentication saying “Subversion Domain” enter your domain name without domain as we have SSPIOmitDomain On and based on Subversion authorization file i.e authz in our scenario you will be able to see repository or you will get forbidden error.

We are done with setting up domain authentication, in-case you face any problem with above settings feel free to write to me.

LoadModule sspi_auth_module   modules/mod_auth_sspi.so
LoadModule dav_svn_module     modules/mod_dav_svn.so
LoadModule authz_svn_module   modules/mod_authz_svn.so

I have been fiddling around with Apache for quite sometime now on Ubuntu and there were few questions which used to come to my mind as novice user initially like how do i install apache on first place, where are Apache logs, where are Apache conf files located, how do I add new site to Apache server, stopping and restarting the server so I thought that I would some up answer to all these question at a single place for my own future reference and for the help of my readers.

So first things first I will start with how to install apache here apt-get comes to your rescue and thanks to Ubuntu archives all you need to give simple on liner as shown below

So now that we are done with installation lets move on other things like for troubleshooting you need to know where are apache logs, apache logs can be found at below mentioned path here you can find access logs as well as error logs

we also need to know where are configuration related files to our web server for that we need to look at path mentioned below here you will find apache2.conf, httpd.conf, ports.conf and other configuration related files how to modify and update them is beyond the scope of this nifty article

Moving on to next FAQ this one is my favourite now that I have setup apache how do I go about hosting my site thats the whole purpose for you following along this article, all you need to do is follow the sequence mentioned below

Create a file mysite or what ever name you want to give and add configuration related to your site in this file

you are done with setting up your site.

Last of these faq’s is how do I start and stop the server for doing this all you need to know about is apache2ctl utility and you can start stop using it pretty easily

We are done with the faq’s which were in mind and I will keep on updating this list in future as and when things come to my mind. In next article I would covering how to use apache to host Subversion repositories along with domain authentication so stay tuned.

/etc/apache2/conf.d/