Re: [SOGo] SOGo 2.0.4 Memcache Errors on Debian Squeeze

2013-02-12 Thread Valentin Bud
Hello World,

On Mon, Feb 11, 2013 at 09:18:38AM -0500, Jean Raby wrote:
 On 13-02-11 5:20 AM, Valentin Bud wrote:
  Hello World,
  
  I have installed SOGo on Debian Squeeze (again), following the
  online documentation. I will summarize the steps:
  
  1. Add sogo to /etc/apt/sources.list and get the public key,
  
  2. apt-get update,
  
  3. apt-get install sogo memcached apache2 
  
  4. a2enmod rewrite proxy proxy_http headers
  
  5. mkdir /etc/sogo ; touch /etc/sogo/sogo.conf ; chown -R sogo:root
  /etc/sogo
  
  6. Uncommented `-vv' from /etc/memcached.conf for greater verbosity,
  
  7. Configured sogo as follows:
  
  /etc/sogo/sogo.conf
  ===
  ```
  {
  OCSFolderInfoURL =
  mysql://databus_pro_sogo:pass@172.16.17.36:3306/databus_pro_sogo/sogo_folder_info;
  OCSSessionsFolderURL =
  mysql://databus_pro_sogo:pass@172.16.17.36:3306/databus_pro_sogo/sogo_sessions_folder;
  SOGoACLsSendEMailNotifications = YES;
  SOGoAppointmentSendEMailNotifications = YES;
  SOGoDebugRequests = YES;
  SOGoDraftsFolderName = Drafts;
  SOGoEnableDomainBasedUID = YES;
  SOGoFirstDayOfWeek = 1;
  SOGoFoldersSendEMailNotifications = YES;
  SOGoForceExternalLoginWithEmail = YES;
  SOGoIMAPServer = imap://172.16.17.38:143;
  SOGoLanguage = English;
  SOGoLoginModule = Mail;
  SOGoMailDomain = databus.pro;
  SOGoMailMessageCheck = every_2_minutes;
  SOGoMailShowSubscribedFoldersOnly = YES;
  SOGoMailingMechanism = smtp;
  SOGoMemcachedHost = 127.0.0.1:11211;
  SOGoPageTitle = SOGo;
  SOGoProfileURL =
  mysql://databus_pro_sogo:pass@172.16.17.36:3306/databus_pro_sogo/sogo_user_profile;
  SOGoSMTPServer = 172.16.17.28;
  SOGoSQLUserProfileURL =
  mysql://databus_pro_sogo:pass@172.16.17.36:3306/databus_pro_sogo/sogo_user_profile;
  SOGoSentFolderName = Sent;
  SOGoSieveServer = sieve://172.16.17.38:4190;
  SOGoSupportedLanguages = (
  English
  );
  SOGoTimeZone = Europe/Berlin;
  SOGoTrashFolderName = Trash;
  SOGoUserSources = (
  {
  CNFieldName = cn;
  IDFieldName = cn;
  IMAPHostFieldName = gosaMailServer;
  UIDFieldName = cn;
  baseDN = ou=people,dc=databus,dc=pro;
  bindDN = cn=SOGo SYSTEM,ou=people,dc=databus,dc=pro;
  bindFields = mail;
 This doesn't look right, bindFields is an array, so :
   bindFields = (mail);

Thank you Jean Raby for the heads up. It was working even though that
entry was wrong. I have changed it now.

  bindPassword = pass;
  canAuthenticate = YES;
  filter = (objectClass=person);
  hostname = ldap://172.16.17.20:389;;
  id = public;
  isAddressBook = NO;
  scope = sub;
  }
  );
  }
  ```
  
  I can login to the web interface just fine after the configuration so
  the above works as far as I am concerned.
  
  The problem I see are some errors regarding memchaced. I'll post the
  sogo.log and memchached.log entrie when doing a login action.
  
  sogo.log
  
  ```
  Feb 11 11:15:45 sogod [4308]: |SOGo| starting method 'POST' on uri
  '/SOGo/connect'
  Feb 11 11:15:45 sogod [4308]: SOGoRootPage successful login for user
  'valen...@databus.pro' - expire = -1  grace = -1
  Feb 11 11:15:45 sogod [4308]: 0x0x7f4d7395c8a0[SOGoCache] an error
  occurred when caching value for key 'Valentin Bud+attributes': CLIENT
  ERROR
  Feb 11 11:15:45 sogod [4308]: 0x0x7f4d7395c8a0[SOGoCache] an error
  occurred when caching value for key 'Valentin
  b...@databus.pro+attributes': CLIENT ERROR
 snip
 
  memcached.log
  =
  ```
  28 get valen...@databus.pro+attributes
  28 sending key valen...@databus.pro+attributes
  28 END
  28 set session:c7vgF6LWbGA0oCS4hnkGKQ== 0 300 216
  28 STORED
  28 get Valentin Bud+attributes
  28 END
  28 set Valentin Bud+attributes 0 300 262
  28 CLIENT_ERROR bad command line format
  28 {c_uid: Valentin Bud, MailAccess: 1, emails:
  [valen...@databus.pro, Valentin b...@databus.pro], cn: Valentin
  Bud, c_imaphostname: imap.databus.pro, SOGoSource: public,
  c_domain: , c_email: valen...@databus.pro, CalendarAccess: 1}
  28 ERROR
  28 connection closed.
 snip
  
  The memcached.log is full of `CLIENT_ERROR` bad command line format like
  the ones above. I don't think it's worth posting all of them here.
  
  Is there something wrong with my configuration? Could you please be so
  kind in pointing me in the right direction on how to solve this errors?
  
 I think the errors come from the fact that sogo is trying to set a key
 containing a space: Valentin Bud. That is probably not supported by
 memcached.
 
 You could probably work around this limitation by using an attribute
 other than 'CN' as the UIDFieldName.
 This is highly dependent on your LDAP schema/attribute used, so I can't
 help you more than that without seeing an actual LDAP entry.

Re: [SOGo] SOGo 2.0.4 Memcache Errors on Debian Squeeze

2013-02-11 Thread Jean Raby
On 13-02-11 5:20 AM, Valentin Bud wrote:
 Hello World,
 
 I have installed SOGo on Debian Squeeze (again), following the
 online documentation. I will summarize the steps:
 
 1. Add sogo to /etc/apt/sources.list and get the public key,
 
 2. apt-get update,
 
 3. apt-get install sogo memcached apache2 
 
 4. a2enmod rewrite proxy proxy_http headers
 
 5. mkdir /etc/sogo ; touch /etc/sogo/sogo.conf ; chown -R sogo:root
 /etc/sogo
 
 6. Uncommented `-vv' from /etc/memcached.conf for greater verbosity,
 
 7. Configured sogo as follows:
 
 /etc/sogo/sogo.conf
 ===
 ```
 {
 OCSFolderInfoURL =
 mysql://databus_pro_sogo:pass@172.16.17.36:3306/databus_pro_sogo/sogo_folder_info;
 OCSSessionsFolderURL =
 mysql://databus_pro_sogo:pass@172.16.17.36:3306/databus_pro_sogo/sogo_sessions_folder;
 SOGoACLsSendEMailNotifications = YES;
 SOGoAppointmentSendEMailNotifications = YES;
 SOGoDebugRequests = YES;
 SOGoDraftsFolderName = Drafts;
 SOGoEnableDomainBasedUID = YES;
 SOGoFirstDayOfWeek = 1;
 SOGoFoldersSendEMailNotifications = YES;
 SOGoForceExternalLoginWithEmail = YES;
 SOGoIMAPServer = imap://172.16.17.38:143;
 SOGoLanguage = English;
 SOGoLoginModule = Mail;
 SOGoMailDomain = databus.pro;
 SOGoMailMessageCheck = every_2_minutes;
 SOGoMailShowSubscribedFoldersOnly = YES;
 SOGoMailingMechanism = smtp;
 SOGoMemcachedHost = 127.0.0.1:11211;
 SOGoPageTitle = SOGo;
 SOGoProfileURL =
 mysql://databus_pro_sogo:pass@172.16.17.36:3306/databus_pro_sogo/sogo_user_profile;
 SOGoSMTPServer = 172.16.17.28;
 SOGoSQLUserProfileURL =
 mysql://databus_pro_sogo:pass@172.16.17.36:3306/databus_pro_sogo/sogo_user_profile;
 SOGoSentFolderName = Sent;
 SOGoSieveServer = sieve://172.16.17.38:4190;
 SOGoSupportedLanguages = (
 English
 );
 SOGoTimeZone = Europe/Berlin;
 SOGoTrashFolderName = Trash;
 SOGoUserSources = (
 {
 CNFieldName = cn;
 IDFieldName = cn;
 IMAPHostFieldName = gosaMailServer;
 UIDFieldName = cn;
 baseDN = ou=people,dc=databus,dc=pro;
 bindDN = cn=SOGo SYSTEM,ou=people,dc=databus,dc=pro;
 bindFields = mail;
This doesn't look right, bindFields is an array, so :
  bindFields = (mail);
 bindPassword = pass;
 canAuthenticate = YES;
 filter = (objectClass=person);
 hostname = ldap://172.16.17.20:389;;
 id = public;
 isAddressBook = NO;
 scope = sub;
 }
 );
 }
 ```
 
 I can login to the web interface just fine after the configuration so
 the above works as far as I am concerned.
 
 The problem I see are some errors regarding memchaced. I'll post the
 sogo.log and memchached.log entrie when doing a login action.
 
 sogo.log
 
 ```
 Feb 11 11:15:45 sogod [4308]: |SOGo| starting method 'POST' on uri
 '/SOGo/connect'
 Feb 11 11:15:45 sogod [4308]: SOGoRootPage successful login for user
 'valen...@databus.pro' - expire = -1  grace = -1
 Feb 11 11:15:45 sogod [4308]: 0x0x7f4d7395c8a0[SOGoCache] an error
 occurred when caching value for key 'Valentin Bud+attributes': CLIENT
 ERROR
 Feb 11 11:15:45 sogod [4308]: 0x0x7f4d7395c8a0[SOGoCache] an error
 occurred when caching value for key 'Valentin
 b...@databus.pro+attributes': CLIENT ERROR
snip

 memcached.log
 =
 ```
 28 get valen...@databus.pro+attributes
 28 sending key valen...@databus.pro+attributes
 28 END
 28 set session:c7vgF6LWbGA0oCS4hnkGKQ== 0 300 216
 28 STORED
 28 get Valentin Bud+attributes
 28 END
 28 set Valentin Bud+attributes 0 300 262
 28 CLIENT_ERROR bad command line format
 28 {c_uid: Valentin Bud, MailAccess: 1, emails:
 [valen...@databus.pro, Valentin b...@databus.pro], cn: Valentin
 Bud, c_imaphostname: imap.databus.pro, SOGoSource: public,
 c_domain: , c_email: valen...@databus.pro, CalendarAccess: 1}
 28 ERROR
 28 connection closed.
snip
 
 The memcached.log is full of `CLIENT_ERROR` bad command line format like
 the ones above. I don't think it's worth posting all of them here.
 
 Is there something wrong with my configuration? Could you please be so
 kind in pointing me in the right direction on how to solve this errors?
 
I think the errors come from the fact that sogo is trying to set a key
containing a space: Valentin Bud. That is probably not supported by
memcached.

You could probably work around this limitation by using an attribute
other than 'CN' as the UIDFieldName.
This is highly dependent on your LDAP schema/attribute used, so I can't
help you more than that without seeing an actual LDAP entry.

Hope this helps.
 Thank you. Cheers and Goodwill,
 Valentin Bud
 


-- 
Jean Raby
jr...@inverse.ca  ::  +1.514.447.4918 (x120) ::  www.inverse.ca
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence
(www.packetfence.org)
-- 
users@sogo.nu
https://inverse.ca/sogo/lists