Tag Archives | sysadmin

Multiple project Trac set-up

I’ve already installed Trac and I now want to be able to set-up multiple projects with the minimum of fuss. My requirements are: Not having to mess with the Apache configuration every time I add a new project because I don’t want to have to restart apache Make some simple modifications to the stanadard trac.ini [...]

Continue Reading

Subversion over ssh

My background task over the Christmas holidays was to ensure that I had the ability to give read/write access to a subversion repository situated on a machine within our corporate network so that staff or external contractors can access it via the interweb but without me needing to open up additional ports on our firewall. [...]

Continue Reading

MySQL replication

More brain dumping, this time after setting up MySQL on my test server to replicate offsite as the data on there is becoming important. To start with both machines are running fully updated and upgraded Debian Etch and MySQL 5 as a Debian package with identical copies of the MySQL databases in /var/lib/mysql/. On the [...]

Continue Reading

Move multiple subversion repositories

Need to move multiple subversion repositories? Well I just finished putting a simple how-to together which details the steps I took when moving our 30+ svn projects from one server to another. It went really smoothly and took about a quarter of the time I was expecting it to. Anyway, here it is. Related: Creating [...]

Continue Reading

Flush the qmail queue

My secondary mail server (that runs qmail) had a load of email queued up today that I needed to flush. Googling comes back with people saying run qmail with daemontools then you can use on of the nice qmailctl scripts to do a ‘doqueue’. Needless to say I’m not running with daemontools (my primary is), [...]

Continue Reading

Nightmare MySQL migration

I've been migrating a large number of websites over from one server to another, always an enjoyable task. So I get to the last one, copy the database over and do the normal mysql import along the lines of: [code]mysql -ufoo -pbar database_name < database_name.sql[/code] Errors++ Turns out the Donke^H^H^H^HDeveloper who built the application didn't [...]

Continue Reading

Excluding folders when creating a tarball

When creating a tarball, to exclude folders one simply uses the –exclude= flag: For example to tar up the contents of /var/log but to exclude /var/log/apache & /var/log/mail/ tar -jcvf logfiles.ta cheap viagra online without prescription r.bz2 /var/log/* –exclude=/var/log/apache/* –exclude=/var/log/mail/* Just in case you didn't already know then the 'j' flag in the 'jcvf' tells [...]

Continue Reading