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
[SOGo] select multiple emails in internet explorer
Hi all, We are on 2.0.5a, and noticed that in internet explorer (8) we cannot select multiple emails in the web access. (using ctrl-click, or shift-click both don't work) Is anyone else seeing this, or is it just us..? MJ -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo, Openchange and Outlook
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 Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org) -- 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
Re: [SOGo] Training
On 2013-06-26 7:54 AM, Wayland Sothcott wrote: Back in the 90's there was a fantastic thing called Lotus Notes which was the ultimate groupware. There are no open standards to let you create one in Linux. Whare are the IMAP and SMTP protocols for address books and calendars? They are called CardDAV and CalDAV. -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Training
On 26.06.2013 13:54, Wayland Sothcott wrote: On 26/06/2013 06:35, Steven Swarts wrote: G'day guys I've been following SOGo for awhile now, used the ZEG and played with the tutorial that Oliver has kindly made available. My question is I have access to a vast amount of small businesses that I currently support and would love to support in the area of an Exchange alternative. But my reluctance is that I don't understand SOGo, OpenChange, Dovecot, Samba4, Sope, etc. I was wondering if anyone knew or could tell me where I could get training in this area. Currently I have a basic understanding of Linux, but I'm looking for a cutting edge education. The local education places only support Samba3 which annoys me to no end. So in a nutshell, if I were to do some courses (online preferably) what is the recommendation? Also I just want to say brilliant venture, I love Linux so keep up the great work. Hello Steven, I have been following SOGo for several months now and played with the ZEG and tried to add SOGo to a Debian server. I think there is a long way to go with this before I can use it and I don't think it's a matter of training. I have used ClearOS 5.2 successfully for small businesses. With it's web interface it's very easy to get it to do all the things it's capable of such as file sharing, email and hosting the companies website. (I can't say the same about ClearOS 6) The 'Internet' defines lots of things for us, like how websites work, how email works and how DNS works. What it does not define is how address books work. All I want is a simple centralised database of email addresses that is shared by all email users in the company. Back in the 90's there was a fantastic thing called Lotus Notes which was the ultimate groupware. There are no open standards to let you create one in Linux. Whare are the IMAP and SMTP protocols for address books and calendars? CardDAV and CalDAV. Coinincidentally, what SOGo uses. And Apple. And KDE. And Gnome. And… about everyone, sans Google (who want to push their own services – thankfully, there are decent clients for Android) and Microsoft (surprise!). I have no idea why people would create standards such as IMAP yet not carry on and create standards for address books. Unless it's so that Microsoft Exchange has no competitor in the Open Source area. Regards, Wayland. (Someone please correct me if I am wrong) -- Mit freundlichen Grüßen, / Best Regards, Sven SCHWEDAS Systemadministrator TAO Beratungs- und Management GmbH | Lendplatz 45 | A - 8020 Graz Mail/XMPP: sven.schwe...@tao.at | +43 (0)680 301 7167 http://software.tao.at signature.asc Description: OpenPGP digital signature
Re: [SOGo] Problem with outlook and ZEG - Need help please!
On 24/06/2013 13:39, raymond wrote: I am sitting watching the demonstration video of sogo on youtube and giving a big sigh!! Wondering how the hell did they get it to work. Must I purchase a support pack, yes or no. mmm NO if the demo doesn't work, I can just imagine how the support is going to work. Yes I know the ZEG does works but I am yet to experience a working demo with outlook as shown in the video on youtube. Phew, now that I had the opportunity to blow off steam I would like to apologise to the Sogo team. If you do have a working product then great stuff, just a pity you have not found a way to share it with people like me. Man I am so irritable at the moment I can shout it from the roof tops no reflection on Sogo... just me wanting something and not getting it... I am just tossing out my toys, banging my head against the wall and shouting at ants... And all because I can't figure out where I am going wrong with the outlook setup. Oh, look there is another ant... Good bye. Hello Raymond, I sympathise with you but also with the SOGo team. There is an obvious hole in what you can do with a Linux server. It's not necessarily that it does not act as an Exchange server but that the functionality of an email server beyond simply sending and receiving emails using Internet standards is missing. Microsoft protocols are usually very complicated, The SAMBA team have done fantastically well to make it work like Microsoft NT Server. The SOGo team are trying to do this for Exchange. What should happen is a set of open standards should be written. These would define how the client and the server talk to each other to handle address book data and calendar data. The server could then store it's data in whatever database suits it. This might be the companies own database or one which came with the service. The client could be an ipad or MS Outlook or Thunderbird. Whatever, no matter since this standard would be added to the client just like IMAP or POP is currently. Trying to reverse engineer a Microsoft product is a bit sad. It's all reflected glory. Open Office is like this. I could go on... Regards, Wayland. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] So disappointed !!
On 22/06/2013 13:59, Raymond wrote: I am so disappointed !! Just can't get outlook to stay connected to openchange - I don't think it is a Sogo problem, the (ZEG) is not producing any workable solution. Seems like this project needs a lot of work still. Now I need to look at the costs of a Microsoft Exchange Server.. L not happy. Ray That LDAP thing makes you think that there is a standard for groupware but there is not :-( LDAP is a total pain. Far too difficult to use unless you are a genius, but then I would create something better if I was. I am sure there is a reason why the ZEG is not issued as an ISO. It's so you can't make a real server unless you go through the full pain. I did actually turn it into an ISO using a tool but it lost the GUI in the process. From: Ludovic Marcotte [mailto:lmarco...@inverse.ca] Sent: 22 June 2013 14:37 To: users@sogo.nu Subject: Re: [SOGo] Unknown HTTPS issue On 2013-06-22 8:28 AM, Steve Ankeny wrote: Nothing in http.conf Your SOGo Apache configuration. -- Mobile: 07925 431381 Office: 01787 388165 -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGo MySQL Authentication
Helloz, I am almost bald trying to get authentication using mysql working. The difficult part is how to tell what SOGo is exactly doing (debugging) so that I can fix it. I have in my sogo.conf: /* MySQL Authentication */ SOGoUserSources = ( { type = sql; canAuthenticate = YES; displayName = Staff Members; id = users; isAddressBook = YES; userPasswordAlgorithm = md5; viewURL =mysql:// exim4u:XXX@127.0.0.1:3306/exim4u/sogo_auth_view; } ); And I created a view on my DB as follows: CREATE VIEW sogo_auth_view AS SELECT user_id AS sogo_id, username AS c_uid, realname AS c_name, clear AS c_password, username AS c_cn, use rname AS mail, realname AS displayName FROM users WHERE enabled='1'; Which gives me: mysql select * from exim4u.sogo_auth_view where c_name like '%wash%'; +-+-+-++-+-+-+ | sogo_id | c_uid | c_name | c_password | c_cn | mail| displayName | +-+-+-++-+-+-+ | 3 | w...@kictanet.or.ke | Odhiambo WASHINGTON | secret1| w...@kictanet.or.ke | w...@kictanet.or.ke | Odhiambo WASHINGTON | +-+-+-++-+-+-+ I am trying to login using username=w...@kictanet.or.ke and password=whateveritis but I always get failure... wrong username or password. On sogo.log, I see no clue whatsoever: root@gw:/usr/local/etc/sogo # tail -f /var/log/sogo/sogo.log Jun 26 14:51:24 sogod [94532]: 0x0x23bdedc4[WOWatchDog] child spawned with pid 94533 Jun 26 15:40:53 sogod [5681]: version 2.0.6a (build r...@gw.kictanet.or.ke201306252307) -- starting Jun 26 15:40:53 sogod [5681]: vmem size check enabled: shutting down app when vmem 384 MB Jun 26 15:40:53 sogod [5681]: 0x0x23c01ee4[SOGoProductLoader] SOGo products loaded from '/usr/local/GNUstep/Local/Library/SOGo': Jun 26 15:40:53 sogod [5681]: 0x0x23c01ee4[SOGoProductLoader] Appointments.SOGo, Contacts.SOGo, Mailer.SOGo, CommonUI.SOGo, ContactsUI.SOGo, MailerUI.SOGo, MailPartViewers.SOGo, MainUI.SOGo, PreferencesUI.SOGo, SchedulerUI.SOGo, AdministrationUI.SOGo Jun 26 15:40:53 sogod [5681]: 0x0x23bdedc4[WOWatchDog] listening on *:2 Jun 26 15:40:53 sogod [5681]: 0x0x23bdedc4[WOWatchDog] watchdog process pid: 5681 Jun 26 15:40:53 sogod [5681]: 0x0x21464020[WOWatchDogChild] watchdog request timeout set to 10 minutes Jun 26 15:40:53 sogod [5681]: 0x0x23bdedc4[WOWatchDog] preparing 1 children Jun 26 15:40:53 sogod [5681]: 0x0x23bdedc4[WOWatchDog] child spawned with pid 5682 2013-06-26 15:41:06.186 sogod[5682] Note: Using UTF-8 as URL encoding in NGExtensions. Jun 26 15:41:06 sogod [5682]: |SOGo| starting method 'POST' on uri '/SOGo/connect' Jun 26 15:41:06 sogod [5682]: 0x0x23c58e54[SOGoCache] Cache cleanup interval set every 300.00 seconds Jun 26 15:41:06 sogod [5682]: 0x0x23c58e54[SOGoCache] Using host(s) 'localhost' as server(s) Jun 26 15:41:10 sogod [5682]: |SOGo| lookup name: SOGo 2013-06-26 15:41:10.189 sogod[5682] Note(SoObject): SoDebugKeyLookup is enabled! 2013-06-26 15:41:10.189 sogod[5682] Note(SoObject): SoDebugBaseURL is enabled! 2013-06-26 15:41:10.190 sogod[5682] Note(SoObject): relative base URLs are enabled. Jun 26 15:41:10 sogod [5682]: |SOGo| did not find key 'SOGo' in SoClass: 0x0x23c07504[SoObjCClass]: super=0x0x23c07184 objc=SOGo slots=connect ,GET,view,casProxy,index,saml2-signon-post,changePassword,saml2-metadata,loading,toolbar Jun 26 15:41:10 sogod [5682]: |SOGo| looked up value: (null) Jun 26 15:41:10 sogod [5682]: |SOGo| lookup in root object: (null) Jun 26 15:41:10 sogod [5682]: |SOGo| GOT: (null) Jun 26 15:41:10 sogod [5682]: |SOGo| matched appname: SOGo Jun 26 15:41:10 sogod [5682]: |SOGo| = rewrote value: SOGo[0x0x23a6aba4]: name=SOGo Jun 26 15:41:10 sogod [5682]: |SOGo| lookup name: connect 2013-06-26 15:41:10.194 sogod[5682] ERROR(-[NGBundleManager bundleWithPath:]): could not create bundle for path: '/usr/local/GNUstep/System/Libra ry/Libraries/gnustep-base/Versions/1.24/Resources/SSL.bundle' 2013-06-26 15:41:10.202 sogod[5682] WOCompoundElement: pool embedding is on. 2013-06-26 15:41:10.203 sogod[5682] WOCompoundElement: id logging is on. Jun 26 15:41:10 sogod [5682]: |SOGo| looked up value: 0x0x23c968c4[SoPageInvocation]: class=SOGoRootPage action=connect bound instantiated pro duct=0x0x23c67dc4[SoProduct]: loaded code-loaded bundle=/usr/local/GNUstep/Local/Library/SOGo/MainUI.SOGo #classes=8 #categories=4 rm=0x0x23c770 a4 Jun 26 15:41:10 sogod [5682]: |SOGo| GOT: 0x0x23c968c4[SoPageInvocation]: class=SOGoRootPage action=connect bound instantiated product=0x0x23 c67dc4[SoProduct]: loaded code-loaded
[SOGo] Re: SOGo MySQL Authentication - SOLVED
Hello, I have changed userPasswordAlgorithm = md5; to userPasswordAlgorithm = none; and I was able to login! On 26 June 2013 15:46, Odhiambo Washington odhia...@gmail.com wrote: Helloz, I am almost bald trying to get authentication using mysql working. The difficult part is how to tell what SOGo is exactly doing (debugging) so that I can fix it. I have in my sogo.conf: /* MySQL Authentication */ SOGoUserSources = ( { type = sql; canAuthenticate = YES; displayName = Staff Members; id = users; isAddressBook = YES; userPasswordAlgorithm = md5; viewURL =mysql:// exim4u:XXX@127.0.0.1:3306/exim4u/sogo_auth_view; } ); And I created a view on my DB as follows: CREATE VIEW sogo_auth_view AS SELECT user_id AS sogo_id, username AS c_uid, realname AS c_name, clear AS c_password, username AS c_cn, use rname AS mail, realname AS displayName FROM users WHERE enabled='1'; Which gives me: mysql select * from exim4u.sogo_auth_view where c_name like '%wash%'; +-+-+-++-+-+-+ | sogo_id | c_uid | c_name | c_password | c_cn | mail| displayName | +-+-+-++-+-+-+ | 3 | w...@kictanet.or.ke | Odhiambo WASHINGTON | secret1| w...@kictanet.or.ke | w...@kictanet.or.ke | Odhiambo WASHINGTON | +-+-+-++-+-+-+ I am trying to login using username=w...@kictanet.or.ke and password=whateveritis but I always get failure... wrong username or password. On sogo.log, I see no clue whatsoever: root@gw:/usr/local/etc/sogo # tail -f /var/log/sogo/sogo.log Jun 26 14:51:24 sogod [94532]: 0x0x23bdedc4[WOWatchDog] child spawned with pid 94533 Jun 26 15:40:53 sogod [5681]: version 2.0.6a (build r...@gw.kictanet.or.ke201306252307) -- starting Jun 26 15:40:53 sogod [5681]: vmem size check enabled: shutting down app when vmem 384 MB Jun 26 15:40:53 sogod [5681]: 0x0x23c01ee4[SOGoProductLoader] SOGo products loaded from '/usr/local/GNUstep/Local/Library/SOGo': Jun 26 15:40:53 sogod [5681]: 0x0x23c01ee4[SOGoProductLoader] Appointments.SOGo, Contacts.SOGo, Mailer.SOGo, CommonUI.SOGo, ContactsUI.SOGo, MailerUI.SOGo, MailPartViewers.SOGo, MainUI.SOGo, PreferencesUI.SOGo, SchedulerUI.SOGo, AdministrationUI.SOGo Jun 26 15:40:53 sogod [5681]: 0x0x23bdedc4[WOWatchDog] listening on *:2 Jun 26 15:40:53 sogod [5681]: 0x0x23bdedc4[WOWatchDog] watchdog process pid: 5681 Jun 26 15:40:53 sogod [5681]: 0x0x21464020[WOWatchDogChild] watchdog request timeout set to 10 minutes Jun 26 15:40:53 sogod [5681]: 0x0x23bdedc4[WOWatchDog] preparing 1 children Jun 26 15:40:53 sogod [5681]: 0x0x23bdedc4[WOWatchDog] child spawned with pid 5682 2013-06-26 15:41:06.186 sogod[5682] Note: Using UTF-8 as URL encoding in NGExtensions. Jun 26 15:41:06 sogod [5682]: |SOGo| starting method 'POST' on uri '/SOGo/connect' Jun 26 15:41:06 sogod [5682]: 0x0x23c58e54[SOGoCache] Cache cleanup interval set every 300.00 seconds Jun 26 15:41:06 sogod [5682]: 0x0x23c58e54[SOGoCache] Using host(s) 'localhost' as server(s) Jun 26 15:41:10 sogod [5682]: |SOGo| lookup name: SOGo 2013-06-26 15:41:10.189 sogod[5682] Note(SoObject): SoDebugKeyLookup is enabled! 2013-06-26 15:41:10.189 sogod[5682] Note(SoObject): SoDebugBaseURL is enabled! 2013-06-26 15:41:10.190 sogod[5682] Note(SoObject): relative base URLs are enabled. Jun 26 15:41:10 sogod [5682]: |SOGo| did not find key 'SOGo' in SoClass: 0x0x23c07504[SoObjCClass]: super=0x0x23c07184 objc=SOGo slots=connect ,GET,view,casProxy,index,saml2-signon-post,changePassword,saml2-metadata,loading,toolbar Jun 26 15:41:10 sogod [5682]: |SOGo| looked up value: (null) Jun 26 15:41:10 sogod [5682]: |SOGo| lookup in root object: (null) Jun 26 15:41:10 sogod [5682]: |SOGo| GOT: (null) Jun 26 15:41:10 sogod [5682]: |SOGo| matched appname: SOGo Jun 26 15:41:10 sogod [5682]: |SOGo| = rewrote value: SOGo[0x0x23a6aba4]: name=SOGo Jun 26 15:41:10 sogod [5682]: |SOGo| lookup name: connect 2013-06-26 15:41:10.194 sogod[5682] ERROR(-[NGBundleManager bundleWithPath:]): could not create bundle for path: '/usr/local/GNUstep/System/Libra ry/Libraries/gnustep-base/Versions/1.24/Resources/SSL.bundle' 2013-06-26 15:41:10.202 sogod[5682] WOCompoundElement: pool embedding is on. 2013-06-26 15:41:10.203 sogod[5682] WOCompoundElement: id logging is on. Jun 26 15:41:10 sogod [5682]: |SOGo| looked up value: 0x0x23c968c4[SoPageInvocation]: class=SOGoRootPage action=connect bound instantiated pro duct=0x0x23c67dc4[SoProduct]: loaded code-loaded
[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
Re: [SOGo] Problem with outlook and ZEG - Need help please!
If it were not for the desire and in some cases the actual need for Outlook, then reverse engineering would not be necessary. As an alternative, if there were another client that would allow for connection to Sharepoint calendars and would also allow for the use of existing third party Outlook plugins, then we could use that. If you do not need Outlook, then the web interface or Thunderbird (with its plugins) is enough. Of course, working with Thunderbird and its issues requires some reverse engineering as well - or at least patience. On 06/26/2013 07:35 AM, Wayland Sothcott wrote: Hello Raymond, I sympathise with you but also with the SOGo team. There is an obvious hole in what you can do with a Linux server. It's not necessarily that it does not act as an Exchange server but that the functionality of an email server beyond simply sending and receiving emails using Internet standards is missing. Microsoft protocols are usually very complicated, The SAMBA team have done fantastically well to make it work like Microsoft NT Server. The SOGo team are trying to do this for Exchange. What should happen is a set of open standards should be written. These would define how the client and the server talk to each other to handle address book data and calendar data. The server could then store it's data in whatever database suits it. This might be the companies own database or one which came with the service. The client could be an ipad or MS Outlook or Thunderbird. Whatever, no matter since this standard would be added to the client just like IMAP or POP is currently. Trying to reverse engineer a Microsoft product is a bit sad. It's all reflected glory. Open Office is like this. I could go on... Regards, Wayland. Privileged, Proprietary and/or Confidential Information may be contained in this electronic message. If you are not the intended recipient, you should not copy it, re-transmit it, use it or disclose its contents, but should kindly return to the sender immediately and delete your copy from your system. Gulf Interstate Engineering Company does not accept responsibility for changes made to this electronic message or its attachments. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Re: SOGo MySQL Authentication - SOLVED
On 06/26/13 15:32, Odhiambo Washington wrote: Hello, I have changed userPasswordAlgorithm = md5; to userPasswordAlgorithm = none; and I was able to login! This is because you have cleartext passwords in your database, you should crypt your passwords before saving into MySQL. Cheers Giovanni -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Migration
On 06/19/13 15:15, Benito Chamberlain wrote: Hi there We want to migrate MS exchange server to Sogo . What is the best way to go about this ,? My knowledge of MS Exchange is limited , as I don't work with Microsoft . Our goal is to migrate as quickly and painlessly as possible , with the minimum down time. I recently migrate from Exchange/Outlook to SOGo/Thunderbird and I used the following software to migrate data: - offlineimap for mail folders - outlook2ical (http://outlook2ical.sourceforge.net/) for calendars - a macro (http://www.outlook-answers.com/microsoft/Outlook/36234758/esportare-rubrica-outlook-2003-in-vcf.aspx) to export contacts in vcf format, then I was able to import the vcf in SOGo web gui The Exchange server was a backend server so I was able to migrate one account (I have few) at a time with little downtime. Cheers Giovanni -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] select multiple emails in internet explorer
works fine with 2.0.6 and IE 10 Not sure how it worked under IE 8 or 2.0.5a but I believe it worked correctly. On 06/26/2013 05:15 AM, mourik jan heupink wrote: Hi all, We are on 2.0.5a, and noticed that in internet explorer (8) we cannot select multiple emails in the web access. (using ctrl-click, or shift-click both don't work) Is anyone else seeing this, or is it just us..? MJ -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] select multiple emails in internet explorer
On 06/26/13 17:01, Steve Ankeny wrote: works fine with 2.0.6 and IE 10 Not sure how it worked under IE 8 or 2.0.5a but I believe it worked correctly. with IE8 and 2.0.6 (from sogo.nu) the bug is present. Giovanni -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Problem with outlook and ZEG - Need help please!
On 26/06/2013 14:41, raymond wrote: Hi Wayland, thank you for your reply. I don't know if you will get this email, I have been kicked off the list by Ludovic Marcotte for my last comments. I am sure that the Sogo team is working hard and I really hope they crack the whip on MS Exchange server. We need people like the Sogo team. What frustrated me a bit was the fact that the Zeg is advertised on the site as a zero config test environment to see the product in action. The Sogo web GUI worked fine and the sending test mail with the interface worked fine but there was just no way Outlook stayed connected for me to see the results of using a native connection to outlook. I google'd the problem with Outlook and found some people who had the same issues but with no reply on how to resolve it, this is why I got a bit mad after discovering one post where someone commented on a user problem and one of the team suggested that they purchase a support pack. This is where I snapped and got the idea that the Zeg was not working and to get it to work you had to purchase support. Anyway I had another discussion and it just may be Windows 8 with outlook 2007 that is not tested with the Zeg and it could be a bug. Outlook has all the SP's 1-3 installed, firewall turned off, hosts set in windows etc etc... as per the docs but no luck to get outlook connected. If you don't use the exchange setup in outlook and you use the account (auto detect) option then the IMAP server is detected on the Zeg. By doing this you don't have Calendar synchronization, only mail items as you would expect from an IMAP server. One Sogo member on the list assured me that the Zeg works with outlook. So now I am in the process of testing WindowsXP with Outlook (2003 and 2007) and then will move onto Windows 7 with Outlook (2007) I addition I will be starting from scratch to configure CentOS 6.4 with Samba 4 and to see if I can get OpenChange running. Better to start from the bottom up. Regards, Ray Hello Ray, Indeed your message did not reach the group but my reply will. I messed around with ZEG for quite a while and even managed to make an installable ISO so I could run it on hardware. I don't know if the ZEG is up to date with the current SOGo but I had disconnection problems and very slow response. I tried Outlook XP and Outlook 7 on XP and Windows 7. It was obvious to me that this was not ready for my customers as I could not handle the frustration myself. I love Open Source software but it's a mystery to me what is motivating the developers. Is someone paying them? Do they thrive on people complaining about bugs? Are they planning on selling the whole thing to Oracle? Here's what I do. There are loads of small businesses with two or three computers and they struggle to share work without a server. I get a decent old computer and make a server using Linux. It acts as file storage and email server. It bugs me that they can't all use the same address book. Also these days people are using their smartphones for email. It's easy enough to get the smartphone to use the server for email but again no address book. The calendar function would be great. This market is dominated by Microsoft in the medium sized businesses and Google in the small businesses. I don't think it's good if people keep all their stuff with companies hooked into PRISM. One bloke died and another is on the run so that we could be told this blindingly obvious bit of info:- the worlds governments have all our emails and data. Regards, Wayland. -Original Message- From: Wayland Sothcott [mailto:wayl...@sothcott.co.uk] Sent: 26 June 2013 02:36 PM To: users@sogo.nu Cc: raym...@joburgtheatre.com Subject: Re: [SOGo] Problem with outlook and ZEG - Need help please! On 24/06/2013 13:39, raymond wrote: I am sitting watching the demonstration video of sogo on youtube and giving a big sigh!! Wondering how the hell did they get it to work. Must I purchase a support pack, yes or no. mmm NO if the demo doesn't work, I can just imagine how the support is going to work. Yes I know the ZEG does works but I am yet to experience a working demo with outlook as shown in the video on youtube. Phew, now that I had the opportunity to blow off steam I would like to apologise to the Sogo team. If you do have a working product then great stuff, just a pity you have not found a way to share it with people like me. Man I am so irritable at the moment I can shout it from the roof tops no reflection on Sogo... just me wanting something and not getting it... I am just tossing out my toys, banging my head against the wall and shouting at ants... And all because I can't figure out where I am going wrong with the outlook setup. Oh, look there is another ant... Good bye. Hello Raymond, I sympathise with you but also with the SOGo team. There is an obvious hole in what you can do with a Linux server. It's not necessarily
[SOGo] Mail module not functional
Hi folks, first: I'm new here. Thanks for the great work on SOGo. Here is my problem, may be somebody can help: I compiled SOPE 2.0.6 and SOGo 2.0.6a on OpenSUSE 12.2 32-bit. GNUstep is from OpenSUSE repository http://download.opensuse.org/repositories/X11:/GNUstep/openSUSE_12.2 Everything looks good, I can start the service, I can login but if I change to Mail tab, I get the error in browser: An error occurred during object publishing the requested object could not be found! At this time I get a 404 return code in the logfile. Here ist SOGo logfile (there is something about could not load product: Mail...: Jun 26 16:01:39 sogod [26693]: version 2.0.6a (build root@samba-server.axora 201306261505) -- starting Jun 26 16:01:39 sogod [26693]: vmem size check enabled: shutting down app when vmem 384 MB Jun 26 16:01:39 sogod [26693]: 0x0xb885ef74[SOGoProductLoader] SOGo products loaded from '/usr/lib/GNUstep/SOGo': Jun 26 16:01:39 sogod [26693]: 0x0xb885ef74[SOGoProductLoader] AdministrationUI.SOGo, Appointments.SOGo, CommonUI.SOGo, Contacts.SOGo, ContactsUI.SOGo, MailPartViewers.SOGo, Mailer.SOGo, MailerUI.SOGo, MainU I.SOGo, PreferencesUI.SOGo, SchedulerUI.SOGo Jun 26 16:01:39 sogod [26693]: [so-product-registry] could not load product: MailPartViewers Jun 26 16:01:39 sogod [26693]: [so-product-registry] could not load product: MailerUI Jun 26 16:01:39 sogod [26693]: 0x0xb88662c4[WOWatchDog] listening on *:2 Jun 26 16:01:39 sogod [26693]: 0x0xb88662c4[WOWatchDog] watchdog process pid: 26693 Jun 26 16:01:39 sogod [26693]: 0x0xb74aad20[WOWatchDogChild] watchdog request timeout set to 10 minutes Jun 26 16:01:39 sogod [26693]: 0x0xb88662c4[WOWatchDog] preparing 1 children Jun 26 16:01:39 sogod [26693]: 0x0xb88662c4[WOWatchDog] child spawned with pid 26694 Jun 26 16:02:15 sogod [26694]: 0x0xb892b5dc[SOGoCache] Cache cleanup interval set every 300.00 seconds Jun 26 16:02:15 sogod [26694]: 0x0xb892b5dc[SOGoCache] Using host(s) 'localhost' as server(s) 2013-06-26 16:02:15.601 sogod[26694] Note(SoObject): SoDebugKeyLookup is enabled! 2013-06-26 16:02:15.601 sogod[26694] Note(SoObject): SoDebugBaseURL is enabled! 2013-06-26 16:02:15.601 sogod[26694] Note(SoObject): relative base URLs are enabled. Jun 26 16:02:15 sogod [26694]: SOGoRootPage successful login from '10.8.0.30' for user 'igor' - expire = -1 grace = -1 Jun 26 16:02:15 sogod [26694]: [ERROR] 0x0xb8b7458c[NGLdapAttribute] cound not convert value of objectSid to string Jun 26 16:02:15 sogod [26694]: [ERROR] 0x0xb8b744bc[NGLdapAttribute] cound not convert value of objectGUID to string Jun 26 16:02:15 sogod [26694]: [WARN] 0x0xb8b86acc[SOGoWebDAVAclManager] entry '{DAV:}write' already exists in DAV permissions table Jun 26 16:02:15 sogod [26694]: [WARN] 0x0xb8b86acc[SOGoWebDAVAclManager] entry '{DAV:}write-properties' already exists in DAV permissions table Jun 26 16:02:15 sogod [26694]: [WARN] 0x0xb8b86acc[SOGoWebDAVAclManager] entry '{DAV:}write-content' already exists in DAV permissions table 2013-06-26 16:02:15.741 sogod[26694] Note: Using UTF-8 as URL encoding in NGExtensions. 10.8.0.30 - - [26/Jun/2013:16:02:15 GMT] POST /SOGo/connect HTTP/1.1 200 27/38 0.147 - - 3M 10.8.0.30 - - [26/Jun/2013:16:02:15 GMT] GET /SOGo/so/igor HTTP/1.1 302 0/0 0.004 - - 8K 10.8.0.30 - - [26/Jun/2013:16:02:15 GMT] GET /SOGo/so/igor/view HTTP/1.1 302 0/0 0.004 - - 8K 10.8.0.30 - - [26/Jun/2013:16:02:15 GMT] GET /SOGo/so/Igor/Calendar HTTP/1.1 302 0/0 0.005 - - 0 10.8.0.30 - - [26/Jun/2013:16:02:16 GMT] GET /SOGo/so/Igor/Calendar/view HTTP/1.1 200 13112/0 0.084 47891 72% 1M 10.8.0.30 - - [26/Jun/2013:16:02:16 GMT] POST /SOGo/so/Igor/Calendar/personal/canAccessContent HTTP/1.1 204 0/0 0.012 - - 0 10.8.0.30 - - [26/Jun/2013:16:02:16 GMT] POST /SOGo/so/Igor/Calendar/alarmslist?browserTime=1372255335 HTTP/1.1 200 2/0 0.006 - - 0 10.8.0.30 - - [26/Jun/2013:16:02:16 GMT] POST /SOGo/so/Igor/Calendar/eventslist?asc=truesort=startday=filterpopup=view_today HTTP/1.1 200 2/0 0.009 - - 0 10.8.0.30 - - [26/Jun/2013:16:02:16 GMT] POST /SOGo/so/Igor/Calendar/taskslist?show-completed=0asc=truesort=end HTTP/1.1 200 2/0 0.005 - - 0 10.8.0.30 - - [26/Jun/2013:16:02:16 GMT] POST /SOGo/so/Igor/Calendar/weekview HTTP/1.1 200 2185/0 0.017 22433 90% 12K 10.8.0.30 - - [26/Jun/2013:16:02:16 GMT] POST /SOGo/so/Igor/Calendar/eventsblocks?sd=20130624ed=20130630view=weekview HTTP/1.1 200 64/0 0.005 - - 0 10.8.0.30 - - [26/Jun/2013:16:02:18 GMT] GET /SOGo/so/Igor/Mail HTTP/1.1 302 0/0 0.003 - - 0 Jun 26 16:02:18 sogod [26694]: [ERROR] 0x0xb8b6b94c[NGLdapAttribute] cound not convert value of objectSid to string Jun 26 16:02:18 sogod [26694]: [ERROR] 0x0xb8b0100c[NGLdapAttribute] cound not convert value of objectGUID to string 10.8.0.30 - - [26/Jun/2013:16:02:18 GMT] GET /SOGo/so/Igor/Mail/view HTTP/1.1 404 208/0 0.011 - - 0 10.8.0.30 - - [26/Jun/2013:16:02:19 GMT] POST /SOGo/so/Igor/Calendar/personal/canAccessContent HTTP/1.1 204 0/0 0.003 - - 0 10.8.0.30 - - [26/Jun/2013:16:02:19 GMT] POST
Re: [SOGo] select multiple emails in internet explorer
IE 8 had Enhanced Security settings, which we've removed from our Windows 2008R2 Server for other reasons (such as displaying remote application content - i.e., links to other apps within an accounting app) I'd suggest looking at removing that in IE 8 and standardizing the security options (admins to users) On 06/26/2013 11:07 AM, Giovanni Bechis wrote: On 06/26/13 17:01, Steve Ankeny wrote: works fine with 2.0.6 and IE 10 Not sure how it worked under IE 8 or 2.0.5a but I believe it worked correctly. with IE8 and 2.0.6 (from sogo.nu) the bug is present. Giovanni -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Problem with outlook and ZEG - Need help please!
On 26/06/2013 14:42, Miles Lott wrote: If it were not for the desire and in some cases the actual need for Outlook, then reverse engineering would not be necessary. As an alternative, if there were another client that would allow for connection to Sharepoint calendars and would also allow for the use of existing third party Outlook plugins, then we could use that. If you do not need Outlook, then the web interface or Thunderbird (with its plugins) is enough. Of course, working with Thunderbird and its issues requires some reverse engineering as well - or at least patience. It sounds like I am coming at the problem backwards. Outlook is a popular and competent email client but if I found another one my customers would use that. There used to be a little address book and calendar that looked like a filofax, it was fantastic and could even share it's file over the network so several people could use it. This was discontinued rather than developed further. I rather feel that the lack of a simple solution to this common and simple problem is deliberate. Novel Netware was very reliable but the corporation I worked for migrated away from this to TCP/IP which I did not understand at the time. The same corporation moved away from Lotus Notes to Microsoft Exchange and I have never understood. I am becoming convinced that the way to solve this problem is to ignore the existing 'solutions' such as any Thunderbird plugins or MS Exchange or LDAP and create a very simple protocol. Then people can create the plugins for the email clients and the web interface and the backend server database interface etc to their hearts content. No one has to try and pretend to be MS Exchange. On 06/26/2013 07:35 AM, Wayland Sothcott wrote: Hello Raymond, I sympathise with you but also with the SOGo team. There is an obvious hole in what you can do with a Linux server. It's not necessarily that it does not act as an Exchange server but that the functionality of an email server beyond simply sending and receiving emails using Internet standards is missing. Microsoft protocols are usually very complicated, The SAMBA team have done fantastically well to make it work like Microsoft NT Server. The SOGo team are trying to do this for Exchange. What should happen is a set of open standards should be written. These would define how the client and the server talk to each other to handle address book data and calendar data. The server could then store it's data in whatever database suits it. This might be the companies own database or one which came with the service. The client could be an ipad or MS Outlook or Thunderbird. Whatever, no matter since this standard would be added to the client just like IMAP or POP is currently. Trying to reverse engineer a Microsoft product is a bit sad. It's all reflected glory. Open Office is like this. I could go on... Regards, Wayland. Privileged, Proprietary and/or Confidential Information may be contained in this electronic message. If you are not the intended recipient, you should not copy it, re-transmit it, use it or disclose its contents, but should kindly return to the sender immediately and delete your copy from your system. Gulf Interstate Engineering Company does not accept responsibility for changes made to this electronic message or its attachments. -- Mobile: 07925 431381 Office: 01787 388165 -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] This page cant be displayed
Thanks for the quick reply. I fixed the bindDn to where I no longer get the Invalid credentials error, but in my sogo.log file it still says:192.1.1.237 - - [26/Jun/2013:01:26:13 GMT] GET /SOGo/ HTTP/1.1 302 0/0 0.164 - - 5M192.1.1.237 - - [26/Jun/2013:01:26:13 GMT] GET /SOGo/user HTTP/1.1 302 0/0 0.003 - - 40K192.1.1.237 - - [26/Jun/2013:01:26:13 GMT] GET /SOGo/user/view HTTP/1.1 302 0/0 0.004 - - 16KBut my screen says This page cant be displayed.Looking through the rest of my logs their is no evident reason the only thing I can think of is something with Postgesql.--Terry L. Welchterry.welch@hmatpa.comHMA, LLC.1600 W. Broadway Rd, Suite 300Tempe, -AZ 85282ph: 480-800-7470< br />480-214-4645NOTICE OF CONFIDENTIALITY: This message and any attachments contain confidential information belonging to the sender intended only for the use of the individual or entity named above. If you are not the intended recipient, be advised that copying, disclosure or reliance upon the contents is strictly prohibited. If you have received this message in error please notify the sender immediately and destroy this message. Original Message Subject: Re: [SOGo] This page cant be displayedDate: Tuesday, June 25, 2013 07:02 PM MSTFrom: Ludovic Marcotte lmarco...@inverse.caReply-To: users@sogo.nuOrganization: Inverse inc.To: users@sogo.nuReferences: 50ea-51ca1300-27d-76ba6f00@7167953On 2013-06-25 6:01 PM, Terry Welch wrote: My maillo g says the same. I believe this to be a postgresql issue but do not know enough postgres to figure this out on my own Ive done alot of googleing but have had no luck.Its a LDAP issue - Jun 25 08:00:33 sogod [14879]:0x0x7fc1044d0b98[LDAPSource] NAME:LDAPException REASON:operation bind failed: Invalid credentials(0x31) INFO:{login = uid=user,ou=others,dc=domain,dc=com; }Check your bindDn.--Ludovic Marcottelmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.caInverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org)--users@sogo.nuhttps://inverse.ca/sogo/lists
Re: [SOGo] Problem with outlook and ZEG - Need help please!
On 26.06.2013 17:28, Wayland Sothcott wrote: On 26/06/2013 14:42, Miles Lott wrote: If it were not for the desire and in some cases the actual need for Outlook, then reverse engineering would not be necessary. As an alternative, if there were another client that would allow for connection to Sharepoint calendars and would also allow for the use of existing third party Outlook plugins, then we could use that. If you do not need Outlook, then the web interface or Thunderbird (with its plugins) is enough. Of course, working with Thunderbird and its issues requires some reverse engineering as well - or at least patience. It sounds like I am coming at the problem backwards. Outlook is a popular and competent email client but if I found another one my customers would use that. There used to be a little address book and calendar that looked like a filofax, it was fantastic and could even share it's file over the network so several people could use it. This was discontinued rather than developed further. I rather feel that the lack of a simple solution to this common and simple problem is deliberate. Novel Netware was very reliable but the corporation I worked for migrated away from this to TCP/IP which I did not understand at the time. The same corporation moved away from Lotus Notes to Microsoft Exchange and I have never understood. I am becoming convinced that the way to solve this problem is to ignore the existing 'solutions' such as any Thunderbird plugins or MS Exchange or LDAP and create a very simple protocol. Why are you constantly repeating yourself all over the mailing list? As mentioned, oh, a dozen times, those simple protocols already /exist/. Namely Card- and CalDAV. The Thunderbird plugins (or Android apps) just add those sync protocols to the existing calendar/address book; Apple iCal and Contacts.app, for example, can already be used natively. The Exchange Bloatware is only necessary because there is no decent way to integrate Outlook into a sane setup. Sogo uses LDAP (or Samba) because it aims at companies actually big enough to require them, there are more lightweight address book/calendar sync solutions building on Cal/CardDAV that can be used without a central domain (Owncloud and Davical, if I'm not mistaken). Again, with the same client infrastructure as the SOGo Server – SOGo Connector for Thunderbird, iCal/Contacts.app, Cal/CardDAVSync (Android), … Then people can create the plugins for the email clients and the web interface and the backend server database interface etc to their hearts content. They already do. No one has to try and pretend to be MS Exchange. Outlook is the sole exception. Sadly, it's a rather huge and (for many) important one. On 06/26/2013 07:35 AM, Wayland Sothcott wrote: Hello Raymond, I sympathise with you but also with the SOGo team. There is an obvious hole in what you can do with a Linux server. It's not necessarily that it does not act as an Exchange server but that the functionality of an email server beyond simply sending and receiving emails using Internet standards is missing. Microsoft protocols are usually very complicated, The SAMBA team have done fantastically well to make it work like Microsoft NT Server. The SOGo team are trying to do this for Exchange. What should happen is a set of open standards should be written. These would define how the client and the server talk to each other to handle address book data and calendar data. The server could then store it's data in whatever database suits it. This might be the companies own database or one which came with the service. The client could be an ipad or MS Outlook or Thunderbird. Whatever, no matter since this standard would be added to the client just like IMAP or POP is currently. Trying to reverse engineer a Microsoft product is a bit sad. It's all reflected glory. Open Office is like this. I could go on... Regards, Wayland. Privileged, Proprietary and/or Confidential Information may be contained in this electronic message. If you are not the intended recipient, you should not copy it, re-transmit it, use it or disclose its contents, but should kindly return to the sender immediately and delete your copy from your system. Gulf Interstate Engineering Company does not accept responsibility for changes made to this electronic message or its attachments. -- Mit freundlichen Grüßen, / Best Regards, Sven SCHWEDAS Systemadministrator TAO Beratungs- und Management GmbH | Lendplatz 45 | A - 8020 Graz Mail/XMPP: sven.schwe...@tao.at | +43 (0)680 301 7167 http://software.tao.at signature.asc Description: OpenPGP digital signature
Re: [SOGo] Re: SOGo MySQL Authentication - SOLVED
Well when I change that to md5-crypt, with matching password, it doesn't work. Why so? Either of these two don't work! userPasswordAlgorithm = md5; userPasswordAlgorithm = md5-crypt; My VIEW looks like this: mysql select * from exim4u.sogo_auth_view where c_name like '%wash%'; +-+-+-++-+-+- + | sogo_id | c_uid | c_name | c_password | c_cn| mail| displayN ame | +-+-+-++-+-+- + | 3 | w...@kictanet.or.ke | Odhiambo WASHINGTON | $1$OFb7e/vf$/FL/Q4T0LXFwaklRUzN7v. | w...@kictanet.or.ke | w...@kictanet.or.ke | Odhiambo WASHINGTON | +-+-+-++-+-+- + On 26 June 2013 17:44, Giovanni Bechis giova...@bigio.snb.it wrote: On 06/26/13 15:32, Odhiambo Washington wrote: Hello, I have changed userPasswordAlgorithm = md5; to userPasswordAlgorithm = none; and I was able to login! This is because you have cleartext passwords in your database, you should crypt your passwords before saving into MySQL. Cheers Giovanni -- users@sogo.nu https://inverse.ca/sogo/lists -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] This page cant be displayed
If I type the url in like this user authenticates into SOGo other then IMAP dovecot is having an issue but I will fix that later.http://mail1.domain.com/SOGo/so/user/Mail/viewIf I simply type the url in like this:http://mail1.domain.com/SOGothe I get the message This page cant be displayedAny ideas of where to fix this so that the bottom option url works?--Terry L. Welchterry.welch@hmatpa.comHMA, LLC.1600 W. Broadway Rd, Suite 300Tempe, -AZ 85282ph: 480-800-7470480-214-4645NOTICE OF CONFIDENTIALITY: This message and any attachments contain confidential information belonging to the sender intended on ly for the use of the individual or entity named above. If you are not the intended recipient, be advised that copying, disclosure or reliance upon the contents is strictly prohibited. If you have received this message in error please notify the sender immediately and destroy this message. Original Message Subject: Re: [SOGo] This page cant be displayedDate: Tuesday, June 25, 2013 07:02 PM MSTFrom: Ludovic Marcotte lmarco...@inverse.caReply-To: users@sogo.nuOrganization: Inverse inc.To: users@sogo.nuReferences: 50ea-51ca1300-27d-76ba6f00@7167953On 2013-06-25 6:01 PM, Terry Welch wrote: My maillo g says the same. I believe this to be a postgresql issue but do not know enough postgres to figure this out on my own Ive done alot of googleing but have had no luck.
Its a LDAP issue - Jun 25 08:00:33 sogod [14879]:0x0x7fc1044d0b98[LDAPSource] NAME:LDAPException REASON:operation bind failed: Invalid credentials(0x31) INFO:{login = uid=user,ou=others,dc=domain,dc=com; }Check your bindDn.--Ludovic Marcottelmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.caInverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org)--users@sogo.nuhttps://inverse.ca/sogo/lists
Re: [SOGo] Training
Quoting Wayland Sothcott wayl...@sothcott.co.uk On 26/06/2013 06:35, Steven Swarts wrote: G'day guys I've been following SOGo for awhile now, used the ZEG and played with the tutorial that Oliver has kindly made available. My question is I have access to a vast amount of small businesses that I currently support and would love to support in the area of an Exchange alternative. But my reluctance is that I don't understand SOGo, OpenChange, Dovecot, Samba4, Sope, etc. I was wondering if anyone knew or could tell me where I could get training in this area. Currently I have a basic understanding of Linux, but I'm looking for a cutting edge education. The local education places only support Samba3 which annoys me to no end. So in a nutshell, if I were to do some courses (online preferably) what is the recommendation? Also I just want to say brilliant venture, I love Linux so keep up the great work. Hello Steven, I have been following SOGo for several months now and played with the ZEG and tried to add SOGo to a Debian server. I think there is a long way to go with this before I can use it and I don't think it's a matter of training. I have used ClearOS 5.2 successfully for small businesses. With it's web interface it's very easy to get it to do all the things it's capable of such as file sharing, email and hosting the companies website. (I can't say the same about ClearOS 6) The 'Internet' defines lots of things for us, like how websites work, how email works and how DNS works. What it does not define is how address books work. All I want is a simple centralised database of email addresses that is shared by all email users in the company. Back in the 90's there was a fantastic thing called Lotus Notes which was the ultimate groupware. There are no open standards to let you create one in Linux. Whare are the IMAP and SMTP protocols for address books and calendars? I have no idea why people would create standards such as IMAP yet not carry on and create standards for address books. Unless it's so that Microsoft Exchange has no competitor in the Open Source area. Regards, Wayland. (Someone please correct me if I am wrong) -- Mobile: 07925 431381 Office: 01787 388165 -- users@sogo.nu https://inverse.ca/sogo/lists Well currently i use Horde Webmail groupware. It supports CalDav and CardDav plus active sync capabilities with iOS and Android up to AS 14.1 But SOGo and the native Outlook support is a winner in my books, plus coupled with Samba 4 and goodbye Microsoft in a couple of years I would say. The trick I'm sure is to know how to set it up, but most importantly how to keep it running. Anyway I hoping that someone has an answer for my original question. Regards, Steven Swarts Swarts IT Wayland Sothcott wayl...@sothcott.co.uk wrote: -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Disable Resource Event Creation
All, We have a couple conference rooms that are under construction and need to prevent event creation, but do not want to delete them from LDAP etc. Tried setting Authenticated and Public ACL's to None acrost the board but users can still create events with the resource. Is this setup possible without deleting the resource? -Ron -- users@sogo.nu https://inverse.ca/sogo/lists
RE: [SOGo] Migration
Thanks for your help! Date: Wed, 26 Jun 2013 16:54:32 +0200 From: giova...@bigio.snb.it To: users@sogo.nu Subject: Re: [SOGo] Migration On 06/19/13 15:15, Benito Chamberlain wrote: Hi there We want to migrate MS exchange server to Sogo . What is the best way to go about this ,? My knowledge of MS Exchange is limited , as I don't work with Microsoft . Our goal is to migrate as quickly and painlessly as possible , with the minimum down time. I recently migrate from Exchange/Outlook to SOGo/Thunderbird and I used the following software to migrate data: - offlineimap for mail folders - outlook2ical (http://outlook2ical.sourceforge.net/) for calendars - a macro (http://www.outlook-answers.com/microsoft/Outlook/36234758/esportare-rubrica-outlook-2003-in-vcf.aspx) to export contacts in vcf format, then I was able to import the vcf in SOGo web gui The Exchange server was a backend server so I was able to migrate one account (I have few) at a time with little downtime. Cheers Giovanni -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Mail module not functional
On 26/06/13 16:20, Igor wrote: Hi folks, first: I'm new here. Thanks for the great work on SOGo. Here is my problem, may be somebody can help: I compiled SOPE 2.0.6 and SOGo 2.0.6a on OpenSUSE 12.2 32-bit. GNUstep is from OpenSUSE repository http://download.opensuse.org/repositories/X11:/GNUstep/openSUSE_12.2 Everything looks good, I can start the service, I can login but if I change to Mail tab, I get the error in browser: An error occurred during object publishing the requested object could not be found! At this time I get a 404 return code in the logfile. Here ist SOGo logfile (there is something about could not load product: Mail...: Jun 26 16:01:39 sogod [26693]: version 2.0.6a (build root@samba-server.axora 201306261505) -- starting Jun 26 16:01:39 sogod [26693]: vmem size check enabled: shutting down app when vmem 384 MB Jun 26 16:01:39 sogod [26693]: 0x0xb885ef74[SOGoProductLoader] SOGo products loaded from '/usr/lib/GNUstep/SOGo': Jun 26 16:01:39 sogod [26693]: 0x0xb885ef74[SOGoProductLoader] AdministrationUI.SOGo, Appointments.SOGo, CommonUI.SOGo, Contacts.SOGo, ContactsUI.SOGo, MailPartViewers.SOGo, Mailer.SOGo, MailerUI.SOGo, MainU I.SOGo, PreferencesUI.SOGo, SchedulerUI.SOGo Jun 26 16:01:39 sogod [26693]: [so-product-registry] could not load product: MailPartViewers Jun 26 16:01:39 sogod [26693]: [so-product-registry] could not load product: MailerUI Jun 26 16:01:39 sogod [26693]: 0x0xb88662c4[WOWatchDog] listening on *:2 Jun 26 16:01:39 sogod [26693]: 0x0xb88662c4[WOWatchDog] watchdog process pid: 26693 Jun 26 16:01:39 sogod [26693]: 0x0xb74aad20[WOWatchDogChild] watchdog request timeout set to 10 minutes Jun 26 16:01:39 sogod [26693]: 0x0xb88662c4[WOWatchDog] preparing 1 children Jun 26 16:01:39 sogod [26693]: 0x0xb88662c4[WOWatchDog] child spawned with pid 26694 Jun 26 16:02:15 sogod [26694]: 0x0xb892b5dc[SOGoCache] Cache cleanup interval set every 300.00 seconds Jun 26 16:02:15 sogod [26694]: 0x0xb892b5dc[SOGoCache] Using host(s) 'localhost' as server(s) 2013-06-26 16:02:15.601 sogod[26694] Note(SoObject): SoDebugKeyLookup is enabled! 2013-06-26 16:02:15.601 sogod[26694] Note(SoObject): SoDebugBaseURL is enabled! 2013-06-26 16:02:15.601 sogod[26694] Note(SoObject): relative base URLs are enabled. Jun 26 16:02:15 sogod [26694]: SOGoRootPage successful login from '10.8.0.30' for user 'igor' - expire = -1 grace = -1 Jun 26 16:02:15 sogod [26694]: [ERROR] 0x0xb8b7458c[NGLdapAttribute] cound not convert value of objectSid to string Jun 26 16:02:15 sogod [26694]: [ERROR] 0x0xb8b744bc[NGLdapAttribute] cound not convert value of objectGUID to string Jun 26 16:02:15 sogod [26694]: [WARN] 0x0xb8b86acc[SOGoWebDAVAclManager] entry '{DAV:}write' already exists in DAV permissions table Jun 26 16:02:15 sogod [26694]: [WARN] 0x0xb8b86acc[SOGoWebDAVAclManager] entry '{DAV:}write-properties' already exists in DAV permissions table Jun 26 16:02:15 sogod [26694]: [WARN] 0x0xb8b86acc[SOGoWebDAVAclManager] entry '{DAV:}write-content' already exists in DAV permissions table 2013-06-26 16:02:15.741 sogod[26694] Note: Using UTF-8 as URL encoding in NGExtensions. 10.8.0.30 - - [26/Jun/2013:16:02:15 GMT] POST /SOGo/connect HTTP/1.1 200 27/38 0.147 - - 3M 10.8.0.30 - - [26/Jun/2013:16:02:15 GMT] GET /SOGo/so/igor HTTP/1.1 302 0/0 0.004 - - 8K 10.8.0.30 - - [26/Jun/2013:16:02:15 GMT] GET /SOGo/so/igor/view HTTP/1.1 302 0/0 0.004 - - 8K 10.8.0.30 - - [26/Jun/2013:16:02:15 GMT] GET /SOGo/so/Igor/Calendar HTTP/1.1 302 0/0 0.005 - - 0 10.8.0.30 - - [26/Jun/2013:16:02:16 GMT] GET /SOGo/so/Igor/Calendar/view HTTP/1.1 200 13112/0 0.084 47891 72% 1M 10.8.0.30 - - [26/Jun/2013:16:02:16 GMT] POST /SOGo/so/Igor/Calendar/personal/canAccessContent HTTP/1.1 204 0/0 0.012 - - 0 10.8.0.30 - - [26/Jun/2013:16:02:16 GMT] POST /SOGo/so/Igor/Calendar/alarmslist?browserTime=1372255335 HTTP/1.1 200 2/0 0.006 - - 0 10.8.0.30 - - [26/Jun/2013:16:02:16 GMT] POST /SOGo/so/Igor/Calendar/eventslist?asc=truesort=startday=filterpopup=view_today HTTP/1.1 200 2/0 0.009 - - 0 10.8.0.30 - - [26/Jun/2013:16:02:16 GMT] POST /SOGo/so/Igor/Calendar/taskslist?show-completed=0asc=truesort=end HTTP/1.1 200 2/0 0.005 - - 0 10.8.0.30 - - [26/Jun/2013:16:02:16 GMT] POST /SOGo/so/Igor/Calendar/weekview HTTP/1.1 200 2185/0 0.017 22433 90% 12K 10.8.0.30 - - [26/Jun/2013:16:02:16 GMT] POST /SOGo/so/Igor/Calendar/eventsblocks?sd=20130624ed=20130630view=weekview HTTP/1.1 200 64/0 0.005 - - 0 10.8.0.30 - - [26/Jun/2013:16:02:18 GMT] GET /SOGo/so/Igor/Mail HTTP/1.1 302 0/0 0.003 - - 0 Jun 26 16:02:18 sogod [26694]: [ERROR] 0x0xb8b6b94c[NGLdapAttribute] cound not convert value of objectSid to string Jun 26 16:02:18 sogod [26694]: [ERROR] 0x0xb8b0100c[NGLdapAttribute] cound not convert value of objectGUID to string 10.8.0.30 - - [26/Jun/2013:16:02:18 GMT] GET /SOGo/so/Igor/Mail/view HTTP/1.1 404 208/0 0.011 - - 0 10.8.0.30 - - [26/Jun/2013:16:02:19 GMT] POST /SOGo/so/Igor/Calendar/personal/canAccessContent HTTP/1.1 204 0/0 0.003 - - 0 10.8.0.30 - -
Re: Re: [SOGo] Re: SOGo MySQL Authentication - SOLVED
I have just tried that now and it works!! Thanks However, I find this confusing, since I use dovecot and dovecot treats my password as md5-crypt. Allow me to also ask: Since I have isAddressBook = YES; , shouldn't SOGo populate my global addressbook by default? Mine remains empty... On 26 June 2013 20:16, Giovanni Bechis giova...@bigio.snb.it wrote: Have you tried with userPasswordAlgorithm = crypt; ? -- msg. originale -- Oggetto: Re: [SOGo] Re: SOGo MySQL Authentication - SOLVED Da: Odhiambo Washington odhia...@gmail.com Data: 26/06/2013 18:17 Well when I change that to md5-crypt, with matching password, it doesn't work. Why so? Either of these two don't work! userPasswordAlgorithm = md5; userPasswordAlgorithm = md5-crypt; My VIEW looks like this: mysql select * from exim4u.sogo_auth_view where c_name like '%wash%'; +-+-+-++-+-+- + | sogo_id | c_uid | c_name | c_password | c_cn| mail| displayN ame | +-+-+-++-+-+- + | 3 | w...@kictanet.or.ke | Odhiambo WASHINGTON | $1$OFb7e/vf$/FL/Q4T0LXFwaklRUzN7v. | w...@kictanet.or.ke | w...@kictanet.or.ke | Odhiambo WASHINGTON | +-+-+-++-+-+- + On 26 June 2013 17:44, Giovanni Bechis giova...@bigio.snb.it wrote: On 06/26/13 15:32, Odhiambo Washington wrote: Hello, I have changed userPasswordAlgorithm = md5; to userPasswordAlgorithm = none; and I was able to login! This is because you have cleartext passwords in your database, you should crypt your passwords before saving into MySQL. Cheers Giovanni -- users@sogo.nu https://inverse.ca/sogo/lists -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Re: SOGo MySQL Authentication - SOLVED
On 2013-06-26 3:43 PM, Odhiambo Washington wrote: Since I have isAddressBook = YES; , shouldn't SOGo populate my global addressbook by default? Mine remains empty... Search in it. Also, c_name should be equal in most situation to c_uid. Right now you've set it to the user's real name, which is far from ideal. c_cn should be the user's realname. -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Re: SOGo MySQL Authentication - SOLVED
Hi Ludovic, In that case, I now modify my VIEW: mysql CREATE VIEW sogo_auth_view AS SELECT user_id AS sogo_id, username AS c_uid, username AS c_name, crypt AS c_password, realname AS c_cn, use rname AS mail, realname AS displayName FROM users WHERE enabled='1'; Which then gives the output below mysql select * from exim4u.sogo_auth_view where c_name like '%wash%'; +-+-+-++-+-+-+ | sogo_id | c_uid | c_name | c_password | c_cn| mail| displayName | +-+-+-++-+-+-+ | 3 | w...@kictanet.or.ke | w...@kictanet.or.ke | $1$XXX | Odhiambo WASHINGTON | w...@kictanet.or.ke | Odhiambo WASHINGTON | +-+-+-++-+-+-+ So c_uid == c_name as you've suggested. My config has the below and still I cannot find anything inside the Staff Members addressbook folder. Anything unusual?? Also tell me, why is it that SOGo treats such password as crypt and not md5-crypt?? SOGoUserSources = ( { type = sql; canAuthenticate = YES; displayName = Staff Members; id = users; isAddressBook = YES; userPasswordAlgorithm = crypt; //userPasswordAlgorithm = none; viewURL =mysql://exim4u:XXXWWW@127.0.0.1:3306/exim4u/sogo_auth_view ; } ); On 26 June 2013 22:47, Ludovic Marcotte lmarco...@inverse.ca wrote: On 2013-06-26 3:43 PM, Odhiambo Washington wrote: Since I have isAddressBook = YES; , shouldn't SOGo populate my global addressbook by default? Mine remains empty... Search in it. Also, c_name should be equal in most situation to c_uid. Right now you've set it to the user's real name, which is far from ideal. c_cn should be the user's realname. -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence ( http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Caching errors - what's the problem/solution?
I am getting these in the sogo.log: Jun 26 23:34:41 sogod [82542]: 0x0x23c58d64[SOGoCache] an error occurred when caching value for key 'session:ODRXP1/M23Xz99zKVHGoWg==': SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY Jun 26 23:34:41 sogod [82542]: 0x0x23c58d64[SOGoCache] an error occurred when caching value for key 'w...@kictanet.or.ke+attributes': SER VER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY Jun 26 23:34:41 sogod [82542]: |SOGo| lookup name: w...@kictanet.or.ke Jun 26 23:34:41 sogod [82542]: |SOGo| did not find key ' w...@kictanet.or.ke' in SoClass: 0x0x23c07544[SoObjCClass]: super=0x0x23c071c4 ob jc=SOGo slots=connect,GET,view,casProxy,index,saml2-signon-post,changePassword,saml2-metadata,loading,toolbar Jun 26 23:34:41 sogod [82542]: |SOGo| looked up value: (null) Jun 26 23:34:41 sogod [82542]: |SOGo| lookup in root object: (null) Jun 26 23:34:41 sogod [82542]: |SOGo| GOT: (null) Jun 26 23:34:41 sogod [82542]: 0x0x23c58d64[SOGoCache] an error occurred when caching value for key 'w...@kictanet.or.ke+attributes': SER VER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY Jun 26 23:34:41 sogod [82542]: 0x0x23c58d64[SOGoCache] an error occurred when caching value for key 'w...@kictanet.or.ke+attributes': SER VER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY Jun 26 23:34:41 sogod [82542]: 0x0x23c58d64[SOGoCache] an error occurred when caching value for key 'w...@kictanet.or.ke+attributes': SER VER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY Jun 26 23:34:41 sogod [82542]: 0x0x23c58d64[SOGoCache] an error occurred when caching value for key 'session:ODRXP1/M23Xz99zKVHGoWg==': SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY Jun 26 23:34:41 sogod [82542]: 0x0x23c58d64[SOGoCache] an error occurred when caching value for key 'w...@kictanet.or.ke+defaults': SERVE R HAS FAILED AND IS DISABLED UNTIL TIMED RETRY What do I need to do to solve? -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] select multiple emails in internet explorer
Thank you all for your responses. MJ -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] FreeBSD port - LDAP authentication
Good day, Well, I'm back on this after a reinstall to see how things are looking. Here's the nice thing so far SOGo installed. I've got it working with PGSQL I believe I have it working with OpenLDAP with exceptions. Versions that we are playing with here: FreeBSD 9.1 RELEASE apache22-2.2.24 memcached-1.4.15 nss_ldap-1.265_7 openldap-client-2.4.35 pam_ldap-1.8.6_2 postgresql-client-9.2.4 sogo-2.0.5 sope-2.0.5 Sogo starts and runs Apache starts and runs Memcached starts and runs Anonymous ldap binding seems to run fine and I can grab a uid in the subtree. My LDAP server has a configuration like: dc=company,dc=com ou=people,dc=company,dc=com When I start up sogo, I get the following in the /var/log/sogo/sogo.log: Jun 26 16:06:03 sogod [67881]: version 2.0.5 (build r...@.company.com 201306251909) -- starting Jun 26 16:06:03 sogod [67881]: vmem size check enabled: shutting down app when vmem 384 MB Jun 26 16:06:03 sogod [67881]: 0x0x8087b5988[SOGoProductLoader] SOGo products loaded from '/usr/local/GNUstep/Local/Library/SOGo': Jun 26 16:06:03 sogod [67881]: 0x0x8087b5988[SOGoProductLoader] MailPartViewers.SOGo, ContactsUI.SOGo, Mailer.SOGo, Appointments.SOGo, MainUI.SOGo, CommonUI.SOGo, SchedulerUI.SOGo, AdministrationUI.SOGo, PreferencesUI.SOGo, Contacts.SOGo, MailerUI.SOGo Jun 26 16:06:03 sogod [67881]: 0x0x808470438[WOWatchDog] listening on *:2 Jun 26 16:06:03 sogod [67881]: 0x0x808470438[WOWatchDog] watchdog process pid: 67881 Jun 26 16:06:03 sogod [67881]: 0x0x801c3bb60[WOWatchDogChild] watchdog request timeout set to 10 minutes Jun 26 16:06:03 sogod [67881]: 0x0x808470438[WOWatchDog] preparing 1 children Jun 26 16:06:03 sogod [67881]: 0x0x808470438[WOWatchDog] child spawned with pid 67882 2013-06-26 16:06:03.695 sogod[67882] PostgreSQL72 connection established: 0x0x809cf20a8[PGConnection]: connection=0x0x809d7c000 2013-06-26 16:06:03.695 sogod[67882] PostgreSQL72 channel 0x0x809cba048 opened (connection=0x0x809cf20a8[PGConnection]: connection=0x0x809d7c000) 2013-06-26 16:06:03.695 sogod[67882] PG0x0x809cba048 SQL: SELECT count(*) FROM sogo_user_profile 2013-06-26 16:06:03.696 sogod[67882] PG0x0x809cba048 SQL: SELECT count(*) FROM sogo_folder_info 2013-06-26 16:06:03.698 sogod[67882] PG0x0x809cba048 SQL: SELECT count(*) FROM sogo_sessions_folder H... looks fine in that we're connecting to PostGreSQL and everything checks out on the PGSQL side. A simple web server test on the machine, retries the It Works! on the home page. Attempting to go to the http://www.company.com/SOGo page I get the following in the sogo log: 2013-06-26 16:30:54.616 sogod[68616] Note: Using UTF-8 as URL encoding in NGExtensions. Jun 26 16:30:54 sogod [68616]: |SOGo| starting method 'GET' on uri '/SOGo/' Jun 26 16:30:54 sogod [68616]: 0x0x809df6d38[SOGoCache] Cache cleanup interval set every 300.00 seconds Jun 26 16:30:54 sogod [68616]: 0x0x809df6d38[SOGoCache] Using host(s) 'localhost' as server(s) 2013-06-26 16:30:54.618 sogod[68616] PG0x0x809cba048 SQL: BEGIN TRANSACTION 2013-06-26 16:30:54.619 sogod[68616] PG0x0x809cba048 SQL: SELECT t1.c_creationdate, t1.c_id, t1.c_lastseen, t1.c_value FROM sogo_sessions_folder t1 WHERE t1.c_id='OtUy2L39/oh7u6ije6m1xA==' 2013-06-26 16:30:54.620 sogod[68616] PG0x0x809cba048 SQL: ROLLBACK TRANSACTION 2013-06-26 16:30:54.623 sogod[68616] PostgreSQL72 connection established: 0x0x809d6fc88[PGConnection]: connection=0x0x809d80c00 2013-06-26 16:30:54.623 sogod[68616] PostgreSQL72 channel 0x0x809d04848 opened (connection=0x0x809d6fc88[PGConnection]: connection=0x0x809d80c00) 2013-06-26 16:30:54.623 sogod[68616] PG0x0x809d04848 SQL: BEGIN TRANSACTION 2013-06-26 16:30:54.623 sogod[68616] PG0x0x809d04848 SQL: SELECT t1.c_creationdate, t1.c_id, t1.c_lastseen, t1.c_value FROM sogo_sessions_folder t1 WHERE t1.c_id='OtUy2L39/oh7u6ije6m1xA==' 2013-06-26 16:30:54.624 sogod[68616] PG0x0x809d04848 SQL: ROLLBACK TRANSACTION 2013-06-26 16:30:54.624 sogod[68616] PG0x0x809cba048 SQL: BEGIN TRANSACTION 2013-06-26 16:30:54.624 sogod[68616] PG0x0x809cba048 SQL: UPDATE sogo_sessions_folder SET c_value = 'RHtwGoSxIq0lcvmfWdP6FXwvWMu1wV/IEqoBSkoK13hTtXPg8+COyTrMIY5xgcvIitCGUCmfDQ5KK+IXySFijtt/7j9EvJMYEm1oapBHU79u/IsrdAu5F8hHGEAl54uZkqCAKHmymjQIXaMo3UZYjkoonmaIcIXRpo07RmUhz4+UOf+SV9Pm8GSnaiekMoPsW7muqzEfJiplmsge+VGZEg==', c_lastseen = 1372278654, c_creationdate = 1372274587, c_id = 'OtUy2L39/oh7u6ije6m1xA==' WHERE c_id='OtUy2L39/oh7u6ije6m1xA==' 2013-06-26 16:30:54.625 sogod[68616] PG0x0x809cba048 SQL: COMMIT TRANSACTION Jun 26 16:30:54 sogod [68616]: 0x0x809e303d8[NGLdapConnection] Using ldap_initialize for LDAP URL: ldap://LDAP IP:389 2013-06-26 16:30:54.651 sogod[68616] Note(SoObject): SoDebugKeyLookup is enabled! 2013-06-26 16:30:54.651 sogod[68616] Note(SoObject): SoDebugBaseURL is enabled! 2013-06-26 16:30:54.651 sogod[68616] Note(SoObject): relative base URLs are enabled. Jun 26 16:30:54 sogod [68616]: 0x0x809e9f2e8[NGLdapConnection]
Re: [SOGo] This page cant be displayed
Ok, Ive managed to work through the This page cant be displayed issue and now Im on to the next. I log into SOGo with user name and authenticate fine but do not get my IMAP folders displayed. My SOGo server is stand alone and IMAP/Postfixare ona different server. Using Thunderbird I can authenticate and use email just fine no issues but SOGo gives me a Could Not Connect IMAP4 error.Here is my .GNUstepDefaults config?xml version=1.0 encoding=UTF-8?!DOCTYPE plist PUBLIC -//GNUstep//DTD plist 0.9//EN http://www.gnustep.org/plist-0_9.xmlplist version=0.9dict keyNSGlobalDomain/key dict /dict keysogod/key ; dict keyOCSEMailAlarmsFolderURL/key stringpostgresql://sogo:sogo@127.0.0.1:5432/sogo/sogo_alarms_folder/string keyOCSFolderInfoURL/key stringpostgresql://sogo:sogo@127.0.0.1:5432/sogo/sogo_folder_info/string keyOCSSessionsFolderURL/key stringpostgresql://sogo:sogo@127.0.0.1:5432/sogo/sogo_sessions_folder/string keySOGoACLsSendEMailNotifications/key stringYES/string keySOGoAppointmentSendEMailNotificati ons/key stringYES/string keySOGoDraftsFolderName/key stringDrafts/string keySOGoEnableEMailAlarms/key stringYES/string keySOGoFoldersSendEMailNotifications/key stringYES/string keySOGoIMAPServer/key stringmail1.domain.com/string keySOGoSieveServer/key stringsieve://hma018.domain.com:4 190/string keySOGoLanguage/key stringEnglish/string keySOGoMailAuxiliaryUserAccountsEnabled/key stringYES/string keySOGoMailComposeMessageType/key stringhtml/string keySOGoMailDomain/key stringdomain.com/string keySOGoMailReplyPlacement/key stringabove/string keySOGoMailSignatu rePlacement/key stringbelow/string keySOGoMailUseOutlookStyleReplies/key stringYES/string keySOGoMailingMechanism/key stringsmtp/stringkeySOGoPageTitle/key stringSOGo Mail at domain, LLC./string keySOGoVacationEnabled/key stringYES/string keySOGoForwardEnabled/key stringYES/string bsp; keySOGoSieveScriptsEnabled/key stringYES/string keySOGoProfileURL/key stringpostgresql://sogo:s...@hma018.domain.com:5432/sogo/sogo_user_profile/string keySOGoSMTPServer/key stringhma016.domain.com/string keySOGoSentFoldersName/key stringSent/string keySOGoTimeZone/key stringAmerica/Phoenix/string keySOGoTrashFolderN ame/key stringTrash/string keySOGoUserSources/key array dict keyCNFieldName/key stringcn/string keyIDFieldName/key stringuid/string keyUIDFieldName/key stringuid/string keybaseDN/key stringou=people,dc=domain,dc=com/string keybindDN/key stringcn=Manager,dc=domain,dc=com/string keybindPassword/key stringpassword/string& nbsp; keycanAuthenticate/key stringYES/string keydisplayName/key stringHMA - ALL PEOPLE/string keyhostname/key stringds1.domain.com/string keyid/key stri ngpublic/string keyisAddressBook/key stringYES/string keyport/key string389/string /dict/array keySOGoWOWorkersCount/key string8/string keySxVMemLimit/key string1024/string< br /> keymailHost/key stringhma016.domain.com/string /dict/dict/plistHere is my sogo.log output:192.1.1.237 - - [26/Jun/2013:07:12:46 GMT] GET /SOGo/so/terry.welch/Mail/null/expunge HTTP/1.1 404 208/0 0.004 - - 0Jun 26 07:12:46 sogod [15593]: [ERROR] 0x0x7f3785b25ef8[NGImap4ConnectionManager] IMAP4 login failed: host=hma016.domain.com, user=terry.welch, pwd=yes url="" /> base=(null) base-class=(null)) = 0x0x7f3785cc5948[NGImap4Client]: login=terry.welch(pwd) address=0x0x7f3785c41cb8[NGInternetSocketAddress]: host=hma016.domain.com port=143Jun 26 07:12:46 sogod [15593]: 0x85C31BA8[SOGoMailFolder]:folderINBOX renewing imap4 passwordJun 26 07:12:46 sogod [15593]: [ERROR] 0x0x7f3785b25ef8[NGImap4ConnectionManager] IMAP4 login failed: host=hma016.domain.com, user=terry.welch, pwd=yes url="" /> base=(null) base-class=(null)) = 0x0x7f3785bd9d88[NGImap4Client]: login=terry.welch(pwd) address=0x0x7f3785b57818[NGInternetSocketAddress]: host=hma016.domain.com port=143Jun 26 07:12:46 sogod [15593]: [ERROR] 0x85C31BA8[SOGoMailFolder]:folderINBOX Could not connect IMAP4192.1.1.237 - - [26/Jun/2013:07:12:46 GMT] GET /SOGo/so/terry.welch/Mail/view HTTP/1.1 200 7885/0 0.034 31421 74% 0192.1.1.237 - - [26/Jun/2013:07:12:47 GMT] POST /SOGo/so/terry.welch/Calendar/alarmslist?browserTime=1372281195 HTTP/1.1 200 2/0 0.006 - - 0Jun 26 07:12:47 sogod [15593]: [ERROR] 0x0x7f3785b25ef8[NGImap4ConnectionManager] IMAP4 login faile d: host=hma016.domain.com, user=terry.welch, pwd=yes url="" /> base=(null) base-class=(null)) = 0x0x7f3785c592d8[NGImap4Client]: login=terry.welch(pwd) address=0x0x7f3785bb8a58[NGInternetSocketAddress]: host=hma016.domain.com port=143Jun 26 07:12:47 sogod [15593]: 0x85BDE038[SOGoMailAccount]:0 renewing imap4 passwordJun 26 07:12:47 sogod [15593]: [ERROR] 0x0x7f3785b25ef8[NGImap4ConnectionManager] IMAP4 login failed: host=hma016.domain.com, user=terry.welch, pwd=yes url="" /> base=(null) base-class=(null)) = 0x0x7f3785d8[NGImap4Client]: login=terry.welch(pwd) address=0x0x7f3785b89968[NGInternetSocketAddress]: host=hma016.domain.com port=143Jun 26 07:12:47 sogod [15593]: [ERROR] 0x85BDE038[SOGoMailAccount]:0
Re: [SOGo] Training
No lies, 2 weeks ago I didn't know anything about postfix, cyrus, how to setup an ldap server, sasl or anything related to a 'business linux mail server'. and thanksfully, with alot of effort, I managed to learn about all of those modules and setup a working lab composed of postfix, cyrus-imap, ldap, sogo, sasl and some startls etc etc. I just finished making everything work with the thunderbird addon today and I must admit that I find this alternative very interesting so far !! :) Thanks alot for this :D to get back on the topic, I would admit that it is a little hard to find good information that looks like 'course' or good tutorial that really covers everything. I believe that this is simply because all those things are heavily configurable and most of the tutorial I saw lacked alot of information. Hell, just postfix in itself is a beast when it comes down to the amount of possible option settings there is! I personally chose self training, by reading alot of the original manual, mixed with a few trial errors from some tutorials, more reading! and well, make a lab with some vm (I use virtual box..) and fix some objective... Then in the process you might have a better idea of what kind of course you're looking for and might even find it yourself ;p hehe, well that was just my 2 cents. no need to flame me on that :D in the process of building sogo I figured out that there is so much différent things you can use... Just as an example, I found out that you have Directory389, slapd, apacheDS or even freeipa. Oh well, sorry for the lack of reference, and good luck :) Jonathan G. On Wed, Jun 26, 2013 at 12:29 PM, Steven Swarts ste...@swartsit.com wrote: Quoting Wayland Sothcott wayl...@sothcott.co.uk On 26/06/2013 06:35, Steven Swarts wrote: G'day guys I've been following SOGo for awhile now, used the ZEG and played with the tutorial that Oliver has kindly made available. My question is I have access to a vast amount of small businesses that I currently support and would love to support in the area of an Exchange alternative. But my reluctance is that I don't understand SOGo, OpenChange, Dovecot, Samba4, Sope, etc. I was wondering if anyone knew or could tell me where I could get training in this area. Currently I have a basic understanding of Linux, but I'm looking for a cutting edge education. The local education places only support Samba3 which annoys me to no end. So in a nutshell, if I were to do some courses (online preferably) what is the recommendation? Also I just want to say brilliant venture, I love Linux so keep up the great work. Hello Steven, I have been following SOGo for several months now and played with the ZEG and tried to add SOGo to a Debian server. I think there is a long way to go with this before I can use it and I don't think it's a matter of training. I have used ClearOS 5.2 successfully for small businesses. With it's web interface it's very easy to get it to do all the things it's capable of such as file sharing, email and hosting the companies website. (I can't say the same about ClearOS 6) The 'Internet' defines lots of things for us, like how websites work, how email works and how DNS works. What it does not define is how address books work. All I want is a simple centralised database of email addresses that is shared by all email users in the company. Back in the 90's there was a fantastic thing called Lotus Notes which was the ultimate groupware. There are no open standards to let you create one in Linux. Whare are the IMAP and SMTP protocols for address books and calendars? I have no idea why people would create standards such as IMAP yet not carry on and create standards for address books. Unless it's so that Microsoft Exchange has no competitor in the Open Source area. Regards, Wayland. (Someone please correct me if I am wrong) -- Mobile: 07925 431381 Office: 01787 388165 -- users@sogo.nu https://inverse.ca/sogo/lists Well currently i use Horde Webmail groupware. It supports CalDav and CardDav plus active sync capabilities with iOS and Android up to AS 14.1 But SOGo and the native Outlook support is a winner in my books, plus coupled with Samba 4 and goodbye Microsoft in a couple of years I would say. The trick I'm sure is to know how to set it up, but most importantly how to keep it running. Anyway I hoping that someone has an answer for my original question. Regards, Steven Swarts Swarts IT Wayland Sothcott wayl...@sothcott.co.uk wrote: -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Training
Good job, Jonathan! We didn't start from scratch but from a prior ZEG We asked Inverse to configure it initially, but I've learned how to manage and upgrade it along the way. I've downloaded the latest ZEG and will begin working through the differences (chiefly, Samba4) to see if I can repeat what I've learned. On 06/26/2013 05:25 PM, Jonathan Goyette wrote: No lies, 2 weeks ago I didn't know anything about postfix, cyrus, how to setup an ldap server, sasl or anything related to a 'business linux mail server'. and thanksfully, with alot of effort, I managed to learn about all of those modules and setup a working lab composed of postfix, cyrus-imap, ldap, sogo, sasl and some startls etc etc. I just finished making everything work with the thunderbird addon today and I must admit that I find this alternative very interesting so far !! :) Thanks alot for this :D to get back on the topic, I would admit that it is a little hard to find good information that looks like 'course' or good tutorial that really covers everything. I believe that this is simply because all those things are heavily configurable and most of the tutorial I saw lacked alot of information. Hell, just postfix in itself is a beast when it comes down to the amount of possible option settings there is! I personally chose self training, by reading alot of the original manual, mixed with a few trial errors from some tutorials, more reading! and well, make a lab with some vm (I use virtual box..) and fix some objective... Then in the process you might have a better idea of what kind of course you're looking for and might even find it yourself ;p hehe, well that was just my 2 cents. no need to flame me on that :D in the process of building sogo I figured out that there is so much différent things you can use... Just as an example, I found out that you have Directory389, slapd, apacheDS or even freeipa. Oh well, sorry for the lack of reference, and good luck :) Jonathan G. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] BTS activities for Wednesday, June 26 2013
Title: BTS activities for Wednesday, June 26 2013 BTS Activities Home page: http://www.sogo.nu/bugs Project: SOGo For the period covering: Wednesday, June 26 2013 idlast updatestatus (resolution)categorysummary 2248 2013-06-26 10:49:35 updated (open) Apple iCal.app Impossible to autoconfigure ICAL via profilmanager 2355 2013-06-26 07:54:57 updated (open) sogo-tool Sogo connector 17.0.5 2293 2013-06-26 07:18:30 updated (open) Web Address Book MailList 2356 2013-06-26 07:56:57 new (open) with SOGo Sogo connector 17.0.5 2352 2013-06-26 10:41:47 assigned (open) OpenChange backend samba panic with outlook shared calendar and contact