Re: [SOGo] Table 'sogo.sogo_users' doesn't exist
Hi Bart,
On 31.01.24 18:07, Bits 'n Tricks (i...@bitsandtricks.com) wrote:
it came from /var/log/sogo/sogo.log:
ERROR: Table 'sogo.sogo_users' doesn't exist
[...]
Anyway, I have only one occurrence in the sogo.conf file and it is this:
viewURL = "mysql://sogo:password@127.0.0.1:3306/sogo/sogo_users";
IMHO the main question is: according to which documentation did you
create/edit your sogo.conf?
Please have a look at:
https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#Authentication-using-SQL
At the end of this section you'll find an example of a 'SOGoUserSources'
config and there (among others) the 'viewURL' parameter. Couldn't you try
to use this example from the official documentation?
On a former system I used:
SOGoUserSources =
(
{
type = sql;
id = users;
viewURL = "mysql://sogo:xxx@127.0.0.1:3306/sogo/sogo_view";
canAuthenticate = YES;
isAddressBook = YES;
userPasswordAlgorithm = SHA512-CRYPT;
prependPasswordScheme = YES;
displayName = "SOGo Benutzer";
}
);
and it worked without any problem.
Maybe it's worth a try.
HTH and regards,
Markus
Re: [SOGo] 404 error when accessing Sogo WebUI?
Hello Alain, thanks for the information and the plain text as well. ;-) On 01.11.23 22:51, "alain25" (s...@osnetworking.com) wrote: I still have a 501 error despite the changes: As long as you have errors in your /var/log/sogo/sogo.log then it's very likely that your sogod isn't running and so you'll have 501 errors. If I were you I would throw away the configs you downloaded somewhere with content like this: 1) please attach your current /etc/sogo/sogo.conf file _complete_ (passwords censored of course) OCSEMailAlarmsFolderURL = "mysql://userDB:Password@192.168.10.250:3306/sogosogo_alarms_folder"; ^ [...] SOGoTimeZone = "Africa/Nairobi"; ---^^ I doubt you check the whole file if all parameters really suits your needs. ;-) 2) please attach your _complete_ Apache vHost config file(s) from /etc/apache2/sites-available that is/are currently enabled (and therefore linked to /etc/apache2/sites-enabled) And here you mixed the vHost config file with the SOGo config file. That's not the SOGo standard configuration: # Webmail Interface ServerAdmin ad...@davenet.fr ServerName webmail.davenet.fr ErrorLog /var/log/apache2/webmail-ssl-error_log CustomLog /var/log/apache2/webmail-ssl-access_log common LogLevel warn #SOGo Alias /SOGo.woa/WebServerResources/ \ /usr/lib/GNUstep/SOGo/WebServerResources/ Alias /SOGo/WebServerResources/ \ /usr/lib/GNUstep/SOGo/WebServerResources/ [...] Of course you can do that, but e. g. if there are updates you have to check if there are any changes and so on. So again and IMHO: restart your setup with the config files as close as possible to the SOGo and (in your case) Apache standard. I already wrote my suggestions in one of my former mails. Important: check every option and read the respective documentation to fully understand their meaning, use only the needed options and change their values to your needs. Start with: 1) a working database access (verify that you can login with the SOGo db user from the the SOGo host to the db host) 2) minimal necessary changes in the original /etc/sogo/sogo.conf that you have a running sogod in the end Tuning etc. may follow later. If sogod is running without any errors you can config the Apache vHost and see if http://192.168.1.10/SOGo Or did you accept Odhiambo's offer in between and his remote support already helped to get a running SOGo server? Regards, Markus
Re: [SOGo] 404 error when accessing Sogo WebUI?
Hello Alain, On 30.10.23 23:01, "alain25" (s...@osnetworking.com) wrote: I always get a 501 error 1) please attach your _complete_ current /etc/sogo/sogo.conf (censored passwords of course) 2) please attach your _complete_ Apache vHost config file(s) from /etc/apache2/sites-available which is/are currently activated (and so linked to /etc/apache2/sites-enabled) 3) please attach the output of /var/log/sogo/sogo.log, especially the lines after a restart of the sogod Without these essential information it's quite impossible to help. Thanks and regards Markus
Re: [SOGo] 404 error when accessing Sogo WebUI?
Hello Alain,
thanks for the information.
On 30.10.23 13:37, "alain25" (s...@osnetworking.com) wrote:
I followed your instructions and moved the file
/etc/apache2/conf.d/SOGo.conf to /etc/apache2/conf-available/SOGo.conf
root@webmail: mv /etc/apache2/conf.d/SOGo.conf
/etc/apache2/conf-available/SOGo.conf
Then I did the following command:
root@webmail:/etc/apache2/conf-available# a2enconf SOGo.conf
I checked that the synbolic link was made in :
/etc/apache2/conf-enable/
lrwxrwxrwx 1 root root root 27 oct. 30 12:02 SOGo.conf ->
../conf-available/SOGo.conf
looks fine
I restarted Apache2
root@webmail:/etc/apache2/conf-enabled# systemctl restart apache2
Then I went to the ip address 192.168.1.10/SOGO
As I (and also Marco) already wrote: this URL is wrong.
You have to use 192.168.1.10/SOGo
The URL is case sensitiv, so the last 'o' has to be in lower case.
But then I get a black screen with a 501 error.
I give you the configuration of ../conf-available/SOGo.conf
Is this really the whole file? If yes, then there's missing content at the
end of it after this:
[...]
## For proxy-side authentication only for CardDAV and GroupDAV from external
## clients:
#
# AuthType XXX
# Require valid-user
# SetEnv proxy-nokeepalive 1
# Allow from all
#
^^ starting here there should be more lines
The next problem: IMHO the content of this file:
And in the file /etc/sogo/sogo.conf
normally looks completely different than yours:
Servername localhost
#DocumentRoot /usr/lib/GNUstep/SOGo/WebServerResources/
ErrorLog /var/log/apache2/sogo_error.log
Customlog /var/log/apache2/sogo_access.log combined
ServerSignature Off
Alias /SOGo.woa/WebServerResources/
/usr/lib/GNUstep/SOGo/WebServerResources/
Alias /SOGo/WebServerResources/ /usr/lib/GNUstep/SOGo/WebServerResources/
AliasMatch /SOGo/so/ControlPanel/Products/(.*)/Resources/(.*)
/usr/lib/GNUstep/SOGo/$1.SOGo/Resources/$2
AllowOverride None
# Order deny,allow
# Allow from all
Require all granted
"^/SOGo/so/ControlPanel/Products/.*UI/Resources/.*\.(jpg|png|gif|css|js)">
SetHandler default-handler
ProxyRequests Off
SetEnv proxy-nokeepalive 1
ProxyPreserveHost On
ProxyPass /SOGo http://127.0.0.1:2/SOGo retry=0
http://127.0.0.1:2/SOGo>
RequestHeader set "x-webobjects-server-port" "80"
RequestHeader set "x-webobjects-server-name" "localhost"
RequestHeader set "x-webobjects-server-url" "http://localhost;
RequestHeader set "x-webobjects-server-protocol" "HTTP/1.0"
RequestHeader set "x-webobjects-remote-host" %{REMOTE_HOST}e
env=REMOTE_HOST
AddDefaultCharset UTF-8
Order allow,deny
Allow from all
## We use mod_rewrite to pass remote address to the SOGo proxy.
# The remote address will appear in SOGo's log files and in the X-Forward
# header of emails.
RewriteEngine On
RewriteRule ^/SOGo/(.*)$ /SOGo/$1 [env=REMOTE_HOST:%{REMOTE_ADDR},PT]
Redirect permanent /index.html http://webmail.davenet.fr/SOGo
Or did you mixed files with wrong contents within your mail and the files
on your server are looking different?
This should be clarified first. Could you please check the content of these
two files?
And after that: what do the logs say (Apache & /var/log/sogo/sogo.log)?
Regards,
Markus
P.S.: It would be helpful if you could send plain text mails and avoid HTML
Re: [SOGo] 404 error when accessing Sogo WebUI?
On 28.10.23 20:15, "alain25" (s...@osnetworking.com) wrote: Before installing SOGO, I installed Apache 2 and activated the Apache modules [...] I copied the file /etc/apache2/conf.d/SOGo.conf to /etc/apache2/conf-enabled/SOGo.conf IMHO it's better to copy it to /etc/apache2/conf-available and then activate it with a2enconf following the general schema of Apache configuration files. Next, I edited the SOGo virtual host configuration file: No, this isn't a virtual host config file but an Apache config file. Virtual host configs are located within /etc/apache2/sites-available which are then enabled with a2ensite (or manually creating the symlink to /etc/apache2/sites-enabled). nano /etc/apache2/conf.d/SOGo.conf And here you edited only the source file from the SOGo package you copied to /etc/apache2/conf-enabled/SOGo.conf in the step before. That seems a little bit unlogical to me as this file AFAIK will never be used by Apache. ;-) [...] I have activated the Apache2 configuration a2enconf SOGo.conf Please see above. ;-) You try to enable a config file that (following your description) is currently not existing within /etc/apache2/conf-available. So, summarized I would suggest: - mv /etc/apache2/conf-enabled/SOGo.conf /etc/apache2/conf-available - check if /etc/apache2/conf-available/SOGo.conf has the correct content - sudo a2enconf SOGo.conf - just to be sure: check if there's now a symlink /etc/apache2/conf-enabled/SOGo.conf which points to /etc/apache2/conf-available/SOGo.conf - sudo systemctl restart apache2 Then I try to go to WebUI of Sogo via firefox 192.168.1.10/SOGO If this isn't only a typo ... But I get a 404 error. ... the correct URL is http(s)://192.168.1.10/SOGo -^ But even if you only use http(s)://192.168.1.10/ Apache should redirect to the correct URL shown above. HTH and regards, Markus
Re: [SOGo] SOGo no longer talking to mysql
Hi Richard,
On Mon, 24 Jul 2023 at 01:40:52PM +0200, Richard Rosner wrote:
My biggest problem with the old installation was (which was set up
before I became admin and I can't tell if it has been upgraded somehow
from SOGo 2.x, which we where using before 5.x, or if it was a fresh
install) that when I took over, the whole config was commented out and
everything was set to their default values. I have no idea how it even
worked in the first place, already because the default database is
postgresql, which isn't even installed on the system. And when I tried
to edit things like page title or availability of forwarding, they
simply didn't get applied. So I hoped with reinstalling I could solve
the issue. I even did an apt purge to remove everything from that old
installation (so only the mysql database survived), but obviously the
problem seems to be somewhere it did survive.
On Mon, 24 Jul 2023 at 03:27:49PM +0200, Richard Rosner wrote:
The old installation was SOGo (up until 5.8.0) on Debian 11 from the
official Nightly Repo. I now switched to Debians own packages after
upgrading to Debian 12, so it's still SOGo 5.8.0. But as the problem
was present during the whole 5.x cycle (at least since we switched
from 2.x, maybe in 2018 or so) and I switched to the Debian packages
just now, it must be a problem independent of the package source.
just another idea regarding this strange behaviour:
Within /usr/share/doc/sogo/README.Debian
"The SOGo debian package differs from upstream in placing the
configuration file in /etc/sogo/sogo.conf instead of using the GNUstep
user defaults that are placed under the home directory of the user
used to run SOGo. This file is parsed as GNUstep defaults in the
"sogod" domain, which means you must not specify the sogod domain in
the configuration file (there shouldn't be a "sogod = {" in
/etc/sogo/sogo.conf)."
Within a non-Debian sogo.conf there's this hint:
* ~sogo/GNUstep/Defaults/.GNUstepDefaults has precedence over this file, *
* make sure to move it away to avoid unwanted parameter overrides. *
--> Maybe you still have a mixture of old Debian and non-Debian and/or 2.x vs. 5.x configuration files somewhere? Could you have a look at
/var/lib/sogo/GNUstep/Defaults/ if there are files which could provide SOGo defaults even if you delete /etc/sogo/sogo.conf. Or somewhere else,
perhaps grepping for some relevant content shows a hit?
And just to be sure: in /etc/passwd is there an entry for the sogo user like
this one?:
sogo:x:999:999:SOGo daemon:/var/lib/sogo:/usr/sbin/nologin
The home directory would be the interesting part.
Regards,
Markus
Re: [SOGo] SOGo no longer talking to mysql
Hi Richard, On 21.07.23 13:27, Richard Rosner (rros...@fsmuw.rwth-aachen.de) wrote: thanks for this, but username is just sogo, password only consists of latin alphabet letters (no special letters like ê, ę or others), numbers and simple special characters like - or _, nothing that's not ASCII. just to be sure: does the password contain characters like '&'? Is there anything else that can/must be done? Earlier you wrote: So of course I tried logging in manually to mysql, but this succedes without any complaints. How exactly did you do this test? Did you enter: (1) $ mysql -u sogo -ppassword -D sogo -h localhost or did you enter the password interactively: (2) $ mysql -u sogo -p -D sogo -h localhost If you did not use method (1): could you please try it and see if that works? Regards, Markus
Re: [SOGo] sogo new install, users logged out immediatley after login
Hello Harald, On 30.03.22 11:36, Harald Wegscheider (harald.wegschei...@unileoben.ac.at) wrote: sogo.conf /* Mail */ SOGoIMAPServer = "imap://127.0.0.1:143"; SOGoSMTPServer = "smtp://127.0.0.1"; I would suggest to try the following parameters and see, if this makes any difference: SOGoIMAPServer = 127.0.0.1; SOGoSMTPServer = 127.0.0.1; Some time ago I also had a problem to connect to the IMAP server (and I think to the SMTP server too) and solved it with these values for the server options. IIRC at that time I tried several combinations (with imap(s) and with/without port etc.) but only with the parameters shown above it finally worked. Maybe it's worth a try. HTH and regards, Markus -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Proxy Error is Solved
Hi Elsam, On 27.09.20 21:55, Eslam Basyouni (eslam.basyo...@yahoo.com) wrote: and after troubleshoot we solve the issue by editing /etc/sysconfig/sogo and remove # from PREFORK=3 and make it 100 . i hope this help you , from other side i don't understand what this configuration mean , so could anyone tell me more about it please have a look at the documentation: https://sogo.nu/files/docs/SOGoInstallationGuide.html#_general_preferences --> WOWorkersCount HTH and regards, Markus -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Change password with SQL authentication
Hi Lars, thanks for the information. On 22.04.20 08:52, Lars Liedtke (lied...@punkt.de) wrote: * I created a view on the respective table and login works fine. * I set SOGoPasswordChangeEnabled = YES; . OK * I gave the database user UPDATE rights on the view. I don't think that this is necessary. At least I didn't have to do it in my former setups and it works. ;-) Interesting Which privileges did you assign to the sogo db user on the sogo database? In my setups I usually had one database with the accounts for Postfix/Dovecot and a separate database 'sogo' only for SOGo. The sogo db user had all privileges on the 'sogo' database, in which I simply created the necessary view 'sogo_view' to use the respective columns of the account table in the postfix database. What I additionally should add is, that I am using two sources of authentication: AD/LDAP for regular users of our company and SQL for additional users and aliases (Postfixadmin, Postfix/Dovecot). Do the regular (AD/LDAP) users see the 'Password' tab and can they use it? Or isn't it possible for them too? I tested with the two-source version in a vagrant box, I could of course let ansible build a box without the AD/LDAP source. I would test it with only SQL authentication - just to be sure. For such a test it should be sufficient if you disable the LDAP SOGoUserSources = (...) in sogo.conf Regards, Markus -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Change password with SQL authentication
Hi Lars, On 21.04.20 16:03, Lars Liedtke (lied...@punkt.de) wrote: is it possible that users can change their password when they are authenticated via SQL (MariaDB)? in general: yes * I created a view on the respective table and login works fine. * I set SOGoPasswordChangeEnabled = YES; . OK * I gave the database user UPDATE rights on the view. I don't think that this is necessary. At least I didn't have to do it in my former setups and it works. ;-) But I cannot see the possibility to change a user's password when logging in as that user, so I was not able to test further. Am I missing something? If you're going to Preferences -> General there's no tab 'PASSWORD' or did I misunderstand? Are there any errors in sogo.log? Which version of SOGo are you using? Regards, Markus -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Vacation Auto Reply doesnt'work - tries to send directly not on the defined relay.
Hi Juergen, On 10.03.20 15:47, "J. Echter" (j.ech...@echter-kuechen-elektro.de) wrote: How to handle this? in case you're using Dovecot IMAP server and not already configured: you could have a look at /etc/dovecot/conf.d/15-lda.conf: # If non-empty, send mails via this SMTP host[:port] instead of sendmail. #submission_host = Regards, Markus -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Thunderbird with Connector 68.0.x - managing ACLs
Hi Martin, On Tue, 11 Feb 2020 at 09:30:49AM +0100, Martin LEUSCH wrote: SOGo Connector is only able to manage ACL for calendars and address book. To manage mail folder ACL there is Imap-ACL-Extension thank you very much for the clarification. I already read about this extension and my hope was, that with the SOGo Connector (Integrator part of it) it isn't necessary to manage the ACL's. So let's hope that this add-on will be available for TB 68+ sometime. Thanks again and regards, Markus -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Thunderbird with Connector 68.0.x - managing ACLs
Hi all, I have a general question regarding the SOGo Connector. In the documentation I found this: --- snip --- Among the supported features of the SOGo Integrator extension, we have : Remote administration of folder access control lists (ACL) --- snip --- Does that mean, that within Thunderbird I should be able to share some of my mail folders with other users? If yes: I have installed the new Connector and can, for example, see mail folders shared by other users - no problem. Also: I can share my calendars with other users, can manage specific access rights for them etc. - no problem But when I click on one of my own mail folders -> properties -> share: I can see all _my_ access rights to this folder, among others: administer the folder. But _how_ can I do this? I can't see any button or something similar for this. Is the SOGo Connector sufficient for this (and maybe is only missing some local or [Dovecot] server side settings)? Or do I need an additional TB add-on for this? I hope I didn't only overlook something ... It would be nice if somebody could help me. Thanks and regards, Markus P.S.: Sharing the mail folders within the webmail client works without any problem. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Connector for Thunderbird 68 ?
Hi Boris, On 09.02.20 12:18, Boris (bo...@cation.de) wrote: Will there be a new connector - hopefully in the official Thunderbird-AddOn-Repositories? you can download it here: https://sogo.nu/download.html#/frontends But in your case you could indeed think about using John's TbSync - works really well and is a great TB Add-on (thanks John! :-)). Regards, Markus -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Setting up SOGo on iPhone and Apple Calendar?
Hi Jore, On 02.02.20 02:00, Jore (commun...@thoughtmaybe.com) wrote: I'm trying to get SOGo connected from Gandi.net to Apple Calendar and iPhone. Is there any documentation for this? At the moment, I cannot get iPhone or MacOS to connect properly using CalDAV. how exactly did you try it? Are there any error messages on macOS/iOS? Do you know this documentation?: https://sogo.nu/support/faq/accessing-your-calendars-with-apple-icalapp.html https://sogo.nu/files/docs/SOGoMobileDevicesConfigurationGuide.html#_apple_ios_calendars And in the context menu of your calendar(s) (clicking on the three dots besides the name of the calendar): did you check the "Links to this calendar"? There you can find the CalDAV URL, which you should use on macOS/iOS. HTH and regards, Markus -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Issues with Apostrophe (Single Quote)
Hello Christian,
On 26.11.19 18:03, Christian Mack (christian.m...@uni-konstanz.de) wrote:
We are having issues with a particular email address which has a ' in its email
address. Such as Dano'rou...@gmail.com
When the email is sent from SOGo, it removes the ' from the email address, so
the email is actually sent to danorou...@gmail.com
That is an invalid email address.
You need Quotes around it to work:
"Dano'rourke"@gmail.com
according to RFC 2822 and it's successor RFC 5322 and IMHO that's not
necessary and it's a bug if SOGo removes the "'":
https://tools.ietf.org/html/rfc5322
3.2.3. Atom
Several productions in structured header field bodies are simply
strings of certain basic characters. Such productions are called
atoms.
Some of the structured header field bodies also allow the period
character (".", ASCII value 46) within runs of atext. An additional
"dot-atom" token is defined for those purposes.
Note: The "specials" token does not appear anywhere else in this
specification. It is simply the visible (i.e., non-control, non-
white space) characters that do not appear in atext. It is
provided only because it is useful for implementers who use tools
that lexically analyze messages. Each of the characters in
specials can be used to indicate a tokenization point in lexical
analysis.
atext = ALPHA / DIGIT /; Printable US-ASCII
"!" / "#" /; characters not including
"$" / "%" /; specials. Used for atoms.
"&" / "'" /
"*" / "+" /
"-" / "/" /
"=" / "?" /
"^" / "_" /
"`" / "{" /
"|" / "}" /
"~"
atom= [CFWS] 1*atext [CFWS]
dot-atom-text = 1*atext *("." 1*atext)
dot-atom= [CFWS] dot-atom-text [CFWS]
specials= "(" / ")" /; Special characters that do
"<" / ">" /; not appear in atext
"[" / "]" /
":" / ";" /
"@" / "\" /
"," / "." /
DQUOTE
Both atom and dot-atom are interpreted as a single unit, comprising
the string of characters that make it up. Semantically, the optional
comments and FWS surrounding the rest of the characters are not part
of the atom; the atom is only the run of atext characters in an atom,
or the atext and "." characters in a dot-atom.
3.2.4. Quoted Strings
Strings of characters that include characters other than those
allowed in atoms can be represented in a quoted string format, where
the characters are surrounded by quote (DQUOTE, ASCII value 34)
characters.
[...]
I would ditch that address and get one without special characters.
I have seen too many SMTP servers not accepting such addresses at all.
Then they aren't RFC compliant.
For instance: an e-mail address like foo+...@example.com (Postfix:
recipient_delimiter = + and the e-mail will then finally be delivered to
f...@example.com) is widely used (and I never saw a problem with such an
address on Postfix, Dovecot, Thunderbird etc.).
According to the RFC that "+" is within the same category of characters
like the "'" of Dano'rou...@gmail.com (atext) and therefore has to be
accepted by any compliant software.
Just my $ 0.02
Kind regards,
Markus
--
users@sogo.nu
https://inverse.ca/sogo/lists
Re: [SOGo] Authentication for emai
Hi Andreas, On Thu, 11 Jul 2019 at 12:23:10AM +0200, Andreas Meyer wrote: I have a running SOGo-Server 4.0.7. I configured mail for IMAP and SMTP but the mailboxes are not shown. are there any errors in the logs? Are you able to send e-mails? What I don't understand is how sogo authenticates to the imap- and smtp-server when there is no possibility to give a password somewhere. How is this working and what am I missing? SOGo is using the credentials of the current user. Did you read these parts of the documentation: https://sogo.nu/files/docs/SOGoInstallationGuide.html#_smtp_server_configuration https://sogo.nu/files/docs/SOGoInstallationGuide.html#_imap_server_configuration especially the description of the parameter SOGoForceExternalLoginWithEmail? Regards, Markus -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Unable to connect to Dovecot IMAP (UnexpectedEndOfStream)
Hi Alexander, On Tue, 04 Jun 2019 at 12:35:48PM +0200, Alexander Koch wrote: Dovecot (2.3.4.1 from Debian Buster) instance running on another host via IMAP (port 143, TLS). if this IMAP server is also listening on port 993 - could you try the following: SOGoIMAPServer = imaps://mail.example.net; Just to see if there's any difference. Regards, Markus -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] [SOGoMailer]> error with recipient
Hi Yaisel, On Tue, 21 May 2019 at 10:58:35AM -0400, Yaisel Cruz Zuñiga wrote: The connector already had it configured, and even then it does not send the emails outside the domain itself just to be sure: Could you please verify that you configured these two settings: 1) in the connector settings -> security is the box 'Anonymous Users' checked? or via Management Shell: Set-ReceiveConnector -identity "" -PermissionGroups "AnonymousUsers" 2) Get-ReceiveConnector "" | Add-ADPermission -User "NT AUTHORITY\ANONYMOUS LOGON" -ExtendedRights "Ms-Exch-SMTP-Accept-Any-Recipient" Without these settings it won't work. Regards, Markus -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] [SOGoMailer]> error with recipient
Hi Yaisel, On Tue, 21 May 2019 at 01:42:12AM -0400, Yaisel Cruz Zuñiga wrote: when sending an email to u...@gmail.com he tells me this (error with recipient 'u...@gmail.com') [...] when I send an email to a user on the same server everything is perfect it looks like your webmail.ucf.edu.cu isn't allowed to relay. Depending on your Exchange version, please have a look at EMC -> Server Configuration -> Hub Transport. There you can define a receive connector. While running this wizard you can define an IP address (the one of your webmail.ucf.edu.cu) which is allowed for anonymous relaying. You can find several how-to's how to do this (also via Power Shell). After configuring this connector correctly sending mails from webmail.ucf.edu.cu to external recipients should work. HTH and regards, Markus -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Does
Hi luckydog, On Tue, 30 Apr 2019 at 12:40:07PM +0800, luckydog xf wrote: But I didn't congure https, does anyone share me that how to configure https? there are tons of how-to's regarding Apache and https like this one (specific for SOGo): https://wiki.debian.org/SOGo But as you wrote: yum install ... ^^^ you may prefer: https://www.digitalocean.com/community/tutorials/how-to-secure-apache-with-let-s-encrypt-on-centos-7 https://linuxize.com/post/secure-apache-with-let-s-encrypt-on-centos-7/ HTH and regards, Markus -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Trouble finding...
Hi Scot, On 17.04.19 05:33, Scot Anderson (lupine...@gmail.com) wrote: I am getting an error when I attempt to send a message from the web interface. “(Smtp) originator not accepted”. where did you read this error message? And we would need some more details about your environment: - which OS and which version - output of 'postconf -n' - the config options regarding SMTP (SOGoMailingMechanism, SOGoSMTPServer, SOGoForceExternalLoginWithEmail) from or the complete /etc/sogo/sogo.conf - a log extract from Postfix log (var/log/mail.log or so) and /var/log/sogo/sogo.log if you're trying to send a mail from the web client Regards, Markus -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Calendar and invation email language
Hi Benoît, On 15.03.19 16:43, Benoît PELISSIER (bpeliss...@lan2net.fr) wrote: I dont know where can i change language for calendar invitation email... SOGoLanguage = French; in /etc/sogo/sogo.conf should do the trick. HTH and have a nice weekend. Regards, Markus -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Problems with a fresh install of SOGO 4.0.7 on ubuntu 16
Hi Carsten, On Thu, 14 Mar 2019 at 11:45:21AM +0100, Carsten Pieper wrote: I now solved the problem by enabling the proxy_http module of Apache. Till now, I just looked only for the proxy module itself. thank you very much for the logfiles - I couldn't have a look at them earlier. But I'm glad to hear that it's running now, thanks for the feedback. Kind regards Markus -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] (fwd) Re: Problems with a fresh install of SOGO 4.0.7 on ubuntu 16
has been sent to my personal address ;-)
--
users@sogo.nu
https://inverse.ca/sogo/lists--- Begin Message ---
After SOGoSuperUsernames in your sogo.conf, why are you indiscriminately
commenting out and changing values without going by what the documentation
says? :)
Start with the minimal as suggested in the documentation.
Anyway, that aside, could you please try changing the following two lines:
RequestHeader set "x-webobjects-server-port" "443" < Make
sure you know whether to use 443 or 80
SetEnvIf Host (.*) HTTP_HOST=$1
#RequestHeader set "x-webobjects-server-name" "%{HTTP_HOST}e"
env=HTTP_HOST
#RequestHeader set "x-webobjects-server-url" "https://%{HTTP_HOST}e;
env=HTTP_HOST
RequestHeader set "x-webobjects-server-name" "FQDN"
RequestHeader set "x-webobjects-server-url" "https://FQDN;
AddDefaultCharset UTF-8
Be sure to know whether it is http or https - if you do not have a
certificate, please stay with http/port 80.
This is just to test
On Wed, 13 Mar 2019 at 20:33, Carsten Pieper wrote:
> Hi Markus,
> Am 13.03.19 um 16:12 schrieb Markus Winkler (m...@irmawi.de):
>
> Hi Carsten,
>
> On Wed, 13 Mar 2019 at 02:56:17PM +0100, Carsten Pieper wrote:
>
> I was looking in nginx because it feels for me that something before SOGo
> is not running correctly yet.
>
>
> what I still cannot understand: you have Apache configured for SOGo,
> right? What's the purpose of the additional Nginx in your setup? And do
> you really have them _both_ running on the same host, are you sure?
>
> Yes I am, that is the default config in Plesk virtual servers. Nginx is
> working as reverse proxy, see:
> https://docs.plesk.com/de-DE/onyx/administrator-guide/webserver/apache-und-ngnixwebserver-linux/apache-mit-nginx.70837/
> (Sorry, German, but different translations are available.
>
>
>
> It would be good to know which webserver is doing which job. Could you
> please send us an output of 'ps aux' and 'netstat -lntp' or something
> similar?
>
> It would be helpful if you could:
>
> o set 'LogLevel debug' (in case of using Apache)
>
> Please find attached my /etc/apache2/conf-available/SOGo.conf
>
> and my /etc/sogo/sogo.conf
>
>
>
> o send an extract of the logs (configured for CustomLog and ErrorLog)
> of the webserver which is serving SOGo right after you try to access
> SOGo via browser (when you say that you get an 'Internal Server Error',
> then there must be something to find in the log) - even if it doesn't
> seem:
>
> I checked /var/log/sogo.log, var/log/apache2/error.log
> and /var/log/nginx/error.log
> and found nothing helpful to get the login screen displayed.
>
>
> "interesting" to you.
>
> I've attached you the current sogo.log and apache error.log.
>
>
>
> makes me even more think that the problem is caused somewhere in Apache or
> Nginx, not in SOGo.
>
>
> At the moment I assume you have a problem with your webserver(s), but just
> to be sure: did you check if the SOGo deamon is really running and listens
> on the configured port? You should see something like this:
>
> tcp 0 0 127.0.0.1:2 0.0.0.0:*LISTEN 1508/sogod
>
> Please find attached the output from ps and netstat in running
> processes.txt
>
>
>
> Any other ideas are really appreciated, I think it's something really
> stupid :-),
>
>
> Let's see after you give a little more input. ;-)
>
> Thanks and regards,
> Markus
>
> --
>
>
> THANK you so much for your support, I'm a little blinded at the moment...
>
> Regards,
>
> Carsten
>
>
>
>
>
>
>
>
>
>
>
>
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists
>
--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", grep ^[^#] :-)
--- End Message ---
Re: [SOGo] Problems with a fresh install of SOGO 4.0.7 on ubuntu 16
Hi Carsten, On Wed, 13 Mar 2019 at 02:56:17PM +0100, Carsten Pieper wrote: I was looking in nginx because it feels for me that something before SOGo is not running correctly yet. what I still cannot understand: you have Apache configured for SOGo, right? What's the purpose of the additional Nginx in your setup? And do you really have them _both_ running on the same host, are you sure? It would be good to know which webserver is doing which job. Could you please send us an output of 'ps aux' and 'netstat -lntp' or something similar? It would be helpful if you could: o set 'LogLevel debug' (in case of using Apache) o send an extract of the logs (configured for CustomLog and ErrorLog) of the webserver which is serving SOGo right after you try to access SOGo via browser (when you say that you get an 'Internal Server Error', then there must be something to find in the log) - even if it doesn't seem: I checked /var/log/sogo.log, var/log/apache2/error.log and /var/log/nginx/error.log and found nothing helpful to get the login screen displayed. "interesting" to you. makes me even more think that the problem is caused somewhere in Apache or Nginx, not in SOGo. At the moment I assume you have a problem with your webserver(s), but just to be sure: did you check if the SOGo deamon is really running and listens on the configured port? You should see something like this: tcp 0 0 127.0.0.1:2 0.0.0.0:*LISTEN 1508/sogod Any other ideas are really appreciated, I think it's something really stupid :-), Let's see after you give a little more input. ;-) Thanks and regards, Markus -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Question regarding OpenChange package on Xenial
Hi Carsten, On Thu, 07 Mar 2019 at 11:23:09AM +0100, Carsten Pieper wrote: referring to https://sogo.nu/files/docs/v3/SOGoNativeOutlookConfigurationGuide.html#_installation, it says in Chapter 5 I have to install sogo-openchange and several more. I do not find anything regarding sogo-activesync there. OpenChange uses MAPI for accessing the SOGo server and that's a complete different way compared to Exchange ActiveSync (EAS). So, am I right with the following thesis: "SOGo v4 supports Outlook/ExchangeActiveSync via installing the package sogo-activesync, i.e. following https://sogo.nu/files/docs/SOGoInstallationGuide.html. That's correct. It is not necessary to follow the NativeOutlookConfigurationGuide, neither for v3 nor v4, to have Outlook connected to SOGo without any plugin." If your Outlook supports EAS and EAS has all the needed features, then yes. But for what do I than need the Native Outlook Configuration Guide? I would say: in case your Outlook doesn't support EAS, EAS doesn't support a needed feature or if you prefer to use CalDAVSynchronizer etc. for some other reason. Regards, Markus -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Question regarding OpenChange package on Xenial
Hi Carsten, On 05.03.19 11:41, Carsten Pieper (i...@carstenpieper.com) wrote: I'm actually migrating my SOGo installation from trusty to xenial. which version of SOGo do you currently use on Trusty - v3.x? Trying to install the necessary packages results in: E: Package 'sogo-openchange' has no installation candidate As you mentioned 'sogo-v4' together with 'openchange' and it therefore seems that you not only want to upgrade Ubuntu but also from SOGo 3.x to 4.x: AFAIK there's no sogo-openchange package for SOGo 4 and I assume there never will be one, as to my knowledge the OpenChange project is rather dead. Regards, Markus -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Show quota
Hi Daniel, On Sun, 03 Mar 2019 at 07:10:37PM +0100, "Daniel - Infosoft Proyectos Informaticos" wrote: SOGo does not show the space occupied by my mails, nor the total space. Do we have to activate some special parameter to be visualized? do your IMAP accounts have quotas? And your IMAP server has to support quotas - you didn't wrote which one you use. In my case (SOGo 4): accounts with activated quota can see the total amount and the used space without problems (IMAP server: Dovecot). Best regards, Markus -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Performance tuning
Hi Lorenz, On 01.03.19 22:42, Lorenz Pressler (lor...@pressler.pro) wrote: yes, this made indeed a difference; it's about ~20-30% faster. response time taken from the debug log is now ~500-1200ms. as expected, I would say. ;-) Thank you for testing and your feedback. I am not sure why though or I am misunderstanding what this is doing. If this parameter is not set, the default setting is effective, which means IMAP pooling is disabled. In this case SOGo has to log in _and_ especially out for every access to/from the IMAP server and so permanently establishes new sessions to Dovecot. A typical log extract would look like this (while clicking in the web interface): --- snip --- 2019-03-02 10:49:32 imap-login: Info: Login: user=, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, mpid=15163, secured, session= 2019-03-02 10:49:32 imap(f...@example.com): Info: Logged out in=222 out=1607 2019-03-02 10:49:37 imap-login: Info: Login: user=, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, mpid=15167, secured, session=<3WMIcRmDIsl/AAAB> 2019-03-02 10:49:37 imap(f...@example.com): Info: Logged out in=331 out=2116 2019-03-02 10:49:39 imap-login: Info: Login: user=, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, mpid=15169, secured, session= 2019-03-02 10:49:39 imap(f...@example.com): Info: Logged out in=331 out=2116 2019-03-02 10:49:42 imap-login: Info: Login: user=, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, mpid=15171, secured, session=<3ctbcRmDLMl/AAAB> 2019-03-02 10:49:43 imap(f...@example.com): Info: Logged out in=307 out=4075 --- snip --- In contrast to that, if you set 'NGImap4DisableIMAP4Pooling = NO;' then the pooling is activated, SOGo keeps the current connection open and so _no_ new logins are necessary every time you access a folder or e-mail. In the Dovecot log you'll only see one login and that's it. The down side is, that there will be more simultaneous open connections to Dovecot. I'm also new to SOGo and hope that my understanding of this mechanism is correct. I don't know exactly if and when timeouts on SOGo and Dovecot regarding the IMAP connection are taking effect (at least there is some information in the RFC's and the Dovecot Wiki). According to the Dovecot log it seems that SOGo logs out after about 5 minutes of inactivity in the web frontend (but I didn't check this exactly). Well, this test was mainly for isolation and confirmation of one possible reason for the performance bottleneck - the slow IMAP login/access. And with changing this parameter we can indeed mitigate this problem. But for me it's unclear, why the login resp. access to Dovecot takes so long compared to the same procedure using Thunderbird or OpenSSL/fetching as IMAP clients. Perhaps there are some SOGo experts which have any idea how to narrow down this further and have tuning tips? By way of comparison: in the sogo.log of my server (Debian, 2 GB RAM with software components like on your system and with 'NGImap4DisableIMAP4Pooling = NO;') I can see IMAP access times on an average of 0,1 s, if an initial IMAP login was necessary before then this takes approx. 0,4 s. And BTW: it doesn't suprise me that your access to address book and calendar is working well, as they are stored exclusively in the MariaDB and this access is something completely different. Best regards, Markus -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Performance tuning
Hi Lorenz, On 01.03.19 10:12, Lorenz Pressler (lor...@pressler.pro) wrote: I don't have much in my config at all, maybe I am missing something; in your sogo.conf I couldn't find 'NGImap4DisableIMAP4Pooling', which defaults to 'YES'. Just for testing purposes: could you please add NGImap4DisableIMAP4Pooling = NO; and check, if this makes any difference? Regards, Markus -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] ANN: SOGo v4.0.6 released! Vacation reply not to be activated
Hi Francis, On Tue, 26 Feb 2019 at 10:04:25AM -0500, Francis Lachapelle wrote: > New nightly packages will be available in a few hours for testing. just a short feedback after updating to 4.0.6.20190226-1: with German language settings I could o activate a vacation message o create a calendar event both in March (März) and without any problem. Thank you very much for solving this problem so fast. :) Regards, Markus -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] ANN: SOGo v4.0.6 released! Vacation reply not to be activated
Hi Andreas, On Di, 26 Feb 2019 at 03:03:56 +0100, Andreas Vögele wrote: > In the end I figured out > that the start and end date caused the problem although I hadn't changed > them. After I changed both dates with the date selector the save button > became green. I haven't been able to reproduce this problem though. interesting information, thanks. This could point us in the right direction, now I could reproduce a similar problem too ...: If I use German language settings and select a date for enable or disable or both within March (regardless which year), then in German this month contains an umlaut (M_ä_r) and so the save button stays grey and the line under the date stays red. After Switching to English the month becomes 'M_a_r' -> no umlaut and I can save/activate the vacation message. I did all my former tests within February and so I didn't observe this (IMHO) bug. Regards, Markus -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] ANN: SOGo v4.0.6 released! Vacation reply not to be activated
Hi Andreas, On Di, 26 Feb 2019 at 02:10:09 +0100, "Andreas Blaha" wrote: > and (sorry I forgot to state that) this works perfectly well when in English > language, but not in German ... my former successful test was with German language settings. I now tested it with English: works fine too without any problem. OS: Debian Stretch. Regards, Markus -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] ANN: SOGo v4.0.6 released!
Hi Dominique, On Di, 26 Feb 2019 at 10:44:22 +0100, Dominique BERTHET wrote: > It's seems to be impossible to "Enable vacation auto reply" in 4.0.6 just tested with 4.0.6 (upgraded from 4.0.5): it works. Best regards, Markus -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Installation of SOGo 4 on Debian Buster
Hello Christian, On 13.02.19 17:29, Christian Mack (christian.m...@uni-konstanz.de) wrote: >> 1) Does anybody know if this separate package 'sogo-activesync' is necessary >> on Debian >>Buster? In the Debian Buster repo there's no such package. > > Yes it is, if you want ActiveSync support. OK, as expected - thank you for the information. > But even Ubuntu 18.04 got a repo after being multiple months stable. Good to know. So Buster together with SOGo will still be take some time. > As far as I know that 'sogo-activesync' package can be compiled from the > normal SOGo sources. > I never did that ;-) Me too ;-). To build this package should not be a big problem, I think. But luckily I'm not in a hurry and so I can wait until Buster will become stable and the official SOGo repositories are available. And in between I'll follow the development (like the linked bug within mantis). Thanks again for your help and kind regards, Markus -- users@sogo.nu https://inverse.ca/sogo/lists
