[SOLVED] How to configure DAViCal for external use?

Epp · 2024-02-25 18:55:47

Hi,

I installed the packages mentioned in the DAViCal wiki:
https://wiki.archlinux.org/title/DAViCal. This with nginx.
After following these wiki instructions for my mail server I can not connect to the CalDAV database (a bit like step 3 on this page: https://www.davical.org/clients.php?client=Thunderbird).
Also combinations with https as mentioned here don't work for me:
https://caldav.readthedocs.io/en/latest/

I placed my name as a user in the file /var/lib/postgres/data/pg_hba.conf:

Connection         Database    User    Address  Method
host               davical     john    *        password

The database must run on a mail server and I try to login with Thunderbird on my laptop.

Hopefully you can give some advice or point me to some more info about how to configure.

Last edited by Epp (2024-03-05 19:26:04)

impossibleveins23 · 2024-03-02 07:16:30

HI,

I assume you have postgres installed, up and running.
- Can you connect to the DB with your user?

psql -h <host> -u <user> -p <password>

This should be 1st step.

After this, see what DaviCal logs says

Epp · 2024-03-02 19:34:55

Yes I think so.

[postgres@myserver ~]$ psql -h mail.example.com -U root

psql (16.1)
Type "help" for help.

root=#

[postgres@myserver ~]$ psql -U davical_dba -h mail.example.com davical
psql (16.1)
Type "help" for help.

davical=>

With DaviCal log you mean the apache or (in my case) nginx log?
Well today I could not get any error or text to the log files in /var/log/nginx

After walking through the instruction on davical.org https://www.davical.org/installation.php
Thunderbird can still not find a calendar server on my domain.

For today I give up. Tomorrow I will try to improve error loging in hope that will give some indication.

Thanks.

WorMzy · 2024-03-02 19:43:39

Mod note: moving to AUR Issues.

impossibleveins23 · 2024-03-03 03:34:03

I don't have it installed but it seems to me simple app comprise of the DB (Postgres)) and backend (Apache).
So after checking that DB is up and running, I would go the apache logs (the app can write to systemd journal or to its own log) and see what's going on.

*Better also do simple query like SELECT * FROM pg_catalog.pg_class LIMIT 1; to validate the DB connection

Epp · 2024-03-03 09:06:48

impossibleveins23 wrote:

I don't have it installed but it seems to me simple app comprise of the DB (Postgres)) and backend (Apache).
So after checking that DB is up and running, I would go the apache logs (the app can write to systemd journal or to its own log) and see what's going on.
*Better also do simple query like SELECT * FROM pg_catalog.pg_class LIMIT 1; to validate the DB connection

Well, if it was really simple, the information (how to) would not be that scattered.

The select works.

postgres=# SELECT * FROM pg_catalog.pg_class LIMIT 1;
 oid  |   relname    | relnamespace | reltype | reloftype | relowner | relam | relfilenode | reltablespace | relpages | reltuples | relallvisible | reltoastrelid | relhasindex | relisshared | relpersistence | relkind | relnatts | relchecks | relh
------+--------------+--------------+---------+-----------+----------+-------+-------------+---------------+----------+-----------+---------------+---------------+-------------+-------------+----------------+---------+----------+-----------+-----
 2619 | pg_statistic |           11 |   10029 |         0 |       10 |     2 |        2619 |             0 |       19 |       409 |            19 |          2840 | t           | f           | p              | r       |       31 |         0 | f
(1 row)

postgres=# ^C
postgres=#

But I think the problem is not with the database.
From the server (through ssh) I launched a browser (lynx) and from there I could just open the example .php and .html files.
And just after that the first lines appeared in my nginx log.

So before there was nothing.

I think it's a webserver problem and not a postgresql problem.
At this moment I am trying to change the configuration to public instead of localhost.

I am not sure if this should work in my nginx.conf:
listen 80 default_server;
listen [::]:80;

listen with the ip of the server gives an error.

---
Update:
A big piece of the problem is solved. I did not think about port forwarding, excuses people. After forwarding port 80 I can access the example web server files (index.html and info.php) from another computer.
Looking up the agenda server in Thunderbird now gives direct feedback instead of timing out after a while.

Could be that the problem now is indeed more database specific.
But then, how to connect to the database from a client application (instead of the command line on the server).

All lines in the error log contain:
"/usr/share/nginx/html/caldav.php/davical/multipleusernamestried/calendar/index.php" is not found(2: no such file or directory)

Last edited by Epp (2024-03-03 11:26:04)

Epp · 2024-03-05 19:25:39

So, and a last update!
I don't exactly know when what, but I think this subject played a big part in de solution:
https://www.nginx.com/resources/wiki/st … s/phpfcgi/

I must say that I got help from the davical IRC channel.
With my nginx setup I had to remove the semicolon in front of extensions in the php.ini file (in the folder /etc/php).
The setup.php (page) in the browser showed which extensions (your calendar.domain.com/setup.php).
Afther this was done the Administration portal became accessible in the browser at the calendar domain, from where you can add your calendar user(s) with the needed permissions.
And of course change the admin password given after running the script create-database.sh.

Thanks people!

Arch Linux

#1 2024-02-25 18:55:47

[SOLVED] How to configure DAViCal for external use?

#2 2024-03-02 07:16:30

Re: [SOLVED] How to configure DAViCal for external use?

#3 2024-03-02 19:34:55

Re: [SOLVED] How to configure DAViCal for external use?

#4 2024-03-02 19:43:39

Re: [SOLVED] How to configure DAViCal for external use?

#5 2024-03-03 03:34:03

Re: [SOLVED] How to configure DAViCal for external use?

#6 2024-03-03 09:06:48

Re: [SOLVED] How to configure DAViCal for external use?

#7 2024-03-05 19:25:39

Re: [SOLVED] How to configure DAViCal for external use?

Board footer