Webcalendar - Revision history

PhilippeTeuwen: Reverted edits by Etegohy (Talk) to last revision by PhilippeTeuwen

2010-11-24T20:35:42Z

Reverted edits by Etegohy (Talk) to last revision by PhilippeTeuwen

Can't load revision 6857

at 00:31, 24 November 2010

2010-11-24T00:31:31Z

Can't load revision 6699

PhilippeTeuwen: /* Upgrade from 1.0.15 to 1.2.0+dfsg-2 */

2009-06-09T20:26:21Z

Upgrade from 1.0.15 to 1.2.0+dfsg-2

← Older revision		Revision as of 20:26, 9 June 2009
Line 77:		Line 77:

	Then I encountered [http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=530842 Bug#530842] and found a workaround, see the bugreport.		Then I encountered [http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=530842 Bug#530842] and found a workaround, see the bugreport.
			<br>Maybe the bug is already fixed while you're reading those lines.

			Last issue: immediately after the upgrade, I wrote a fake appointment to check notifications and the notification was sent only 5h later.
			<br>A day later, all hours of my appointments were shifted back by 5h (so e.g. 3h00 instead of 8h00).
			<br>It appears that everything was converted to EDT (NYC time), so I fixed it in my preferences and now everything is ok.

PhilippeTeuwen: /* Upgrade from 1.0.15 to 1.2.0+dfsg-2 */

2009-06-05T15:40:29Z

Upgrade from 1.0.15 to 1.2.0+dfsg-2

← Older revision		Revision as of 15:40, 5 June 2009
Line 51:		Line 51:
	)		)
	===Upgrade from 1.0.15 to 1.2.0+dfsg-2===		===Upgrade from 1.0.15 to 1.2.0+dfsg-2===
			I got an obscur "query failed" error without any info.

			So I tried the install script which is normally there to help you to upgrade your DB.

	Edit /usr/share/webcalendar/www/install/index.php		Edit /usr/share/webcalendar/www/install/index.php
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />		<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
Line 69:		Line 73:
	So now it could log in.		So now it could log in.
	<br>Accept DB update and accept GMT conversion		<br>Accept DB update and accept GMT conversion

			Then I discovered that on Debian /etc/webcalendar/settings.conf is still the one used so I migrated manually some of the new stuffs from settings.php to settings.conf.

			Then I encountered [http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=530842 Bug#530842] and found a workaround, see the bugreport.

PhilippeTeuwen: /* Upgrade from 1.0.15 to 1.2.0+dfsg-2 */

2009-06-05T12:12:06Z

Upgrade from 1.0.15 to 1.2.0+dfsg-2

← Older revision		Revision as of 12:12, 5 June 2009
Line 59:		Line 59:
	Go to http://your.website/webcalendar/install/		Go to http://your.website/webcalendar/install/
	<br>Choose install password		<br>Choose install password
			chmod 755 /usr/share/webcalendar/www/includes
	mv /usr/share/webcalendar/www/includes/settings.php /etc/webcalendar		mv /usr/share/webcalendar/www/includes/settings.php /etc/webcalendar
	ln -s /etc/webcalendar/settings.php /usr/share/webcalendar/www/includes/settings.php		ln -s /etc/webcalendar/settings.php /usr/share/webcalendar/www/includes/settings.php

PhilippeTeuwen at 12:10, 5 June 2009

2009-06-05T12:10:20Z

← Older revision		Revision as of 12:10, 5 June 2009
Line 50:		Line 50:
	0 // arg 2		0 // arg 2
	)		)
			===Upgrade from 1.0.15 to 1.2.0+dfsg-2===
			Edit /usr/share/webcalendar/www/install/index.php
			<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
			=>
			<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-15" />

			chmod 777 /usr/share/webcalendar/www/includes
			Go to http://your.website/webcalendar/install/
			<br>Choose install password
			mv /usr/share/webcalendar/www/includes/settings.php /etc/webcalendar
			ln -s /etc/webcalendar/settings.php /usr/share/webcalendar/www/includes/settings.php
			Connect with newly defined password

			For SQL connection the pwd contained a "#" but the new webcalendar install interface tells me it's an invalid char so I had to change the pwd via phpMyAdmin (mysql/user/edit webcalendar user/Password: fct PASSWORD etc/Execute) then on sql server:
			/etc/init.d/mysql reload

			So now it could log in.
			<br>Accept DB update and accept GMT conversion

PhilippeTeuwen at 17:33, 17 November 2006

2006-11-17T17:33:14Z

← Older revision		Revision as of 17:33, 17 November 2006
Line 9:		Line 9:
	Provides: php4, php4-cli, php4-mysql, mysql-client		Provides: php4, php4-cli, php4-mysql, mysql-client
	Architecture: all		Architecture: all
	Description: Allows to install webcalendar with php5~~%%% Provides php4 and mysql dependancies to satisfy webcalendar~~		Description: Allows to install webcalendar with php5
			Provides php4 and mysql dependancies to satisfy webcalendar

	Then we can install this fresh package and webcalendar		Then we can install this fresh package and webcalendar
Line 17:		Line 18:
	<br>Create the DB and tables		<br>Create the DB and tables
	mysqladmin -p create webcalendar		mysqladmin -p create webcalendar
			mysql -p
	~~mysql~~ ~~-p%%%~~GRANT ALL ON webcalendar.* TO webcalendar@private IDENTIFIED BY '<pwd>';		GRANT ALL ON webcalendar.* TO webcalendar@private IDENTIFIED BY '<pwd>';
	mysql -p webcalendar < webcalendar-tables-mysql.sql (From /usr/share/webcalendar/sql/tables-mysql.sql)		mysql -p webcalendar < webcalendar-tables-mysql.sql (From /usr/share/webcalendar/sql/tables-mysql.sql)
	cp /usr/share/webcalendar/tools/settings.conf /etc/webcalendar/settings.conf		cp /usr/share/webcalendar/tools/settings.conf /etc/webcalendar/settings.conf

PhilippeTeuwen at 17:31, 17 November 2006

2006-11-17T17:31:42Z

New page

Attempt to run it with php5!

First we have to fix the dependencies of webcalendar
apt-get install equivs
equivs webcalendar-equivs
edit webcalendar-equivs.ctl:
Package: webcalendar-equivs
Depends: php5, php5-cli, php5-mysql
Provides: php4, php4-cli, php4-mysql, mysql-client
Architecture: all
Description: Allows to install webcalendar with php5%%% Provides php4 and mysql dependancies to satisfy webcalendar

Then we can install this fresh package and webcalendar
dpkg -i webcalendar-equivs_1.0_all.deb
apt-get install webcalendar
I've chosen not to rely on debconf
<br>Create the DB and tables
mysqladmin -p create webcalendar
mysql -p%%%GRANT ALL ON webcalendar.* TO webcalendar@private IDENTIFIED BY '<pwd>';
mysql -p webcalendar < webcalendar-tables-mysql.sql (From /usr/share/webcalendar/sql/tables-mysql.sql)
cp /usr/share/webcalendar/tools/settings.conf /etc/webcalendar/settings.conf
Edit settings.conf:
db_type = mysql
db_host = sql
db_login = webcalendar
db_password = <pwd>
db_database = webcalendar
db_persistent = true
single_user = N
use_http_auth = false
Default admin is admin:admin

To setup the reminders, we've to fix some bugs:
cd /usr/share/webcalendar/
ln -s www/includes/
cd /usr/share/webcalendar/tools
ln -s ../www/translations/
Then edit /etc/cron.d/webcalendar
1,6,11,16,21,26,31,36,41,46,51,56 * * * * root cd /usr/share/webcalendar/tools/; php send_reminders.php
Edit settings from the web interface at least to fix the URL (if SSL) and the sender email

I like to be able to add an URL to some of the events, so I edit /etc/webcalendar/site_extras.php and add a sub-array to $site_extras:
array (
"URL", // unique name of this extra field (used in db)
"URL", // how this field will be described to users
$EXTRA_URL, // type of field
0, // arg 1
0 // arg 2
)