Good day
I have been fighting this for a couple of days now. I have tried the FreeBSD repositories for contact calendar and addressbook downloading directly and cli. Nextcloud postgreql php are run in the same jail.
uname -a
FreeBSD nextcloud.local 11.1-RELEASE-p8 FreeBSD 11.1-RELEASE-p8
pkg info nextcloud
nextcloud-13.0.1
Name : nextcloud
Version : 13.0.1
Installed on : Wed Apr 18 11:00:59 2018 EDT
Origin : www/nextcloud
Architecture : FreeBSD:11:*
Prefix : /usr/local
Categories : www
Licenses : AGPLv3
Maintainer : brnrd@FreeBSD.org
WWW : https://nextcloud.com
Comment : Personal cloud which runs on your own server
Options :
EXIF : on
LDAP : on
MYSQL : off
OPCACHE : on
PGSQL : on
SMB : on
SQLITE : off
SSL : on
Annotations :
cpe : cpe:2.3:a:nextcloud:nextcloud:13.0.1:::::freebsd11:x64
# sudo -u www php occ dav:create-calendar admin calendar
[Doctrine\DBAL\Exception\TableNotFoundException]
An exception occurred while executing 'INSERT INTO "oc_calendars" ("principaluri", "uri", "synctoken", "transparent", "components", "displayname") VALUES(?, ?, ?
, ?, ?, ?)' with params ["principals\/users\/admin", "calendar", 1, 0, "VEVENT,VTODO", "calendar"]:
SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "oc_calendars" does not exist
LINE 1: INSERT INTO "oc_calendars" ("principaluri", "uri", "synctoke...
^
[Doctrine\DBAL\Driver\PDOException]
SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "oc_calendars" does not exist
LINE 1: INSERT INTO "oc_calendars" ("principaluri", "uri", "synctoke...
^
[PDOException]
SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "oc_calendars" does not exist
LINE 1: INSERT INTO "oc_calendars" ("principaluri", "uri", "synctoke...
^
dav:create-calendar
pkg info postgresql10-server
postgresql10-server-10.3_1
Name : postgresql10-server
Version : 10.3_1
Installed on : Wed Apr 18 10:49:53 2018 EDT
Origin : databases/postgresql10-server
Architecture : FreeBSD:11:amd64
Prefix : /usr/local
Categories : databases
Licenses : PostgreSQL
Maintainer : pgsql@FreeBSD.org
WWW : http://www.postgresql.org/
Comment : PostgreSQL is the most advanced open-source database available anywhere
Options :
DEBUG : off
DTRACE : off
GSSAPI : off
INTDATE : on
LDAP : off
NLS : on
OPTIMIZED_CFLAGS: off
PAM : off
SSL : on
TZDATA : on
XML : on
Shared Libs required:
libicui18n.so.61
libintl.so.8
libpq.so.5
libicuuc.so.61
libxml2.so.2
Annotations :
FreeBSD_version: 1101001
cpe : cpe:2.3:a:postgresql:postgresql:10.3:::::freebsd11:x64:1
repo_type : binary
repository : FreeBSD
Flat size : 19.7MiB
sudo -u www php /usr/local/www/nextcloud/occ config:list system
{
"system": {
"instanceid": "***REMOVED SENSITIVE VALUE***",
"passwordsalt": "***REMOVED SENSITIVE VALUE***",
"secret": "***REMOVED SENSITIVE VALUE***",
"trusted_domains": [
"10.0.0.204",
"nextcloud.local",
"local"
],
"datadirectory": "***REMOVED SENSITIVE VALUE***",
"overwrite.cli.url": "https:\/\/10.0.0.204",
"dbtype": "pgsql",
"version": "13.0.1.1",
"dbname": "***REMOVED SENSITIVE VALUE***",
"dbhost": "***REMOVED SENSITIVE VALUE***",
"dbport": "",
"dbtableprefix": "oc_",
"dbuser": "***REMOVED SENSITIVE VALUE***",
"dbpassword": "***REMOVED SENSITIVE VALUE***",
"installed": true,
"log_type": "file",
"logfile": "\/var\/log\/nextcloud.log",
"loglevel": "0",
"logdateformat": "F d, Y H:i:s",
"logtimezone": "America\/Toronto",
"log_rotate_size": 52428800,
"memcache.local": "\\OC\\Memcache\\Memcached",
"memcache.distributed": "\\OC\\Memcache\\Memcached",
"memcached_servers": [
[
"10.0.0.204",
11211
]
],
"appstoreenabled": true,
"apps_paths": [
{
"path": "\/usr\/local\/www\/nextcloud\/apps",
"url": "\/apps",
"writable": true
},
{
"path": "\/usr\/local\/www\/nextcloud\/apps-pkg",
"url": "\/apps-pkg",
"writable": false
}
],
"defaultapp": "calendar",
"mail_smtpmode": "smtp",
"mail_domain": "***REMOVED SENSITIVE VALUE***",
"mail_smtphost": "***REMOVED SENSITIVE VALUE***",
"mail_smtpport": 25,
"mail_smtptimeout": 30,
"mail_smtpsecure": "",
"mail_smtpauth": true,
"mail_smtpauthtype": "LOGIN",
"mail_smtpname": "***REMOVED SENSITIVE VALUE***",
"mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
"updatechecker": false,
"check_for_working_webdav": true,
"check_for_working_wellknown_setup": true,
"enable_previews": true,
"preview_max_x": 4096,
"preview_max_y": 4096,
"preview_libreoffice_path": "\/usr\/local\/bin\/libreoffice",
"enabledPreviewProviders": [
"OC\\Preview\\PNG",
"OC\\Preview\\JPEG",
"OC\\Preview\\GIF",
"OC\\Preview\\BMP",
"OC\\Preview\\XBitmap",
"OC\\Preview\\MP3",
"OC\\Preview\\TXT",
"OC\\Preview\\MarkDown"
],
"maintenance": false,
"cache_path": "\/var\/db\/nextcloud\/data\/",
"max_filesize_animated_gifs_public_sharing": 50
}
}
Thanks for looking