Date: Thu, 4 Nov 2010 10:00:27 GMT From: "Rodrigo OSORIO (ros)" <rodrigo@bebik.net> To: freebsd-ports-bugs@FreeBSD.org Subject: Re: ports/150974: www/cybercalendar : port fix / deprecate Message-ID: <201011041000.oA4A0R5C030083@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
The following reply was made to PR ports/150974; it has been noted by GNATS.
From: "Rodrigo OSORIO (ros)" <rodrigo@bebik.net>
To: wen heping <wenheping@gmail.com>
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--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201011041000.oA4A0R5C030083>