[SOGo] ocsmanager
Hi all I am gone thru the Installation Manual and searched the web, but didn't find a how-to to Setup ocsmanager. I have installed openchange and can connect to the openchange Server with Outlook and can Access Sogo, but I haven't find an Installation Manual for the ocsmanager. As far as I understood I Need the funcitonality for free/busy lookups. So I would appreciate if anyone could help me out here. Nice Weekend to all. -- Mit freundlichem Gruß Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net http://www.linkedin.com/in/carstenlaundelellis [1] Links: -- [1] http://www.linkedin.com/in/carstenlaundelellis -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo, Openchange and Outlook
Hi all As I said in my former posts I have installed SOGo, Openchange and Samba following the tutorial by Olivier Bitsch. I am actually running into two Problems, but first things first. I have succeded to install Samba4. Can connect with my PC and joined the Domain. So far so good. Next imap and smtp are working. At least I can see the relevant ports are listening. Now my Problems: When I try to login on SOGo I got a blank Screen with Error HTTP 404 Page not found. The sogo log has the following entries: Jun 26 08:44:49 sogod [12311]: SOGoRootPage successful login from '91.51.56.15' for user 'cdelellis' - expire = -1 grace = -1 91.51.56.15 - - [26/Jun/2013:08:44:49 GMT] POST /SOGo/connect HTTP/1.1 200 27/49 0.068 - - 608K 2013-06-26 08:44:49.584 sogod[12311] ERROR(-[NSNull(misc) forwardInvocation:]): called selector objectForKey: on NSNull ! 2013-06-26 08:44:49.610 sogod[12311] ERROR(-[NSNull(misc) forwardInvocation:]): called selector setObject:forKey: on NSNull ! 2013-06-26 08:44:49.612 sogod[12311] didn't set return value for type 'v' 91.51.56.15 - - [26/Jun/2013:08:44:49 GMT] GET /SOGo/cdelellis HTTP/1.1 404 38/0 0.034 - - 4K The next problem is, when I try to connect via Outlook I got the error message in the attached screen shot: No logs, because I have no idea where to look at. I would appreciate any help. Thankx in advance. --- Mit freundlichem Gruß Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net http://www.linkedin.com/in/carstenlaundelellis [6] Am 2013-06-25 16:48, schrieb Ludovic Marcotte: On 2013-06-25 10:46 AM, Carsten Laun-De Lellis wrote: Ludovic you surely know the tutorial written by Olivier Bitsch on the iabsis website. There is a chapter using RPC to connect outlook to the openchange server. IT is like the Exchange Anywhere function from the Exchange server. I am not talking about accessing SOGo's web interface. To call http://server.ip/rpc/rpcproxy.dll [1] is meant to test the rpc proxy functionality. And as I already said, when connecting with firefox everything worked but IE fails all the times. As I said, it's not meant to be accessed from a web browser. -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca [2] Inverse inc. :: Leaders behind SOGo (http://sogo.nu [3]) and PacketFence (http://packetfence.org [4]) -- users@sogo.nu https://inverse.ca/sogo/lists [5] Links: -- [1] http://server.ip/rpc/rpcproxy.dll [2] http://inverse.ca [3] http://sogo.nu [4] http://packetfence.org [5] https://inverse.ca/sogo/lists [6] http://www.linkedin.com/in/carstenlaundelellis attachment: Outlook_EM.PNG
Re: [SOGo] SOGo, Openchange and Outlook
Hi Folks I have no clue why, but after I restarted Apache the first Problem went away. But I still can't connect Outlook. --- Mit freundlichem Gruß Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net http://www.linkedin.com/in/carstenlaundelellis [5] Am 2013-06-26 08:52, schrieb Carsten Laun-De Lellis: Hi all As I said in my former posts I have installed SOGo, Openchange and Samba following the tutorial by Olivier Bitsch. I am actually running into two Problems, but first things first. I have succeded to install Samba4. Can connect with my PC and joined the Domain. So far so good. Next imap and smtp are working. At least I can see the relevant ports are listening. Now my Problems: When I try to login on SOGo I got a blank Screen with Error HTTP 404 Page not found. The sogo log has the following entries: Jun 26 08:44:49 sogod [12311]: SOGoRootPage successful login from '91.51.56.15' for user 'cdelellis' - expire = -1 grace = -1 91.51.56.15 - - [26/Jun/2013:08:44:49 GMT] POST /SOGo/connect HTTP/1.1 200 27/49 0.068 - - 608K 2013-06-26 08:44:49.584 sogod[12311] ERROR(-[NSNull(misc) forwardInvocation:]): called selector objectForKey: on NSNull ! 2013-06-26 08:44:49.610 sogod[12311] ERROR(-[NSNull(misc) forwardInvocation:]): called selector setObject:forKey: on NSNull ! 2013-06-26 08:44:49.612 sogod[12311] didn't set return value for type 'v' 91.51.56.15 - - [26/Jun/2013:08:44:49 GMT] GET /SOGo/cdelellis HTTP/1.1 404 38/0 0.034 - - 4K The next problem is, when I try to connect via Outlook I got the error message in the attached screen shot: No logs, because I have no idea where to look at. I would appreciate any help. Thankx in advance. --- Mit freundlichem Gruß Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net http://www.linkedin.com/in/carstenlaundelellis [5] Am 2013-06-25 16:48, schrieb Ludovic Marcotte: On 2013-06-25 10:46 AM, Carsten Laun-De Lellis wrote: Ludovic you surely know the tutorial written by Olivier Bitsch on the iabsis website. There is a chapter using RPC to connect outlook to the openchange server. IT is like the Exchange Anywhere function from the Exchange server. I am not talking about accessing SOGo's web interface. To call http://server.ip/rpc/rpcproxy.dll [6] is meant to test the rpc proxy functionality. And as I already said, when connecting with firefox everything worked but IE fails all the times. As I said, it's not meant to be accessed from a web browser. -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca [1] Inverse inc. :: Leaders behind SOGo (http://sogo.nu [2]) and PacketFence (http://packetfence.org [3]) -- users@sogo.nu https://inverse.ca/sogo/lists [4] Links: -- [1] http://inverse.ca [2] http://sogo.nu [3] http://packetfence.org [4] https://inverse.ca/sogo/lists [5] http://www.linkedin.com/in/carstenlaundelellis [6] http://server.ip/rpc/rpcproxy.dll -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo, Openchange and Outlook
Hi Ludovic I will make a fresh Installation. Then let`s see. Maybe i made a misconfiguration somewhere. --- Mit freundlichem Gruß Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net http://www.linkedin.com/in/carstenlaundelellis [5] Am 2013-06-26 12:10, schrieb Ludovic Marcotte: On 2013-06-26 3:09 AM, Carsten Laun-De Lellis wrote: Are they related to my Problem. I think so, but don't know how to fix it. My concern are the entries saying that no auth Cookies are passed by the client. Any suggestions ? Try to first connect without RPC over HTTP (Outlook Anywhere). If it works with normal RPC, we'll progress from there. -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca [1] Inverse inc. :: Leaders behind SOGo (http://sogo.nu [2]) and PacketFence (http://packetfence.org [3]) -- users@sogo.nu https://inverse.ca/sogo/lists [4] Links: -- [1] http://inverse.ca [2] http://sogo.nu [3] http://packetfence.org [4] https://inverse.ca/sogo/lists [5] http://www.linkedin.com/in/carstenlaundelellis -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Sogo login
Hi All @Ludovic: After a fresh install I can connect to OpenChange/Sogo with Outlook (and for me Outlook 2013 works). But now I have problems to log on into SOGo. I found the following entry in the sogo.log file Jun 26 15:36:24 sogod [11519]: 0x0x7f871e447940[LDAPSource] NSException: 0x7f871e4b2820 NAME:LDAPException REASON:operation bind failed: Invalid credentials (0x31) INFO:{login = cn=user,cn=users,dc=domain,dc=net; } Jun 26 15:36:24 sogod [11519]: SOGoRootPage Login from '153.100.131.12' for user 'user' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0 153.100.131.12 - - [26/Jun/2013:15:36:24 GMT] POST /SOGo/connect HTTP/1.1 403 34/49 0.052 - - 2M I don't know what that exactly means and therefor what to do now. My GnuStep config is pretty simple at the Moment, because I am building the System step by step and don't have Setup postfix and dovecot now. So my GNUstep user config looks like follows. array dict keyCNFieldName/key stringdisplayName/string keyIDFieldName/key stringcn/string keyIMAPHostFieldName/key string/string keyUIDFieldName/key stringsAMAccountName/string keybaseDN/key stringcn=Users,dc=domain,dc=net/string keybindDN/key stringcn=_binduser_,cn=Users,dc=domain,dc=net/string keybindPassword/key string_password_/string keycanAuthenticate/key stringYES/string keydisplayName/key stringInternal Addresses/string keyhostname/key stringlocalhost/string keyid/key stringpublic/string keyisAddressBook/key stringYES/string keyport/key string389/string /dict /array keyWOLogFile/key string-/string keyWONoDetach/key -- Mit freundlichem Gruß Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net http://www.linkedin.com/in/carstenlaundelellis [1] Links: -- [1] http://www.linkedin.com/in/carstenlaundelellis -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Openchange and Outlook
Hi all I am not sure if this is the right forum, but i give it a try. My problem is more in regards to openchange. The backend is an ubuntu 12.04 server with a Samba, openchange, sogo installation followed the manual from http://iabsis.com/EN/article/35/Installation-de-Samba4-et-Openchange-sur-un-serveur-Debian-ou-Ubuntu [1] I don't want to use the igestis tool, so I created a Samba4 user, an openchange user and provided this user with a mailbox. On my notebook I have Win8 64 bit with outlook 2013 installed. Whenever I try to connect to the openchange server it doesn't work. The weird thing is, that when I try rpc in the webbrowser as described in the manual it only works with Netscape but not with IE. I have no idea what went wrong, that is the reason why I don't post any configs or logs, because I have no idea where to look at. I would appreciate any hint. Regards, Carsten -- Mit freundlichem Gruß Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net http://www.linkedin.com/in/carstenlaundelellis [2] Links: -- [1] http://iabsis.com/EN/article/35/Installation-de-Samba4-et-Openchange-sur-un-serveur-Debian-ou-Ubuntu [2] http://www.linkedin.com/in/carstenlaundelellis -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Openchange and Outlook
Hi Ludovic That's what I thought first, but why does rpc over http works on firefox but not on IE? I am sure, when I can find an answer to that question I will find a solution for the rest. --- Mit freundlichem Gruß Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net http://www.linkedin.com/in/carstenlaundelellis [5] Am 2013-06-25 16:34, schrieb Ludovic Marcotte: On 2013-06-25 10:23 AM, Carsten Laun-De Lellis wrote: On my notebook I have Win8 64 bit with outlook 2013 installed. We haven't yet tested with OL2013. Your problem might be there. -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca [1] Inverse inc. :: Leaders behind SOGo (http://sogo.nu [2]) and PacketFence (http://packetfence.org [3]) -- users@sogo.nu https://inverse.ca/sogo/lists [4] Links: -- [1] http://inverse.ca [2] http://sogo.nu [3] http://packetfence.org [4] https://inverse.ca/sogo/lists [5] http://www.linkedin.com/in/carstenlaundelellis -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Openchange and Outlook
Ludovic you surely know the tutorial written by Olivier Bitsch on the iabsis website. There is a chapter using RPC to connect outlook to the openchange server. IT is like the Exchange Anywhere function from the Exchange server. I am not talking about accessing SOGo's web interface. To call http://server.ip/rpc/rpcproxy.dll [5] is meant to test the rpc proxy functionality. And as I already said, when connecting with firefox everything worked but IE fails all the times. --- Mit freundlichem Gruß Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net http://www.linkedin.com/in/carstenlaundelellis [6] Am 2013-06-25 16:40, schrieb Ludovic Marcotte: On 2013-06-25 10:38 AM, Carsten Laun-De Lellis wrote: That's what I thought first, but why does rpc over http works on firefox but not on IE? I am sure, when I can find an answer to that question I will find a solution for the rest. What do you mean? If you want to use the SOGo's web interface, just use http{s}://your_server_name/SOGo RPC over HTTP is not meant to be used from a web browser, but from Outlook. -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca [1] Inverse inc. :: Leaders behind SOGo (http://sogo.nu [2]) and PacketFence (http://packetfence.org [3]) -- users@sogo.nu https://inverse.ca/sogo/lists [4] Links: -- [1] http://inverse.ca [2] http://sogo.nu [3] http://packetfence.org [4] https://inverse.ca/sogo/lists [5] http://server.ip/rpc/rpcproxy.dll [6] http://www.linkedin.com/in/carstenlaundelellis -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] ISO image
Hi all Ive tried out the backup and dist with remastersys but I failes all the times. Could anyone provide me with a ZEG ISO image ? Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 Fax: +49 (6306) 992142 email:mailto:carsten.delel...@delellis.net carsten.delel...@delellis.net http://www.linkedin.com/in/carstenlaundelellis http://www.linkedin.com/in/carstenlaundelellis -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Re: New Samba4/OpenChange/Sogo tutorial
Hi All First of all I want to thank Oliver for the great tutorial. I followed it step by step and successfully installed a Samba4 Server and OpenChange. After that I had no problems to join my domain with my Win8 PC. Everything worked fine. I installed the Win Admin Tools and had no issues with adding users to the domain and also set them up as local users. DNS worked great, so I tried the next step. I installed SOGo and after that nothing worked at all. I allways get an error message: Naming information cannot be located because: The RPC Server is unavailable. Contact your system administrators ... I tried to solve the problem by adding my server to the hosts file. But no success. Any ideas to solve this problem? I would provide logging information if I only knew which. Also I didn't get the link where to create the user for SOGo, openchange and Samba4 if I don't want to use iGestis. I would appreciate any hints. Regards, Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net http://www.linkedin.com/in/carstenlaundelellis To all, I've updated my SOGo tutorial and bring the following fixed (still available at http://iabsis.com/EN/article/35/Samba4-and-OpenChange-on-a-Debian-or-Ubuntu-server/ ) - Add a temporarily and cleaner way to install Samba4 (Thanks to Davor Vusir). - Some small other fixes. Don't hesitate to let me a comment on the website if something work or not. Best regards. 2013/3/5 Ludovic Marcotte lmarco...@inverse.ca On 28/02/13 03:27, Olivier Bitsch wrote: Use PostGreSQL by default to avoid the bug http://tracker.openchange.org/issues/413 We identified the bug. MySQL's TEXT data type is limited to 2^16 - 1 = 65535 bytes, so truncation occurs and thus, a crash (because the cache is corrupted). We'll commit a fix shortly and provide an upgrade script (2.0.4 to 2.0.5) to adjust the data type for all tables accordingly. Thanks, -- Ludovic Marcotte+1.514.755.3630 :: www.inverse.ca Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Re: New Samba4/OpenChange/Sogo tutorial
Hi all I found out, that when I delete the openchange settings from the smb.conf file than the Samba4 server works fine and I don't get the Error Message any more. I can than connect to the Server with no problem and use the Admin Tools like intended. Is this how it's supposed to work? Regards, Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net http://www.linkedin.com/in/carstenlaundelellis Hi All First of all I want to thank Oliver for the great tutorial. I followed it step by step and successfully installed a Samba4 Server and OpenChange. After that I had no problems to join my domain with my Win8 PC. Everything worked fine. I installed the Win Admin Tools and had no issues with adding users to the domain and also set them up as local users. DNS worked great, so I tried the next step. I installed SOGo and after that nothing worked at all. I allways get an error message: Naming information cannot be located because: The RPC Server is unavailable. Contact your system administrators ... I tried to solve the problem by adding my server to the hosts file. But no success. Any ideas to solve this problem? I would provide logging information if I only knew which. Also I didn't get the link where to create the user for SOGo, openchange and Samba4 if I don't want to use iGestis. I would appreciate any hints. Regards, Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net http://www.linkedin.com/in/carstenlaundelellis To all, I've updated my SOGo tutorial and bring the following fixed (still available at http://iabsis.com/EN/article/35/Samba4-and-OpenChange-on-a-Debian-or-Ubuntu-server/ ) - Add a temporarily and cleaner way to install Samba4 (Thanks to Davor Vusir). - Some small other fixes. Don't hesitate to let me a comment on the website if something work or not. Best regards. 2013/3/5 Ludovic Marcotte lmarco...@inverse.ca On 28/02/13 03:27, Olivier Bitsch wrote: Use PostGreSQL by default to avoid the bug http://tracker.openchange.org/issues/413 We identified the bug. MySQL's TEXT data type is limited to 2^16 - 1 = 65535 bytes, so truncation occurs and thus, a crash (because the cache is corrupted). We'll commit a fix shortly and provide an upgrade script (2.0.4 to 2.0.5) to adjust the data type for all tables accordingly. Thanks, -- Ludovic Marcotte+1.514.755.3630 :: www.inverse.ca Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Re: New Samba4/OpenChange/Sogo tutorial
Hi all I tried to narrow down the problem a bit. Whenever I start the Apache Web Server the RPC Error comes up. I am then neither able to connect to the AD Managment nor I am able to connect via Outlook. But I also need help on another topic. I am now able to connect to the OpenChange Server using outlook. But what I don't understand where do I get the link to my mailboxes. Let's say for example I want to use postfix and dovecot where do I tell the system which email server to use and how to get the email into the OpenChange server. Any help appreciated. Regards Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net http://www.linkedin.com/in/carstenlaundelellis Hi Olivier Sure. Maybe you have already read my second email where I explainde that after deleting the entries for openchange in the smb.conf everyghing worked fine. I have attached some log files to this email. Regards, Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net http://www.linkedin.com/in/carstenlaundelellis Is it possible to provide some logs files like /var/log/samba/log.samba and /var/log/sogo/sogo.log? Thanks. Olivier. 2013/3/14 Carsten Laun-De Lellis carsten.delel...@delellis.net Hi All First of all I want to thank Oliver for the great tutorial. I followed it step by step and successfully installed a Samba4 Server and OpenChange. After that I had no problems to join my domain with my Win8 PC. Everything worked fine. I installed the Win Admin Tools and had no issues with adding users to the domain and also set them up as local users. DNS worked great, so I tried the next step. I installed SOGo and after that nothing worked at all. I allways get an error message: Naming information cannot be located because: The RPC Server is unavailable. Contact your system administrators ... I tried to solve the problem by adding my server to the hosts file. But no success. Any ideas to solve this problem? I would provide logging information if I only knew which. Also I didn't get the link where to create the user for SOGo, openchange and Samba4 if I don't want to use iGestis. I would appreciate any hints. Regards, Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net http://www.linkedin.com/in/carstenlaundelellis To all, I've updated my SOGo tutorial and bring the following fixed (still available at http://iabsis.com/EN/article/35/Samba4-and-OpenChange-on-a-Debian-or-Ubuntu-server/ ) - Add a temporarily and cleaner way to install Samba4 (Thanks to Davor Vusir). - Some small other fixes. Don't hesitate to let me a comment on the website if something work or not. Best regards. 2013/3/5 Ludovic Marcotte lmarco...@inverse.ca On 28/02/13 03:27, Olivier Bitsch wrote: Use PostGreSQL by default to avoid the bug http://tracker.openchange.org/issues/413 We identified the bug. MySQL's TEXT data type is limited to 2^16 - 1 = 65535 bytes, so truncation occurs and thus, a crash (because the cache is corrupted). We'll commit a fix shortly and provide an upgrade script (2.0.4 to 2.0.5) to adjust the data type for all tables accordingly. Thanks, -- Ludovic Marcotte+1.514.755.3630 :: www.inverse.ca Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Re: New Samba4/OpenChange/Sogo tutorial
Hi all I think I am very Close. I've got openchange running, samba4, sogo but didn't manage to logon. I always got the following error message: Mar 14 17:12:07 sogod [1515]: 0x0x7f7a8444d420[LDAPSource] NSException: 0x7f7a84528960 NAME:LDAPException REASON:operation bind failed: Invalid credentials (0x31) INFO:{login = cn=cdelellis,cn=users,dc=1blu,dc=de; } Mar 14 17:12:07 sogod [1515]: SOGoRootPage Login from '2.206.0.83' for user 'cdelellis' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0 2.206.0.83 - - [14/Mar/2013:17:12:07 GMT] POST /SOGo/connect HTTP/1.1 403 34/69 0.016 - - 0 I have no idea what it is meant with Password policy: 65535. I have checked on the LDAP query. The path cn=cdelellis,cn=users,dc=1blu,dc=de is correct. I checked that using Ldp on my Windows machine. So could anyone please tell me where the misconfiguration is and what to do. Thankx in advance. Regards, Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net http://www.linkedin.com/in/carstenlaundelellis Hi all I tried to narrow down the problem a bit. Whenever I start the Apache Web Server the RPC Error comes up. I am then neither able to connect to the AD Managment nor I am able to connect via Outlook. But I also need help on another topic. I am now able to connect to the OpenChange Server using outlook. But what I don't understand where do I get the link to my mailboxes. Let's say for example I want to use postfix and dovecot where do I tell the system which email server to use and how to get the email into the OpenChange server. Any help appreciated. Regards Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net http://www.linkedin.com/in/carstenlaundelellis Hi Olivier Sure. Maybe you have already read my second email where I explainde that after deleting the entries for openchange in the smb.conf everyghing worked fine. I have attached some log files to this email. Regards, Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net http://www.linkedin.com/in/carstenlaundelellis Is it possible to provide some logs files like /var/log/samba/log.samba and /var/log/sogo/sogo.log? Thanks. Olivier. 2013/3/14 Carsten Laun-De Lellis carsten.delel...@delellis.net Hi All First of all I want to thank Oliver for the great tutorial. I followed it step by step and successfully installed a Samba4 Server and OpenChange. After that I had no problems to join my domain with my Win8 PC. Everything worked fine. I installed the Win Admin Tools and had no issues with adding users to the domain and also set them up as local users. DNS worked great, so I tried the next step. I installed SOGo and after that nothing worked at all. I allways get an error message: Naming information cannot be located because: The RPC Server is unavailable. Contact your system administrators ... I tried to solve the problem by adding my server to the hosts file. But no success. Any ideas to solve this problem? I would provide logging information if I only knew which. Also I didn't get the link where to create the user for SOGo, openchange and Samba4 if I don't want to use iGestis. I would appreciate any hints. Regards, Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net http://www.linkedin.com/in/carstenlaundelellis To all, I've updated my SOGo tutorial and bring the following fixed (still available at http://iabsis.com/EN/article/35/Samba4-and-OpenChange-on-a-Debian-or-Ubuntu-server/ ) - Add a temporarily and cleaner way to install Samba4 (Thanks to Davor Vusir). - Some small other fixes. Don't hesitate to let me a comment on the website if something work or not. Best regards. 2013/3/5 Ludovic Marcotte lmarco...@inverse.ca On 28/02/13 03:27, Olivier Bitsch wrote: Use PostGreSQL by default to avoid the bug http://tracker.openchange.org/issues/413 We identified the bug. MySQL's TEXT data type is limited to 2^16 - 1 = 65535 bytes, so truncation occurs and thus, a crash (because the cache is corrupted). We'll commit a fix shortly and provide an upgrade script (2.0.4 to 2.0.5) to adjust the data type for all tables accordingly. Thanks, -- Ludovic Marcotte+1.514.755.3630 :: www.inverse.ca Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists -- users
Re: [SOGo] Re: New Samba4/OpenChange/Sogo tutorial
Hi all I finally managed to logon with the Administrator account, but not with any other user account. I have no idea where to look at. I still got the same error message for every user but the Administrator. I Need help !! Regards, Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net http://www.linkedin.com/in/carstenlaundelellis Hi all I think I am very Close. I've got openchange running, samba4, sogo but didn't manage to logon. I always got the following error message: Mar 14 17:12:07 sogod [1515]: 0x0x7f7a8444d420[LDAPSource] NSException: 0x7f7a84528960 NAME:LDAPException REASON:operation bind failed: Invalid credentials (0x31) INFO:{login = cn=cdelellis,cn=users,dc=1blu,dc=de; } Mar 14 17:12:07 sogod [1515]: SOGoRootPage Login from '2.206.0.83' for user 'cdelellis' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0 2.206.0.83 - - [14/Mar/2013:17:12:07 GMT] POST /SOGo/connect HTTP/1.1 403 34/69 0.016 - - 0 I have no idea what it is meant with Password policy: 65535. I have checked on the LDAP query. The path cn=cdelellis,cn=users,dc=1blu,dc=de is correct. I checked that using Ldp on my Windows machine. So could anyone please tell me where the misconfiguration is and what to do. Thankx in advance. Regards, Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net http://www.linkedin.com/in/carstenlaundelellis Hi all I tried to narrow down the problem a bit. Whenever I start the Apache Web Server the RPC Error comes up. I am then neither able to connect to the AD Managment nor I am able to connect via Outlook. But I also need help on another topic. I am now able to connect to the OpenChange Server using outlook. But what I don't understand where do I get the link to my mailboxes. Let's say for example I want to use postfix and dovecot where do I tell the system which email server to use and how to get the email into the OpenChange server. Any help appreciated. Regards Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net http://www.linkedin.com/in/carstenlaundelellis Hi Olivier Sure. Maybe you have already read my second email where I explainde that after deleting the entries for openchange in the smb.conf everyghing worked fine. I have attached some log files to this email. Regards, Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net http://www.linkedin.com/in/carstenlaundelellis Is it possible to provide some logs files like /var/log/samba/log.samba and /var/log/sogo/sogo.log? Thanks. Olivier. 2013/3/14 Carsten Laun-De Lellis carsten.delel...@delellis.net Hi All First of all I want to thank Oliver for the great tutorial. I followed it step by step and successfully installed a Samba4 Server and OpenChange. After that I had no problems to join my domain with my Win8 PC. Everything worked fine. I installed the Win Admin Tools and had no issues with adding users to the domain and also set them up as local users. DNS worked great, so I tried the next step. I installed SOGo and after that nothing worked at all. I allways get an error message: Naming information cannot be located because: The RPC Server is unavailable. Contact your system administrators ... I tried to solve the problem by adding my server to the hosts file. But no success. Any ideas to solve this problem? I would provide logging information if I only knew which. Also I didn't get the link where to create the user for SOGo, openchange and Samba4 if I don't want to use iGestis. I would appreciate any hints. Regards, Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net http://www.linkedin.com/in/carstenlaundelellis To all, I've updated my SOGo tutorial and bring the following fixed (still available at http://iabsis.com/EN/article/35/Samba4-and-OpenChange-on-a-Debian-or-Ubuntu-server/ ) - Add a temporarily and cleaner way to install Samba4 (Thanks to Davor Vusir). - Some small other fixes. Don't hesitate to let me a comment on the website if something work or not. Best regards. 2013/3/5 Ludovic Marcotte lmarco...@inverse.ca On 28/02/13 03:27, Olivier Bitsch wrote: Use PostGreSQL by default to avoid the bug http://tracker.openchange.org/issues/413 We identified the bug. MySQL's TEXT data type is limited to 2^16 - 1 = 65535 bytes, so
RE: [SOGo] How to start openldap listening on another port than 389
Hi all I got so many hints how to change the slapd behaviour. I want to thank everyone for that and I will try out next week what works best for me. Again thank you all. Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 Fax: +49 (6306) 992142 email: carsten.delel...@delellis.net -Original Message- From: Marc Patermann [mailto:hans.mo...@ofd-z.niedersachsen.de] Sent: Donnerstag, 25. Oktober 2012 17:52 To: users@sogo.nu Subject: Re: [SOGo] How to start openldap listening on another port than 389 Carsten, Carsten Laun-De Lellis schrieb (25.10.2012 09:59 Uhr): I don't know if I am the only one with this problem, but I didn't get openldap listening on any other port than 389. The plan is to run an samba4 ldap and an openldap server on the same machine. Therefor I need openldap listening on any other port than 389. I have tried to start slapd with the -h ldap://localhost:939 option but that doesn't work. Still listens on port 389. have you tried ldap://127.0.0.1:939 instead or ldap://0.0.0.0:939? man slapd tells Hosts may be specified by name or IPv4 and IPv6 address formats. so localhost might be OK. I am running ubuntu 12.04 and have no idea where to start. check the ubuntu documentation or a corresponding list/forum. Are you sure you changed the port at the right place where the start script gets its settings from? Did you check you setting made it to the process i.e. with the ps command? Marc -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] using samba4 as an AD along with openchange
Hi Do you have a local dns server running with _ldap._tcp and _kerberos._udp defined? I made also the experience that for the time I want to join the domain I have to turn off the rpcproxy in the smb.conf file. Also when I try to administrate the domain with the remote admin tools. Mit freundlichem Gruß Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net quote who=deepak Hi, I've successfully installed openchange and sogo2 on Ubuntu 12.04 and now and the outlook compatibility works fine. I'm trying to use the samba4 in the same machine as an AD server also. Dns is working fine, i've checked all the records. I've tested kerberos login also, that also works fine. But when i try to join to domain, i 'm getting an error saying that networks path not found. The dns server for windows machine is the the samba server. I've tried to query dns from the windows machine and that also works fine. I made samba running on debug level 5, but still i dont see any error in samba logs. Regards Deepak DeepRootLinux www.deeproot.in -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Expanding the openchange schema
Hi list I am trying to set up a server with postfix, dovecot and openchange. I managed to install the samba4 service and openchange. But there are still two questions I didn't find a solution yet: a.) When I create an openchange user I can't see him in the AD Ldap. Is this correct or do I make a mistake? b.) When I use the Windows Remote Administration Toolset I can administrate the Samba4 AD in adding users and groups and so on. But when I add a user there is only one field for the email address. Does anybody know how to expand the schema so I can have more than one email address per user like I have in MS Exchange. This is important to implement alias functionality when using only the samba AD as userdb and authdb. I would appreciate any help. Mit freundlichem Gruß Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] using samba4 as an AD along with openchange
That is how I changed my smb.conf settings during domain join. ### Configuration required by OpenChange server ### # dcerpc endpoint servers = epmapper, mapiproxy # dcerpc_mapiproxy:server = true # dcerpc_mapiproxy:interfaces = exchange_emsmdb, exchange_nsp, exchange_ds_rfr ### Configuration required by OpenChange server ### Mit freundlichem Gruß Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net quote who=deepak Hi Do you have a local dns server running with _ldap._tcp and _kerberos._udp defined? I made also the experience that for the time I want to join the domain I have to turn off the rpcproxy in the smb.conf file. Also when I try to administrate the domain with the remote admin tools. Thanks for the reply. Yes i've configured the local dns on the same machine with bind v9.8. Let me try turning off the rpcproxy option in smb.conf. Regards Deepak DeeprootLinux www.deeproot.in -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] How to start openldap listening on another port than 389
Hi all I don't know if I am the only one with this problem, but I didn't get openldap listening on any other port than 389. The plan is to run an samba4 ldap and an openldap server on the same machine. Therefor I need openldap listening on any other port than 389. I have tried to start slapd with the -h ldap://localhost:939 option but that doesn't work. Still listens on port 389. I am running ubuntu 12.04 and have no idea where to start. Mit freundlichem Gruß Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] using samba4 as an AD along with openchange
Hi Deepak It depends on what you wanna do. My purpose was to set up a mail server with sogo and an openchange backend for outlook support. That means that I don't have the need to adminstrate many computers. I only need a few computers joining the domain so I can administrate users with the remote administration tools. So for the time a computer wants to join the domain I turned of the rpcproxy function and turn it on afterwords. If I want to administrate a large amount of PCs and users at the same time I would setup another DC to use for computer and user administration purposes. Mit freundlichem Gruß Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net quote who=deepak Hi ### Configuration required by OpenChange server ### # dcerpc endpoint servers = epmapper, mapiproxy # dcerpc_mapiproxy:server = true # dcerpc_mapiproxy:interfaces = exchange_emsmdb, exchange_nsp, exchange_ds_rfr ### Configuration required by OpenChange server ### Which means i cannot do both simultaneously rite. I thought i can use it as AD for some machines and openchange server for a few machines. Regards Deepak DeepRootLinux Develeopers of deepOfix Mail Server www.deeproot.in -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] sogo and openchange with dovecot auth agains samba4 AD
Hi group I am currently running a mail server on ubuntu 11.04 with postfix 2.8.5, dovecot dovecot 2.0.13 and openldap 2.4.23. I have now read about sogo and I am thinking about installing it because of it's native outlook support capabilities. The ZEG appliance wouldn't be an option for me because I use a virtual server from a provider where I can't install my own vm or even an iso. When I go thru the documentation there is a part with installing OpenChange based on samba4. As far as I understood the OpenChange authentication is against the samba4 AD. Actually there is no support in syncing the AD against an OpenLdap Server and I would have to change the OpenLdap port because the AD is listening on port 389. To change the port wouldn't be a big deal, but what i was thinking about to run the dovecot auth also against the samba 4 AD. I searched around on the internet but didn't find a doc yet how to do that. Does anyone here could provide me with a link or a how-to ? Thanks very much in advance. Mit freundlichem Gruß Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delel...@delellis.net -- users@sogo.nu https://inverse.ca/sogo/lists
AW: [SOGo] Error while compiling openchange
Hi all I changed the PYTHONPATH but I still got the same error message. What is confusing me is that ldb mismatch: ldb: module version mismatch in ../dsdb/samdb/ldb_modules/acl.c : ldb_version=1.0.1 module_version=0.9.22 ldb: failed to initialise module bin/python/samba/../../../bin/modules/ldb/acl.so : Unavailable Setting up secrets.ldb Any ideas Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net -Ursprüngliche Nachricht- Von: Ludovic Marcotte [mailto:lmarco...@inverse.ca] Gesendet: Mittwoch, 22. Juni 2011 13:03 An: users@sogo.nu Betreff: Re: [SOGo] Error while compiling openchange On 22/06/11 06:42, Fabrice Durand wrote: # Teach ld.so about the non standard location of samba4 libraries sudo su -c 'echo /usr/local/samba/lib /etc/ld.so.conf.d/samba4.conf' # update PKG_CONFIG_PATH and PYTHONPATH sudo su -c 'echo PKG_CONFIG_PATH=$PKG_CONFIG_PATH:/usr/local/samba/lib/pkgconfig; export PKG_CONFIG_PATH /etc/profile.d/samba4-env-build.sh' sudo su -c 'echo PYTHONPATH=$PYTHONPATH:/usr/local/samba/lib64/python2.7/site-packages ; export PYTHONPATH /etc/profile.d/samba4-env-build.sh' . /etc/profile.d/samba4-env-build.sh You should adjust the Wiki with those instructions for Fedore Core 15 (and perhaps, RHEL vX). Regards, -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: www.inverse.ca Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] All configuration settings
Hi all Does anybody know if there is a list with all configuration variables and settings for SOGO? I would appreciate any link. Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email:mailto:carsten.delel...@delellis.net carsten.delel...@delellis.net -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Address Book
Hi Sven Thank you for your advice. Maybe I will try another way and implement the administration via a web frontend in sql. Is there a way to connect to an ldap server address book? Not in the global configuration but to subscribe for every single user by its own ? But still there is the open topic, how to change the colum names and data in SOGo web interface. Has anybody ideas to share with me? Regards, Carsten Am Donnerstag, 14. April 2011 08:30 CEST, Sven Marth sma...@marth.com schrieb: Am 13.04.2011 23:36, schrieb Carsten Laun-De Lellis: Hi all I created a user source in mysql and want to use this as address book. It worked so far, that I can see the users in the global address book, but I cant edit any entries. Also i want to change the colums with the attributes in the web interface. Any help ? -- Mit freundlichem Gru *Carsten Laun-De Lellis* Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net Hi Carsten, so far I now, the global address book is read only by design. If you like to have a real Global Address Book, setup a shared account and share that address book to all users. cu Sven -- users@sogo.nu https://inverse.ca/sogo/lists -- Mit freundlichem Gru Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net
Re: [SOGo] Problem with mailstore SOGo.
Hi Jesus Did you doublecheck your imap settings. Do the users need to logon with their email addresses instead of user account. Do you use tls or ssl ? These are the first settings I would look into. Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net Am Donnerstag, 14. April 2011 11:52 CEST, Jess Alba Rivas jesusalbari...@gmail.com schrieb: Good Mornings, we are having problem with sogo, specifically with the mailstore. Sogo is connect with ldap, we can logger into web interface and to send mails, but we dont see the users mailstore. Have anyone some idea? Thanks so much :)= -- users@sogo.nu https://inverse.ca/sogo/lists -- Mit freundlichem Gru
[SOGo] contact categories
Hi I went thru the manual and found a parameter SOGoContactsCategories that is used to define the categories that can be associated to contacts. Has anyone an example how a list could look like ? How do you match it to the fields of the database or ldap directory ? Any help appreciated. -- Mit freundlichem Gru Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net
[SOGo] Address Book
Hi all I created a user source in mysql and want to use this as address book. It worked so far, that I can see the users in the global address book, but I cant edit any entries. Also i want to change the colums with the attributes in the web interface. Any help ? -- Mit freundlichem Gru Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net
Re: [SOGo] ANN: SOGo ZEG with Native Outlook Compatibility - TP7
Hey Ludovic When will be an updated howto for the installation of SOGo with openchange available. I am using a vServer from a service provider and therefor virtual appliances are no option for me. But as soon as a new howto is gonna be released I will try it out. Regards, Carsten
Re: [SOGo] ANN: SOGo ZEG with Native Outlook Compatibility - TP7
Hey Ludovic When will an updated howto be available. I am using a vServer from a hoster and therefor virtual machines are not available to me. But i am very interested in the solution with openChange and as soon as an updated howto is out i will try it out. Regards, Carsten Am Dienstag, 08. Mrz 2011 16:29 CET, Ludovic Marcotte lmarco...@inverse.ca schrieb: Inverse is proud to announce the seventh downloadable version of SOGo ZEG with native Microsoft Outlook compatibility. The virtual appliance consists of the latest development version of SOGo, SOPE and OpenChange, properly installed and configured. Note that the native Microsoft Outlook compatibility is still *considered as experimental*. The fundamentals have been developed and the progress towards an end-user usable version will be fast from now on. Nonetheless, we release this Technology Preview ZEG edition to show how promising this is. == Getting it == To download ZEG Technology Preview, simply point your browser to http://www.sogo.nu/english/downloads/zeg.html Look for Virtual Appliance - Native Outlook Compatibility. For configuration instructions, look at the following FAQ: http://www.sogo.nu/english/nc/support/faq/article/how-to-configure-outlook-to-work-with-openchange.html == Changes == Here is a list of changes performed by the Inverse team since TP6 was released : * Added notifications support, meaning that views will now be refreshed as soon as an element is created, modified or deleted * Added support for multiple users (see below for instructions) * Various other small bug fixes and minor improvements == Upcoming improvements == The follow improvements will occur in the next following days, likely resulting in a TP8 : * Integrate the mapistore_v2 work which will allow us to support all SOGo user folders and all SOGo users easily (making freebusy lookup for other users more easy) * Initial recurrence support for events and tasks Some bug fixes or improvements need to be added in OpenChange to make the solution even more usable and we are working with them to : * Reminder issues which can cause Outlook to disconnect momentarily Those will be added once the mapistore_v2 transition is completed. == Installation / Update == Both SOGo and SOPE were installed from the Monotone repository while OpenChange was installed using the sogo branch from their official Subversion server. To update those components on ZEG from TP4, simply sudo as root. Then run the following script : /home/sogo/update.sh You might want to restart Outlook after the update. == Adding users to an existing environments == This is a two-step process because SOGo and Samba/OpenChange do not share the same user database. First of all, you need to add your users to your LDAP database, exactly as documented in the SOGo Installation guide (http://www.sogo.nu/files/docs/SOGo%20Installation%20Guide.pdf). Afterwards, you need to replicate those accounts to the Samba database and populate their OpenChange profile using the 3 following commands: samba-tool newuser [username] [password] ./setup/openchange_newuser --create [username] ./setup/openchange_newuser --mailbox [username] It is easier to setup accounts having their username set as password. If you prefer not, you will need to edit /usr/local/samba/private with ldbedit -H. From there, you should replace the occurrences of sogo://[username]:[username]@ with sogo://[username]:[password]@. Since ldbedit makes use of vi, you can simply issue the following sequence: :%s/:[username]@/:[password]@/g. Please note that brackets are used here as parameter delimiters... This is temporary and everything will be much more simpler once the migration towards mapistore_v2 is completed. == Helping Out == There are many ways you can help us. You can: * Spread the good word about this technology preview! * Follow our development in the users@sogo.nu mailing list and update regularly the components mentioned above * Contact us if you want to sponsor specific features with regard to Outlook / SOGo compatibility Thanks, -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: www.inverse.ca Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] mysql and password change
Hi all Did anyone managed to set up the password change functionality, when using mysql user source? I tried, but i always got an error message, when changing the password. Regards, Carsten
[SOGo] mysql and password change
Hi all Did anyone managed to set up the password change functionality, when using mysql user source? I tried, but i always got an error message, when changing the password. Regards, Carsten
Re: [SOGo] mysql and password change
Hi No not with email, but I had a performance issue on my web server and hit the send button 3 times. I am sorry. Regards, Carsten Am Donnerstag, 10. Mrz 2011 11:59 CET, Alessio Fattorini alessio.fattor...@nethesis.it schrieb: Il 10/03/2011 11:54, Carsten Laun-De Lellis ha scritto: Hi all Did anyone managed to set up the password change functionality, when using mysql user source? I tried, but i always got an error message, when changing the password. do you have any problem with e-mail? we see your sent triplicate! Bye -- 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
[SOGo] start with no email account
Hi all When i logon to sogo for the first time, there is always an imap account and the smtp account is not configurable at all. SMTP is not a big issue for me at the moment, but i wonder if it is possible with starting sogo with no imap account and let the user configure all imap accounts? I would appreciate any hints. Regards, Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Addressbook attributes
Hi all I just want to know which attributes I can use for setting up addressbooks in mysql. I would appreciate any hints. Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email:mailto:carsten.delel...@delellis.net carsten.delel...@delellis.net -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] error message during logon
Hi all After filling the username and password fields on the logon page, whenever i hit the login button the result is a blank page. When I check the sogo log I can find the following entries. Mar 02 21:33:26 sogod [32761]: 0x0x1dadd7f0[SOGoCache] Cache cleanup interval set every 300.00 seconds Mar 02 21:33:26 sogod [32761]: 0x0x1dadd7f0[SOGoCache] Using host(s) 'localhost' as server(s) 2011-03-02 21:33:26.982 sogod[32761] Note(SoObject): SoDebugKeyLookup is enabled! 2011-03-02 21:33:26.983 sogod[32761] Note(SoObject): SoDebugBaseURL is enabled! 2011-03-02 21:33:26.983 sogod[32761] Note(SoObject): relative base URLs are enabled. 2011-03-02 21:33:26.987 sogod[32761] ERROR(-[NGBundleManager bundleWithPath:]): could not create bundle for path: '/usr/share/GNUstep/Libraries/gnustep-base/Versions/1.19/Resources/SSL.bundl e' 2011-03-02 21:33:26.997 sogod[32761] WOCompoundElement: pool embedding is on. 2011-03-02 21:33:26.998 sogod[32761] WOCompoundElement: id logging is on. Mar 02 21:33:27 sogod [32761]: SOGoRootPage successful login for user 'cdelellis' - expire = -1 grace = -1 Mar 02 21:33:27 sogod [32761]: [WARN] 0x0x1d943f00[SOGoWebDAVAclManager] entry '{DAV:}write' already exists in DAV permissions table Mar 02 21:33:27 sogod [32761]: [WARN] 0x0x1d943f00[SOGoWebDAVAclManager] entry '{DAV:}write-properties' already exists in DAV permissions table Mar 02 21:33:27 sogod [32761]: [WARN] 0x0x1d943f00[SOGoWebDAVAclManager] entry '{DAV:}write-content' already exists in DAV permissions table 2011-03-02 21:33:27.005 sogod[32761] Note: Using UTF-8 as URL encoding in NGExtensions. localhost.localdomain - - [02/Mar/2011:21:33:27 GMT] POST /SOGo/connect HTTP/1.1 200 27/49 0.027 - - 2M localhost.localdomain - - [02/Mar/2011:21:33:27 GMT] GET /SOGo/cdelellis HTTP/1.1 302 0/0 0.003 - - 28K localhost.localdomain - - [02/Mar/2011:21:33:27 GMT] GET /SOGo/cdelellis/view HTTP/1.1 302 0/0 0.004 - - 32K Has anyone any ideas, whats wrong in my configuration? Appreciate any help. Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email:mailto:carsten.delel...@delellis.net carsten.delel...@delellis.net -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Idle intervall
Hi all I wonder if there is a configuration where I can set the idle time before SOGo loggs me automatically off? Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net -- users@sogo.nu https://inverse.ca/sogo/lists
AW: [SOGo] Idle intervall
Hi Martin Thank you for your reply. But maybe I was not clear about my question. I don't want to be logged of to soon. At the moment when I was logged in and just read a website I have to log in new, because SOGo logged me out. I want to extend the time before automatically logged out. Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net -Ursprüngliche Nachricht- Von: Martin Rabl [mailto:martin.r...@rablnet.de] Gesendet: Freitag, 11. Februar 2011 12:34 An: users@sogo.nu Betreff: Re: [SOGo] Idle intervall Hi, Am 11.02.2011 12:13, schrieb Carsten Laun-De Lellis: I wonder if there is a configuration where I can set the idle time before SOGo loggs me automatically off? Looked for it, didn't find one. Maybe this will run: - Create a cronjob - the job looks every minute into table sogo_sessions_folder and checks the field/s c_creationdate and/or c_lastseen - when to old - delete the entry, which will log you off when you try to, I think (isn't it?) -- Viele Grüße, Martin Rabl -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
AW: [SOGo] WG: sogo and openchange
Hi Wolfgang Thank you very much for your reply. I would love to go with the ZEG, but I am using a server at a hosting provider. This is pretty cheap with a very good performance, but it is a virtual machine and therefor I don't have the choice to use a virtual machine. It is not a big issue for me to have no openchange yet. I will wait and if the project will make progress I am sure there will be a new documentation. But again many thanks. Not only for replying to my request, but to you and all the other guys, that are working on OpenSource projects, who give me the chance to have reliable, secure software. Mit freundlichem Gruß / Regards Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net -Ursprüngliche Nachricht- Von: Wolfgang Sourdeau [mailto:wsourd...@inverse.ca] Gesendet: Dienstag, 8. Februar 2011 16:12 An: carsten.delel...@delellis.net Betreff: Re: [SOGo] WG: sogo and openchange Hi Carsten, The setup instructions for OpenChange/SOGo are outdated and should be ignored. Since the software distribution is likely to change again soon, we will not update them. So I would recommend you to use our OpenChange ZEG instead. Cheers, -- 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] sogo and openchange
) make[2]: *** [obj/MAPIStoreContext.m.o] Error 1 make[1]: *** [internal-bundle-run-compile-submake] Error 2 make: *** [SOGoBackend.all.bundle.variables] Error 2 Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email:mailto:carsten.delel...@delellis.net carsten.delel...@delellis.net -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] WG: sogo and openchange
Sorry I forgot to mention that I am running Ubuntu 10.04. Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net Von: Carsten Laun-De Lellis [mailto:carsten.delel...@delellis.net] Gesendet: Montag, 7. Februar 2011 23:52 An: users@sogo.nu Betreff: sogo and openchange Hi all I am still trying to install openchange and sogo I followed the how-tos from the openchange site and installed and set up an openchange server. I assume that everything is running ok, because the output during installation was as described in the manuals and I can see samba listening on port 139 and several samba processes running. I tried now to install the openchange connector, but that didnt work. I got the following output and have no idea what to do. Any ideas ? In file included from MAPIStoreContext.m:54: /usr/local/samba/include/mapistore/mapistore.h:57:28: error: mapistore_defs.h: No such file or directory cc1obj: warnings being treated as errors In file included from MAPIStoreContext.m:54: /usr/local/samba/include/mapistore/mapistore.h:129: error: 'enum MAPISTORE_DFLT_FOLDERS' declared inside parameter list /usr/local/samba/include/mapistore/mapistore.h:129: error: its scope is only this definition or declaration, which is probably not what you want In file included from MAPIStoreContext.m:54: /usr/local/samba/include/mapistore/mapistore.h:131: error: 'enum MAPISTORE_NAMEDPROPS_PROVISION_TYPE' declared inside parameter list /usr/local/samba/include/mapistore/mapistore.h:133: error: 'enum MAPISTORE_DFLT_FOLDERS' declared inside parameter list /usr/local/samba/include/mapistore/mapistore.h:145: error: 'enum MAPISTORE_TABLE_TYPE' declared inside parameter list /usr/local/samba/include/mapistore/mapistore.h:154: error: 'enum MAPISTORE_DELETION_TYPE' declared inside parameter list /usr/local/samba/include/mapistore/mapistore.h:174: error: 'enum MAPISTORE_DFLT_FOLDERS' declared inside parameter list /usr/local/samba/include/mapistore/mapistore.h:204: error: 'enum MAPISTORE_DELETION_TYPE' declared inside parameter list /usr/local/samba/include/mapistore/mapistore.h:206: error: 'enum MAPISTORE_DELETION_TYPE' declared inside parameter list MAPIStoreContext.m: In function '-[MAPIStoreContext setURI:andMemCtx:]': MAPIStoreContext.m:270: error: 'MAPISTORE_FAI_TABLE' undeclared (first use in this function) MAPIStoreContext.m:270: error: (Each undeclared identifier is reported only once MAPIStoreContext.m:270: error: for each function it appears in.) MAPIStoreContext.m: In function '-[MAPIStoreContext _tableForFID:andTableType:]': MAPIStoreContext.m:555: error: 'MAPISTORE_MESSAGE_TABLE' undeclared (first use in this function) MAPIStoreContext.m:568: error: 'MAPISTORE_FAI_TABLE' undeclared (first use in this function) MAPIStoreContext.m:581: error: 'MAPISTORE_FOLDER_TABLE' undeclared (first use in this function) MAPIStoreContext.m: In function '-[MAPIStoreContext getTableProperty:withTag:atPosition:withTableType:andQueryType:inFID:]': MAPIStoreContext.m:719: error: 'MAPISTORE_PREFILTERED_QUERY' undeclared (first use in this function) MAPIStoreContext.m:719: error: 'queryType' has an incomplete type MAPIStoreContext.m:737: error: 'queryType' has an incomplete type MAPIStoreContext.m: At top level: cc1obj: error: type '({anonymous})' does not have a known size MAPIStoreContext.m: In function '-[MAPIStoreContext openMessage:forKey:inTable:]': MAPIStoreContext.m:796: error: dereferencing pointer to incomplete type MAPIStoreContext.m:828: error: dereferencing pointer to incomplete type MAPIStoreContext.m: In function '-[MAPIStoreContext openMessage:withMID:inFID:]': MAPIStoreContext.m:847: error: 'MAPISTORE_FAI_TABLE' undeclared (first use in this function) MAPIStoreContext.m:856: error: 'MAPISTORE_MESSAGE_TABLE' undeclared (first use in this function) MAPIStoreContext.m: In function '-[MAPIStoreContext setPropertiesWithFMID:ofTableType:inRow:]': MAPIStoreContext.m:1210: error: 'MAPISTORE_MESSAGE' undeclared (first use in this function) MAPIStoreContext.m:1233: error: 'MAPISTORE_FOLDER' undeclared (first use in this function) MAPIStoreContext.m: In function '-[MAPIStoreContext setProperty:withFMID:ofTableType:fromFile:]': MAPIStoreContext.m:1263: error: 'MAPISTORE_MESSAGE' undeclared (first use in this function) MAPIStoreContext.m:1277: error: 'MAPISTORE_FOLDER' undeclared (first use in this function) MAPIStoreContext.m: In function '-[MAPIStoreContext getProperty:withFMID:ofTableType:intoFile:]': MAPIStoreContext.m:1306: error: 'MAPISTORE_MESSAGE' undeclared (first use in this function) MAPIStoreContext.m:1337: error: 'MAPISTORE_FOLDER' undeclared (first use in this function) MAPIStoreContext.m: In function '-[MAPIStoreContext deleteMessageWithMID:inFID:withFlags
[SOGo] OpenChange
Hi Is there anyone who had successfully installed OpenChange and SOGo ? If so, i would appreciate the input on tricks and everything that is not part of the how-tos on the OpenChange website. Example: For me it not clear if the openldap server needs to be set up and/or running. Do i need to update the schemas manually. And if yes, how? Do i need to have my own dns server running. Or what are the requirements for the dns server i am using? That part that is discribed in the how-to How to install OpenChange from source is straightforward, but the configuration is hard to understand what exactly to do. Or maybe did in misunderstood something and the OpenChange must not be configured befor installing and configuring SOGo ? I would appreciate any comments. Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net -- users@sogo.nu https://inverse.ca/sogo/lists
RE: [SOGo] OpenChange Installation
I have checked the OpenChange site and found an entry in one forum that mentioned, that there is no configure, but to try make instead. When I tried make I ran into the following error messages: This is gnustep-make 2.2.0. Type 'make print-gnustep-make-help' for help. Making all for bundle SOGoBackend... Compiling file MAPIStoreContext.m ... In file included from MAPIStoreContext.m:54: /usr/local/samba/include/mapistore/mapistore.h:57:28: error: mapistore_defs.h: No such file or directory cc1obj: warnings being treated as errors In file included from MAPIStoreContext.m:54: /usr/local/samba/include/mapistore/mapistore.h:127: error: 'enum MAPISTORE_TABLE_TYPE' declared inside parameter list /usr/local/samba/include/mapistore/mapistore.h:127: error: its scope is only this definition or declaration, which is probably not what you want In file included from MAPIStoreContext.m:54: /usr/local/samba/include/mapistore/mapistore.h:136: error: 'enum MAPISTORE_DELETION_TYPE' declared inside parameter list /usr/local/samba/include/mapistore/mapistore.h:155: error: 'enum MAPISTORE_DFLT_FOLDERS' declared inside parameter list /usr/local/samba/include/mapistore/mapistore.h:173: error: 'enum MAPISTORE_DELETION_TYPE' declared inside parameter list /usr/local/samba/include/mapistore/mapistore.h:175: error: 'enum MAPISTORE_DELETION_TYPE' declared inside parameter list MAPIStoreContext.m: In function '-[MAPIStoreContext setURI:andMemCtx:]': MAPIStoreContext.m:270: error: 'MAPISTORE_FAI_TABLE' undeclared (first use in this function) MAPIStoreContext.m:270: error: (Each undeclared identifier is reported only once MAPIStoreContext.m:270: error: for each function it appears in.) MAPIStoreContext.m: In function '-[MAPIStoreContext _tableForFID:andTableType:]': MAPIStoreContext.m:555: error: 'MAPISTORE_MESSAGE_TABLE' undeclared (first use in this function) MAPIStoreContext.m:568: error: 'MAPISTORE_FAI_TABLE' undeclared (first use in this function) MAPIStoreContext.m:581: error: 'MAPISTORE_FOLDER_TABLE' undeclared (first use in this function) MAPIStoreContext.m: In function '-[MAPIStoreContext getTableProperty:withTag:atPosition:withTableType:andQueryType:inFID:]': MAPIStoreContext.m:707: error: 'MAPISTORE_PREFILTERED_QUERY' undeclared (first use in this function) MAPIStoreContext.m:707: error: 'queryType' has an incomplete type MAPIStoreContext.m:725: error: 'queryType' has an incomplete type MAPIStoreContext.m: At top level: cc1obj: error: type '({anonymous})' does not have a known size MAPIStoreContext.m: In function '-[MAPIStoreContext openMessage:forKey:inTable:]': MAPIStoreContext.m:783: error: dereferencing pointer to incomplete type MAPIStoreContext.m:815: error: dereferencing pointer to incomplete type MAPIStoreContext.m: In function '-[MAPIStoreContext openMessage:withMID:inFID:]': MAPIStoreContext.m:834: error: 'MAPISTORE_FAI_TABLE' undeclared (first use in this function) MAPIStoreContext.m:843: error: 'MAPISTORE_MESSAGE_TABLE' undeclared (first use in this function) MAPIStoreContext.m: In function '-[MAPIStoreContext setPropertiesWithFMID:ofTableType:inRow:]': MAPIStoreContext.m:1186: error: 'MAPISTORE_MESSAGE' undeclared (first use in this function) MAPIStoreContext.m:1209: error: 'MAPISTORE_FOLDER' undeclared (first use in this function) MAPIStoreContext.m: In function '-[MAPIStoreContext setProperty:withFMID:ofTableType:fromFile:]': MAPIStoreContext.m:1239: error: 'MAPISTORE_MESSAGE' undeclared (first use in this function) MAPIStoreContext.m:1253: error: 'MAPISTORE_FOLDER' undeclared (first use in this function) MAPIStoreContext.m: In function '-[MAPIStoreContext getProperty:withFMID:ofTableType:intoFile:]': MAPIStoreContext.m:1282: error: 'MAPISTORE_MESSAGE' undeclared (first use in this function) MAPIStoreContext.m:1313: error: 'MAPISTORE_FOLDER' undeclared (first use in this function) MAPIStoreContext.m: In function '-[MAPIStoreContext releaseRecordWithFMID:ofTableType:]': MAPIStoreContext.m:1439: error: 'MAPISTORE_MESSAGE_TABLE' undeclared (first use in this function) MAPIStoreContext.m:1463: error: 'MAPISTORE_FOLDER_TABLE' undeclared (first use in this function) make[2]: *** [obj/MAPIStoreContext.m.o] Error 1 make[1]: *** [internal-bundle-run-compile-submake] Error 2 make: *** [SOGoBackend.all.bundle.variables] Error 2 I am not sure if this is a SOGo or an OpenChange problem, or did I set up something wrong. Has anyone out there successfully installed SOGo with OpenChange ? Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email:mailto:carsten.laun-delel...@delellis.net carsten.delel...@delellis.net From: Carsten Laun-De Lellis [mailto:carsten.delel...@delellis.net] Sent: Monday, January 24, 2011 9:41 PM To: users@sogo.nu Subject: [SOGo] OpenChange Installation Hi
RE: [SOGo] SOGo and openchange installation problem
Hi Francis I did as you told me and added the entries to my .bashrc file and also ran source /usr/share/GNUstep/Makefiles/GNUstep.sh But nothing changed. It still said that the file /usr/local/samba/include/mapistore/mapistore_defs.h is missing. I then copied the file from the .tar file. Now the error message are fewer, but still the following error messages left. This is gnustep-make 2.2.0. Type 'make print-gnustep-make-help' for help. Making all for bundle SOGoBackend... Compiling file MAPIStoreContext.m ... MAPIStoreContext.m: In function '-[MAPIStoreContext setURI:andMemCtx:]': MAPIStoreContext.m:270: error: 'MAPISTORE_FAI_TABLE' undeclared (first use in this function) MAPIStoreContext.m:270: error: (Each undeclared identifier is reported only once MAPIStoreContext.m:270: error: for each function it appears in.) MAPIStoreContext.m: In function '-[MAPIStoreContext _tableForFID:andTableType:]': MAPIStoreContext.m:568: error: 'MAPISTORE_FAI_TABLE' undeclared (first use in this function) MAPIStoreContext.m: In function '-[MAPIStoreContext getTableProperty:withTag:atPosition:withTableType:andQueryType:inFID:]': MAPIStoreContext.m:707: error: 'MAPISTORE_PREFILTERED_QUERY' undeclared (first use in this function) MAPIStoreContext.m:707: error: 'queryType' has an incomplete type MAPIStoreContext.m:725: error: 'queryType' has an incomplete type MAPIStoreContext.m: At top level: cc1obj: error: type '({anonymous})' does not have a known size MAPIStoreContext.m: In function '-[MAPIStoreContext openMessage:withMID:inFID:]': MAPIStoreContext.m:834: error: 'MAPISTORE_FAI_TABLE' undeclared (first use in this function) make[2]: *** [obj/MAPIStoreContext.m.o] Error 1 make[1]: *** [internal-bundle-run-compile-submake] Error 2 make: *** [SOGoBackend.all.bundle.variables] Error 2 Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net -Original Message- From: Francis Lachapelle [mailto:flachape...@inverse.ca] Sent: Tuesday, January 25, 2011 8:21 PM To: SOGo List Subject: Re: [SOGo] SOGo and openchange installation problem Hi On Jan 25, 2011, at 12:41 PM, Carsten Laun-De Lellis wrote: I am still trying to install the OpenChange connector. Though after the hint by Francis I have found the directory OpenChange, but there is no configure file in there. Nor on my server and also not in SOGo's source repository. Has anybody already set up the OpenChange connector and could help me out? You must compile the bundle as you compile SOGo. So you probably forgot to source your GNUstep.sh. You'll also need to set the variable PKG_CONFIG_PATH. You should add something like that to your .bashrc: samba=/usr/local/samba export PATH=${samba}/bin:${samba}/sbin:$PATH export PKG_CONFIG_PATH=${samba}/lib/pkgconfig source /usr/share/GNUstep/Makefiles/GNUstep.sh 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 -- users@sogo.nu https://inverse.ca/sogo/lists
RE: [SOGo] SOGo and openchange installation problem
Hi Francis I did as you told me and added the entries to my .bashrc file and also ran source /usr/share/GNUstep/Makefiles/GNUstep.sh But nothing changed. It still said that the file /usr/local/samba/include/mapistore/mapistore_defs.h is missing. I then copied the file from the .tar file. Now the error message are fewer, but still the following error messages left. This is gnustep-make 2.2.0. Type 'make print-gnustep-make-help' for help. Making all for bundle SOGoBackend... Compiling file MAPIStoreContext.m ... MAPIStoreContext.m: In function '-[MAPIStoreContext setURI:andMemCtx:]': MAPIStoreContext.m:270: error: 'MAPISTORE_FAI_TABLE' undeclared (first use in this function) MAPIStoreContext.m:270: error: (Each undeclared identifier is reported only once MAPIStoreContext.m:270: error: for each function it appears in.) MAPIStoreContext.m: In function '-[MAPIStoreContext _tableForFID:andTableType:]': MAPIStoreContext.m:568: error: 'MAPISTORE_FAI_TABLE' undeclared (first use in this function) MAPIStoreContext.m: In function '-[MAPIStoreContext getTableProperty:withTag:atPosition:withTableType:andQueryType:inFID:]': MAPIStoreContext.m:707: error: 'MAPISTORE_PREFILTERED_QUERY' undeclared (first use in this function) MAPIStoreContext.m:707: error: 'queryType' has an incomplete type MAPIStoreContext.m:725: error: 'queryType' has an incomplete type MAPIStoreContext.m: At top level: cc1obj: error: type '({anonymous})' does not have a known size MAPIStoreContext.m: In function '-[MAPIStoreContext openMessage:withMID:inFID:]': MAPIStoreContext.m:834: error: 'MAPISTORE_FAI_TABLE' undeclared (first use in this function) make[2]: *** [obj/MAPIStoreContext.m.o] Error 1 make[1]: *** [internal-bundle-run-compile-submake] Error 2 make: *** [SOGoBackend.all.bundle.variables] Error 2 Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net mailto:carsten.laun-delel...@delellis.net -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo and openchange installation problem
Hi Ive gone thru the installation process once more and I seem to be a step further. The only error message I actually get is: This is gnustep-make 2.2.0. Type 'make print-gnustep-make-help' for help. Package libmapistore was not found in the pkg-config search path. Perhaps you should add the directory containing `libmapistore.pc' to the PKG_CONFIG_PATH environment variable No package 'libmapistore' found Cannot build the OpenChange SOGo backend (empty CFLAGS for libmapistore) The output of locate libmapistore.pc is /usr/local/samba/lib/pkgconfig/libmapistore.pc And I also have an entry in my .bashrc file: samba=/usr/local/samba export PATH=${samba}/bin:${samba}/sbin:$PATH export PKG_CONFIG_PATH=${samba}/lib/pkgconfig source /usr/share/GNUstep/Makefiles/GNUstep.sh So I dont have any idea where to look at. Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net mailto:carsten.laun-delel...@delellis.net -- users@sogo.nu https://inverse.ca/sogo/lists
RE: [SOGo] SOGo and openchange installation problem
Hi Thankx to Francis. I now found the folder. But when I try to compile the OpenChange connector I always got the following error messages: GNUmakefile:3: ../config.make: No such file or directory GNUmakefile:4: /common.make: No such file or directory GNUmakefile:115: /bundle.make: No such file or directory GNUmakefile:116: /library.make: No such file or directory make: *** No rule to make target `/library.make'. Stop. Any ideas or hints ? Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net -Original Message- From: Francis Lachapelle [mailto:flachape...@inverse.ca] Sent: Friday, January 21, 2011 6:40 PM To: carsten.delel...@delellis.net Cc: users@sogo.nu Subject: Re: [SOGo] SOGo and openchange installation problem Hi Carsten On Jan 20, 2011, at 10:23 AM, Carsten Laun-De Lellis wrote: Everything worked fine and exactly how it is described in the how-tos until it came to the OpenChange SOGo connector. I cant find a directory ~/SOGo/OpenChange. It's part of SOGo's source repository : http://mtn.inverse.ca/branch/head/browse/ca.inverse.sogo/OpenChange 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
[SOGo] OpenChange Installation
Hi Thankx to Francis. I now found the folder. But when I try to compile the OpenChange connector I always got the following error messages: GNUmakefile:3: ../config.make: No such file or directory GNUmakefile:4: /common.make: No such file or directory GNUmakefile:115: /bundle.make: No such file or directory GNUmakefile:116: /library.make: No such file or directory make: *** No rule to make target `/library.make'. Stop. Any ideas or hints ? Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net mailto:carsten.laun-delel...@delellis.net -- users@sogo.nu https://inverse.ca/sogo/lists
RE: [SOGo] SOGo and openchange installation problem
Hi all Thank you for your hints and suggestions. I will try this out the next week and let you know if I have success. Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net -Original Message- From: Francis Lachapelle [mailto:flachape...@inverse.ca] Sent: Friday, January 21, 2011 6:40 PM To: carsten.delel...@delellis.net Cc: users@sogo.nu Subject: Re: [SOGo] SOGo and openchange installation problem Hi Carsten On Jan 20, 2011, at 10:23 AM, Carsten Laun-De Lellis wrote: Everything worked fine and exactly how it is described in the how-tos until it came to the OpenChange SOGo connector. I cant find a directory ~/SOGo/OpenChange. It's part of SOGo's source repository : http://mtn.inverse.ca/branch/head/browse/ca.inverse.sogo/OpenChange 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
[SOGo] Problems with authentication
Hi all I installed sogo new but ran into a problem while logging on to the server: I cannot login because of the following error message: wrong user or password When I look into the log I can see this: Jan 13 17:34:47 sogod [24372]: [ERROR] 0x0x15ea14d0[SOGoUserManager] No authentication sources defined - nobody will be able to login. Check your defaults. Jan 13 17:34:47 sogod [24372]: SOGoRootPage Login for user 'carsten.delellis' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0 127.0.0.1 - - [13/Jan/2011:17:34:47 GMT] POST /SOGo/connect HTTP/1.1 403 34/56 0.070 - - 1M Telling me that no authentication sources defined. But as you can see in my attached GnuStepDefaults File there is a database scheme defined as authentication source. Any ideas ? ?xml version=1.0 encoding=UTF-8? !DOCTYPE plist PUBLIC -//GNUstep//DTD plist 0.9//EN http://www.gnustep.org/plist-0_9.xml; plist version=0.9 dict keyNSGlobalDomain/key dict /dict keysogod/key dict keyOCSFolderInfoURL/key stringmysql://sogouser:sogopassword@localhost:3306/sogo/sogo_user_profile /string keySOGoACLsSendEMailNotifications/key stringYES/string keySOGoAUserSources/key array dict keycanAuthenticate/key stringYES/string keyid/key stringdirectory/string keyisAddressBook/key stringYES/string keytype/key stringsql/string keyuserPasswordAlgorithm/key stringnone/string keyviewURL/key stringmysql://sogouser:sogopassword@localhost:3306/sogo/sogo_mail_auth/st ring /dict /array keySOGoAppointmentSendEMailNotifications/key stringYES/string keySOGoDraftsFolderName/key stringDrafts/string keySOGoEnabledPublicAccess/key stringYES/string keySOGoFoldersSendEMailNotifications/key stringYES/string keySOGoForwardEnabled/key stringYES/string keySOGoIMAPServer/key stringimaps://127.0.0.1:143/?tls=YES/string keySOGoLanguage/key stringGerman/string keySOGoMailAuxiliaryUserAccountEnabled/key stringYES/string keySOGoMailComposeMessageType/key stringhml/string keySOGoMailDomain/key stringdelellis.net/string keySOGoMailUserOutlookStyleReplies/key stringYES/string keySOGoMailingMechanism/key stringsmtp/string keySOGoOtherUsersFolderName/key stringOther Users/string keySOGoPasswordChangeEnabled/key stringYES/string keySOGoSMTPServer/key string127.0.0.1/string keySOGoSentFolderName/key stringSent/string keySOGoSharedFolderName/key stringShared Folders/string keySOGoSieveScriptsEnabled/key stringYES/string keySOGoSieveServer/key stringsieve://127.0.0.1/string keySOGoTimeZone/key stringEurope/Berlin/string keySOGoTrashFolderName/key stringTrash/string keySOGoVacationEnabled/key stringYES/string keyWOUseRelativeURLs/key stringYES/string /dict /dict /plist Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net mailto:carsten.laun-delel...@delellis.net -- users@sogo.nu https://inverse.ca/sogo/lists
RE: [SOGo] Problems with authentication
Hi Basti, hi Ludovic Thank you for your hints. After I wrote the first email I found the misconfiguration myself. But though I fixed it I still receive error messages. In the sogo.log I found the following message: Jan 13 20:54:57 sogod [30626]: [ERROR] 0x0x1044c180[SQLSource] could not run SQL 'SELECT * FROM sogo_mail_auth WHERE c_uid = 'carsten.delellis' OR LOWER(mail) = 'carsten.delellis'': MySQL4Exception: 0x10496460 NAME:ExecutionFailed REASON:Unknown column 'mail' in 'where clause' 127.0.0.1 - - [13/Jan/2011:20:54:57 GMT] GET /SOGo/carsten.delellis HTTP/1.1 404 45/0 0.004 - - 8K My table looks like: mysql desc sogo_mail_auth; ++--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+---+ | c_uid | varchar(255) | NO | PRI | NULL| | | c_password | varchar(255) | NO | | NULL| | | c_name | varchar(255) | YES | | NULL| | | c_cn | varchar(255) | YES | | NULL| | ++--+--+-+-+---+ 4 rows in set (0.00 sec) So I have no idea where this message comes from. I dont have a column mail. Any ideas? Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email:mailto:carsten.laun-delel...@delellis.net carsten.delel...@delellis.net From: Ludovic Marcotte [mailto:lmarco...@inverse.ca] Sent: Thursday, January 13, 2011 6:41 PM To: users@sogo.nu Subject: Re: [SOGo] Problems with authentication On 11-01-13 11:41 AM, Carsten Laun-De Lellis wrote: keySOGoAUserSources/key ^- problem. -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: www.inverse.ca Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Problems with authenticating via mysql
Hi Ludovic I am sorry, but i don't understand what you want to tell me with your email. Is there more detailed information you need to get the problem, or is there something i could do to avoid the error message. I am sorry but efaults write sogod SOGoUserSources ... doesn't tell me anything. Regards, Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net On 14/09/10 5:27 PM, Carsten Laun-De Lellis wrote: Hi folks Did anyone manage to authenticate via MySQL backend. I followed the documentation but gut an error message: defaults write SOGoUserSources defaults write sogod SOGoUserSources ... -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Problems with authenticating via mysql
Hi Martin I am so sorry. I was blind. Thankx Regards, Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net Hi, your wrote: defaults write SOGoUserSources It has to be: defaults write sogod SOGoUserSources Greetings, Martin Am 15.09.2010 10:12, schrieb Carsten Laun-De Lellis: Hi Ludovic I am sorry, but i don't understand what you want to tell me with your email. Is there more detailed information you need to get the problem, or is there something i could do to avoid the error message. I am sorry but efaults write sogod SOGoUserSources ... doesn't tell me anything. Regards, Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net On 14/09/10 5:27 PM, Carsten Laun-De Lellis wrote: Hi folks Did anyone manage to authenticate via MySQL backend. I followed the documentation but gut an error message: defaults write SOGoUserSources defaults write sogod SOGoUserSources ... -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Problems with authenticating against mysql
Hi all After typing in the right command i got another error message: defaults write sogod SOGoUserSources '({type = sql;id = directory;viewURL = mysql://mail:m...@localhost:3306/mail/sogo_view;canAuthenticate = YES;isAddressBook = YES;userPasswordAlgorithm = none;})' 2010-09-15 10:57:09.652 defaults[10740] Creating empty user defaults database 2010-09-15 10:57:09.687 defaults[10740] File NSData.m: 1576. In -[NSData writeToFile:options:error:] Unable to correctly set all attributes for '/home/sogo/GNUstep/Defaults/.GNUstepDefaults' I don't know where i have the mistake. I have created a database mail and a view with all identifiers mentioned in the documentation (c_uid, c_user, mail,...) and added some information to the database. I created a user mail with all rights on the database. There are two questions i don't understand: - Does sogo write into the database - What excactly does id mean I would appreciate any help. Regards, Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Problems with authenticating against mysql
Hi Martin Thank you very much. The id=database, does the trick. Yes the passwords are stored in plain text. I don't see any advantage in storing them in md5 format. Access is only allowed from local machine. From my point of view it is much more important to secure the access either via web or directly via any sort of client. But again. Thank you very much for your help. Regards, Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net Hi, are the passwords plain in the database? = userPasswordAlgorithm = none (??) Here is a SOGoUserSources I use: defaults write sogod SOGoUserSources '({id=database; isAddressBook = YES; canAuthenticate=NO; displayName = Globale Adressen; type=sql; userPasswordAlgorithm = md5; viewURL = mysql://$DB_SOGO_PWD:$db_sogo_u...@localhost:3306/$DATABASE_SOGO_AUTH/sogo_auth\;})' Should run - runs last week ... ;-) Greetings, Martin Am 15.09.2010 11:05, schrieb Carsten Laun-De Lellis: Hi all After typing in the right command i got another error message: defaults write sogod SOGoUserSources '({type = sql;id = directory;viewURL = mysql://mail:m...@localhost:3306/mail/sogo_view;canAuthenticate = YES;isAddressBook = YES;userPasswordAlgorithm = none;})' 2010-09-15 10:57:09.652 defaults[10740] Creating empty user defaults database 2010-09-15 10:57:09.687 defaults[10740] File NSData.m: 1576. In -[NSData writeToFile:options:error:] Unable to correctly set all attributes for '/home/sogo/GNUstep/Defaults/.GNUstepDefaults' I don't know where i have the mistake. I have created a database mail and a view with all identifiers mentioned in the documentation (c_uid, c_user, mail,...) and added some information to the database. I created a user mail with all rights on the database. There are two questions i don't understand: - Does sogo write into the database - What excactly does id mean I would appreciate any help. Regards, Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] MISMATCH: different db ..
Hi all I am using now sql Auth, as you can read in my earlier questions. I can log on, with no problem, but when i try to add a new contact, nothing happens and i have the following entries in my log file. Sep 15 12:55:57 sogod: SOGo watchdog [18693]: 0x0xaff5100[GCSChannelHandle] MISMATCH: different db .. 127.0.0.1 - - [15/Sep/2010:12:55:57 GMT] GET /SOGo/so/carsten.delel...@delellis.lan/Contacts/new_list?popup=YES HTTP/1.1 404 208/0 0.016 - - 0 I have searched former threads and i found something similiar. In one post Ludovic mentioned to just ignore the message, but i can't add any addressbook entries. When i checked out the tables on the mysql server i found the following entries in sogo_folder_info: see attachement: But when i check the referenced tables: sogocarstend00159681f74 for example. These tables are empty. Any suggestions ? Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net folder_list.pdf Description: Adobe PDF document -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Problems with authenticating via mysql
Hi folks Did anyone manage to authenticate via MySQL backend. I followed the documentation but gut an error message: defaults write SOGoUserSources '({type = sql;id = directory;viewURL = mysql://mail:m...@localhost:3306/mail/sogo_view;canAuthenticate = YES;isAddressBook = YES;userPasswordAlgorithm = none;})' 2010-09-14 23:18:18.450 defaults[22753] File NSDictionary.m: 628. In -[NSDictionary initWithContentsOfFile:] Contents of file '/home/sogo/GNUstep/Defaults/.GNUstepDefaults' does not contain a dictionary defaults write: domain is not a dictionary! I have no idea what is wrong with my syntax. The view i am referring to sogo_view looks like: select concat(`virtual_users`.`user`,'@',`virtual_domains`.`name`) AS `c_uid`,concat(`virtual_users`.`user`,'@',`virtual_domains`.`name`) AS `c_name`,`virtual_users`.`password` AS `c_password`,concat(`virtual_users`.`sn`,' ',`virtual_users`.`givenName`) AS `c_cn`,concat(`virtual_users`.`user`,'@',`virtual_domains`.`name`) AS `mail`,`virtual_users`.`department` AS `department`,`virtual_users`.`pphone` AS `telephoneNumber` from (`virtual_users` left join `virtual_domains` on((`virtual_users`.`domain_id` = `virtual_domains`.`id`))) Any ideas ? -- Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Problems with Funambol installation
Hi all I am trying to install Funambol but got the following error message after running the install-modules command. r...@w07:/opt/Funambol# ./bin/install-modules [echo] Funambol Data Synchronization Server will be installed on the Tomcat 6.0.x application server [echo] install.modules basedir /opt/Funambol/ds-server [echo] Pre installation for modules content-provider-8.7.0,email-connector-8.7.0,foundation-8.7.0,phones-support-8.7.0,webdemo-8.7.0 funambol-sogo-1.0.8 [echo] install.modules basedir /opt/Funambol/ds-server [echo] content-provider-8.7.0 pre-installation... [echo] content-provider-8.7.0 pre-installation successfully completed [echo] install.modules basedir /opt/Funambol/ds-server [echo] email-connector-8.7.0 pre-installation... [echo] email-connector-8.7.0 pre-installation successfully completed [echo] install.modules basedir /opt/Funambol/ds-server [echo] foundation-8.7.0 pre-installation... [echo] foundation-8.7.0 pre-installation successfully completed [echo] install.modules basedir /opt/Funambol/ds-server [echo] phones-support-8.7.0 pre-installation... [echo] phones-support-8.7.0 pre-installation successfully completed [echo] install.modules basedir /opt/Funambol/ds-server [echo] webdemo-8.7.0 funambol-sogo-1.0.8 pre-installation... BUILD FAILED /opt/Funambol/ds-server/install/install.xml:197: The following error occurred while executing this line: /opt/Funambol/ds-server/install/install-modules.xml:106: The following error occurred while executing this line: /opt/Funambol/ds-server/install/install-modules.xml:131: Error while expanding /opt/Funambol/ds-server/modules/webdemo-8.7.0 funambol-sogo-1.0.8.s4j Total time: 2 seconds I am following the SOGo Installation document from the website. I would appreciate any help. Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Can't login into webinterface
Hi all Thank you very much for your support, but i managed to login. Again thank you all for your hints. Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net Hi all I still have problems logging into the webinterface: Whenever i try to login i got an error message wrong user or password: The sogo log file shows: 2010-09-09 00:45:09.256 sogod[18905] Scanner initialised with nil string Sep 09 00:45:09 sogod: SOGo watchdog [18905]: SOGoRootPage Login for user 'sogo' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0 127.0.0.1 - - [09/Sep/2010:00:45:09 GMT] POST /SOGo/connect HTTP/1.1 403 34/38 0.008 - - 0 I tried to logon to the ldap server via phpldapadmin using the user sogo credential and it worked. I set passwordPolicy NO in my GNUstepDefaults. Has anyone an idea, what's wrong ? If it is helpful i can also post the complete GNUstepDefaults file. Regards, Carsten Laun-De Lellis -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Display of all users in the addressbook
Hi all After i managed to log into SOGo i do have question regarding the display of the users from the ldap addressbook. In my .GNUstepDefaults i use ldap for user informations. array dict keyCNFieldName/key stringcn/string keyIDFieldName/key stringuid/string keyIMAPHostFieldName/key stringmailHost/string keyUIDFieldName/key stringuid/string keybaseDN/key stringou=users,dc=delellis,dc=lan/string keybindDN/key stringcn=manager,dc=delellis,dc=lan/string keybindPassword/key stringsandra22/string keycanAuthenticate/key stringYES/string keydisplayName/key stringlt;Unternehmensadressbuchgt;/string keyhostname/key stringlocalhost/string keyid/key stringpublic/string keyisAddressBook/key stringYES/string keyport/key string389/string /dict /array When i am in the webinterface using the ldap addressbook for user search it works fine. Whenever i start typing in the user name it displays all possibilities. But i wander if it possible to display all users when accessing the ldap addressbook and to scroll up and down and select users by clicking on them? I would appreciate any help. Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Problems with Funambol installation
Hi Dominique After i put in the komma everything worked fine. I didn't ran into any more problems. Just for your information. I am running SOGo on my laptop for test purposes. It is an ubuntu-10.04 x86 installation. I followed the Documentation on the website http://www.sogo.nu/file/docs/SOGo%20Installation%20Guide.pdf After your help everyting went well. I am now trying to configure funambol to connect to my iphone. Wish you luck. Maybe it is interresting for you which modules i used: collections-current.tar.gz commons-configuration-current.tar.gz commons-lang-current.tar.gz commons-logging-current-bin.tar.gz funambol-8.7.0.bin funambol-sogo-1.0.8.s4j json_simple-1.1.jar postgresql-8.4-702.jdbc4.jar Maybe this will help you a little bit. Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net I am stuck just a step ahead of you... but it seems that you did not seperate the webdemo module from the funambol-sogo module by a comma in the install properties file. Once you pass that step, let me know if it accepts top continue. In my case it say: BUILD FAILED /usr/lib/Funambol/ds-server/install/install.xml:197: The following error occurred while executing this line: /usr/lib/Funambol/ds-server/install/install-modules.xml:101: The following error occurred while executing this line: /usr/lib/Funambol/ds-server/install/install-modules.xml:126: Error while expanding /usr/lib/Funambol/ds-server/modules/funambolsogo-.s4j Obviously because there is no funambolsogo-.s4j module. In /modules the file is called funambol-sogo-1.0.8.s4j... Any idea how to go through that one ? Dominique On 09/09/2010 11:35, Carsten Laun-De Lellis wrote: Hi all I am trying to install Funambol but got the following error message after running the install-modules command. r...@w07:/opt/Funambol# ./bin/install-modules [echo] Funambol Data Synchronization Server will be installed on the Tomcat 6.0.x application server [echo] install.modules basedir /opt/Funambol/ds-server [echo] Pre installation for modules content-provider-8.7.0,email-connector-8.7.0,foundation-8.7.0,phones-support-8.7.0,webdemo-8.7.0 funambol-sogo-1.0.8 [echo] install.modules basedir /opt/Funambol/ds-server [echo] content-provider-8.7.0 pre-installation... [echo] content-provider-8.7.0 pre-installation successfully completed [echo] install.modules basedir /opt/Funambol/ds-server [echo] email-connector-8.7.0 pre-installation... [echo] email-connector-8.7.0 pre-installation successfully completed [echo] install.modules basedir /opt/Funambol/ds-server [echo] foundation-8.7.0 pre-installation... [echo] foundation-8.7.0 pre-installation successfully completed [echo] install.modules basedir /opt/Funambol/ds-server [echo] phones-support-8.7.0 pre-installation... [echo] phones-support-8.7.0 pre-installation successfully completed [echo] install.modules basedir /opt/Funambol/ds-server [echo] webdemo-8.7.0 funambol-sogo-1.0.8 pre-installation... BUILD FAILED /opt/Funambol/ds-server/install/install.xml:197: The following error occurred while executing this line: /opt/Funambol/ds-server/install/install-modules.xml:106: The following error occurred while executing this line: /opt/Funambol/ds-server/install/install-modules.xml:131: Error while expanding /opt/Funambol/ds-server/modules/webdemo-8.7.0 funambol-sogo-1.0.8.s4j Total time: 2 seconds I am following the SOGo Installation document from the website. I would appreciate any help. Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] EOAdaptor: cannot find adaptor bundle: 'PostgreSQL'
Hi all I have tried to install SOGo on an ubuntu 10.04 system. Whenever i try to connect to the webinterface SOGo hung up and i got an error message. In the sogo log file i can find the following entries: ep 08 12:27:09 sogod: SOGo watchdog [5559]: [WARN] 0x0x94ce3f8[WOWatchDog] 'WOHttpAllowHost' is ignored in watchdog mode, use a real firewall instead Sep 08 12:27:09 sogod: SOGo watchdog [5559]: 0x0x94ce3f8[WOWatchDog] listening on *:2 Sep 08 12:27:09 sogod: SOGo watchdog [5559]: 0x0x94ce3f8[WOWatchDog] watchdog process pid: 5559 Sep 08 12:27:09 sogod: SOGo watchdog [5559]: 0x0x94ce3f8[WOWatchDog] preparing 1 children Sep 08 12:27:09 sogod: SOGo watchdog [5559]: 0x0x94ce3f8[WOWatchDog] child spawned with pid 5561 Sep 08 12:27:09 sogod: SOGo watchdog [5561]: SNS support disabled. Sep 08 12:27:10 sogod: SOGo watchdog [5561]: 0x0x9938b98[SOGoProductLoader] SOGo products loaded from '/usr/lib/GNUstep/SOGo': Sep 08 12:27:10 sogod: SOGo watchdog [5561]: 0x0x9938b98[SOGoProductLoader] MailPartViewers.SOGo, CommonUI.SOGo, MainUI.SOGo, PreferencesUI.SOGo, SchedulerUI.SOGo, MailerUI.SOGo, ContactsUI.SOGo, Appointments.SOGo, AdministrationUI.SOGo, Contacts.SOGo, Mailer.SOGo Sep 08 12:27:11 sogod: SOGo watchdog [5561]: |SOGo| version 1.3.0 (build @vizzini.inverse.ca 201008191918) -- starting Sep 08 12:27:11 sogod: SOGo watchdog [5561]: |SOGo| vmem size check enabled: shutting down app when vmem 384 MB 2010-09-08 12:27:11.292 sogod[5561] EOAdaptor: cannot find adaptor bundle: 'PostgreSQL' Sep 08 12:27:11 sogod: SOGo watchdog [5561]: [ERROR] 0x0x94ce3f8[WOWatchDog] an exception occured in runloop NSException: 0xab64cd0 NAME:NSInvalidArgumentException REASON:Tried to add nil value for key 'localhost:5432:sogo:sogo' to dictionary INFO:{} Sep 08 12:27:11 sogod: SOGo watchdog [5559]: 0x0x94e9a88[WOWatchDogChild] child 5561 exited Sep 08 12:27:11 sogod: SOGo watchdog [5559]: 0x0x94e9a88[WOWatchDogChild] avoiding to respawn child before 2010-09-08 12:27:14 +0200 Has anyone an idea what went wrong and how to fix the bug ? I would appreciate any help. Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Problems logging on to SOGo webinterface
Dear all After i had luckily managed to access the webinterface with support from this list i ran into another problem. To be honest i am not a LDAP guru, not an expirienced user at all. When i try to log on to the web interface i got an error message. object not found: SOGo = cdelellis When i check the sogo log i got the following error message: Sep 08 14:20:59 sogod: SOGo watchdog [15855]: SOGoRootPage Login for user 'uid=cdelellis,ou=users,dc=delellis,dc=delellis' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0 127.0.0.1 - - [08/Sep/2010:14:20:59 GMT] POST /SOGo/connect HTTP/1.1 403 34/101 0.009 - - 0 2010-09-08 14:21:10.807 sogod[15855] Scanner initialised with nil string Sep 08 14:21:10 sogod: SOGo watchdog [15855]: SOGoRootPage Login for user 'uid=cdelellis,ou=users,dc=delellis,dc=delellis' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0 127.0.0.1 - - [08/Sep/2010:14:21:10 GMT] POST /SOGo/connect HTTP/1.1 403 34/101 0.009 - - 0 2010-09-08 14:22:11.107 sogod[15855] Scanner initialised with nil string Sep 08 14:22:11 sogod: SOGo watchdog [15855]: SOGoRootPage Login for user 'uid=cdelellis,ou=users,dc=delellis,dc=delellis' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0 127.0.0.1 - - [08/Sep/2010:14:22:11 GMT] POST /SOGo/connect HTTP/1.1 403 34/101 0.008 - - 0 Sep 08 14:22:21 sogod: SOGo watchdog [15855]: SOGoRootPage successful login for user 'cdelellis' - expire = -1 grace = -1 2010-09-08 14:22:21.023 sogod[15855] Could not bind to the LDAP server localhost (389) using the bind DN: uid=sogo,ou=users,dc=delellis,dc=lan 127.0.0.1 - - [08/Sep/2010:14:22:21 GMT] POST /SOGo/connect HTTP/1.1 200 27/62 0.012 - - 0 2010-09-08 14:22:21.033 sogod[15855] Could not bind to the LDAP server localhost (389) using the bind DN: uid=sogo,ou=users,dc=delellis,dc=lan 2010-09-08 14:22:21.034 sogod[15855] Could not bind to the LDAP server localhost (389) using the bind DN: uid=sogo,ou=users,dc=delellis,dc=lan 2010-09-08 14:22:21.036 sogod[15855] Could not bind to the LDAP server localhost (389) using the bind DN: uid=sogo,ou=users,dc=delellis,dc=lan 127.0.0.1 - - [08/Sep/2010:14:22:21 GMT] GET /SOGo/cdelellis HTTP/1.1 404 38/0 0.006 - - 0 But when i run the following command: ldapsearch -xLLL -b dc=delellis,dc=lan uid=cdelellis sn givenName cn i got this result: dn: uid=cdelellis,ou=users,dc=delellis,dc=lan cn: Carsten Laun-De Lellis sn: Laun-De Lellis givenName: Carsten And when i ran ldapsearch -xLLL -b dc=delellis,dc=lan uid=sogo sn givenName cn i got: dn: uid=sogo,ou=users,dc=delellis,dc=lan cn: SOGo Administrator sn: Administrator givenName: SOGo So has anyone an idea where to look at. I would appreciate any help and hints. Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Problems logging on to SOGo webinterface
Hi Jeremy Again. Thank you for your suggestions. Maybe someone else knows what to do ? Regards, Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net You are welcome Carsten. And, yes, you are right it is strange that SOGo is looking in that location considering your configuration. That is something I cannot answer, sorry. On 8-Sep-10, at 10:23 PM, Carsten Laun-De Lellis wrote: Thank you very much for your response Jeremy. But before i give it a try there are some basics i want to understand. In the log file i find the following entry: 'uid=cdelellis,ou=users,dc=delellis,dc=delellis' might not have I have no idea why SOGo makes a lookup to dc=delellis,dc=delellis. From my understanding it has to be dc=delellis,dc=lan, becaus in my .GNUstepDefaults the line looks like keyCNFieldName/key stringcn/string keyIDFieldName/key stringuid/string keyIMAPHostFieldName/key stringmailHost/string keyUIDFieldName/key stringuid/string keybaseDN/key stringou=users,dc=delellis,dc=lan/string keybindDN/key stringuid=sogo,ou=users,dc=delellis,dc=lan/string keybindPassword/key stringsogo/string keycanAuthenticate/key stringYES/string keydisplayName/key stringlt;the human identification name of the address bookgt;/string Am i wrong ? Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: carsten.delel...@delellis.net Carsten, Try changing the ou=users to ou=Users. I believe it is case sensitive! ;-) Jeremy On 8-Sep-10, at 9:51 PM, Carsten Laun-De Lellis wrote: Dear all After i had luckily managed to access the webinterface with support from this list i ran into another problem. To be honest i am not a LDAP guru, not an expirienced user at all. When i try to log on to the web interface i got an error message. object not found: SOGo = cdelellis When i check the sogo log i got the following error message: Sep 08 14:20:59 sogod: SOGo watchdog [15855]: SOGoRootPage Login for user 'uid=cdelellis,ou=users,dc=delellis,dc=delellis' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0 127.0.0.1 - - [08/Sep/2010:14:20:59 GMT] POST /SOGo/connect HTTP/ 1.1 403 34/101 0.009 - - 0 2010-09-08 14:21:10.807 sogod[15855] Scanner initialised with nil string Sep 08 14:21:10 sogod: SOGo watchdog [15855]: SOGoRootPage Login for user 'uid=cdelellis,ou=users,dc=delellis,dc=delellis' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0 127.0.0.1 - - [08/Sep/2010:14:21:10 GMT] POST /SOGo/connect HTTP/ 1.1 403 34/101 0.009 - - 0 2010-09-08 14:22:11.107 sogod[15855] Scanner initialised with nil string Sep 08 14:22:11 sogod: SOGo watchdog [15855]: SOGoRootPage Login for user 'uid=cdelellis,ou=users,dc=delellis,dc=delellis' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0 127.0.0.1 - - [08/Sep/2010:14:22:11 GMT] POST /SOGo/connect HTTP/ 1.1 403 34/101 0.008 - - 0 Sep 08 14:22:21 sogod: SOGo watchdog [15855]: SOGoRootPage successful login for user 'cdelellis' - expire = -1 grace = -1 2010-09-08 14:22:21.023 sogod[15855] Could not bind to the LDAP server localhost (389) using the bind DN: uid=sogo,ou=users,dc=delellis,dc=lan 127.0.0.1 - - [08/Sep/2010:14:22:21 GMT] POST /SOGo/connect HTTP/ 1.1 200 27/62 0.012 - - 0 2010-09-08 14:22:21.033 sogod[15855] Could not bind to the LDAP server localhost (389) using the bind DN: uid=sogo,ou=users,dc=delellis,dc=lan 2010-09-08 14:22:21.034 sogod[15855] Could not bind to the LDAP server localhost (389) using the bind DN: uid=sogo,ou=users,dc=delellis,dc=lan 2010-09-08 14:22:21.036 sogod[15855] Could not bind to the LDAP server localhost (389) using the bind DN: uid=sogo,ou=users,dc=delellis,dc=lan 127.0.0.1 - - [08/Sep/2010:14:22:21 GMT] GET /SOGo/cdelellis HTTP/ 1.1 404 38/0 0.006 - - 0 But when i run the following command: ldapsearch -xLLL -b dc=delellis,dc=lan uid=cdelellis sn givenName cn i got this result: dn: uid=cdelellis,ou=users,dc=delellis,dc=lan cn: Carsten Laun-De Lellis sn: Laun-De Lellis givenName: Carsten And when i ran ldapsearch -xLLL -b dc=delellis,dc=lan uid=sogo sn givenName cn i got: dn: uid=sogo,ou=users,dc=delellis,dc=lan cn: SOGo Administrator sn: Administrator givenName: SOGo So has anyone an idea where to look at. I would appreciate any help and hints. Mit freundlichem
[SOGo] Can't login into webinterface
Hi all I still have problems logging into the webinterface: Whenever i try to login i got an error message wrong user or password: The sogo log file shows: 2010-09-09 00:45:09.256 sogod[18905] Scanner initialised with nil string Sep 09 00:45:09 sogod: SOGo watchdog [18905]: SOGoRootPage Login for user 'sogo' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0 127.0.0.1 - - [09/Sep/2010:00:45:09 GMT] POST /SOGo/connect HTTP/1.1 403 34/38 0.008 - - 0 I tried to logon to the ldap server via phpldapadmin using the user sogo credential and it worked. I set passwordPolicy NO in my GNUstepDefaults. Has anyone an idea, what's wrong ? If it is helpful i can also post the complete GNUstepDefaults file. Regards, Carsten Laun-De Lellis -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] OpenGroupware and opensuse
HI all Does anyone from this list have experience with installing opengroupware on opensuse 11.2 ? If so I would appreciate any hint, manual or tutorial on how to do that. I don't want to make to many mistakes in setting sogo up. Regards, Carsten -- users@sogo.nu https://inverse.ca/sogo/lists