DAViCal - Revision history

Ebroch at 15:16, 4 April 2024

2024-04-04T15:16:57Z

← Older revision		Revision as of 09:16, 4 April 2024
Line 1:		Line 1:
	[Calendar\|Back]		[[Calendar\|Back]]
	EL 8/9		EL 8/9
	// Disable selinux, update & reboot		// Disable selinux, update & reboot

Ebroch at 15:16, 4 April 2024

2024-04-04T15:16:31Z

← Older revision		Revision as of 09:16, 4 April 2024
Line 1:		Line 1:
			[Calendar\|Back]
	EL 8/9		EL 8/9

	// Disable selinux, update & reboot		// Disable selinux, update & reboot
	# sed -i-e "s\|^SELINUX=.*$\|SELINUX=disabled\|" /etc/selinux/config		# sed -i-e "s\|^SELINUX=.*$\|SELINUX=disabled\|" /etc/selinux/config

Ebroch at 01:33, 31 March 2024

2024-03-31T01:33:28Z

← Older revision		Revision as of 19:33, 30 March 2024
Line 81:		Line 81:
	Create DNS entry for your DAViCal Calendar & Contact server,		Create DNS entry for your DAViCal Calendar & Contact server,
	browse to it, and enter users and groups: http://davical2.whitehorsetc.com/		browse to it, and enter users and groups: http://davical2.whitehorsetc.com/
	Use 'admin' and password output at database creation (noted above in ~~green~~ font) to log in<br>		Use 'admin' and password output at database creation (noted above in red font) to log in<br>
	*Note: 1) Replace 'davical2.whitehorsetc.com' wherever found with your hostname		*Note: 1) Replace 'davical2.whitehorsetc.com' wherever found with your hostname
	2) Select items in red (tee to END), paste in terminal, and return		2) Select items in red (tee to END), paste in terminal, and return

Ebroch at 01:32, 31 March 2024

2024-03-31T01:32:53Z

← Older revision		Revision as of 19:32, 30 March 2024
Line 26:		Line 26:
	// PostgreSQL service enable and start		// PostgreSQL service enable and start
	# systemctl enable --now postgresql && systemctl status postgresql<br>		# systemctl enable --now postgresql && systemctl status postgresql<br>
	// Create PostgreSQL DAViCal database <span style="color:~~green~~">(Save password which is output after database creation)</span>		// Create PostgreSQL DAViCal database <span style="color:red">(Save password which is output after database creation)</span>
	# sudo -u postgres /usr/share/davical/dba/create-database.sh<br>		# sudo -u postgres /usr/share/davical/dba/create-database.sh<br>
	// If this is a migration import database from old server		// If this is a migration import database from old server

Ebroch at 01:32, 31 March 2024

2024-03-31T01:32:09Z

← Older revision		Revision as of 19:32, 30 March 2024
Line 26:		Line 26:
	// PostgreSQL service enable and start		// PostgreSQL service enable and start
	# systemctl enable --now postgresql && systemctl status postgresql<br>		# systemctl enable --now postgresql && systemctl status postgresql<br>
	// Create PostgreSQL DAViCal database (Save password which is output after database creation)		// Create PostgreSQL DAViCal database <span style="color:green">(Save password which is output after database creation)</span>
	# sudo -u postgres /usr/share/davical/dba/create-database.sh<br>		# sudo -u postgres /usr/share/davical/dba/create-database.sh<br>
	// If this is a migration import database from old server		// If this is a migration import database from old server

Ebroch at 13:41, 28 March 2024

2024-03-28T13:41:03Z

← Older revision		Revision as of 07:41, 28 March 2024
Line 67:		Line 67:
	END<br>		END<br>
	# cat /etc/httpd/conf/httpd.conf		# cat /etc/httpd/conf/httpd.conf
	# systemctl enable ~~httpd && systemctl start~~ httpd && systemctl status httpd<br>		# systemctl enable --now httpd && systemctl status httpd<br>
	// Configure DAViCal to connect to database		// Configure DAViCal to connect to database
	# tee -a /etc/davical/davical2.whitehorsetc.com-conf.php <<END		# tee -a /etc/davical/davical2.whitehorsetc.com-conf.php <<END

Ebroch at 07:06, 28 March 2024

2024-03-28T07:06:29Z

← Older revision		Revision as of 01:06, 28 March 2024
Line 25:		Line 25:
	# cat $file<br>		# cat $file<br>
	// PostgreSQL service enable and start		// PostgreSQL service enable and start
	# systemctl enable ~~postgresql && systemctl start~~ postgresql && systemctl status postgresql<br>		# systemctl enable --now postgresql && systemctl status postgresql<br>
	// Create PostgreSQL DAViCal database (Save password which is output after database creation)		// Create PostgreSQL DAViCal database (Save password which is output after database creation)
	# sudo -u postgres /usr/share/davical/dba/create-database.sh<br>		# sudo -u postgres /usr/share/davical/dba/create-database.sh<br>

Ebroch at 06:15, 28 March 2024

2024-03-28T06:15:27Z

← Older revision		Revision as of 00:15, 28 March 2024
Line 69:		Line 69:
	# systemctl enable httpd && systemctl start httpd && systemctl status httpd<br>		# systemctl enable httpd && systemctl start httpd && systemctl status httpd<br>
	// Configure DAViCal to connect to database		// Configure DAViCal to connect to database
	# tee -a /etc/davical/davical2.whitehorsetc.com-conf.php <<END~~<br>~~		# tee -a /etc/davical/davical2.whitehorsetc.com-conf.php <<END
	<?php		<?php
	\$c->domain_name = "davical2.whitehorsetc.com";		\$c->domain_name = "davical2.whitehorsetc.com";

Ebroch at 06:14, 28 March 2024

2024-03-28T06:14:51Z

← Older revision		Revision as of 00:14, 28 March 2024
Line 1:		Line 1:
	EL 8/9		EL 8/9
	~~Install OS~~

	// Disable selinux, update & reboot		// Disable selinux, update & reboot

Ebroch at 06:12, 28 March 2024

2024-03-28T06:12:18Z

← Older revision		Revision as of 00:12, 28 March 2024
Line 7:		Line 7:
	# setenforce 0		# setenforce 0
	# getenforce		# getenforce
	# yum -y update		# yum -y update<br>

	// Install PostgreSQL and dependencies		// Install PostgreSQL and dependencies
	# yum -y install httpd git php php-pgsql php-gettext postgresql-server perl-DBD-Pg perl-YAML		# yum -y install httpd git php php-pgsql php-gettext postgresql-server perl-DBD-Pg perl-YAML<br>

	// Install DAViCal calendar and contacts server		// Install DAViCal calendar and contacts server
	# cd /usr/share		# cd /usr/share
	# git clone https://gitlab.com/davical-project/davical.git && \		# git clone https://gitlab.com/davical-project/davical.git && \
	git clone https://gitlab.com/davical-project/awl.git && \		git clone https://gitlab.com/davical-project/awl.git && \
	rm -rf ./davical/.git/ && rm -rf ./awl/.git/		rm -rf ./davical/.git/ && rm -rf ./awl/.git/<br>

	// PostgreSQL initialization		// PostgreSQL initialization
	# /usr/bin/postgresql-setup initdb		# /usr/bin/postgresql-setup initdb<br>

	// PostgreSQL user database configuration		// PostgreSQL user database configuration
	# file=/var/lib/pgsql/data/pg_hba.conf		# file=/var/lib/pgsql/data/pg_hba.conf
Line 28:		Line 24:
	# awk -v n=$num -v s="local davical davical_app trust\nlocal davical davical_dba trust" \		# awk -v n=$num -v s="local davical davical_app trust\nlocal davical davical_dba trust" \
	'NR == n {print s} {print}' $file.bak > $file		'NR == n {print s} {print}' $file.bak > $file
	# cat $file		# cat $file<br>

	// PostgreSQL service enable and start		// PostgreSQL service enable and start
	# systemctl enable postgresql && systemctl start postgresql && systemctl status postgresql		# systemctl enable postgresql && systemctl start postgresql && systemctl status postgresql<br>

	// Create PostgreSQL DAViCal database (Save password which is output after database creation)		// Create PostgreSQL DAViCal database (Save password which is output after database creation)
	# sudo -u postgres /usr/share/davical/dba/create-database.sh		# sudo -u postgres /usr/share/davical/dba/create-database.sh<br>

	// If this is a migration import database from old server		// If this is a migration import database from old server
	(On old server)		(On old server)
Line 43:		Line 36:
	# sudo -u postgres dropdb davical		# sudo -u postgres dropdb davical
	# sudo -u postgres createdb davical		# sudo -u postgres createdb davical
	# sudo -u postgres psql davical < /root/davical.psql		# sudo -u postgres psql davical < /root/davical.psql<br>

	// Create Apache and DAViCal configuration directories		// Create Apache and DAViCal configuration directories
	# mkdir /etc/httpd/sites-available && mkdir /etc/httpd/sites-enabled && mkdir /etc/davical		# mkdir /etc/httpd/sites-available && mkdir /etc/httpd/sites-enabled && mkdir /etc/davical<br>

	// Create DAViCal virtual host in Apache, enable the site, and start Apache		// Create DAViCal virtual host in Apache, enable the site, and start Apache
	# tee -a /etc/httpd/sites-available/davical2.whitehorsetc.com.conf <<END		# tee -a /etc/httpd/sites-available/davical2.whitehorsetc.com.conf <<END
	<VirtualHost *:80>		<VirtualHost *:80>
	DocumentRoot /usr/share/davical/htdocs		DocumentRoot /usr/share/davical/htdocs
	DirectoryIndex index.php index.html		DirectoryIndex index.php index.html
Line 65:		Line 56:
	php_value error_reporting "E_ALL & ~E_NOTICE"		php_value error_reporting "E_ALL & ~E_NOTICE"
	php_value default_charset "utf-8"		php_value default_charset "utf-8"
	</VirtualHost>		</VirtualHost>
	END		END<br>

	# cat /etc/httpd/sites-available/davical2.whitehorsetc.com.conf		# cat /etc/httpd/sites-available/davical2.whitehorsetc.com.conf
	# ln -s /etc/httpd/sites-available/davical2.whitehorsetc.com.conf \		# ln -s /etc/httpd/sites-available/davical2.whitehorsetc.com.conf \
	/etc/httpd/sites-enabled/davical2.whitehorsetc.com.conf		/etc/httpd/sites-enabled/davical2.whitehorsetc.com.conf
	# ls -l /etc/httpd/sites-enabled		# ls -l /etc/httpd/sites-enabled
	# cp -p /etc/httpd/conf/httpd.conf /etc/httpd/conf/httpd.conf.bak		# cp -p /etc/httpd/conf/httpd.conf /etc/httpd/conf/httpd.conf.bak<br>
			# tee -a /etc/httpd/conf/httpd.conf <<END
	# tee -a /etc/httpd/conf/httpd.conf <<END		# Include the virtual host configurations:
	# Include the virtual host configurations:		IncludeOptional sites-enabled/*.conf
	IncludeOptional sites-enabled/*.conf		END<br>
	END

	# cat /etc/httpd/conf/httpd.conf		# cat /etc/httpd/conf/httpd.conf
	# systemctl enable httpd && systemctl start httpd && systemctl status httpd		# systemctl enable httpd && systemctl start httpd && systemctl status httpd<br>

	// Configure DAViCal to connect to database		// Configure DAViCal to connect to database
	# tee -a /etc/davical/davical2.whitehorsetc.com-conf.php <<END		# tee -a /etc/davical/davical2.whitehorsetc.com-conf.php <<END<br>
	<?php		<?php
	\$c->domain_name = "davical2.whitehorsetc.com";		\$c->domain_name = "davical2.whitehorsetc.com";
	\$c->sysabbr = 'DAViCal';		\$c->sysabbr = 'DAViCal';
Line 90:		Line 77:
	\$c->system_name = "Example DAViCal Server";		\$c->system_name = "Example DAViCal Server";
	\$c->pg_connect[] = 'dbname=davical port=5432 user=davical_app';		\$c->pg_connect[] = 'dbname=davical port=5432 user=davical_app';
	?>		?>
	END		END<br>
			# cat /etc/davical/davical2.whitehorsetc.com-conf.php<br>
	# cat /etc/davical/davical2.whitehorsetc.com-conf.php

	Create DNS entry for your DAViCal Calendar & Contact server,		Create DNS entry for your DAViCal Calendar & Contact server,
	browse to it, and enter users and groups: http://davical2.whitehorsetc.com/		browse to it, and enter users and groups: http://davical2.whitehorsetc.com/
	Use 'admin' and password output at database creation (noted above in green font) to log in		Use 'admin' and password output at database creation (noted above in green font) to log in<br>

	*Note: 1) Replace 'davical2.whitehorsetc.com' wherever found with your hostname		*Note: 1) Replace 'davical2.whitehorsetc.com' wherever found with your hostname
	2) Select items in red (tee to END), paste in terminal, and return		2) Select items in red (tee to END), paste in terminal, and return
	3) DAViCal CalDav Store		3) DAViCal CalDav Store
	4) Https security should be implemented over the internet		4) Https security should be implemented over the internet<br>
			Text version of this outline...possibly, for a script<br>
	Text version of this outline...possibly, for a script

	Clients:		Clients:
	1) Outlook (CalDav plugin necessary. CalDav Synchronizer)		1) Outlook (CalDav plugin necessary. CalDav Synchronizer)
	2) Thunderbird (Lightning)		2) Thunderbird (Lightning)
	3) One Calendar		3) One Calendar<br>

	// List databases (Linux command line)		// List databases (Linux command line)
	# sudo -u postgres psql -l		# sudo -u postgres psql -l