Re: [SOGo] Wrong time in WEB SOGo (5.5.1)
On Thu, Jul 21, 2022 at 08:50:45PM +, "? ???" wrote: > But it didn't help me That will only impact event you create after installing the TZv1 file. Do youi still have the bug for newly created events? If you want to fix the older events created while you had the TZv2 file, you will need to edit the database. Below is the script I wrote to do that. You will need to adjust at least the time zone (Europe/Paris in my case) and the date after which event should be fixed, which is the day you updated the system and got the TZv2 file (1587001800 in case). You probably also need to adjust the charset. I advise you to work on a copy of your SOGo installation. Make a backup, run the script, check for bugs, fix, restore backup and start over. Unfortunately there is no way to spot events that users moved back to the appropriate time within the web interface. The script will fix their time as if they were incorrect, relulting in an icorrect time. --- cut here --- #!/bin/sh # create an ic() helper function mysql << EOT DELIMITER // CREATE FUNCTION ics(haystack mediumtext, field varchar(64)) RETURNS varchar(256) CHARACTER SET 'latin1' COLLATE 'latin1_swedish_ci' DETERMINISTIC BEGIN RETURN substr(haystack, instr(haystack, field) + length(field), instr(substr(haystack, instr(haystack, field) + length(field)), '\r') - 1); END // DELIMITER ; EOT for i in `echo " select substr(c_location, instr(c_location, '/sogo/')+ 6) from sogo_folder_info where c_folder_type='Appointment';" | mysql -ABN sogo` ; do echo " update ${i} set c_content = replace( c_content, concat( 'DTSTART;TZID=Europe/Paris:', ics(c_content, 'DTSTART;TZID=Europe/Paris:') ), concat('DTSTART;TZID=Europe/Paris:', date_format( convert_tz( str_to_date( ics(c_content, 'DTSTART;TZID=Europe/Paris:'), '%Y%m%dT%H%i%S' ), 'Europe/Paris', 'UTC' ), '%Y%m%dT%H%i%S' ) ) ) where ics(c_content, 'PRODID:') like '-//Inverse inc./SOGo%' and c_creationdate > 1587001800 and c_content like '%DTSTART;TZID=Europe/Paris:%'; update ${i} set c_content = replace( c_content, concat( 'DTEND;TZID=Europe/Paris:', ics(c_content, 'DTEND;TZID=Europe/Paris:') ), concat('DTEND;TZID=Europe/Paris:', date_format( convert_tz( str_to_date( ics(c_content, 'DTEND;TZID=Europe/Paris:'), '%Y%m%dT%H%i%S' ), 'Europe/Paris', 'UTC' ), '%Y%m%dT%H%i%S' ) ) ) where ics(c_content, 'PRODID:') like '-//Inverse inc./SOGo%' and c_creationdate > 1587001800 and c_content like '%DTEND;TZID=Europe/Paris:%'; update ${i}_quick q, ${i} c set q.c_startdate = unix_timestamp( convert_tz( from_unixtime(q.c_startdate), 'Europe/Paris', 'UTC' ) ), q.c_enddate = unix_timestamp( convert_tz( from_unixtime(q.c_enddate), 'Europe/Paris', 'UTC' ) ), q.c_cycleenddate = unix_timestamp( convert_tz( from_unixtime(q.c_cycleenddate), 'Europe/Paris', 'UTC' ) ) where q.c_name = c.c_name and ics(c.c_content, 'PRODID:') like '-//Inverse inc./SOGo%' and c.c_creationdate > 1587001800 and c.c_content like '%DTSTART;TZID=Europe/Paris:%'; update ${i}_quick q, ${i} c set q.c_nextalarm = unix_timestamp( convert_tz( from_unixtime(q.c_nextalarm), 'Europe/Paris', 'UTC' ) ) where q.c_name = c.c_name and q.c_nextalarm != 0 and ics(c.c_content, 'PRODID:') like '-//Inverse inc./SOGo%' and c.c_creationdate > 1587001800 and c.c_content like '%DTSTART;TZID=Europe/Paris:%'; " done --- cut here --- -- Emmanuel Dreyfus m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Wrong time in WEB SOGo (5.5.1)
On Thu, Jul 21, 2022 at 03:51:57PM +0200, Christian Mack wrote: > That in turn means, that your local timezone does not work as Emmanuel > Dreyfus suggests. That problem will strike more and more often, as all systems move to TZ v2 or v3. Unfortunately, backporting the code I contributed to GNUstep base so that it works with 1.28.0 is not obvious. We need to start lobbying for a GNUstep base 1.29.0 release! -- Emmanuel Dreyfus m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Wrong time in WEB SOGo (5.5.1)
On Thu, Jul 21, 2022 at 10:15:09AM +0300, gtg2...@rambler.ru wrote: > Unfortunately I couldn't find v1 format You can steal it from antoher OS: http://archive.netbsd.org/pub/NetBSD-archive/NetBSD-5.2.3/i386/binary/sets/base.tgz tar -xzf base.tgz ./usr/share/zoneinfo/Europe/Moscow Of course I assume you can live with a few leap seconds missing. -- Emmanuel Dreyfus m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Wrong time in WEB SOGo (5.5.1)
On Mon, Jul 18, 2022 at 07:34:57PM +, "? ???" wrote: > Here is the command output > [root@SRV-MAIL ~]# file /usr/share/zoneinfo/Europe/Moscow > /usr/share/zoneinfo/Europe/Moscow: timezone data [root@SRV-MAIL ~]# > How to understand what version it is? v2 ? Your file(1) is not smart enough. Try hexdump -C /usr/share/zoneinfo/Europe/Moscow | head v1 format start by TZif or just a bunch of nul bytes v2 format start by TZif2 -- Emmanuel Dreyfus m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Wrong time in WEB SOGo (5.5.1)
On Thu, Jun 30, 2022 at 11:23:46AM +0300, gtg2...@rambler.ru wrote: > The list of sent and received emails in the web interface shows the wrong > time (UTC), should be (UTC+3) What version is your timezone file? file(1) can tell: $ file /usr/share/zoneinfo/Europe/Moscow /usr/share/zoneinfo/Europe/Moscow: timezone data, version 2, no gmt time flags, no std time flags, no leap seconds, no transition times, 1 abbreviation char gnustep-base did not support v2+. I contributed the code for that and it was accepted, but there has not been any release wth it yet. If you are hit by the problm, a workaround can be to remplace your timezone file by a v1 copy from an earlier OS release. That will not fix events that have been inserted from the web interface with the v2 file: the wrong data is in database now. -- Emmanuel Dreyfus m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] No local time zone specified
On Tue, Dec 07, 2021 at 11:01:06PM +0100, HYVERNAT Philippe wrote: > **2021-12-07 20:57:01.609 sogod[71303:100517] No local time zone > specified.** > **2021-12-07 20:57:01.609 sogod[71303:100517] Using time zone with absolute > offset 0.** Beyond the unexpected /usr/local/etc/sogo/sogo.conf content, note that current release of GNUstep base libraries do not cope with timezone files v2+. I contributed code to support v2 and v3, but it will only be released in upcoming GNUstep Base 1.29.0. If your system has v2 TZ files (file(1) can tell you), you will need to replace it by a v1 file from an older FreeBSD release. -- Emmanuel Dreyfus m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] failed to parse RFC822 date field
On Tue, Aug 03, 2021 at 01:41:16PM +0200, mj wrote: > Yes you are right. But the question remains: where does this faulty date in > the system come from, and how to get it out. Scrub the database? mysqldump sogo | grep 'Sat Jul 10 11:56:18 UTC 2021' and see from what table it comes? Hopefully, a PRODID property will tell you what client did it. Then you could fix it with something like this: update table_xxx set c_content = replace( c_content, 'Sat Jul 10 11:56:18 UTC 2021', 'Sat, Jul 10 11:56:18 2021 +') where c_content like '%Sat Jul 10 11:56:18 UTC 2021%'; If you have many of them, you will need something more complex. Backup advised, as usual. -- Emmanuel Dreyfus m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] failed to parse RFC822 date field
On Mon, Aug 02, 2021 at 01:30:47PM +0200, mj wrote: > > sogod [32661]: <0x0x5570fe0afcd0[NGMimeRFC822DateHeaderFieldParser]> > > WARNING: failed to parse RFC822 date field: 'Sat Jul 10 11:56:18 UTC 2021' > > These appear for various dates and times. > > Can anyone explain? I guess the problem is that RFC822 format is Sat, Jul 10 2021 11:56:18 + -- Emmanuel Dreyfus m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Regeneration of _quick tables
Hello I understand that for a given table foo in the database, there is a foo_quick table with information parsed from the CalDAV data present in the first table. I need to perform a batch fix of CalDAV data. Is there a way to force update of the _quick tables? I tried to delete everything from them, but SOGo just sees an empty agenda. -- Emmanuel Dreyfus m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Timezone bug
On Tue, Jul 13, 2021 at 03:33:04PM +, "Nagel, Peter" wrote: > what timezone is set on your server and what time does it show? If your > server is set to UTC and the time isn't UTC you will get this offset... Server side, default is Europe/Paris, and date indeed displays Paris time. $ ls -l /etc/localtime lrwxr-xr-x 1 root wheel 32 Oct 13 2011 /etc/localtime -> /usr/share/zoneinfo/Europe/Paris $ echo $TZ $ date Tue Jul 13 18:44:47 CEST 2021 sogod has no TZ in its environment (shown by ps -e), and SOGoTimeZone is set to Paris: # su -l sogo -c 'defaults read sogod SOGoTimeZone' sogod SOGoTimeZone Europe/Paris -- Emmanuel Dreyfus m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Downgrading to SOGo 2
On Tue, Jul 13, 2021 at 10:40:34AM +0200, Christian Mack wrote: > Don't do it. Too late :-) > There are several changes involved. > Check the database upgrade scripts in /usr/share/doc/sogo/sql-update-3* > for examples. I did not run them. > Also some settings respective their values have changed. Is there a list somewere? I ran 4.0.1 for 48 hours, a few users have worked on it, but it seems everything is working without a hitch after downgrading to 2.4.1. What damage should I search for? -- Emmanuel Dreyfus m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Remote calender refresh
On Tue, Feb 26, 2019 at 03:14:09PM +, Emmanuel Dreyfus wrote: > Even that does not seems to happen, and I checked the "reload on login" > checkbox in the calendar properties. SOGo just never refresh it. Where does the rechresh is done in the sources (SOGo 2.3.23)? It seems there is something to fix. -- Emmanuel Dreyfus m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Remote calender refresh
Hello I SOGo2.3.23 subscribed to a remote calendar that is supposed to refresh every hour, but that does not happen. I have the feeling it never updates after the initial import. Here is the remote calendar preambule: is there anthing wrong here? BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Example Inc//NONSGML ICS//EN URL:http://www.example.net/ics NAME:Remote calendar X-WR-CALNAME:Remote calendar TIMEZONE-ID:Europe/Paris X-WR-TIMEZONE:Europe/Paris REFRESH-INTERVAL;VALUE=DURATION:PT1H X-PUBLISHED-TTL:PT1H CALSCALE:GREGORIAN METHOD:PUBLISH -- Emmanuel Dreyfus m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] ics export is slow
On Thu, Aug 06, 2015 at 09:59:41AM +0200, Christian Mack wrote: Count: 1 Time=0.03s (0s) Lock=0.00s (0s) Rows=1803.0 (1803), SELECT c_lastmodified FROM sogouser00636dbde13 ORDER BY c_lastmodified DESC (...) How many events are in this calendar? According to the log above, 1803 entries are returned. The ics file has 2973 BEGIN lines, and 1607 DTSTART lines. I worked around the problem by having a cache where this is displayed. -- Emmanuel Dreyfus m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] ics export is slow
Hi I posted already about this issue and got no reply. I repost as I gathered more information. Exporting as .ucs is painfully slow. It can take more than 30s. I ruled out any problem with Apache and MySQL: 1) No problem in Apache, as the problem happens if I ask SOGo directly: $ ICS=/SOGo/dav/user/Calendar/3E8-50B38880-F-6B8B4580.ics $ time wget http://sogo-anonymous:@localhost:2${ICS} Resolving localhost (localhost)... ::1, 127.0.0.1 Connecting to localhost (localhost)|::1|:2... failed: Connection refused. Connecting to localhost (localhost)|127.0.0.1|:2... connected. HTTP request sent, awaiting response... 401 Authorization Required Authentication selected: basic realm=SOGo Connecting to localhost (localhost)|127.0.0.1|:2... connected. HTTP request sent, awaiting response... 200 OK Length: 1014850 (991K) [text/calendar] Saving to: '3E8-50B38880-F-6B8B4580.ics.3' 3E8-50B38880-F-6B8B 100%[=] 991.06K --.-KB/s in 0.05s 2015-06-30 09:11:15 (19.9 MB/s) - '3E8-50B38880-F-6B8B4580.ics.3' saved [1014850/1014850] 50.48s real 0.00s user 0.04s system 2) No problem with MySQL. I enabled the slow query log, and mysqldumpslow tells me no query took more than 0.25s. Therefore adding an index will not help. Count: 1 Time=0.25s (0s) Lock=0.00s (0s) Rows=1559.0 (1559) SELECT b.c_name,b.c_version,b.c_lastmodified,b.c_creationdate, a.c_component,b.c_content FROM sogouser00636dbde13_quick a, sogouser00636dbde13 b WHERE (c_classification = N) AND a.c_name = b.c_name AND (c_deleted != N OR c_deleted IS NULL) Count: 1 Time=0.03s (0s) Lock=0.00s (0s) Rows=1803.0 (1803), SELECT c_lastmodified FROM sogouser00636dbde13 ORDER BY c_lastmodified DESC Count: 6 Time=0.00s (0s) Lock=0.00s (0s) Rows=1.0 (6), SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'S' AND c_path2 = 'S' AND c_path3 = 'S' AND c_path4 = 'S' Count: 5 Time=0.00s (0s) Lock=0.00s (0s) Rows=3.0 (15), SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'S' AND c_folder_type = 'S' Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows=1.0 (1), SELECT c_uid, c_object, c_role FROM sogoedreyfus0011f18833d_acl WHERE (c_object = 'S') AND ((c_uid = 'S') OR (c_uid LIKE 'S')) Therefore the problem is really inside SOGo. Peeking at the source, it is said that SOGo has to parse the .ics output from the database. Could that be the problem? Is there a way to speed it up? -- Emmanuel Dreyfus m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] .ics output is slow
Hi I use the .ics export for a calendar, and as nee event have been added, it got slower and slower. It now takes more than a minute to fetch. I see the .ics file contains all past events that are of no use, and I suspect this is why it is slow; Is there a cean was to wipe past events? Can I erase them from the database without breaking a reference? Or is my diagnostic wrong and the performance issue to be searched somewhere else? -- Emmanuel Dreyfus m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Antispam antivirus
On Wed, Aug 21, 2013 at 11:49:04PM +0200, Szládovics Péter wrote: 2. Greylisting - you can eliminate the 90% of remain spams I know it is somewhat off-topic, but I cannot resist some advertising for milter-greylist: http://hcpnet.free.fr/milter-greylist/ It does greylisting, and much more thanks to its powerful ACL system that lets you choose what you whitelist/blacklist/greylist (and how long). Free both as in speech and as in beer. Used since 2006 by many organisation around the world. -- Emmanuel Dreyfus m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo 2.0 Microsoft authentication with Samba
Devinder Singh devinder.si...@qlc.in wrote: 1. Is Authentication via SAMBA necessary for Outlook Compatibility ? This question has not been answered, but I have the same: I have an OpenLDAP server, where users have sambaNTPassword attribute. Is it required to use the Samba built-in LDAP server? -- Emmanuel Dreyfus http://hcpnet.free.fr/pubz m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] LDAP search broken
Emmanuel Dreyfus m...@netbsd.org wrote: It seems I cannot get LDAP authentication working, while it works for the address book. When credentials should be validated by LDAP, it always fail (...) It seems the LDAP parameters did not made their way to the function that uses them. This is SOGO 2.0.0b3. I found a workaround: I use Apache with mod_authnz_ldap in front of sogod, set x-webobjects-remote-user, and sogod trusts that. I still have a weird LDAP log message, but authentication works. -- Emmanuel Dreyfus http://hcpnet.free.fr/pubz m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] LDAP search broken
Hi No reply on this? I am still stuck with that problem... Emmanuel Dreyfus m...@netbsd.org wrote: Christian Mack christian.m...@uni-konstanz.de wrote: Did you restart SOGo after changing your configuration? Yes, I did. If you did, what locale do you use as user sogo? None set. Did I miss something in the documentation about that? I quick look at the manual does not show anything about locale. I just set LANG=fr_FR.UTF-8 and restarted sogod, and I now have something that just seems a bit less corrupted: 2011-12-24 16:30:16.153 sogod[12681] -[NGLdapConnection _searchAtBaseDN:qualifier:attributes:scope:]: search with at base filter for attrs RK And show us your LDAP configuration. I have this: keyLDAPDebugEnabled/key stringYES/string (...) keySOGoUserSources/key array dict keyCNFieldName/key stringcn/string keyIDFieldName/key stringuid/string keyIMAPHostFieldName/key stringXXXunusedYet/string keyUIDFieldName/key stringuid/string keybaseDN/key stringdc=example,dc=net/string keybindDN/key string/string keybindFields/key array stringdn/string /array keybindPassword/key string/string keycanAuthenticate/key stringYES/string keydisplayName/key stringExample.net/string keyencryption/key stringSSL/string keyfilter/key string(objectClass=inetOrgPerson)/string keyhostname/key stringldap.example.net/string keyid/key stringpublic/string keyisAddressBook/key stringYES/string keyport/key string636/string /dict /array -- Emmanuel Dreyfus http://hcpnet.free.fr/pubz m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] LDAP search broken
Christian Mack christian.m...@uni-konstanz.de wrote: Did you restart SOGo after changing your configuration? Yes, I did. If you did, what locale do you use as user sogo? None set. Did I miss something in the documentation about that? I quick look at the manual does not show anything about locale. I just set LANG=fr_FR.UTF-8 and restarted sogod, and I now have something that just seems a bit less corrupted: 2011-12-24 16:30:16.153 sogod[12681] -[NGLdapConnection _searchAtBaseDN:qualifier:attributes:scope:]: search with at base filter for attrs RK And show us your LDAP configuration. I have this: keyLDAPDebugEnabled/key stringYES/string (...) keySOGoUserSources/key array dict keyCNFieldName/key stringcn/string keyIDFieldName/key stringuid/string keyIMAPHostFieldName/key stringXXXunusedYet/string keyUIDFieldName/key stringuid/string keybaseDN/key stringdc=example,dc=net/string keybindDN/key string/string keybindFields/key array stringdn/string /array keybindPassword/key string/string keycanAuthenticate/key stringYES/string keydisplayName/key stringExample.net/string keyencryption/key stringSSL/string keyfilter/key string(objectClass=inetOrgPerson)/string keyhostname/key stringldap.example.net/string keyid/key stringpublic/string keyisAddressBook/key stringYES/string keyport/key string636/string /dict /array -- Emmanuel Dreyfus http://hcpnet.free.fr/pubz m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] LDAP search broken
Hello No reply on this one? This is an annoying problem... On Wed, Dec 14, 2011 at 11:25:53AM +, Emmanuel Dreyfus wrote: Hello It seems I cannot get LDAP authentication working, while it works for the address book. When credentials should be validated by LDAP, it always fail, and I have this in the logs: 2011-12-14 12:10:39.717 sogod[12062] -[NGLdapConnection _searchAtBaseDN:qualifier:attributes:scope:]: search with at base àL»Kpº filter àL»HDºK for attrs RK»UcºI It seems the LDAP parameters did not made their way to the function that uses them. This is SOGO 2.0.0b3. -- Emmanuel Dreyfus m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] LDAP search broken
Hello It seems I cannot get LDAP authentication working, while it works for the address book. When credentials should be validated by LDAP, it always fail, and I have this in the logs: 2011-12-14 12:10:39.717 sogod[12062] -[NGLdapConnection _searchAtBaseDN:qualifier:attributes:scope:]: search with at base àL»Kpº filter àL»HDºK for attrs RK»UcºI It seems the LDAP parameters did not made their way to the function that uses them. This is SOGO 2.0.0b3. -- Emmanuel Dreyfus m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Syncing mobile devices (was: Importing Private Events)
On Tue, Dec 13, 2011 at 05:45:02PM +0100, Christian Mack wrote: PS ad you don't need Funambol anymore: How will mobile devices be synched with SOGo 2? Via IMAP, CalDAV and CardDAV. Only Windows and Symbian Phones don't currently work with these at all. But Windows Phones should work with native Exchange support through OpenChange too. But what about Symbian? They still need Funambol, right? -- Emmanuel Dreyfus m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Syncing mobile devices
On Tue, Dec 13, 2011 at 05:48:22PM +0100, Christian Mack wrote: But what about Symbian? They still need Funambol, right? Yes. Is there a pan to address that limitation? It would be nice to get rid of Funambol. -- Emmanuel Dreyfus m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGoTrustProxyAuthentication and funambol
Hello I use SOGo with a webSSO, which has the consequence that apache has a REMOTE_USER, but no password. It feeds the REMOTE_USER to SOGo, and thanks to the SOGoTrustProxyAuthentication, SOGo works fine. Now I want to add Funambol. mobile clients authenticate to Funambol within the syncML protocol, and Funambol passes the credentials to SOGo through an Authorization header. Of course that plays badly with SOGoTrustProxyAuthentication since SOGo will accept the login without validating the password. I had a look at the code, and if I understand correctly, SOGoTrustProxyAuthentication causes SOGo to accept the login taken from x-webobjects-remote-user or from Authorization header. Is it correct that there is no way to trust x-webobjects-remote-user but to validate the credentions from Authorization header? If that is correct, then I am ready to submit a patch to fix that, provided the change makes concensus. -- Emmanuel Dreyfus m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists