From owner-freebsd-ports-bugs@FreeBSD.ORG Sun Sep 26 20:30:14 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 82AED106566B for ; Sun, 26 Sep 2010 20:30:14 +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 463FC8FC0C for ; Sun, 26 Sep 2010 20:30:14 +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 o8QKUEGC065690 for ; Sun, 26 Sep 2010 20:30:14 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.4/8.14.4/Submit) id o8QKUEZO065680; Sun, 26 Sep 2010 20:30:14 GMT (envelope-from gnats) Resent-Date: Sun, 26 Sep 2010 20:30:14 GMT Resent-Message-Id: <201009262030.o8QKUEZO065680@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-ports-bugs@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, Rodrigo OSORIO (ros) Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id AAD76106564A for ; Sun, 26 Sep 2010 20:29:06 +0000 (UTC) (envelope-from rodrigo@bebik.net) Received: from smtp2-g21.free.fr (smtp2-g21.free.fr [212.27.42.2]) by mx1.freebsd.org (Postfix) with ESMTP id 4093D8FC08 for ; Sun, 26 Sep 2010 20:29:04 +0000 (UTC) Received: from hodja.bebik.net (unknown [82.235.223.127]) by smtp2-g21.free.fr (Postfix) with ESMTP id 5B48F4B00A3 for ; Sun, 26 Sep 2010 22:29:00 +0200 (CEST) Received: by hodja.bebik.net (Postfix, from userid 1001) id 2C9D82847C; Sun, 26 Sep 2010 22:28:59 +0200 (CEST) Message-Id: <20100926202859.2C9D82847C@hodja.bebik.net> Date: Sun, 26 Sep 2010 22:28:59 +0200 (CEST) From: Rodrigo OSORIO (ros) To: FreeBSD-gnats-submit@FreeBSD.org X-Send-Pr-Version: 3.113 Cc: Subject: 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: Sun, 26 Sep 2010 20:30:14 -0000 >Number: 150974 >Category: ports >Synopsis: www/cybercalendar : port fix / deprecate >Confidential: no >Severity: non-critical >Priority: low >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: sw-bug >Submitter-Id: current-users >Arrival-Date: Sun Sep 26 20:30:13 UTC 2010 >Closed-Date: >Last-Modified: >Originator: Rodrigo OSORIO (ros) >Release: FreeBSD 7.1-RELEASE amd64 >Organization: >Environment: System: FreeBSD home 8.1-RELEASE FreeBSD 8.1-RELEASE #0: Mon Jul 19 02:36:49 UTC 2010 root@mason.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC amd64 >Description: The Cybercalendar port is quite outdated and the database creation scripts doesn't work with the new mysql versions. This patch fix the problem adding two files to the existing port. files/patch-setup-db-caluser.sql Who fix the 'caluser' user creation into the mysql database and grants the user permissions in the right way. files/patch-setup-db-calendar.sql Who fix the tables creation SQL scripts using deprecated and erroneous calls I also fix the database structure, extending the password field in the user table to 50 characters to match with the hashes returned by the mysql function password. After that I suggest to declare Cybercallendar deprecate because most of the dates in the forms are hardcoded in the scripts and there is no way to declare events *after* 2010 in the calendar without code changes. DEPRECATED= Use www/webcalendar instead >How-To-Repeat: >Fix: >Release-Note: >Audit-Trail: >Unformatted: