From patchwork Mon Jul 29 14:46:33 2013 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit X-Patchwork-Submitter: Ralf Baechle X-Patchwork-Id: 262812 Return-Path: X-Original-To: incoming@patchwork.ozlabs.org Delivered-To: patchwork-incoming@bilbo.ozlabs.org Received: from ozlabs.org (localhost [IPv6:::1]) by ozlabs.org (Postfix) with ESMTP id 0227F2C0135 for ; Tue, 30 Jul 2013 00:53:23 +1000 (EST) X-Greylist: delayed 396 seconds by postgrey-1.34 at bilbo; Tue, 30 Jul 2013 00:53:17 EST Received: from git.linux-mips.org (marvin.linux-mips.org [78.24.191.183]) by ozlabs.org (Postfix) with ESMTP id 805552C0109 for ; Tue, 30 Jul 2013 00:53:17 +1000 (EST) Received: from localhost.localdomain ([127.0.0.1]:52754 "EHLO linux-mips.org" rhost-flags-OK-OK-OK-FAIL) by eddie.linux-mips.org with ESMTP id S6816743Ab3G2Oqgy0NNz (ORCPT ); Mon, 29 Jul 2013 16:46:36 +0200 Received: from scotty.linux-mips.net (localhost.localdomain [127.0.0.1]) by scotty.linux-mips.net (8.14.5/8.14.4) with ESMTP id r6TEkYxp024954 for ; Mon, 29 Jul 2013 16:46:34 +0200 Received: (from ralf@localhost) by scotty.linux-mips.net (8.14.5/8.14.5/Submit) id r6TEkXEn024953 for patchwork@lists.ozlabs.org; Mon, 29 Jul 2013 16:46:33 +0200 Date: Mon, 29 Jul 2013 16:46:33 +0200 From: Ralf Baechle To: patchwork@lists.ozlabs.org Subject: Patchwork broken after server update Message-ID: <20130729144633.GA23881@linux-mips.org> MIME-Version: 1.0 Content-Disposition: inline User-Agent: Mutt/1.5.21 (2010-09-15) X-BeenThere: patchwork@lists.ozlabs.org X-Mailman-Version: 2.1.15 Precedence: list List-Id: Patchwork development List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: patchwork-bounces+incoming=patchwork.ozlabs.org@lists.ozlabs.org Sender: "Patchwork" I've upgraded linux-mips.org from Fedora 17 which was reaching EOL to Fedora 19. Since then patchwork is no longer working. The first issue is that patchwork was no longer accepting new patches via the apps/patchwork/bin/parsemail.sh script. When I was trying to invoke it manually, it only printed "no project found". I was able to figure out that this was caused by changes to the database scheme which are taken care of by the two SQL scripts: lib/sql/migration/012-project-add-columns.sql lib/sql/migration/013-bundle-names.sql The catch - these first script don't run with MySQL - or rather MariaDB that Fedora has switched to. MariaDB doesn't like the quotes around the table and column names. Patch below. With the database scheme fixed patchwork now appears to properly filter patch from email into its database. The web interface is a bit harder. First, Fedora has retired mod_python which I previously was using, so short of resurrecting that module from the dead I decided to switch to the wsgi interface instead. But still no success with the webapp. All I get for an access to patchwork.linux-mips.org is a "Server Error (500)" Nothing useful in apache log files, even with loglevel cranked up to infinity other than the already known fact that the script resulted in a server error 500. Django version is 1.5.1, Python 2.7.3, Apache 2.4.4, patchwork is latest from git, 4e7b62c5 [notifications: add project name to patch update notification]. Any ideas? Ralf diff --git a/lib/sql/migration/012-project-add-columns.sql b/lib/sql/migration/012-project-add-columns.sql index d984ad2..ecade28 100644 --- a/lib/sql/migration/012-project-add-columns.sql +++ b/lib/sql/migration/012-project-add-columns.sql @@ -1,5 +1,5 @@ BEGIN; -ALTER TABLE "patchwork_project" ADD COLUMN "web_url" varchar(2000); -ALTER TABLE "patchwork_project" ADD COLUMN "scm_url" varchar(2000); -ALTER TABLE "patchwork_project" ADD COLUMN "webscm_url" varchar(2000); +ALTER TABLE patchwork_project ADD COLUMN web_url varchar(2000); +ALTER TABLE patchwork_project ADD COLUMN scm_url varchar(2000); +ALTER TABLE patchwork_project ADD COLUMN webscm_url varchar(2000); COMMIT;