[SOGo] Re: any gotchas on LDAP/AD authentication for upgrading from 1.2.2 to 1.3.0

2010-08-30 Thread Yu-Phing Ong



I did a reinstall to 1.3.2 nightly, and changed a few things:
SOGoUserSources = (
    {
        CNFieldName = cn; (instead of displayname)
        IDFieldName = sAMAccountName;  (instead of cn)
        IMAPHostFieldName = mailHost;
        UIDFieldName = sAMAccountName;
        baseDN = "dc=test,dc=internal";
        bindDN = "CN=testuser,CN=users,dc=test,dc=internal";
        bindFields = sAMAccountName;
        bindPassword = testpassword;
        canAuthenticate = YES;
        displayName = "Active Directory";
        hostname = "IPAddress";
        id = directory;
        isAddressBook = YES;
        port = 389;
   }

Initially I was hopeful, it was ok and managed to authenticate.

However, after a few minutes, I would start getting Bind errors again:
2010-08-30 12:08:44.319 sogod[3688] Could not bind to the LDAP server 10.x.x.x(389) using the bind DN: CN=Test User,CN=users,DC=test,DC=internal

If I restart sogod, it will work for a while, then start erroring out again.  Strange.

Can anybody help me to shed some light?  I'm almost prepared to go back to 1.2.2 again (assuming I can), since this seems to have been all caused after an upgrade to 1.3.0 and later.

thanks.


-- Original Message --
   Received: 10:45 AM SGT, 08/10/2010
   From: "Yu-Phing Ong" 
   To: 
   Subject: any gotchas on LDAP/AD authentication for upgrading from 1.2.2 to 1.3.0
  
  
  
  

   I did an upgrade from 1.2.2 to 1.3.0, and after restarting the service, with the same configuration .GNUstepDefaults that has been working fine, I now get unable to bind errors in /var/log/sogod/sogo.log file, for the bindDN user that I have been using fine for the last year or so.

System is a VM (ESXi 4.0 U2) running Centos 5.5, just did a yum update, using  as the repo:
[sogo-nightly-rhel5]
name=Inverse SOGo nightly-build Repository
baseurl=http://inverse.ca/downloads/SOGo/RHEL5/nightly/$basearch
gpgcheck=0

Did see the "known" error about memcached:
memcached-1.4.2-1.el5.i386 from installed has depsolving problems
  --> Missing Dependency: libevent-1.1a.so.1 is needed by package memcached-1.4.2-1.el5.i386 (installed)

But I don't think this is related.

Using an LDAP browser like jxplorer, I am able to connect to the window AD tree with that bindDN and password, so I know it's not a problem with the bindDN and bindPassword/bindFields.

FYI my SOGoUserSources looks something like this (sanitized):

SOGoUserSources = (
    {
        CNFieldName = displayname;
        IDFieldName = cn;
        IMAPHostFieldName = mailHost;
        UIDFieldName = sAMAccountName;
        baseDN = "dc=test,dc=internal";
        bindDN = "testu...@test.internal";
        bindFields = sAMAccountName;
        bindPassword = testpassword;
        canAuthenticate = YES;
        displayName = "Active Directory";
        hostname = "IPAddress";
        id = directory;
        isAddressBook = YES;
        port = 389;
   }
)

Since I am running this in a VM, I had taken a snapshot before, so did a rollback to 1.2.2, and everything is fine again.  So must be something related to the 1.3.0 update.

Any idea what went wrong?  Or have others done the update without any problems?

Thanks.


  
  

  
  






-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] BTS activities for Monday, August 30 2010

2010-08-30 Thread SOGo reporter
Title: BTS activities for Monday, August 30 2010





  
BTS Activities

  Home page: http://www.sogo.nu/bugs
  Project: SOGo
  For the period covering: Monday, August 30 2010

  
  
idlast updatestatus (resolution)categorysummary
	
	
	  
	
788
	2010-08-30 12:29:31
	new (open)
	Web General
	Opera as supported browser
	
	  
	
3
	2010-08-30 15:00:56
	assigned (open)
	Backend Calendar
	Feature Request: Ressource Planning
	
	  
	
705
	2010-08-30 16:32:44
	resolved (fixed)
	SOPE
	SOPE/SOGo 1.3.0 building problems
	
	  
	
776
	2010-08-30 17:47:26
	closed (not fixable)
	Web Calendar
	time zone in Webinterface
	
	  
	
  
  


-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] WebCalendar .ics with https

2010-08-30 Thread Wolfgang Sourdeau

Orchal wrote:

Hi,

No one has already encountered this problem ?

Thank you !


I guess not. But no, authentication is not enabled for remote 
calendars... You could fill a request for it in your BTS if you wish: 
http://sogo.nu/bugs/



Thanks!

--
Wolfgang Sourdeau  ::  +1 (514) 447-4918 ext. 125  ::  wsourd...@inverse.ca
Inverse inc. Leaders behind SOGo (sogo.nu) and PacketFence 
(www.packetfence.org)
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] imaps not working

2010-08-30 Thread Wolfgang Sourdeau

Hi Martin,


They are from the same source.

What is the associated log message ?



Wolfgang

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] imaps not working

2010-08-30 Thread Martin Lehmann

 Hi,

imaps doesn't seem to be working in the latest nightlies.

I saw this bug report http://www.sogo.nu/bugs/view.php?id=460 where it 
says that it should now work in monotone but for me it doesn't.


I tried the following mailserver settings in .GNUstepDefaults but 
neither of them worked:

  SOGoIMAPServer = "imaps://server";
  SOGoIMAPServer = "imaps://server:993";

Are the nightlies different from monotone sources or are they build from 
the monotone sources?


Thx,
Martin


-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] libmemcached2 on debian squeeze

2010-08-30 Thread Wolfgang Sourdeau

Sascha Kasch wrote:

hi,

is there a problem with using libmemcached5 from squeeze testing rather 
than libmemcached2 from sid unstable?


Hi guys,


This has now been fixed. The nightly builds for squeeze are now linked 
against libmemcached5.


Please report any issues...

--
Wolfgang Sourdeau  ::  +1 (514) 447-4918 ext. 125  ::  wsourd...@inverse.ca
Inverse inc. Leaders behind SOGo (sogo.nu) and PacketFence 
(www.packetfence.org)
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] define koi8-u charset

2010-08-30 Thread Oleksa Stasevych
Hi all.

I propose to define koi8-u charset (Ukrainian cyrillic). It differs
from koi8-r (Russian cyrillic) with several specific Ukrainian
letters.
In order to gain the proper result I replaced koi8-r with koi8-u
manually binaries as a workaround, but this is not the right way.

WBR, Oleksa
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Re: Ukrainian localisation

2010-08-30 Thread Oleksa Stasevych
Hi Francis. Yes,thank you. Something went wrong during update and i
didn't find Ukrainian. Oleksa.

2010/8/30, Francis Lachapelle :
> Hi Oleksa
>
> On Aug 28, 2010, at 12:07 PM, Oleksa Stasevych wrote:
>
>> I was surpised not finding Ukrainian localisation in SOGo though it
>> was been announced, look over here:
>> http://www.inverse.ca/english/inverse_news/articles/80.html
>> What went wrong?
>
> Isn't on the demo site (http://sogo-demo.inverse.ca/SOGo/)?
>
> You can set the language to "Українська".
>
>
> Francis
>
> --
> flachape...@inverse.ca :: +1.514.755.3640 :: http://www.inverse.ca
> Inverse :: Leaders behind SOGo (http://sogo.nu) and PacketFence
> (http://packetfence.org)
>
>

-- 
Надіслано з мого мобільного пристрою


---
Tel: +380676227218
E-Mail: oleksiy.stasev...@gmail.com
ICQ: 228807631
Skype: aleks_stassewicz
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Ukrainian localisation

2010-08-30 Thread Francis Lachapelle
Hi Oleksa

On Aug 28, 2010, at 12:07 PM, Oleksa Stasevych wrote:

> I was surpised not finding Ukrainian localisation in SOGo though it
> was been announced, look over here:
> http://www.inverse.ca/english/inverse_news/articles/80.html
> What went wrong?

Isn't on the demo site (http://sogo-demo.inverse.ca/SOGo/)?

You can set the language to "Українська".


Francis

--
flachape...@inverse.ca :: +1.514.755.3640 :: http://www.inverse.ca
Inverse :: Leaders behind SOGo (http://sogo.nu) and PacketFence 
(http://packetfence.org)

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Problem with recurring events [was Re: stack smashing detected]

2010-08-30 Thread Luca Olivetti

En/na Luca Olivetti ha escrit:


RRULE:FREQ=MONTHLY;INTERVAL=1;BYMONTHDAY=22;COUNT=0
EXDATE:2009-11-22;2010-05-22


 This is the line causing the "invalid month given".
If I change it to EXDATE:20091122,20100522 it doesn't give that error 
message anymore, but it still cannot be edited on the webinterface (it 
gives a 404 right away).
To "fix" it completely I have to remove both the "INTERVAL=1" and the 
"COUNT=0" from the "RRULE" line.


Well, actually it doesn't, it gives a 404 right away :-(

Bye
--
Luca Olivetti
Wetron Automatización S.A. http://www.wetron.es/
Tel. +34 93 5883004 (Ext.133)  Fax +34 93 5883007
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Problem with recurring events [was Re: stack smashing detected]

2010-08-30 Thread Luca Olivetti

En/na Luca Olivetti ha escrit:


While doing the restore, I see a bunch of these messages:

2010-08-30 15:19:25.843 sogo-tool[18846] restoring record '1073742958'
2010-08-30 15:19:25.850 sogo-tool[18846] File NSCalendarDate.m: 1440. In
[NSCalendarDate -initWithYear:month:day:hour:minute:second:timeZone:]
invalid month given - 4294967295

This is record 1073742958 in the backup file (the summary is not the
original one but it doesn't matter, I tested it both ways):

c_content = "BEGIN:VCALENDAR
VERSION:1.0
TZ:+0100
DAYLIGHT:TRUE;+0200;20090329T02;20091025T03;;
DAYLIGHT:TRUE;+0200;20100328T02;20101031T03;;
DAYLIGHT:TRUE;+0200;20110327T02;20111030T03;;
DAYLIGHT:TRUE;+0200;20120325T02;20121028T03;;
DAYLIGHT:TRUE;+0200;20130331T02;20131027T03;;
DAYLIGHT:TRUE;+0200;20140330T02;20141026T03;;
DAYLIGHT:TRUE;+0200;20150329T02;20151025T03;;
BEGIN:VEVENT
UID:1073742958
X-FUNAMBOL-ALLDAY:1
DTSTART:20090522
DTEND:20090523
X-MICROSOFT-CDO-BUSYSTATUS:0
CATEGORIES:
DESCRIPTION:
LOCATION:
STATUS:0
SUMMARY:XX
CLASS:PUBLIC
RRULE:FREQ=MONTHLY;INTERVAL=1;BYMONTHDAY=22;COUNT=0
EXDATE:2009-11-22;2010-05-22


 This is the line causing the "invalid month given".
If I change it to EXDATE:20091122,20100522 it doesn't give that error 
message anymore, but it still cannot be edited on the webinterface (it 
gives a 404 right away).
To "fix" it completely I have to remove both the "INTERVAL=1" and the 
"COUNT=0" from the "RRULE" line.



RDATE:
X-FUNAMBOL-AALARMOPTIONS:4
END:VEVENT
END:VCALENDAR
";
c_name = 1073742958;
},


Bye
--
Luca Olivetti
Wetron Automatización S.A. http://www.wetron.es/
Tel. +34 93 5883004 (Ext.133)  Fax +34 93 5883007
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Problem with recurring events [was Re: stack smashing detected]

2010-08-30 Thread Luca Olivetti

En/na Luca Olivetti ha escrit:

En/na Wolfgang Sourdeau ha escrit:



Any hint?


There is likely one particular event that causes the issue. What you 
might want to do is to extract the event in question. Since the crash 
occurs in the reccurence code, you need to search for an element in 
your boss's tables where the c_cycleinfo column is not null and where 
the c_creationdate column is recent enough.



There is a bunch of those, may I assume that, since the crash occurs in 
iCalMonthlyRecurrenceCalculator, that the event causing the problem is a 
monthly one?

The columns c_startdate and c_enddate are unix timestamps?
Finally, I don't think that the c_creationdate matters, after all it 
still works with the version of sogo that I'm running now, so it could 
be and old entry.


If you wish, you could send us a dump of your boss's tables so that we 
can debug this from here...


If I cannot debug it myself I'll ask for permission, thanks.


Been away from sogo for a while. Now I'm testing 1.3.1.

I took a backup with sogo-tool and restored it in a test server with
1.3.1 (using -F to use the same data).

There's no problem with the stack now (but note that the test server is 
i586 while the production server is x86_64) but I still have problems 
with recurring events.


While doing the restore, I see a bunch of these messages:

2010-08-30 15:19:25.843 sogo-tool[18846] restoring record '1073742958'
2010-08-30 15:19:25.850 sogo-tool[18846] File NSCalendarDate.m: 1440. In
[NSCalendarDate -initWithYear:month:day:hour:minute:second:timeZone:]
invalid month given - 4294967295

This is record 1073742958 in the backup file (the summary is not the
original one but it doesn't matter, I tested it both ways):

c_content = "BEGIN:VCALENDAR
VERSION:1.0
TZ:+0100
DAYLIGHT:TRUE;+0200;20090329T02;20091025T03;;
DAYLIGHT:TRUE;+0200;20100328T02;20101031T03;;
DAYLIGHT:TRUE;+0200;20110327T02;20111030T03;;
DAYLIGHT:TRUE;+0200;20120325T02;20121028T03;;
DAYLIGHT:TRUE;+0200;20130331T02;20131027T03;;
DAYLIGHT:TRUE;+0200;20140330T02;20141026T03;;
DAYLIGHT:TRUE;+0200;20150329T02;20151025T03;;
BEGIN:VEVENT
UID:1073742958
X-FUNAMBOL-ALLDAY:1
DTSTART:20090522
DTEND:20090523
X-MICROSOFT-CDO-BUSYSTATUS:0
CATEGORIES:
DESCRIPTION:
LOCATION:
STATUS:0
SUMMARY:XX
CLASS:PUBLIC
RRULE:FREQ=MONTHLY;INTERVAL=1;BYMONTHDAY=22;COUNT=0
EXDATE:2009-11-22;2010-05-22
RDATE:
X-FUNAMBOL-AALARMOPTIONS:4
END:VEVENT
END:VCALENDAR
";
c_name = 1073742958;
},



When I try to edit the event in the web interface, it opens the window
where the confirmation message should appear ("edit this instance",
"edit all instances"), but it either times out or it shows that the 
object doesn't exist right away. This is an example of a time out:


2010-08-30 16:04:52.371 sogod[19835] File NSCalendarDate.m: 1440. In 
[NSCalendarDate -initWithYear:month:day:hour:minute:second:timeZone:] 
invalid month given - 4294967295
2010-08-30 16:04:52.420 sogod[19836] File NSCalendarDate.m: 1440. In 
[NSCalendarDate -initWithYear:month:day:hour:minute:second:timeZone:] 
invalid month given - 4294967295
2010-08-30 16:05:16.283 sogod[18146] File NSCalendarDate.m: 1440. In 
[NSCalendarDate -initWithYear:month:day:hour:minute:second:timeZone:] 
invalid month given - 4294967295
2010-08-30 16:05:17.936 sogod[18152] File NSCalendarDate.m: 1440. In 
[NSCalendarDate -initWithYear:month:day:hour:minute:second:timeZone:] 
invalid month given - 4294967295
127.0.0.1 - - [30/Aug/2010:16:05:47 GMT] "POST 
/SOGo/so/luca/Calendar/personal/1073742958/occurence1285106400/view 
HTTP/1.1" 404 208/0 288.824 - - 0
Aug 30 16:05:48 sogod: SOGo watchdog [18145]: 
<0x0x8281900[WOWatchDogChild]> child 18147 exited
127.0.0.1 - - [30/Aug/2010:16:05:51 GMT] "GET 
/SOGo/so/luca/Calendar/personal/1073742958/occurence1285106400/confirmEditing 
HTTP/1.1" 404 208/0 291.575 - - 0
Aug 30 16:05:52 sogod: SOGo watchdog [18145]: 
<0x0x82818d0[WOWatchDogChild]> child 18148 exited
2010-08-30 16:07:52.647 sogod[19836] File NSCalendarDate.m: 1440. In 
[NSCalendarDate -initWithYear:month:day:hour:minute:second:timeZone:] 
invalid month given - 4294967295
2010-08-30 16:07:52.754 sogod[19835] File NSCalendarDate.m: 1440. In 
[NSCalendarDate -initWithYear:month:day:hour:minute:second:timeZone:] 
invalid month given - 4294967295
<0x0xa1eae30[WOHttpTransaction]> client disconnected during delivery of 
response for uri=/SOGo/so/luca/Calendar/personal/1073742958/occurence1285106400/view 
app=SOGo rqKey=so 
rqPath=luca/Calendar/personal/1073742958/occurence1285106400/view> 
(len=208): the socket was shutdown
127.0.0.1 - - [30/Aug/2010:16:08:07 GMT] "POST 
/SOGo/so/luca/Calendar/personal/1073742958/occurence1285106400/view 
HTTP/1.1" 404 208/0 358.782 - - 0
Aug 30 16:08:08 sogod: SOGo watchdog [18145]: 
<0x0x8281930[WOWatchDogChild]> child 18146 exited
<0x0x9994458[WOHttpTransaction]> client disconnected during delivery of 
respon

Re: Re: Re: [SOGo] WebCalendar .ics with https

2010-08-30 Thread Orchal
Hi,

No one has already encountered this problem ?

Thank you !
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Event details in invitation e-mail

2010-08-30 Thread tuomas
Is it possible to include event details (start, end, description) with the
invitation mail in plaintext in addition to the .ics file?

.tuomas


-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Proxy Error 502 : Error reading from remote server :Can't get cStringLength from Unicode string.

2010-08-30 Thread Anthony Milan
 Hi,

I would like to deploy SOGo in my company with Thunderbird 3.1. I'am
preparing this deployment. One thing I have to do is to import existent
calendars as ics files. I tried to import ics file by web interface
(Calendar, Calendars, Import Events...). After, I tried to read this
events with Perl DAV (my ambition is to script the imports) and I had
the error in subject. Before the import, I could read the events created
with SOGo interface without mistake.

How can I find the event which is at the origin of this error? I have
more 300 events in ics file.

Regards,

The sogo.log, apache2 error.log and perl dav debug are as follows.

/var/log/sogo/sogo.log

Aug 30 10:10:07 sogod: SOGo watchdog [1508]: <[so-security]>D validate
key 5E8-4C7B6780-35-7EDBB300 of object:
<0x09608440[SOGoAppointmentFolder]: name=personal
container=0x094F0AF0/Calendar
ocs=/Users/anthony.mi...@ch-stbrieuc.fr/Calendar/personal>
Aug 30 10:10:07 sogod: SOGo watchdog [1508]: <[so-security]>D   found no
security info for key (class SOGoAppointmentFolder):
5E8-4C7B6780-35-7EDBB300
Aug 30 10:10:07 sogod: SOGo watchdog [1508]: <[so-security]>D   default
is allow ...
PostgreSQL72 connection dropped 0x0xaac1b98 (channel=0x0x9a9a5b0)
PostgreSQL72 connection dropped 0x0x959c830 (channel=0x0x90b3538)
EXCEPTION:  NAME:NSCharacterConversionException
REASON:Can't get cStringLength from Unicode string. INFO:(nil)
Aug 30 10:10:08 sogod: SOGo watchdog [1504]:
<0x0x8dbb8a0[WOWatchDogChild]> child 1508 exited
Aug 30 10:10:08 sogod: SOGo watchdog [1504]:
<0x0x8dbb8a0[WOWatchDogChild]>  (terminated due to signal 6)
Aug 30 10:10:08 sogod: SOGo watchdog [1504]: <0x0x8d9f208[WOWatchDog]>
child spawned with pid 2034
Aug 30 10:10:08 sogod: SOGo watchdog [2034]: SNS support disabled.
Aug 30 10:10:08 sogod: SOGo watchdog [2034]:
<0x0x903b018[SOGoProductLoader]> SOGo products loaded from
'/usr/lib/GNUstep/SOGo':
Aug 30 10:10:08 sogod: SOGo watchdog [2034]:
<0x0x903b018[SOGoProductLoader]>   Contacts.SOGo, SchedulerUI.SOGo,
Appointments.SOGo, CommonUI.SOGo, MailerUI.SOGo, MainUI.SOGo,
Mailer.SOGo, ContactsUI.SOGo, PreferencesUI.SOGo, AdministrationUI.SOGo,
MailPartViewers.SOGo
Aug 30 10:10:09 sogod: SOGo watchdog [2034]: |SOGo| version 1.3.0 (build
@vizzini.inverse.ca 201008191852) -- starting
Aug 30 10:10:09 sogod: SOGo watchdog [2034]: |SOGo| vmem size check
enabled: shutting down app when vmem > 512 MB
2010-08-30 10:10:09.494 sogod[2034] PostgreSQL72 connection established:
<0x0x91ffb70[PGConnection]:  connection=0x0x957f028>
2010-08-30 10:10:09.495 sogod[2034] PostgreSQL72 channel 0x0x97901d0
opened (connection=<0x0x91ffb70[PGConnection]:  connection=0x0x957f028>)
2010-08-30 10:10:09.495 sogod[2034] PG0x0x97901d0 SQL: SELECT count(*)
FROM sogo_user_profile
2010-08-30 10:10:09.498 sogod[2034] PG0x0x97901d0 SQL: SELECT count(*)
FROM sogo_folder_info

/var/log/apache2/error.log

[Mon Aug 30 10:10:07 2010] [error] [client 132.147.200.196] (70014)End
of file found: proxy: error reading status line from remote server 127.0.0.1
[Mon Aug 30 10:10:07 2010] [error] [client 132.147.200.196] proxy: Error
reading from remote server returned by
/SOGo/dav/anthony.mi...@ch-stbrieuc.fr/Calendar/personal/

PerlDAV Debug

Mon Aug 30 10:09:48 2010
PROPFIND REQUEST>>
PROPFIND
http://webmail.ch-stbrieuc.fr/SOGo/dav/anthony.mi...@ch-stbrieuc.fr/Calendar/personal/
HTTP/1.1
Host: webmail.ch-stbrieuc.fr:80
User-Agent: DAV.pm/v0.31
Content-Length: 90
Content-Type: text/xml
Depth: 1


PROPFIND RESPONSE>>
HTTP/1.1 502 Proxy Error
Connection: close
Date: Mon, 30 Aug 2010 08:10:07 GMT
Vary: Accept-Encoding
Content-Length: 612
Content-Type: text/html; charset=iso-8859-1
Client-Date: Mon, 30 Aug 2010 08:09:48 GMT
Client-Peer: 132.147.161.87:80
Client-Response-Num: 1
Title: 502 Proxy Error



502 Proxy Error

Proxy Error
The proxy server received an invalid^M
response from an upstream server.^M
The proxy server could not handle the request PROPFIND /SOGo/dav/anthony.mi...@ch
-stbrieuc.fr/Calendar/personal/.
Reason: Error reading from remote server

Apache/2.2.9 (Debian) mod_ssl/2.2.9 OpenSSL/0.9.8g Server at
webmail.ch-stbrieuc.fr Port 80


-- 
Anthony Milan

Centre Hospitalier de Saint-Brieuc
Direction du système d'information
22027 Saint-Brieuc Cedex 1
Tél : 02 96 01 78 39 (67839)
Fax : 02 96 01 75 57

-- 
users@sogo.nu
https://inverse.ca/sogo/lists