Thanks for the tips Zhang. The upgrade did indeed remove sogo. I've reinstalled it, and checked the mysql tables and they all seem to still contain sogo data (i.e. users and such are all still in them). It seems most everything is working except sogo. Navigating to the web page gives a bad gateway error. There are plenty of errors in the log files and such. I'll list some now:
Looks like it's complaining about a null table. I had been on sogo4.02 for a while before running ubuntu upgrade so the tables should have been migrated already.
● sogo.service - LSB: SOGo server
Loaded: loaded (/etc/init.d/sogo; generated)
Active: active (exited) since Mon 2018-09-03 12:47:09 MST; 5min ago
Docs: man:systemd-sysv-generator(8)
Process: 1221 ExecStart=/etc/init.d/sogo start (code=exited, status=0/SUCCESS)
Sep 03 12:46:46 mx systemd[1]: Starting LSB: SOGo server...
Sep 03 12:46:54 mx sogo[1221]: * Starting SOGo sogo
Sep 03 12:47:12 mx sogo[1221]: 2018-09-03 19:47:08.268 sogod[1612:1612] File NSConcreteMapTable.m: 584. In NSMapGet Null table argument supplied
Sep 03 12:47:12 mx sogo[1221]: /usr/sbin/sogod: Uncaught exception NSInvalidArgumentException, reason: Attempt to place key-value in null table
Sep 03 12:47:12 mx sogo[1221]: ...done.
Sep 03 12:47:09 mx systemd[1]: Started LSB: SOGo server.
There's a Connection refused error for every attempt to access anything sogo in the nginx error.log (which I sanitized a bit)
2018/09/03 12:56:39 [error] 1450#1450: *36 connect() failed (111: Connection refused) while connecting to upstream, client: 192.168.0.2, server: _, request: "PROPFIND /SOGo/dav/xxxx%40xxxx.net/Calendar/51E9-58E44B00-9-7816E200/ HTTP/1.1", upstream: "http://127.0.0.1:20000/SOGo/dav/xxxx%40xxxx.net/Calendar/51E9-58E44B00-9-7816E200/", host: "xxxx.net"
Originally, roundcube was throwing a bad gateway too but I realized php-fpm server line was misconfigured in nginx.conf. I pointed to the upgraded version and it works now. Oddly, iredadmin worked fine without changing the line. I don't know if this has anything to do with sogo though.
upstream php_workers {
# server unix:/var/run/php-fpm.socket;
server unix:/var/run/php/php7.2-fpm.sock;
}
I suspect that the re-install of sogo stepped on some config somewhere but I can't find it. There is a backup of a sogo.conf file with a timestamp from a year ago but the time stamp on the current file was the same date. Any ideas?
Update: Inspecting the installed version of sogo, it mentions something about apache. Does this have anything to do with it?
root@mx:/var/log# dpkg -s sogo
Package: sogo
Status: install ok installed
Priority: optional
Section: web
Installed-Size: 51214
Maintainer: Inverse Support <support@inverse.ca>
Architecture: amd64
Version: 4.0.2.20180903-1
Depends: gnustep-base-runtime (>= 1.25.1), libc6 (>= 2.14), libcurl4 (>= 7.16.2), libgcc1 (>= 1:3.0), libglib2.0-0 (>= 2.14.0), libgnustep-base1.25 (>= 1.25.1), liblasso3 (>= 2.3.5), libmemcached11, libobjc4 (>= 4.6), libsbjson2.3 (>= 4.9.r1664.20180828), libsope-appserver4.9 (>= 4.9.r1664.20180828), libsope-core4.9 (>= 4.9.r1664.20180828), libsope-gdl1-4.9 (>= 4.9.r1664.20180828), libsope-ldap4.9 (>= 4.9.r1664.20180828), libsope-mime4.9 (>= 4.9.r1664.20180828), libsope-xml4.9 (>= 4.9.r1664.20180828), libssl1.1 (>= 1.1.0), sope4.9-libxmlsaxdriver, sope4.9-db-connector, gnustep-make, zip
Recommends: memcached
Suggests: nginx
Conffiles:
/etc/apache2/conf.d/SOGo.conf 8f45e554762ec40ce34fb7f929e68c15
/etc/cron.d/sogo 7a7baf6aa09cb8a3ba36d5eb11a7ca36
/etc/cron.daily/sogo f4e7f06fc2ec514c8ea3705a4612091d
/etc/default/sogo 986e4c2506f01ca3531f04d066a49b3c
/etc/init.d/sogo d85d08f75b47001fddd3d33cf397c0a9
/etc/logrotate.d/sogo a660f9849da382a7c1537298cca7e022
/etc/sogo/sogo.conf 9b67cf7794ab4759f58fe9a9fca5af31
/etc/apache2/conf-available/SOGo.conf 8f45e554762ec40ce34fb7f929e68c15 obsolete
Description: a modern and scalable groupware
SOGo is a groupware server built around OpenGroupware.org (OGo) and
the SOPE application server with focus on scalability.
The Inverse edition of this project has many feature enhancements:
* CalDAV and GroupDAV compliance
* full handling of vCard as well as vCalendar/iCalendar formats
* support for folder sharing and ACLs
.
The Web interface has been rewritten in an AJAX fashion to provide a faster
UI for the users, consistency in look and feel with the Mozilla applications,
and to reduce the load of the transactions on the server.
