From patchwork Wed Nov 9 19:26:14 2011 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit X-Patchwork-Submitter: Zygmunt Krynicki X-Patchwork-Id: 4990 Return-Path: X-Original-To: patchwork@peony.canonical.com Delivered-To: patchwork@peony.canonical.com Received: from fiordland.canonical.com (fiordland.canonical.com [91.189.94.145]) by peony.canonical.com (Postfix) with ESMTP id D1D2523E0F for ; Wed, 9 Nov 2011 19:26:19 +0000 (UTC) Received: from mail-fx0-f52.google.com (mail-fx0-f52.google.com [209.85.161.52]) by fiordland.canonical.com (Postfix) with ESMTP id C6296A1810C for ; Wed, 9 Nov 2011 19:26:19 +0000 (UTC) Received: by mail-fx0-f52.google.com with SMTP id n26so2870852faa.11 for ; Wed, 09 Nov 2011 11:26:19 -0800 (PST) Received: by 10.152.144.202 with SMTP id so10mr2547062lab.9.1320866778151; Wed, 09 Nov 2011 11:26:18 -0800 (PST) X-Forwarded-To: linaro-patchwork@canonical.com X-Forwarded-For: patch@linaro.org linaro-patchwork@canonical.com Delivered-To: patches@linaro.org Received: by 10.152.10.72 with SMTP id g8cs183730lab; Wed, 9 Nov 2011 11:26:17 -0800 (PST) Received: by 10.181.11.226 with SMTP id el2mr4233374wid.64.1320866775465; Wed, 09 Nov 2011 11:26:15 -0800 (PST) Received: from indium.canonical.com (indium.canonical.com. [91.189.90.7]) by mx.google.com with ESMTPS id fw12si1456545wbb.18.2011.11.09.11.26.15 (version=TLSv1/SSLv3 cipher=OTHER); Wed, 09 Nov 2011 11:26:15 -0800 (PST) Received-SPF: pass (google.com: best guess record for domain of bounces@canonical.com designates 91.189.90.7 as permitted sender) client-ip=91.189.90.7; Authentication-Results: mx.google.com; spf=pass (google.com: best guess record for domain of bounces@canonical.com designates 91.189.90.7 as permitted sender) smtp.mail=bounces@canonical.com Received: from ackee.canonical.com ([91.189.89.26]) by indium.canonical.com with esmtp (Exim 4.71 #1 (Debian)) id 1RODmp-0000dX-0p for ; Wed, 09 Nov 2011 19:26:15 +0000 Received: from ackee.canonical.com (localhost [127.0.0.1]) by ackee.canonical.com (Postfix) with ESMTP id F2742E01E4 for ; Wed, 9 Nov 2011 19:26:14 +0000 (UTC) MIME-Version: 1.0 X-Launchpad-Project: lava-server X-Launchpad-Branch: ~linaro-validation/lava-server/trunk X-Launchpad-Message-Rationale: Subscriber X-Launchpad-Branch-Revision-Number: 275 X-Launchpad-Notification-Type: branch-revision To: Linaro Patch Tracker From: noreply@launchpad.net Subject: [Branch ~linaro-validation/lava-server/trunk] Rev 275: Add helper scripts for development setup Message-Id: <20111109192614.3833.19775.launchpad@ackee.canonical.com> Date: Wed, 09 Nov 2011 19:26:14 -0000 Reply-To: noreply@launchpad.net Sender: bounces@canonical.com Errors-To: bounces@canonical.com Precedence: bulk X-Generated-By: Launchpad (canonical.com); Revision="14263"; Instance="launchpad-lazr.conf" X-Launchpad-Hash: d4128b00b25e1df2918683b2a571738e8cf11a26 ------------------------------------------------------------ revno: 275 committer: Zygmunt Krynicki branch nick: lava-server timestamp: Fri 2011-10-28 02:29:27 +0200 message: Add helper scripts for development setup added: create-devel-db.sh run-postgresql-instance.sh --- lp:lava-server https://code.launchpad.net/~linaro-validation/lava-server/trunk You are subscribed to branch lp:lava-server. To unsubscribe from this branch go to https://code.launchpad.net/~linaro-validation/lava-server/trunk/+edit-subscription === added file 'create-devel-db.sh' --- create-devel-db.sh 1970-01-01 00:00:00 +0000 +++ create-devel-db.sh 2011-10-28 00:29:27 +0000 @@ -0,0 +1,32 @@ +echo "Setting up development database..." + +lava_instance_user=devel +lava_password=devel +lava_database=devel + +echo "Dropping old database and user" +sudo -u postgres dropdb $lava_database +sudo -u postgres dropuser $lava_instance_user + +echo "Creating new user and database" +# Create database user +sudo -u postgres createuser \ + --no-createdb \ + --encrypted \ + --login \ + --no-superuser \ + --no-createrole \ + --no-password \ + $lava_instance_user + +# Set a password for our new user +sudo -u postgres psql \ + --quiet \ + --command="ALTER USER \"$lava_instance_user\" WITH PASSWORD '$lava_password'" + +# Create a database for our new user +sudo -u postgres createdb \ + --encoding=UTF-8 \ + --owner=$lava_instance_user \ + --no-password \ + $lava_database === added file 'run-postgresql-instance.sh' --- run-postgresql-instance.sh 1970-01-01 00:00:00 +0000 +++ run-postgresql-instance.sh 2011-10-28 00:29:27 +0000 @@ -0,0 +1,2 @@ +#!/bin/sh +DEVEL_DB=pgsql ./lava_server/manage.py $@