Explore Posterous

Git: Installation eines eigenen Servers auf Basis von Ubuntu 9.10 (samt Trac)

Leider haben sowohl Posterous als auch Blogger mich dazu gezwungen, das Dokument nur im PDF-Format anbieten zu können, da sich beide System entweder an der Länge und/oder den Sonderzeichen im Text verschluckt haben.

Fragen und Kommentare bitte trotzdem in die Kommentare.

Click here to download:

Git und Trac.pdf (78 KB)

Loading mentions Retweet

Comment (0) »

Migrating Trac from SQLite to MySQL

A little while ago I was tasked with migrating about hundred Trac instances from SQLite to MySQL. Unfortunately SQLites schema definitions is not compatible with MySQL. So I had to write some scripts to handle it. After a little bit of experimenting everything worked perfectly.

The Strategy I employed was like this:

1. Make a dump of a default MySQL Trac db schema.
2. Make a dump of the Trac SQLite database
3. Remove db schema definitions from the SQLite dump
4. Concatenate the MySQL and SQLite dumps
5. Load data into MySQL
6. Edit Trac's database settings to use MySQL
7. Do a trac-admin upgrade

Here is the shell script I made:

MYSQL_USER=username
MYSQL_PSWD=password

SQLITECMD=sqlite3
TRACBASE=/path/to/tracreps


# loop through all trac instances in tracreps
for d in $( ls $TRACBASE )
do
if [ -d "$TRACBASE/$d" ]; then
echo $d
TRACNAME=$d

# create database in mysql
echo "creating database for $TRACNAME..."
mysqladmin --user $MYSQL_USER -p$MYSQL_PSWD create $TRACNAME

# dump sqlite db structure + data
echo "dumping data from sqlite..."
$SQLITECMD $TRACBASE/$TRACNAME/db/trac.db .dump > trac.sqlite.sql

# remove database definitions from dump using a custom python script
echo "cleaning database definition from dump..."
`./cleansql.py < trac.sqlite.sql > trac.sqlite.sql.dataonly`

# concatenate mysql database definitions and sqlite data
cat trac.mysql.sql trac.sqlite.sql.dataonly > trac.sql

echo "loading data into mysql..."
mysql --user $MYSQL_USER -p$MYSQL_PSWD --default_character_set utf8 $TRACNAME < trac.sql

# edit database connection string in trac.ini
sed -i "s?sqlite:db/trac.db?mysql://$MYSQL_USER:$MYSQL_PSWD@localhost:3306/$TRACNAME?" $TRACBASE/$TRACNAME/conf/trac.ini

echo "upgrading mysql database..."
trac-admin $TRACBASE/$TRACNAME upgrade --no-backup

To remove schema definitions from the sqlite dump and fix some incompatibilities I made this python script referenced above as cleansql.py:

#!/usr/bin/env python

import sys
import re

file = sys.stdin.read()
file = re.sub(r'(CREATE (TABLE|INDEX)[^;]*|COMMIT|BEGIN TRANSACTION);', '', file)
file = re.sub(r'INSERT INTO "([^"]+)"', lambda m: 'INSERT INTO `%s`' % m.groups(1), file)
# fix sql for reports
file = re.sub(r'CAST\((.+) AS int\)', lambda m: 'CAST(%s AS signed)' % m.groups(1), file)

sys.stdout.write(file)

And that's it. I hope this will benefit someone tasked with the same job.

Loading mentions Retweet

Comment (0) »

Textmate Trac Bundle Updated

I just released version 1.2 of my Textmate Trac bundle.  It includes an awesome new Preview command contributed by Tudor Marghidanu.  While editing a Trac wiki page, just hit command-option-control-p (same as Markdown, etc.) to pop up an HTML formatted preview of the page.  Seriously useful.  Thanks Tudor!

Loading mentions Retweet

Comment (0) »

Running trac-git on Ubuntu 9.04 Server

It took me around two hours to figure out, why Trac was always throwing the following error, when launched using tracd:

Warning: Can't synchronize with the repository (Unsupported version control system "git":
 Can't find an appropriate component, maybe the corresponding plugin was not 
enabled? ). Look in the Trac log for more information.

The Ubuntu package trac-git was perfectly installed and seemed to work fine. The real reason was that the Ubuntu package trac-git depends on python2.6, which obviously doesn't work with trac-git.

So I did an

aptitude install python2.5 && rm /usr/bin/python && ln -s /usr/bin/python2.5 /usr/bin/python

which did the trick. After that, tracd was able to use the trac plugin for Git.

If it still doesn't work make sure that you have at least the following lines in your project's trac.ini:

[components] 
# for plugin version 0.10 
gitplugin.* = enabled 
 # for plugin version 0.11.0.1+ 
tracext.git.* = enabled 
 [git] 
cached_repository = true 
git_bin = /usr/bin/git 
persistent_cache = true 
shortrev_len = 7 
 [trac] 
repository_dir = /path/to/git/repository.git 
repository_type = git

If everything above is set a

tracd --port 8000 /var/trac/yourpath

should start tracd and make it available via port 8000 on your machine.

Loading mentions Retweet

Comment (0) »

installing trac

Loading mentions Retweet

Comment (0) »

replicating a subversion repository with svnsync

svnadmin create svn.example.com

echo '#!/bin/sh' > svn.example.com/hooks/pre-revprop-change
chmod +x svn.example.com/hooks/pre-revprop-change

svnsync init file://$PWD/svn.example.com https://svn.example.com/

svnsync sync file://$PWD/svn.example.com

crontab -e

*/5 * * * * /usr/bin/svnsync sync --non-interactive file:///opt/svn.example.com

Loading mentions Retweet

Comment (0) »

pools.jp | フリーのSubversion & Tracサービス(assembla)を使う

Loading mentions Retweet

Comment (0) »