From owner-freebsd-ports-bugs@FreeBSD.ORG Thu Nov 4 10:00:43 2010 Return-Path: Delivered-To: freebsd-ports-bugs@hub.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 046AE1065911 for ; Thu, 4 Nov 2010 10:00:42 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:4f8:fff6::28]) by mx1.freebsd.org (Postfix) with ESMTP id 7514F8FC2A for ; Thu, 4 Nov 2010 10:00:27 +0000 (UTC) Received: from freefall.freebsd.org (localhost [127.0.0.1]) by freefall.freebsd.org (8.14.4/8.14.4) with ESMTP id oA4A0RVe030096 for ; Thu, 4 Nov 2010 10:00:27 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.4/8.14.4/Submit) id oA4A0R5C030083; Thu, 4 Nov 2010 10:00:27 GMT (envelope-from gnats) Date: Thu, 4 Nov 2010 10:00:27 GMT Message-Id: <201011041000.oA4A0R5C030083@freefall.freebsd.org> To: freebsd-ports-bugs@FreeBSD.org From: "Rodrigo OSORIO (ros)" Cc: Subject: Re: ports/150974: www/cybercalendar : port fix / deprecate X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: "Rodrigo OSORIO \(ros\)" List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 04 Nov 2010 10:00:43 -0000 The following reply was made to PR ports/150974; it has been noted by GNATS. From: "Rodrigo OSORIO (ros)" To: wen heping Cc: bug-followup@FreeBSD.org Subject: Re: ports/150974: www/cybercalendar : port fix / deprecate Date: Thu, 4 Nov 2010 10:41:46 +0100 --EeQfGwPcQSOJBaQU Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On 03/11/10 16:08 +0800, wen heping wrote: > But where is the patch file ? > > wen > Hi, You right, there is a missing file. The attached file is the original fix; I suppose you don't need a patch to add the DEPRECATE flag into the Makefile. regards - rodrigo --EeQfGwPcQSOJBaQU Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="cybercalendar.patch" diff -rupN cybercalendar/files/patch-setup-db-calendar.sql cybercalendar.new/files/patch-setup-db-calendar.sql --- cybercalendar/files/patch-setup-db-calendar.sql 1970-01-01 01:00:00.000000000 +0100 +++ cybercalendar.new/files/patch-setup-db-calendar.sql 2010-09-26 21:15:24.000000000 +0200 @@ -0,0 +1,20 @@ +--- setup/db/calendar.sql 2001-03-21 02:19:48.000000000 +0100 ++++ setup/db/calendar.sql 2010-09-21 20:31:13.000000000 +0200 +@@ -118,7 +118,7 @@ + CREATE TABLE users ( + uid int(11) NOT NULL auto_increment, + username varchar(25) DEFAULT '' NOT NULL, +- password varchar(25) DEFAULT '' NOT NULL, ++ password varchar(50) DEFAULT '' NOT NULL, + accesslevel tinyint(2), + fullname varchar(255), + email varchar(255), +@@ -185,7 +185,7 @@ + # + + CREATE TABLE submitted_events ( +- eventid int(11) NOT NULL DEFAULT '0' auto_increment, ++ eventid int(11) NOT NULL auto_increment, + site_id int(11) DEFAULT '0' NOT NULL, + calendar varchar(255) DEFAULT '' NOT NULL, + sub_name varchar(255) DEFAULT '', diff -rupN cybercalendar/files/patch-setup-db-caluser.sql cybercalendar.new/files/patch-setup-db-caluser.sql --- cybercalendar/files/patch-setup-db-caluser.sql 1970-01-01 01:00:00.000000000 +0100 +++ cybercalendar.new/files/patch-setup-db-caluser.sql 2010-09-26 21:15:24.000000000 +0200 @@ -0,0 +1,18 @@ +--- setup/db/caluser.sql 2001-03-14 01:12:52.000000000 +0100 ++++ setup/db/caluser.sql 2010-09-21 20:29:01.000000000 +0200 +@@ -11,13 +11,12 @@ + # Inserts user account into MySQL user table + # MAKE SURE TO CHANGE THE PASSWORD + +-INSERT INTO user VALUES ('localhost', 'caluser', password('4caladmin'), 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'); +- ++CREATE USER 'caluser'@'localhost' IDENTIFIED BY '4caladmin'; + + # Inserts user permissions for calendar table + # MAKE SURE THE TABLE NAME, HOST, AND USERNAME + # ARE CORRECT. + +-INSERT INTO db VALUES ('localhost', 'calendar', 'caluser', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'Y', 'Y'); ++GRANT SELECT,INSERT,UPDATE,DELETE ON calendar.* TO 'caluser'@'localhost' ; + + FLUSH PRIVILEGES; --EeQfGwPcQSOJBaQU--