I doubt that is the problem. I dropped all the sogo_* tables from my DB, except the sogo_auth_view, which is created from my users table. There is no /usr/share/doc/sogo: [wash@waridi ~]$ ls -al /usr/share/doc/ total 60 drwxr-xr-x 15 root wheel 512 Jan 10 2017 . drwxr-xr-x 32 root wheel 1024 Mar 18 2018 .. drwxr-xr-x 2 root wheel 512 Oct 8 22:45 IPv6 drwxr-xr-x 2 root wheel 512 Oct 8 22:45 atf drwxr-xr-x 2 root wheel 512 Oct 8 22:45 atm drwxr-xr-x 3 root wheel 512 Mar 18 2018 bind9 drwxr-xr-x 2 root wheel 512 Oct 8 22:45 legal drwxr-xr-x 3 root wheel 512 Oct 8 22:45 llvm drwxr-xr-x 2 root wheel 512 Oct 8 22:44 ncurses drwxr-xr-x 7 root wheel 2560 Oct 8 22:46 ntp drwxr-xr-x 2 root wheel 512 Oct 8 22:45 papers drwxr-xr-x 2 root wheel 512 Oct 8 22:45 pjdfstest drwxr-xr-x 22 root wheel 512 Oct 8 22:45 psd drwxr-xr-x 13 root wheel 512 Oct 8 22:45 smm drwxr-xr-x 15 root wheel 512 Oct 8 22:45 usd
Similarly: [wash@waridi ~]$ sudo find /usr/ -type d -name "sogo" Password: /usr/local/etc/sogo /usr/local/GNUstep/Local/Library/Frameworks/SOGo.framework/Versions/4/sogo /usr/local/GNUstep/Local/Library/Frameworks/SOGo.framework/sogo /usr/local/GNUstep/Local/Library/Libraries/sogo So, the files could be elsewhere, but I am still not sure I need any sql update scripts, especially because I am only using sogo-4.0.4 since 4.0.5 has not yet hit the FreeBSD ports. I am not compiling manually, but using the ports. My problem still lives :-) Allow me to digress a little. Today while thinking about SOGo, I was wondering why the developers cannot let us define custom SQL queries within sogo.conf. For example, in my case I have to create a view of my users table to be used by SOGo wherea I could easily craft the queries dependent on my table structure. The sogo_auth_view comprises a very small subset of the columns that exist on my users table. With the ability to define custom queries inside sogo.conf, I could only use select X as A, Y as B from db.table....etc so that I do not have to rely on a view. This would help with SOGoPasswordChangeEnabled option to operate directly on the main table instead of on the view. root@localhost [exim4u]> desc sogo_auth_view; +-------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+---------+-------+ | sogo_id | int(10) unsigned | NO | | 0 | | | c_uid | varchar(255) | NO | | | | | c_name | varchar(255) | NO | | | | | c_password | varchar(256) | YES | | NULL | | | c_cn | varchar(255) | YES | | NULL | | | mail | varchar(255) | NO | | | | | displayName | varchar(255) | YES | | NULL | | +-------------+------------------+------+-----+---------+-------+ 7 rows in set (0.25 sec) root@localhost [exim4u]> desc users; +------------------+-------------------------------------------------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+-------------------------------------------------------------+------+-----+---------+----------------+ | user_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | domain_id | mediumint(8) unsigned | NO | | 0 | | | localpart | varchar(192) | NO | MUL | | | | username | varchar(255) | NO | | | | | clear | varchar(255) | YES | | NULL | | | crypt | varchar(256) | YES | | NULL | | | uid | smallint(5) unsigned | NO | | 65534 | | | gid | smallint(5) unsigned | NO | | 65534 | | | smtp | varchar(255) | YES | | NULL | | | pop | varchar(255) | YES | | NULL | | | type | enum('local','alias','catch','fail','piped','admin','site') | NO | | local | | | admin | tinyint(1) | NO | | 0 | | | on_avscan | tinyint(1) | NO | | 0 | | | on_blocklist | tinyint(1) | NO | | 0 | | | on_complexpass | tinyint(1) | NO | | 0 | | | on_forward | tinyint(1) | NO | | 0 | | | on_piped | tinyint(1) | NO | | 0 | | | on_spamassassin | tinyint(1) | NO | | 0 | | | on_vacation | tinyint(1) | NO | | 0 | | | enabled | tinyint(1) | NO | | 1 | | | flags | varchar(16) | YES | | NULL | | | forward | varchar(255) | YES | | NULL | | | unseen | tinyint(1) | YES | | 0 | | | maxmsgsize | mediumint(8) unsigned | NO | | 0 | | | quota | int(10) unsigned | NO | | 0 | | | realname | varchar(255) | YES | | NULL | | | sa_tag | smallint(5) unsigned | NO | | 0 | | | sa_refuse | smallint(5) unsigned | NO | | 0 | | | tagline | varchar(255) | YES | | NULL | | | vacation | varchar(255) | YES | | NULL | | | on_spambox | tinyint(1) | YES | | NULL | | | on_spamboxreport | tinyint(1) | YES | | NULL | | | ftp_dir | varchar(255) | YES | | NULL | | | ftp_enable | tinyint(1) | NO | | 0 | | | ftp_quota | int(11) | YES | | 20 | | | ULBandwidth | smallint(5) | NO | | 0 | | | DLBandwidth | smallint(5) | NO | | 0 | | | ipaccess | varchar(15) | NO | | * | | | QuotaFiles | int(11) | NO | | 0 | | +------------------+-------------------------------------------------------------+------+-----+---------+----------------+ On Tue, 12 Feb 2019 at 18:52, Christian Mack <users@sogo.nu> wrote: > Hello > > There should be no breakage. > But you have to check, if there exists any sql update scripts between > the version you came from to the one you just installed. > > Check /usr/share/doc/sogo/ > > > Kind regards, > Christian Mack > > Am 12.02.19 um 08:37 schrieb Odhiambo Washington (odhia...@gmail.com): > > Hello Gordon, > > > > True, I was updating a previous install. How things got broken is what > > surprised me. > > After some clues, I was able to delete some rogue libraries, reinstalled > > all the SOGo related bits (sogo4, sope4, gnustep-make, gnustep-base) > > and now I am able to get sogod running again. > > The thing is, in FreeBSD we can do `portupgrade -a` to update all > installed > > packages, like they do 'apt update && apt upgrade' in Linux. > > Somewhere in between, something might break for some reason, no? > > That is where I am at the moment. Webmail does NOT load the e-mails and I > > am not sure I can tell what is causing it. > > > > > > > > > > On Tue, 12 Feb 2019 at 07:29, Gordon Messmer <users@sogo.nu> wrote: > > > >> On 2/10/19 12:01 AM, Odhiambo Washington" (odhia...@gmail.com) wrote: > >>> I thought SOGo is supposed to create the tables sogo_* itself. > >> > >> > >> I'm a little unclear on where you're at with your installation. I > >> thought you were updating a previous install. If this is a new install, > >> make sure the sogo user has the rights required to make the tables that > >> it's complaining about. > >> > >> > >> -- > >> users@sogo.nu > >> https://inverse.ca/sogo/lists > >> > > > > > > > -- > Christian Mack > Universität Konstanz > Kommunikations-, Informations-, Medienzentrum (KIM) > Abteilung Basisdienste > 78457 Konstanz > +49 7531 88-4416 > > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists