NetBSD Problem Report #46707

From markus@marsrakete.de  Mon Jul 16 07:36:42 2012
Return-Path: <markus@marsrakete.de>
Received: from mail.netbsd.org (mail.netbsd.org [149.20.53.66])
	by www.NetBSD.org (Postfix) with ESMTP id 9805C63B85F
	for <gnats-bugs@gnats.NetBSD.org>; Mon, 16 Jul 2012 07:36:42 +0000 (UTC)
Message-Id: <20120716073638.124AF2D583@mail.marsrakete.de>
Date: Mon, 16 Jul 2012 09:36:38 +0200 (CEST)
From: markus@marsrakete.de
Reply-To: markus@marsrakete.de
To: gnats-bugs@gnats.NetBSD.org
Subject: No SQL-Update on roundcube update
X-Send-Pr-Version: 3.95

>Number:         46707
>Category:       pkg
>Synopsis:       No SQL-Update on roundcube update
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    taca
>State:          open
>Class:          change-request
>Submitter-Id:   net
>Arrival-Date:   Mon Jul 16 07:40:00 +0000 2012
>Closed-Date:    
>Last-Modified:  Wed Dec 05 15:40:04 +0000 2012
>Originator:     Markus Illenseer
>Release:        NetBSD 5.1_STABLE
>Organization:
--
Markus Illenseer
>Environment:


System: NetBSD beaver.marsrakete.de 5.1_STABLE NetBSD 5.1_STABLE (BEAVER) #2: Wed Sep 21 21:00:36 CEST 2011 tron@beaver.marsrakete.de:/usr/src/sys/arch/i386/compile/BEAVER i386
Architecture: i386
Machine: i386
>Description:
	After a "make update" for latest pkgsrc "roundcube", it does not update the SQL-Database. This resulted into a non-working application, as for example the adressbook was not editable for the user.
>How-To-Repeat:
	make update
>Fix:
        There is a shell-script provided by roundcube, which performs the updates, requires the correct "old" and "current" versions, though. Probably a patch to this files is required, as well as a notice to start this script after the pkgsrc-update is done.

>Release-Note:

>Audit-Trail:

Responsible-Changed-From-To: pkg-manager->taca
Responsible-Changed-By: wiz@NetBSD.org
Responsible-Changed-When: Mon, 16 Jul 2012 18:47:46 +0000
Responsible-Changed-Why:
over to maintainer.


From: Takahiro Kambe <taca@back-street.net>
To: gnats-bugs@NetBSD.org, markus@marsrakete.de
Cc: 
Subject: Re: pkg/46707: No SQL-Update on roundcube update
Date: Fri, 10 Aug 2012 12:14:37 +0900 (JST)

 In message <20120716074000.AF11B63BA6C@www.NetBSD.org>
 	on Mon, 16 Jul 2012 07:40:00 +0000 (UTC),
 	markus@marsrakete.de wrote:
 >>Description:
 > 	After a "make update" for latest pkgsrc "roundcube", it does
 > 	not update the SQL-Database. This resulted into a non-working
 > 	application, as for example the adressbook was not editable
 > 	for the user.
 Yes, proper upgrading process is required.

 >>Fix:
 >         There is a shell-script provided by roundcube, which
 >         performs the updates, requires the correct "old" and
 >         "current" versions, though. Probably a patch to this files
 >         is required, as well as a notice to start this script after
 >         the pkgsrc-update is done.
 Since these files and upgrade document are already contained in the
 package, how about to some tweak to MESSAGE?

 -- 
 Takahiro Kambe <taca@back-street.net>

 Index: MESSAGE
 ===================================================================
 RCS file: /cvsroot/pkgsrc/mail/roundcube/MESSAGE,v
 retrieving revision 1.6
 diff -u -u -r1.6 MESSAGE
 --- MESSAGE	30 Jul 2008 21:29:56 -0000	1.6
 +++ MESSAGE	10 Aug 2012 03:13:47 -0000
 @@ -6,8 +6,13 @@

  	${DOCDIR}/INSTALL

 +And please refer to the following file on how to upgrade your RoundCube
 +from older version.
 +
 +	${DOCDIR}/UPGRADING
 +
  For pkgsrc installations the RoundCube package is installed in
 -non-default locations.
 +these locations.

  	Log files:		${VARBASE}/log/roundcube/
  	Document root:		${PREFIX}/share/roundcube/
 @@ -18,9 +23,4 @@

  	Include ${PKG_SYSCONFDIR}/roundcube.conf

 -NOTE: The location of some of the roundcube configuration files
 -has changed.  In addition to this please read the note in the
 -${PKG_SYSCONFDIR}/roundcube.conf file about the protection of the
 -installer directory.
 -
  ===========================================================================

State-Changed-From-To: open->feedback
State-Changed-By: taca@NetBSD.org
State-Changed-When: Sun, 12 Aug 2012 16:22:07 +0000
State-Changed-Why:
Some improvement to MESSAGE.  Is it enough to this problem?


From: "Takahiro Kambe" <taca@netbsd.org>
To: gnats-bugs@gnats.NetBSD.org
Cc: 
Subject: PR/46707 CVS commit: pkgsrc/doc
Date: Sun, 12 Aug 2012 16:20:22 +0000

 Module Name:	pkgsrc
 Committed By:	taca
 Date:		Sun Aug 12 16:20:22 UTC 2012

 Modified Files:
 	pkgsrc/doc: CHANGES-2012

 Log Message:
 Note update of mail/roundcube package to 0.7.2nb3.

 Focus on PR pkg/46707.


 To generate a diff of this commit:
 cvs rdiff -u -r1.2542 -r1.2543 pkgsrc/doc/CHANGES-2012

 Please note that diffs are not public domain; they are subject to the
 copyright notices on the relevant files.

From: Markus Illenseer <markus@marsrakete.de>
To: "gnats-bugs@NetBSD.org" <gnats-bugs@NetBSD.org>
Cc: "pkgsrc-bugs@netbsd.org" <pkgsrc-bugs@netbsd.org>,
 "gnats-admin@netbsd.org" <gnats-admin@netbsd.org>,
 "taca@NetBSD.org" <taca@NetBSD.org>
Subject: Re: pkg/46707 (No SQL-Update on roundcube update)
Date: Wed, 22 Aug 2012 20:40:52 +0200

 Yes, mentioning the Update Procedure for MySQL within the MESSAGE will be su=
 fficient.
 Is there a way to display the former and the newly installed version in orde=
 r to show the update path, which is required for the SQL-Update?

 --
 markus illenseer

 Am 12.08.2012 um 18:22 schrieb taca@NetBSD.org:

 > Synopsis: No SQL-Update on roundcube update
 >=20
 > State-Changed-From-To: open->feedback
 > State-Changed-By: taca@NetBSD.org
 > State-Changed-When: Sun, 12 Aug 2012 16:22:07 +0000
 > State-Changed-Why:
 > Some improvement to MESSAGE.  Is it enough to this problem?
 >=20
 >=20

State-Changed-From-To: feedback->open
State-Changed-By: tron@NetBSD.org
State-Changed-When: Wed, 05 Dec 2012 08:53:59 +0000
State-Changed-Why:
Feedback was provided a while ago.


From: Takahiro Kambe <taca@NetBSD.org>
To: markus@marsrakete.de
Cc: gnats-bugs@NetBSD.org
Subject: Re: pkg/46707 (No SQL-Update on roundcube update)
Date: Thu, 06 Dec 2012 00:39:39 +0900 (JST)

 Hi,

 I missed last paragraph of your message.

 >> Is there a way to display the former and the newly installed
 >> version in order to show the update path, which is required for the
 >> SQL-Update?
 I've looked at update.sh script and it really require to specify the
 previous roundcube's version.

 Since updating database's data dosen't contain roundcube's version
 information, it is unknown what version of roundcube package was
 installed after updating roundcube pacakge to latest one.  

 So, before update the roundcube pacakge, you needs to check the
 version with "pkg_info -I roundcube".

 I've added it to MESSAGE file during update roundcube package to
 0.8.4.

 -- 
 Takahiro Kambe <taca@NetBSD.org>/<taca@back-street.net>

>Unformatted:

NetBSD Home
NetBSD PR Database Search

(Contact us) $NetBSD: query-full-pr,v 1.39 2013/11/01 18:47:49 spz Exp $
$NetBSD: gnats_config.sh,v 1.8 2006/05/07 09:23:38 tsutsui Exp $
Copyright © 1994-2007 The NetBSD Foundation, Inc. ALL RIGHTS RESERVED.