My Notepad

Il mio taccuino personale.

Archive for March, 2009

Import and Export DB Schema in SQL files – Visual Studio 2008

without comments

Written by Davide Orazio Montersino

March 23rd, 2009 at 12:29 pm

Integrating Mantis-Svn-Mediawiki – A Team Development platform on Ubuntu Server

with 2 comments

Being a consultant for a little but expanding custom development company, I’ve been learning first hand how much it can be useful to begin use simple instruments to coordinate and organize the team work, to collect know-how, to avoid certain problems, and to lead to a better communication. Team development software can do much  – give a unique access point for the company’s developing resources, give facilities to collect know how and documentation – especially with occasional collaborators or consultants.

In the following posts I’ll explain how to deploy a useful development server, which integrates some functionalities:

  • svn and websvn server
  • bug/issue tracker
  • wiki
  • scheduled backup via mail or ftp

In particular, our system will have:

  • A single sign-on for wiki and issue tracker (Mediawiki and Mantis)
  • Issue/Bug Tracker automated entries directly from the svn comments.
  • Automated backup via ftp nd/or mail

This platform can be used in very different developing environment, and while it can become an almost perfect solution for LAMP development, I’ve been using it with .NET projects too.

The Ubuntu Box

First of all, we need a running linux server. In this tutorial, I’ll be using Ubuntu server hardy Heron. The choice is not fot technical reasons, but because Ubuntu is the distribution I know best and because it is a quite popular and well maintained distribution.

  1. Get a copy of ubuntu server. Here is a complete guide to install a Ubuntu Hardy Heron LAMP Server in 15 minutes.
  2. if installing in virtualbox, Hardy Heron 8.04 requires that you enable PAE/NX in settings, which exposes your CPUs Physical Address Extensions to the guest OS. Otherwise, all you’ll get would be a kernel error message.
  3. change /etc/network/interfaces to assign a static IP address:

comment the line

#iface eth0 inet dhcp

and append something like this (of course, values depend on desired configuration):

iface eth0 inet static
address 192.168.1.100
netmask 255.255.255.0
network 192.168.1.0
broadcast 192.168.1.255
gateway 192.168.1.254

Oh, and don’t you forget to restart networking:

sudo /etc/init.d/networking restart


Et voilà, you should now be able to open a browser window and navigate to your server’s IP.

You should Ubuntu’s apache default page, saying something like “It works!”

Written by Davide Orazio Montersino

March 7th, 2009 at 8:14 pm

Posted in Senza categoria