[SOGo] migrating Exchange 2007 to SOGo
Hi there My Company decides within the next days about a new solution for groupware. I am fighting for SOGo :) Currently we have MS$ Exchange 2007 with an large Calendar and an Adressbook for the whole company. My people I’ve suggested to switch from Outlook 2010 and 2011 (Mac) to Thunderbird. Only a few people like the Managers should still use Outlook 2010. I hope I am right here to get some suggestions about an Migration from Exchange 2007 to SOGo. For migrating the Mails from exchange to an Imapserver like Dbmail or Dovecot what would be the best way? imapsync? Currently I have no clue to migrate the calendar and the addressbook to SOGo. An export from client site and import to SOGo would violate against the policy of my company. What would be best practice to get an solution? Cheers Darko [cid:008f-0001@01cf27ed.202f5f61] Darko Hojnik, Administrator Tel. +49 (221) 589808-35 Fax +49 (221) 589808-11 » dhoj...@brainbits.netmailto:dhoj...@brainbits.net brainbits GmbH Kommunikation Systeme Alpenerstrasse 16, D-50825 Köln » www.brainbits.nethttp://www.brainbits.net » www.phlexible.nethttp://www.phlexible.net Folgen Sie uns auf twitter » www.twitter.com/brainbits_gmbhhttp://www.twitter.com/brainbits_gmbh » www.twitter.com/phlexiblehttp://www.twitter.com/phlexible Geschäftsführung: Sascha Emondts, Patrick Schuh Amtsgericht Köln, HRB 32293, USt-IdNr. DE 203606736 inline: bblogo_100.gif
[SOGo] postgresql and SSL
Hi there, Is it possible if SOGo conects to an PostgreSQL database use SSL on the connection? And if yes how could I write it on the .GnuStepDefaults file? cheers Darko -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] memcached problem?
Hi Today I've installed SOGo on a fresh installed FreeBSD In my Log i see somthing like this 172.16.54.1 - - [26/Mar/2012:23:08:26 GMT] POST /SOGo/so/test@hell.localdomain/Mail//0/folderINBOX/headers HTTP/1.1 200 564/12 0.441 - - - Mar 26 23:08:26 sogod [1188]: 0x0x8077c21d0[SOGoCache] an error occurred when caching value for key 'session:iM4is2iIJWTV+yf2yg/zCQ==': SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY Mar 26 23:08:26 sogod [1188]: 0x0x8077c21d0[SOGoCache] an error occurred when caching value for key 'test@hell.localdomain+attributes': SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY Mar 26 23:08:26 sogod [1188]: 0x0x8077c21d0[SOGoCache] an error occurred when caching value for key 'test@hell.localdomain+attributes': SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY Mar 26 23:08:26 sogod [1188]: 0x0x8077c21d0[SOGoCache] an error occurred when caching value for key 'test@hell.localdomain+attributes': SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY Mar 26 23:08:26 sogod [1188]: 0x0x8077c21d0[SOGoCache] an error occurred when caching value for key 'test@hell.localdomain+attributes': SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY Mar 26 23:08:26 sogod [1188]: 0x0x8077c21d0[SOGoCache] an error occurred when caching value for key 'session:iM4is2iIJWTV+yf2yg/zCQ==': SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY Mar 26 23:08:26 sogod [1188]: 0x0x8077c21d0[SOGoCache] an error occurred when caching value for key 'test@hell.localdomain@+attributes': SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY Mar 26 23:08:26 sogod [1188]: 0x0x8077c21d0[SOGoCache] an error occurred when caching value for key 'test@hell.localdomain+attributes': SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY Mar 26 23:08:26 sogod [1188]: 0x0x8077c21d0[SOGoCache] an error occurred when caching value for key 'test@hell.localdomain+attributes': SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY Mar 26 23:08:26 sogod [1188]: 0x0x8077c21d0[SOGoCache] an error occurred when caching value for key 'test@hell.localdomain+attributes': SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY Mar 26 23:08:26 sogod [1188]: 0x0x8077c21d0[SOGoCache] an error occurred when caching value for key 'session:iM4is2iIJWTV+yf2yg/zCQ==': SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY 172.16.54.1 - - [26/Mar/2012:23:08:27 GMT] POST /SOGo/so/test@hell.localdomain/Mail//0/folderINBOX/headers HTTP/1.1 200 564/12 0.441 - - - Mar 26 23:12:12 sogod [1188]: 0x0x8077c21d0[SOGoCache] an error occurred when caching value for key 'session:iM4is2iIJWTV+yf2yg/zCQ==': SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY Mar 26 23:12:12 sogod [1188]: 0x0x8077c21d0[SOGoCache] an error occurred when caching value for key 'test@hell.localdomain+attributes': SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY Mar 26 23:12:12 sogod [1188]: 0x0x8077c21d0[SOGoCache] an error occurred when caching value for key 'test@hell.localdomain+attributes': SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY Mar 26 23:12:12 sogod [1188]: 0x0x8077c21d0[SOGoCache] an error occurred when caching value for key 'test@hell.localdomain+attributes': SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY Mar 26 23:12:12 sogod [1188]: 0x0x8077c21d0[SOGoCache] an error occurred when caching value for key 'test@hell.localdomain+attributes': SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY Mar 26 23:12:12 sogod [1188]: 0x0x8077c21d0[SOGoCache] an error occurred when caching value for key 'session:iM4is2iIJWTV+yf2yg/zCQ==': SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY Mar 26 23:12:12 sogod [1188]: SOGoUserHomePage user 'test@hell.localdomain' logged off Currently I don't know whats happening now, Is that an Problem with memcached or with cyrus? Or both? cheers Darko -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] memcached problem?
Hello Andre Am Dienstag, den 27.03.2012, 17:21 +0200 schrieb André Schild: Make sure you use 127.0.0.1 for the address of your memcached and not localhost. When using localhost it sometimes trys to access memcached via IPv6 which apparently is not yet working André Thank you for the hint defaults write sogod SOGoMemcachedHost = 127.0.0.1 That was wrong from me. I've corrected it to defaults write sogod SOGoMemcachedHost 127.0.0.1 Now it works :) cheers Darko -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Question about MailFieldNames for LDAP
Hi there
I want tell SOGo the fields for mailadresses and alternative
mailadresses. In the Docomentation I've read that I should choose
MailFieldNames for that. Could someone describe me the use of the
SOGoUserSources MailFieldNames and give me an example?
Without MailFieldNames
defaults write sogod SOGoUserSources '({CNFieldName = cn; IDFieldName =
cn; UIDFieldName = mail; baseDN = ou=people,dc=hell; bindDN =
cn=manager; bindPassword = freebsd; canAuthenticate = YES; displayName
= ldap; hostname = localhost; bindFields = mail; id = ldap;
port=389})'
I want use the attributes gosamailalternateaddress and mail on my LDAP
Tree
best regards
Darko
--
users@sogo.nu
https://inverse.ca/sogo/lists
[SOGo] how I could prevent automaticly logout on SOGo or adjust the time for logout in SOGo
Hello List After a successful login in SOGo I'm always automaticly loggetd out after some minutes. How I could prevent automaticly logout for users on SOGo or adjust the time for logout in SOGo? cheers Darko -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] how I could prevent automaticly logout on SOGo or adjust the time for logout in SOGo
Hello List After a successful login in SOGo I'm always automaticly loggetd out after some minutes. How I could prevent automaticly logout for users on SOGo or adjust the time for logout in SOGo? cheers Darko -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Can not log me in with LDAP
Hi there Today I've fresh installed SOGo on FreeBSD. But i cant log me in with LDAP enabeled. ?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 keyOCSEMailAlarmsFolderURL/key stringpostgresql://sogo:freebsd@127.0.0.1:5432/sogo/sogo_alarms_folder/string keyOCSFolderInfoURL/key stringpostgresql://sogo:freebsd@127.0.0.1:5432/sogo/sogo_folder_info/string keyOCSSessionsFolderURL/key stringpostgresql://sogo:freebsd@127.0.0.1:5432/sogo/sogo_sessions_info/string keySOGoACLsSendEMailNotifications/key stringYES/string keySOGoAppointmentSendEMailNotifications/key stringYES/string keySOGoCalendarDefaultRoles/key array stringPublicViewer/string stringConfidentialDAndTViewer/string /array keySOGoEnableEMailAlarms/key stringYES/string keySOGoFoldersSendEMailNotifications/key stringYES/string keySOGoIMAPServer/key string127.0.0.1/string keySOGoLanguage/key stringGerman/string keySOGoMailDomain/key stringhell.localdomain/string keySOGoMailingMechanism/key stringsmtp/string keySOGoMemcachedHost/key string=/string keySOGoProfileURL/key stringpostgresql://sogo:freebsd@127.0.0.1:5432/sogo/sogo_user_profile/string keySOGoSMTPServer/key string127.0.0.1/string keySOGoTimeZone/key stringEurope/Berlin/string keySOGoUserSources/key array dict keyCNFieldName/key stringcn/string keyIDFieldName/key stringuid/string keyUIDFieldName/key stringuid/string keybaseDN/key stringou=people,dc=hell/string keybindDN/key stringcn=manager,dc=hell/string keybindPassword/key stringfreebsd/string keycanAuthenticate/key stringYES/string keydisplayName/key stringldap/string keyhostname/key stringlocalhost/string keyid/key stringldap/string keyport/key string389/string /dict /array /dict /dict /plist ~ On my Log 2012-03-26 20:07:52.653 sogod[4104] WOCompoundElement: pool embedding is on. 2012-03-26 20:07:52.653 sogod[4104] WOCompoundElement: id logging is on. Mar 26 20:07:52 sogod [4104]: SOGoRootPage Login for user 'test@hell.localdomain' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0 172.16.54.1 - - [26/Mar/2012:20:07:52 GMT] POST /SOGo/connect HTTP/1.1 403 34/76 0.512 - - - The Data to LDAP and PostgreSQL are correct. Binding with LDAP commandline-tools was successfully possible. Mailsystem ist Postfix, Postgrey, Cyrus and GOSa as an Webfrontend + a SAMBA PDC there are proper working. Anybody haves an Idea to fix it? tanks all in advance! -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Can not log me in with LDAP
Hi Steve, Am Montag, den 26.03.2012, 12:45 -0700 schrieb Stephen Ingram: On Mon, Mar 26, 2012 at 12:15 PM, Darko Hojnik hoj...@virtualizing.org wrote: Hi there Today I've fresh installed SOGo on FreeBSD. But i cant log me in with LDAP enabeled. ?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 keyOCSEMailAlarmsFolderURL/key stringpostgresql://sogo:freebsd@127.0.0.1:5432/sogo/sogo_alarms_folder/string keyOCSFolderInfoURL/key stringpostgresql://sogo:freebsd@127.0.0.1:5432/sogo/sogo_folder_info/string keyOCSSessionsFolderURL/key stringpostgresql://sogo:freebsd@127.0.0.1:5432/sogo/sogo_sessions_info/string keySOGoACLsSendEMailNotifications/key stringYES/string keySOGoAppointmentSendEMailNotifications/key stringYES/string keySOGoCalendarDefaultRoles/key array stringPublicViewer/string stringConfidentialDAndTViewer/string /array keySOGoEnableEMailAlarms/key stringYES/string keySOGoFoldersSendEMailNotifications/key stringYES/string keySOGoIMAPServer/key string127.0.0.1/string keySOGoLanguage/key stringGerman/string keySOGoMailDomain/key stringhell.localdomain/string keySOGoMailingMechanism/key stringsmtp/string keySOGoMemcachedHost/key string=/string keySOGoProfileURL/key stringpostgresql://sogo:freebsd@127.0.0.1:5432/sogo/sogo_user_profile/string keySOGoSMTPServer/key string127.0.0.1/string keySOGoTimeZone/key stringEurope/Berlin/string keySOGoUserSources/key array dict keyCNFieldName/key stringcn/string keyIDFieldName/key stringuid/string keyUIDFieldName/key stringuid/string keybaseDN/key stringou=people,dc=hell/string keybindDN/key stringcn=manager,dc=hell/string keybindPassword/key stringfreebsd/string keycanAuthenticate/key stringYES/string keydisplayName/key stringldap/string keyhostname/key stringlocalhost/string keyid/key stringldap/string keyport/key string389/string /dict /array /dict /dict /plist ~ On my Log 2012-03-26 20:07:52.653 sogod[4104] WOCompoundElement: pool embedding is on. 2012-03-26 20:07:52.653 sogod[4104] WOCompoundElement: id logging is on. Mar 26 20:07:52 sogod [4104]: SOGoRootPage Login for usertest@hell.localdomain 'test@hell.localdomain' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0 172.16.54.1 - - [26/Mar/2012:20:07:52 GMT] POST /SOGo/connect HTTP/1.1 403 34/76 0.512 - - - The Data to LDAP and PostgreSQL are correct. Binding with LDAP commandline-tools was successfully possible. Mailsystem ist Postfix, Postgrey, Cyrus and GOSa as an Webfrontend + a SAMBA PDC there are proper working. Anybody haves an Idea to fix it? The uid you are trying to login with (test@hell.localdomain) looks unusual to me. Are you sure that is the uid in your directory? Steve -- users@sogo.nu https://inverse.ca/sogo/lists Here is an ldif from this User dn: cn=Testing User,ou=people,dc=hell objectclass: top objectclass: person objectclass: organizationalPerson objectclass: inetOrgPerson objectclass: gosaAccount objectclass: posixAccount objectclass: shadowAccount objectclass: sambaSamAccount objectclass: gosaMailAccount cn: Testing User gidnumber: 1001 gosamaildeliverymode: [LC] gosamailserver: Cyrus on 127.0.0.1 homedirectory: /usr/home/test mail: test@hell.localdomain sambasid: S-1-5-21-3006298893-1151248186-1656590636-2002 sn: User uid: test uidnumber: 1001 academictitle:: RHIuIA== dateofbirth: 1970-01-01 gecos: Testing User gender: M givenname: Testing gosamailalternateaddress: test2@hell.localdomain gosamailalternateaddress: test3@hell.localdomain gosamailquota: 2000 gosaspammailbox: INBOX gosaspamsortlevel: 0 gotolastsystemlogin: 01.01.1970 00:00:00 homephone: 123456789 homepostaladdress: Somewere over the Rainbow labeleduri: http://www.google.com/ loginshell: /bin/csh personaltitle: King preferredlanguage: de_DE sambaacctflags: [U ] sambabadpasswordcount: 0 sambabadpasswordtime: 0 sambadomainname: HELL sambahomedrive: H: sambahomepath: \\HELL\test sambalmpassword: 1859DF459C8FC49CAAD3B435B51404EE sambalogofftime: 2147483647 sambalogontime: 0 sambamungeddial
Re: [SOGo] Can not log me in with LDAP
Hi Ludovic, Am Montag, den 26.03.2012, 16:38 -0400 schrieb Ludovic Marcotte: On 26/03/12 16:32, Darko Hojnik wrote: keyIDFieldName/key stringuid/string keyUIDFieldName/key stringmail/string Set CNFieldName to cn Set IDFieldName to cn; Set UIDFieldName to uid; Set bindFields to (uid, mail); This should work. -- Ludovic Marcotte +1.514.755.3630 :: www.inverse.ca Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) Now it works keyCNFieldName/key stringcn/string keyIDFieldName/key stringcn/string keyUIDFieldName/key stringmail/string keybaseDN/key stringou=people,dc=hell/string keybindDN/key stringcn=manager,dc=hell/string keybindFields/key stringmail/string keybindPassword/key stringfreebsd/string keycanAuthenticate/key stringYES/string keydisplayName/key stringldap/string keyhostname/key stringlocalhost/string keyid/key stringldap/string keyport/key string389/string This would work but SOGo would register me with a wron username on cyrus. keyIDFieldName/key stringuid/string Thank you so much. best regards Darko -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGo on FreeBSD
Hi there, Currently I'm trying to install SOGo on my FreeBSD Box with multiple Domains. But Login over LDAP Sources fails. Could anyone tell me whats going wrong? I still didn't find the error :( PostgreSQL, LDAP, IMAP and SMTP are distributed on other servers (FreeBSD Jails). On my sogo logfile Oct 16 17:55:28 sogod [67193]: version 1.3.8 (build darko@web 201110142242) -- starting Oct 16 17:55:28 sogod [67193]: vmem size check enabled: shutting down app when vmem 384 MB Oct 16 17:55:28 sogod [67193]: 0x0x8052dfe50[SOGoProductLoader] SOGo products loaded from '/usr/local/GNUstep/Local/Library/SOGo': Oct 16 17:55:28 sogod [67193]: 0x0x8052dfe50[SOGoProductLoader] CommonUI.SOGo, MailPartViewers.SOGo, Mailer.SOGo, Appointments.SOGo, PreferencesUI.SOGo, AdministrationUI.SOGo, Contacts.SOGo, MailerUI.SOGo, MainUI.SOGo, ContactsUI.SOGo, SchedulerUI.SOGo Oct 16 17:55:28 sogod [67193]: 0x0x80528ee10[WOWatchDog] listening on *:2 Oct 16 17:55:28 sogod [67193]: 0x0x80528ee10[WOWatchDog] watchdog process pid: 67193 Oct 16 17:55:28 sogod [67193]: 0x0x80135a100[WOWatchDogChild] watchdog request timeout set to 10 minutes Oct 16 17:55:28 sogod [67193]: 0x0x80528ee10[WOWatchDog] preparing 1 children Oct 16 17:55:28 sogod [67193]: 0x0x80528ee10[WOWatchDog] child spawned with pid 67194 Oct 16 17:56:17 sogod [67194]: 0x0x80538cf50[SOGoCache] Cache cleanup interval set every 300.00 seconds Oct 16 17:56:17 sogod [67194]: 0x0x80538cf50[SOGoCache] Using host(s) 'localhost' as server(s) 2011-10-16 17:56:17.952 sogod[67194] Note(SoObject): SoDebugKeyLookup is enabled! 2011-10-16 17:56:17.953 sogod[67194] Note(SoObject): SoDebugBaseURL is enabled! 2011-10-16 17:56:17.953 sogod[67194] Note(SoObject): relative base URLs are enabled. 2011-10-16 17:56:21.964 sogod[67194] ERROR(-[NGBundleManager bundleWithPath:]): could not create bundle for path: '/usr/local/GNUstep/System/Library/Libraries/gnustep-base/Versions/1.19/Resources/SSL.bundle' 2011-10-16 17:56:21.976 sogod[67194] WOCompoundElement: pool embedding is on. 2011-10-16 17:56:21.976 sogod[67194] WOCompoundElement: id logging is on. 31.214.153.165 - - [16/Oct/2011:17:56:21 GMT] GET /SOGo HTTP/1.1 302 0/0 4.030 - - - 2011-10-16 17:56:22.056 sogod[67194] WARNING(-[NSNull(misc) count]): called NSNull -count (returns 0) !!! 31.214.153.165 - - [16/Oct/2011:17:56:22 GMT] GET /SOGo/ HTTP/1.1 200 3521/0 0.034 10701 67% - Oct 16 17:56:43 sogod [67194]: SOGoRootPage Login for user 'darko_hojnik' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0 31.214.153.165 - - [16/Oct/2011:17:56:43 GMT] POST /SOGo/connect HTTP/1.1 403 34/70 0.014 - - for better reading I've pasted everything on a pastbin service My .GNUstepDefaults http://debianforum.de/forum/pastebin.php?mode=views=35979 My Vhost http://debianforum.de/forum/pastebin.php?mode=views=35980 My Log http://debianforum.de/forum/pastebin.php?mode=views=35981 here again my .GNUstepDefaults ?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 keyLDAPDebugEnabled/key stringYES/string keyOCSFolderInfoURL/key ?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 keyLDAPDebugEnabled/key stringYES/string keyOCSFolderInfoURL/key stringpostgresql://someuser:foob...@sql.host.tld:5432/sogodb/sogo_folder_info/string keyOCSSessionsFolderURL/key stringpostgresql://someuser:foob...@sql.host.tld:5432/sogodb/sogo_sessions_folder/string keySOGoAppointmentSendEMailNotifications/key stringYES/string keySOGoCalendarDefaultRoles/key array stringPublicViewer/string stringConfidentialDAndTViewer/string /array keySOGoLanguage/key stringGerman/string keySOGoMailingMechanism/key stringsmtp/string keySOGoProfileURL/key stringpostgresql://someuser:foob...@sql.host.tld:5432/sogodb/sogo_user_profile/string keySOGoSentFolderName/key stringSent/string keySOGoTimeZone/key stringEurope/Berlin/string keySOGoTrashFolderName/key stringTrash/string keydomains/key dict keyfoo/key dict keySOGoDraftsFolderName/key stringDrafts/string keySOGoIMAPServer/key stringimap.foo.tld/string keySOGoMailDomain/key stringimap.foo.tld/string keySOGoSMTPServer/key stringsmtp.foo.tld/string keySOGoUserSources/key array dict keyCNFieldName/key
[SOGo] SOGo and IPv6
Hi there I didn't tryed it, but it is possible to run SOGo on a IPv6 only network? It would be nice for me if I could access my LDAP and PostgreSQL Server on different boxes over IPv6 Im using FreeBSD 8 stable, PostgreSQL 9.1, OpenLDAP 2.4.26, SOGo 1.3.8b best regards Darko -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Bug Compiling with LDAP Support fails
Hi there, I've tryed to compile SOGo with the latest stable and with the two beta. My OS is FreeBSD 8 stable, PostgreSQL 9.1, OpenLDAP 2.4.26 for bindings and as Client, GnuSTEP 1.19.3. As Mailsystem I'm using Postfix and DBmail 3 RC3 over a PostgreSQL Database with Apache DS as LDAP Server. Mails are stored in a large PostgreSQL Database and users comes from an LDAP tree I could successful compile SOPE 1.3.8b and 2.0 BETA without any Error Without suport for LDAP I could compile SOGo 1.3.8b and 2.0.0b1 without any Error. Only SOPE warns me about that it couldn't find mysqlclient. But thats OK. nothing about MySQL is installed here and needed. But if I try it with LDAP my build breaks [root@web /var/sogo/SOGo]# ./configure --enable-ldap-config GNUstep environment: system: /usr/local/GNUstep/System local: /usr/local/GNUstep/Local user: /root/GNUstep path: /usr/local/GNUstep/System:/usr/local/GNUstep/Network:/usr/local/GNUstep/Local:/root/GNUstep flat: yes arch: amd64-portbld-freebsd8.2 combo: gnu-gnu-gnu Note: will install in GNUSTEP_LOCAL_ROOT: /usr/local/GNUstep/Local Configuration: debug: yes strip: no ldap-based configuration: yes prefix: /usr/local/GNUstep/Local gstep: /usr/local/GNUstep/System/Library/Makefiles config: /var/sogo/SOGo/config.make script: /usr/local/GNUstep/System/Library/Makefiles/GNUstep.sh creating: /var/sogo/SOGo/config.make [root@web /var/sogo/SOGo]# [root@web /var/sogo/SOGo]# gmake This is gnustep-make 2.6.1. Type 'gmake print-gnustep-make-help' for help. Making all in SOPE/NGCards ... Making all for library libNGCards... Compiling file NSArray+NGCards.m ... Compiling file NSCalendarDate+NGCards.m ... Compiling file NSDictionary+NGCards.m ... Compiling file NSString+NGCards.m ... Compiling file NSCalendarDate+ICal.m ... NSCalendarDate+ICal.m:22:2: warning: #warning this module should be cleaned up and merged with NSCalendarDate+NGCards Compiling file CardElement.m ... CardElement.m:607:2: warning: #warning this method really is the same as copyWithZone: Compiling file CardGroup.m ... Compiling file CardVersitRenderer.m ... Compiling file iCalXMLRenderer.m ... Compiling file iCalAlarm.m ... Compiling file iCalAttachment.m ... Compiling file iCalByDayMask.m ... Compiling file iCalCalendar.m ... iCalCalendar.m:192:2: warning: #warning should we return timezones too? Compiling file iCalDailyRecurrenceCalculator.m ... Compiling file iCalDateTime.m ... Compiling file iCalDataSource.m ... Compiling file iCalEntityObject.m ... Compiling file iCalEvent.m ... Compiling file iCalEventChanges.m ... Compiling file iCalFreeBusy.m ... Compiling file iCalJournal.m ... Compiling file iCalMonthlyRecurrenceCalculator.m ... Compiling file iCalObject.m ... Compiling file iCalPerson.m ... Compiling file iCalRecurrenceRule.m ... iCalRecurrenceRule.m:380:2: warning: #warning handling of default timezone needs to be implemented iCalRecurrenceRule.m:424:2: warning: #warning we also should handle the user weekstarts Compiling file iCalRecurrenceCalculator.m ... Compiling file iCalRepeatableEntityObject.m ... Compiling file iCalTimeZone.m ... iCalTimeZone.m:334:2: warning: #warning this is a dirty hack due to the fact that the date is first passed as UTC Compiling file iCalTimeZonePeriod.m ... Compiling file iCalToDo.m ... Compiling file iCalTrigger.m ... Compiling file iCalUTCOffset.m ... Compiling file iCalWeeklyRecurrenceCalculator.m ... Compiling file iCalYearlyRecurrenceCalculator.m ... Compiling file NGVCard.m ... Compiling file NGVList.m ... Compiling file NGVCardPhoto.m ... Compiling file NGVCardReference.m ... Compiling file NGCardsSaxHandler.m ... Linking library libNGCards ... Making all in versitCardsSaxDriver ... Making all for bundle versitCardsSaxDriver... Creating versitCardsSaxDriver.sax/ Compiling file VSSaxDriver.m ... Compiling file VSCardSaxDriver.m ... Linking bundle versitCardsSaxDriver ... Creating versitCardsSaxDriver.sax/Resources... Copying resources into the bundle wrapper... Creating stamp file... Creating versitCardsSaxDriver.sax/Resources/Info-gnustep.plist... Making all in SOPE/GDLContentStore ... Making all for library libGDLContentStore... Compiling file NSURL+GCS.m ... Compiling file EOAdaptorChannel+GCS.m ... Compiling file EOQualifier+GCS.m ... Compiling file GCSAlarmsFolder.m ... GCSAlarmsFolder.m:49:2: warning: #warning GCSAlarmsFolder should share a common ancestor with GCSFolder Compiling file GCSContext.m ... Compiling file GCSFieldInfo.m ... Compiling file GCSFolder.m ... GCSFolder.m:459:8: warning: #warning this may be dangerous... GCSFolder.m: In function '-[GCSFolder _quickTableEntity]': GCSFolder.m:752: warning: unused variable 'field' Compiling file GCSFolderManager.m ... Compiling file GCSFolderType.m ... Compiling file GCSChannelManager.m ... Compiling file GCSFieldExtractor.m ... Compiling file GCSSessionsFolder.m ... GCSSessionsFolder.m:49:2:
Re: [SOGo] Sugestion about a LDAP Webfrontend
Am 01.08.2011, 02:52 Uhr, schrieb Jason Wohlford ja...@wohlfordcompany.com: On Jul 31, 2011, at 6:32 PM, Darko Hojnik wrote: I'm currently working since one year with the combo SOGo, Postfix, DBmail, PostgreSQL and OpenLDAP. DBmail stores all mails in a PostgreSQL database and SOGo uses for itself another one. All users are stored inside a LDAP three. So I've the same users for SOGo, DBmail and Postfix inside LDAP. For less 100 users I've handled it with Apache Directory Studio. But in the future there will comes more users. Also users has asked me about a webfrontend to configure domains, users, aliases and such stuff. So I'm searching something like a web based solution. Anyone here who could suggest me something like this what is already present and OpenSource licensed? I've found the combination of Webmin/Virtualmin to be fantastic. What I like most about Webmin compared to other control panels, is that it actually comprehends config files. One can make an edit directly with the config file or through Webmin and nothing is messed up. Other control panels such as cpanel and plesk force you to only do edits through their control panels. Webmin/Virtualmin can handle users and groups in OpenLDAP. From there you should be good to go. This is how I manage my clients. Best Regards, Jason Hello Jason Thanks for your respond! I've taken a look on it. But it breaks our security policy. It's not a real secure solution because everybody could get your server between some seconds. In a intranet maybe OK. Bot not on a larger box directly connected to the internet. I'm looking for another again cheers Darko -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Sugestion about a LDAP Webfrontend
Am 01.08.2011, 07:41 Uhr, schrieb Martin (Lists) li...@fahrendorf.de: Am 01.08.2011 01:32, schrieb Darko Hojnik: Hi there I'm currently working since one year with the combo SOGo, Postfix, DBmail, PostgreSQL and OpenLDAP. DBmail stores all mails in a PostgreSQL database and SOGo uses for itself another one. All users are stored inside a LDAP three. So I've the same users for SOGo, DBmail and Postfix inside LDAP. For less 100 users I've handled it with Apache Directory Studio. But in the future there will comes more users. Also users has asked me about a webfrontend to configure domains, users, aliases and such stuff. So I'm searching something like a web based solution. Anyone here who could suggest me something like this what is already present and OpenSource licensed? I use GOsa for this. It is a fine web base ldap administration stuff with mail storage config (so for cyrus only afaik) and is able to handle samba, dns, ... Martin best regards Darko Hello Martin I've taken a look on it. But how do you handle ACL about domains? For example they are two company's called foo and bar with the domains foo.tld and bar.tld. The manager of company foo is allowed to creates mailadresses with @foo.tld but it should disallowed for him to create an address with @bar.tld. I didn't found a setting to adjust a proper ACL about this. cheers Darko -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Sugestion about a LDAP Webfrontend
Hi there I'm currently working since one year with the combo SOGo, Postfix, DBmail, PostgreSQL and OpenLDAP. DBmail stores all mails in a PostgreSQL database and SOGo uses for itself another one. All users are stored inside a LDAP three. So I've the same users for SOGo, DBmail and Postfix inside LDAP. For less 100 users I've handled it with Apache Directory Studio. But in the future there will comes more users. Also users has asked me about a webfrontend to configure domains, users, aliases and such stuff. So I'm searching something like a web based solution. Anyone here who could suggest me something like this what is already present and OpenSource licensed? best regards Darko -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo on Debian/ARM + Funambol
Hello Dominique, At first you could take the OpenJDK only. You should try compile Funambol with the OpenJDK and maybe you have to change something on the sources. On PPC you could get IBM Java only. You could compile Funambol with the OpenJDK on any platform. I do the same with my Javastuff to get it proper running with the OpenJDK. best regards Darko Hojnik Am 06.06.2011, 17:55 Uhr, schrieb Dominique dco...@hotmail.com: Hi, Since the bug thread is closed - with the issue resolved, I'll answer 'wsourdeau' here. I am running Debian Squeeze on a reformated QNAP TS 109 (Orion ARM) with 128 MB of memory. SOGo is configured with MySQL and since I'm running it for a small number of user it should do fine. A nice .deb package with a full install would be nice for future upgrades - and future users. Now the challenge is to setup Funambol to get the full service. So if anyone has experience in installing with success Funambol on such a small CPU, I'm willing to listen. So far, I have problems with installing Sun JAVA. Dominique -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Authenticate against a non SOGo database
Am 06.04.2011, 23:58 Uhr, schrieb Mark Adams m...@campbell-lange.net:
On 6 Apr 2011, at 20:02, Darko Hojnik hoj...@virtualizing.org wrote:
Hi there,
Currently we are using Postfix and DBmail with an LDAP backend. SOGo
uses this LDAP backend too. In the future we maybe want migrate to
Apache James as the solution for the mailserver. And if we do it, then
we want do it without a LDAP Server.
So I've got an testinstallation with Apache James 3 Milsestone3
compiled SVN using a PostgreSQL 9 Database. SOGo should be installed
soon on the next days. We want that SOGo will authenticate against the
Database from James
The Database,
james= \dt
Liste der Relationen
Schema | Name | Typ | Eigentümer
+--+-+
public | james_domain | Tabelle | james
public | james_mail | Tabelle | james
public | james_mail_header| Tabelle | james
public | james_mail_property | Tabelle | james
public | james_mailbox| Tabelle | james
public | james_mailbox_membership | Tabelle | james
public | james_subscription | Tabelle | james
public | james_user | Tabelle | james
public | james_virtual_user_table | Tabelle | james
public | openjpa_sequence_table | Tabelle | james
(10 Zeilen)
Select of the table james_user,
james= SELECT column_name FROM information_schema.columns WHERE
table_name = 'james_user';
column_name
-
user_name
password_hash_algorithm
password
version
(4 Zeilen)
james=
Now I'm asking me is that the correct Syntax for SOGoUserSources to
authenticate against the database from Apache James?
SOGoUserSources =
(
{
type = sql;
id = directory;
viewURL = postgresql://james:james@192.168.0.60:5432/james/james_user;
canAuthenticate = YES;
isAddressBook = NO;
userPasswordAlgorithm = md5;
}
);
thanks for help and suggestions
You have to pass the fields from the db to sogo specifically, as
detailed in the documentation (for example name should be c_name). You
can achieve this with a view in your db that sogo can call.
best regards
Darko Hojnik
--
users@sogo.nu
https://inverse.ca/sogo/lists
Hello Mark,
After I've taken a look in the manual again, I'm a little bit confused
because I didn't understand it.So I'm not shore how I have to write it
correct. It's possible to write me an example for viewURL and c_name?
kind regards
Darko Hojnik
--
users@sogo.nu
https://inverse.ca/sogo/lists
