Hello:
I have installed DAViCal on my server, but when I attempt to access it all I get is blank pages.
My server is running:
Ubuntu Server 18.04.3
Apache 2.4.29
PostgreSQL 10.10
Webmin 1.941
Virtualmin 6.03
The apache2 and PostgreSQL services are both running
esprimme@esprimmeserv:~$ sudo service --status-all
[..]
[ + ] apache2
[..]
[ + ] postgresql
[..]
DAViCal has been setup as a virtual host with SSL
The owner: group has been set to www-data:www-data. All files' permissions have been set to 755 to allow the PHP files to execute.
sudo ls -l /home/calendar/public_html
total 148
-rwxr-xr-x 1 www-data www-data 1512 Apr 8 2017 admin.php
-rwxr-xr-x 1 www-data www-data 24386 Jan 11 2018 always.php
-rwxr-xr-x 1 www-data www-data 6119 Jan 10 2018 caldav.php
drwxr-xr-x 2 www-data www-data 4096 Feb 7 16:51 css
-rwxr-xr-x 1 www-data www-data 6254 Dec 2 2016 davical.css
-rwxr-xr-x 1 www-data www-data 8504 Apr 8 2017 feed.php
-rwxr-xr-x 1 www-data www-data 3368 Sep 28 2017 freebusy.php
-rwxr-xr-x 1 www-data www-data 1329 May 1 2017 help.php
drwxr-xr-x 2 www-data www-data 4096 Feb 7 16:51 images
-rwxr-xr-x 1 www-data www-data 4343 May 1 2017 index.php
-rwxr-xr-x 1 www-data www-data 6872 May 1 2017 iSchedule.php
drwxr-xr-x 2 www-data www-data 4096 Feb 7 16:51 js
-rwxr-xr-x 1 www-data www-data 5695 Apr 8 2017 metrics.php
-rwxr-xr-x 1 www-data www-data 2362 Jan 2 2017 public.php
-rwxr-xr-x 1 www-data www-data 25 Dec 2 2016 robots.txt
-rwxr-xr-x 1 www-data www-data 17281 May 1 2017 setup.php
drwxr-xr-x 2 www-data www-data 4096 Feb 10 04:08 stats
-rwxr-xr-x 1 www-data www-data 7071 Apr 8 2017 tools.php
-rwxr-xr-x 1 www-data www-data 1017 Dec 28 2016 tz.php
-rwxr-xr-x 1 www-data www-data 3715 May 1 2017 upgrade.php
The following have been added to /etc/postgresql/pg_hba.conf
local all all trust
local davical davical_app trust
local davical davical_dba trust
I have made the following change to /etc/davical/config.php
Disabled/Commented: $c->pg_connect[] = "dbname=davical user=davical_app";
Enabled/Uncommented: $c->pg_connect[] = "dbname=davical user=davical_app port=5432 host=localhost password=*********";
After creation of the database, I was given a password for 'admin' user. Should I have used user=admin password=???????????
BTW...my distribution package installed the file with port=5433.
I am able to telnet into DAViCal on localhost
esprimme@esprimmeserv:~$ sudo telnet localhost 5432
Trying ::1...
Connected to localhost.localdomain.
Escape character is '^]'.
but not the server's IP address
esprimme@esprimmeserv:~$ sudo telnet 192.168.0.109 5432
Trying 192.168.0.109...
telnet: Unable to connect to remote host: Connection refused
I'm stumped. This is my first exposure to PostgreSQL, so that's not helping. Any insights would be greatly appreciated:
Thanks
--
Patrick
Email: support@esprimme.com
I have installed DAViCal on my server, but when I attempt to access it all I get is blank pages.
My server is running:
Ubuntu Server 18.04.3
Apache 2.4.29
PostgreSQL 10.10
Webmin 1.941
Virtualmin 6.03
The apache2 and PostgreSQL services are both running
esprimme@esprimmeserv:~$ sudo service --status-all
[..]
[ + ] apache2
[..]
[ + ] postgresql
[..]
DAViCal has been setup as a virtual host with SSL
<VirtualHost *:80>The files from /usr/share/davical/htdocs have been copied to /home/calendar/public_html.
ServerName calendar.example.com
Redirect permanent "/" https://calendar.example.com/"]"https://calendar.example.com/"
</VirtualHost>
<VirtualHost *:443>
#SSL
SSLEngine On
SSLCertificateFile /etc/letsencrypt/live/calendar.example.com/fullchain.pem
SSLCertificateKeyFile /etc/letsencrypt/live/calendar.example.com/privkey.pem
# Server
ServerName calendar.example.com
ServerAlias http://www.calendar.example.com"]www.calendar.example.com
ServerAlias webmail.calendar.example.com
ServerAlias admin.calendar.example.com
DocumentRoot /home/calendar/public_html
#Logs
ErrorLog /var/log/virtualmin/calendar.example.com_error_log
CustomLog /var/log/virtualmin/calendar.example.com_access_log combined
ScriptAlias /cgi-bin/ /home/calendar/cgi-bin/
DirectoryIndex index.html index.htm index.php index.php4 index.php5
<Directory /home/calendar/public_html>
Options -Indexes +IncludesNOEXEC +SymLinksIfOwnerMatch
allow from all
AllowOverride All Options=ExecCGI,Includes,IncludesNOEXEC,Indexes,MultiViews,SymLinksIfOwnerMatch
Require all granted
AddType application/x-httpd-php7.2 .php7.2
AddType application/x-httpd-php .php
</Directory>
<Directory /home/calendar/cgi-bin>
allow from all
AllowOverride All Options=ExecCGI,Includes,IncludesNOEXEC,Indexes,MultiViews,SymLinksIfOwnerMatch
Require all granted
</Directory>
RewriteEngine on
RewriteCond %{HTTP_HOST} =webmail.calendar.example.com
RewriteRule ^(.*) https://calendar.example.com:20000/"]https://calendar.example.com:20000/ [R]
RewriteCond %{HTTP_HOST} =admin.calendar.example.com
RewriteRule ^(.*) https://calendar.example.com:10000/"]https://calendar.example.com:10000/ [R]
</VirtualHost>
The owner: group has been set to www-data:www-data. All files' permissions have been set to 755 to allow the PHP files to execute.
sudo ls -l /home/calendar/public_html
total 148
-rwxr-xr-x 1 www-data www-data 1512 Apr 8 2017 admin.php
-rwxr-xr-x 1 www-data www-data 24386 Jan 11 2018 always.php
-rwxr-xr-x 1 www-data www-data 6119 Jan 10 2018 caldav.php
drwxr-xr-x 2 www-data www-data 4096 Feb 7 16:51 css
-rwxr-xr-x 1 www-data www-data 6254 Dec 2 2016 davical.css
-rwxr-xr-x 1 www-data www-data 8504 Apr 8 2017 feed.php
-rwxr-xr-x 1 www-data www-data 3368 Sep 28 2017 freebusy.php
-rwxr-xr-x 1 www-data www-data 1329 May 1 2017 help.php
drwxr-xr-x 2 www-data www-data 4096 Feb 7 16:51 images
-rwxr-xr-x 1 www-data www-data 4343 May 1 2017 index.php
-rwxr-xr-x 1 www-data www-data 6872 May 1 2017 iSchedule.php
drwxr-xr-x 2 www-data www-data 4096 Feb 7 16:51 js
-rwxr-xr-x 1 www-data www-data 5695 Apr 8 2017 metrics.php
-rwxr-xr-x 1 www-data www-data 2362 Jan 2 2017 public.php
-rwxr-xr-x 1 www-data www-data 25 Dec 2 2016 robots.txt
-rwxr-xr-x 1 www-data www-data 17281 May 1 2017 setup.php
drwxr-xr-x 2 www-data www-data 4096 Feb 10 04:08 stats
-rwxr-xr-x 1 www-data www-data 7071 Apr 8 2017 tools.php
-rwxr-xr-x 1 www-data www-data 1017 Dec 28 2016 tz.php
-rwxr-xr-x 1 www-data www-data 3715 May 1 2017 upgrade.php
The following have been added to /etc/postgresql/pg_hba.conf
local all all trust
local davical davical_app trust
local davical davical_dba trust
I have made the following change to /etc/davical/config.php
Disabled/Commented: $c->pg_connect[] = "dbname=davical user=davical_app";
Enabled/Uncommented: $c->pg_connect[] = "dbname=davical user=davical_app port=5432 host=localhost password=*********";
After creation of the database, I was given a password for 'admin' user. Should I have used user=admin password=???????????
BTW...my distribution package installed the file with port=5433.
I am able to telnet into DAViCal on localhost
esprimme@esprimmeserv:~$ sudo telnet localhost 5432
Trying ::1...
Connected to localhost.localdomain.
Escape character is '^]'.
but not the server's IP address
esprimme@esprimmeserv:~$ sudo telnet 192.168.0.109 5432
Trying 192.168.0.109...
telnet: Unable to connect to remote host: Connection refused
I'm stumped. This is my first exposure to PostgreSQL, so that's not helping. Any insights would be greatly appreciated:
Thanks
--
Patrick
Email: support@esprimme.com