Re: [SOGo] Calendar issues with 5.7.1
On Tuesday, September 20, 2022 4:19:15 PM CEST Pierre wrote: Hello Pierre, > I got the same issue trying to sync calendars between Outlook client and > SOGo with Caldav synchronizer. > As I'm trying the platform for our office, so far my calendar is the only > one in SOGo with data and all invites from other users of the office do not > get sync'd for the same issue. > > I was wondering if a possible solution could be to have a switch in the > conf file to disable this check? Thanks for your feedback. We got the exact same idea and asked Alinto if they could implement it. A fix has been committed here : https://github.com/Alinto/sogo/commit/cddfdb90f9c2bf5d61db619899ccce280ab13419 It is available in nightlies starting from 5.7.1.20221006-1. You have to set : SOGoDisableOrganizerEventCheck = YES; in your sogo.conf file to disable the check. I have tested in and it seems to fix the problem (but I am still waiting for a feedback from our complaining users). Thanks to Alinto for their responsiveness! Best regards, -- Ganael Laplanche Unix Systems Engineer @CentraleSupelec Rennes - DISI
[SOGo] BTS activities for Thursday, October 06 2022
Title: BTS activities for Thursday, October 06 2022 BTS Activities Home page: https://bugs.sogo.nu Project: SOGo For the period covering: Thursday, October 06 2022 idlast updatestatus (resolution)categorysummary 5613 2022-10-06 15:05:22 updated (open) Backend Address Book Downloading vcf file we obtain a file that has line breaks inside 5619 2022-10-06 04:04:51 updated (open) Backend General Feature Request for Password Recovery for Ldap User Source 5616 2022-10-06 15:14:57 updated (open) Web Address Book Export problem 5609 2022-10-06 14:51:17 updated (open) Web Calendar No message when invitation is delegated 5611 2022-10-06 14:42:49 updated (open) Web Mail Cannot choose other calendar when creating an appointment 5614 2022-10-06 15:06:18 updated (open) Web Mail FIDO2 support 5618 2022-10-06 15:20:59 acknowledged (open) with SOGo demo.sogo.nu is out of date 5581 2022-10-06 14:42:49 resolved (fixed) Web Calendar not able to create event in addtional calendar
Re: [SOGo] Postfixadmin
I'm not using LDAP, just regular mysql db. On 2022-10-06 22:10, Serveria Support wrote: Here it is: MariaDB [mailserver]> describe sogo_users; ++--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+---+ | c_uid | varchar(100) | NO | | NULL| | | c_name | varchar(100) | NO | | NULL| | | c_password | varchar(106) | NO | | NULL| | | c_cn | varchar(100) | NO | | NULL| | | mail | varchar(100) | NO | | NULL| | | domain | varchar(100) | NO | | NULL| | ++--+--+-+-+---+ 6 rows in set (0.006 sec) But I think you're going the wrong way. Windows Mail and other software clients can log in and send/receive emails just fine using these credentials. On 2022-10-06 21:01, Odhiambo Washington wrote: I am expecting a table equivalent to this. On Thu, Oct 6, 2022 at 8:50 PM Odhiambo Washington wrote: On Thu, Oct 6, 2022 at 8:33 PM Serveria Support wrote: Sure, here you go. It's very basic actually, I didn't make any heavy tweaking: [snip] SOGoUserSources = ( { type = sql; id = users; viewURL = "mysql://mailuser:password@localhost:3306/mailserver/sogo_users"; canAuthenticate = YES; isAddressBook = NO; userPasswordAlgorithm = ssha512; } ); [snip] Can you please connect to the "mailserver" database and then do: describe table sogo_users; I am expecting something like this: MySQL -uUSER -ppassword mailserver # After you connect, I'd like to see the output of describe table sogo_users; I am expecting to see column names and definitions: root@localhost [mailserver]> desc sogo_users; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | sogo_id | int unsigned | NO | | 0 | | | c_uid | varchar(255) | NO | | | | | c_name| varchar(255) | YES | | NULL| | | c_password| varchar(256) | YES | | NULL| | | c_cn | varchar(255) | NO | | | | | mail | varchar(255) | NO | | | | | displayName | varchar(255) | YES | | NULL| | | kind | varchar(100) | YES | | NULL| | | multiple_bookings | int | YES | | NULL| | +---+--+--+-+-+---+ Most importantly I'd like to see the c_uid, c_name, c_password, c_cn... -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] Postfixadmin
Here it is: MariaDB [mailserver]> describe sogo_users; ++--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+---+ | c_uid | varchar(100) | NO | | NULL| | | c_name | varchar(100) | NO | | NULL| | | c_password | varchar(106) | NO | | NULL| | | c_cn | varchar(100) | NO | | NULL| | | mail | varchar(100) | NO | | NULL| | | domain | varchar(100) | NO | | NULL| | ++--+--+-+-+---+ 6 rows in set (0.006 sec) But I think you're going the wrong way. Windows Mail and other software clients can log in and send/receive emails just fine using these credentials. On 2022-10-06 21:01, Odhiambo Washington wrote: I am expecting a table equivalent to this. On Thu, Oct 6, 2022 at 8:50 PM Odhiambo Washington wrote: On Thu, Oct 6, 2022 at 8:33 PM Serveria Support wrote: Sure, here you go. It's very basic actually, I didn't make any heavy tweaking: [snip] SOGoUserSources = ( { type = sql; id = users; viewURL = "mysql://mailuser:password@localhost:3306/mailserver/sogo_users"; canAuthenticate = YES; isAddressBook = NO; userPasswordAlgorithm = ssha512; } ); [snip] Can you please connect to the "mailserver" database and then do: describe table sogo_users; I am expecting something like this: MySQL -uUSER -ppassword mailserver # After you connect, I'd like to see the output of describe table sogo_users; I am expecting to see column names and definitions: root@localhost [mailserver]> desc sogo_users; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | sogo_id | int unsigned | NO | | 0 | | | c_uid | varchar(255) | NO | | | | | c_name| varchar(255) | YES | | NULL| | | c_password| varchar(256) | YES | | NULL| | | c_cn | varchar(255) | NO | | | | | mail | varchar(255) | NO | | | | | displayName | varchar(255) | YES | | NULL| | | kind | varchar(100) | YES | | NULL| | | multiple_bookings | int | YES | | NULL| | +---+--+--+-+-+---+ Most importantly I'd like to see the c_uid, c_name, c_password, c_cn... -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] SOGO reusing Dovecot db password issue
MySQL4DebugEnabled = YES; line is enabled in my sogo.conf I'm not using any hashing atm, it's a test install, but if you mean password algorithm I'm using ssha512 (used it as my Dovecot was using it already and I was too lazy to change it). It seems to be supported: Possible values are: none, plain, crypt, md5, md5-crypt, sha256-crypt and sha512-crypt, smd5, cram-md5 and sha, sha256, sha512 and its ssha (e.g. ssha or ssha256) variants Any ideas? On 2022-10-06 16:35, Christian Mack wrote: Hi Enable debugging for mysql in sogo.conf: MySQL4DebugEnabled = YES; Also which password hashing are you using? See "userPasswordAlgorithm" in "Installation and Konfiguration Guide". Kind regards, Christian Mack Am 06.10.22 um 10:44 schrieb Serveria Support (supp...@serveria.com): Hi, Thanks for responding. I did enable all possible logging in Dovecot and I can see Windows Mail clients logging in successfully. But for some reason my SOGo connection attempts are not showing up in logs at all. SOGo log still shows the same error message I already posted. SOGo website is giving me this error: Wrong username or password. On 2022-10-04 18:54, Odhiambo Washington wrote: On Thu, Sep 29, 2022 at 4:01 PM Serveria Support wrote: Hi, After weeks of trying to configure iredmail package for my needs (and failing miserably) I decided to start everything from scratch: I took a vanilla Debian 11 server and installed Dovecot + Postfix + MariaDB + Apache. Mailserver works like a charm - emails are getting sent/delivered/stored perfectly. Users are able to log in/authenticate. Then I decided to add SOGo to the config and installed it, also configured using the basic howto from sogo website. All done, web frontend comes up. So far so good unfortunately I'm unable to authenticate using my Dovecot users db. Here I have to add that I didn't create a separate table for SOGo but instead tried to reuse my Dovecot user credentials by creating a VIEW in my DB. However, this doesn't seem to work, here's my sogo.log: Sep 29 06:30:17 sogod [151286]: XXXIPADDRESSXXX "POST /SOGo/connect HTTP/1.1" 403 34/89 0.003 - - 0 - 12 Sep 29 06:30:25 sogod [151286]: |SOGo| starting method 'POST' on uri '/SOGo/connect' 2022-09-29 06:30:25.510 sogod[151286:151286] SQL: SELECT c_password FROM sogo_users WHERE c_uid = 'u...@mydomain.tld'; 2022-09-29 06:30:25.510 sogod[151286:151286] query has results, entering fetch-mode. Sep 29 06:30:25 sogod [151286]: SOGoRootPage Login from 'XXXIPADDRESSXXX' for user 'u...@mydomain.xxx' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0 Sep 29 06:30:25 sogod [151286]: |SOGo| request took 0.001784 seconds to execute Unfortunately, I'm not too good at reading SOGo logs and the error message seems to be not very self-explanatory. What exactly does this mean? Unable to fetch password? Password didn't work? Wrong encryption protocol? Any suggestions? Look at the dovecot logging configuration and bump the debugging up and you'll get it right. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] Postfixadmin
I am expecting a table equivalent to this. [image: sogo.jpg] On Thu, Oct 6, 2022 at 8:50 PM Odhiambo Washington wrote: > > > On Thu, Oct 6, 2022 at 8:33 PM Serveria Support wrote: > >> Sure, here you go. It's very basic actually, I didn't make any heavy >> tweaking: >> > > [snip] > > > >SOGoUserSources = > ( >{ > type = sql; > id = users; > viewURL = > "mysql://mailuser:password@localhost:3306/mailserver/sogo_users"; > canAuthenticate = YES; > isAddressBook = NO; > userPasswordAlgorithm = ssha512; >} > ); > [snip] > > Can you please connect to the "mailserver" database and then do: > describe table sogo_users; > > I am expecting something like this: > MySQL -uUSER -ppassword mailserver # After you connect, I'd like to see > the output of > describe table sogo_users; > > I am expecting to see column names and definitions: > root@localhost [mailserver]> desc sogo_users; > +---+--+--+-+-+---+ > | Field | Type | Null | Key | Default | Extra | > +---+--+--+-+-+---+ > | sogo_id | int unsigned | NO | | 0 | | > | c_uid | varchar(255) | NO | | | | > | c_name| varchar(255) | YES | | NULL| | > | c_password| varchar(256) | YES | | NULL| | > | c_cn | varchar(255) | NO | | | | > | mail | varchar(255) | NO | | | | > | displayName | varchar(255) | YES | | NULL| | > | kind | varchar(100) | YES | | NULL| | > | multiple_bookings | int | YES | | NULL| | > +---+--+--+-+-+---+ > > Most importantly I'd like to see the c_uid, c_name, c_password, c_cn... > > > -- > Best regards, > Odhiambo WASHINGTON, > Nairobi,KE > +254 7 3200 0004/+254 7 2274 3223 > "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] Postfixadmin
On Thu, Oct 6, 2022 at 8:33 PM Serveria Support wrote: > Sure, here you go. It's very basic actually, I didn't make any heavy > tweaking: > [snip] SOGoUserSources = ( { type = sql; id = users; viewURL = "mysql://mailuser:password@localhost:3306/mailserver/sogo_users"; canAuthenticate = YES; isAddressBook = NO; userPasswordAlgorithm = ssha512; } ); [snip] Can you please connect to the "mailserver" database and then do: describe table sogo_users; I am expecting something like this: MySQL -uUSER -ppassword mailserver # After you connect, I'd like to see the output of describe table sogo_users; I am expecting to see column names and definitions: root@localhost [mailserver]> desc sogo_users; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | sogo_id | int unsigned | NO | | 0 | | | c_uid | varchar(255) | NO | | | | | c_name| varchar(255) | YES | | NULL| | | c_password| varchar(256) | YES | | NULL| | | c_cn | varchar(255) | NO | | | | | mail | varchar(255) | NO | | | | | displayName | varchar(255) | YES | | NULL| | | kind | varchar(100) | YES | | NULL| | | multiple_bookings | int | YES | | NULL| | +---+--+--+-+-+---+ Most importantly I'd like to see the c_uid, c_name, c_password, c_cn... -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] Postfixadmin
Sure, here you go. It's very basic actually, I didn't make any heavy tweaking: { /* * Main SOGo configuration file ** * * * Since the content of this file is a dictionary in OpenStep plist format, * * the curly braces enclosing the body of the configuration are mandatory. * * See the Installation Guide for details on the format. * * * * C and C++ style comments are supported. * * * * This example configuration contains only a subset of all available * * configuration parameters. Please see the installation guide more details. * * * * ~sogo/GNUstep/Defaults/.GNUstepDefaults has precedence over this file,* * make sure to move it away to avoid unwanted parameter overrides. * * * * **/ /* Database configuration (mysql://, postgresql:// or oracle://) */ SOGoProfileURL = "mysql://mailuser:password@localhost:3306/mailserver/sogo_user_profile"; OCSFolderInfoURL = "mysql://mailuser:password@localhost:3306/mailserver/sogo_folder_info"; OCSSessionsFolderURL = "mysql://mailuser:password@localhost:3306/mailserver/sogo_sessions_folder"; /* Mail */ //SOGoDraftsFolderName = Drafts; //SOGoSentFolderName = Sent; //SOGoTrashFolderName = Trash; //SOGoJunkFolderName = Junk; SOGoIMAPServer = "localhost"; //SOGoSieveServer = "sieve://127.0.0.1:4190"; SOGoSMTPServer = "smtp://127.0.0.1"; SOGoMailDomain = mydomain.tld; SOGoMailingMechanism = smtp; //SOGoForceExternalLoginWithEmail = NO; //SOGoMailSpoolPath = /var/spool/sogo; //NGImap4ConnectionStringSeparator = "/"; /* Notifications */ //SOGoAppointmentSendEMailNotifications = NO; //SOGoACLsSendEMailNotifications = NO; //SOGoFoldersSendEMailNotifications = NO; /* Authentication */ //SOGoPasswordChangeEnabled = YES; /* LDAP authentication example */ //SOGoUserSources = ( // { //type = ldap; //CNFieldName = cn; //UIDFieldName = uid; //IDFieldName = uid; // first field of the DN for direct binds //bindFields = (uid, mail); // array of fields to use for indirect binds //baseDN = "ou=users,dc=acme,dc=com"; //bindDN = "uid=sogo,ou=users,dc=acme,dc=com"; //bindPassword = qwerty; //canAuthenticate = YES; //displayName = "Shared Addresses"; //hostname = "ldap://127.0.0.1:389";; //id = public; //isAddressBook = YES; // } //); /* LDAP AD/Samba4 example */ //SOGoUserSources = ( // { //type = ldap; //CNFieldName = cn; //UIDFieldName = sAMAccountName; //baseDN = "CN=users,dc=domain,dc=tld"; //bindDN = "CN=sogo,CN=users,DC=domain,DC=tld"; //bindFields = (sAMAccountName, mail); //bindPassword = password; //canAuthenticate = YES; //displayName = "Public"; //hostname = "ldap://127.0.0.1:389";; //filter = "mail = '*'"; //id = directory; //isAddressBook = YES; // } //); /* SQL authentication example */ /* These database columns MUST be present in the view/table: *c_uid - will be used for authentication - it's the username or usern...@domain.tld) *c_name - which can be identical to c_uid - will be used to uniquely identify entries *c_password - password of the user, plain-text, md5 or sha encoded for now *c_cn - the user's common name - such as "John Doe" *mail - the user's mail address * See the installation guide for more details */ SOGoUserSources = ( { type = sql; id = users; viewURL = "mysql://mailuser:password@localhost:3306/mailserver/sogo_users"; canAuthenticate = YES; isAddressBook = NO; userPasswordAlgorithm = ssha512; } ); /* Web Interface */ //SOGoPageTitle = SOGo; //SOGoVacationEnabled = YES; //SOGoForwardEnabled = YES; //SOGoSieveScriptsEnabled = YES; //SOGoMailAuxiliaryUserAccountsEnabled = YES; //SOGoTrustProxyAuthentication = NO; //SOGoXSRFValidationEnabled = NO; /* General - SOGoTimeZone *MUST* be defined */ SOGoLanguage = English; SOGoTimeZone = America/Montreal; //SOGoCalendarDefaultRoles = ( // PublicDAndTViewer, // ConfidentialDAndTViewer //); //SOGoSuperUsernames = (sogo1, sogo2); // This is an array - keep the parens! //SxVMemLimit = 384; //WOPidFile = "/var/run/sogo/sogo.pid"; //SOGoMemcachedHost = "/var/run/memcached.sock"; /* Debug */ SOGoDebugRequests = YES
Re: [SOGo] Postfixadmin
On Thu, Oct 6, 2022 at 3:12 PM Serveria Support wrote: > Hi, > > Thanks for your reply. Yes, I realized that after posting this. I made a > mistake I meant SOGo on port 80 and 443 not Dovecot obviously. > > I did enable all possible logging in Dovecot and I can see Windows Mail > clients logging in successfully. But for some reason my SOGo connection > attempts are not showing up in logs at all. SOGo log still shows the > same error message I already posted. SOGo website is giving me this > error: Wrong username or password. > Let's see your complete sogo.conf, please. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] SOGO reusing Dovecot db password issue
Hi Enable debugging for mysql in sogo.conf: MySQL4DebugEnabled = YES; Also which password hashing are you using? See "userPasswordAlgorithm" in "Installation and Konfiguration Guide". Kind regards, Christian Mack Am 06.10.22 um 10:44 schrieb Serveria Support (supp...@serveria.com): Hi, Thanks for responding. I did enable all possible logging in Dovecot and I can see Windows Mail clients logging in successfully. But for some reason my SOGo connection attempts are not showing up in logs at all. SOGo log still shows the same error message I already posted. SOGo website is giving me this error: Wrong username or password. On 2022-10-04 18:54, Odhiambo Washington wrote: On Thu, Sep 29, 2022 at 4:01 PM Serveria Support wrote: Hi, After weeks of trying to configure iredmail package for my needs (and failing miserably) I decided to start everything from scratch: I took a vanilla Debian 11 server and installed Dovecot + Postfix + MariaDB + Apache. Mailserver works like a charm - emails are getting sent/delivered/stored perfectly. Users are able to log in/authenticate. Then I decided to add SOGo to the config and installed it, also configured using the basic howto from sogo website. All done, web frontend comes up. So far so good unfortunately I'm unable to authenticate using my Dovecot users db. Here I have to add that I didn't create a separate table for SOGo but instead tried to reuse my Dovecot user credentials by creating a VIEW in my DB. However, this doesn't seem to work, here's my sogo.log: Sep 29 06:30:17 sogod [151286]: XXXIPADDRESSXXX "POST /SOGo/connect HTTP/1.1" 403 34/89 0.003 - - 0 - 12 Sep 29 06:30:25 sogod [151286]: |SOGo| starting method 'POST' on uri '/SOGo/connect' 2022-09-29 06:30:25.510 sogod[151286:151286] SQL: SELECT c_password FROM sogo_users WHERE c_uid = 'u...@mydomain.tld'; 2022-09-29 06:30:25.510 sogod[151286:151286] query has results, entering fetch-mode. Sep 29 06:30:25 sogod [151286]: SOGoRootPage Login from 'XXXIPADDRESSXXX' for user 'u...@mydomain.xxx' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0 Sep 29 06:30:25 sogod [151286]: |SOGo| request took 0.001784 seconds to execute Unfortunately, I'm not too good at reading SOGo logs and the error message seems to be not very self-explanatory. What exactly does this mean? Unable to fetch password? Password didn't work? Wrong encryption protocol? Any suggestions? Look at the dovecot logging configuration and bump the debugging up and you'll get it right. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung IT-Dienste Forschung, Lehre, Infrastruktur 78457 Konstanz +49 7531 88-4416 smime.p7s Description: S/MIME Cryptographic Signature
Re: [SOGo] fullName value
Hello Usually attribute cn (common name) is used for that. Some (like us) use that field for login name instead. You can specify in sogo.conf the fieldname (e.g. "displayName") for the full name with: [...] SOGoUserSources = ( { CNFieldName = "displayName"; [cut] Kind regards, Christian Mack Am 29.09.22 um 10:43 schrieb David Kmoch (david.km...@tul.cz): Hello, when using a LDAP server to authenticate users and parameter SOGoMailCustomFromEnabled set to default (NO), email header From contains fullName in the form "name.surname" Which LDAP field is used to fill the value of the fullName attribute? Is it possible to specify a different LDAP field as a source? Best regards, -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung IT-Dienste Forschung, Lehre, Infrastruktur 78457 Konstanz +49 7531 88-4416 smime.p7s Description: S/MIME Cryptographic Signature
Re: [SOGo] Postfixadmin
Hi, Thanks for your reply. Yes, I realized that after posting this. I made a mistake I meant SOGo on port 80 and 443 not Dovecot obviously. I did enable all possible logging in Dovecot and I can see Windows Mail clients logging in successfully. But for some reason my SOGo connection attempts are not showing up in logs at all. SOGo log still shows the same error message I already posted. SOGo website is giving me this error: Wrong username or password. On 2022-10-05 23:45, Odhiambo Washington wrote: On Wed, Oct 5, 2022 at 4:37 PM Serveria Support wrote: Thanks, you're really helpful, I appreciate. After turning Dovecot debugging on (SOGO had been enabled already) I'm seeing these in the log: 09:22:01 debian postfix/smtps/smtpd[267384]: SSL_accept error from unknown[xx.xx.xx.xx]: Connection timed out 09:22:01 debian postfix/smtps/smtpd[267384]: lost connection after CONNECT from unknown[xx.xx.xx.xx] 09:22:01 debian postfix/smtps/smtpd[267384]: disconnect from unknown[xx.xx.xx.xx] commands=0/0 Interesting, Dovecot is configured to use http/port 80 by default, port 443 is open but I didn't enable it as I wanted to test out with http first. So https is necessary for SOGO to authenticate? I can see Windows mail connecting just fine in the same log. Any thoughts? Dovecot can only listen on the following ports by default: 110 (POP3), 143 (IMAP4), 993 (IMAPS), 995 (POP3S). It can never listen to port 80 (HTTP) or 443 (HTTPS) which are only used by a web server (Nginx, Apache, Lighttpd). The logs you are showing are from Postfix and not dovecot! Please enable debugging on dovecot and look at the dovecot logs. You need to be seeing SQL queries on the logs. Please re-read your 10-logging.conf from dovecot, enable debugging are refer to the file specified. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] SOGO reusing Dovecot db password issue
Hi, Thanks for responding. I did enable all possible logging in Dovecot and I can see Windows Mail clients logging in successfully. But for some reason my SOGo connection attempts are not showing up in logs at all. SOGo log still shows the same error message I already posted. SOGo website is giving me this error: Wrong username or password. On 2022-10-04 18:54, Odhiambo Washington wrote: On Thu, Sep 29, 2022 at 4:01 PM Serveria Support wrote: Hi, After weeks of trying to configure iredmail package for my needs (and failing miserably) I decided to start everything from scratch: I took a vanilla Debian 11 server and installed Dovecot + Postfix + MariaDB + Apache. Mailserver works like a charm - emails are getting sent/delivered/stored perfectly. Users are able to log in/authenticate. Then I decided to add SOGo to the config and installed it, also configured using the basic howto from sogo website. All done, web frontend comes up. So far so good unfortunately I'm unable to authenticate using my Dovecot users db. Here I have to add that I didn't create a separate table for SOGo but instead tried to reuse my Dovecot user credentials by creating a VIEW in my DB. However, this doesn't seem to work, here's my sogo.log: Sep 29 06:30:17 sogod [151286]: XXXIPADDRESSXXX "POST /SOGo/connect HTTP/1.1" 403 34/89 0.003 - - 0 - 12 Sep 29 06:30:25 sogod [151286]: |SOGo| starting method 'POST' on uri '/SOGo/connect' 2022-09-29 06:30:25.510 sogod[151286:151286] SQL: SELECT c_password FROM sogo_users WHERE c_uid = 'u...@mydomain.tld'; 2022-09-29 06:30:25.510 sogod[151286:151286] query has results, entering fetch-mode. Sep 29 06:30:25 sogod [151286]: SOGoRootPage Login from 'XXXIPADDRESSXXX' for user 'u...@mydomain.xxx' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0 Sep 29 06:30:25 sogod [151286]: |SOGo| request took 0.001784 seconds to execute Unfortunately, I'm not too good at reading SOGo logs and the error message seems to be not very self-explanatory. What exactly does this mean? Unable to fetch password? Password didn't work? Wrong encryption protocol? Any suggestions? Look at the dovecot logging configuration and bump the debugging up and you'll get it right. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Re: [SOGo] show event organizer/creator on event detail
Hello That is how the standard demands it. Why or when do you need that? If there are no attendees, then the owner of the calendar is always the organizer. Kind regards, Christian Mack Am 26.09.22 um 09:29 schrieb Claudio Brocco - Peer Srl (c.bro...@peer.biz): Hi, I kindly ask if there is an option to show the organizer in a sogo calendar if no attendee are added to the event. I notice that in the raw source of the event the organizer is not present and not displayed. In event with attendee both are displayed. Thank you -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung IT-Dienste Forschung, Lehre, Infrastruktur 78457 Konstanz +49 7531 88-4416 smime.p7s Description: S/MIME Cryptographic Signature
Re: [SOGo] Error with activesync
Hello Am 24.09.22 um 22:54 schrieb Nick Wiltshire (n...@customdesigns.ca): Hi everyone, After following the guides to set this up, I must have gotten something wrong that I can't find. SOGo seems to be not returning a header Outlook expects. Using the MS test tool I get this error: Testing HTTP Authentication Methods for URL https://[mydomain]/Microsoft-Server-ActiveSync. The HTTP authentication test failed. A 401 error was received from the server, but no authentication methods are supported. HTTP Response Headers: Referrer-Policy: same-origin Sogo-Request-Duration: 0.002476 Keep-Alive: timeout=15, max=100 Connection: Keep-Alive Content-Length: 0 Content-Type: text/plain; charset=UTF-8 Date: Wed, 21 Sep 2022 20:20:24 GMT Server: Apache WWW-Authenticate: basic realm="SOGo" This contradicts itself. "Basic" Authentication is requested: > A 401 error was received from the server, but no authentication methods are > supported. [...] > WWW-Authenticate: basic realm="SOGo" Kind regards, Christian Mack -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung IT-Dienste Forschung, Lehre, Infrastruktur 78457 Konstanz +49 7531 88-4416 smime.p7s Description: S/MIME Cryptographic Signature