[SOGo] Unknown column 'c_hascertificate' in 'field list'
Hi all I have just updated our SOGo to the very latest SOGo nightly build (for CentOS6), 3.2.10.20180107, hoping to fix a problem that must have started recently but I am unsure when exactly. When trying to look at the address book in the SOGo web interface (tested with various users), the screen will show you the total amount of contacts but underneath, where the list of contacts should be seen, it looks like it is trying to refresh but not been able to show any entry. The SOGo log shows the following: Jan 08 09:47:03 sogod [3637]: [ERROR] <0x0x7fa98f65f468[GCSFolder]> -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SELECT c_name, c_cn, c_givenname, c_sn, c_screenname, c_o, c_mail, c_telephonenumber, c_categories, c_component, c_hascertificate FROM . (cut)... ExecutionFailed REASON:Unknown column 'c_hascertificate' in 'field list' We have not in any way tried to do something manually with the MySQL database so I wonder what might be the reason for this? Any idea or help? Thanks, Michael -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] group/distribution aliases cannot be used as sender
Hi, I have searched thru the FAQ and thru a lot of archived mailings of this list entries but I have not found an answer so far. We did install a mailcow-dockerized installation on our server and did migrate our users from an external email provider now. We do have a couple of aliases, two domain aliases, personal aliases and group/distribution aliases (two or more users as recipients) I do for example have my standard sender address and the mailcow admin UI does show in my mailbox config that I am allowed to sent mails all together with 8 different adresses. But inside SOGo the web interface does me only offer six of them when I click on sender (my personal address, the two adresses with the domain alias and all personal aliases). The two group/distribution alias are not offered as sender addresses. I had first thought that there might be a limitation for the number of aliases when the two group/distribution aliases did no show up. So I entered additional personal aliases for my mail account in the admin interface but they did show all up then using the SOGo web interface. Is there a restriction in SOGo Webinterface version 3.2.10 to just allow domain and personal aliases as sender addresses and not group/distribution aliases? I do receive the mails sent to my two group/distribution aliases in my mailbox but I am unable to answer with the two aliases in the SOGo web interface. Using Thunderbird or Outlook with IMAP I can easily use also the group/distribution aliases as sender address. But our users would like to use the group/distribution aliases as sender adresses also in the SOGo web interface. best regards Guido -- users@sogo.nu https://inverse.ca/sogo/lists