Re: [SOGo] Active Directory problems.

2011-09-21 Thread Stefan Perschbacher 
 
Am Dienstag, 20. September 2011 22:54 CEST, Fred Wilhelm fwilh...@careq.com 
schrieb: 
 
 I have SOGo installed through Ubuntu server 11 and apache2 webserver and 
 I am able to connect to the SOGo login page fine. However, I can not 
 authenticate through my AD server. My AD server is a Win2008 box.
 
 {
 sogod = {
  SOGoProfileURL = 
 mysql://sogo:sogo@localhost:3306/sogo/sogo_user_profile;
  OCSFolderInfoURL = 
 mysql://sogo:sogo@localhost:3306/sogo/sogo_folder_info;
  OCSSessionsFolderURL = 
 mysql://sogo:sogo@localhost:3306/sogo/sogo_sessions_folder;
  SOGoAppointmentSendEMailNotifications = YES;
  SOGoCalendarDefaultRoles = (PublicViewer,ConfidentialDAndTViewer);
  SOGoLanguage = English;
  SOGoMailDomain = carmichael.local;
  SOGoDraftsFolderName = Drafts;
  SOGoIMAPServer = localhost;
  SOGoUserSources = ({
  type = ldap;
  CNFieldName = cn;
  IDFieldName = cn;
  UIDFieldName = sAMAccountName;
  baseDN = ou=people,dc=carmichael,dc=local;
  bindDN = admin@carmichael.local; (I have also tried 
 cn=admin,dc=carmichael,dc=local)
  bindPassword = password;
  canAuthenticate = YES;
  displayName = Carmichael Equipment;
  hostname = 10.38.60.25;
  id = public;
  isAddressBook = YES;
  port = 389;});
  SOGoMailingMechanism = smtp;
  SOGoSMTPServer = 127.0.0.1;
  SOGoSentFolderName = Sent;
  SOGoTimeZone = America/New_York;
  SOGoTrashFolderName = Trash;
 };}
 
 I have Thunderbird and iPhone both connecting to the AD server to pull 
 the address book with the settings above. However, the iPhone requires 
 caps ie. OU=People,DC=carmichael,DC=local. I have tried this for SOGo as 
 well with no success.
 -- 
 users@sogo.nu
 https://inverse.ca/sogo/lists
 
Hi,

maybe you need to add
bindFields = sAMAccountName;
after bindPassword.

Best regards,

Stefan

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

[SOGo] how to provision a openchange account

2011-09-21 Thread Dika Ye 
Dear all,

 

Do some body know how to provision a openchange account using the ZEG image?

 

Thanks.

 

Best wishes,

 

Dika.Ye



 

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

Re: [SOGo] problem importing public calendar from google calendar

2011-09-21 Thread Khapare Joshi 
I think these error occurs when I subscribe the google public calander.
After removing the google calendar login is much faster and no error. But
this should work without any problem as - there must be some trick.


On Tue, Sep 20, 2011 at 2:42 PM, Khapare Joshi khapar...@gmail.com wrote:

 hi, I am also getting such error with few user. These user also takes a
 while to login. can you share if you have any idea ?


 On Thu, Sep 8, 2011 at 7:15 AM, Sebastian Reitenbach 
 sebas...@l00-bugdead-prods.de wrote:

 Hi,

 I'm trying to import a calendar from google. The google calendar is shared
 publicly, the URL is like this:
 http://www.google.com/calendar/ical/u...@domain.com/public/basic.ics

 The calendar publishs free busy information.

 When i add the calendar to the sogo web interface, I see the following in
 the logs:

 127.0.0.1 - - [08/Sep/2011:08:28:09 GMT] POST
 /SOGo/so/sebastia/Calendar//addWebCalendar?url=http%3A//
 www.google.com/calendar/feeds/user%2540domain.com/public/basic HTTP/1.1
 200 16/0 10.202 - - -
 2011-09-08 08:30:34.628 sogod[7513] 0x0x85f43908[PostgreSQL72Channel]:
 connection=0x0x803879c8[PGConnection]:  connection=0x0x828b5000: message:
 NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
 sogosebastia0025b1fcff7_pkey for table sogosebastia0025b1fcff7

 2011-09-08 08:30:34.639 sogod[7513] 0x0x85f43908[PostgreSQL72Channel]:
 connection=0x0x803879c8[PGConnection]:  connection=0x0x828b5000: message:
 NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
 sogosebastia0025b1fcff7_quick_pkey for table
 sogosebastia0025b1fcff7_quick

 Sep 08 08:30:34 sogod [7513]: 0x0x839b9aa8[NGSendMail] wrote 1, length
 764
 2011-09-08 08:30:34.733 sogod[7513] 0x0x8590e308[PostgreSQL72Channel]:
 connection=0x0x83605638[PGConnection]:  connection=0x0x8bb49800: message:
 WARNING:  nonstandard use of \\ in a string literal
 LINE 1: UPDATE sogo_user_profile SET c_settings = '{folderINBOX...
  ^
 HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.

 2011-09-08 08:30:34.744 sogod[7513] 0x0x85f43908[PostgreSQL72Channel]:
 connection=0x0x803879c8[PGConnection]:  connection=0x0x828b5000: message:
 WARNING:  nonstandard use of \\ in a string literal
 LINE 1: UPDATE sogo_user_profile SET c_settings = '{folderINBOX...
  ^
 HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.

 Sep 08 08:30:35 sogod [7513]: 0x0x7e81d3c8[OCSiCalFieldExtractor] ERROR:
 unexpected iCalendar parse result: 0x834a3008[iCalFreeBusy]:VFREEBUSY
  6 children: {
  0x80386e88[iCalDateTime]:DTSTART

  1 values: {
  20110908T113000Z
 }
  0x84a1e308[iCalDateTime]:DTEND

  1 values: {
  20110908T123000Z
 }
  0x80386668[iCalDateTime]:DTSTAMP

  1 values: {
  20110908T063034Z
 }
  0x80386ee8[CardElement]:UID

  1 values: {
  1D59-4E686100-5-6B8B4580
 }
  0x80386cc8[iCalPerson]:ATTENDEE

  1 attributes: {
  X-NUM-GUESTS: (0)
 }
  1 values: {
  mailto:u...@domain.com
 }
  0x80386ac8[CardElement]:SUMMARY

  1 values: {
  Busy
 }
 }
 Sep 08 08:30:35 sogod [7513]: [ERROR]
 0x876B1E08[SOGoAppointmentObject]:1D59-4E686100-5-6B8B4580 write failed:
 NSException: 0x84f24a88 NAME:GCSExtractFailed REASON:Quickfield extractor
 did not return a result! INFO:{GCSContent = BEGIN:VCALENDAR
 BEGIN:VFREEBUSY
 DTSTART:20110908T113000Z
 DTEND:20110908T123000Z
 DTSTAMP:20110908T063034Z
 UID:1D59-4E686100-5-6B8B4580
 ATTENDEE;X-NUM-GUESTS=0:mailto:u...@domain.com
 SUMMARY:Busy
 END:VFREEBUSY
 END:VCALENDAR; GCSExtractor = OCSiCalFieldExtractor: 0x7e81d3c8;
 GCSFolder = 0x0x810c30c8[GCSFolder]: id=15
 path=/Users/sebastia/Calendar/1D59-4E686100-3-6B8B4580 type=Appointment
 loc=postgresql://_sogo:sogo@localhost:5432/sogo/sogosebastia0025b1fcff7;
 }
 127.0.0.1 - - [08/Sep/2011:08:30:35 GMT] POST
 /SOGo/so/sebastia/Calendar//addWebCalendar?url=http%3A//
 www.google.com/calendar/ical/user%2540domain.com/public/basic.icsHTTP/1.1 
 200 75/0 0.499 - - -
 127.0.0.1 - - [08/Sep/2011:08:30:35 GMT] POST
 /SOGo/so/sebastia/Calendar/1D59-4E686100-3-6B8B4580/canAccessContent
 HTTP/1.1 204 0/0 0.018 - - -
 2011-09-08 08:30:39.576 sogod[7513] 0x0x8590e308[PostgreSQL72Channel]:
 connection=0x0x83605638[PGConnection]:  connection=0x0x8bb49800: message:
 WARNING:  nonstandard use of \\ in a string literal
 LINE 1: UPDATE sogo_user_profile SET c_settings = '{Mail: {Dr...
  ^
 HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.

 127.0.0.1 - - [08/Sep/2011:08:30:39 GMT] POST
 /SOGo/so/sebastia/Calendar/eventslist?asc=truesort=startday=20110908filterpopup=view_thismonth
 HTTP/1.1 200 2/0 0.031 - - -
 127.0.0.1 - - [08/Sep/2011:08:30:39 GMT] POST
 /SOGo/so/sebastia/Calendar/alarmslist?browserTime=1315463424 HTTP/1.1 200
 2/0 0.016 - - -
 127.0.0.1 - - [08/Sep/2011:08:30:39 GMT] POST
 /SOGo/so/sebastia/Calendar/monthview?day=20110908 HTTP/1.1 200 1210/0 0.029
 6535 81%

[SOGo] threaded view

2011-09-21 Thread Khapare Joshi 
hello,

how to enable threaded view in webinterface

defaults write SOGothreadedview YES

I tried the combination other uppercase and lowercase character that did not
help

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

[SOGo] Share doesn' t work properly

2011-09-21 Thread Alessio Fattorini 

Sogo: 1.3.8a
Andrea shares a calendar with pippo.
Pippo search calendar into Andrea's shares. (with subscribe calendar.. 
button)

Pippo doesn't found anything (no shares), but it's wrong.

Sogo.log (in debug mode) says:
2011-09-21 17:05:02.712 sogod[19125] MySQL4Channel[0x0x9bbe440] 
connection=0x0x9c0b698 SQL: SELECT c_uid, c_object, c_role FROM 
sogoandrea00167fe181f_acl WHERE (c_object = 
'/andrea/Calendar/7BBC-4E788900-1-33087700') AND ((c_uid = 'pippo') OR 
(c_uid LIKE '@%'));
2011-09-21 17:05:02.712 sogod[19125] MySQL4Channel[0x0x9bbe440] 
connection=0x0x9c0b698   query has results, entering fetch-mode.


query has results!

I can verify this.

mysql SELECT c_uid, c_object, c_role FROM sogoandrea00167fe181f_acl 
WHERE (c_object = '/andrea/Calendar/7BBC-4E788900-1-33087700') AND 
((c_uid = 'pippo') OR (c_uid LIKE '@%'));

++---+--+
| c_uid  | c_object  | c_role   |
++---+--+
| @pippo | /andrea/Calendar/7BBC-4E788900-1-33087700 | PublicViewer |
++---+--+
1 row in set (0.00 sec)

why? Webinterface doesn't show anything. Can you help me?
--
Alessio Fattorini (alessio.fattor...@nethesis.it)

nethesis srl - Via degli Olmi 16/4 - 61100 Pesaro (PU)
tel. +39 0721 405516 - fax +39 0721 268147
www.nethesis.it - i...@nethesis.it
--
users@sogo.nu
https://inverse.ca/sogo/lists