Date: Sun, 26 Sep 2010 22:28:59 +0200 (CEST) From: Rodrigo OSORIO (ros) <rodrigo@bebik.net> To: FreeBSD-gnats-submit@FreeBSD.org Subject: ports/150974: www/cybercalendar : port fix / deprecate Message-ID: <20100926202859.2C9D82847C@hodja.bebik.net> Resent-Message-ID: <201009262030.o8QKUEZO065680@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>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:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20100926202859.2C9D82847C>