Re: [SOGo] No local time zone specified

2021-12-08 Thread Emmanuel Dreyfus
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

2021-08-03 Thread Emmanuel Dreyfus
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

2021-08-02 Thread Emmanuel Dreyfus
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

2021-08-02 Thread Emmanuel Dreyfus
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

2021-07-13 Thread Emmanuel Dreyfus
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

2021-07-13 Thread Emmanuel Dreyfus
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

2019-02-27 Thread Emmanuel Dreyfus
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

2019-01-23 Thread Emmanuel Dreyfus
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

2015-08-06 Thread Emmanuel Dreyfus
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

2015-06-30 Thread Emmanuel Dreyfus
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

2015-06-25 Thread Emmanuel Dreyfus
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

2013-08-28 Thread Emmanuel Dreyfus
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

2012-10-30 Thread Emmanuel Dreyfus
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

2011-12-30 Thread Emmanuel Dreyfus
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

2011-12-29 Thread Emmanuel Dreyfus
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

2011-12-24 Thread Emmanuel Dreyfus
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

2011-12-16 Thread Emmanuel Dreyfus
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

2011-12-14 Thread Emmanuel Dreyfus
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)

2011-12-13 Thread Emmanuel Dreyfus
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

2011-12-13 Thread Emmanuel Dreyfus
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

2011-12-12 Thread Emmanuel Dreyfus
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